Version Tracking in FileMaker with help of MBS Plugin


We show you our Split DDR example to prepare your DDR for better tracking changes in version control systems like GIT.

The Split DDR example file is included with download of MBS FileMaker Plugin.

All our FileMaker videos   Watch on Youtube.


MBS FileMaker Plugin 10.4 - More than 6300 Functions In One Plugin


Nickenich, Germany - (September 15th, 2020) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 10.4 for macOS, iOS, Linux and Windows, the latest update to their product that is easily the most powerful plugin currently available for FileMaker Pro. As the leading database management solution for Windows, macOS, iOS and the web, the FileMaker Pro Integrated Development Environment supports a plugin architecture that can easily extend the feature set of the application. MBS FileMaker Plugin 10.4 has been updated and now includes over 6300 different functions, and the versatile plugin has gained more new functions:

The main feature of the newer plugin version is our move from Visual Studio 2008 to the more current version 2019. We now use universal runtime library, the same Visual Studio runtime as FileMaker. As Windows 10 includes those DLLs by default and Windows 7 and 8 can install them, the plugin should run fine there. We worked on this for over a year to get all our libraries ported and recompiled. All parts come together and we can finally ship our Windows plugins built with current tools and start to add more Windows 10 APIs over time.

You may know that FileMaker has a built-in Location function for iOS. MBS FileMaker Plugin include CoreLocation functions for macOS for years. For the new version we added WindowsLocation functions to query the location of your Windows PC. Useful for all those Windows tablet PCs running FileMaker Pro. Check also CoreLocation.requestLocation function for macOS to ask for location permissions.

For GraphicsMagick we have new functions to select a font family, stretch (condensed or expanded), style (italic or oblique) or weight (bold). Once set, you can use GMImage.Annotate to write text. We can list the font types available to a text file with GMImage.ListTypeInfo function.

Use Archive.ExtractFile to extract just one file from an archive and get it back as container value. For SSH connections use SSH.ConfigureKeepAlive to prevent the connection from timing out when an operation takes longer than 2 minutes. When tracing plugin calls on server use Trace.SetServerLogPath to have one log file per thread and not mix all calls from all scripts in one huge log file.

For CURL we added functions to query some of the options to help with debugging. You can query effective HTTP method and the retry after delay. We extended post fields to allow more than 8 MB in data size.

On macOS you can use ImageCapture.SetItemsAddedScript to trigger a script when a picture is taken with your digital camera. For TextView functions you can now set them to styled text with TextView.SetStyledText function or append styled text with TextView.AppendStyledText or query the current text with TextView.GetStyledText function.

For iOS use iOSApp.ReadReceipt function to read the app store receipt and see what items the user purchased with the store. Check the StoreKit functions to list products and start a transaction.

We optimized speed for Audit functions, add better error handling for socket functions, rewrote Hotkey functions to use native API on Windows, improved text encoding handling for XML and restored the notifications to show errors in MBS calls (if you have notifications allowed for FileMaker).

Finally we updated bzip2 library to version 1.0.8, CURL to 7.72.0, DynaPDF to 4.0.41.118 with ZUGFeRD 2.1, GraphicsMagick to 1.3.35, JPEG library to 9d, PCRE to 8.44, SQLAPI to 5.1.1, SQLite to 3.33.0 including decimal extension and we updated Xcode to version 10.6.

See release notes for a complete list of changes.

Neues MBS FileMaker Plugin 10.4


15. September 2020 - Monkeybread Software veröffentlicht heute das MBS FileMaker Plugin für FileMaker in Version 10.4, mit inzwischen über 6300 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen:

Das wichtigste Feature der neueren Plugin-Version ist unser Umstieg von Visual Studio 2008 auf die aktuellere Version 2019. Wir verwenden jetzt die universelle Runtime-Bibliothek in der gleichen Version wie sie FileMaker verwendet. Da Windows 10 diese DLLs standardmäßig enthält und Windows 7 und 8 sie installieren können, sollte das Plugin dort problemlos laufen. Wir haben über ein Jahr lang daran gearbeitet alle unsere Bibliotheken zu portieren und neu zu kompilieren. Jetzt können wir unsere Windows-Plugins, die mit aktuellen Tools erstellt wurden, ausliefern und im Laufe der Zeit weitere Windows 10-APIs hinzufügen.

Sie wissen vielleicht, dass FileMaker eine eingebaute Standortfunktion für iOS hat. Das MBS-Plugin enthält seit Jahren CoreLocation-Funktionen für MacOS. Für die neue Version haben wir WindowsLocation-Funktionen hinzugefügt, um den Standort Ihres Windows-PCs abzufragen. Nützlich für alle Windows-Tablet-PCs mit FileMaker Pro. Für iOS probieren Sie die CoreLocation.requestLocation-Funktion, um die Standortberechtigungen abzufragen.

