Our Blog   Our Claris FileMaker Blog   Our Xojo Blog   Archive     Follow us on BlueSky, Mastodon, Twitter, Xing, LinkedIn or Facebook.

MBS FileMaker Plugin, version 15.2pr5

New in this prerelease of version 15.2 of the MBS FileMaker Plugin:
  • Fixed XL.CopyCellValue, XL.CopyColumn and XL.CopyRow to work if second document has more sheets.
  • Added shortcuts to calculation dialog to pick return type just like field types.
  • Changed shortcut to show ruler in calculation dialog to using command-option-R.
  • Changed shortcut to show invisibles in calculation dialog to using command-option-I.
  • Added Audit.SetUUIDFields and Audit.GetUUIDFields function.
  • Updated plugin SDK.
  • Improved auto complete to work better with XL functions.
Download at monkeybreadsoftware.com/filemaker/files/Prerelease/

You can subscribe to our FileMaker mailing list to get notified for new pre-release and release versions.


Priority Support

We got asked by clients for support contracts or options. In general we offer support to all our clients at a best effort level. You know, as time permits. Usually that tends to be within minutes or hours when someone is in the office. But sometimes when traveling, vacation, holidays or similar, there is a delay. And some more complex support requests may take days until we get an answer.

Our clients in general appreciate our responsiveness. We get praises about having a very complete documentation and functions working as advertised or documented.

Since we got asked, we will introduce a priority support level. If you get priority support for a fee, we make sure your support requests are flagged as important and answered quicker. Usually this may not make a difference, except when time for support is tight and we have to pick who to answer first.

Our priority support comes in two variants. General MBS Plugin support and separated DynaPDF support. And if you order priority support for DynaPDF, we include the priority support from DynaForms with 24h reaction time and 7 days fix time.

Beside standard or priority support, there is also paid support available. Some clients prefer to pay by the hour to get their problems resolved or a helping hand implementing a plugin feature.

We'll see how well this is received and appreciated.
Let us know if you have a question.


MBS FileMaker Plugin, version 15.2pr4

New in this prerelease of version 15.2 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.com/filemaker/files/Prerelease/

You can subscribe to our FileMaker mailing list to get notified for new pre-release and release versions.


25 Years Monkeybread Software Party

This year in early April our company turned 25 years old. We plan to have a party here in Germany near our office with around 100 guests.

Today we emailed everyone who is on the guest list. If you do not receive an email today or lost your invitation, please contact us.

So far it looks like our party will be the biggest Xojo developer conference this year. For FileMaker, it will be the second biggest gathering of FileMaker developers behind the German FileMaker Konferenz.

We look forward to meet you guys and celebrate!

(more)

Bidirectional Mode and Complex Text Rendering in DynaPDF

Rendering text in a PDF might seem straightforward—until you try working with languages like Arabic or Hebrew. These languages require more than just placing characters from left to right. Without proper handling, the result can be unreadable or even misleading.

Let’s look at how DynaPDF handles this challenge using Bidirectional (Bidi) Mode and Complex Text Rendering.

(more)

MBS FileMaker Plugin, version 15.2pr3

New in this prerelease of version 15.2 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.com/filemaker/files/Prerelease/

You can subscribe to our FileMaker mailing list to get notified for new pre-release and release versions.


Improving a Web Form: Fighting Back Against Bots

Over time, we’ve built a few web forms—some simple, some more complex. Unfortunately, bots love web forms. They fill them out with spam, test vulnerabilities, or just cause general headaches. If you’ve ever maintained a form in production, you know exactly what I mean.

To cut down on junk submissions, we’ve implemented a few strategies that have worked well for us. These aren’t foolproof, but they definitely raise the bar and help filter out a lot of automated noise.

(more)

Connect to DuckDB in FileMaker

Today we like to connect to a DuckDB database from FileMaker using the SQL functions in MBS FileMaker Plugin. For that we need the client libraries for DuckDB, but where to get them?

macOS with homebrew

For macOS you can use homebrew to install the duckdb package. Then you get the duckdb library installed.

You find the library on an Apple Silicon Mac:

/opt/homebrew/Cellar/duckdb/1.2.1/lib/libduckdb.dylib

For an Intel Mac, you find it in the /usr/local folder in a sunfolder.

(more)

Connect to Postgres in FileMaker

Today we like to connect to Postgres Database server from FileMaker using the SQL functions in MBS FileMaker Plugin. For that we need the client libraries for Postgres, but where to get them?

macOS

