MBS Xojo Conference
6/7th September 2018, Munich
Our Blog, Filemaker only, Xojo only, Archive (older)

Follow us on Twitter, Xing, LinkedIn or Facebook.

Xojo 2018r1.1 available

Xojo Inc. released Xojo in version 2018r1.1 today.
This is a bugfix release with 19 bug fixes.

You can read the details here: Xojo 2018r1.1 Release notes

We recommend you to install the update soon. It fixes the breakpoint problem in 32-bit applications as well as a few other debugger issues we saw. Also fixed are crashes related to undo :-)

You can download the update here: Xojo Download

And now we look forward what comes for 2018r2.
We hope to learn about the Xojo 2018r2 release and a lookout for version 2018r3 in the Xojo keynote at the MBS Xojo Conference.

MBS FileMaker Plugin, version 8.2pr9

New in this prerelease of version 8.2 of the MBS FileMaker Plugin:
  • Fixed crash with Barcode.Detect with out of bounds access in image for bad QRCodes.
  • Changed Barcode.Detect to report the version number read when complaining about invalid version in QRCode.
  • Updated code signing script for FileMaker 17 runtimes.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

MBS Xojo Plugins, version 18.2pr9

New in this prerelease of the 18.2 plugins:
  • Fixed crash with zxingQRCodeReaderMBS with out of bounds access in image for bad QRCodes.
  • Changed zxingQRCodeReaderMBS to report the version number read when complaining about invalid version in QRCode.
  • Fixed OpenDialogMBS for Cocoa target to handle better file extensions when several are separated by semicolon.
Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

Code Signing FileMaker 17 Runtimes

This week I prepared a new code singing script for runtimes made with FileMaker 17.

A few things changed in the runtimes with a new Cloud framework, addition of the swift libraries and removal of OmniORB4 framework.

If you distribute your runtimes, you need to sign the app and the disk image for Gate Keeper. If your runtime is not signed, the Finder will ask the user when launching the application after download to delete the app! Or you may get a message that the database is not found. To avoid users get confused or not use the runtime, we sign the runtime.


Signing the runtime got harder with new requirements in Mac OS X 10.9 and the upcoming Yosemite release. We not just need to sign the actual application, but also make sure we sign all the components. For the frameworks inside the runtime, we need to fix them to give them a few standard symlinks which are missing. Without those modifications, the bundle will not sign. If you like to save a few bytes, you can delete the icon files: FM12Dict.icns, FM12Label.icns and FM12Plug.icns inside the runtime. Those are not referenced and never used.

Developer Account

In order to sign, you need to sign up for a Mac Developer Account with Apple. This costs $99 USD per year. In the Certificates, Identifiers & Profiles section, please go in Mac Apps section and there in Certificates. Create a new Developer ID certificate, follow the instructions and download the certificate file. Double click it to add it to Keychain Manager and voila, it is installed and ready to use.

Sign Script

When you edit the script in a text editor (like BBEdit or TextWranger), you can change the path to the runtime, the name of the app and the name of the certificate. Please note that this script will not work without correct values. If your file name or path contain special character, escaping may be needed. For example a space character needs to be escaped with putting a backslash character just before the space character. You can learn how to escape a path by dragging and dropping the file or folder into the window of the Terminal application. The path is inserted and you can copy & paste it.

Now when everything is setup for your runtime in the script, you can drop the script on a Terminal window and press return key to start it. You'll see a couple of messages. This may include some complains from rm command trying to delete files which are not there. Nothing to worry about, the script just makes sure everything is correct. Further you see a couple of sign message for various parts of the application. The final line should show "signed bundle with Mach-O thin" and report success for signing your runtime app.


To check if app is okay for Gate Keeper you can first verify code signature using a call to codesign with a couple of v for more details and -d to display certificate:

codesign -d -vvvv /Users/cs/Desktop/Test/test.app

Next with spctl utility you can show if app is accepted. So we run spctl utility with verbose messages and -a parameter:

spctl -a -vv /Users/cs/Desktop/Test/test.app

Please change path to your runtimes before running above commands. The output should say "accepted" and now you are lucky and can archive and upload your runtime. Good luck!
Now you can build disk image and sign it.

New script will be included with MBS Plugin.

