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


MBS FileMaker Plugin 7.0 - More than 4400 Functions In One Plugin

Monday 23 January 2017 at 11:20 am
Nickenich, Germany - (January 23rd, 2017) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 7.0 for Mac OS X, 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, Mac, 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 7.0 has been updated and now includes over 4400 different functions, and the versatile plugin has gained more new functions:

New functions help you read details from X509 certificate files. You can read PKCS12 files and extract public and private keys as well as additional certificates. You can than write keys or certificates as PEM files and use them with our CURL functions.

Our new XML functions help you find nodes and attributes in XML text. You can extract text and subtrees. To process XML efficiently you can let the plugin read XML and put values in local variables in your script.

For CURL we added new functions to batch download files via FTP. Of course you can still query yourself the list of files via plugin in a directory and than download several files one after each other. But now we have options to do this all in one transfer and with the use of wildcards to specify which files to fetch.

Using the new function FM.AllowFileDragDrop you can allow users to drag and drop container with files from FileMaker to other applications, e.g. the Finder. And if needed you can switch this on/off on layout changes.

For DynaPDF we added new functions to query or set raw content of a page. You can rotate page templates and add page links or watermark annotations to your PDF pages.

As FileMaker on Mac is now 64-bit in most cases, we include an Apple Script to create 32 or 64-bit only plugin. The MBS Plugin in our plugin download is for both and you can split it to get a smaller plugin file if needed.

The functions to work on Word files have been improved. They should now be able to replace tags with multi line texts. And if you have a table in your template, we can now remove rows there, too.

When you run SQL queries in FileMaker using our FM.SQL.Execute functions, you can later query result as text. Or we provide the results properly encoded for CSV export.

We improved PrintDialog, PortMidi, LDAP, Audit, ImageCapture, SerialPort line reading, SmartCard, SQL functions and more. DynaPDF is updated to 4.0.8.19, LibXL to version 3.7.2 and SQLite to 3.16.2.

See release notes for a complete list of changes.

MonkeyBread Software Releases the MBS Xojo plug-ins in version 17.0

Monday 23 January 2017 at 11:02 am
NICKENICH, Germany (January 23rd, 2017) -- Monkeybread Software releases version 17.0 of the MBS plug-in for Xojo and Real Studio.

The MBS plug-in comprises a collection of several plug-in parts which extend the Xojo (Real Studio) development environment with 2,400 classes featuring over 61,000 documented functions. Our plugins support all three platforms Mac OS X, Windows and Linux with all project types desktop, web and console including 64-bit and ARM targets.

Some of the highlights on the 17.0 update:

Sometimes you need to provide certificates and SSL keys to CURL plugin for secure transfers. To make it easier to query details from those certificates, we added a X509MBS class. The PKeyMBS class helps working with private or public keys, which you can read using our new PKCS12MBS class.

For better encryption you can now use our TwoFishMBS class. TwoFish is derived from the older Blowfish encrypter and was one of the AES finalists. Rijndael was choose for AES, but Twofish may be a good alternative in some cases.

For macOS we added the LAContextMBS class to query local authentication. This includes using TouchID on the latest Macbook Pro. Please note that this feature is only available for 64-bit applications.

Our DynaPDF plugin now supports loading newer DynaPDF libraries and use them instead of the built-in library. For page templates we added a convenience function to rotate them. The DynaPDFEditTextMBS class provides now more details on the text to replace so you can use it to find texts on PDF pages and highlight them. As we fixed a few things for printing with DynaPDF, please update your code to match our examples to keep it working well.

The WordFileMBS class to work on Word files have been improved. It should now be able to replace tags with multi line texts. And if you have a table in your template, we can now remove rows there, too.

Our WKWebViewControlMBS control to use WebKit 2 on Mac in 64-bit applications now supports more events. You can use that control instead of a HTMLViewer control. In 32-bit applications, you get WebKit 1.0 while in 64-bit applications you get WebKit 2.0. We try to keep functionality equal for both implementations.

We improved PHP class, PortMidiStreamMBS, CGImageSourceMBS, JSONMBS classes and more. We added MeasureRotatedTextMBS to measure size of text for drawing with DrawRotatedTextMBS.

Finally we updated DynaPDF to version 4.0.8.19, LibXL to version 3.7.2 and SQLite to 3.16.2.

