Our Blog, Filemaker only, Xojo only, Archive (older), Follow us on Twitter or Facebook.

FileMaker Developer Conference 2017

Friday 22 July 2016 at 04:16 am
And the next conference will be in Phoenix, Arizona:

Join us from 24th to 26th July 2017 in Phoenix, Arizona and learn more about FileMaker 16.

Tip of the day: AppleScript with Properties to pass file path

Thursday 21 July 2016 at 11:57 pm
Today we discussed on how to best get the file path into an AppleScript. We'd like to pass it as POSIX path and no the old Mac path format. And we prefer to use properties to pass values into the script. The advantage is that we can compile once and run several times with different values. Finally putting values in properties avoids any escaping problems when putting a text into a script directly. So here is the final code:

// we have some FolderItem dim f as FolderItem = SpecialFolder.Desktop.Child("test.key") // and build a script dim lines() as string // here we declare a property for the script: lines.Append "property filePath : """"" // and convert path from posix file path to AppleScript path lines.Append "tell application ""Finder""" lines.Append " set f to filePath as POSIX file" lines.Append "end tell" // and use path for Keynote lines.Append "tell application ""Keynote""" lines.Append " activate" lines.Append " set mydoc to open file f" lines.Append "end tell" // compile the script dim s as String = Join(lines, EndOfLine.Macintosh) dim a as new AppleScriptMBS a.Compile s if a.Lasterror <> 0 then MsgBox str(a.Lasterror)+" "+a.Error.BriefMessage end if // fill the property a.ScriptPropertyValue("filePath") = f.NativePath // run it a.Execute if a.Lasterror <> 0 then MsgBox str(a.Lasterror)+" "+a.Error.BriefMessage end if

Monkeybread Software presents MBS FileMaker Plugin at FileMaker Developer Conference 2016

Thursday 21 July 2016 at 3:36 pm
LAS VEGAS, July 18, 2016 - Monkeybread Software exhibits at the FileMaker Developer Conference 2016 in Las Vegas. We invite everyone at the conference to visit our booth and learn about our latest MBS FileMaker Plugin.

Version 6.3 include over 4,000 documented functions to extend FileMaker Pro, Runtime and Server, including Web Direct. The plug-in adds new possibilities for you to deliver great new features for your clients in your solutions. Try our plug-in and see with over 400 example databases what you can do in FileMaker with our toolbox. Over the last ten years the plug-in grew to an unique toolbox for FileMaker developers all over the world and helped to provide solutions to thousands of users.

In our presentation, scheduled for Thursday at 10:45 am, we provide an overview of our plugin's functionality. We also demonstrate new features coming in the next release soon after the conference. Bring your questions and let us go deep into scripts to show you how things are done using our plug-in.

Learn more about using SQL with FileMaker, hotkeys, schedules, graphics, networking, menus and other outstanding features. Finally enjoy our syntax highlighting and more development goodies.

Our booth is located on the left side from the main entrance of the exhibit hall and open on all conference days in the breaks.

Atl Xojo Users Group - Mon, Jul 25th, 2016

Wednesday 20 July 2016 at 11:04 pm
Kevin Cully sent the invitation for the next meeting in Atlanta:

Hello Xojo enthusiasts!

Please join us for this Xojo monthly meeting! We promise that you'll learn something new at each meeting!

Who: Everyone interested in developing in Xojo!
What: Monthly Meeting
Where: Las Palmas Mexican Restaurant, 2210 Holly Springs Pkwy, Holly Springs, GA
When: Monday, July 25th, 2015 - 6pm to 9pm
Monkey Bread Software is one of the most prolific creators of plugins for Xojo. Literally hundreds of useful plugins that help you look and work like a pro. Christian Schmitz is coming all the way from Germany to talk all things Xojo, plugins and productivity. We hope that you can join us this next Monday.

We've also got the latest Xojo news, reviews and announcements.

See you there!

MBS FileMaker Plugin, version 6.4pr1

Wednesday 20 July 2016 at 02:45 am
New in this prerelease of the 6.4 plugins:
  • Updated to DynaPDF
  • Added DynaPDF.GetColorSpaceInfo to query details on a color space.
  • Added DynaPDF.ListImages function to list images in a PDF file.
  • Fixed a problem with some XML with XML.Import where no fields where imported.
  • Added DynaPDF.OpenOutputFileEncrypted.
  • Plugin works again fine on Windows XP with FileMaker 10.
  • Changed ServerSocket functions to provide service via IPv6 and IPv4. That solves the problem when ServerSocket in 6.3 tried to connect via IPv6 to a IPv4 socket.
  • Added DynaPDF.GetBBox function.
  • Added Math.DecodeNumber and Math.EncodeNumber.
  • Added transparent as a possible color value for GraphicsMagick.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

