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

Packr The suitcase checklist

Saturday 29 April 2017 at 8:43 pm
Jérémie Leroy published an application made with Xojo on the iOS App Store:

You can download it for free on the iOS App Store.
And Jérémie told me attendees to our conference in Berlin next week get a free upgrade to Premium, so watch his presentation for the coupon code.

BKS Shorts Version 2.0

Friday 28 April 2017 at 5:45 pm
Bob Keeney just sent email about new release of his reporting tool BKS Shorts:

BKeeney Software (Lenexa, KS) has released version 2.0 of it’s Xojo reporting tool, BKS Shorts, today. BKS Shorts is the premier reporting tool for Xojo desktop and web applications and comes with an integrated Designer and Viewer components to make it easy for Xojo developers to get advanced reporting in their desktop and web applications.

Within a few minutes Xojo developers can incorporate the Report Designer component in their desktop applications and create rich, dynamic reports. Grouping on a field is easy as well as creating complex queries to filter data. It’s possible to ask for query parameters at runtime so end-users can filter data how they choose. Using XojoScript it’s easy to create incredibly complex reports that can vary text, visibility, and formatting at runtime based on field values.

The Report Viewer component is available for desktop and web applications. The viewer allows users to view their reports but also can ask them for parameters for the reports at runtime. For example it would be easy to allow users to specify their own date range for their reports. Reports in the viewer are searchable and with can be configured to allow for ‘drill down’ reports.

Reports can be printed and are resolution independent. They can also be exported to PDF (requires MBS DynaPDF Starter Edition), HTML, and CSV.

Shorts supports SQLite, MySQL, Postgres, CubeSQL, MS SQL Server, Informix (requires the SQL plugin from MBS), and ODBC.

Version 2 Highlights

  • Added Report Header
  • Added Report Footer
  • Now allow database fields in Report and Page Headers and Footers
  • Rewritten SQL engine that makes reports with a lot of groups faster
  • Field aggregates (sum, min, max, average, count) are now handled by the report rather than queried.
  • Barcode Fields (requires BarcodeGeneratorMBS from Monkeybread Software)
  • Project comes with a converter for On-Target Reports
  • Numerous bug fixes and tweaks

The normal price for Shorts is $300 USD and you receive the package in 100% unencrypted source code. Existing users receive a 50% discount and if they've not already received an email should contact support.

Requirements: Shorts 2.0 requires Xojo 2016 R1 and better. Windows users should avoid using Xojo 2016 R4 as there is a bug in the Xojo printing framework. Shorts works on macOS, Windows desktop environments (Linux is untested and unsupported). Shorts report viewer does work in web applications running on macOS, Windows, and Linux. Because of XojoScript 64-bit applications are not supported yet (though XojoScript can be removed to make it so)

More information at the Shorts page at bkeeney.com/allproducts/bkeeney-shorts/

You can create PDFs in Shorts by using our MBS Xojo DynaPDF Plugin.
DynaPDF Starter is included with OmegaBundle this year.

FM Conférence 2017, Rouen

Friday 28 April 2017 at 3:43 pm
The next French FileMaker Conference will be held at Rouen in Normandy from 18 to 20 October 2017.

La prochaine FM Conférence se tiendra p'têt ben à Rouen en Normandie du 18 au 20 octobre 2017.
P'têt ben qu'vous avez un truc à présenter à cette occasion pendant 15 ou 60mn. Alors, creusez-vous viiiite les méninges car y'aura p'têt ben pas assez de place pour tous ;).
Est-ce que toutes les infos sur la conférence sont sur notre site www.fmconf.com? P'têt ben qu'oui, p'têt ben qu'non… (traduction ici)

Gazouillis: fmconf

Videos from FileMaker Day in Vleuten

Friday 28 April 2017 at 10:44 am
On 11th March 2017, we had a FileMaker event in Vleuten near Utrecht in the Netherlands. I did two presentations about my MBS Plugin and recorded them:

MBS Plugin Presentation
Example Walkthrough

If you are interested in a similar event, let me know. The next English MBS Plugin presentation will be at DevCon.
Maybe in October for the European conferences, we can have a few more presentations and maybe even a training day. We already announced German training day for Salzburg.

LibXL 3.8.0 has been released

Thursday 27 April 2017 at 11:46 pm
LibXL version 3.8.0 is available.