Two weeks left for early bird tickets for MBS Xojo Conference in Munich

Just about two weeks left for early bird tickets for our European MBS Xojo Conference 2018 in Munich. If you like to join, please sign up soon.

Already developers from nine countries are signed up including Xojo CEO Geoff Perlman and Xojo Evangelist Paul Lefebvre. The schedule is mostly done with only a few sessions still pending. Reserve your ticket and reserve your hotel room as soon as possible.

Our Hotel room contingent expires later this month, so please make sure you have a room booked.

The schedule:

Sep 4thDayoptional sight seeing tour
Sep 4thEveningoptional get-together with everyone arriving early
Sep 5thDayoptional Xojo training (English)
Sep 5thEveningoptional get-together with everyone arriving early
Sep 6th9:00 to 18:00First day of conference with keynotes
EveningDinner event in Augustiner Keller
Sep 7th9:00 to 18:00Second day of conference with more sessions
EveningOptional dinner together
Sep 8thDayoptional Xojo training (Deutsch/German)
Sep 8thEveningoptional dinner together

We all look forward to presentations about Android, the new Web Framework other news in the Xojo keynote.

Registration is open. The late bird offer available till 7th June is just 599 Euro plus VAT if needed. Attending the conference costs regularly 699 Euro plus VAT, including food and beverage in the Maritim Hotel as well as an accompanying social program.

Sessions are to be held in English. Our conference is conceived as a networking event for the Xojo community. The conference is an ideal opportunity for sharing your thoughts and your own development experience with fellow users and developers. If you like to hold a presentation, please contact us as soon as possible.

Run FileMaker in different language on your Mac

Sometimes we need to make screenshots or present with FileMaker in other languages and you can have at least eleven languages:

(you know all the languages for the menubars?)

I made a couple of little AppleScript apps to launch FileMaker 14/15/16/17 in another language. So I can double click the French one and another instance of FileMaker Pro launches on my Mac with French localization. Please try and let me know what you think about it.

Download: LaunchFileMakerInDifferentLanguages.dmg
Now updated for FileMaker 17.

FileMaker 17 Event in der Schweiz und MBS Schulung

Zuerst einmal das FileMaker 17 Event für die Schweiz:

Medio-Ingeno AG veranstaltet zusammen mit FileMaker Inc. einen weiteren FMnext-Anlass am 12. Juni 2018, ab 16:30 Uhr im Jürg-Wille-Saal im Restaurant Löwen in Meilen.
Neuigkeiten zu FileMaker 17, artfremde Präsentationen von Andreas Reinhard sowie etwas für die Lachmuskeln von Rob Spence wird zu sehen und hören sein.
Für das leibliche Wohl ist wie gewohnt gesorgt.
Anmeldung und weitere Informationen unter fmnext.ch.
Wir freuen uns, Sie an diesem Anlass begrüssen zu dürfen.

Zudem wird eine MBS Plugin Schulung am gleichen Tag von ca. 9 bis 16 Uhr stattfinden.
Aufgrund einiger Anfragen, haben wir folgendes Programm zusammengestellt:
  • MBS Plugin Überblick
  • Scannen aus FileMaker
    • Mac & Windows
    • Duplex an/aus
    • Ordner anlegen
    • Bilder in Ordner ablegen
  • PDF Generierung aus Bildern
  • JSON Funktionen
  • FileMaker Server Admin API steuern
  • FileMaker iOS SDK Anwendung bauen
  • Fragen
Weitere Themen können je nach Wunsch der Teilnehmer noch dazu kommen.
Falls Sie Interesse haben dabei zu sein, dann melden Sie sich bitte bald bei uns. Anmeldung.
Kosten vermutlich 150 Franken inkl. Mittagessen.

Three weeks till FileMaker Conference .fmp[x]Berlin 2018

Just three weeks left for FileMaker Conference .fmp[x]Berlin 2018?

Beside the local conferences in Europe coming in October, this is a pan-european conference for people from all over the world.

FileMaker developers from 16 countries attend:
🇦🇹, 🇧🇪, 🇨🇦, 🇨🇭, 🇩🇪, 🇩🇰, 🇪🇸, 🇫🇮, 🇫🇷, 🇬🇧, 🇮🇹, 🇱🇻, 🇳🇱, 🇳🇴, 🇸🇪 & 🇺🇸.