For macOS you can download the Postgres App to get a local test server for Postgres on your Mac. You can directly point to the libpq.5.dylib within the application.

We adjusted the install names to make them work into the Frameworks folder of your application. The libpq library needs crypto and ssl libraries, so these must be in the same folder. We got the libraries here for you: PostgreSQL Libraries. You can store these for example in the Extensions folder next to our plugin.

(more)

LibXL 4.6.0 has been released

We are glad to inform you that the new LibXL version 4.6.0 is available now.

What's new in the version 4.6.0:

New methods:

The LibXL library can be used with MBS Plugins in Xojo and FileMaker. Updated plugins will be available soon. As usual we add the new functions soon. If you need help or want to try the new version early, let me know.


MBS FileMaker Plugin, version 15.2pr2

New in this prerelease of version 15.2 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.com/filemaker/files/Prerelease/

You can subscribe to our FileMaker mailing list to get notified for new pre-release and release versions.


25 Years of Monkeybread Software

This month we celebrate 25 years of Monkeybread Software.

In April 2000 I started my self employment with filling the business registration form. Originally I coded shareware applications, but since I got consulting clients in 2000 and needed to write invoices, I had to start a company and register as a business.

In 2001 we needed more and more plugins in REALbasic for the various projects. We got a lot of plugins from Einhugur back then and Björn is still making Xojo plugins as of today! Since we needed more, I went into learning C++ and started my own plugin collection. Thanks to Thomas Tempelmann and others for some help to get started. Over the years we (co-)hosted 13 European Xojo conferences to bring together the developer community.

Later in 2006 we started the adventure into making a plugin for FileMaker. A couple of people asked over the years to port over some functions from my Xojo plugins to FileMaker and eventually Todd Geist persuaded me into making one. It took a few years to grow, but the popularity really toke off when I went to the FileMaker Konferenz 2012 in Salzburg and the FileMaker DevCon in 2013 in San Diego. Once people saw the plugin, they loved it and our business grew.

The Monkeybread Software name came from Matt Ronge, my former US business partner. We separated a few years later and he's now busy as the Cofounder and CEO of Astropad.

There will be a big party here near the office and we invited hundreds of clients, friends and family. If you like to join and you miss an invitation, you can contact us and ask whether your invitation got lost.

If you need a new license for MBS Plugins, we have a special offer for April: Use coupon code Birthday for a 20% discount.

See you at the party or the next conference!


MBS FileMaker Plugin, version 15.2pr1

New in this prerelease of version 15.2 of the MBS FileMaker Plugin:
  • Added AbortProc and an event processing loop to DynaPDF printing to help with updating a progress dialog.
  • Added DynaPDF.ReadImageFormatFile and DynaPDF.ReadImageResolutionFile function to inspect images files on disk.
  • Added DynaPDF.RenderJob function.
  • Added ExtensionFilter parameter to Files.ListRecursive function.
  • Added flag 128 for matching substring with the ExtensionFilter parameter for the Files.List, Files.ListAsJSON and Files.ListRecursive functions.
  • Added MapView.GetWindow function.
  • Added more Python functions to query time and library information.
  • Added ScriptWorkspace.IsFocusOnScriptList and ScriptWorkspace.SetFocusToScriptList functions.
  • Changed tooltips for fields to use FieldType() instead of SQL for better performance.
  • Fixed an issue with Audit.BuildCaches function missing the FieldName.
  • Fixed SQL.ConvertDateTimeFromSQL to return empty result if the date value is not valid.
  • Fixed SSH2 library for Windows to use OpenSSL instead of Windows API again. Broken in last release.
  • Implemented a maximum for sockets. Now limited to 1000 concurrent sockets to avoid crashing FileMaker when running out of file handles.
  • Implemented text selector for ScriptWorkspace.StyledScriptText function.
  • Improved Archive.Compress to compress folder itself if file list is empty.
  • Improved exceptions handling for GraphicsMagick functions.
  • Improved OCR error messages about missing functions to show the function name. you may see such an error if you have an older tesseract or leptonica library, which doesn't contain the functions we look for.
  • Improved PDFKit.SelectPrinter to return an error when we fail to create the dialog.
  • Improved performance of DynaPDF generating previews for container values for large files.
  • Improved showing IDs for Database Design dialog to not rebuild cache for new fields.
  • Improved the If/Loop highlighting to also highlight Enter Find Mode and Perform Find.
  • Updated DynaPDF to version 4.0.98.281.
  • Updated expat library to version 2.7.1.
  • Updated libarchive to version 3.7.9.
  • Updated Saxon library to 12.5.1 pre-release.