MBS Xojo / Real Studio Plugins, version 16.4pr1

Wednesday 20 July 2016 at 01:41 am
New in this prerelease of the 16.4 plugins:
  • Added Raspberry Pi cameras classes.
  • Updated to DynaPDF
  • Fixed a bug for Japanese with Set Variable checking.
  • Improved DynaPDFOptimizeParamsMBS class for newer DynaPDF version.
  • Changed CIImageMBS.RenderPicture methods. If extend of image is infinite, we use the width and height you provide.
  • Fixed bug with ICDeviceBrowserMBS destructor.
  • Added GetStringsFromDataMBS function.
  • Fixed some issues with new Contacts classes.
  • Added new constructors for WindowsListMBS class to list child windows.
Download: macsw.de/plugin/Prerelease. Or ask us to be added to our shared Dropbox folder.

Visit MBS at FileMaker DevCon

Monday 18 July 2016 at 10:23 pm
Arrived in Las Vegas and he booth is ready for you to visit:

DynaPDF Optimize Command

Sunday 17 July 2016 at 10:54 am
With the next prerelease of our FileMaker, Xojo and Real Studio plugins we will include DynaPDF and the Optimize command has two big changes: First, it now can now scale down images and reduce the size of PDF files significantly. Second, the license changes and the Optimize command is now included in the Pro license.

For optimize you can specify a few parameters. For each image in the PDF, DynaPDF will check the display resolution of the image. That is not the resolution stored in some metadata with the image, but the actual size the image will be displayed. You can specify the minimum resolution for images to be checked independently for Color, grayscale and 1 bit images. Next you define the resolution you want as maximum for the output images. For example you want to scale down all images with more than 100 dpi and reduce them to maximum 150 dpi. For the filter parameter you can specify the compression you want, e.g. JPEG. Converting images from Flate compression to JPEG with same or lower resolution will of course reduce the file size.

When optimizing PDFs, we can remove private data, invisible paths and create new link names. This further reduces size down and rebuilds the structure of the PDF. While doing the optimize we fix problems in PDF files automatically. Some PDFs which showed error messages when opening in Adobe Reader now open without errors.

Here an example:

The test PDF optimize-before.pdf is created with FileMaker 15 from the product catalog example with a few pictures. Than printed to PDF in FileMaker. Of course you can use whatever test PDFs you like for your own tests. Now we run through and let DynaPDF limit image resolution to 150 dpi. The new PDF optimize-after.pdf is much smaller. From 686 KB down to 89 KB (87% saved).

See yourself:
before vs. after

or when we scale them up at 200%:
before vs. after

We can extract the images and see that FileMaker placed a 816x612 Pixel big JPEG file (optimize-image-before.jpg) there. DynaPDF replaced that with a 206x154 Pixel big (optimize-image-after.jpg). I don't think you see the difference at the target size in the PDF. And 150 dpi is quite good for reading on screen and sending via email. FileMaker probably uses 600 dpi here to make sure it looks good when printing.

If you join FileMaker DevCon in Las Vegas, please visit our booth to try compression on your test PDFs!

Use Raspberry Pi Camera in Xojo

Thursday 14 July 2016 at 3:23 pm
As you may know I have a Raspberry Pi and play with it from time to time. One of my hobby projects got to a state where I can show it to you:

For upcoming 16.4 MBS Xojo plugins, we now have a few classes to work with the camera on a Raspberry Pi. You can query available formats, select one and take pictures. We support both picture objects and directly capturing JPEG data. This way you can request image in right size and compressed and your application doesn't need to do this.
If you like to try, please email me soon.

Tip of day: Gradients with CoreImage Filter