This is going to be the biggest international conference for FileMaker in Europe, I've ever seen!

I proposed three sessions:
MBS Sessions at FileMaker Conference .fmp[x]Berlin 2018

This conference is organized by Egbert Friedrich and takes place from 7th to 9th June 2018 in Berlin, Germany. If you like to join and you are not yet on the list, I think you may need a really good reason for him to let you get a ticket.

MBS FileMaker Plugin, version 8.2pr8

New in this prerelease of version 8.2 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

MBS Xojo Plugins, version 18.2pr8

New in this prerelease of the 18.2 plugins: Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

FileMaker 17 Launch Event bei der Denkform

Am 29. Mai 2018 treffen sich interessierte FileMaker Entwickler bei der Denkform in Hofheim (Taunus).

Michael Valentin von FileMaker Deutschland kommt vorbei und präsentiert Filemaker 17 und steht dann für Fragen bereit.

Anschließend zeigt Christian Schmitz gerne ein paar Neuerungen im MBS Plugin 8.x.

18:00 Uhr Einlass und Begrüßung bei der denkform® GmbH
18:30 Uhr - 19:45 Uhr Michael Valentin: FileMaker Produktneuheiten und F&A
19:45 Uhr - 20:00 Uhr Pause
20:00 Uhr - 20:45 Uhr Christian Schmitz: MBS FileMaker Plugin Neuerungen; F&A
ab ca. 21:00 Uhr Get-to­ge­ther

Anmeldung auf der Denkform Eventseite. Zeitlich vermutlich 18 bis 21 Uhr. Eventuell mit optionalem Abendessen.

Xojo Stammtisch in Zürich

On my next visit to Zurich, I'd love to make another Xojo developer meeting:

Wer hat Interesse an einem Xojo Entwicklertreffen am 10. oder 11. Juni in Zürich?

Einfach gemütlich zusammen sitzen und über Xojo schnacken.
Gerne zeige ich auch neue Pluginfunktionen oder helfe bei Problemen mit Xojo Projekten. Einfach Computer mitbringen und was zeigen.

Bei Interesse bitte eintragen für Terminfindung: Umfrage

Wer Interesse hat an einem Termin mit mir für Softwareentwicklung, Schulungen, Entwicklungshilfe, Plugin Empfehlungen, assistierte Fehlersuche, Code-Review und IT-Beratung, der darf sich gerne melden für eine baldige Terminfindung.

BBEdit turns 25 years old

Do you know BBEdit?

It's still after many years it is my favorite text editor on MacOS.
I've been using it since version 6.x around year 2000, first the Light version and than full version later.

You can use BBEdit to edit any text file, convert between different line endings and text encodings.

I love it for searching and replacing texts in multiple files using regular expression and edit all my html, php and javascript files in it.

As BBEdit can be downloaded and tested for free, please give it a try today.

Thanks Bare Bones Software, Inc. for making it.

UUID Numbers

FileMaker 17 introduces a new function Get(UUIDNumber). It allows you to query the numeric representation of an UUID.


Both refer to the same UUID and you can calculate the numeric value yourself by decoding hex parts and multiplying. Those UUID values allow you to use UUIDs as primary keys on the database. Sorting and indexing can be more efficient.

Sadly FileMaker 17 does not introduce the UUID data type to store UUIDs efficient as 16 byte in binary representation instead of 40 characters of text for the number or 36 characters for hex representation. That would save space.

So please start using UUID numbers, which avoid people guessing your record IDs by counting up or down.

If you need those for FileMaker 16 or older, you can use our new plugin function UUID.Number. It returns you an UUID as number, same as with FileMaker 17.

We also got UUID.FromNumber and UUID.ToNumber functions to convert between hexadecimal and numeric representation.

Windows GUI Resources

For next MBS Xojo Win Plugin, we add a new WindowsGUIResourcesMBS class:

This class allows you to query the number of handles used for GUI and user objects. So you can have a timer monitor those values and maybe detect a leak in memory usage. For example, each picture needs a GUI handle. But a window may contain a few user object and GUI handles.

Coming soon for version 18.2 of our Xojo plugins.

FileMaker Stammtisch Ulm

