MBS FileMaker Plugin, version 10.6pr4

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

Multi Column Output for PDFs with FileMaker

For MBS FileMaker Plugin we recently added a new DynaPDF.SetPageBreakExpression function. Have you seen it?
It allows you to define a page break expression. This calculation is evaluated when a text rectangle is filled with text and we need a new page or a new rectangle on the same page.

Look on this sample database with three columns filled over many pages with one big text block:



Here is a sample call for DynaPDF.SetPageBreakExpression: (more)

MBS FileMaker Plugin, version 10.6pr3

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

Lots of new commands in FileMaker Admin API

Have you checked the documentation for the FileMaker Admin API for FileMaker Server 19.2?

The Claris FileMaker Server 19.2.1 Release Notes website only says:

This release includes a preview of enhancements to the FileMaker Admin API. New commands have been added to allow you to configure FileMaker Server settings that were only available through Admin Console or the FileMaker Server Command Line Interface (CLI). You can now:

  • get metadata for FileMaker Server
  • configure additional folders
  • import an SSL certificate
  • import a license certificate
  • manage plug-ins

But when we checked the documentation, we found over 30 new commands:

(more)

FileMaker 19.2 and the new fmplugin extended privilege

Claris just released FileMaker 19.2 and MBS FileMaker Plugin works fine with it. We have been testing the new version for weeks and not yet found an issue.
Please make sure you use version 10.5 or better 10.6pr2 with latest Big Sur fixes.

FileMaker Pro 19.2.1 Updater Release Notes
Claris FileMaker Server 19.2.1 Release Notes
Claris FileMaker Cloud 2.19.2.1 Release Notes

But there is a new feature in FileMaker to allow developers to disallow plugins to run scripts or do SQL queries. This is done with a new extended privilege named fmplugin. Or in a per plugin specific version you can add one named fmpluginXXXX, where XXXX is the 4 letter code of the plugin, e.g. MBSP for our MBS Plugin.

If a plugin tries to run a script or execute a SQL statement in a target file, FileMaker scans for fmplugin privilege sets. If the current account in the target file does have the privilege granted for either all plugins or specifically MBS Plugin, the operation is allowed. Otherwise you may see error codes and your scripts may not get the desired action.

FileMaker Pro adds the new privilege automatically to a new file for you. As old files don't have the privilege (unless you add it), plugins should work as before. But for the new files, this can cause plugin functions which involve starting scripts or running SQL commands to not work as permissions get denied to do so. Error code 825 as far as we see. This may affect our capabilities to search relationship graph, show field or table names. Also Audit functions may be affected and our FMSQL functions of course. This is not always directly visible as for example FM.QueryTableNames, XML.Import or JSON.Import use SQL internally.

There is an exception, that if you have admin privileges, you can allow access via an UI code, which can create a permanent link between files and allow access without privilege set.

Let us know if you find an issue or have a question.

6 Monate bis zur Deutschen FileMaker Konferenz 2020 in Malbun

Noch sechs Monate bis zur FileMaker Konferenz 2021 in Malbun (Liechtenstein) und zur MBS Plugin Schulung Schulung am Mittwoch vorher.

Vom 17. bis 19. Juni 2021 findet die elfte deutschsprachige FileMaker Konferenz in Malbun, Liechtenstein statt. Aktuell läuft die Frühbucherphase bis 28. Februar mit vergünstigten Tickets.

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

Für den Deutschsprachigen Raum ist diese Konferenz das Treffen des Jahres. Hier finden Sie vom Anfänger bis zum Profi Kontakte zu anderen Entwicklern. Lernen Sie was es neues gibt, nehmen Sie Impulse mit für die eigene Arbeit und erfahren Sie mehr zu FileMaker von deutschsprachigen Experten!



Die MBS Plugin Schulung vorher findet voraussichtlich am statt im gleichen Hotel am 16. Juni 2021.

Bitte planen Sie wenigstens einen extra Tag ein für ihren Besuch in Liechtenstein, damit Sie die Natur in dem schönen Tal geniessen können. Den Aufstieg auf den Sareis können Sie bequem zu Fuß vom Hotel aus starten und die Turnastraße hinauf spazieren bis zum Restaurant am Gipfel. Oder alternativ die Seilbahn nehmen.

Hoffen wir, dass sich im Frühjahr die Corona Lage verbessert und die Konferenz stattfinden kann.

Translating Insert from URL options for CURL to MBS Plugin calls

You may have a few options for an Insert from URL script step and you may want to convert them to a script using MBS FileMaker Plugin.

e.g.
" --user myusername:mypassword --upload-file $file --header \"Content-type: image/png\""

Which translates to a script like this:

Set Variable [$curl; Value:MBS("CURL.New")]
# set options
Set Variable [$r; Value: MBS( "CURL.SetOptionURL"; $curl; $URL)]
Set Variable [$r; Value: MBS( "CURL.SetOptionUpload"; $curl; 1)]
Set Variable [$r; Value: MBS( "CURL.SetOptionUserName"; $curl; "myusername" )]
Set Variable [$r; Value: MBS( "CURL.SetOptionPassword"; $curl; "mypassword" )]
Set Variable [$r; Value: MBS( "CURL.SetOptionHTTPHeader"; $curl; "Content-type: image/png" )]
Set Variable [$r; Value: MBS( "CURL.SetInputFile"; $curl; $file )]
# run transfer
Set Field [CURL Test::Result; MBS("CURL.Perform"; $curl) ]
Set Field [CURL Test::DebugMessages; MBS("CURL.GetDebugAsText"; $curl) ]
Set Variable [$result; Value: MBS("CURL.Release"; $curl) ]


As you see we set a few options like the URL (with filename for uploaded file), the user name and password for the login and a HTTP header for the content type. If you'd use ftp:// URL for a ftp upload, you won't need the HTTP headers and the option would be ignored if you set it. But if you do a HTTP upload, it's oft course good to pass the mime type to the receiving script on the web server. (more)

MBS FileMaker Plugin Goodies Video

We got a new video for you about the goodies and made an English and a German version:

Thumbnail

Goodies for macOS (English)

Thumbnail

macOS Bonusmaterial (German)

Enjoy is and if you have questions, please don't hesitate to contact us.


MBS FileMaker Plugin, version 10.6pr2

New in this prerelease of version 10.6 of the MBS FileMaker Plugin:
  • Added mode 16 for number sorting to QuickList.SortWith function.
  • Update SQLite library to version 3.34.0.
  • Changed SQL functions to automatically use CLOB/BLOB type for strings for SQL Server if length is >8000.
  • Updated DynaPDF to version 4.0.44.125.
  • Fixed ListDialog functions on macOS to handle Command-C, Command-V, Command-X and Command-A for the filter text field.
  • Split local offline documentation in separate download.
Download at monkeybreadsoftware.com/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

MBS FileMaker Plugin, version 10.6pr1

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

DynaPDF Introduction for FileMaker

We got a video about using DynaPDF in FileMaker. Stefanie builds a few examples and shows how to add text and change images in a PDF document.



Enjoy the video and please don't hesitate to contact us with your questions.

Archives

Jul 2025
Jun 2025
May 2025
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
Mar 2010
Dec 2009
Nov 2009