Für GraphicsMagick haben wir neue Funktionen zur Auswahl einer Schriftfamilie, der Größe, dem Stil (kursiv oder schräg) oder der Gewichtung (fett). Einmal festgelegt, können Sie GMImage.Annotate verwenden, um Text zu schreiben. Wir können die verfügbaren Schriftarten mit GMImage.ListTypeInfo als Liste in eine Textdatei schreiben.

Verwenden Sie Archive.ExtractFile, um nur eine Datei aus einem Archiv zu extrahieren und sie als Containerwert zu bekommen. Für SSH-Verbindungen verwenden Sie SSH.ConfigureKeepAlive, um zu verhindern, dass die Verbindung mit einem Timeout abbricht, wenn ein Vorgang länger als 2 Minuten dauert. Beim Trace von Plugin-Aufrufen auf dem Server verwenden Sie Trace.SetServerLogPath, um eine Protokolldatei pro Thread zu bekommen und nicht alle Aufrufe aller Skripte in einer riesigen Protokolldatei zu mischen.

Für CURL haben wir Funktionen zur Abfrage einiger Optionen hinzugefügt, um bei der Fehlersuche zu helfen. Sie können die effektive HTTP-Methode abfragen und die Verzögerung bis zum nächsten Verbindungsversuch. Wir haben die POST-Felder erweitert, um eine Datengröße von mehr als 8 MB zu ermöglichen.

Unter MacOS können Sie ImageCapture.SetItemsAddedScript verwenden, um ein Skript auszulösen, wenn ein Bild mit Ihrer Digitalkamera aufgenommen wird. Für TextView-Funktionen können Sie sie jetzt mit der Funktion TextView.SetStyledText auf formatierten Text setzen oder formatierten Text mit der Funktion TextView.AppendStyledText anhängen oder den aktuellen Text mit der Funktion TextView.GetStyledText abfragen.

Für iOS verwenden Sie die Funktion iOSApp.ReadReceipt, um die Quittung des App Store zu lesen und zu sehen, welche Artikel der Benutzer mit dem Store gekauft hat. Benutzen Sie die StoreKit-Funktionen, um Produkte aufzulisten und eine Transaktion zu starten.

Wir optimieren die Geschwindigkeit für Audit-Funktionen, fügen eine bessere Fehlerbehandlung für Socket-Funktionen hinzu, schreiben die Hotkey-Funktionen mit nativer API unter Windows neu, verbesseren die Handhabung der Textkodierung für XML Funktionen und stellen die Fehler Benachrichtigungen wieder her, um Fehler in MBS-Aufrufen anzuzeigen (wenn Sie Benachrichtigungen für FileMaker zugelassen haben).

Schließlich aktualisieren wir die bzip2-Bibliothek auf Version 1.0.8, CURL auf 7.72.0, DynaPDF auf 4.0.41.118 mit ZUGFeRD 2.1, GraphicsMagick auf 1.3.35, JPEG-Bibliothek auf 9d, PCRE auf 8.44, SQLAPI auf 5.1.1, SQLite auf 3.33.0 einschließlich Dezimalerweiterung und wir aktualisieren Xcode auf Version 10.6.

Alle Änderungen in den Release Notes.

FileMaker Magazin - MBS Artikel


Wir haben die Artikel zum MBS Plugin aus dem FileMaker Magazin gesammelt hier online gestellt: FileMaker Magazin Artikel.

Wir empfehlen allen FileMaker Anwender ein Abo vom Magazin und den Kauf der alten Ausgaben.
Das FileMaker Magazin ist eine exzellente Quelle von Informationen, Anleitungen und Profitips.


MBS FileMaker Plugin, version 10.4pr9


New in this prerelease of version 10.4 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.com/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

14 years since MBS FileMaker Plugin version 1.0


Today fourteen 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.

FileMaker Stammtisch in Wien am 10. September 2020


On my next visit to Vienna, we plan another developer meeting:

Wer hat Interesse an einem FileMaker Entwicklertreffen am 10. September in Wien?

Diesmal mit Vince Menanno von Beezwax, der gerne was zum Inspector Pro zeigt.
Vince ist seit ein paar Monaten in Deutschland und kommt gerne mal rüber nach Wien.
Und gerne zeige ich auch was zum nächsten MBS Plugin.

Einfach in gemütlicher Runde treffen in einem netten Restaurant und beim Abendessen was über FileMaker reden. Vielleicht habt ihr ja auch Fragen und Probleme, wo ich helfen kann?

