MBS FileMaker Plugin, version 8.5pr4

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

MBS Xojo Plugins, version 18.5pr4

New in this prerelease of the 18.4 plugins:
  • Updated ChartDirector control examples.
  • Fixed bug in CDPieChartMBS class and setExplode method with HiDPI.
  • Added delegates to documentation.
  • Fixed SystemInformationMBS.UserName for Windows.
  • Updated ChartDirector for Mac to newer build.
  • Improved handling of extra quotes in CSV text for SplitCommaSeparatedValuesMBS function.
Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

ChartDirector Plugin with HiDPI

We got updated ChartDirector control example projects for HiDPI and Xojo 2018r3 coming with next MBS Plugins:

When using our plugin, you can set CDBaseChartMBS.ScaleFactor to 2 to get our plugin to multiply all numbers by 2 and get you a higher resolution of the graph. This makes it easy to adapt an application for higher resolutions.

Xojo 2018 Release 3

The new version of Xojo was released this week. You probably read the announcement on the Xojo website. Improvements include Dark Mode (see blog article) and IDE enhancements (see blog article).

For MBS Plugin there is a little change we will apply to next plugin release: The list of data types for SQL in the Xojo plugin SDK was extended and now includes all variants of integer from 8 to 64-bit and signed/unsigned. We''ll update our MBS Xojo SQL Plugin to make sure we can pass right data type to Xojo for UInt16 and others. The plugin will stay with old behavior for older Xojo versions.

This Xojo release looks great so far and we are moving a lot of projects from older versions to the new Xojo 2018r3 release. The labels on Windows are a big improvement as well as the other changes to reduce flicker on Windows. And the new Xojo version works with Xcode 10, which we need for MacOS 10.14 Mojave.

There is a move in software development to get us 64-bit only on Mac. We like to avoid the annoying dialogs for 32-bit for our customers and soon start implementing the notarization for our apps. There is an AppWrapper update (3.9) coming to help there. But usually it will be a shell script to do the signing, the notarization and build a dmg. We want to automate the build process as much as possible.

For old Real Studio, it may come the time to say good bye. MacOS 10.15 may no longer support 32-bit and not run it.

See also review from Bob Keeney: Xojo 2018 R3

Strange looking PDF in Microsoft Edge and Apple Preview

Have you received PDF documents like this?

This is a PDF preview in Microsoft Edge. The PDF in question uses an OpenType font with postscript outlines with the variant without CID Font operators and this format is not supported by the Microsoft Edge PDF viewer.

For MacOS, the preview app shows the PDF, but when you print it, you get an empty paper.

We got a workaround for using this type of font with DynaPDF functions in our FileMaker and Xojo Plugins. So if you like to use such a font and get a working preview above, you need to not use the unicode encoding, but pick one of the 8-bit code pages like 1252.

Query the properties for font via GetSysFontInfos (Xojo) or DynaPDF.SysFontInfo (FileMaker) and check what you get back for BaseType. If the base type is OpenType. If it is open type and CIDOrdering property is empty, please don't use unicode code page for loading that font.

Or as I assume most clients do, is to trash the font and use one with proper character collection information. Otherwise having a checkbox to fall back to 1252 code page could be a checkbox to include for PDF output.

MBS Xojo Plugins, version 18.5pr3

New in this prerelease of the 18.4 plugins:
  • Added SCNCameraMBS, SCNLightMBS and SCNCameraControllerMBS classes.
  • Updated SQL Database plugin for changes in Xojo 2018r3.
  • Deprecated Account types for ACAccountTypeMBS class as Apple deprecated them for MacOS 10.14.
  • Changed SSH2TunnelMBS class to stop thread in destructor.
  • Added ReadFile method to SmartCardMBS class to read data from various smartcards (e.g. Swiss Health Insurance Card or Belgian Identity Card).
  • Added NSTextFinderMBS class.
  • Added find bar methods with NSScrollViewMBS class.
  • Added find bar methods with NSTextViewMBS class.
  • Added NSColorSpaceMBS.File property.
  • Added NSProcessInfoMBS.operationSystemVersion method and properties.
Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

New functions for smart card reading

In the last two weeks I worked on new functions to read smart cards. We got a client interested in reading Belgian national identity card via CryptoTokenKit functions in our plugins and a FileMaker client interested in reading Swiss Health Insurance cards. We got both working with our latest MBS Plugins.

For testing, we used both the Smart Card Reader from König (left) and the SmartTerminal ST-1144UB from Cherry (right). Both do the job with a little difference. For the left device, you can connect and query status, even if there is no card. The right one only allows to connect when you have a card inserted. Other readers work probably as this uses a standard interface and drivers are built into the operation system.

For Xojo we got the new CryptoTokenKit classes in MBS Xojo Mac64bit Plugin for the modern way Apple likes to handle this with asynchron operation and delegates. Beside this, we also go the older cross platform way via PCSC API and the ReadFile method in and SmartCardMBS class.

For FileMaker, we added a new SmartCard.ReadFile function for Mac and Windows in the upcoming MBS FileMaker Plugin version 8.5.

Whatever function you use, you can pass the right file ID and read the files you need from the smart cards. We also got a function to split the data into the parts. See SmartCard.SplitValues for FileMaker and SmartCardMBS.SplitValues function for Xojo.

MBS Sale for Conferences

In the last week and the coming week, we have seven FileMaker conferences in Europe. Five are sponsored by Monkeybread Software. For three conferences, I will attend and present about our plugin.

We like to reward people coming to the conferences, so we make a special conference offer:

20% on all licenses including updates.

If you like to use that offer, just order via web store and use coupon code FMK2018. Add first to shopping cart and than put the coupon code in the field.

