- MBS FM Plugin - lists.monkeybreadsoftware.com

[ANN] 14.3pr3
by Christian Schmitz 14 Jun '24

14 Jun '24

Hi, * Improved list functions to better split lists with CRLF as delimiter. * Fixed Matrix.CSVSplit to split better (Broken in pr2). * Improved UNNotification functions to work better in FileMaker 21, so both ways can be used together. * Improved code formatting to detect semicolon first and then formats this way. * Added Python.Path, Python.ProgramFullPath, Python.ProgramName, Python.PythonHome, Python.SetProgramName and Python.SetPythonHome functions. * Changed CURL debug messages to include the full URL you requested for review. We include a warning, if URL has no scheme. * Updated DynaPDF to version 4.0.88.252. * Added KeepUnsupportedAnnots option for DynaPDF.FlattenAnnots function. * Added DynaPDF.SetLineAnnotPoints and DynaPDF.EnableImageCache functions. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.3pr2
by Christian Schmitz 10 Jun '24

10 Jun '24

Hi, * Added DX, DY and ClassID parameters to Preview.CreateWithControl and Preview.Create functions. * Enabled Python functions to work on iOS. * Fixed JSON.GetPathItem to not return error for invalid JSON. * Fixed an issue with server calling WMIQuery.Connect function. * Fixed JSON.GetArraySize to return no error for empty JSON and just return zero. * Added SystemInfo.MacMemoryHostStatistics function. * Added MQTT example using CURL. * Improved UNNotification functions to work better in FileMaker 21. * Changed WindowsUserNotification and UNNotification functions to be free to use without license. * Added QuickList.JSONArray function. * Changed Matrix.JSONRecord and Matrix.JSONRecords to take field names from column names, if you have some and you don't pass field names. * Changed Matrix.CSVSplit to handle CSV with multi line values better. * Added header row flag for Matrix.CSVSplit to put first row into column names. * Added Archive.CompressText function. * Added CURL.SetMQTTScript, CURL.GetMQTTFileName and CURL.GetMQTTScriptName functions. * Added CURL.GetMQTTMessages function. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

DynaPDF 4.0.87.251 for iOS
by Christian Schmitz 06 Jun '24

06 Jun '24

Hi, I build a new iOS framework for DynaPDF with version 4.0.87.251: https://www.monkeybreadsoftware.com/filemaker/files/Libs/DynaPDF%20iOS/ For use with FileMaker iOS SDK. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] FileMaker 2024 released
by Christian Schmitz 04 Jun '24

04 Jun '24

Hello everyone Claris released today FileMaker 2024 in version 21.0. Works fine with MBS FileMaker Plugin 14.2. You get new AI script steps, writing via Execute FileMaker Data API script step, Let's Encrypt certificates (instructions here), an Open Quickly shortcut, Revert transactions in subscripts and you may enjoy a few bug fixes. But please read details in the release notes: • FileMaker 2024 Announcement https://community.claris.com/en/s/question/0D5Vy000009idtMKAQ/introducing-c… • FileMaker 2024 Resources https://partner.claris.com/s/fm2024-resources • Claris FileMaker 2024 Technical Specifications https://support.claris.com/s/answerview?anum=000041422&language=en_US • FileMaker Pro release notes https://help.claris.com/en/pro-release-notes/content/index.html • FileMaker Go release notes https://help.claris.com/en/go-release-notes/content/index.html • FileMaker Server release notes https://help.claris.com/en/server-release-notes/content/index.html You can download it on the ESD website. The link is in the license email from Claris. For MBS FileMaker Plugin, just make sure you have a 14.x version, best the 14.2 one. We had to adjust our plugin in several places: • We updated the SDK to the latest version. • Relationship graph search had to be adjusted for macOS. • Control placements have been adjusted for macOS. • Adjustments for identifying FileMaker windows on Windows. And a few smaller bug fixes. We keep an eye open on what users report and may adjust more for the next plugin release. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.3pr1
by Christian Schmitz 03 Jun '24

03 Jun '24