Zeit wäre ca. 18 bis 22 Uhr am 10. September 2020, so dass man auch später kommen oder früher gehen kann.

Wer dabei sein möchte, bitte bei uns melden.

Falls sonst noch Bedarf an Schulung, vor Ort Entwicklung oder FileMaker/Xojo Hilfe besteht, bitte wegen Terminfindung bald melden.

MBS FileMaker Plugin, version 10.4pr8


New in this prerelease of version 10.4 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.com/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Webservice vs. Plugin


Sometimes users ask what is better: a plugin or a web service?

The usual answer from your lawyer applies here, too: It depends.

If you can write your own plugin or web service, things may be different than the average user, who uses it.

The web service

The web service provides functionality over a network (usual Internet). It runs on someone else's computer who takes care about keeping it working with redundancy, load balancing and security threads. Your access to the service depends on the quality of your own network connection and the service is usually not available while being offline or without connectivity on the go in rural areas.

You may need to prepare for service being not available and have a table in your database for jobs, so when service is not available, you can store requests and process them later.

If the service gets new features, those are usually rolled out quickly. Usually first to a tester group, but over time to all users. A good service will not break functionality, but use versioning in the URLs to keep old versions running.

Your access to the service will be available as long as you pay whatever the service vendor wants to charge you. Per request, per time and with arbitrary usage limits. The service may stop being available for you if your credit card expires and you forget to update it. If the company goes out of business or decides the service is not profitable, the service may shut down with very short notice.

One question is who owns the data. Can the service provider use data you provide and for example use it for advertisement. Servers may be in a different jurisdiction and could be seized. Problematic if you use shared servers and some other customers does something illegal and your data is seized with the one of the suspect.

Finally you need to consider how big the impact is on you, in case the provider is hacked and all your data on the server is copied by the hackers. Or worse, if the hackers can read all data coming back over months. Of course you may have a contract stating how data is processed, stored, secured, backed up and shared.

The library

The library (or plugin) providing a service locally within your solution is a bit different. You get the library and you can use it locally, even offline. There is usually no per-use fee, but only a license fee to get the library once, with possible yearly maintenance cost.

A shared library has access to the hosting application, so it can work with windows and controls. It can show own dialogs within the application and provide additional functionality on the host windows.

If the vendor of the library goes out of business, the library will usually continue to work. Over time some functionality may break, e.g. with an update to the operation system. If that happens, you may look for other libraries to provide such functionality and gradually replace features as needed.

Every request can be answered by the library instantly or after some processing time. The network latency has no effect. All data can be accessed within the same memory and same disk space as no data needs to be uploaded. Performance may be higher compared to a service, as the library is usually provided as compiled code for the local CPU. And of course all data stays locally.

Finally the library may help you to access a web service. We have examples for e.g. sending emails, Amazon S3 upload/download and more for MBS Plugins.

Conclusion

What you prefer to use depends on your concrete task to solve. Think a little bit about all those factors above and decide wisely. If you have a library doing the job or you already pay for the service, you may just use that. Otherwise it is a calculation of make vs buy, pay by month for a service vs. pay one time for a license and how much work the implementation and future maintenance is.

Record Creation Script Trigger


Today we want to share two ways to trigger scripts via MBS Plugin on record creation.

There has been a request to have 

 

Auto Enter Script Trigger

 

First you can define a field TriggerScriptOnCreate with an auto calculation like this:

 

MBS("FM.RunScript"; "Contacts"; "RecordCreated"; Get(RecordID))

 

We set the option to not replace existing values. This calculation now runs on every record creation in FileMaker Pro. The plugin function returns OK, which is written to the record.

The script will now run whenever you create a new record or duplicate one as the calculation runs. We pass the record ID so the script could check the record.

 

Timer Script Trigger

 

Other people may create records on the same database hosted on a server. So you may want to regularly check whether there are new records and we just automated it via counting records via SQL to trigger a script when the count changes. Here is the sample script:

 

# StartRecordCreatedTrigger

 

Set Variable [ $count ; Value: MBS( "FM.ExecuteFileSQL"; "Contacts"; "SELECT Count(*) FROM Contacts"; 9; 13 ) ] 

If [ MBS("IsError") ] 

Show Custom Dialog [ "SQL Error?" ; $$LastSQLCount ] 

Else

Set Variable [ $$LastSQLCount ; Value: $count ] 

# free old if still runs

Set Variable [ $r ; Value: If(Length($$RecordCreatedScheduleRef) > 0 ; MBS("Schedule.Release"; $$RecordCreatedScheduleRef); "") ] 