Wednesday 13 July 2016 at 7:31 pm
With CoreImage you can easily get nice gradients:
// create gradient filter dim CiGradiantFilter as new CIFilterLinearGradientMBS // set input vector and colors CiGradiantFilter.inputPoint0 = CIVectorMBS.vectorWithXY(800,600) CiGradiantFilter.inputPoint1 = CIVectorMBS.vectorWithXY(0,0) CiGradiantFilter.inputColor0 = CIColorMBS.colorWithRGB(1,1,1) CiGradiantFilter.inputColor1 = CIColorMBS.colorWithRGB(1,0.5,0.3) // get output picture dim r as CIImageMBS = CiGradiantFilter.outputImage // render bitmap Backdrop = r.RenderPicture(800, 600)
With MBS Plugin we provide you over 100 CoreImage classes including CIFilterLinearGradientMBS, CIFilterGaussianGradientMBS, CIFilterRadialGradientMBS and CIFilterSmoothLinearGradientMBS.

Loaded Plugins in Xojo

Wednesday 13 July 2016 at 2:17 pm
Did you see the recent addition to the about dialog in Xojo 2016r2?

Now you can see which plugins are loaded. Thanks Xojo Inc.

Three month till German FileMaker Conference in Salzburg, Austria

Wednesday 13 July 2016 at 11:51 am
Nur noch drei Monate bis zur FileMaker Konferenz und zur MBS Plugin Schulung in Salzburg:

Vom 13. bis 15. Oktober 2016 treffen sich wieder ca. 200 Teilnehmer im Pitter in Salzburg.
Bitte bald anmelden um ein Ticket zu bekommen. Die Konferenztickets und die Zimmer im Hotel Crowne Plaza Salzburg waren in den vorherigen Jahren schon Wochen vor der Konferenz ausverkauft.

Dieses Jahr gibt es neben meinem MBS Vortrag auch einen zum iOS SDK. Mal sehen, was bis zur Konferenz noch alles kommt von FileMaker. iOS Extension könnte ein Thema sein.

MBS Plugin Schulung
Am Tag vor der Konferenz (12. Oktober) findet der MBS Plugin Workshop statt. Einen Tag mal Intensiv das MBS Plugin anschauen, durch die Beispiele gehen, einen Webservice implementieren und Funktionen ausprobieren. Limitierte Anzahl von Plätzen und gleiches Hotel wie Konferenz, also bald anmelden.
(Noch wenige Restplätze verfügbar.)

Xojo 2016 Release 2 Now Available

Tuesday 12 July 2016 at 1:42 pm
A new release of Xojo is now available for download! The latest release adds significant new features for iOS and web, along with 150 improvements overall. In addition, this release continues with HiDPI (Retina) support by adding HiDPI for web apps and dramatic improvements for Windows HiDPI.

Xojo for iOS now has significantly improved support for tables, available in the following new capabilities:
  • Row scrolling
  • Row actions
  • Row editing
  • Row re-ordering
  • Custom cells
New iOS controls and features include:
  • Location services
  • Motion data from the accelerometer and gyroscope
  • The PicturePicker control to select pictures from the camera roll, photo library or to let the user take a new picture
  • A Scrollable Area that allows for UI layouts that are larger than the size of a view, making it easy for the user to scroll through all the fields and controls
  • A SharingPane control to allow your apps to share text, URLs and pictures to other registered apps
Xojo 2016 Release 2 also makes it easier to create toolbars with an all-new visual toolbar editor and simplifies app deployment by removing the need for launch images.

Read the complete list of improvements in the release notes. Is your license expired?

PS: Please update MBS Plugin to 16.3 before using Xojo 2016r2 and run into fixed issues.

MBS FileMaker Plugin 6.3 for OS X/Windows

Tuesday 12 July 2016 at 11:58 am
Nickenich, Germany - (July 12th, 2016) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 6.3 for Mac OS X or Windows, the latest update to their product that is easily the most powerful plugin currently available for FileMaker Pro. As the leading database management solution for Windows, Mac, and the web, the FileMaker Pro Integrated Development Environment supports a plugin architecture that can easily extend the feature set of the application. MBS FileMaker Plugin 6.3 has been updated and now includes over 4000 different functions, and the versatile plugin has gained more new functions:

With the new version we add SSH functions. They allow you to connect to a remote server with Secure Shell protocol. You can authenticate via password or your private key. Than you can execute shell commands, provide input and receive output text. Our existing CURL functions provide SFTP file uploads and downloads using the same SSH connection parameters.

As the speak command in FileMaker is limited, we added a new Text.Speak command. Our speak command has less problems and also works on Windows. You can choose the voice and decide whether to wait for speech to finish.

For accessing smartcard readers, we got a set of new functions. You can list the readers, detect cards and transmit data to them. This is very low level and requires knowledge about the protocols used with your smart card.