See release notes for a complete list of changes.

MBS FileMaker Plugin 7.0 - 4400 Funktionen in einem Plugin

Monday 23 January 2017 at 10:52 am
23. Januar 2017 - Monkeybread Software veröffentlicht heute das MBS Plugin für FileMaker in Version 7.0, mit inzwischen über 4400 Funktionen eines der größten FileMaker Plugins überhaupt. Hier einige der Neuerungen:

Mit neuen Funktionen können Sie jetzt Details aus X509 Zertifikate lesen. Sie können PKCS12 Dateien öffnen und die privaten und öffentlichen Schlüssel auslesen oder weitere enthaltene Zertifikate. Sie können dann die Schlüssel in PEM Dateien schreiben und Sie mit den CURL Funktionen benutzen.

Unsere neuen XML Funktionen helfen Ihnen XML Knoten und Attribute im XML Text zu finden. Sie können dann Texte und Teilbäume extrahieren. Um XML effizient zu verarbeiten können sie das XML einlesen lassen um automatisch Variablen für ihr Skript zu definieren.

Für CURL haben wir neue Funktionen für automatisierte Downloads von mehreren Dateien via FTP. Natürlich können Sie weiterhin selber per Plugin die Liste der Dateien abfragen und eine Datei nach der anderen runter laden. Aber jetzt haben wir Optionen um das automatisch in einem Transfer zu machen. Sie können ein Suchmuster angeben um nur bestimmte Dateien zu laden, zum Beispiel alle mit einer bestimmten Dateinamenerweiterung.

Über die neue Funktion FM.AllowFileDragDrop können Sie Drag & Drop erlauben für Container mit Dateien. So ziehen Sie Dateien aus FileMaker direkt auf den Schreibtisch oder in andere Programme. Natürlich kann man das pro Layout an/abschalten.

Für DynaPDF haben wir neue Funktionen um die Rohdaten von einer PDF Seite abzufragen oder zu setzen. Vorlagen für PDF Seiten können Sie jetzt drehen und Seitenverweise oder Wasserzeichen zu PDF Seiten hinzufügen.

Da FileMaker für Mac jetzt meistens in 64-bit läuft, liegen dem Plugin AppleSkripte bei mit denen Sie Plugins für 32-bit oder 64-bit erstellen können. Das MBS Plugin im Download enthält 32-bit und 64-bit Unterstützung und beim Aufteilen bekommen Sie eine kleinere Plugindatei.

Die Funktionen für Word Dateien wurden verbessert und Sie können jetzt mehrzeiligen Text ersetzen. Wenn Sie in der Vorlage eine Tabelle haben, können Sie jetzt extra Zeilen löschen.

Wenn Sie SQL Abfragen über die FM.SQL.Execute Funktion laufen lassen, können Sie jetzt auch das Ergebnis einfach als Text bekommen. Oder für einen CSV Export kann das Plugin die Texte passend kodieren.

Verbessert wurde außerdem die Funktionen zum PrintDialog, PortMidi, LDAP, Audit, ImageCapture, SerialPort mit lesen in Zeilen, SmartCard, SQL Funktionen und mehr. DynaPDF kommt jetzt in Version 4.0.8.19, LibXL in Version 3.7.2 und SQLite in Version 3.16.2.

Alle Änderungen in den Release Notes.

Dash help archives updated

Sunday 22 January 2017 at 11:28 pm
Just updated the archives for the Dash application. Does the auto update work for you?

So here you can click to launch Dash and install our plugin help:
MBS Xojo Plugins and MBS FileMaker Plugin



You find the docset links also on our reference websites where you can download archive manually if needed:
MBS FileMaker Plugin Documentation for Dash and MBS Xojo Plugins Documentation for Dash

Feedback is welcome.

MBS FileMaker Plugin Schulung auf Deutsch bei der FMK 2017

Friday 20 January 2017 at 1:33 pm
Auch 2017 biete ich wieder eine MBS FileMaker Schulung auf Deutsch an.
Am Tag vor der FileMaker Konferenz in Salzburg, am 11. Oktober 2017 (Mittwoch) von ca. 9 bis 17 Uhr.
  • Neues im MBS Plugin.
  • Rundgang durch Beispiele
  • MBS Plugin verwenden mit FileMaker Cloud
  • MBS Plugin verwenden mit FileMaker iOS SDK
  • Erweiterungen im Skript Workspace
  • Beliebte Pluginfunktionen
    • FTP/SFTP Up/Download
    • Webservices einbinden
    • Bildbearbeitung
    • Barcodes generieren und erkennen
    • Arbeiten mit dem Webviewer
    • SQL Anfragen in FIleMaker oder an andere Datenbanksysteme
  • Zeit für Fragen
