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


MBS FileMaker Plugin, version 7.5pr2


New in this prerelease of the 7.5 MBS FileMaker Plugin:
  • Added App.GetProcessPath and App.GetProcessName for Linux.
  • Fixed bug with SQLite Prepare command with extra spaces in SQL commands.
  • Added RSA.DecryptPrivateKey and RSA.EncryptPrivateKey functions.
  • Improved RSA.GeneratePrivateKey to allow you to specify algorithm and encrypt keys.
  • Added "Callbacks with Custom Webviewer" example to show how to use JavaScript callback with our custom webviewers.
  • Added MouseCursor.HideUntilMouseMoves function.
  • Fixed problem in List.DeCombine not returning list with first empty element missing.
  • Fixed TinyMCE example for FileMaker 16.
  • Fixed preferences dialog to allow entering of values.
  • Changed copy button in script workspace to replace tab with spaces, so tabs are only used to intent.
  • Fixed a bug with formula coloring to work, if formula starts with "(".
  • Added selector CopyRight for Files.FileInfo to query copyright string on Mac.
  • Improved custom webviews to work with download delegate and policy delegate functions.
  • Changed window finding by window title to fall back to prefix matching if the exact window title is not found.
  • Enabled P12 files for certificates in CURL for Windows.
  • Updated CURL library to version 7.56.0.
  • Changed WebView.InstallCallback to work in FMP 16 with WebView.Create.
  • Fixed problem for iOS where registration for remote notification would not always happen.
  • Put back in iOS plugin, which was missing for 7.4.
  • Added FileName parameter to FM.ScriptNameForScriptID, FM.ScriptIDForScriptName and FM.ScriptNames.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

PS: I uploaded a newer disk image including iOS Plugin which was missing. Sorry.

Reise in die Schweiz zu FileMaker und Xojo Entwickler Treffen


Wieder mal bin ich in der Schweiz, u.a. zum FileMaker Experience Event am 21. November in Meilen.

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.

Für Xojo Entwickler organisiere ich gerne noch einen Stammtisch: Doodle Umfrage

Alle FileMaker Entwickler sind natürlich gerne eingeladen mit nach Meilen zu kommen, wo ich auch gerne die ein oder andere MBS Plugin Funktion zeige. Mal sehen, was es in einem Monat alles neues gibt!

Conference discount offer


As usual with every conference we offer licenses at a discount to conference attendees: 20% on everything.

You can find the coupon code on our flyers at the booth. The coupon code is valid till end of October and can be used with the Share-It web store.
For PayPal or orders using invoices, we will create individual invoices on request.

If you don't have a flyer and you attend one of the current conferences, you can always email us a picture of the badge as proof to get the coupon.
Please note that the discount is to help attendees to get a bigger return of investment out of the conference trip.

MBS Plugin Stand bei der FMK 2017


Falls Sie eine Frage haben zum MBS FileMaker Plugin haben oder sich einmal darüber informieren möchten, so kommen Sie bitte am Stand vorbei:



Man sieht sich!

FileMaker Pro, Server and Go in version 16.0.3


FileMaker Inc. just released a new version of their products:

See details for FileMaker Server 16.0.3, FileMaker Go 16.0.3 and FileMaker Pro 16.0.3.

Fixes include the problems with lost scripts when committing a record after a reconnect. And of course a couple more fixes.

The installation of the update is highly recommended to all users of FileMaker 16 to avoid the problem mentioned above!

Arrived in Salzburg


Arrived in Salzburg for German FileMaker Konferenz:



See you all there!

FileMaker Conference .fmp[x]Berlin 2018


We just got announcement for the 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.

As the conference is in english, this is your chance to meet people from around the world at a conference in Europe. And for a lot of people it's easier to get to Berlin than to cross the atlantic and deal with US immigration officers.