Our menu creation is now much quicker due to optimized internal storage of menu items. The DefineQuickMenu function is now much quicker. And you can decide whether a menu item is selectable. This way you can prevent people from selecting a menuitem with a submenu attached.

We updated DynaPDF to version Our new functions DynaPDF.AppendImagePage and DynaPDF.AppendImagePages allow to easily add new pages for existing images, either from a container or a list of file paths. Our function to show difference between two pages can now be parameterized with a specific color tolerance.

For Webviewers on Mac you can now provide login credentials. When the website asks for a password, the plugin will supply it for you. This way you can visit websites without FileMaker showing a password dialog.

Our plugin can now create symbolic and hard links. When working with Word files, you can now replace images. For automated debugging you can now query the content of the data viewer window and store it in a log.

Finally we improved barcode reading, we accept now multiple file paths for Files.Delete and Files.RevealFile. GraphicsMagick handles resolutions better and allows querying/setting XMP data. PortMidi can now provide unicode device names.

See release notes for a complete list of changes.

MBS Xojo / Real Studio plug-ins in version 16.3

Tuesday 12 July 2016 at 11:13 am
NICKENICH, Germany (July 12h, 2016) -- Monkeybread Software releases version 16.3 of the MBS plug-in for Xojo and Real Studio.

The MBS plug-in comprises a collection of several plug-in parts which extend the Xojo (Real Studio) development environment with 2,300 classes featuring over 59,000 documented functions. Our plugins support all three platforms Mac OS X, Windows and Linux with all project types desktop, web and console including 64-bit and ARM targets.

Some of the highlights on the 16.3 update:

Our latest plugins have been updated for Xojo 2016r2. Due to a few little changes in the new Xojo version we had to modify the plugins. Older plugins may not work properly.

For 64-bit applications we added a new Contacts plugin part with a couple of new classes. For new 64-bit applications you may prefer the new classes instead of the older Addressbook classes.

For accessing smartcard readers, we got a set of new functions in our new SmartCard plugin. You can list the readers, detect cards and transmit data to them. This is very low level and requires knowledge about the protocols used with your smart card.

For DynaPDF we improved the difference feature to compare two pages. You can now specify the color tolerance. We added a new optimize parameter class for our optimize command.

Our SQL Plugin got new methods to execute prepared statements multithreaded. That allows you to use them in a Xojo thread and have the work run on a preemptive thread on another CPU core.

For editing word files we now have methods to replace images. PortMidi can now handle unicode device names and initialize on demand.

Finally we updated DynaPDF to version and LibArchive to version 3.2.1.

See release notes for a complete list of changes.

FileMaker Magazin - MBS Artikel

Monday 11 July 2016 at 2:43 pm

For our Germans speaking users:

Wir haben die Artikel zum MBS Plugin aus dem FileMaker Magazin gesammelt hier online gestellt: FileMaker Magazin Artikel:

Wir empfehlen allen FileMaker Anwender ein Abo vom Magazin und den Kauf der alten Ausgaben. Das FileMaker Magazin ist eine excellente Quelle von Informationen, Anleitungen und Profitips.

Alternativer Wolf- und Bärenpark Schwarzwald

Sunday 10 July 2016 at 9:09 pm
This week I had the chance to visit the Alternativer Wolf- und Bärenpark Schwarzwald. This is a project to protect wolves and bears here in Germany and they provides a home to eight bears and three wolves. Those bears are freed/rescued from circus and other places where they had a bad live with punishment. Now they can enjoy the rest of their lives in a natural environment there in the black forest. And visits can go and see them.
As those animals are used to humans they can't survive alone in nature.

My visit there was due to the FileMaker training organized by MKV. I gave a short presentation about the MBS FileMaker Plugin and had some time to talk with the trainees.

If you have a chance, please visit the two parks in Worbis and Bad Rippoldsau.

MBS Xojo / Real Studio Plugins, version 16.3pr6

Saturday 09 July 2016 at 1:07 pm
New in this prerelease of the 16.3 plugins:
  • Added WordFileMBS.MediaFile and WordFileMBS.MediaFiles.
  • Added Contacts classes for our Mac 64bit plugin.
  • Fixed bug in DynaPDFMBS.ShowDifference introduced in pr4.
  • Fixed a bug with CFDictionary creation when Xojo reports wrong variant type in 64-bit.
Download: macsw.de/plugin/Prerelease. Or ask us to be added to our shared Dropbox folder.

MBS FileMaker Plugin, version 6.3pr6

