Check out the FMTraining.tv website. Richard Carlton and his team do a daily free live stream about FileMaker to watch.
A few days ago Christian Schmitz from Monkeybread Software joined a live episode to talk a bit about the MBS FileMaker Plugin. Watch it on YouTube.
We check what is new in 14.4 release: Announcements, new functions and Release Notes.
(more)
Back from the conference in Liechtenstein, I wrote down a few of the tidbits we learnt.
Missing serial numbers
If you use serial numbers for new records in FileMaker, you may notice that sometimes the serial numbers have a gap. Why could this happen?
- Someone deleted a record
- Someone created a record, but never committed it.
- FileMaker crashed or network got disconnected while a transaction runs, so it never completes.
You need to know that on record creation, the client will request a new serial number from the server. If the record doesn't get committed or gets reverted, the serial value is used, but no record saved. If you like to make sure the serial number doesn't get lost, please call Commit script step after creating the new record to make sure the empty record is definitely stored.
Please consider moving to UUID numbers instead, so people can't get the serial numbers and they are more random but unique.
(more)
New in this prerelease of the 24.5 plugins:
- Added WillPopUp, WillDismiss, SelectionIsChanging and SelectionDidChange events to NSComboBoxControlMBS control.
- Updated DynaPDF to version 4.0.94.265.
- Added GetTextBBox and GetAnnotColor functions to DynaPDFMBS class.
- Fixed an edge case with swiss keyboard layout for PressKey function in RemoteControlMBS module and the virtual key lookup.
Download:
monkeybreadsoftware.de/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared DropBox folder.
You can subscribe to our Xojo mailing list to get notified for new pre-release and release versions.
New in this prerelease of version 14.5 of the
MBS FileMaker Plugin:
- 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.
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/
You can subscribe to our FileMaker mailing list to get notified for new pre-release and release versions.
Recently someone asked about comments for a table and whether we could do something there. In the FileMaker community you find a couple of ideas around this topic, so we through why not. Let us add a comment text for the table definition section of the manage database dialog.
But we run into a couple of questions like where to store comments. Should the plugin store them somewhere or should FileMaker store them. Would we have some kind of user interface to enter the comment?
We can't just store comments in a local preferences file since others would open the database file and miss the comments. We can't store them in a new separate table as that would not survive clone and migration process. We decided to leverage the existing field comments in FileMaker to define a new field _TableComment to store it. Just define a field (can be global) and add a comment there. FileMaker stores the comment and provides the user interface to enter it.
(more)
This Release Includes:
- Preemptive Threading
- Android tablet support
- Web supports adding CSS classes to controls
- Code Editor improvements: Row highlighting, command bar button for Standardize Format, and Syntax Help area size control
- Web now uses Bootstrap v5.3.3 and Bootstrap Icons v1.11.3
- macOS Popovers can be resized
- Windows HTMLViewer can now access camera and microphone
- iOS Picture can now access EXIF metadata
- Android improved Declare support
- Android RegEx classes
The complete list of improvements can be found in the Release Notes. Download here
MBS Plugins 24.3 and later work fine with Xojo 2024r3.
New in this prerelease of the 24.5 plugins:
- Fixed crash with running Python on Windows.
- Updated DynaPDF to version 4.0.93.262.
- Updated CURL to version 8.10.1.
- Added GetAnnotTextAlign function to DynaPDFMBS class.
- Updated to libxml2 version 2.13.4.
- Updated to libxslt version 1.1.42.
- Updated OpenSSL to version 3.3.2.
- Note: SSLv3 is disabled now.
- Removed outdated CKFetchNotificationChangesOperationMBS, CKModifyBadgeOperationMBS and CKMarkNotificationsReadOperationMBS classes.
- Updated to Xcode 16.0.
- Updated jpeg library to version 9.6.
- Using REALCopyStringCFString on iOS to quicker get CFString from Xojo String.
- Fixed CURLSMultiMBS class, broken in 24.4.
- Added scroll methods for NSViewMBS class.
- Added sendAction method for NSControlMBS class.
- Added more properties for ArchiveEntryMBS class.
- Updated libarchive to version 3.7.6.
- Updated discount library to version 2.2.7d.
- Improved exception handling for ReSVGMBS class.
- Updated unicode tables for removing accents for RemoveAccentsMBS function.
- Added abortEditing method to NSControlMBS class.
Download:
monkeybreadsoftware.de/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared DropBox folder.
You can subscribe to our Xojo mailing list to get notified for new pre-release and release versions.
New in this prerelease of version 14.5 of the
MBS FileMaker Plugin:
- 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
monkeybreadsoftware.com/filemaker/files/Prerelease/
You can subscribe to our FileMaker mailing list to get notified for new pre-release and release versions.
In this article we want to introduce you the new functions from the MBS FileMaker Plugin in version 14.4.
JSON
We have added a couple of JSON functions for you that you can use to create, update or delete records in your database. With the JSON.InsertOrUpdateRecord function, you even have the option of changing a data record if it already exists or creating a new one if it does not exist yet. With JSON.UpdateRecords and JSON.DeleteRecords, not only one record can be changed or deleted, but several records can be modified or removed at the same time. If you only want to create, change or delete one data record, you can use the JSON.InsertRecord, JSON.UpdateRecord or JSON.DeleteRecord functions. So that we know which data record we are addressing with JSON.UpdateRecord, for example, we first specify the file name in the parameters of the functions, as we get it from the FM function Get(FileName). This is followed by the table name and the primary key of the data record. For updating, we then also specify the value that we want to update.
(more)
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.
(more)
Zu keinem anderen Thema haben aus dem deutschsprachigen Raum so viele Fragen in den letzten Wochen und Monaten bekommen als zu dem Thema E-Rechnung. Ab 2025 müssen die meisten Unternehmen E-Rechnungen zumindest empfangen und lesen können. Im Verlauf der nächsten Jahre müssen sogar kleine Unternehmen E-Rechnungen ausstellen können. Dass die Nachfrage groß ist ist verständlich und so haben wir unsere, bereits seit Jahren existierenden Beispiele, noch einmal überarbeitet und auf den momentanen Stand gebracht.
Das überarbeite Beispiel ZUGFeRD Rechnung erstellen.fmp12 zeigt Ihnen wie Sie mit Hilfe von MBS und einer DynaPDF Professional Lizenz mit PDF/A Erweiterung eine ZUGFeRD Rechnung nach EN 16931 erstellen können. Wir haben dabei die notwendigen, wie auch vereinzelt für uns zusätzlich nützlich erscheinende Informationen, in die Rechnung übernommen. Das Beispiel ist ZUGFeRD in Version 2.2.
Mit der ZUGFeRD Rechnung auslesen.fmp12 Datei stellen wir Ihnen eine Datei zur Verfügung die alle Informationen aus Rechnungen nach EN 16931 ausliest und Ihnen diese darstellt. Das ermöglicht Ihnen ein Script zu schreiben in dem Sie die Feldwerte aus unserem Beispiel in die Felder Ihres bereits bestehenden Rechnungsprogrammes überführen.
(more)
Let's say you received an electronic invoice in Germany or France as a PDF document with embedded XML. You like tp use DynaPDF to extract the XML and we have a sample file for you, which we like to explain here. So let's take a look on the main script to extract the attachment with the XML.
First we initialize DynaPDF and have the script load the dynapdf library. Then we open the invoice PDF with DynaPDF.OpenPDFFromContainer function and then use DynaPDF.ImportPDFFile function to import the content of the PDF into memory into the working PDF.
# Make new PDF environments
Set Variable [ $pdf ; Value: MBS("DynaPDF.New") ]
# Load PDF from container
Set Variable [ $r ; Value: MBS("DynaPDF.OpenPDFFromContainer"; $pdf; ZUGFeRD Extract XML::Input PDF) ]
Set Variable [ $r ; Value: MBS("DynaPDF.ImportPDFFile"; $pdf) ]
(more)
Sometimes you may work on a project for macOS where it would be useful to know the location of the computer. You can use CoreLocation classes in MBS Xojo Plugins to query the location, but maybe it is not available, so lets check status.
We can ask locationServicesAvailable to check whether the API is available and use locationServicesEnabled to check whether it is enabled. Nowadays most Macs have location enabled, but sometimes in a cooperate environment, it may be turned off. If turned off, we can stop bothering asking the user.
Sub Init()
If Not MyLocationManager.locationServicesAvailable Then
MsgBox "Location Services are not available."
end if
if not MyLocationManager.locationServicesEnabled then
MsgBox "Location Services are not enabled."
end if
End
(more)
A few days ago we got a request on whether we can directly integrate ChatGPT to the ScriptWorkspace in FileMaker. Since we have already plenty of extensions to the ScriptWorkspace on macOS, we can just add a menu command for this. For Windows, the same thing could be done as a hotkey.
If you like to use this, you need to have your own API key and organization ID for ChatGPT and please insert it right into the sample code. Once you have the Let statement, you can pass it to the SyntaxColoring.AddContextMenuCommand function to add as a menu command.
To get the Let statement below, we started with a short script to use our CURL functions to query a completion via ChatGPT. We create the CURL session, set the URL and headers with the authentication details. Then we build the JSON with the request to have our prompt to summarize and the user text to process. Once we set the post content, we run the request and on success pick the output from the JSON and show it with a message box:
(more)
Nickenich, Germany - (September 17th, 2024) -- Monkeybread Software today is pleased to announce MBS FileMaker 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.
Nickenich, Germany - (September 17th, 2024) -- Monkeybread Software today is pleased to announce MBS Xojo Plugins 24.4 for macOS, Linux and Windows, the latest update to their product that is easily the most powerful plugin collection currently available for Xojo. MBS Xojo Plugins have been updated and now includes over 3000 classes and 82,000 documented features, and the versatile plugins have gained more new functions:
Use the ZxingBarcodeMBS module with the functions there to read barcodes from images. We support 18 different types of barcodes including EAN, UPC and QRCodes.
We improved our Linux support by using newer compilers for all 4 Linux targets: 32- and 64-bit on ARM or x86 architecture. This enables 32-bit Linux support for newer parts of our plugins. You can use JSONMBS class, Phidget classes, LibUSBTransferMBS class and XL classes there.
Use Handoff to continue tasks on your other devices with macOS or iOS. The NSUserActivityMBS class helps you to implement this in your Xojo project and pass the current state from one device to the other device.
If you use CURL to retrieve emails from your IMAP server, please use the DecodeIMAPFolderName function to decode folder names from UTF-7 encoding. You can specify not just the minimum required TLS version, but also the maximum and we have new constants for these. We improved CURLSMultiMBS class to let you better reuse CURL objects.
Showing a statusitem in the Mac menubar can be done with our NSStatusItemMBS class. Use the new DidMove and DidResize events to notice if the statusitem moved. The DidChangeOcclusionState event tells you if the statusitem got hidden when the screen resolution is too low to show all statusitems.
With DynaPDF you can query the encryption state of the file with the GetInEncryptionInfo function and the DynaPDFEncryptInfoMBS class. The TestPassword function and verify whether a password is correct.
We improved the MongoDB classes with better trace logging. The MongoCursorMBS class can now provide all records as one big JSON string.
The TidyDocumentMBS class got a Tidy() function to make the usage easier and tidy up XML and HTML with a function call. You can list all option names with the OptionNames function.
The NetSNMPMBS class got new properties for SNMPv3 support, the NSViewMBS class got a hitTest() function to find a view in the hierachie based on screen coordinates and in SceneKit you can specify shader modifiers with new properties in SCNMaterialMBS and SCNGeometryMBS classes.
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, SQLite to 3.46.1 and Tidy library to version 5.8.
See release notes for a complete list of changes.
17. September 2024 - Monkeybread Software veröffentlicht heute das MBS FileMaker 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.
When it comes to handling PDF documents, FileMaker developers have a robust ally in DynaPDF and the MBS FileMaker Plugin. This powerful combination opens up a world of possibilities for creating, modifying, and managing PDF files directly within your FileMaker solutions. Let’s dive into the key capabilities that DynaPDF and the MBS FileMaker Plugin bring to the table.
For each point we can link to the relevant functions and on the documentation pages, you find listed examples and further blog articles.
1. Create PDFs from Scratch
With DynaPDF and the MBS FileMaker Plugin, you can effortlessly generate PDF files directly from FileMaker. Whether you need to create a professional invoice, a custom report, or any other document, you have full control over the layout and content. You can incorporate text, images, and graphics to design documents that align perfectly with your needs. This functionality allows for seamless integration of data from FileMaker into beautifully formatted PDFs.
See DynaPDF.New and then DynaPDF.AppendPage to add pages.
(more)
In general we recommend you use a recent Windows version and a recent Linux distribution, so you have all the security fixes. But sometimes we get asked about support of older versions.
We tried the upcoming 24.4 plugins on Windows 7, Windows 8 and Ubuntu 18 to verify what works. Here are the results:
(more)