Hi, Let's start a new round for MBS Plugin development: * Added Python functions. * Added Plugin.LockedFunctions function. * Enhanced execute button for calculation dialog to allow pressing option key to only evaluate the selected text. * Updated for future FileMaker version. * Improved variable auto completion to better handle custom functions starting with underscore. * Updated to newer plugin SDK for FileMaker 21. * Fixed problem with JSON returning negative floating point numbers without leading 0. * Updated to Xcode 15.4. * Updated SQLAPI to version 5.3.2. * Fixed the WordFile.ReplaceTag function, which broke in 14.2. * Improved the formatting code for calculations to handle special words like or and and better. * Update LibXL libraries for macOS and Windows to version 4.3. * Fixed a bug in WebLink() function in DynaPDFMBS class returning negative number. * Changed XL.Book.Version to have the book parameter optional. * Added EmailParser.ReleaseAll function. * Renamed EmailParser.Free to EmailParser.Release, but old name will stay valid. * Fixed a memory leak in loading Excel file from disk with XL.LoadBook function. * Fixed a problem with XL functions where license key was not recognized properly. * Fixed a problem with copying script text would duplicate field names or calculations. * Changed trace function to not log the password for a Files.Mount call. * Added check to XL.Initialize and DynaPDF.Initialize to return an error if the license key includes invalid characters like a space character. * Added Mutex.ReleaseAll function. * Renamed Mutex.Free to Mutex.Release, but old name will stay valid. * Updated SQLite to version 3.46.0. * Updated our ICU integration for SQLite to the new SQLite version. * Updated DynaPDF to version 4.0.87.251. * Enhanced format button for calculation dialog to allow pressing shift key to only format the selected text. * Updated curl to version 8.8.0 * Enhanced check syntax button for calculation dialog to allow pressing shift key to only check the selected text. Download at https://www.monkeybreadsoftware.com/filemaker/files/Prerelease/ or ask for being added to the DropBox shared folder. Please also go to the FM Soup forum and setup "Watching First Post" for the MBS category, so you get an email when I start my pre-release topic. Then once you see that, please put the topic on watching, so you get an email for every new posting from me. https://the.fmsoup.org/c/plugins/mbs-plugins/58 Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

Warning: WordFile.ReplaceTag broken
by Christian Schmitz 22 May '24

22 May '24

Hello everyone, The changes in 14.2 for WordFile functions broke them. Sorry. This will be fixed for 14.3. If you use WordFile functions, please stay with 14.1 or older versions. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] MBS Plugin 14.2 for Claris FileMaker - More than 7300 Functions In One Plugin
by Christian Schmitz 14 May '24

14 May '24

Nickenich, Germany - (May 14th, 2024) -- Monkeybread Software today is pleased to announce MBS Plugin 14.2 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 14.2 has been updated and now includes over 7300 different functions, and the versatile plugin has gained more new functions: We upgraded our JSON functions with the JSON.Merge function to merge two JSON blocks or arrays. This allows to easily merge two arrays of JSON data for example. Since you may need to decide dynamically on what to replace with JSON.Replace, we got a new JSON.ReplaceEvaluate function to run an expression to build the new JSON to replace the old value. Use JSON.CurrentMatch to get the current found JSON. The XL functions can create conditional formatting in your scripts. Use the XL.Book.AddConditionalFormat function to define the format and use XL.Sheet.AddConditionalFormatting to define the rules. This could be a simple comparison or include a calculation in Excel. The new LibXL version can better handle SVG, so we updated our XL.Book.GetPicture function. When you build your iOS app using the FileMaker iOS SDK and you embed our plugin, then you can enjoy our new printing functions for iOS. Use PDFKit.SelectPrinter function to pick a printer and then use PDFKit.Print to print with or without dialog. A point of sale application can print receipts without a dialog to the printer selected by script. Our MongoDB functions got improved with new functions to execute custom commands. If you expect a result, please use MongoDB.ClientCommandQuery instead of MongoDB.ClientCommand and loop over the returned documents. You can set the app name to be reported to the server on connecting and query the credentials used. Our CURL functions can now pick the SSL backend. By default we use OpenSSL, but you can switch to SecureTransport on macOS or SecureChannel on Windows using CURL.SetSSLBackend function, if you prefer the local SSL engines. The plugin comes with the newer Apple IDN implementation for CURL, which we contributed to the project recently. For the goodies in our plugin for macOS, we got a new label in the field picker to jump the table occurence you used the last time. Just click on the name to jump to that table occurence without manually picking it in the popup menu. Use the Math.MovingAverage function to calculate the moving average with three different modes on the fly, check out Container.RemovePreview to remove preview images for containers and use GMImage.Flatten to remove alpha channel of an image and substitute with a background color. The Overlay.Move function can be animated, use Files.IsUserImmutable to check whether a file is locked by the user and configure the WebView on Windows to decide whether to hide PDF toolbar items or disable swipes. Finally we updated CURL to version 8.7.1, DynaPDF to 4.0.87.250, LibXL to 4.3.0, SQLAPI to 5.3.1, SQLite to 3.45.3 and Xcode to version 15.3. See release notes for a complete list of changes: https://monkeybreadsoftware.com/filemaker/releasenotes142.shtml More details in the release notes. Please take the time to check our 600 example databases and check where you can use our plugin features in your solutions. System Requirements: * macOS 10.13 or later * Windows 8 and newer, Windows 7 on request. * FileMaker Pro 7 to 20.3 * FileMaker iOS SDK * FileMaker Server for Linux, Windows or macOS Pricing and Availability: MBS FileMaker Plugin is available directly from the MonkeyBread Software website with licenses starting at just $149 USD. You can just download and try the plugin without a license or request a trail license. Not all functions are available in all platforms, please check specifications. Please join us on the next conferences and visit our booth. Monkeybread Software Website https://monkeybreadsoftware.com/filemaker/ Documentation: https://mbsplugins.eu/ Release notes: https://monkeybreadsoftware.com/filemaker/releasenotes.shtml Located in beautiful Nickenich, Germany, MonkeyBread Software is a privately held company founded in 2000 by Christian Schmitz. MonkeyBread Software focuses on the Macintosh, Linux and Windows platforms. With over twenty years as a software developer, Christian's aim is developing unique and useful utilities, complemented by first-class customer support. Copyright 2000-2024 Christian Schmitz Software GmbH. MonkeyBread Software is a registered trademark of Christian Schmitz, Nickenich. All Rights Reserved. Apple, and the Apple logo are registered trademarks of Apple Computer in the U.S. and/or other countries. FileMaker Pro and FileMaker are trademarks of Claris International, Inc. Other trademarks and registered trademarks may be the property of their respective owners. Greetings Christian Schmitz Monkeybread Software