Am 17. Mai treffen sich interessierte FileMaker Entwickler in Ulm zum Austausch von Neuigkeiten, Erfahrungen und Tipps & Tricks.

Diesmal als Thema vermutlich FileMaker 17 mit vielen Neuerungen und ersten Erfahrungen.

Wo: Mommo’s Pasta & Pizza, Frauenstraße 30, 89073 Ulm
Wann: 17. Mai 2018, ab 19 Uhr
Kosten: Nur die eigenen Getränke und Abendessen

Anmeldung am Besten beim Swen Bauer und Fabrice Ricker. Die können euch dann auch in Zukunft über weitere Termine informieren. Siehe auch FileMaker Magazin

Würde mich freuen Euch dort zu sehen.

Falls sonst noch Bedarf an Schulung, vor Ort Entwicklung oder FileMaker/Xojo Hilfe besteht, bitte wegen Terminfindung bald melden.

PS: Noch sind Plätze zur MBS Schulung frei bei Brainworks am 14. Juni frei.

XDC 2018 Highlights Video

Watch the XDC 2018 highlights video now:

The next conference is just 4 months away: MBS Xojo Conference, 6th/7th Sep 2018 in Munich.

My FileMaker 17 Release Notes

FileMaker Inc. just released their latest version of FileMaker product family and you can read elsewhere about all the details. Here I want to just point to a few changes, which may not be addressed in all the announcements.


The new version of FileMaker has a new plugin SDK and plugin vendors should update plugins for the new version. For MBS Plugin, please use version 8.1 or newer. Version 8.2 will be released next week to give us a few days to test with the final FileMaker 17 version. We hope to quickly fix any issue found after the release is out.

We support 12 different FileMaker releases from version 7.0 to 17.0 and use a modified version of the SDK which does some extra steps to make sure the plugin loads for all the older versions.

Older plugins may or may not work for FileMaker 17. They may not load, not initialize correctly or you cause problems later. We fixed a couple of issues in our plugin for 17 in the beta time. But with 5000+ functions, you may never run into one of the affected functions! To avoid trouble, please use 8.2 or newer.

FileMaker Advanced only

First FileMaker Pro is gone and we only have FileMaker Pro Advanced. If you miss the Tools menu, please enable it in preferences and restart your copy of FileMaker Pro Advanced. Please note that independent of this preferences, the software itself via report itself as FileMaker Pro Advanced. e.g. Get ( ApplicationVersion ) returns something like "ProAdvanced 17.0.1".

For plugins this means that we have to do extra work in the MBS Plugin. But you can use that as MBS( "Platform" ) should return "Pro" if you use only the Pro version and Developer if advanced tools are enabled. We use this to disabled script highlighting automatically for FileMaker Pro until the first time you open the script editor. This avoids confusion with users who may see a colored number somewhere.

Please note that you as a solution provider can define whether Advanced Tools are enabled with the AI_DISABLEADVANCEDTOOLS=1 entry in the "Assisted Install.txt" file next to the installer.

FileMaker Data Migration Tool

The migration command line tool is great addition and certainly will help a lot of people. It allows to copy data from the older database into a clone of a newer version. Be careful to read the documentation for this tool. The rules on how to match tables and fields from old to new database could be unexpected sometimes as matching goes primary by name and not ID. So better do not rename tables or fields unless you want them to be empty after migration.

If calculated fields need to be recalculated, be aware that some context may be missing, especially calls to plugins will not work as far as we know and not return the expected values. Finally, please always use the -v command line switch for verbose output, so you see what is going on. Work on copies of the databases and it may be good to lock the old file as read only (Info window in Finder), so you don't accidentally overwrite the old database.

For the performance, calculated fields can make the process slow. Because if there is a field, which needs to be recalculated, that means that all related fields may need recalculating and finally the indexes need to be redone. And if each field needs to be touched and index rebuild for a table, the copy process can change from a second (copy on block) to minutes.

Perform Script by Name

As scripts can be performed by name, be always sure that the script called verifies that the one who called is allowed to call it. People could before trigger any script by name via URL already, but now it's even easier. So expect any script to be triggered by someone at any time. For best security, validate if the script is run in the correct layout, by the current account and exit with an error if something is not as it should be!

Temporary Logout

