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.
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)
We recently got the 60th live stream on
FMTraining.tv with Christian Schmitz talking about MBS Plugin for FileMaker. Richard and his team even prepared a cake for this event. 60 sessions in about 3 years is a lot and we like to have more in the future.
Regularly we make new live streams talking about new MBS Plugin versions and Q&A sessions. But we like to get ideas for new topics to make separate special live streams. These can show examples and do live coding, which also shows how we debug issues on the way.
Please let us know what topics you like to see coming up!
Claris Inc. announced that the registration is open for the annual Claris Engage developer conference. Once again they do a conference in Austin, Texas from 25th to 26th March 2025 with an optional training day on 27th March. Please join the biggest FileMaker developer conference of the year:
Tickets are from $1099 USD for very early bird tickets to later $1850 USD for the full price ticket with training. Be sure to arrive 24th, so you can join others for a dinner meet-up on the conference eve. If Claris doesn't organize something, we and others may step in and make a reservation.
(more)
Vom 1. bis 4. Oktober 2024 findet die nächste deutschsprachige FileMaker Konferenz in Malbun, Liechtenstein statt. Einige Tickets für die Konferenz sind noch zu haben.
Monkeybread Software ist als Sponsor mit Stand und Session vor Ort. Bitte kommen Sie mit Ihren Fragen vorbei!
Wir planen für den 1. Oktober einen Wandertag ein (Anmeldung bei uns). Wer mit möchte, kann dann bei hoffentlich schönem Wetter mit uns durch die Berge wandern. z.B. von Malbun auf den Sareis zum Bergrestaurant. Der genaue Weg wird kurzfristig je nach Wetter und Öffnungszeiten vom Ziel entschieden.
(more)
Claris Inc. is looking for a new product manager:
Senior Product Manager – Claris
While it is fascinating to get a look into the job definition, salary, benefits and responsibilities of this job, I wonder what is going on at Claris?
In the last years we saw quite a bit of change at Claris with people leaving and new people arriving. But with everyone going or retiring, there is a brain drain. It seems to be difficult to retain people in Silicon Valley and keep them for more than a few years. But to execute on a strategy in the long run, you need to keep people for a decade or longer.
For this job offer, I wonder whether this is a new position for something new at Claris or if they replace someone, who may have or need to leave. Maybe someone can share?
Reading the job offer, I wonder if people could do this remotely, since Silicon Valley is an expensive place to live. The job offer doesn't specify where you work, just Sunnyvale on the top, where Claris Inc. has their office. If I remember correctly Apple asks for 3 days per week in the office, but not sure whether this applies here.
Claris has some more job offers, if you like to work there:
jobs.apple.com
New in this prerelease of version 14.4 of the
MBS FileMaker Plugin:
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.
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.
Today eighteen years ago we released the MBS FileMaker Plugin in Version 1.0.
Here the original announcement:
[ANN] MBS Plug-in For FileMaker
Make FileMaker Windows Semi Transparent!
Take Screenshots from FileMaker
Run an Applescript on field exit
and more...
Monkey Bread Software, maker of the popular MBS Plug-in for RealBasic and geist interactive have teamed up to bring the extensive MBS function library to FileMaker. The MBS RealBasic plug-in contains over 10000 functions, and this release represents the first step in a project to bring as many of those functions to FileMaker as make sense. Many many more features to com in the future.
The plug-in is available for FileMaker 8 and 8.5. It is available for Windows XP and as Universal Binary for Mac OS X There is a Developer Tool available to help you get started quickly with documentation and Calculation builder. Demos are available on the website
more info: geistinteractive.com
download: monkeybreadsoftware.de/filemaker/
Read also:
4000 functions in 10 years and
5000 Functions in MBS Plugin.
Thanks for the support over years.
Going to a FileMaker conference teaches you a lot of things. You talk with a lot of experienced developers and enjoy some great presentations. Let's think about a few I remember:
PSoS vs. job queue
The call to PSoS takes time to start the session, open files, load schema, run open and close script triggers. It can be quicker to use a job queue table and run one script server side to check every few seconds if the queue has new entries and trigger scripts to process the jobs. This script just pauses most of the time and still is very responsible.
More OData
Claris looks into improving their OData support for the next releases. And then eventually the ODBC/JDBC support will internally go through OData to provide connectivity for older systems, that can't yet do OData.
(more)
Please watch our short presentation for Reconnect.fm conference in Brisbane, Australia. We show a few new things in 2024 for MBS Plugin for Claris FileMaker.
More movies
Watch on YouTube.
(more)
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 answer questions from the live stream. This includes Overlay functions with Drag & Drop or hosting a web viewer. We check file dialogs and Drag & Drop as way to import lots of files into FileMaker. We check MapKit functions, progress bar in portals, cropping images and try a window moved script trigger. Thanks to everyone bringing questions!
(more)
Greetings from the
Australian FileMaker conference. It just started and we are happy to meet so many developers from the Asia Pacific area. Lots of attendees from Australia and New Zealand, but also up to Japan or Dubai. And some usual suspects from USA, Canada and Europe, who just like me love to explore the world. In total 110 people came including the Claris representatives.
There will be a short MBS Presentation to highlight a few new things in the plugin. Learn what is new in MBS Plugins this year.
(more)
When managing and optimizing FileMaker databases, understanding the details of your data is crucial. Whether you’re looking to optimize performance, audit data quality, or get insights into database structure, having precise statistical information about your database can be invaluable. The MBS FileMaker Plugin offers powerful functions for querying detailed statistics on fields, records, and entire tables. In this blog post, we’ll explore three key functions — FM.FieldStatistics, FM.RecordStatistics, and FM.TableStatistics — and how to use them to gain deep insights into your FileMaker databases.
(more)
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 talk about the new version 14.3 of our plugin: Announcement, release notes and new functions.
Let us show you how to combine DragDrop functions with the Overlay functions, run Python scripts with our Python functions and check the other smaller enhancements.
(more)
New in this prerelease of version 14.4 of the
MBS FileMaker Plugin:
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 clients asked to get a quick way to insert records with JSON data. As soon as that was done, the next one asked for updating and then of course for our insert and update.
We had these functions for years:
And all these functions are very handy, but how about passing parameters as JSON?
(more)
New in this prerelease of version 14.4 of the
MBS FileMaker Plugin:
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.
New in this prerelease of version 14.4 of the
MBS FileMaker Plugin:
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.
