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

MBS FileMaker Plugin, version 7.4pr8

New in this prerelease of the 7.4 MBS FileMaker Plugin:
  • Changed script ID display to show ? if two scripts have same name and we don't know which ID is right.
  • Added iOSApp functions to get notification on low memory, going to background, coming to foreground or significant time changes.
  • Fixed Folders.UserVideo to make it work on Windows.
  • Added stars to field ID list in database design window to highlight where we didn't find a neighbor ID.
  • Added Dictionary.AddSQLRecord function.
  • Added CSV functions: FM.InsertRecordCSV, List.CSVSplit and QuickList.CSVSplit.
  • Enabled XML for GraphicsMagick for Mac as it's needed for SVG.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

MBS FileMaker Plugin, version 7.4pr7

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

Field Picker in FileMaker resizable and in black

Take a look on this screenshot:

Another nice idea for people with big databases where the names of the fields can be really long.
You can enable resize and/or black color in the preferences dialog for MBS Plugin.

All options can be toggles on/off and should work fine in various FileMaker versions.

Showing Script IDs in FileMaker Script Workspace

The MBS Plugin can soon show the script IDs in the Script Workspace:

As you trigger scripts via ID, it may be convenient to see the IDs right in the tab.
Coming soon in the next 7.4 prerelease. Or email for a copy to test today.

Update: We'll move the numbers to the script table, as you better see them there, I think.

MBS Plugin now showing field and table IDs in database design dialog

Take a close look on this FileMaker dialog:

Of course you can toggle this off in preferences dialog and the checkboxes allow you to enable it only if you want to see them.
But if enabled, the plugin tries to query all the field and table IDs and show them in a new column. We use a checkbox to enable it as the query to get table/field information from FileMaker can take a few seconds on big databases.

If you like to test, email me for a copy. macOS only.

MBS FileMaker Plugin, version 7.4pr6

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

Bluetooth Vulnerability BlueBorne Impacts Android, iOS, Windows, and Linux Devices

Have you seen the details on the Blueborne attack?

Any device unless patched can simply be taken over via bluetooth by just being in range of a hacker!
If someone places a bot to hack all devices in range automatically in a subway station, they can get thousands of devices taken over and have a huge bot army.

This is one of the bugs, which renders all unpatched devices to be no longer used. So any Android and Windows without security patch installed, and iOS before version 10 should no longer be used. And for Android it's unlikely, that your phone has currently the September security patch installed, if it's available for your phone at all!

Another solution is to disable bluetooth on all devices.

Playing with CoreML in FileMaker

For the release of macOS 10.13 High Sierra, we are working on supporting CoreML framework in FileMaker and Xojo. Here is my test database to detect :

While macOS 10.13 is not ready for a few weeks, we can already download the beta versions of macOS and Xcode and play with it. You can use a model quite easy as you see in the Core ML presentation from WWDC 2017. With just a few lines in a script we load a model, setup source image and run it though the neural network to classify the picture. You can get sample models from Apple's Machine Learning website.

The plugin will be available later this month with the macOS release.

Image view for FileMaker via MBS Plugin

For next MBS FileMaker Plugin release we add an image view control for macOS and iOS:

So you can show an animated GIF images on the layout independent of container fields!
Of course other images work, too. And you can hide/show as needed, change size and close the control as needed.
Like to try? Well, contact us for a new plugin. Documentation

PS: Now available in 7.4pr6 to test.

Sponsoring FileMaker conferences

I recently noticed that I had not yet signed up to sponsor the FileMaker conferences in Leiden and Rouen.
So now I changed that and you can find my logo on the list of sponsors. So you can now join those conferences:

fmconf.com, FM Conférence 2017 in Rouen, 18-20 October
fmsummit.info, FM Summit 2017 in Leiden, 9-11 October

We also sponsor FileMaker Konferenz in Salzburg and FileMaker DevCon in Madrid.

MBS FileMaker Plugin, version 7.4pr5

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

MBS FileMaker Plugin Schulung auf Deutsch bei der FMK 2017

Noch einen Monat bis zur FileMaker Konferenz und damit zur MBS FileMaker Schulung auf Deutsch in Salzburg.
Schon angemeldet für die Konferenz und die Schulung?

