- MBS FM Plugin - lists.monkeybreadsoftware.com

[ANN] 14.5pr4
by Christian Schmitz 25 Oct '24

25 Oct '24

Hi, * Fixed a problem with Preview, MapView, DragDrop and ImageView controls to avoid control disappearing. * Added FM.UpdateRecord4, FM.UpdateRecord5, FM.UpdateRecords4 and FM.UpdateRecords5 functions. * Added MYSQL_OPT_LOCAL_INFILE option for SQL.SetConnectionOption for use with MySQL connections. * Fixed SharedMemory.GetValue and SharedMemory.SetValue functions to work with empty values. * Added SharedMemory.DeleteValue function. * Removed the dependency on VCRUNTIME140_1.DLL file. * Fixed an edge case with plugin registration. * Added WordFile.GetProperty and WordFile.SetProperty functions. * Improved FM.TableStatistics function to ignore summary fields. * Improved FM.QueryBaseTableNames to use newer API in FileMaker 21.0 and newer. * Added Overlay.AddWebViewer function. * Updated SQLite to version 3.47.0. * Added List.Intersection function. * Improved styled text conversion on macOS to include better support for highlight, underline and strikethrough, e.g. for RichText.SetFormattedText and Clipboard.SetStyledText functions. 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

Switched web shop to FastSpring
by Christian Schmitz 17 Oct '24

17 Oct '24

Hello, Due to trouble with MyCommerce, we switched the website ordering to FastSpring. Please don't use any old links you got from us, which may point to the old shop. If you like to order, you can always email me directly for an order link. Or to setup a custom invoice for wired bank transfer or Paypal. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.5pr3
by Christian Schmitz 17 Oct '24

17 Oct '24

Hi, * Added Math.Rate function. * Improved custom function auto complete to cache table and field names. * Changed Barcode.Generate, Barcode.GenerateJSON and Barcode.WriteFile to use 4 as default scale. * Added Vision.RectifyDocument function. * Updated for next FileMaker version. * Implemented Process.List for Linux. * Updated plugin SDK. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.5pr2
by Christian Schmitz 07 Oct '24

07 Oct '24

Hi, * Added field comment to the tooltips for the export dialog. * Fixed an issue in Window.PositionNextDialog function for Windows. * Updated DynaPDF to version 4.0.94.265. * Added DynaPDF.GetAnnotColor and DynaPDF.GetTextBBox functions. * Fixed an edge case with swiss keyboard layout for RemoteControl.PressKey function and the virtual key lookup. * Added sample script into extras to launch two FileMaker on macOS, one with HTTP tunneling on and one with it being off. * Optimized XML functions to better handle thread locking. * Improved error handling for XML.ApplyStylesheet. * Added some auto complete for custom functions for parameters and function names: * Table occurrences * Field names after :: * Operator names * Function names from function list * Parameter names * Get/Hole/Obtenir functions Invoke with fn-F5 in the dialog or we auto invoke it for you. Best regards, Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

1 0

[ANN] 14.5pr1
by Christian Schmitz 01 Oct '24

01 Oct '24

Hi, Let's start a new round for MBS Plugin development: * Updated DynaPDF to version 4.0.93.262. * Updated CURL to version 8.10.1. * Fixed crash with running Python on Windows. * Added DynaPDF.GetAnnotTextAlign function. * Added DynaPDF.ClearLicense function. * Added JSON.InsertRecords function to insert array of records in JSON. * Updated to libxml2 version 2.13.4. * Updated to libxslt version 1.1.42. * Updated LibXL to version 4.4.0. * Updated OpenSSL to version 3.3.2. * Note: SSLv3 is disabled now. * Updated libarchive to version 3.7.6. * Changed Archive.Content to skip GID, UID, Permissions, RDev, FileType and HardLink fields, if not set. * Updated zxing library to newer branch. * Improved Barcode.Detect by using newer zxing library. * Added Barcode.DetectAsJSON function. * Updated to Xcode 16.0. * Updated jpeg library to version 9.6. * Fixed CURL Multi functions, broken in 14.4. * Added a field to database design dialog for tables to show comments. To add a comment, define a field _TableComment and put comment text there. * Fixed an issue with GMImage.WriteToPDFContainer and TWAIN.Acquire on Windows. * Added Text.FilterSwissQRCode function. * Added DynaPDF.GetGlyphIndex and DynaPDF.GetGlyphOutline functions. * Updated discount library to version 2.2.7d. * Added Audit.BuildCaches function. * Updated unicode tables for removing accents for Text.RemoveAccents function. 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