1 0

[ANN] Neues MBS Plugin 14.2 für Claris FileMaker - Über 7300 Funktionen in einem Plugin
by Christian Schmitz 14 May '24

14 May '24

14. Mai 2024 - Monkeybread Software veröffentlicht heute das MBS Plugin für Claris FileMaker in Version 14.2, mit inzwischen über 7300 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen: Wir haben unsere JSON-Funktionen um die Funktion JSON.Merge erweitert, mit der zwei JSON-Blöcke oder Arrays zusammengeführt werden können. Da Sie möglicherweise dynamisch entscheiden müssen, was mit JSON.Replace zu ersetzen ist, haben wir eine neue Funktion JSON.ReplaceEvaluate eingeführt, die einen Ausdruck ausführt, um das neue JSON zu erstellen, das den alten Wert ersetzt. Verwenden Sie JSON.CurrentMatch, um das aktuell gefundene JSON zu erhalten. Mit den XL-Funktionen können Sie bedingte Formatierungen in Ihren Skripten erstellen. Verwenden Sie die Funktion XL.Book.AddConditionalFormat, um das Format zu definieren, und verwenden Sie XL.Sheet.AddConditionalFormatting, um die Regeln zu definieren. Dies könnte ein einfacher Vergleich sein oder eine Berechnung in Excel beinhalten. Die neue LibXL-Version kann besser mit SVG umgehen, daher haben wir unsere Funktion XL.Book.GetPicture aktualisiert. Wenn Sie Ihre iOS-App mit dem FileMaker iOS SDK erstellen und unser Plugin einbetten, können Sie unsere neuen Druckfunktionen für iOS nutzen. Verwenden Sie die Funktion PDFKit.SelectPrinter, um einen Drucker auszuwählen, und verwenden Sie dann PDFKit.Print, um mit oder ohne Dialog zu drucken. Eine Kassenanwendung kann Quittungen ohne Dialog auf dem per Skript ausgewählten Drucker drucken. Unsere MongoDB-Funktionen wurden um neue Funktionen zur Ausführung benutzerdefinierter Befehle erweitert. Wenn Sie ein Ergebnis erwarten, verwenden Sie bitte statt MongoDB.ClientCommand die MongoDB.ClientCommandQuery und führen Sie eine Schleife über die zurückgegebenen Dokumente aus. Sie können den App-Namen festlegen, der bei der Verbindung an den Server gemeldet werden soll, und die verwendeten Anmeldeinformationen abfragen. Unsere CURL-Funktionen können nun das SSL-Backend auswählen. Standardmäßig verwenden wir OpenSSL, aber Sie können mit der Funktion CURL.SetSSLBackend zu SecureTransport unter macOS oder SecureChannel unter Windows wechseln, wenn Sie die lokalen SSL-Engines bevorzugen. Das Plugin kommt mit der neuere Apple IDN-Implementierung für CURL, die wir kürzlich zum Projekt beigesteuert haben. Für die Goodies in unserem Plugin für macOS haben wir ein neues Label in der Feldauswahl, um zu der Tabelle zu springen, die Sie das letzte Mal verwendet haben. Klicken Sie einfach auf den Tabellennamen, um zu dieser Tabelle zu springen, ohne sie manuell im Popupmenü auszuwählen. Verwenden Sie die Funktion Math.MovingAverage, um den gleitenden Durchschnitt mit drei verschiedenen Modi im laufenden Betrieb zu berechnen, probieren Sie Container.RemovePreview aus, um Vorschaubilder für Container zu entfernen, und verwenden Sie GMImage.Flatten, um den Alphakanal eines Bildes zu entfernen und durch eine Hintergrundfarbe zu ersetzen. Die Funktion Overlay.Move kann animiert werden, mit Files.IsUserImmutable können Sie prüfen, ob eine Datei vom Benutzer gesperrt ist, und die WebView unter Windows kann so konfiguriert werden, dass sie PDF-Symbolleistenelemente ausblendet oder Swipes deaktiviert. Schließlich haben wir CURL auf Version 8.7.1, DynaPDF auf 4.0.87.250, LibXL auf 4.3.0, SQLAPI auf 5.3.1, SQLite auf 3.45.3 und Xcode auf Version 15.3 aktualisiert. Alle Änderungen in den Release Notes: https://monkeybreadsoftware.com/filemaker/releasenotes142.shtml Mehr Details zu den Änderungen finden Sie in den Release Notes. Nehmen Sie sich ruhig einmal die Zeit das Plugin näher anzuschauen. Probieren Sie die über 600 Beispieldatenbanken und überlegen Sie einmal, wo Sie welche Funktion in ihren Lösungen einbauen können. Systemvorraussetzungen: * macOS 10.13 oder neuer * Windows 8 und neuer, Windows 7 auf Anfrage * FileMaker Pro 7 bis 20.3 * FileMaker iOS SDK * FileMaker Server für Linux, Windows oder macOS * Claris Pro * Claris Server Lizenzen gibt es ab 119 Euro (zuzüglich MWSt) direkt auf unserer Webseite. Sie können die Plugins gerne ohne Lizenz einmal testen oder eine Trial Lizenz anfordern. Bei Fragen können Sie sich gerne auf Deutsch oder Englisch an uns wenden, per Email oder Telefon. Gerne können Sie auch auf einem FileMaker Stammtisch oder auf einer der nächsten FileMaker Konferenzen mehr erfahren. Mehr Informationen auf unserer Webseite: https://monkeybreadsoftware.com/filemaker/ Dokumentation: https://mbsplugins.eu/ Release Notes: https://monkeybreadsoftware.com/filemaker/releasenotes.shtml Mit freundlichen Grüßen Christian Schmitz Monkeybread Software