Download at monkeybreadsoftware.com/filemaker/files/Prerelease/

You can subscribe to our FileMaker mailing list to get notified for new pre-release and release versions.


FileMaker Konferenz 2025 in Hamburg - Frühbucher

Noch ein Monat für den Frühbucherrabatt: Vom 14. bis 17. September 2025 findet die nächste deutschsprachige FileMaker Konferenz in Hamburg, Deutschland statt. Das JUFA Hotel Hamburg HafenCity liegt direkt neben dem Ausgang der U-Bahn Station HafenCity Universität, nur drei Stationen vom Hauptbahnhof via U4, so dass sich die Anreise per Bahn empfiehlt. FileMaker Anwender und Entwickler können ihre Teilnahme buchen.

Anmeldung mit Frühbucherrabatt

Bitte melden Sie sich an, wenn Sie Interesse an der Konferenz haben. Bis zum 30. April 2025 gibt es den Frühbucherrabatt.

Möchten Sie Sponsor oder Sprecher werden?

Aktuell sucht der FMK Verein Vorschläge für interessante Vorträge.

Die Veranstalter vom Verein FM Konferenz erwarten auch 2025 rund 120 Entwickler, Anwender, IT-Fachleute und Entscheidungsträger aus Wirtschaft, Bildung und Verwaltung. Rund um über 25 Fachvorträge und Workshops wird es viel Zeit zum Vernetzen in den gemeinsamen Pausen und beim Abendprogramm geben.

Weitere Konferenzen

Alternativ gibt es noch weitere Konferenzen in Europa:

  • Vienna Calling, 4th to 7th June 2025 in Vienna, Austria.
  • EngageU, 9th to 11th November 2025 in Antwerpen, Belgium

Meet us at Claris Engage

You can find Stefanie and Christian at the Claris Engage conference in Austin.
Just walk around and talk to us in the breaks. If you need a longer meeting, we could sit together for a chat while a session runs.

If you need a license, please use coupon code FileMakerConference in our web shop to place an order. Let us know if you need something special so we can assist the order. The code is valid until at least 5th April, so you have time next week to place an order.

Ideas? Questions? Please don’t hesitate to write us an email, send a feedback or to find us on the conference.

MBS FileMaker Plugin 15.1 News

In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 15.1.

SendMail

For many years we offer functions in the SendMail area that allow you to create and send emails with a variety of different options. This time we have added functions that allow you to set whether SSL should be used when sending the email. With SendMail.SetUseSSL we set the setting and with SendMail.GetUseSSL we can query it. You can also specify whether 8-bit encoding should be used for encoding instead of Quoted Printable. The functions SendMail.SetUse8BitMime and SendMail.GetUse8BitMime can help you with this.

Encryption

When it comes to encryption, you can now list the available curves for the ECKey function. The ECKey.BuiltInCurvesJSON function, which outputs a JSON with the information about built in curves. We can use the ECKey.CurveNameToID function to determine the ID of a curve by its name.

We have also added two functions for signing and verifying ES256. You can sign data with the ECKey.ES256Sign function and verify it with ECKey.ES256Verify.

(more)

Upcoming Mailserver Migration

Our mail provider notified us, that they plan to switch to different mail servers within the next month.

Sadly this may cause an interruption in the mail services whenever this happens.
And to prepare for a migration, we cleaned up and deleted a couple of email accounts.

If you send an email to use and it bounces, please try again later. If we don't react to an email, maybe contact us next day on a different way like by messaging service, website form or a different email.

Sorry for any inconvenience.

Exploring the Plugin.LimitToFile Feature in the MBS FileMaker Plugin 15.1

Exploring the Plugin.LimitToFile Feature in the MBS FileMaker Plugin 15.1

The MBS FileMaker Plugin 15.1 introduces an important functionality for FileMaker developers — Plugin.LimitToFile. This feature enhances control over which files can access and utilize the plugin. It’s a useful tool when creating solutions where limiting plugin access to specific files is essential for security or organizational purposes.

What is Plugin.LimitToFile?

In essence, Plugin.LimitToFile restricts the plugin's functionality to certain files within your FileMaker solution. It ensures that only the specified files are allowed to make use of the plugin. This feature is useful when you want to avoid unauthorized use of the plugin or to limit its operation to a select few files. It adds an extra layer of control over the environment in which your plugin operates.

(more)

MBS Plugin 15.1 for Claris FileMaker

