Door 10 - Phidgets
Fact of the day |
---|
Did you know that Phidgets are used in schools to get students interested in computer science?
|
Do you already know the small input/output devices from Phidgets Inc. Phidgets are small additional
devices that you can connect to your computer and with which you can then input or output data.
For example you can connect a small motor, a temperature sensor,
a humidity sensor, a gyroscope or a small LED display and exchange data with these devices.
In this example, I would like to introduce you to three different Phidgets
and how we can read data from these Phidgets in FileMaker. Our three phidgets are a light sensor,
a temperature sensor and a slider.
In our example, the phidgets are all connected together to a hub.
This hub has various outputs to which the individual Phidgets can be connected.
This hub is then connected to the computer with a USB cable.
All Phidgets also draw their power via this USB cable.
It is also possible to purchase a wireless HUB.
In this case, a separate power supply is required.
I would now like to show you how to retrieve the Phidget data via FileMaker.
First of all, we need to load the Phidget libary.
To be able to load the libary, we first have to download it.
You can find the appropriate download here.
(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 looked on a few new things in development for the next version. In the Q&A session we got interesting questions:
(more)
I am coming to Austin in early February and I may organize a casual get-together with Xojo developers.
Something like a meet-up for dinner in a restaurant to talk about Xojo in North Austin.
I made a survey with doodle to find a date:
Survey to find a date
We previously had meetings as well as a Xojo conference in previous years. See also
forum post.
Door 9 - IBAN
Fact of the day |
---|
Saint Lucia has the longest IBAN with 32 characters. This country is not a member of the SEPA area. Within the SEPA area, Malta has the longest IBAN with 31 characters.
|
Today I would like to introduce you to a component that currently only contains 7 functions,
but can be very useful to you if required. We are talking about the IBAN component.
The IBAN number is an international number that can be clearly assigned to a specific account.
It is intended to contribute to the standardization of global payment transactions.
Mainly the EU countries have already implemented this standard,
but countries outside of Europe are also adopting this standard.
(more)
Door 8 - Determine your own position (for Mac users)
Fact of the day |
---|
A man from Munich parked his car in a parking lot in 2015 and was unable to find it again. The car was reported stolen in the meantime. After around 6 months, he was informed by the parking garage company that his car was still in the parking lot. This man should have remembered his location
|
Today I would like to show you how you can determine your own position as a Mac or iOS SDK user.
The CoreLocation component is available for this purpose.
If you want to use this option in your apps, we need authorization.
We can request various authorizations.
The Always authorization requests permission to use location services whenever the app is running.
The next weaker authorization is the when in use authorization.
It Requests permission to use location services while the app is in the foreground.
There is also the temporary full accuracy authorization. This access will expire automatically,
but it won't expire while the user is still engaged with your app.
In our example, we use the Always authorization. If the authorization fails, please check the settings in Security.
You can check whether the authorization was successful using the CoreLocation.authorizationStatus function.
It displays the current authorization status. The following responses are possible.
(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 MBS FileMaker Plugin 13.5 release: Announcement, release notes, new functions and download
(more)
Door 7 - Paths
Fact of the day |
---|
Did you know that you can easily copy the path of a file under Mac if you press the option key in the menu of the right mouse button at the same time? The menu will then show the entry as Copy...as pathname
|
Today it's all about how you can build paths in FileMaker with the help of the MBS FileMaker Plugin.
We already got a little insight into this topic in the third door, where we created a path to a file on the desktop.
The MBS FileMaker Plugin offers you some of these paths to special folders in your system.
For example, you can use the Folders.UserDesktop function
to determine the path to a user's desktop. Or you can determine the path to the temporary folder
with Folders.UserTemporary.
In this picture you can see the functions that are available for special folders.
(more)

New in this prerelease of the 23.6 plugins:
Download:
monkeybreadsoftware.de/xojo/download/plugin/Prerelease/ or
from DropBox.
Or ask us to be added to our shared DropBox folder.

New in this prerelease of version 13.5 of the
MBS FileMaker Plugin:
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/, in
DropBox folder or ask for being added to the DropBox shared folder.
Just two months left until
Claris Engage 2024, 6th to 8th February 2024 in Austin, Texas.
The
Claris Engage conference will take place one day in the Apple Campus (6900 West Parmer Lane) for training and keynote. After the keynote, we'll meet each other at a party with food and drinks. Plenty of time to welcome old friends and talk about the keynote content. The other two days are on a different Apple Campus (5505 Parmer Lane). All the sessions will be there with lunches and refreshment breaks.
I hope to meet a lot of users of
MBS FileMaker Plugin there, answer questions and have a great time!
For our next pre-release, we did a big change. We reduced the number of
plugin parts from about 500 to now about 400. About a 20% reduction. This saves us some build times. We build each plugin part for 13 targets and thus building 5200 dylib/dll/so files is better than build 6500 ones.
How did we do this?
Well, we merged over 100 plugins parts together internally. For example if you build a Windows app using our Windows USB classes, we had several plugin parts. But it is quite likely you would refercence all the parts for Windows USB if you would write such an application. Since these three plugin parts had common code, merging them reduced the size of the total code. Often merging three parts makes the resulting plugin part smaller than 2 of them.
Old size of all 52 plugins was 879 MB and now is 832 MB, a 47 MB saving. You may check if your application become bigger or smaller as your milage may vary. Due to the reduced number of plugin libraries to load, the IDE needs about 20% less time to start.
Please let us know if you find issues with your projects. Everything should just work fine like before.
Door 6 - MongoDB
Fact of the day |
---|
MongoDB is the backend of Claris Studio, unfortunately you cannot use the advantages of MongoDB directly with Claris Studio, but MBS makes it possible.
|
Welcome to December 6th.
Today is St. Nicholas Day and we also want to take part in filling the Christmas boot with our calendar.
Today it contains MongoDB.
The special thing about MongoDB is that it is not a relational database based on tables and relationships,
but its data has a JSON-like structure.
This allows you to perform queries that were previously not possible due to the restriction of relationships or table limits.
In a MongoDB database we can have several collections.
These collections can in turn contain several documents.
The documents can be compared with data records,
with the difference that different documents in a collection do not have to share the same structure.
For example, you can have data in one and the same collection that describes the data for an employee and
for a warehouse item. So you can easily find out who is in your company longer:
the carpet in the warehouse or your trainee.
(more)
Let us show you the built-in functions in JSON Query and how to use them in FileMaker with MBS FileMaker Plugin.
abs
Returns the absolute value of a number.
Run abs() on a value in an array:
MBS( "JSON.Query"; "[-3]"; "abs($[0])")
[
3
]
Or find all values with an absolute value > 3, so we remove small values from the array:
MBS( "JSON.Query"; "[-3, 5, -6, 1]"; "$[?abs(@)> 3]")
[
5,
-6
]
(more)
In Xojo variable declaration somewhere inside a piece of code, you can use the static keyword. Whether you are in an event handler, a menu handler, a method or a global function doesn't matter. Just swap your "var" or "dim" with a "static" and you get a global variable. Instead of allocating memory for the variable on the stack and thus loosing the value on the end of the current code block, the static variable will remember the value. You can easily use it as counter for how often a method is called or for a global dictionary to cache results.
Here is a sample for a method which counts how often it gets invoked:
Sub testCounter()
Static counter As Integer
counter = counter + 1
System.DebugLog CurrentMethodName+" called already "+counter.ToString+" times."
End Sub
(more)
Door 5 - WindowsOCR
Fact of the day |
---|
If you want to program a cross-platform solution or need text recognition for older Windows versions, you can use functions of the Tesseract component from the MBS FileMaker Plugin.
|
In Door 2 we already introduced you to a way of performing text recognition under Mac.
But this possibility is not only available for Mac in the MBS FileMaker Plugin, but the MBS FileMaker Plugin also makes it
possible to use Windows' own OCR functions.
These WindowsOCR functions are available under Windows 10 and 11.
You can test whether you can use the functions under an operating system by running the WindowsOCR.Available function.
If you can use the functions, first create a new OCR engine with WindowsOCR.New.
This function returns a reference number which you can use in other functions to address the OCR engine.
In this function, you can also optionally specify which language is to be recognized by the engine.
If you skip this parameter, the language, that you get back with the WindowsOCR.CurrentInputMethodLanguageTag function,
is automatically used for language recognition. Which languages can be recognized depends on which languages are
installed on your system. You can obtain a list of the languages that you can currently use in your system with
WindowsOCR.AvailableRecognizerLanguages.
(more)
Door 4 - Speech
Fact of the day |
---|
A voice output can not only make reading easier, but also creates freedom for people with physical disabilities.
|
In this door, you have the opportunity to ensure that your solution never has to be at a loss for words again.
Today we are teaching your application to speak, because MBS offers speech output for Windows, Mac and iOS with the
Component Speech.
If we want to output a text, we can use the Speech.Speak function.
We first pass the text to be read out in the parameters.
That's enough for now.
Optionally, we can also choose from various speakers.
You can find out which speakers are available with the Speech.AvailableVoices function.
This function provides you with a list of all speakers.
You can specify in this function whether you want the speaker names or the ID for the speaker to be displayed in this list.
If you want to use a specific speaker in the Speech.Speak function,
you need to enter the ID.
In the Speech.Speak function, you can also set whether or not your script should be continued while the
speech output is running. Stopping a script also makes sense if you call the Speech.Speak
function in the script several times so that the text that follows is also read out and is not lost
because another text is being read out.
You can also set the volume and playback rate in the function. The volume is between 0.0 (silent) and 1.0 (full).
The playback speed ranges between 0.0 (silent) and 2.0 (double speed).
The default value for both settings is 1.0.
(more)
Door 3 - Binary File
Fact of the day |
---|
You may also be interested in the Text component. Because you can also create a text file with this component.
|
Behind door 3 is a component that is mostly unseen,
but is used in many applications by customers and has become essential.
It is the BinaryFile component.
You can use it to read binary data from a file and also write it to a file.
But what is it actually good for?
Although the texts are saved as binary data,
you can also create normal text files with this component and read them out again later.
For example, you can create a log file yourself in which you can write information.
We would like to do this now by logging in the file when a certain script has been called and what result it has.
The aim is to have as less code as possible in the script that we want to log so that the script doesn't become confusing.
For this reason, we use the Perform Script script step and call a script that writes the desired text to the log file.
We pass the text that we want to write to the log file as a parameter.
In this way, for example, the results that were calculated in the script can also be written to the file.
(more)
Door 2 - Vision
Fact of the day |
---|
The MBS FileMaker Plugin not only offers you the Apple Vision as a framework, using MapKit you can also integrate Apple maps into your application or take pictures with your iPhone via Continuty Camera and store them directly in FileMaker.
|
The second door provides something for Mac users.
Apple provides a framework called Vision.
With this framework you can recognize barcodes,
recognize texts from images or classify images into categories with the help of machine learning, e.g.
so that you can search for them in your image database. This framework makes MBS usable with the plugin for FileMaker.
Barcode recognition
Let's first look at the possibility of recognizing multiple barcodes on an image.
You simply pass the image to the Vision.DetectBarcode function as a parameter and
Vision then searches for the barcodes on the image and returns a JSON in which the barcodes are listed.
If you only want to search for QR codes on the image, for example,
you can restrict the barcode types in the search by specifying the desired types as parameters.
You can find out which barcode types can be recognized with Vision on your computer using the Vision.SupportedSymbologies
function.
(more)

New in this prerelease of the 23.6 plugins:
- Updated DynaPDF to version 4.0.81.236.
- Updated SQLAPI to version 5.3.
- Added FullyQualifiedFieldName property to DynaPDFFieldExMBS class.
- Added karFormData and kaffNonPDFA_4e constants to DynaPDFMBS class.
- Added Hidden attribute to JSONIteratorMBS, XMLIterateAttributeNodesMBS, XMLIterateChildNodesMBS, XMLIterateElementsMBS, DynaPDFIteratorMBS and PCRE2IteratorMBS classes to hide it from auto complete. Since you use it via for each loops indirectly, you never need to use these classes directly.
- Changed CallDelegateOnMainThreadMBS delegates to be hidden for auto complete.
- Fixed GetDelegateParametersMBS, GetDelegateTargetMBS and GetDelegateWeakMBS functions to work better in newer Xojo versions.
- Fixed an endless loop in JSONMBS class when running Search function with a bad query. Now propergates the exception properly.
- Fixed JSON, DynaPDF and plugin to compile again with Xojo 2019r1.
- Added SortArrayMBS methods to sort with/without a delegate and ascending or descending.
- Updated openssl library to version 3.1.4.
- Optimized text handling to be faster, which affects various string functions like ContainsWholeWordMBS.
- Added CopyArrayMBS methods to copy array data to second array of same type.
- Added target flags to our delegates to make sure they are available on the right targets.
- Updated to LCMS 2.16fc1.
- Improved array access for the plugins.
- Added checks for fillSeries and fillDateSeries in CDRanSeriesMBS class to better handle if arrays are nil.
- Improved array conversion from Xojo array to JSONMBS array.
- Fixed crash in NSIndexPathMBS when passing nil array to Constructor or indexPathWithIndexes method.
- Improved NSSearchFieldControlMBS to scroll horizontally.
- Added DynaPDFParserMBS class.
- Fixed some flags for delegates to work better in the future.
- Added cmsV2Unicode function to LCMS2ProfileMBS class.
- Added Scrollable property to NSSearchFieldMBS class.
- Added more properties to CURLEmailMBS class for debugger.
- Updated SQLite to version 3.44.1.
- Added ApplyMergePatch, ApplyPatch, MergePatchFromDiff, PatchFromDiff to JSONMBS class.
- Fixed string parser in LargeNumberMBS to not break on a minus sign sometimes.
- Added BigNumberConversionMBS class.
- Added new GetStringValue and SetStringValue methods to BigNumberMBS class.
- Added new GetStringValue and SetStringValue methods to LargeNumberMBS class with more options.
- Fixed OpenMTInputFile method in CURLSMBS class to remove InputData first.
- Fixed SetupAWS and SetupOAuth in CURLSMBS class to reset NoBody flag if new transfer is not head.
- Implemented EOF and BOF for SQL Plugin for RowSets to make for-each loops work better, but AutoCache may need to be enabled if the database doesn't allow MoveFirst like SQLite.
- Added isBOF and isEOF to SQLCommandMBS class.
- Improved WindowsDeviceInformationPairingMBS class to keep reference to the device object.
- Fixed a possible crash in SQLConnectionMBS destructor.
Download:
monkeybreadsoftware.de/xojo/download/plugin/Prerelease/ or
from DropBox.
Or ask us to be added to our shared DropBox folder.

New in this prerelease of version 13.5 of the
MBS FileMaker Plugin:
- Updated DynaPDF to version 4.0.81.236.
- Updated SQLAPI to version 5.3.
- Added FullyQualifiedFieldName as new field for DynaPDF.GetFieldAsJSON and DynaPDF.GetFieldAsJSON results.
- Added DynaPDF.GetFullyQualifiedFieldName function.
- Fixed WebView.InstallUserMediaAccess to not return error when called a second time.
- Added flags for List.BestMatch and QuickList.BestMatch to use Jaro-Winkler distance optionally and optionally return list of top 5.
- Added Command-Option-Cursor key shortcuts for relationship graph on macOS to align items.
- Added Command-Option-Shift-Cursor key shortcuts for relationship graph on macOS to resize items to smallest/biggest size.
- Fixed ListDialog functions to not use column widths if you have only one column.
- Fixed copy variables command to not limit it to 500 lines.
- Improved script coloring to better read script lines.
- Added caching for variable check to improve performance for longer scripts.
- Fixed an endless loop in JSON.Search function with a bad query. Now propergates the error properly.
- Implemented Time.Parse for Windows.
- Improved animation for ProgressDialog functions on macOS.
- Fixed an issue with auto completing underscore prefixed local variables.
- Added Phidget.DisableServerDiscovery and Phidget.EnableServerDiscovery functions.
- Added SyntaxColoring.GetCodeFoldingEnabled and SyntaxColoring.SetCodeFoldingEnabled function.
- Added List.Shuffle and QuickList.Shuffle functions.
- Improved performance for newer JSON functions.
- Fixed AppleScript.Compile to clear last error for AppleScript.LastErrorMessage function.
- Updated for future FileMaker version.
- Updated openssl library to version 3.1.4.
- Removed support for Claris Pro/Server.
- Updated to LCMS 2.16fc1.
- Improved format button to handle <=, >= and <> correctly. But you can also use ≤, ≥ or ≠ of course.
- Enabled Folders.UserDownloads to work in iOS.
- Fixed a problem in Matrix.CopyRow when using row names.
- Added Matrix.IndexOfFirstValueMatching function.
- Updated SQLite to version 3.44.1.
- Added DynaPDF parser functions: DynaPDF.Parser.ChangeAltFont, DynaPDF.Parser.Create, DynaPDF.Parser.DeleteText, DynaPDF.Parser.ExtractText, DynaPDF.Parser.FindText, DynaPDF.Parser.Line, DynaPDF.Parser.ParsePage, DynaPDF.Parser.ReplaceSelText, DynaPDF.Parser.SetAltFont, DynaPDF.Parser.TextMatrix, DynaPDF.Parser.WriteToPage.
- Added JSON.JSONPatch.ApplyPatch, JSON.JSONPatch.FromDiff, JSON.MergePatch.ApplyPatch and JSON.MergePatch.FromDiff functions.
- Added CNContactStore.ContactsMatchingURL function.
- Added FM.SQL.ToMatrix function.
- Fixed an edge case with Path.LastPathComponent to return last path name, even if a slash is on the end of the path.
- Added command-J to format text as JSON in a text view, e.g. in data viewer result.
- Fixed CURL.SetupAWS and CURL.SetupOAuth to reset NoBody flag if new transfer is not head.
- Fixed DynaPDF field functions to try different field structure sizes, if the DynaPDF DLL is much newer/older than our plugin and prevent errors about different structure sizes.
- Improved XL functions for form controls to take name of control in addition to index.
- Added XL.FormControl.JSON function.
Download at
monkeybreadsoftware.com/filemaker/files/Prerelease/, in
DropBox folder or ask for being added to the DropBox shared folder.