# launch new evaluate schedule

Set Variable [ $$RecordCreatedScheduleRef ; Value: MBS( "Schedule.EvaluateAfterDelay"; 60; "Let( [ $SQLCount = MBS( \"FM.ExecuteFileSQL\"; \"Contacts\"; \"SELECT Count(*) FROM Contacts\"; 9; 13 ); $e = MBS(\"IsError\"); $r = Wenn($SQLCount ≠ $$LastSQLCount; MBS(\"FM.RunScript\"; \"Contacts\"; \"RecordCr… ] 

End If

 

As you see we query an initial count number and put it in a global variable. We schedule an evaluate and let's take a look on the expression without the backslashes needed:

 

Let( [

$SQLCount = MBS( "FM.ExecuteFileSQL"; "Contacts"; "SELECT Count(*) FROM Contacts"; 9; 13 );

$e = MBS("IsError");

$r = Wenn($e = 0 AND $SQLCount $$LastSQLCount; MBS("FM.RunScript"; "Contacts"; "RecordCreated"));

$$LastSQLCount = Wenn($e; $$LastSQLCount; $SQLCount)

]; "")

 

As you see we query again the count of records via SQL and if that number changes, trigger the script and remember the new count. If an error is reported from SQL, we ignore this for now as the file may be closed currently?

 

To stop this later, we can release the schedule and have the plugin stop it:

 

# StopRecordCreatedTrigger

 

# free old if still runs

Set Variable [ $r ; Value: If(Length($$RecordCreatedScheduleRef) > 0 ; MBS("Schedule.Release"; $$RecordCreatedScheduleRef); "") ] 

Set Variable [ $$RecordCreatedScheduleRef ; Value: "" ] 

 

As you see we just call Schedule.Release function to release if the variable is set and then clear it.

By using the MBS Plugin to schedule this, we can do the Evaluate even while a script is running already. Your scripts can use OnTimer if needed as we don't need that.

 

Let us know if you have comments or questions.


MBS FileMaker Plugin, version 10.4pr7


New in this prerelease of version 10.4 of the MBS FileMaker Plugin: Download at monkeybreadsoftware.com/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Archives

Sep 2020
Aug 2020
Jul 2020
Jun 2020
May 2020
Apr 2020
Mar 2020
Feb 2020
Jan 2020
Dec 2019
Nov 2019
Oct 2019
Sep 2019
Aug 2019
Jul 2019
Jun 2019
May 2019
Apr 2019
Mar 2019
Feb 2019
Jan 2019
Dec 2018
Nov 2018
Oct 2018
Sep 2018
Aug 2018
Jul 2018
Jun 2018
May 2018
Apr 2018
Mar 2018
Feb 2018
Jan 2018
Dec 2017
Nov 2017
Oct 2017
Sep 2017
Aug 2017
Jul 2017
Jun 2017
May 2017
Apr 2017
Mar 2017
Feb 2017
Jan 2017
Dec 2016
Nov 2016
Oct 2016
Sep 2016
Aug 2016
Jul 2016
Jun 2016
May 2016
Apr 2016
Mar 2016
Feb 2016
Jan 2016
Dec 2015
Nov 2015
Oct 2015
Sep 2015
Aug 2015
Jul 2015
Jun 2015
May 2015
Apr 2015
Mar 2015
Feb 2015
Jan 2015
Dec 2014
Nov 2014
Oct 2014
Sep 2014
Aug 2014
Jul 2014
Jun 2014
May 2014
Apr 2014
Mar 2014
Feb 2014
Jan 2014
Dec 2013
Nov 2013
Oct 2013
Sep 2013
Aug 2013
Jul 2013
Jun 2013
May 2013
Apr 2013
Mar 2013
Feb 2013
Jan 2013
Dec 2012
Nov 2012
Oct 2012
Sep 2012
Aug 2012
Jul 2012
Jun 2012
May 2012
Apr 2012
Mar 2012
Feb 2012
Jan 2012
Dec 2011
Nov 2011
Oct 2011
Sep 2011
Aug 2011
Jul 2011
Jun 2011
May 2011
Apr 2011
Mar 2011
Feb 2011
Jan 2011
Dec 2010
Nov 2010
Oct 2010
Sep 2010
Aug 2010
Jul 2010
Jun 2010
May 2010
Apr 2010
Mar 2010
Feb 2010
Jan 2010
Dec 2009
Nov 2009
Oct 2009
Sep 2009
Aug 2009
Jul 2009
Apr 2009
Mar 2009
Feb 2009
Dec 2008
Nov 2008
Oct 2008
Aug 2008
May 2008
Apr 2008
Mar 2008
Feb 2008