Nickenich, Germany - (March 11th, 2025) -- Monkeybread Software today is pleased to announce MBS FileMaker Plugin 15.1 for Claris FileMaker for macOS, iOS, Linux and Windows, the latest update to their product that is easily the most powerful plugin currently available for Claris FileMaker produce line. As the leading database management solution for Windows, macOS, iOS and the web, the Claris FileMaker Pro Integrated Development Environment supports a plugin architecture that can easily extend the feature set of the application. MBS FileMaker Plugin 15.1 has been updated and now includes over 7600 different functions, and the versatile plugin has gained more new functions:

We improve our Saxon integration and licensing. We have two new examples to show what is possible with XSLT. One example uses an XML transformation to validate ZUGFeRD, Factur-X or X-Rechnung invoice. The second example uses XSLT to visualize electronic invoices in UBL, ZUGFeRD, Factur-X or X-Rechnung format.

The Barcode.GenerateJSON function can optionally outputs drawing commands as JSON. Our example project shows how to use this to draw QR-Codes with round dots.

For Windows you can programmatically show the properties dialog for a file in explorer with Files.ShowPropertyDialog function. The Files.ShareFile function can open the Windows share sheet to share a file with contacts.

If you like to protect access to MBS FileMaker Plugin, you can use Plugin.LimitToFile to limit the plugin only to a few files. For encryption you can now list the available curves for ECKey function and do ES256 sign and verify.

For macOS and iOS you can query the change history for contacts database. This informs you about changes, that happened since the last time you asked and provides the list of new, updated and deleted contacts.

If you have multiple Python installations, you can use Python.AddSysPath function to point to the directory where to find libraries.

Sending emails can use 8bit instead of quoted printable encoding. The JSON.Import and XML.Import functions can handle dates and numbers better. For XL functions you can address columns in Excel with letters instead of just numbers (e.g. C instead of 2 for 3rd column). The XML.ApplyStylesheet function got the EXSLT extensions. The MQTT feature in CURL functions can keep up the connection.

We added a checkbox for preferences to toggle whether custom functions get parameters autocompleted when you pick a function. We detect links in calculations and make them clickable. For color blind users we can change the error display in the debugger from red to blue. For your own context menu entries with SyntaxColoring.AddContextMenuCommand functions, you can add a calculation to determinate whether a menu command shows.

Finally we updated CURL library to version 8.12.1, DynaPDF to 4.0.98.278, jsoncons to 1.3.0, lcms to 2.17, OpenSSL to 3.3.3, png to 1.6.47 and SQLite to version 3.49.1.

See release notes for a complete list of changes and documentation for new functions.


Neues MBS FileMaker Plugin 15.1 für Claris FileMaker

11. März 2025 - Monkeybread Software veröffentlicht heute das MBS FileMaker Plugin für Claris FileMaker in Version 15.1, mit inzwischen über 7600 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen:

Wir verbessern unsere Saxon-Integration und -Lizenzierung. Wir haben zwei neue Beispiele, die zeigen, was mit XSLT möglich ist. Ein Beispiel verwendet eine XLST Transformation, um ZUGFeRD, X-Rechnung oder Factur-X Rechnungen zu validieren. Das zweite Beispiel verwendet XSLT, um elektronische Rechnungen im UBL-, ZUGFeRD-, Factur-X- oder X-Rechnung-Format zu visualisieren.

Die Funktion Barcode.GenerateJSON kann optional die Zeichenbefehle als JSON ausgeben. Unser Beispielprojekt zeigt, wie man damit QR-Codes mit runden Punkten zeichnen kann.

Unter Windows können Sie mit der Funktion Files.ShowPropertyDialog programmatisch den Eigenschaftsdialog für eine Datei im Explorer anzeigen. Die Funktion Files.ShareFile kann die Windows-Freigabemaske öffnen, um eine Datei mit Kontakten zu teilen.

Wenn Sie den Zugriff auf das MBS FileMaker Plugin schützen möchten, können Sie Plugin.LimitToFile verwenden, um das Plugin auf einige wenige Dateien zu beschränken. Beim Thema Verschlüsselung können Sie nun die verfügbaren Kurven für die ECKey-Funktion auflisten und ES256 signieren und verifizieren.

Für macOS und iOS können Sie die Änderungshistorie für die Kontaktdatenbank abfragen. Diese informiert Sie über Änderungen, die seit der letzten Abfrage stattgefunden haben und liefert die Liste der neuen, aktualisierten und gelöschten Kontakte.

