Our Blog, Filemaker only, Xojo only, Archive (older), Follow us on Twitter, Xing, LinkedIn or Facebook.

Install fonts for PDF generation in FileMaker Cloud

As you may have noted, FileMaker Could comes preinstalled with around 50 font faces. The font you love and use in layouts may not be included in the list. The fonts include in various styles:
  • Baekmuk Batang
  • Utopia
  • URW Gothic L
  • URW Bookman L
  • Century Schoolbook L
  • Dingbats
  • Nimbus Sans L
  • Nimbus Roman No9 L
  • Nimbus Mono L
  • URW Palladio L
  • Standard Symbols L
  • URW Chancery L
  • IPAPGothic
  • Liberation Mono
  • Liberation Sans
  • WenQuanYi Micro Hei Mono
  • WenQuanYi Micro Hei
  • WenQuanYi Zen Hei Mono
  • WenQuanYi Zen Hei Sharp
  • WenQuanYi Zen Hei
If you like, you can install more fonts with those easy steps:
  1. Get login for your FileMaker Cloud Server via SSH.
  2. Create a new folder in /usr/share/fonts folder for your fonts.
    e.g. sudo mkdir --mode=777 /usr/share/fonts/myfonts
  3. Copy fonts in your new folder.
  4. Run "fc-cache -f -v" command to update cache.
  5. You can verify with "fc-list" command whether fonts were found.
  6. Reboot machine or at least restart the WebDirect engine.
Now you can create PDFs with any font you like. Let me know if it works for you.

You can use MBS( "DynaPDF.AddFontSearchPath"; $PDF; "/usr/share/fonts"; 1 ) with our DynaPDF functions to use the fonts on the FileMaker Cloud.

MBS FileMaker Plugin, version 7.6pr2

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

MBS Xojo Plugins, version 17.6pr2

New in this prerelease of the 17.6 plugins: Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.


For the next plugin prerelease, we introduce three JSON functions for use with our LDAP functions.

So you can use query and get the result as JSON with the new LDAP.JSON function. See this little example which connects and makes a query and finally shows the JSON in a dialog:

# Connect

Variable setzen [ $r ; Wert: MBS("LDAP.Connect"; "ldap.forumsys.com"; 0; 389) ] 

Wenn [ MBS("IsError") ] 

Eigenes Dialogfeld anzeigen [ "LDAP error" ; "Failed to connect." & ¶ & $r ] 


Variable setzen [ $ldap ; Wert: $r ] 

# Login

Variable setzen [ $r ; Wert: MBS("LDAP.Bind"; $ldap; "uid=tesla,dc=example,dc=com"; "password"; "simple") ] 

Wenn [ MBS("IsError") ] 

Eigenes Dialogfeld anzeigen [ "LDAP error" ; "Failed to authenticate." & ¶ & $r ] 


# Search

Variable setzen [ $r ; Wert: MBS("LDAP.Search"; $ldap; "dc=example,dc=com"; "subtree"; "(givenName=*)"; ""; 0; 20; 999) ] 

# Check results

Eigenes Dialogfeld anzeigen [ "JSON" ; MBS("LDAP.JSON"; $ldap) ] 

Ende (wenn)

# Cleanup

Variable setzen [ $r ; Wert: MBS("LDAP.Release"; $ldap) ] 

Ende (wenn)

The answer in JSON looks like this:


"dn": "uid=test,dc=example,dc=com",