Anmeldung bei mir. Kosten 99 Euro + MWSt. inkl. Mittagessen und Kaffeepausen.
Bitte Umsatzsteuer ID angeben bei Anmeldung.

Oder melden Sie sich bei der Denkform an für den MBS Workshop am 2. März und 7. Dezember 2017 in Hofheim (Taunus).

MBS Xojo / Real Studio Plugins, version 17.0pr4

Friday 20 January 2017 at 12:24 am
New in this prerelease of the 17.0 plugins:
  • Updated DynaPDF to version 4.0.8.19.
  • Added checks to Nikon module to avoid reentry and raise exceptions if you try to.
  • Added SetGestureConfig/GetGestureConfig methods in WinPointerEventsMBS to use controls as target.
  • Fixed bug with DynaPDFTableMBS.GetNextHeight function.
  • Added WinSelSubScriptMBS and WinSelSuperScriptMBS to TextArea control.
  • Fixed PageBreak event in DynaPDFMBS to work with addhandler.
  • Fixed DOMHTMLDocumentMBS.body function.
  • Changed DrawRotatedTextMBS to use symbol charset for Wingdings font on Windows.
  • Added PortMidiStreamMBS.currentTimeStamp.
  • Added NSExceptionHandlerMBS.Disable and Enable.
Download: monkeybreadsoftware.de/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

MBS FileMaker Plugin, version 7.0pr4

Thursday 19 January 2017 at 9:51 pm
New in this prerelease of the 7.0 MBS FileMaker Plugin: Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

FileMaker DevCon 2017

Thursday 19 January 2017 at 7:46 pm


See you in Phoenix Arizona for the FileMaker Developer Conference, 24th to 27th July 2017.
The ticket price is down to $899, but you also get only 2 conference days plus a day for keynote and/or training. Hotel $149/night.
FBA members get an extra day.

Field Colors in FileMaker via other field and Xojo app

Thursday 19 January 2017 at 11:21 am
There was a question on how set field background color in FileMaker based on a color in another field:


So we define a field which gets a color using formatting rules. The other field defines the hex color code to use. To keep it smaller, we only allow 4096 colors: Those where the two digits per color channel are equal. So from 000000 to FFFFFF with steps of 11. e.g. put FF0000 here to make field background red.

To generate the conditional formatting rules, we use a Xojo app:

The workflow is like this:
  1. Cut or copy a field in layout mode in FileMaker.
  2. Go in the app and type the right field name for the condition.
  3. Press the button to add formatting rules.
  4. Paste field in layout with colors.
Please try it. To change/build the Xojo app, please download Xojo on the Xojo website. For just running the project with your custom modifications in the IDE, you won't need to buy a license.

Download test database and project here: FieldColor.zip

FileMaker Pro 15.0.3 Update

Wednesday 18 January 2017 at 8:00 pm
FileMaker Inc today released FileMaker Pro 15.0.3, an update to address bug fixes and various compatibility issues.

You can read in the knowledge base about FileMaker Server 15.0.3 (6 fixes),
FileMaker Pro (Advanced) 15.0.3 (6 fixes) and FileMaker Go 15.0.3

As usual FileMaker provides updaters only for Windows and we miss the ones for Mac. So here are the links for Mac:

FileMaker Advanced 15.0.2 to 15.0.3:
https://productupdates.filemaker.com/pro/15.0.2/release/fmpa.15.0.3.305.updates.pkg.zip

FileMaker Pro 15.0.2 to 15.0.3:
https://productupdates.filemaker.com/pro/15.0.2/release/fmp.15.0.3.305.updates.pkg.zip

Be sure to only apply them when you have the right 15.0.2 version before and FileMaker is not running.

curl meeting in Germany, March 2017

Tuesday 17 January 2017 at 8:26 pm
On the weekend of March 18-19, 2017, the first ever curl meeting is taking place is Nuremberg, Germany.