What's new in the version 3.8.0:
  • added data validation feature for xlsx files
  • added Book::addPictureAsLink() method (xlsx)
  • added Book::moveSheet() method
  • improved speed of Sheet::setMerge() method (removed overlap checking)
  • improved compatibility with Apple Preview (xls)
  • fixed a bug in autofit feature for a custom format with % character
  • fixed issue with access to some worksheets for exported xlsx files from the SAS statistical package
  • fixed issue with 1900/2/1 date
  • fixed a bug with loading some xls files
  • fixed a bug in Book::load() and xlBookLoadUsingTempFile() with passing a full path with directories for temporary files (xlsx)
  • fixed a bug in Sheet::setCol() (xls)
  • fixed Sheet::getNamedRange() and Sheet::namedRange() methods for correct extracting the whole column or row as a range (xlsx)
New methods:
  • Book::moveSheet()
New methods only for xlsx format:
  • Sheet::addDataValidation()
  • Sheet::addDataValidationDouble()
  • Sheet::removeDataValidations()
  • Book::addPictureAsLink()
The LibXL library can be used with MBS Plugins in Xojo and FileMaker. Updated plugins will be available soon. As usual we add the new functions soon. If you need help or want to try the new version early, let me know.

MBS FileMaker Plugin, version 7.2pr4

Wednesday 26 April 2017 at 9:07 pm
New in this prerelease of the 7.2 MBS FileMaker Plugin:
  • Added ProtocolPreference parameter to SSH.Connect and Socket.Connect to request IPv4 or IPv6.
  • Improved font handling with syntax coloring, so we can now have bold fonts there.
  • Fixed coordinates for WebView.Screenshot with multiple screens.
  • Added call # for Trace, so you can better see which result belongs to which call.
  • Updated to DynaPDF
  • Improved thread handling with using thread local storage for per script values like error state.
  • Added developerExtrasEnabled and logsPageMessagesToSystemConsoleEnabled for WebView preferences.
  • Added new XL functions, e.g. for auto filter.
  • Added possibility to specify field and tables by ID for FM.InsertRecord and similar functions.
  • Added NewInstance parameter for Files.LaunchFile and Files.Launch function.
  • Fixed issue with WinSendMail.
  • Added Files.SetCreationDate.
  • Updated to Xcode 8.3.2
  • Added script step for MBS function calls which can be used in future FileMaker versions instead of Set Variable or Set Field.
  • Added ability to define your own evaluation based script steps.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

MBS Xojo Plugins, version 17.2pr4

Wednesday 26 April 2017 at 3:30 pm
New in this prerelease of the 17.2 plugins:
  • Fixed bug in SQLNumericMBS.NumericWithCurrency when using small negative numbers.
  • Added PictureMBS MapInRows and RawRowPtr function.
  • Added page print functions for DynaPDF.
  • Added DynaPDFPrintParamsMBS class.
  • Updated to DynaPDF
  • Fixed an issue with REALbasic 2007 and DynaPDF Plugin.
  • Fixed CalCalendarStoreMBS.EventsMT to work with calendars.
  • Updated to Xcode 8.3.2
Download: monkeybreadsoftware.de/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

FileMaker Stammtisch in Berlin

Tuesday 25 April 2017 at 2:24 pm
Once again I come to Berlin next week and I organize a FileMaker developer meeting in Berlin.

Date: 2nd May 2017
Time: Probably around 18 to 22 o'clock.
Location: A nice restaurant or beer garden.
Topics: FileMaker News, Conferences and Plugins.

If you like to join us, let me know by email and I keep you updated.

Save the Date for XDC 2018 in Denver

Tuesday 25 April 2017 at 09:23 am
Just one year till the XDC 2018 in Denver. Mark the dates in the calendar and make sure you can join the conference!

Mark your calendar today for XDC 2018, taking place April 25 - 27, 2018, in the Mile High City itself, Denver, Colorado! We will be staying at the lovely Magnolia Hotel, located very near Union Station and Larimer Square. More information, including registration information and the call for speakers coming soon.

I am looking forward to see you all in Denver!

The big Xojo conference 2017 will be 4th/5th May 2017 in Berlin, Germany.

Five days left for early bird tickets for FileMaker DevCon 2017

Monday 24 April 2017 at 10:35 am
If you plan to go, be sure to register till 28th April 2018 for early bird pricing.

See you in Phoenix Arizona for the FileMaker Developer Conference, 24th to 27th July 2017.
MBS will be present with a booth in the vendor area.

If you don't get a room in the JW Marriott Phoenix Desert Ridge hotel, you can try next door at the Marriott's Canyon Villas. Just a short walk over the street and parking area (0.4 miles) to the conference hotel.

Restart FileMaker with same database

Friday 21 April 2017 at 10:17 am
With next 7.2 plugin, we can now restart FileMaker and open the same database:

