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


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 4.0.11.27.
  • 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.

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.

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.

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.

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.

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:

Menu10000text
Menu Items11000text
QuickList12000text
Regular Expressions13000text
SendEmail14000text
Window15000text
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
SerialPort28000text
Socket29000text
PDFKit Document30000text
Drag & Drop31000number
TAPI32000text
not used33000text
Dictionary34000text
HotKey35000text
MarkDown36000text
SQL in FileMaker37000text
Schedule38000text
ProcessActivity39000 text
AVAsset40000text
WMI Query41000text
QTKitMovie42000text
Social Request43000text
Email Parser44000text
EC Key45000text
WordFile46000text
JavaScript47000text
FSEvents48000text
DNS Lookup49000text
LDAP50000text
JSON51000text
not used52000text
AVCapture53000text
AVExport54000text
QTExport55000text
Events56000text
SSH57000text
SmartCard58000text
AppleScript59000text
Java60000text
TouchBar61000text
X50962000text
PKey63000text
PKCS1264000text
Drag View65000text
AVPlayer66000text
MAPI67000text
DirectoryChange68000text
WindowsNotification69000text
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.

My iPhone ring tone for you: Silence

Monday 10 April 2017 at 10:58 pm
In iOS you can assign a ring tone to individual contacts. As I missed to find a way to set ring tone to silence for my special contact for ad calls, I made a new ring tone with only silence. Maybe you like it?

Download: silence.m4r

MBS Vendor Session at FileMaker DevCon

Saturday 08 April 2017 at 09:31 am
The session list is available for the FileMaker DevCon, July 24-27 in Phoenix Arizona.



My MBS FileMaker Plugin Introduction session is scheduled for Wednesday, 26th July 2017 at 2:15pm in room Grand Canyon 4. If you come to the conference, please join me and learn what's new this year in MBS Plugin. Or visit my booth.

My Tip: go to the sessions which are not recorded.

MBS FileMaker Plugin, version 7.2pr2

Wednesday 05 April 2017 at 9:10 pm
New in this prerelease of the 7.2 MBS FileMaker Plugin:
  • Added context menu for popup menus to copy title and list entries.
  • Updated OpenSSL to 1.1.0e and 1.0.2k
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Copy entries from PopupMenus

Wednesday 05 April 2017 at 6:49 pm
Sometimes you see a popup menu control in FileMaker and you like to copy the entries.
To help you our new 7.2pr2 plugin does offer a context menu on all popup controls:



You can copy the visible text or the whole list of options as text.

FileMaker Abend bei der Denkform

Tuesday 04 April 2017 at 7:37 pm
Am 18. Mai 2017 treffen sich interessierte FileMaker Entwickler bei der Denkform in Hofheim (Taunus).
Wir schauen uns neues in der FileMaker Welt an. Unter anderem FileMaker Cloud und das aktuelle MBS Plugin.
Michael Valentin von FileMaker Deutschland kommt vorbei und präsentiert und steht dann für Fragen bereit.

Ich kann dann gerne noch ein paar Neuerungen im MBS Plugin zeigen für die Version 7.2.

Anmeldung auf der Eventseite. Zeitlich vermutlich 18 bis 21 Uhr. Eventuell mit optionalem Abendessen.

DevCon 2017 Conference Scholarship

Monday 03 April 2017 at 5:51 pm
A great move by FileMaker to add young people to the conference:

Women of FileMaker is excited to offer three scholarships to the 2017 FileMaker Developer Conference (DevCon) held July 25-26 in Phoenix, Arizona. We believe that DevCon is a wonderful learning and connecting experience, and we are excited to promote the cause of women in technology by helping them to gain access to FileMaker learning and networking potential. This year, we are offering scholarships for three pre-paid registrations to DevCon, as well as assigning a mentor to each scholarship winner to help them navigate the conference and get the most out of the experience. Deadline for applications is April 7.

Requirements & Qualifications

  • This must be your first FileMaker DevCon
  • The scholarship does not include hotel or airfare
  • The conference pass is non-transferable
  • Applications close on April 7, 2017
  • Winners will be notified on or before April 28, 2017

see womenoffilemaker.com/scholarship/ for more details and registration.