Who
dotfmp is an effort of various leading European FileMaker Developers. It is meant to bring all kinds of higher level developers together to share knowledge, educate and challenge each other.
When
dotfmp starts at the 6th June 2018 in the later afternoon with a relaxed "Beer and Sausages" in one of the most famous Berlin Beergarden.The session days itself last from 7th until 9th June with various socialising events in the evenings. Additionally we offer support on 10th June to see more from Berlin and its surroundings.
What
dotfmp is a 3 Day-Unconference, Meetup, Hangout or Barcamp. It is an informal and self-organized effort to meet on a personal base.
Where
dotfmp takes place in one of the most famous spots in Berlin. The GLS Campus is located in a vibrant area with a very short walking distance to all the famous restaurants.
Why
We feel there are far too few possibilities to talk to, learn from, and hangout with fellow developers in a relaxed and informal environment. And we'd like to share work and get feedback from people chewing on similar challenges.


If you like to join the conference and present something, please register soon.

Click on a container to set points in FileMaker


Here is a nice example database to show how to make clicks on a PDF:


So first we render PDF to an image using DynaPDF functions. Than user can click on image inside a container to set a point. We draw the point with our GraphicsMagick functions in MBS Plugin and build a list of records for the points.

Later those points could be used to draw them on a new PDF with existing PDF in background.
Maybe this is useful for you? I'll include it with next plugins (or email me for a copy)

MBS FileMaker Plugin, version 7.5pr1


New in this prerelease of the 7.5 MBS FileMaker Plugin:
  • Added DynaPDF.ReplaceImage function.
  • Fixed bug with DynaPDF.GetImage function complaining about non decompressed image.
  • Added DynaPDF.GetReplaceICCProfileData and DynaPDF.SetReplaceICCProfileData.
  • Changed trace file to be UTF-8 with BOM and LF as end of line on Mac and Linux.
  • Changed trace file to be UTF-16 with BOM and CRLF as end of line on Windows.
  • Updated DynaPDF to version version 4.0.13.36.
  • Added QuickList.DeCombine function.
  • Added fix to avoid crashes with FileMaker 12 on macOS Sierra related to removing observers.
  • Added List.SubList and QuickList.SubList functions.
  • Changed error notifications to only show maximum 5 of them and remove them automatically after 5 minutes.
  • Changed variable error notifications to be removed automatically when you typed correct name.
  • Added iOS support for JavaScript functions.
  • The column for script IDs is now a bit narrower.
  • Updated LCMS library to version 2.9rc1.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

PS: I uploaded a newer disk image including iOS Plugin which was missing. Sorry.

Thanksgiving


It’s Thanksgiving this weekend in Germany. Time to say thank you to all the good things that happen in live. Thanks for the wife and three healthy kids, thanks for having a great job and thanks to you my customers, who keep this company running.

Thanks for my father's colleagues who recommend him to buy a Mac 20 years ago. Thanks to Geoff for buying CrossBasic, making it REALbasic and thanks for Macwelt magazine to pointing me to it. Thanks for the first customers who hired me in 1999 to code for them, so I started a company in April 2000. Thanks to customers pushing me to learn C++ and writing plugins for Xojo and FileMaker. And thanks to everyone who bought a license. Over the years we can keep doing this, because people support us with their purchases. Thanks to keep me doing this instead of applying for a regular job somewhere to pay my bills.

And thanks for the travel around the world and the conferences. Organizing a conference is a lot of work, so thanks to all people who organize conferences. And of course thanks to everyone leaving their office to go to a conference. Only attending conferences makes them great and keeps them going!

So lets keep this running and see you at conferences in Salzburg, Madrid, London, Montreal, Denver, Munich and wherever another one will be!

Replace Image in PDF


For DynaPDF we add new method to replace an image in a PDF:

With existing functions, you can query image information for all the images and export them to files. With the next plugin, you can use a new function in DynaPDF to replace each image with a new image. The display size and orientation is not changed, so your new image should match the size and aspect ratio.

With next plugin version, you can use the new function DynaPDF.ReplaceImage in FileMaker or DynaPDFMBS.ReplaceImage in Xojo. You can pass new picture as file on disk or with data in memory. The image can use it's own color space or be converted to one of the color spaces defined in the PDF or standard device colorspaces.

If you like to try, send me an email for an early preview copy.

Fixing a problem in FileMaker 12 via MBS Plugin


Today we run into a problem with FileMaker 12.
On every (!) launch here, we get a crash report dialog with a lot of details including this message:

*** Terminating app due to uncaught exception 'NSRangeException', reason: 'Cannot remove an observer for the key path "areInspectorsVisible" from because it is not registered as an observer.'