Set Variable [$dbpath; Value:Get ( FilePath )]

Set Variable [$dbpath; Value:MBS( "Path.FileMakerPathToNativePath"; $dbpath )]

Set Variable [$apppath; Value:MBS( "App.GetProcessPath" )]

Set Variable [$r; Value:MBS( "Files.Launch"; $apppath; $dbpath; 1 )]

Exit Application

Normally on Mac launching the app would use the same instance. But with the new flag 1 on the end, we start a new instance.
So this script will launch a new copy of FileMaker and quit the current application.

MBS FileMaker Plugin, version 7.2pr3

Wednesday 19 April 2017 at 2:33 pm
New in this prerelease of the 7.2 MBS FileMaker Plugin:
  • Added Files.SetModificationDate.
  • Added SyntaxColoring.GetMinCalcFontSize and SyntaxColoring.SetMinCalcFontSize to define minimum font size for calculation dialog.
  • Fixed bug with GMImage.DestroyAll.
  • Added Zoom Button for Script Workspace.
  • Removed for 64-bit the limits on how many connections/images/etc. you can make.
  • Added local and remote notifications for iOS.
  • Added email sending via email client on Windows (MAPI).
  • Implemented App.SetDockBadgeLabel and App.GetDockBadgeLabel for iOS.
  • Fixed SQL.InsertRecords to handle floating point numbers better.
  • Updated to Xcode 8.3.1
  • Updated SQLAPI to version 4.1.11.
  • Rewrote Audit Field Type cache to be more reliable.
  • Improved CURL progressbar handling, so you can see progress dialog while sending big email.
  • Fixed a problem with CURL AWS domain detection.
  • Fixed bug with resizing ListDialog on Windows and made it more resolution aware.
  • Added Volume and Rate parameters to Text.Speak function.
  • Fixed a bug in AVRecorder.Init to work better if no video device is found.
  • Fixed a bug with GMImage.NewFromContainer where referenced image file would stay open.
  • Added Dialog.GetButtonPressed function.
  • Fixed bug with missing variable check and future FileMaker.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

MBS Xojo Plugins, version 17.2pr3

Wednesday 19 April 2017 at 2:16 pm
New in this prerelease of the 17.2 plugins: Download: monkeybreadsoftware.de/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

Something about font sizes in FileMaker

Wednesday 19 April 2017 at 11:57 am
For the script workspace, I found a way to add zoom controls, so with FIleMaker 14 and newer you can soon zoom:

The buttons zoom out, 100% and zoom in.

And for various calculation dialogs, we can apply a minimum font size:

So whenever the plugin formats the formula, it can apply a bigger font size than FileMaker does by default.

Especially for presentations it may be worth to install MBS Plugin and adjust sizes.

Three weeks till MBS Xojo Conference in Berlin

Tuesday 18 April 2017 at 8:25 pm
The conference is coming closer and just three weeks are left. If you like to come, please check soon your schedule and make your reservations for traveling.

Monkeybread Software is pleased to host the MBS Xojo Conference in metropolitan Berlin, Germany. We 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 have accompanying social programme with our dinner event and optional two training days. For the evenings we have casual get-together in the hotel bar or beer garden.

Three weeks before we have 80 attendees from 17 countries.
Half of them speak German and a few came as far as USA, Canada and New Zealand!
This is the only Xojo related conference in the year 2017 an the biggest so far in Europe.

Please join us to meet special guests.
Check out discussion about sight seeing on the Xojo forum and the blog article from Ulrich.

Registration is still possible and you can join us 4th/5th May 2017 in Berlin. Rooms are available in the Ellington hotel.
See website for details: monkeybreadsoftware.de/conference

Send emails via Outlook

Tuesday 18 April 2017 at 12:46 pm
Several clients requested sending emails via mail client on Windows, especially using Outlook. So for next MBS Plugins we add WinSendMail functions. You can set subject, text, recipients and add attachments. Depending on the actual mail client, some features work different. For Thunderbird multiple attachments work nice, but Outlook returns always an error with more than one. But with Outlook we can pass a html file and leave text empty to send a html email.

Send text and add attachment:

You can include html in the email:

Thunderbird accepts two attachments:

With further testing, we will see what more works and what doesn't. But so far we are not affected by the Server Busy error or 32/64 bit issues, FileMaker itself runs into.

Meet Geoff Perlman in Berlin in three weeks

Monday 17 April 2017 at 9:56 pm
Last time Geoff Perlman, CEO of Xojo Inc., visited Germany for a conference was 2008. We are happy to have him back here for the upcoming MBS Xojo conference in Berlin.