Wenn Sie mehrere Python-Installationen haben, können Sie die Funktion Python.AddSysPath verwenden, um auf das Verzeichnis zu verweisen, in dem die Bibliotheken zu finden sind.

Beim Versenden von E-Mails kann die 8-Bit-Kodierung anstelle von Quoted Printable verwendet werden. Die Funktionen JSON.Import und XML.Import können besser mit Daten und Zahlen umgehen. Bei XL-Funktionen können Sie Spalten in Excel mit Buchstaben statt nur mit Zahlen ansprechen (z. B. C statt 2 für die 3. Spalte). Die Funktion XML.ApplyStylesheet hat die EXSLT-Erweiterungen erhalten. Die MQTT-Funktion in CURL-Funktionen kann die Verbindung aufrechterhalten.

Wir haben ein Option für die Voreinstellungen hinzugefügt, mit der Sie festlegen können, ob bei benutzerdefinierten Funktionen die Parameter automatisch vervollständigt werden, wenn Sie eine Funktion auswählen. Wir erkennen Links in Formeln und machen sie anklickbar. Für farbenblinde Benutzer können wir die Fehleranzeige im Debugger von rot auf blau umstellen. Für eigene Kontextmenüeinträge mit SyntaxColoring.AddContextMenuCommand-Funktionen können Sie eine Berechnung hinzufügen, um zu bestimmen, ob ein Menübefehl angezeigt wird.

Schließlich haben wir die CURL-Bibliothek auf Version 8.12.1, DynaPDF auf 4.0.98.278, jsoncons auf 1.3.0, lcms auf 2.17, OpenSSL auf 3.3.3, png auf 1.6.47 und SQLite auf Version 3.49.1 aktualisiert.

Alle Änderungen in den Release Notes. Neue Funktionen in der Dokumentation.


Older blog entries:

2025-03-06 MBS FileMaker Plugin, version 15.1pr7
2025-03-06 Electronic invoices in FileMaker
2025-03-04 Elektronische Rechnungen in FileMaker
2025-03-03 MBS FileMaker Plugin, version 15.1pr6
2025-02-25 Claris Engage 2025 - Next Month
2025-02-24 MBS FileMaker Plugin, version 15.1pr5
2025-02-22 Visiting Texas for Claris Engage
2025-02-18 Validate electronic invoices with Saxon
2025-02-17 MBS FileMaker Plugin, version 15.1pr4
2025-02-17 Visualize electronic invoices with Saxon
2025-02-16 How the Script Merges PDFs and Inserts an Image: A Detailed Breakdown
2025-02-15 WebViewer or not?
2025-02-14 Benefits of XSLT 2.0 and 3.0 Compared to XSLT 1.0
2025-02-13 Create QR-Codes with circles
2025-02-12 MBS FileMaker Plugin, version 15.1pr3
2025-02-08 FileMaker Konferenz 2025 in Hamburg
2025-02-07 Read system information on Linux
2025-02-06 MBS FileMaker Plugin, version 15.1pr2
2025-02-04 Differences between old and new Excel file format
2025-02-01 MBS FileMaker Plugin, version 15.1pr1

Archives

Apr 2025
Mar 2025
Feb 2025
Jan 2025
Dec 2024
Nov 2024
Oct 2024
Sep 2024
Aug 2024
Jul 2024
Jun 2024
May 2024
Apr 2024
Mar 2024
Feb 2024
Jan 2024
Dec 2023
Nov 2023
Oct 2023
Sep 2023
Aug 2023
Jul 2023
Jun 2023
May 2023
Apr 2023
Mar 2023
Feb 2023
Jan 2023
Dec 2022
Nov 2022
Oct 2022
Sep 2022
Aug 2022
Jul 2022
Jun 2022
May 2022
Apr 2022
Mar 2022
Feb 2022
Jan 2022
Dec 2021
Nov 2021
Oct 2021
Sep 2021
Aug 2021
Jul 2021
Jun 2021
May 2021
Apr 2021
Mar 2021
Feb 2021
Jan 2021
Dec 2020
Nov 2020
Oct 2020
Sep 2020
Aug 2020
Jul 2020
Jun 2020
May 2020
Apr 2020
Mar 2020
Feb 2020
Jan 2020
Dec 2019
Nov 2019
Oct 2019
Sep 2019
Aug 2019
Jul 2019
Jun 2019
May 2019
Apr 2019
Mar 2019
Feb 2019
Jan 2019
Dec 2018
Nov 2018
Oct 2018
Sep 2018
Aug 2018
Jul 2018
Jun 2018
May 2018
Apr 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