The new feature for temporary lockout is a good idea. But have you ever left your iPhone on the kitchen's table? If you have small kids, the may try some buttons and while they may not be able to read and write, they key can press buttons and get PINs entered. Sometimes I come back and the phone is locked for a minute!
So if someone comes to your FileMaker application, they can now block your access for some time by trying random passwords.

OS Requirements

FileMaker 17 has higher needs for the operation system. On Windows side you can use 7 year old Windows 7 SP1, but on MacOS, it must be 2 year old MacOS 10.12 Sierra or newer. I am personally not happy to only have two supported MacOS releases.

For iOS FileMaker Go requires the 11.2 release from last year. That maybe due to the Drag & Drop support which requires iOS 11.


With the newer license model, the benefits improve for the memberships. For 99 USD/year as FDS member, you can now get the FileMaker Data Migration Tool (you want that in your toolchain!) and a server license for your development. It is the cheapest way to get yourself a server for your own company, although with very limited connections.

Being FBA member is now worth more as you get 3 servers and 5 users included. That is cheaper than buying those licenses for yourself, so I would expect quite a few smaller FileMaker consultant companies can cover their company with those licenses. FileMaker iOS SDK and data migration tools are now included with FBA, so you may no longer need a FDS membership alongside a FBA membership.

Launch Events

Please check FileMaker Events website for announcements of FileMaker 17 Launch events.
We will be present at the launch events in Germany (29th May) and in Switzerland (12th June).

Xojo Stammtisch in München

Wer hat Interesse an einem MBS Xojo Entwicklertreffen am 14. Juni in München?

Einfach gemütlich zusammen sitzen in einem Restaurant oder Biergarten und über Xojo reden.
Gerne zeige ich auch neue Pluginfunktionen oder helfe bei Problemen mit Xojo Projekten. Einfach Computer mitbringen und was zeigen.

Bei Interesse bitte bald bei mir melden.

Für die Xojo Konferenz im September sind noch Plätze frei.

FileMaker Stammtisch in München

Wer hat Interesse an einem MBS FileMaker Entwicklertreffen am 13. Juni in München?

Einfach gemütlich zusammen sitzen in einem Restaurant oder Biergarten und über FileMaker reden.
Gerne zeige ich auch neue Pluginfunktionen oder helfe bei Problemen mit FileMaker Datenbanken. Einfach Computer mitbringen und was zeigen.

Bei der MBS Plugin Schulung bei Brainworks sind noch Plätze frei.

Wir haben schon sieben Teilnehmer, aber wer noch dazu kommen möchte, möge sich bitte bei mir melden.

Dies ist zusätzlich zum regulären FileMaker Stammtisch in München.

Older blog entries:

2018-05-14 Sign PDFs with DynaPDF using Windows Certificate Storage
2018-05-14 MBS FileMaker Plugin, version 8.2pr7
2018-05-14 MBS Xojo Plugins, version 18.2pr7
2018-05-13 Permanent column widths for FileMaker
2018-05-13 XDC2018 Superhero SQLite Video available for free
2018-05-12 MBS Sessions at FileMaker Conference .fmp[x]Berlin 2018
2018-05-11 Detect 32 vs. 64bit DLL in Xojo
2018-05-11 Sum up values in JSON with MBS FileMaker Plugin
2018-05-11 JSON with large integers
2018-05-10 Copy Script Button with HTML
2018-05-10 Check our QuickLook Plugin for Xojo and Real Studio Projects
2018-05-10 DynaPDF for iOS
2018-05-09 xDev Magazine Issue 16.3
2018-05-09 Image Gallery in FileMaker using SQL
2018-05-08 XDC 2018 Session Videos
2018-05-08 Store your ID in URLs in Mac address book
2018-05-08 FileMaker Magazin - MBS Artikel
2018-05-08 Combine PDFs 5.3
2018-05-07 Query URL from downloaded file
2018-05-07 MBS FileMaker Plugin, version 8.2pr6


May 2018
Mar 2018
Feb 2018
Jan 2018
Dec 2017
Nov 2017
Oct 2017
Sep 2017
Aug 2017
Jul 2017
Jun 2017
May 2017
Apr 2017
Mar 2017
Feb 2017
Jan 2017
Dec 2016
Nov 2016
Oct 2016
Sep 2016
Aug 2016
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