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.
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)
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.
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)
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.
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.
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)
We got a new video for you about the goodies and made an English and a German version:
Enjoy is and if you have questions, please don't hesitate to contact us.
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.
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.
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.