Wir bieten auch dieses Jahr am Tag vor der FileMaker Konferenz in Salzburg, am Mittwoch, den 11. Oktober 2017 von ca. 9 bis 17 Uhr eine Schulung rund um das MBS FileMaker Plugin an.
  • Neues im MBS Plugin.
  • Rundgang durch Beispiele
  • MBS Plugin verwenden mit FileMaker Cloud
  • MBS Plugin verwenden mit FileMaker iOS SDK
  • Erweiterungen im Skript Workspace
  • Beliebte Pluginfunktionen
    • FTP/SFTP Up/Download
    • Webservices einbinden
    • Bildbearbeitung
    • Barcodes generieren und erkennen
    • Arbeiten mit dem Webviewer
    • SQL Anfragen in FIleMaker oder an andere Datenbanksysteme
  • Zeit für Fragen
Anmeldung bei mir. Kosten 99 Euro + MWSt. inkl. Mittagessen und Kaffeepausen.
Bitte Umsatzsteuer ID angeben bei Anmeldung, Bezahlen.

Oder melden Sie sich bei der Denkform an für den MBS Workshop am 7. Dezember 2017 in Hofheim (Taunus).

FileMaker DevCon 2018 to be announced in October

On a thread in the FileMaker community, there is a posting that location and date is to be announced in October.

We speculated a bit about the conference location and date. Well, date is set to be mostly in end of July. Location is a bit more difficult. The hotel needs to have plenty of space. A few really big conference rooms to sit people for the keynote, the sessions and to serve food. The keynote this year had around 1200 people in one room and 1600 at the conference in total. The hotel also needs to have rooms for those people to sleep, so a 1000+ room hotel is a good choice.

The JW Marriott Phoenix Desert Ridge Resort had 950 rooms, but there were also people in the Canyon Villas with a few hundred extra rooms. The JW Marriott San Antonio Hill Country Resort has 1000 rooms, but no nearby other hotel.

As we see FileMaker Inc. loves the Marriott hotel chain as they picked them the last years. Looking on what hotels Marriott operates in the southern USA big enough to host the event, there are just a few choices beside the hotels we already visited.

My bet is the Gaylord Texan Resort & Convention Center. Just a few minutes from the Dallas - Fort Worth airport, with 1500+ rooms and a huge meeting space. Big enough to even add a few more attendees to grow the event.
What is your guess?

Dash help archives for Xojo and FileMaker

For browsing help files, the Dash application is very useful on Mac and iOS.

Here you can click to launch Dash and install our plugin help:
MBS Xojo Plugin and MBS FileMaker Plugin

You can download the archives manually on our website:
FileMaker and Xojo (Real Studio).

You can also add Xojo documentation itself to your dash set, see download in preferences dialog.
For FileMaker you find the docsets for v15 here: FileMaker Dash Docsets

Feedback is welcome.

Got a new cabinet. Cube loves it!

We got a new cabinet and it's a nice place for my little Apple Museum: An original Apple Cube with 450 MHz from year 2000.

It still runs well with Mac OS X 10.4.11, can be remotely managed via screen sharing and used to be my testing computer for PPC applications. But since I dropped my PPC support this year, it may now stay on the cabinet and wait till we need it. There is always a chance you get an old document where the software is no longer available to convert them to a newer format.

The Apple mouse pad there is even older. Over 20 years a give away from one of the Apple Expos here in Germany!

FileMaker Magazin - MBS Artikel

For our German 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.

FileMaker Stammtisch Rhein-Main

Der nächste FileMaker Stammtisch in Rhein-Main findet morgen am Donnerstag, den 7. September 2017 in Hofheim-Wallau statt.

ca. 19 bis 23 Uhr im Ristorante BELLA BARI - Hessenstraße 1 - 65719 Wallau.

Themen diesmal FileMaker Konferenz in USA, kommende FileMaker Konferenz in Salzburg und gerne auch Fragen an mich zum MBS Plugin.

Gerne könnt ihr eure FileMaker Lösungen mitbringen und bei Probleme und Fragen direkt vorführen. Eventuell hat jemand in der Runde ja eine Lösung für euch.