Add the Saxon processor to MBS Plugins?
by Christian Schmitz 24 Sep '24

24 Sep '24

Hello, For years we had XLST 1.0 and XQuery in the plugins using open source libraries. We could add the Saxon processor library for XLST, XQuery and XML Schema functionality. But that library has a cost as a commercial library, so making a plugin would only work if we have enough people taking it. We are collecting a list of developers interested in this to know whether it is feasible to do this. We could have: • XSLT 3.0 Processor Saxon Professional supports the latest version of XSLT (3.0) for transforming XML documents into various formats (HTML, text, other XML formats). It supports full XPath 3.1 and XQuery 3.1 standards. • XPath 3.1 Support XPath is a language for navigating through elements and attributes in an XML document. Saxon Professional provides comprehensive support for XPath 3.1, allowing complex expressions for querying and filtering XML data. • XQuery 3.1 Support XQuery is used for querying XML data. Saxon Professional Edition supports XQuery 3.1, which is highly flexible and useful for querying both XML and non-XML data sources. • Streaming for XSLT 3.0 Streaming allows Saxon to process large XML files that do not fit into memory by reading the document sequentially. This is essential for dealing with very large documents efficiently. • Schema-Aware XSLT and XQuery Saxon Professional Edition is schema-aware, meaning it can process and validate XML documents against XML Schema definitions. This ensures data integrity and adherence to data structures during transformation or query. • EXSLT Support Saxon includes support for EXSLT, which is a set of extensions to XSLT. These extensions provide additional functions for working with strings, dates, numbers, and more. • JSON Processing In addition to XML, Saxon/C++ can process JSON documents. It can convert JSON to XML for XSLT processing or use XPath/XQuery directly on JSON data, making it versatile for different data formats. • Serialization Features It provides advanced serialization options, including support for JSON output, binary data formats, and text formats, making it versatile for different kinds of output requirements. We got a prototype working and now look for interested FileMaker developers interested in this functionality. Let us know whether you are interested. We will probably make it an add-on to our plugins to pay an extra licensing fee. Then we would add Saxon features to our plugin over time. Please let us know if you would be interested to have Saxon library available for use in your projects. Greetings Christian -- See you at the EngageU FileMaker conference in Malmö, Sweden 17th - 19th of November 2024 https://engageu.eu/

1 0

[ANN] MBS Plugin 14.4 for Claris FileMaker - More than 7400 Functions In One Plugin
by Christian Schmitz 17 Sep '24

17 Sep '24

Nickenich, Germany - (September 17th, 2024) -- Monkeybread Software today is pleased to announce MBS Plugin 14.4 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.4 has been updated and now includes over 7400 different functions, and the versatile plugin has gained more new functions: We got a few convenience functions to do database operations and pass record data as JSON. Use JSON.InsertRecord to create a new record and pass values for fields as JSON. Our plugin will detect the field types and correctly handles number, date, time and timestamp fields. You can update a record with the JSON.UpdateRecord function and provide the new field values as well as the primary key to find the record. Use JSON.UpdateRecords to update multiple records. The JSON.InsertOrUpdateRecord function goes a step further and updates an existing record. If none exists, it creates a new record. And finally you can delete one record with JSON.DeleteRecord function or multiple with JSON.DeleteRecords function. The tidy library allows us to cleanup and repair both XML and HTML. The XML.Tidy function fixes XML. And Text.Tidy function can do HTML, too. If you need to parse HTML, please use Text.HTMLtoJSON function to convert HTML to JSON and then process the JSON. Use DynaPDF.CreateExtGState to create a new extend graphics state and activate it with DynaPDF.SetExtGState function to use transparency in vector graphics, control overprint and rendering intent. We can create URL actions to have a button open an URL. You can query encryption information for a file and test whether a password is valid. We added MongoDB.CursorRecords to query the JSON for all found records. The MongoDB.ReplaceOne function takes options and we improved the MongoDB logging. On macOS you can use Command-Option-Shift-F shortcut in layout editor to jump to the object search field. With SyntaxColoring.AutoCompleteVariables.SetLocals you can set a list of variables to always show up in auto complete. And the dialog to specify a field shows the field type in a tooltip. The XL functions can now remove printer settings and VBA scripts from an Excel document. Use FM.FieldStatistics function to query size statistics for a field in a table over all records. The Python.RunFile function allows to run a Python script from disk. Finally we updated CURL to version 8.10.0, DynaPDF to 4.0.92.261, LibXL to 4.4.0, openssl to 3.1.6, SQLAPI to 5.3.4 with DuckDB 1.0 support and SQLite to version 3.46.1. See release notes for a complete list of changes: https://monkeybreadsoftware.com/filemaker/releasenotes144.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.x * 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.4 für Claris FileMaker - Über 7400 Funktionen in einem Plugin
by Christian Schmitz 17 Sep '24