Users, developers, binding authors, application authors, curl maintainers, libcurl hackers and other people with a curl interest are welcome!

I will try to be there and finally meet the curl people. I've been using curl for various projects including Xojo and FileMaker plugins for over 10 years.

SuperScript and SubScript for Xojo Textarea

Tuesday 17 January 2017 at 8:06 pm
just added to MBS Xojo Plugins:



Our new example project shows how to use the new functions WinSelSubScriptMBS and WinSelSuperScriptMBS on the TextArea control. The example includes a module to do the same for Mac via NSTextViewMBS class.
Screenshots from Mac OS X 10.10, Windows 7 and Windows 10. If you like to try it, let me know.

MBS Xojo / Real Studio Plugins, version 17.0pr3

Friday 13 January 2017 at 6:18 pm
New in this prerelease of the 17.0 plugins:
  • Fixed an issue with DynaPDF printing blank papers.
  • Changed SQL plugin to detect ODBC to FileMaker and handle that better for reading text fields and avoid a crash.
  • Added MeasureRotatedTextMBS function.
Download: monkeybreadsoftware.de/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

MBS FileMaker Plugin, version 7.0pr3

Friday 13 January 2017 at 5:18 pm
New in this prerelease of the 7.0 MBS FileMaker Plugin:
  • Changed Audit: CurrentTimeStamp, CurrentTime and CurrentDate. Those can now be TimeStamp, Time, Date instead of Text fields.
  • Changed Audit: FieldID, TableID and RecordID can now be number fields instead of text fields.
  • Fixed progress dialog updates for macOS Sierra with CURL synchronous upload.
  • Fixed an issue with PrintDialog functions and Mac OS X 10.6.
  • Enabled script colors for German script editor for FileMaker 13 (broke in 6.5).
  • Added PrintDialog.GetReset and PrintDialog.SetReset.
  • Added progress window option to Files.CopyFile and Files.MoveFile for Windows.
  • Changed SQL plugin to detect ODBC to FileMaker and handle that better for reading text fields and avoid a crash.
  • Added enable parameter FM.AllowFileDragDrop, so you can disable/enable it when needed.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Free tickets for young developers for MBS Xojo Conference

Tuesday 10 January 2017 at 8:34 pm
Monkeybread Software is pleased to announce the MBS Xojo Conference in metropolitan Berlin, Germany. We will meet in the lovely Ellington hotel in the center of west Berlin. The hotel is near Kurfürstendamm, the Zoo and KaDeWe. Beside our two conference days, we will have an accompanying social program with our dinner event and optional two training days. For the evenings we will have a casual get-together in the hotel bar or beer garden.

Monkeybread Software would like to offer young developers the possibility to meet the Xojo community, get in touch with other developers and maybe find first clients or an employer.

For the 2017 conference MBS decided to help your developers: Three conference tickets are provided free of charge to three young developers so they have the chance to join our conference. Please apply until 4th February 2017 to get one of the tickets.

The Xojo community is growing and we want to get more young people to join the conference. Especially younger people may hesitate to join a conference due to cost and by giving away free tickets, we encourage them to come. If you know a friend, student or pupil who is interested in Xojo, please tell them about this offer. Or maybe your own child may apply and join you coming to the conference?

Requirements:
  • You speak english and you can follow the conference.
  • You are 25 years old or younger.
  • You have done your first Xojo projects and know Xojo a little bit.
  • You are sure you can cover your cost of travel, food and hotel room.
  • You have the required passport or Visa to travel to Berlin on yourself.
If needed, we may provide help to find low cost traveling or hotel room.

If you like to apply, please get in touch.

Batch sending Emails in FileMaker via MBS Plugin

Tuesday 10 January 2017 at 3:40 pm

As you may know you can use CURL functions in MBS Plugin to send emails. We include examples to show you how to send with attachments, html text and inline graphics. A recent example coming with 7.0pr2 showed you how to batch send emails. But that example sends emails one by one and each time with a new connection. I already improved the example here to reuse connections which helps a lot on speed. Still the big problem is that network transfers with uploads take time. The script waits while the Kilobytes for the email go through the network cables. 

 

Background processing

 

Luckily our plugin offers a function for cURL to run a transfer in background: CURL.PerformInBackground. Using this function we can start a cURL transfer and the script continues. We can prepare and send the next email while the last one is still uploading. Now you need to be careful and manage the connections and their status. To show you how this can work, we show you what we did in our updated example. Here is an excerpt from the script where we look for a free cURL session: 

 