Enjoy the conferences and see you soon!

Reading Belgian national identity card

As you may know all Belgians have an identify card. We recently added classes for CryptoTokenKit framework on Mac and translated a sample project from Swift to Xojo to read those card. Works very well to get basic information, address details and the picture of the person.

The same could have been done with our SmartCard classes. And as those classes use the PCSC interface on MacOS, Windows and Linux you could even get it done cross platform.

But for newer development on MacOS Apple prefers to use their own frameworks, so we got the CryptoTokenKit plugin part in the Mac64bit plugin.

URLs without UserName and Password please

With last plugin release we enabled the option for CURL to disallow you passing user name and password. As URLs are sent to proxy and may be logged at the web servers, we prefer to not include credentials in the URL. And if you use the email address for user name, the name in the URL never worked.

So for the future, please separate them and put the credentials in the relevant options:

In FileMaker:

Set Variable [ $curl ; Value: MBS("CURL.New") ]
Set Variable [ $r ; Value: MBS("CURL.SetOptionURL"; $curl; $URL) ]
Set Variable [ $r ; Value: MBS("CURL.SetOptionUsername"; $curl; "xxx") ]
Set Variable [ $r ; Value: MBS("CURL.SetOptionPassword"; $curl; "yyy") ]

In Xojo:

dim curl as new CURLSMBS
curl.OptionURL = URL
curl.OptionUserName = "xxx"
curl.OptionPassword = "yyy"

If you still use URLs with username and password, please move to passing them with the username and password properties.

If you really can't change your solution, you can still use CURL.SetOptionDisallowUserNameInURL (FileMaker) and OptionDisallowUserNameInURL property in CURLSMBS/CURLNMBS and CURLMBS classes (Xojo) to enable username and password in URLs.

MBS Xojo Plugins, version 18.5pr2

New in this prerelease of the 18.4 plugins:
  • Updated DynaPDF to version
  • Fixed issues with printer settings for DynaPDFMBS print methods on Windows.
  • Improved RemoveAccentsMBS to include greece characters.
  • Changed CDBaseChartMBS.MakeChartPicture to set resolution of picture to ScaleFactor * 72 dpi.
  • Changed SQLDatabaseMBS to return RecordSet where you can query names of columns even if you have no rows.
  • Fixed bug in PaletteCalculatorMBS.GetNearestIndexOfColor with color parameter.
  • Fixed FinderUpdateMBS for 64-bit to work by calling internally NSWorkSpaceMBS.noteFileSystemChanged.
  • Added more NSErrorMBS methods to create custom error objects.
  • Fixed a bug to avoid crash with RegisterMBSPlugins with wrong license key.
  • Fixed bug in SSL initialization introduced in pr1.
  • Updated to zlib 1.2.11.
  • Fixed bug in DynaPDF print functions (made white pages) and fixed example (printed only one page).
  • Fixed bugs in WindowsMidiOutputMBS and WindowsMidiInputMBS for 64-bit.
  • Fixed SystemInformationMBS.SystemFont for Mac.
  • Added new plugin part to Mac64bit plugin for CryptoTokenKit from Apple.
  • Fixed problem with SystemInformationMBS.Computername and MBS.ComputerName returning extra characters.
Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

CURL Up 2019

The CURL conference for 2019 is announced:

curl up 2019 will take place in Prague, the Czech Republic the last weekend of March.

When: March 29-31, 2019
Where: Prague, Czech Republic
Venue: Charles University

For details, please check the website.

Maybe we can arrange some developer meeting with our Xojo and FileMaker clients, too?

Call stored procedures with output parameters

As you know MBS Xojo SQL Plugin can execute stored procedures. For that you normally just pass the name of the stored procedure instead of a SQL command. The plugin than queries the details for the stored procedure like the input and output parameters. You can set input parameters and call execute. After you got all the result sets read, the last data package from the server brings the return code and the output parameter values. Check this sample code: (more)

MBS Xojo Plugins, version 18.5pr1

New in this prerelease of the 18.4 plugins:
  • Updated to LibXL 3.8.3.
  • Removed draggingSourceOperationMaskForLocal events (deprecated in MacOS 10.7).
  • Rebuild with Xcode 10. Minimum MacOS version is now 10.9.
  • Added SetMethodPreference and SupportedAlgorithms methods to SSH2SessionMBS class.
  • Updated SQLite to version 3.25.2.
  • Added more methods for NSFileManagerMBS.
  • Changed methods in NSFileManagerMBS to be regular ones, not shared. This is needed as we may have multiple file managers.
  • Updated OpenSSL to version 1.1.1 for all targets.
  • Added CipherMBS.CipherNames and DigestMBS.DigestNames functions.
  • Added CipherNames and DigestNames to SSH2SessionMBS and CURLSMBS classes.
  • improved DynaPDFMBS.PrintPDFPage to use DevMode data if set.
Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.
The biggest plugin in space...


Jul 2024
Jun 2024
May 2024
Apr 2024
Mar 2024
Feb 2024
Jan 2024
Dec 2023
Nov 2023
Oct 2023
Sep 2023
Aug 2023
Jul 2023
Jun 2023
May 2023
Apr 2023
Mar 2023
Feb 2023
Jan 2023
Dec 2022
Nov 2022
Oct 2022
Sep 2022
Aug 2022
Jul 2022
Jun 2022
May 2022
Apr 2022
Mar 2022
Feb 2022
Jan 2022
Dec 2021
Nov 2021
Oct 2021
Sep 2021
Aug 2021
Jul 2021
Jun 2021
May 2021
Apr 2021
Mar 2021
Feb 2021
Jan 2021
Dec 2020
Nov 2020
Oct 2020
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