"attributes": [{

"name": "objectClass",

"values": ["posixAccount", "top", "inetOrgPerson"]

}, {

"name": "gidNumber",

"values": ["0"]

}, {

"name": "givenName",

"values": ["Test"]

}, {

"name": "sn",

"values": ["Test"]

}, {

"name": "displayName",

"values": ["Test"]

}, {

"name": "uid",

"values": ["test"]

}, {

"name": "initials",

"values": ["TS"]

}, {

"name": "homeDirectory",

"values": ["home"]

}, {

"name": "cn",

"values": ["Test"]

}, {

"name": "uidNumber",

"values": ["24601"]

}, {

"name": "o",

"values": ["Company"]


So we have an array of entries fill with an object for each entry. Each entry has attributes and there each value can have several values. 
For add, modify or delete, you can now use the LDAP.AddJSON and LDAP.ModifyJSON functions to pass in JSON formatted changes.
The structure looks like this:

    "operation": "Add",
    "type": "xxx",
    "values": ["Hello", "World"]
    "operation": "Replace",
    "type": "yyy",
    "value": "Other"
    "operation": "Delete",
    "type": "zzz"

Please try in next prelease.

FileMaker Cloud Tipps & Tricks

First, you may know we used to simply restart the FileMaker Cloud instance when we installed a new plugin. That is due to the fact that if old and new plugin have the same file name and the OS can’t distinguish them. When FileMaker tries to load a new one, it still gets the handle for the old plugin copy. I suggested to FileMaker Inc. to make a hard link to load it with a random postfix in file name.

But we found a workaround. You can simply rename the plugin each time before adding it to the container to upload. So if first plugin is MBS1.fmx and you install MBS2.fmx via Install Plugin Script Step, you get the new one loaded and the old file is deleted. That’s great way to solve this. For the next plugins, we simply include the build number in the linux file name, e.g. MBS.3100.fmx to help you install it easily.

Second, whenever a plugin crashes the FileMaker Server scripting process, you see error 812 on the client. That can be irritating, but it simply means the client didn’t get an answer due to the lost connection.

Third, you may want to see debug messages from the plugin. Especially if we want to debug an issue. As none of the log files so far contain our debug messages, we change the plugin for next prerelease to redirect them itself. Within the /FileMakerData/Logs folder we create two new files ServerScriptingPluginsStdOut.log and ServerScriptingPluginsStdErr.log to log messages from stdout and stderr. Trace messages and debug messages end up in stderr. Regular outputs of messages may be in the stdout file.

I now usually connect two Terminal windows via SSH and run the commands to output the files live:

tail -f ServerScriptingPluginsStdOut.log
tail -f ServerScriptingPluginsStdErr.log

So in both windows I can watch live what is going on. To exit tail, you can press Control-C.

Forth, the FileMaker Cloud linux is secure. This includes that you can’t simply list all environment variables. EnvironmentVariables.Names returns an empty list. But you can still query some variables:
MBS( "EnvironmentVariables.Value"; "LANG" ) returns "en_US.UTF-8"

The MBS Plugin performs well on the FileMaker Cloud, although that's currently only 5% of the servers out there as far as we know about. Popular functions used on the FileMaker Cloud include our CURL functions, SQL functions within FileMaker and JSON functions.

Three weeks till year's end

The year 2017 will end in less than three weeks. Do you need some more licenses?
  • You can order licenses for 2018 or later and have invoice, delivery and payment done in 2017.
    This way you secure the current pricing and the possibility to keep upgradeability for older licenses.
  • And of course you can order updates for several years in advance for all your MBS products.
  • DynaPDF licenses are on sale for December 2017 with 25% automatically.
  • As all our Xojo and DynaPDF plugin licenses are per developer, you should check if you got a new developer in your team this year and adjust licenses to match team size.
  • If you need a Xojo license (new or update), we can always check whether a bundle with Xojo offers an advantage for you. Or we can point you to the next sale or a coupon code for the Xojo Store.
  • For FileMaker please check if you have enough license for the number of seats or servers you have in use.
    If you upgrade to unlimited seats or servers, the plugin won't need to check the usage.
Especially if you run on a budget and you want to spend some money in the old year, you can buy updates for several years in advance.
If you need help to decide what Xojo, FileMaker or plugin license you need, we may be able to assist you.

One week left for Omegabundle Mini for Xojo Web 2017 Dev Tools Bundle

Get the best developer tools and third party components for the Xojo Web web application development for limited time. Ends 15th December 2017.

Omegbundle Mini for Xojo Web 2017 is a collection of 40+ of the most useful tool sets, add-ons and components for use with Xojo Inc's Xojo development environment. If purchased individually, the savings of the bundle is over $547. Omegabundle Mini for Xojo Web 2017 costs $199.

This is a very limited special offer available from November 24, 2017 (Black Friday) through December 15, 2017.

Xojo is an award-winning, cross-platform development tool for the Desktop (OS X, Windows, Linux), Web, iOS (iPad/iPhone) and Raspberry Pi. With Xojo, you can create native applications by using drag-and-drop to build your user interface and then one straight-forward programming language to enable the functionality. Xojo is powerful and modern, yet easy to use and learn. Download Xojo today and see for yourself.

Xojo Web lets you build your web app user interface with drag and drop. With built-in support for graphics, database servers, internet protocols and more, you can build anything. If you have been thinking about making the leap from desktop or mobile Xojo development to web, Omegabundle Mini for Xojo Web 2017 gives you all the best third party tools at one very good price!

Included Products
  • GraffitiSuite Web Edition. Over 40 controls and classes cover just about all your user interface needs for building Xojo Web applications. Regularly $199.
  • Monkeybread Web Starter Kit. Everything you need to begin creating your first Xojo Web app. Regularly $149.
  • LeRoy Software Web Bundle. Featuring Web Calendar View, Web Chart View, and four other controls. Regularly $199.
  • Valentina Studio Pro. The ultimate reports designer and professional database administration tool. Participants in Omegabundle for Xojo 2016 & 2017 can instead upgrade to UNIVERSAL. Regularly $199 or $239.
You can find additional information about Omegabundle Mini for Xojo Web 2017 from the Omegabundle website or order now through the Paradigma Online Store. Please allow up to three business days for all components to be supplied by email by participating vendors.

FileMaker Magazin - MBS Artikel

For our German speaking users:

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 excellente Quelle von Informationen, Anleitungen und Profitips.

MBS Xojo Plugins, version 17.6pr1

New in this prerelease of the 17.6 plugins:
  • Fixed a crash with JSONMBS class.
  • Improved JSON handling to break circular references.
  • Updated Rockesy4ND library for macOS to better support macOS High Sierra.
  • Added checks to IconMBS class to make sure you don't get corrupted images.
  • Changed CFURL to/from folderitem to use NativePath/URLPath instead of FSRef.
  • Fixed an issue with file path handling for Mac XL Plugin. Now handles composed unicode characters better.
  • Updated DynaPDF to version
  • Updated CURL library to version 7.57.0.
  • Updated OpenSSL to 1.1.0g and 1.0.2m
Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

MBS FileMaker Plugin, version 7.6pr1

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

List of DynaPDF error codes

For your convenience, here a list of all error codes with messages for lookup.

DynaPDF Error List

Don't forget the DynaPDF Christmas Sale. A great chance to upgrade and add maintenance at lower prices.

Xojo 2017r3 available

Xojo Inc. today released Xojo 2017r3.
See Announcement, Download, Release Notes

The new Xojo 2017r3 release brings us a 64-bit IDE. That is great news, but may require some updates on your plugins. The recommended version for MBS Xojo Plugins is the current version 17.5 which contains important fixes to load plugins at all on Windows. Over the year we fixed a couple of 64-bit related bugs, so please do not use the older ones and find those bugs. All plugin versions older than 16.0 do not load at all in the new IDE due to missing 64-bit code.

Due to limits on Windows for the number of plugins, you may not see all plugins loading. Some older plugins which are not supporting 64-bit well enough, may not load. When moving to 64-bit, please also consider moving code from QuickTime to AVFoundation on Mac.

Still you can build 32-bit applications, so no worry on that.

See also: Xojo and Real Studio versions supported by MBS Plugin, MBS Xojo Plugin 17.5 Announcement and
Windows DLL Limits and Xojo 64-bit IDE

PS: Blog post from Bob Keeney: Xojo 2017 R3

FileMaker Cloud, best with BYOL

Be aware of a little limitation when using FileMaker Cloud with annual subscriptions for the FileMaker Server software with AWS:

If you purchased an annual licnese via the Amazon Marketplace, do not change the instance size after installation. Doing so will switch your instance to become hourly billed.

So if you ever plan to up/downscale without hassle on the FileMaker Cloud servers, you better go and buy the license from FileMaker directly (or a your favorite reseller).

With that license, you can easily switch from t2.medium on development (2 cores, 4 GB RAM) to t2.large (2 cores, 8 RAM) for a beta test and up to t2.2xlarge (8 cores and 32 GB RAM) for deployment on busy days. It would be pity if your next AWS bill for FIleMaker Cloud would be $700 for hourly billing, because you just changed instance type.

And you can use one license over the year for several servers independently. e.g. buy a FileMaker Server for a project in February, terminate the server in April and later in August start a new one for another project with the existing license.

For details, please check answer 25984.

Following the license rules

We are software developers and make a living from selling our software. Ourselves we pay for licenses to enable others to make a living. This includes paying royalties for libraries used in our plugins which enable the continued development of those libraries. And we expect our clients to pay their license fees and indeed the majority does it correctly and pays their bills.

Technically we don’t enforce it directly. Xojo itself has a server based activation, FileMaker Pro doesn’t, but the Server talks back to FileMaker Inc.. Personally we don’t like to use an activation for the plugins, so we only check license keys locally. We also do some statistics on the usage of the plugins, so we know what versions are in use on which operation systems. And we can see which license keys are in use.

The licensing terms for Xojo and FileMaker are quite clear. You can have a trial for FileMaker Pro and for Xojo simply use the software without a license. Those are limited in a couple of ways. But when you get productive, you should really get a license key. You need one license per developer and you do not share license between developrs. For Xojo you need to have a Pro key to use version control software, so you buy the Pro licenses when you want take part in a bigger development project. For FileMaker you should have a license for Pro Advanced when you develop and of course you pay it.

For using plugins we expect that you match the licenses for plugins with those for Xojo and FileMaker. So if you have two Xojo licenses for two developers and both developers work on the projects using the plugins, we expect you to buy two licenses. We want bigger companies to contribute more for the tools than a small one person company. For FileMaker you pay for each server a license to FileMaker Inc. and we expect that you also pay for each server using MBS Plugin the license fee to us. That may result in paying for every developer including trainees and managers. We do know that some things may be temporary and for that reason like to issue trial keys to use our plugins without paying for a limited time.

Luckily the statistics show that nearly everybody obeys the licensing terms and that makes me happy. We do have Xojo plugins in use for development on at least a thousand computers. We don’t know about deployment as we don’t want to track that! Still MBS Xojo Plugins is used in thousands of applications with properly hundred thousands installations. I know some Xojo applications using my plugins which sold over 10000 times. Our FileMaker plugin is used on tens of thousands computers and that makes us happy. We got some success there over the years.

On the other side the statistics reveal some really bad guys. We learnt that there are license keys used, which we never created. Someone clearly hacked the plugins. And some users really use the plugin on much more computers than intended. Like the company who runs 26 servers with just one server license for our FileMaker plugin. Or a company with eight Xojo developers and just one license key. Same with a FileMaker solution with a 5 seats key, which was in use on 21 computers on a single day last month. And those calculations include a filter which removes the occasional use of a key for a day or two on another computer.

Today I double checked this and contacted a few clients which exceed the license terms a lot. Not the job I like to do.

Booked for Montreal

For the upcoming Québec FileMaker Developers Conference (QFDC) next year in Montreal, I am happy to be signed up a sponsor and I booked my flight already. Due to flights being much cheaper going to Toronto, I will come to visit that nice town and maybe organize a local developer meeting there.

Montreal at night

The conference will probably be announced soon, but it may be good to keep mid March free for now.

Birthday of our video page

Ten years ago we started created tutorial videos and today our video page has birthday. Enjoy a video and learn about our plugins.

Over the years we collected more than 80 videos. We hope you enjoy them!

Watch Xojo Videos - FileMaker Videos

Youtube channels:

We know we could make more videos. So what wishes do you have?
Please email us or post a comment here.

DynaPDF Christmas Sale

We just got notice from DynaForms about their Christmas Sale for this year:

Christmas Special: 25% Off on anything!

As a thank you for the good collaboration and your trust, you get 25% Christmas Discount on anything til the end of the year!

I wish you and your family Merry Christmas and a successful new year.

With kind regards

DynaForms GmbH

The MBS online shop is updated and we reduced all our DynaPDF prices by 25%. So if you need a new license or updates for up to five years, please order. If you have questions, please do not hesitate to contact us.
Order for Xojo - Order for FileMaker

PDFKit on iOS for MBS FileMaker Plugin

As Apple added support for PDFKit to iOS with version 11, we thought we may use it for FileMaker, too.

And indeed, our PDFKit functions can work on iOS, too. Printing is not available and Quartz Filters are macOS only.
But other functions like rendering a PDF page or merging several PDFs into one works well.

So you can now do PDF append operation on iOS with our plugin, e.g. using PDFKit.AppendPages function. The following scripts merges two PDFs and stores the resulting PDF in a new container:

Set Variable [ $pdf ; Value: MBS("PDFKit.OpenContainer"; MyTable::InputPDF) ]
Set Variable [ $r ; Value: MBS( "PDFKit.AppendPages"; $pdf; MyTable::OtherPDF ) ]
Set Field [ MyTable::OutputPDF ; MBS( "PDFKit.GetPDFDocument"; $PDF) ]
Set Variable [ $r ; Value: MBS( "PDFKit.Release"; $pdf) ]

You can of course decide whether you like to use PDFKit or you need more and use our DynaPDF functions. With DynaPDF we have a cross platform library which provides constant behavior on all platforms. PDFKit is great for the average user, but if you need PDF/A, separation/process colors or optimization, you need more. See DynaPDF features.

The new features can be tested with the upcoming beta version in a few days. If you like to try them earlier, please do not hesitate to contact us.

Amazon S3 Upload with Mime Type and Permissions

As you may know we have functions to do authentication for Amazon WebServices in our plugins for Xojo and FileMaker. This functions can be used with various webservices from Amazon, but today we use S3 as example and upload an image from a container.

You can pass additional headers with the upload to specify permissions and content type. For example you can grant permissions to everyone with acl public-read. When you pass the content type, you get back that same content type when downloading. Here an example upload:

# Change to your own credentials, region, bucket name, file name...

Set Variable [ $AWSAccessKeyId ; Value: "AKIAK21ZENQFJ3EFLKJA" ] 

Set Variable [ $AWSSecretAccessKey ; Value: "4TMeKFtn62xDfAP6F1cENwHehRqo75kQKoT/BAKE" ] 

Set Variable [ $Region ; Value: "eu-central-1" ] 

Set Variable [ $Bucketname ; Value: "mbstest" ] 

Set Variable [ $Filename ; Value: "test.jpg" ] 

Set Variable [ $Headers ; Value: "Content-Type: image/jpeg¶x-amz-acl: public-read" ] 

Set Variable [ $Service ; Value: "s3" ] 

Set Variable [ $Verb ; Value: "PUT" ] 

# Keep those empty for default

Set Variable [ $Domain ; Value: "" ] 

Set Variable [ $HashedPayload ; Value: "" ] 

# Build a path

Set Variable [ $Path ; Value: "/" & $BucketName & "/" & $Filename ] 

# Run transfer

Set Variable [ $curl ; Value: MBS("CURL.New") ] 

Set Variable [ $result ; Value: MBS("CURL.SetInputFile"; $curl; CURL Test::Image) ] 

Set Variable [ $result ; Value: MBS("CURL.SetupAWS"; $curl; $AWSAccessKeyId; $AWSSecretAccessKey; $Region; $Service; $Path; $Domain; $Verb; ""; $Headers) ] 

Set Field [ CURL Test::Result ; MBS("CURL.Perform"; $curl) ] 

Set Field [ CURL Test::debug ; MBS("CURL.GetDebugAsText"; $curl) ] 

Set Variable [ $result ; Value: MBS("CURL.Cleanup"; $curl) ] 

Same upload works in Xojo with our MBS Xojo CURL Plugin

Please do not hesitate to contact us with questions.

Our Xojo Web Apps on a demo server

As we include our WebStarter Kit in the Omegabundle, I got queries to put my web apps on a server again. So please try them:

If an app does not work currently, please come back later and don't hesitate to inform us.

Older blog entries:

2017-11-28 Print WebViewer on macOS in FileMaker
2017-11-28 MBS FileMaker Plugin 7.5 - More than 5000 Functions In One Plugin
2017-11-28 MonkeyBread Software Releases the MBS Xojo Plugins in version 17.5
2017-11-28 MBS FileMaker Plugin 7.5 - Über 5000 Funktionen in einem Plugin
2017-11-24 Black Friday Sales
2017-11-24 Omegabundle Mini for Xojo Web 2017 Dev Tools Bundle Released
2017-11-23 MBS FileMaker Plugin, version 7.5pr9
2017-11-23 MBS Xojo Plugins, version 17.5pr9
2017-11-23 DynaPDF Funktionen im MBS FileMaker Plugin
2017-11-23 FileMaker Experience Event in der Schweiz
2017-11-22 Xojo Web Apps on FileMaker Cloud Server
2017-11-22 xDev Magazine and xDevLibrary's Huge Black Friday/CyberMonday Sale
2017-11-21 Big Xojo Sale For Black Friday
2017-11-18 MBS Xojo Plugins, version 17.5pr8
2017-11-18 MBS FileMaker Plugin, version 7.5pr8
2017-11-17 Transparent Screensaver for macOS
2017-11-16 Convert to MP3 with new Shell commands and ffmpeg
2017-11-15 MBS Workshop in der Schweiz
2017-11-15 Batch Emailer Application for Xojo as a sample project
2017-11-15 MBS Workshop @ Denkform


Dec 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
XML: RSS Feed XML: Atom Feed