Saturday 09 July 2016 at 11:22 am
New in this prerelease of the 6.3 plugins:
  • Added SQL.FreeAllConnections.
  • Added WordFile.GetMediaFile, WordFile.MediaFiles and WordFile.SetMediaFile functions.
  • Fixed bug in DynaPDF.ShowDifference introduced in pr4.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

New FileMaker London User Group

Thursday 07 July 2016 at 11:37 am
I got notice that a FileMaker developer group is meeting in London area:

The FileMaker London User Group is aimed at intermediate level FileMaker developers. Run by Nick Stockbridge of FileMaker Authorised Training Company Transmedia Training, our meetings are self-help sessions, with members offering tips and advice to others. Meetings will generally consist of a demonstration of a useful idea or technique, followed by a Q and A on a work in progress with which a member is getting stuck. So bring in your tricky calculations and scripts and start receiving (and giving) some help!

Dates: Generally the first Monday in the month, every other month.
Time: 6.30pm to 8.30pm.
Location: Transmedia Training, 85 Tottenham Court Road, London W1T 4TQ

Forthcoming dates:

8 August 2016
3 October 2016
12 December 2016
6 February 2017
3 April 2017

Sessions are free. Coffee, tea and refreshments are provided. For more information, please call Nick Stockbridge on 0208-269 4260, or email nick@transmedia.co.uk.

see also thread on FileMaker community.

When I have my next client visit to London, I may be able to schedule my trip to be there for a meeting.
Else you can meet me at DevCon in two weeks :-)

Older blog entries:

2016-07-06 XDC in 3 months
2016-07-05 National BKeeney...er...Bikini Day
2016-07-05 xDev Magazine Issue 14.4
2016-07-05 Tip of the day: Mount drive on FileMaker Server
2016-07-05 MBS Xojo / Real Studio Plugins, version 16.3pr5
2016-07-04 MBS FileMaker Plugin, version 6.3pr5
2016-07-02 SQLite 3.13 with ICU
2016-07-02 FileMaker DevCon 2016
2016-06-28 Xojo Meeting in Atlanta
2016-06-25 Xojo Stammtisch in Hanau
2016-06-25 MBS Xojo / Real Studio Plugins, version 16.3pr4
2016-06-24 MBS FileMaker Plugin, version 6.3pr4
2016-06-22 Survey about European MBS Xojo Conferences 2017
2016-06-22 MBS FileMaker iOS SDK Extension 0.2
2016-06-21 XDC sessions
2016-06-20 DynaPDF Invoice example
2016-06-19 MBS Xojo / Real Studio Plugins, version 16.3pr3
2016-06-19 MBS FileMaker Plugin, version 6.3pr3
2016-06-18 Faster String handling
2016-06-17 Tip of the day: Show debugger in FileMaker from within a script


Jul 2016
Jun 2016
May 2016
Apr 2016
Mar 2016
Feb 2016
Jan 2016
Dec 2015
Nov 2015
Oct 2015
Sep 2015
Aug 2015
Jul 2015
Jun 2015
May 2015
Apr 2015
Mar 2015
Feb 2015
Jan 2015
Dec 2014
Nov 2014
Oct 2014
Sep 2014
Aug 2014
Jul 2014
Jun 2014
May 2014
Apr 2014
Mar 2014
Feb 2014
Jan 2014
Dec 2013
Nov 2013
Oct 2013
Sep 2013
Aug 2013
Jul 2013
Jun 2013
May 2013
Apr 2013
Mar 2013
Feb 2013
Jan 2013
Dec 2012
Nov 2012
Oct 2012
Sep 2012
Aug 2012
Jul 2012
Jun 2012
May 2012
Apr 2012
Mar 2012
Feb 2012
Jan 2012
Dec 2011
Nov 2011
Oct 2011
Sep 2011
Aug 2011
Jul 2011
Jun 2011
May 2011
Apr 2011
Mar 2011
Feb 2011
Jan 2011
Dec 2010
Nov 2010
Oct 2010
Sep 2010
Aug 2010
Jul 2010
Jun 2010
May 2010
Apr 2010
Mar 2010
Feb 2010
Jan 2010
Dec 2009
Nov 2009
Oct 2009
Sep 2009
Aug 2009
Jul 2009
Apr 2009
Mar 2009
Feb 2009
Dec 2008
Nov 2008
Oct 2008
Aug 2008
May 2008
Apr 2008
Mar 2008
Feb 2008
XML: RSS Feed XML: Atom Feed