1 0

[ANN] 14.2pr5
by Christian Schmitz 08 May '24

08 May '24

Hi, * Improved DynaPDF.TestGlyphs to return error message in case you call it outside an open page. * Improved Overlay functions to resize the image automatically to fill window size on Windows. * Enabled ALTER and CREATE commands to be used on server with FM.ExecuteFileSQL function. * Fixed a bug in FM.SQL.InsertRecords that prevented containers from being transferred. * Added firstRow and lastRow parameter to FM.SQL.JSONRecords and FM.SQL.XMLRecords functions. * Added firstRow and lastRow parameter to Matrix.JSONRecords function. * Added GMImage.Flatten function to remove alpha channel from image. * Added CURL.AvailableSSLBackends and CURL.SetSSLBackend functions. * Fixed JSON.ToHTML to not show parsing errors. * Fixed an issue with EmailParser.ReceiveDate and EmailParser.SentDate function with east asia time zones. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.2pr4
by Christian Schmitz 02 May '24

02 May '24

Hi, * Built curl with our Apple IDN implementation for CURL. * Added Files.IsSystemImmutable, Files.IsUserImmutable, Files.SetSystemImmutable and Files.SetUserImmutable functions. * Improved Path.NativePathToFileMakerPath to not put in the disk name if it is already there. * Added Math.MovingAverage function. * Improved control placing for newer FileMaker version for AVPlayer, DragDrop, MapView and WebViewer. * Improved FM.SQL.JSONRecords function to return empty array for empty result. * Added JSON.ReplaceEvaluate function and related JSON.CurrentMatch and JSON.CurrentMatchPath functions. * Added flag value 2 for JSON.ToHTML function to process embedded JSON. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0