- MBS FM Plugin - lists.monkeybreadsoftware.com

[ANN] 14.4pr6
by Christian Schmitz 11 Sep '24

11 Sep '24

Hi, * Updated LibXL to version 4.4.0. * Improved CURL.GetResultAsEMailList function, so it includes In-Reply-To and References headers if you have them in the query. * Fixed thread naming to avoid renaming main thread. * Updated LibXL to version 5.3.4 with DuckDB 1.0 support. * Added XL.Book.RemovePrinterSettings and XL.Book.RemoveVBA functions. * Added DynaPDF.CreateExtGState and DynaPDF.SetExtGState functions. * Added FieldName entry for FM.FieldStatistics function result. * Improved JSON functions to return error if you pass non JSON parameters to JSON.AddItemToArray, JSON.AddItemToObject, JSON.Replace and related functions. * Fixed crash in DynaPDF.GetFontsAsJSON function for font with missing values. * Fixed possible crashes with Phidgets script triggers. * Updated CURL to version 8.10.0. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

Deprecation of TLS 1.0 and 1.1
by Christian Schmitz 10 Sep '24

10 Sep '24

Hello, Anyone still needs TLS 1.0 and 1.1 when working with MBS Plugins? OpenSSL plans to disable them by default. We should do the same. Everyone moved to TLS 1.2 and 1.3 as far as we know, so nobody should need the older one. The version 1.2 was published in 2008 and most browser already removed support for the older ones. The older versions had weak ciphers and digest algorithms which shouldn't be used anymore. It's too easy to attack such connections and be the man in the middle, who could decipher the content. Let us know if you still need older versions. Otherwise they will get disabled in future plugins, probably next year. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.4pr5
by Christian Schmitz 29 Aug '24

29 Aug '24

Hi, * Added JSON.DeleteRecord and JSON.DeleteRecords functions. * Updated DynaPDF to version 4.0.92.261. * Added DynaPDF.TestPassword function. * Added BaseFont as selector for DynaPDF.SysFontInfo function. * Added BaseFont value to JSON for DynaPDF.SysFontInfoAsJSON function. * Changed linux version to include version number and build number for Get(InstalledFMPlugins). Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.4pr3
by Christian Schmitz 21 Aug '24

21 Aug '24

Hi, * Updated SQLite to version 3.46.1. * Updated DynaPDF to version 4.0.91.260. * Fixed a bug in FM.FieldStatistics function. Now properly quotes field names. * Added WebHook.GetTag, WebHook.SetTag, WebRequest.GetTag and WebRequest.SetTag functions. * Added ClearBuffer parameter to WebRequest.GetRawData function. * Improved Twain.Initialize to return better error messages on Windows. * Improved GMImage.ReadContainer to better pick decoder based on file name. * Added tooltips for specify field dialog to show field type. * Changed tooltips to show container instead of binary, text instead of varchar. * Improved Archive functions and UnZipFile.OpenContainer function to better read zip archives downloaded via Insert From URL script step. * Improved PDFKit.RestorePrintSettings to better read PDF from container. * Added DynaPDF.GetInEncryptionInfo function. * Fixed a problem in Files.RenameFile function to rename folders on Windows if the path ended with a backslash. * Added DynaPDF.CreateURIAction function. * Fixed a problem with GMImage.NewFromFile and Japanese characters on Windows. * Added JSON.InsertRecord function. * Added JSON.UpdateRecord and JSON.UpdateRecords functions. * Added Flags parameter for DynaPDF.ExtractDocumentText function. * Updated CURL to version 8.9.1. * Updated openssl to version 3.1.6. Download here: https://www.monkeybreadsoftware.com/filemaker/files/Prerelease/ Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.4pr2
by Christian Schmitz 01 Aug '24

01 Aug '24

Hi, * Added OptionsJSON parameter for MongoDB.ReplaceOne function. * Added FM.FieldStatistics function. * Fixed incorrect returning of result for DynaPDF.SetRenderingIntent, DynaPDF.SetUserUnit and DynaPDF.SetLineWidth functions. * Updated DynaPDF to version 4.0.90.257. * Changed plugin to return empty results as really empty and trace to log that as nothing. It makes a difference whether we return nothing or empty text. * Added shortcut for layout editor to use Command-Option-Shift-F on macOS to jump to the objects search field. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.4pr1
by Christian Schmitz 24 Jul '24

24 Jul '24