This could be a bug in FileMaker or one of the Apple frameworks. Probably due to running FileMaker 12 on macOS 10.12 Sierra. The removeObserver method is called where it shouldn't be.

Now I can use my MBS Plugin to fix this with a work around: The new plugin watches for calls to removeObserver method and puts the call in an try/catch block. If the exception occurs, we can log it and continue. FileMaker doesn't see the exception and does not terminate. If no exception happens, the call just continues normally and nobody will notice.

If you run into the same problem, let me know and I can maybe help you with the same issue with an updated MBS Plugin.

MBS FileMaker Plugin Schulung auf Deutsch bei der FMK 2017


Noch zwei Wochen 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).

MBS FileMaker Plugin 7.4 - More than 4900 Functions In One Plugin


Nickenich, Germany - (September 26th, 2017) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 7.4 for macOS, iOS, Linux and 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, iOS 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 7.4 has been updated and now includes over 4900 different functions, and the versatile plugin has gained more new functions:

For macOS 10.13 High Sierra and iOS 11, we added new Core ML functions to use machine learning files and for example classify pictures. We also updated a few other functions like FSEvents for the new macOS version.

The new ImageView functions allow you to show an image on the layout independent of FileMaker. So you don't need a container field and you can show animated GIF images in your layout on Mac and iOS.

To enhance the script workspace, the MBS Plugin can show the script IDs in the script list. For the database design dialog, you can now show the table IDs and field IDs in the lists. We improved the contextual menus to copy in more cases and we have a new entry to copy the selection only. With Command-F and Command-L you can now jump to search and Go To Line boxes. The new ScriptWorkspace functions can be used in various FileMaker based tools to open script workspace and select scripts from a script.

For the field picker and various other utility palettes, you can now have the plugin make them optionally black and white instead of transparent. The plugin watches for those dialogs and turns them into resizable panels, if enabled in preferences.

You can now use CoreImage to detect faces, rectangles, text areas and QRCodes in images on macOS and iOS.

For the Webviewer, we now allow you to create a WebKit 1.x webview anywhere on a layout. As FileMaker 16 uses WebKit 2.x, some of the functions to query images or PDF of a webviewer are not supported for WebKit 2.x. Making our own webviewer allows to still use those functions.

If you use FileMaker iOS SDK, you can use our plugin now to query keyboard visible state. We can trigger script or evaluate expression if there is a significant time change, app goes to background or foreground and receives a low memory warning.

To better work with CSV text, we got new functions to split CSV into values. Our FM.InsertRecordCSV function can take CSV text and create records for the values in your database. For XML functions we added ways to query and set values based on a path similar to the FileMaker JSON functions.

For DynaPDF we added commands to create process and separation colors. Text can now directly be drawn rotated.

We got new commands to Copy/Cut/Paste text in webviewer, memory usage functions for SQLite, triggers for AVPlayer and SerialPort pause functions.

Finally we updated CURL Library to version 7.55.1, DynaPDF to 4.0.13.35, SQLAPI to 4.1.12, SQLite to 3.20.0 and LibXL to 3.8.1.

See release notes for a complete list of changes.

See all button images in FileMaker



with MBS Plugin FileMaker 7.4 and resizable palette windows.

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.

Older blog entries:

2017-09-17 MBS FileMaker Plugin, version 7.4pr6
2017-09-17 Bluetooth Vulnerability BlueBorne Impacts Android, iOS, Windows, and Linux Devices
2017-09-16 Playing with CoreML in FileMaker
2017-09-14 Image view for FileMaker via MBS Plugin
2017-09-13 Sponsoring FileMaker conferences
2017-09-11 MBS FileMaker Plugin, version 7.4pr5
2017-09-11 MBS FileMaker Plugin Schulung auf Deutsch bei der FMK 2017
2017-09-10 FileMaker DevCon 2018 to be announced in October
2017-09-09 Dash help archives for Xojo and FileMaker
2017-09-08 Got a new cabinet. Cube loves it!
2017-09-07 FileMaker Magazin - MBS Artikel
2017-09-06 FileMaker Stammtisch Rhein-Main
2017-09-04 High Sierra Tester
2017-08-31 MBS FileMaker Plugin, version 7.4pr4
2017-08-30 FileMaker and PDF Containers
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

Archives

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