17 Sep '24

17. September 2024 - Monkeybread Software veröffentlicht heute das MBS Plugin für Claris FileMaker in Version 14.4, mit inzwischen über 7400 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen: Wir haben ein paar praktische Funktionen, um Datenbankoperationen durchzuführen und Datensätze als JSON zu übergeben. Verwenden Sie JSON.InsertRecord, um einen neuen Datensatz zu erstellen und Werte für Felder als JSON zu übergeben. Unser Plugin erkennt die Feldtypen und behandelt Dezimal-, Datums-, Zeit- und Zeitstempelfelder korrekt. Sie können einen Datensatz mit der Funktion JSON.UpdateRecord aktualisieren und die neuen Feldwerte sowie den Primärschlüssel übergeben, um den Datensatz zu finden. Verwenden Sie JSON.UpdateRecords, um mehrere Datensätze zu aktualisieren. Die Funktion JSON.InsertOrUpdateRecord geht noch einen Schritt weiter und aktualisiert einen vorhandenen Datensatz. Wenn kein Datensatz vorhanden ist, wird ein neuer Datensatz erstellt. Und schließlich können Sie einen Datensatz mit der Funktion JSON.DeleteRecord oder mehrere Datensätze mit der Funktion JSON.DeleteRecords löschen. Die Tidy-Bibliothek ermöglicht es uns, sowohl XML als auch HTML zu bereinigen und zu reparieren. Die Funktion XML.Tidy bereinigt XML. Und die Funktion Text.Tidy kann zusätzlich HTML reparieren. Wenn Sie HTML parsen müssen, verwenden Sie bitte die Funktion Text.HTMLtoJSON, um HTML in JSON zu konvertieren und dann das JSON zu verarbeiten. Verwenden Sie DynaPDF.CreateExtGState, um einen erweiterte Grafikstatus zu erstellen. Setzen Sie ihn mit der Funktion DynaPDF.SetExtGState, um Transparenz in Vektorgrafiken zu verwenden, Überdrucken und Rendering Intent zu steuern. Wir können URL-Aktionen erstellen, damit eine Schaltfläche eine URL öffnet. Sie können Verschlüsselungsinformationen für eine Datei abfragen und prüfen, ob ein Passwort gültig ist. Verwenden Sie MongoDB.CursorRecords um ein JSON für alle gefundenen Datensätze abzufragen. Die Funktion MongoDB.ReplaceOne akzeptiert Optionen und wir haben die MongoDB-Protokollierung verbessert. Unter macOS können Sie die Tastenkombination Befehl-Option-Shift-F im Layout Modus verwenden, um zum Objektsuchfeld zu springen. Mit SyntaxColoring.AutoCompleteVariables.SetLocals können Sie eine Liste von Variablen festlegen, die beim Auto Complete immer angezeigt werden. Und der Dialog zur Angabe eines Feldes zeigt den Feldtyp in einem Tooltip an. Die XL-Funktionen können nun Druckereinstellungen und VBA-Skripte aus einem Excel-Dokument entfernen. Mit der Funktion FM.FieldStatistics können Sie Größenstatistiken für ein Feld in einer Tabelle über alle Datensätze abfragen. Die Funktion Python.RunFile ermöglicht die Ausführung eines Python-Skripts von der Festplatte. Schließlich haben wir CURL auf Version 8.10.0, DynaPDF auf 4.0.92.261, LibXL auf 4.4.0, openssl auf 3.1.6, SQLAPI auf 5.3.4 mit DuckDB 1.0 Unterstützung und SQLite auf Version 3.46.1 aktualisiert. Alle Änderungen in den Release Notes: https://monkeybreadsoftware.com/filemaker/releasenotes144.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.x * FileMaker iOS SDK * FileMaker Server für Linux, Windows oder macOS 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.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