Denkform Webseite

High Sierra Tester

For the 9th time I made a Tester app for Macwelt.de for novice users to check if their Mac can run the next macOS version.

You can download and try it here: HighSierraTester.zip

The application does check a few parameters of your Mac to help you learn whether High Sierra will probably work on your Mac.
Be aware that the application is in German, but still it shows red, green or yellow icons for various parameters.

Your Mac must of course meet the minimum requirements from Apple and a few technologies only work if you have required hardware. e.g. HEVC decoding with hardware acceleration needs CPUs supporting it. External graphics adapters need Thunderbolt 3 port and APFS a SSD disk. I hope you see a lot of lights being green.

The application can also identify 32-bit kernel extensions which don't work any more.
Also we can find PPC applications (no longer supported for years) and also warn about 32-bit software, which may need an update for macOS 10.14.

Let me know what you think about it. I hope it helps you to decide whether installing macOS High Sierra makes sense.

See also: Macwelt Artikel

MBS FileMaker Plugin, version 7.4pr4

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

FileMaker and PDF Containers

There are sometimes problems with Containers as you see in various FileMaker forums. Well, the problem may be that FileMaker can do only previews on Mac as they don't include a PDF engine for Windows. So if you try and add files and check with Container.GetTypes what items are in the container, you get a table like this:

FileMaker 16 Win
Any ContainerInsert FileFILE, FNAM
Any ContainerInsert PictureFNAM, PDF
Interactive ContainerInsert PDFFNAM, PDF
After using DynaPDF.GeneratePreviewFNAM, JPEG, MAIN, PDF , SIZE
FileMaker 16 Mac
Any ContainerInsert FileFILE, FNAM
Any ContainerInsert PictureFNAM, JPEG, MAIN, PDF , PNGf, SIZE
Interactive ContainerInsert PDFFNAM, JPEG, MAIN, PDF , PNGf, SIZE
After using PDFKit.Combine functionFNAM, JPEG, MAIN, PDF , SIZE

We have a couple of common types in the containers:
  • "PDF " is the PDF file data.
  • FILE is the content of a file.
  • JPEG if exists is the JPEG preview data.
  • PNGf if exists is a preview as PNG image file.
  • FNAM is the file name for the container.
  • SIZE is the preview image size.
Now you need to know that FileMaker can render PDF on Mac on the fly (without annotations!), but on Windows it needs the preview. Or for all platforms use a web viewer for the interactive container to let the web engine render the PDF using it's PDF plugin.

You can of course always use MBS functions to check if preview is missing and add it on the fly using both PDFKit and DynaPDF functions. This could even be done on a server with a scheduled script or on a helper machine. The MBS Plugin adds a JPEG preview and you can use Plugin.SetPreviewSize function to configure preview size.

Older blog entries:

2017-08-28 Sign up for European FileMaker Conferences
2017-08-26 Custom WebView in FileMaker 16
2017-08-22 MBS FileMaker Plugin, version 7.4pr3
2017-08-21 Video from MBS Plugin Presentation at DevCon 2017
2017-08-20 Video from MBS Plugin Presentation at DotFMP 2017
2017-08-18 Multiple recordsets with Microsoft SQL Server
2017-08-15 Zwei Monate bis zur FileMaker Konferenz in Salzburg
2017-08-14 MBS FileMaker Plugin, version 7.4pr2
2017-08-09 FileMaker consultants with MBS Knowledge
2017-08-04 FileMaker Meeting in Braunschweig
2017-08-02 DevCon Offer still available
2017-08-01 MBS FileMaker Plugin, version 7.4pr1
2017-07-29 Good bye Phoenix!
2017-07-27 FileMaker Excellent Awards
2017-07-25 Push Notifications for FileMaker iOS SDK
2017-07-24 MBS Booth ready for FileMaker DevCon
2017-07-24 FileMaker DevCon to start soon
2017-07-23 Face detection via CoreImage in FileMaker
2017-07-18 MBS FileMaker Plugin 7.3 - More than 4800 Functions In One Plugin
2017-07-18 MBS FileMaker Plugin 7.3 - Über 4800 Funktionen in einem Plugin


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