...

#Find a non busy curl connection

Set Variable [$index; Value:1]

Loop

If [$curls[$index] = ""]

#found free index, setup new CURL session

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

Set Variable [$curls[$index]; Value:$curl]

Set Variable [$r; Value:MBS("CURL.SetOptionURL"; $curl; "smtp://" & $SMTPServer)]

Set Variable [$r; Value:MBS("CURL.SetOptionUsername"; $curl; $SMTPUser)]

Set Variable [$r; Value:MBS("CURL.SetOptionPassword"; $curl; $SMTPPass)]

...

Exit Loop If [1]

Else

#found used index

If [MBS( "CURL.IsRunning"; $curls[$index] ) = 0]

#found used index which is done

Perform Script [“HandleFinishedCURL”; Parameter: $curls[$index]]

Set Variable [$curl; Value:$curls[$index]]

Exit Loop If [1]

End If

End If

Set Variable [$index; Value:$index + 1]

If [$index = 9]

#Wait

Set Variable [$index; Value:1]

Pause/Resume Script [Duration (seconds): ,01]

End If

End Loop

...

(more)

Xojo job offer in southern France

Monday 09 January 2017 at 5:48 pm
MedinCell S.A. is a company located in Montpellier in southern France near the Mediterranean Sea.
They use my plugins for a few years now and are looking for another Xojo developer: (more)

Allow file drag and drop from FileMaker container field to Finder

Monday 09 January 2017 at 2:40 pm
On the weekend we run into the issue that you can store files in a container, but you can't simply drag them into other applications or to the Finder.

To enable the desired behavior with a new plugin function called FM.AllowFileDragDrop.

The plugin than intercepts the drag and drop in FileMaker and writes the data into a temp file, so the drag includes a file reference and does work with Finder and other applications.

Watch the video: AllowFileDrag
Requires MBS FileMaker Plugin 7.0pr2 plugin or newer.

MBS Xojo / Real Studio Plugins, version 17.0pr2

Monday 09 January 2017 at 12:03 pm
New in this prerelease of the 17.0 plugins:
  • Updated DynaPDF to version 4.0.7.18.
  • Added LoadLibrary functions to DynaPDFMBS, so you can use other DynaPDF DLL, e.g. other version.
  • Due to changes in PrintPDFFile we had to update our print examples for DynaPDF. Please update your code, too.
  • Added RotateTemplate function in DynaPDFMBS class.
  • Added more events for WKWebViewControlMBS control.
  • Changed plugin file names to include name of plugin and name of part.
  • Updated SQLite to 3.16.1.
  • Fixed bug in PKeyMBS.PrivateKey.
Download: monkeybreadsoftware.de/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

MBS FileMaker Plugin, version 7.0pr2

Monday 09 January 2017 at 11:12 am
New in this prerelease of the 7.0 MBS FileMaker Plugin: Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Older blog entries:

2017-01-08 Loading LibXL and DynaPDF libraries in our Xojo plugins
2017-01-07 FileMaker Conference .fmp[x]Berlin 2017
2017-01-07 FileMaker Stammtisch SaarLorLux
2017-01-07 Audit with MBS FileMaker Plugin
2017-01-06 Save the Date for XDC 2018 in Denver
2017-01-05 Early bird offer ending for MBS Xojo Conference
2017-01-04 MarkDown via HTMLViewer for Xojo and FileMaker
2017-01-04 SQLite Release 3.16.1
2017-01-03 xDev Magazine Issue 15.1
2017-01-02 FileMaker Magazin - MBS Artikel
2017-01-02 MBS Xojo / Real Studio Plugins, version 17.0pr1
2017-01-02 MBS FileMaker Plugin, version 7.0pr1
2016-12-30 Arbed 1.8.6 updated for Xojo 2016r4
2016-12-28 BKS Shorts 1.8.0
2016-12-27 New XML Functions in MBS FileMaker Plugin
2016-12-26 Xojo Developer Conference 2018
2016-12-25 Merry Christmas
2016-12-21 Finally Apple allows iPhone to stay silent in pockets
2016-12-19 Windows Error Codes
2016-12-16 FileMaker Stammtisch im Bärenpark

Archives

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