Hi, Let's start a new round for MBS Plugin development: * Improved check to XL.Initialize to return an error if the license key includes invalid characters like a space character. * Fixed an issue in SyntaxColoring.AutoCompleteVariables.SetGlobals function. * Fixed DynaPDF.ImportPDFFile to return proper error message. * Upgraded all linux compilers to newer versions. * Reduced number of dependencies on Linux version of our plugin. Requires GLIBCXX_3.4.26 now. * Disabled trace logging for MongoDB by default. Was accidentally enabled. * Fixed a bug with Matrix.Text function where it would skip some columns if they were constants in SQL used to create the matrix. * Fixed a problem with AVRecorder.AddPreviewWithControl positioning the layer for FileMaker 21. * Added Text.Tidy and Text.TidyErrorLog functions to tidy XML and HTML. * Added Text.HTMLtoJSON function. * Added XML.Tidy function. * Changed JSON.GetArrayItemsAsList to return empty result if JSON is empty. * Added MongoDB.CursorRecords function. * Fixed a memory leak in Clipboard.SetFileMakerData, Clipboard.DetectFileMakerDataType and XML.Import functions. * Improved MapView.PlanRoute function to use less memory. 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

[ANN] MBS Plugin 14.3 for Claris FileMaker - More than 7400 Functions In One Plugin
by Christian Schmitz 09 Jul '24

09 Jul '24

Nickenich, Germany - (July 9th, 2024) -- Monkeybread Software today is pleased to announce MBS Plugin 14.3 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.3 has been updated and now includes over 7400 different functions, and the versatile plugin has gained more new functions: Use Python scripts in your FileMaker scripts. Use our Python functions to load a local Python library and evaluate expressions or run scripts. Get and set variables in Python to exchange data in memory. The Python code can optionally query records from FileMaker using ExecuteSQL or Evaluate functions. Our CURL functions got enhanced to better handle MQTT connections. Use CURL.SetMQTTScript to set a script to be called when messages arrive and CURL.GetMQTTMessages to get the received messages. The debug log shows the URL for the request for helping you to debug the scripts. If you use our Drag & Drop functions, you can use an overlay window as the drop target. Use DragDrop.AttachToOverlay function to attach a drop area on the overlay and let the user drop files on the overlay. Your script decides what to do with the files. We got the WebView.SetVirtualHostNameToFolderMapping function to create new virtual host mapping for the WebViewer on Windows. It allows you to redirect requests to a specific domain to html files in a local folder. We added six more SetTag functions for CFunction, CLibrary, Dictionary, Java, Mutex, and Schedule objects. This allows you to store additional information with the plugin object, e.g. a record identifier. In DynaPDF you can now keep annotations from flattening in DynaPDF.FlattenAnnots function, if DynaPDF doesn't recognize them. The DynaPDF.Parser.FindText function can now skip sorting with the new SearchAsIs flag. You can enable an image cache for DynaPDF and change line annotation's coordinates. Our calculation dialog tools got updated to allow using shift key to check syntax, evaluate or format only a selection of text. The code formatting can now detect lines with semicolon first and format the whole text this way. You can pre fill the list of global variables for auto complete with a list of names with SyntaxColoring.AutoCompleteVariables.SetGlobals function. We fixed the UNNotification functions to work better in FileMaker 21, the SystemInfo.isSequoia can detect the next MacOS version and SystemInfo.MacMemoryHostStatistics provides detailed memory statistics. Use Window.HasFormattingBar to check if FileMaker shows the formatting bar in FileMaker Pro on macOS and Windows. Use FM.RecordStatistics to query size of a record and use Archive.CompressText to add text to a new archive. Finally we updated CURL to version 8.8.0, DynaPDF to 4.0.89.256, SQLAPI to 5.3.2, SQLite to 3.46.0, LibXL to 4.3, the plugin SDK and Xcode to version 15.4. See release notes for a complete list of changes: https://monkeybreadsoftware.com/filemaker/releasenotes143.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 21.0 * 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.3 für Claris FileMaker - Über 7400 Funktionen in einem Plugin
by Christian Schmitz 09 Jul '24

09 Jul '24