I just wonder if they saw that at my Xojo conferences where I offer three scholarships myself.

FileMaker Conference .fmp[x]Berlin 2017

Monday 03 April 2017 at 1:44 pm
Just two months till the FileMaker Conference .fmp[x]Berlin 2017. See you there!

This conference is organized by Egbert Friedrich and takes place from 1st to 3rd June 2017 in Berlin, Germany.

As the conference is in english, this is your chance to meet people from around the world at a conference in Europe. And for a lot of people it's easier to get to Berlin than to cross the atlantic and deal with US immigration officers.

Who
dotfmp is an effort of various leading European FileMaker Developers. It is meant to bring all kinds of higher level developers together to share knowledge, educate and challenge each other.
When
dotfmp starts at the 31 May 2107 in the later afternoon with a relaxed "Beer and Sausages" in one of the most famous Berlin Beergarden.The session days itself last from 1 until 3 June with various socialising events in the evenings. Additionally we offer suport on 4 June to see more from Berlin and its surroundings.
What
dotfmp is a 3 Day-Unconference, Meetup, Hangout or Barcamp. It is an informal and self-organized effort to meet on a personal base.
Where
dotfmp takes place in one of the most famous spots in Berlin. The GLS Campus is located in a vibrant area with a very short walking distance to all the famous restaurants.
Why
We feel there are far too few possibilities to talk to, learn from, and hangout with fellow developers in a relaxed and informal environment. And we'd like to share work and get feedback from people chewing on similar challenges.


If you like to join the conference and present something, please register soon.

MBS FileMaker Plugin, version 7.2pr1

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

Windows User Notifications

Sunday 02 April 2017 at 9:21 pm
Coming soon in MBS Plugins for Xojo and FileMaker:



Will be part of next prerelease in a few days.
My coding challenge for the spare time on the weekend. The most difficult thing is to get this build in a plugin that can load on Windows XP, even those notifications are only available in Windows 8.1 and newer.

Company Birthday: 17 Years

Saturday 01 April 2017 at 09:59 am
1st April 2000 I found my company. Well, I registered as a business by getting my Gewerbeanmeldung (business registration) here in Germany.

That was 2 months before I finished school (Gymnasium). While alternative civilian service (Zivildienst) and my time at the university, the company run well and I didn't have to depend on my parents or student loans. Actually the company got me so busy over the years, that I spend less time at university and since 2007 this is my full time job.

I had a few clients in that time interested in development in REALbasic, a very young development environment which started two years earlier. At that time I had a website with a few freeware utilities, so people could see that I can do development. Two years later the demand for plugins got so high, that end of 2001 I started publishing my own plugins.

Thanks everyone for supporting me over the years!

PS: If you need a license (update) this weekend, refer to this blog post and I put a 17% discount on the invoice.

Older blog entries:

2017-03-30 Xojo and FileMaker meetings in Arizona
2017-03-29 MBS Plugin Schulung in Hamburg, Salzburg und Hofheim
2017-03-29 FileMaker Spanish Devcon 2017
2017-03-28 German FileMaker Conference in Salzburg, Austria
2017-03-25 Amazon S3 and other services in Xojo and FileMaker
2017-03-19 Windows Notifications
2017-03-19 CURL conference
2017-03-14 MBS FileMaker Plugin 7.1 - Über 4400 Funktionen in einem Plugin
2017-03-14 MBS FileMaker Plugin 7.1 - More than 4400 Functions In One Plugin
2017-03-14 Stammtisch in Nürnberg
2017-03-09 MBS FileMaker Plugin, version 7.1pr5
2017-03-08 Reminder for Xojo and FileMaker events in Netherlands
2017-03-07 FileMaker Cloud with MBS Plugin
2017-03-07 Creating PDF/A in FileMaker with ZUGFeRD standard
2017-03-06 MBS FileMaker Plugin, version 7.1pr4
2017-03-04 JPEG Quality Estimate
2017-02-28 Image Zoom in Container
2017-02-27 FileMaker Magazin 1/2017
2017-02-26 FileMaker DevCon 2017 with MBS booth
2017-02-24 A Calendar running in WebViewer in FileMaker

Archives

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