The big Xojo event in the year 2017 takes place in the Ellington Hotel in West Berlin from 4th to 5th May 2017 and this is your chance to meet him and the other Xojo engineers without a trip to the USA. Geoff will of course talk in the keynote about what's new and coming for Xojo. Please bring your question for the Q&A after the presentation.

On second day Travis Hill, one of the Xojo engineers, will talk about the new Xojo framework. On the long run this will become the default framework, so be sure to learn how to use it, what benefits it has and how to adapt. Especially as the new framework can be mixed with old framework in your desktop apps. For iOS you will use the new framework exclusively.

We have 6 Xojo people at the conference in total and some come earlier and stay longer. You have the chance to talk to them beside the conference. If needed, make an extra appointment for some private meeting.

Notifications coming for FileMaker iOS SDK

Monday 17 April 2017 at 1:02 pm
As you may know we have our iOS SDK Extension for FileMaker iOS SDK.
We are working on an update to support notifications in the FileMaker iOS SDK:

So you can create local notifications in FileMaker, define title, subtitle, body, badge number and more. Than you add a trigger based on time (Seconds in future), date or a location. We can also receive remote push notifications, if you setup it correct on the server side.

This should be available in a few weeks for everyone to try.

MBS FileMaker Plugin IDs

Saturday 15 April 2017 at 11:07 pm
With MBS FileMaker Plugin 4.5 we reorganized the IDs in our plugin. Now you can see from the ID where it came from. So ID 14012 is an email. Except if you used more than a 1000 regular expressions and also reached that ID there. But in general we don't expect a lot of people use the plugin so much until they restart FileMaker. And even if you have several objects with same ID, the functions will know what they look for and it just works.

So here an updated list for plugin version 7.2:

Menu Items11000text
Regular Expressions13000text
CURL sessions16000text
Midi Streams17000text
GraphicsMagick Image18000text
XL Books19000text
DynaPDF Context20000text
DynaPDF Table21000text
SQL Command22000text
SQL Connection23000text
CoreLocation Geocoder24000text
CoreGraphics Image Source25000text
Addressbook Item26000text
Calendar Item27000text
PDFKit Document30000text
Drag & Drop31000number
not used33000text
SQL in FileMaker37000text
ProcessActivity39000 text
WMI Query41000text
Social Request43000text
Email Parser44000text
EC Key45000text
DNS Lookup49000text
not used52000text
Drag View65000text
iOS Notifications70000text

As you see most IDs are nowadays returned as text and not as numbers. If you just keep them in variables, things should go right. And for storing in fields, simply use text fields. Storing them in number fields may also work as long as you later read the numbers without dot and decimals. "12345" will work, but "12345.00000" may not.

Some function even allow you to define your own IDs, e.g. Menu.DefineQuickMenu, SQL.NewCommand and SQL.NewConnection.

OmegaBundle 2017 available

Thursday 13 April 2017 at 10:47 pm
Today started the 2017 OmegaBundle including MBS Plugins:

As usual, the bundle is a collection of various Xojo related tools. It targets new users which do not yet have all those items and like to get them all for a convenient package price. If you have a few already, it can be cheaper to just upgrade them. Please do not hesitate to contact us.

Older blog entries:

2017-04-10 My iPhone ring tone for you: Silence
2017-04-08 MBS Vendor Session at FileMaker DevCon
2017-04-05 MBS FileMaker Plugin, version 7.2pr2
2017-04-05 MBS Xojo Plugins, version 17.2pr2
2017-04-05 Copy entries from PopupMenus
2017-04-04 FileMaker Abend bei der Denkform
2017-04-03 DevCon 2017 Conference Scholarship
2017-04-03 FileMaker Conference .fmp[x]Berlin 2017
2017-04-03 MBS Xojo Plugins, version 17.2pr1
2017-04-03 MBS FileMaker Plugin, version 7.2pr1
2017-04-02 Windows User Notifications
2017-04-02 JPEGs to Movie
2017-04-01 Company Birthday: 17 Years
2017-03-30 Special guests at the MBS Xojo Conference in Berlin
2017-03-30 Xojo and FileMaker meetings in Arizona
2017-03-29 MBS Plugin Schulung in Hamburg, Salzburg und Hofheim
2017-03-29 MBS Releases the MBS Xojo UDP Socket Kit in version 1.0
2017-03-29 FileMaker Spanish Devcon 2017
2017-03-28 Xojo 2017 Release 1 Now Available
2017-03-28 German FileMaker Conference in Salzburg, Austria


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