9. Juli 2024 - Monkeybread Software veröffentlicht heute das MBS Plugin für Claris FileMaker in Version 14.3, mit inzwischen über 7400 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen: Verwenden Sie Python-Scripts in Ihren FileMaker-Scripts. Verwenden Sie unsere Python-Funktionen, um eine lokale Python-Bibliothek zu laden und Berechnungen auszuwerten oder Scripts auszuführen. Holen und setzen Sie Variablen in Python, um Daten im Speicher auszutauschen. Der Python-Code kann optional mit ExecuteSQL oder Evaluate-Funktionen Daten aus FileMaker abfragen. Unsere CURL-Funktionen wurden verbessert, um besser mit MQTT-Verbindungen umgehen zu können. Verwenden Sie CURL.SetMQTTScript, um ein Skript zu setzen, das aufgerufen wird, wenn Nachrichten ankommen, und CURL.GetMQTTMessages, um die empfangenen Nachrichten abzufragen. Das Debug-Protokoll zeigt die URL für die Anfrage an, um Ihnen bei der Fehlersuche in den Skripten zu helfen. Wenn Sie unsere Drag & Drop-Funktionen verwenden, können Sie ein Overlay-Fenster als Drop-Ziel verwenden. Verwenden Sie die Funktion DragDrop.AttachToOverlay, um einen Drop-Bereich auf dem Overlay anzulegen. Der Benutzer kann dann Dateien auf das Overlay ziehen. Ihr Skript kann dann entscheiden, was Sie mit den Dateien machen. Wir haben die Funktion WebView.SetVirtualHostNameToFolderMapping, um eine neue virtuelle Host-Zuordnung für den WebViewer unter Windows zu erstellen. Damit können Sie Anfragen an eine bestimmte Domäne auf HTML-Dateien in einem lokalen Ordner umleiten. Wir haben sechs weitere SetTag-Funktionen für CFunction-, CLibrary-, Dictionary-, Java-, Mutex- und Schedule-Objekte hinzugefügt. Damit können Sie zusätzliche Informationen mit dem Plugin-Objekt speichern, z. B. einen Primärschlüssel. In DynaPDF können Sie nun bei der DynaPDF.FlattenAnnots Funktion verhindern, dass Anmerkungen eingeebnet werden, wenn DynaPDF sie nicht erkennt. Die DynaPDF.Parser.FindText Funktion kann jetzt mit dem neuen SearchAsIs Flag die Sortierung überspringen. Sie können einen Bild-Cache für DynaPDF aktivieren und die Koordinaten von Linienanmerkungen ändern. Unsere Berechnungsdialog-Tools wurden aktualisiert und erlauben nun die Verwendung der Umschalttaste, um die Syntaxprüfung, das Formatieren oder Ausführen auf eine Textauswahl zu beschränken. Die Code-Formatierung kann nun Zeilen mit Semikolon am Anfang erkennen und den gesamten Text auf diese Weise formatieren. Mit der Funktion SyntaxColoring.AutoCompleteVariables.SetGlobals kann die Liste der globalen Variablen für die automatische Vervollständigung mit einer Liste von Namen vorbelegt werden. Wir haben die UNNotification-Funktionen verbessert, damit sie in FileMaker 21 besser funktionieren, SystemInfo.isSequoia kann die nächste MacOS-Version erkennen und SystemInfo.MacMemoryHostStatistics liefert detaillierte Speicherstatistiken. Verwenden Sie Window.HasFormattingBar, um zu prüfen, ob FileMaker die Formatierungsleiste in FileMaker Pro unter macOS und Windows anzeigt. Verwenden Sie FM.RecordStatistics, um die Größe eines Datensatzes abzufragen, und verwenden Sie Archive.CompressText, um einem neuen Archiv Text hinzuzufügen. Schließlich haben wir CURL auf Version 8.8.0, DynaPDF auf 4.0.89.256, SQLAPI auf 5.3.2, SQLite auf 3.46.0, LibXL auf 4.3, das Plugin SDK und Xcode auf Version 15.4 aktualisiert. Alle Änderungen in den Release Notes: https://monkeybreadsoftware.com/filemaker/releasenotes143.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 21.0 * 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.3pr7
by Christian Schmitz 05 Jul '24

05 Jul '24

Hi, * Added SyntaxColoring.AutoCompleteVariables.GetGlobals and SyntaxColoring.AutoCompleteVariables.SetGlobals functions. * Added TotalSize entry for FM.TableStatistics and FM.RecordStatistics. * Added FileName and Encoding parameters for Archive.CompressText function. * Added Archive.Content, Archive.Extract, Archive.ExtractFile, Archive.FileList and Archive.GZipDecompress functions. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.3pr6
by Christian Schmitz 01 Jul '24

01 Jul '24

Hi, * Fixed DynaPDF.DeletePage to return remaining pages on success. * Improved JSON.SetPathItem to take the given value as text if it doesn't parse as JSON. * Added Window.HasFormattingBar function. * Added DragDrop.AttachToOverlay function to accept drops on an overlay. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0