Xojo Conferences
XDCMay2019MiamiUSA
MBSOct2019CologneDE
Our Blog, Filemaker only, Xojo only, Archive (older)

Follow us on Twitter, Xing, LinkedIn or Facebook.

FileMaker Server vs. MacOS Server


If you see an error message in FileMaker Server installer like this, you may need to remove or disable the built-in web server software to be able to install FileMaker Server.



So in order to disable it, you can dig into how to disable services in MacOS. But we found a simpler way. Just move the com.apple.serverd.plist out of the /Library/LaunchDaemons folder and restart the Mac.

We'd prefer to change the ports from either MacOS Server's web server or the FileMaker Server's web server, but both is not supported. As you may guess a lot of code simply expects https at port 443, so they don't even bother to offer you a way to enter a port number.

MBS FileMaker Plugin, version 9.0pr8


New in this prerelease of version 9.0 of the MBS FileMaker Plugin:
  • Added MapView functions to put map control on the layout for Mac and iOS.
  • Added MapView.Snapshot function to render map images.
  • Manually applied CURL fix: vauth/oauth2: Fix OAUTHBEARER token generation #3377 (for Mac)
  • Fixed bug with inline email text decoding and an extra space character sometimes.
  • Updated to DynaPDF to version 4.0.25.69.
  • Changed Printer.Print to prefer selecting exact match over beginning of text.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

MBS Xojo Plugins, version 19.0pr8


New in this prerelease of the 19.0 plugins:
  • Changed ICDeviceBrowserMBS destructor to call stop for you automatically.
  • Added nil check of saveRequest parameter for CNContactStoreMBS.executeSaveRequest function.
  • Manually applied CURL fix: vauth/oauth2: Fix OAUTHBEARER token generation #3377 (for Mac)
  • Fixed bug with inline email text decoding and an extra space character sometimes.
  • Updated to DynaPDF to version 4.0.25.69.
  • Fixed bug in FileListMBS, introduced in pr6.
  • Removed clock_gettime symbol for GraphicsMagick as that is not available before MacOS 10.11, bug introduced in pr4.
  • Fixed bug in NewCFObjectMBSFromXML introduced in earlier pr.
  • Added more clases for MapKit, so the framework is now completely covered in the plugin.
Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

CURL change for email download via IMAP


Last year there was a little change in the CURL library for handling email downloads via IMAP. We used to download the list of email, get the index in the email box and download the email by passing the index with UID parameter in the URL. The first email in the mailbox is 1. If you delete email with ID 1, than the second email moves down to become the new first email.

Now since CURL version 7.62.0 from October, the default fetch is using the IMAP UID command. That means the IMAP server gives every email in the mailbox an unique ID which counts up for every new email coming in. The UID does not change if emails are moved or deleted, so we can address emails on the server much better. Now the new parameter is named UID and the old UID parameter is renamed MAILINDEX.

As you may guess, the old and new UID are not the name values, so existing applications with newer plugin fail to load emails. You can fix your script by changing UID to MAILINDEX. MBS FileMaker Plugin in version 9.0 for FileMaker and MBS Xojo CURL Plugin version 19.0 for Xojo have a mitigation to switch to MAILINDEX if the query via UID failed.

For newer projects we recommend to do the lookup of the emails in the mailbox with UID FETCH and get the emails with unique IDs. Next we recommend to use BODY.PEEK instead of just BODY to avoid emails being marked as read automatically. When switching to BODY.PEEK you can remove workarounds which removed the seen flag. And you can include options like INTERNALDATE for the date of the email and/or RFC822.SIZE for the email size:

UID FETCH 1:* (FLAGS INTERNALDATE RFC822.SIZE BODY.PEEK[HEADER.FIELDS (Message-Id DATE FROM SUBJECT TO SENDER REPLY-TO CC BCC)])

As you see we include a few headers fields in this sample query.
The result looks like this:

* 1 FETCH (UID 103 FLAGS (\Seen $junk) INTERNALDATE "06-Apr-2018 19:42:11 +0200" RFC822.SIZE 2091 BODY[HEADER.FIELDS (MESSAGE-ID DATE FROM SUBJECT TO SENDER REPLY-TO CC BCC)] {214}
From: Christian Schmitz
Subject: Hello World
Message-Id: <6F3B718F-8427-4EFB-B291-106A8ABFC1AA@monkeybreadsoftware.de>
Date: Fri, 6 Apr 2018 19:42:05 +0200
To: test@macsw.de

)

Now you can parse that easily. But for our FileMaker plugin we made a new function CURL.GetResultAsEMailList to parse the list and return as JSON. The JSON looks like this:

[{
    "Index":   1,
    "UID":   103,
    "Size":   2091,
    "InternalDate":   "06-Apr-2018 19:42:11 +0200",
    "URL":   "imap://imap.macsw.de/INBOX;UID=103",
    "Flags":   ["Seen"],
    "Subject":   "Hello World",
    "Message-Id":   "<6F3B718F-8427-4EFB-B291-106A8ABFC1AA@monkeybreadsoftware.de>",
    "Addresses":   [{
        "Type":   "from",
        "Email":   "testing@monkeybreadsoftware.de",
        "Name":   "Christian Schmitz"
      }, {
        "Type":   "to",
        "Email":   "test@macsw.de",
        "Name":   ""
      }],
    "Date":   "06.04.2018 09:42:05"
  }]

This JSON contains all the parsed values. We convert the date to the timestamp for FileMaker into local time zone. The subject lines and names are decoded if needed. For each email we include the URL to the email for easier download. Please try the new functions for UID fetch and let us know how you like them.

MapKit Framework for Xojo


After weeks of work, the new MapKit plugin for MacOS is done. We have all the features included and got a few example projects for you. One example shows the MapKit control, one to search for local items and one to get directions.

The classes include support for
  • Showing map with standard, hybrid or satellite.
  • Adding annotations like pins or lines
  • Adding overlays like colored areas.
  • Using customized renderes for overlays
  • Get directions for routes
  • Calculate expected time of arrival.
  • Format distances as localized text
  • Do local search query for finding items
  • Show suggestions for auto complete for local search
  • Control camera for fly over
  • Render snapshots of maps
  • Show user location
(more)

FileMaker Conference dotfmp.berlin 2019


Did you sign up for FileMaker Conference dotfmp.berlin 2019?

This conference is organized by Egbert Friedrich and takes place from 6th to 8th June 2019 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 5th June 2019 in the later afternoon with a relaxed "Beer and Sausages" in one of the most famous Berlin Beergarden. The session days itself last from 6th until 8th June with various socializing events in the evenings. Additionally we offer support on 10th 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.

xDev 17.1 Issue


The January/February (17.1) issue of xDev Magazine is now available. Here's a quick preview of what's inside:

Xojo UK Meetup by Paula Roberts (and Paul Budd)
Recently a small group of Xojo developers decided to get together for an informal meetup to show off their apps and discuss problems and solutions.

iOS Success by Jérémie Leroy (and Marc Zeedar)
If you're having trouble getting your iOS app noticed, Jérémie has some great tips for you.

Beyond JSON by Tim Dietrich
Using JSON to retrieve data from a web app is great, but what if you want something else, such as a graphic? Tim creates a web app that serves barcodes.

Vague Errors by Marc Zeedar
Marc discusses the problems of unhelpful error messages from both the developer and user perspectives.

Building a data-list Controller by JC Cruz
Jose shows how to build a data-list controller.

PLUS: Threads, Hour of Code, Best of the Web, Xojo Dojo, Xojo 2018r4, and more!

FileMaker Stammtische im Januar


Im Januar gibt es mindestens noch die folgenden FileMaker Stammtische: Herzliche Einladung an alle FileMaker Entwickler bei einem Stammtisch vorbeizuschauen!

Wir versuchen in Karlsruhe und Bonn vorbei zu schauen.

European Xojo Conference Upgrades


The next European Xojo conference organized by Monkeybread Software is going to be a significant upgrade to previous conferences from us. An excellent hotel, a ballroom for us, two tracks and space for even more attendees.



We have booked a full ball room in Cologne which can be split into two rooms. The ball room can fit over 150 people so we have plenty of space, even if we split it. We ordered of course two projectors and microphones as well as speakers. The advantage of taking the whole ball room is that we can be there on our own. No other group will fight with us for the coffee breaks. In Munich were one of three groups and the break area was too small. So we had to schedule to take break when others couldn’t have a break. This is different for Cologne, where we will have our own space in front of the ballroom. In the foyer we have all day coffee, a tea station, snacks for the breaks as well as a refrigerator with cold soft drinks.

We hope to find speakers to fill the schedule and have two tracks in parallel. The big sessions like the keynotes will be in the full ballroom. But for smaller sessions we split and than we could for example get a database and a mobile track.

For the dinner on Thursday we got an excellent party location. The Höhnerstall is a two story event location with a fantastic view to the city center. We rented the place for our group, so we can enjoy ourselves. Buffet and an open bar will as well as the brewery tour will make a nice conference night. We expect a couple of you to bring partners and maybe even kids there, so please let us know how many you have for that night. (more)

MBS FileMaker Plugin, version 9.0pr7


New in this prerelease of version 9.0 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 19.0pr7


New in this prerelease of the 19.0 plugins: Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

Schedule Notifications with MBS Plugin in iOS


First you need to add MBS FileMaker Plugin for iOS to your FileMaker iOS SDK app project as you can watch in following video on our website: FileMaker iOS SDK and MBS Plugin

Next you need to copy MBSInit.framework to the Frameworks folder. In Xcode in the project settings, please add MBSInit.framework there to the list of libraries to link to. See the following screenshot with our two MBS files in the files list on the left and the MBSInit framework in the link list in the middle:



This makes sure the MBSInit framework is loaded at start of the application and initializes the notification system. Once your app runs, you'll see the following dialog asking for permissions:



If you click allow, UNNotification.AuthorizationGranted function will return 1 and UNNotification.AuthorizationError will be empty. If you like, query device token with UNNotification.RemoteNotificationsDeviceToken and than pass this token to the server for push notifications.

Please also check system settings for your application for whether notifications are allowed. Especially if you want more than just text, you may need to allow sound or badges:



Once you got the notification system initialized, you can show a local notification with a script. The following example script creates a new notification, sets title and body texts, a time interval and schedules the notification.

# Create a new notification
Set Variable [ $notification ; Value: MBS("UNNotification.New") ]
# Set Title and Body
Set Variable [ $r ; Value: MBS("UNNotification.SetTitle"; $notification; "Hello") ]
Set Variable [ $r ; Value: MBS("UNNotification.SetBody"; $notification; "Greetings from FileMaker") ]
# Set a time interval trigger
Set Variable [ $r ; Value: MBS("UNNotification.SetTimeIntervalTrigger"; $notification; 60; 0) ]
# and schedule
Set Variable [ $r ; Value: MBS("UNNotification.Schedule"; $notification; "test") ]

The notification shows while application is in background:



If you have questions, please do not hesitate to contact us.

New ReplaceLineEndingsMBS function


For a client, we add a new ReplaceLineEndingsMBS function to the MBS Xojo Plugin.
It addresses two problems the built-in Xojo function has:
  • Performance: We can do the same job approximately 30% faster as far as we measured.
  • Yielding: If you process 100 MB blocks, a yield every few MB may help to keep the application responsive, especially if you use the function on a thread.
Our new function handles all combinations of CR, LF, CRLF and LFCR correctly and replaces them with the given replacement text. The operation is done in binary mode for 8 bit encodings or no text encoding. For UTF16/32, we first convert to UTF-8.

The new function will be available soon in the next prerelease. See also other functions like ReplaceNonPrintableCharactersMBS.

FileMaker Magazin - MBS Artikel


Wir haben die Artikel zum MBS Plugin aus dem FileMaker Magazin gesammelt hier online gestellt: FileMaker Magazin Artikel.

Wir empfehlen allen FileMaker Anwender ein Abo vom Magazin und den Kauf der alten Ausgaben. Das FileMaker Magazin ist eine exzellente Quelle von Informationen, Anleitungen und Profitips.


MBS FileMaker Plugin, version 9.0pr6


New in this prerelease of version 9.0 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 19.0pr6


New in this prerelease of the 19.0 plugins:
  • Added SortByFileName method to FileListMBS class.
  • Rewrote MapKit classes to use only Apple Map and get more features from it.
  • Fixed crash in SKProductsRequestMBS destructor.
  • Added XLCopyOptionsMBS class to specify copy options for MBS Xojo XL Plugin.
  • Removed helpbook functions: RegisterHelpBookMBS, LookupHelpBookAnchorMBS, GotoHelpBookPageMBS, GotoMainHelpBookTOCMBS and SearchHelpBookMBS.
  • Removed folderitem.GetFileAttributeMBS function.
  • Removed descriptorWithFSRef and FSRefValue from NSAppleEventDescriptorMBS in favor of FileURL methods.
  • Removed Application.IsBundleMBS function.
  • Upgraded UTTypeMBS.UTI to newer API.
  • Rewrote FileListMBS for Mac to get better speed on APFS.
  • Added CFDateMBS convert and constructor methods.
  • Changed conversion from CFDate to Xojo date and back to use current time zone instead of always UTC.
  • Changed 80 properties in GMImageMBS class to be debugger visible.
  • Added JasperLibVersion, TIFFLibVersion and ZLibVersion to GMImageMBS class.
  • Added autoOrient, extent, formatExpression, Quiet, repage and resize methods to GMImageMBS class.
  • Added ReadEXIF for PNGReaderMBS class.
  • Added SetEXIF for PNGWriterMBS class.
  • Added fillArea and limitPixels flags for GMGeometryMBS class.
  • Added addBoundaryTimeObserverForTime and addLoopTimeObserver methods to AVPlayerMBS class.
  • Added AVVideoCodecTypeAppleProRes422, AVVideoCodecTypeAppleProRes4444, AVVideoCodecTypeH264, AVVideoCodecTypeHEVC, and AVVideoCodecTypeJPEG functions to AVFoundationMBS class.
  • Updated GraphicsMagick library to version 1.3.31.
  • Updated iconv to version 1.15.
  • Updated regex library to version 8.42.
  • Updated png library to version 1.6.36.
  • Updated freetype to version 2.9.1.
  • Updated SQLAPI to version 4.2.4.
  • Fixed a bug in Oracle initialization for Linux for SQL Plugin.
  • Changed Linux compile to include function names for stack traces.
Download: monkeybreadsoftware.com/xojo/download/plugin/Prerelease/.
Or ask us to be added to our shared Dropbox folder.

FileMaker calculations with MBS Plugin help links


We got a new options in preferences for the MBS Plugin to make all function names clickable links within calculations:

Coming soon in next prerelease.

MapKit upgrade coming to Xojo


The older MapKit replacement framework we used to use is no longer supported and Google Maps now requires a developer key. But before changing the old framework, we decided to go with Apple Maps only.

So for next plugin version, we'll add more classes for MapKit.

Merry Christmas


Frohe Weihnachten und ein gutes neues Jahr!

Merry Christmas & Happy New Year

Joyeux Noël et Bonne Année

Buon Natale e Felice Anno Nuovo


Franziska, Sebastian, Michael, Monika & Christian Schmitz

Ten month til European MBS Xojo Conference 2019 in Cologne


Monkeybread Software is pleased to announce the European MBS Xojo Conference in metropolitan Cologne, Germany. We meet in the lovely Dorint Hotel in the center of Cologne. The hotel is in the city center and in walking distance to the main station. 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.

As date and location are set, we are now looking for interested speakers to join our conference. If you have an interesting topic, feel free to propose a session. We look for sessions to present applications made in Xojo, best practice, looking deeper on a Xojo features or presenting a product for Xojo developers.

The schedule:

Oct 23rd: Xojo Training in English
Oct 24th: Conference, first day with dinner event
Oct 25th: Conference, second day
Oct 26th: Xojo Training in German

Registration is open. The early bird offer available till 24th April is just 499 Euro plus VAT. For the first 20 people we offer tickets for just 399 Euro plus VAT. Attending the conference costs regularly 699 Euro plus VAT, including food and beverage in the Dorint Hotel as well as an accompanying social program.

Sessions are to be held in English. Our conference is conceived as a networking event for the Xojo community. The conference is an ideal opportunity for sharing your thoughts and your own development experience with fellow users and developers. If you like to hold a presentation, please contact us as soon as possible. Speaker receive discounted tickets.

More details on the conference website.

Older blog entries:

2018-12-23 MBS FileMaker Plugin, version 8.6pr5
2018-12-23 MBS Xojo Plugins, version 18.6pr5
2018-12-21 SQLite Manager and Doctor updated
2018-12-21 FileMaker Konferenz 2019 in Hamburg
2018-12-21 MBS Booth at FileMaker Developer Conference 2019
2018-12-19 Arbed 1.8.11 updated for Xojo 2018r4
2018-12-18 European MBS Xojo Conference 2019 in Cologne
2018-12-18 MBS FileMaker Plugin, version 8.6pr4
2018-12-18 MBS Xojo Plugins, version 18.6pr4
2018-12-17 Use of TAPI functions in MBS FileMaker Plugin
2018-12-16 MBS Xojo Conference Survey Results
2018-12-15 ROWID in FileMaker SQL Commands
2018-12-13 LiteSync and Xojo
2018-12-13 Ask for permissions to control applications with AppleScript in FileMaker
2018-12-13 Three weeks till year's end
2018-12-12 FileMaker based iOS App to the App Store
2018-12-12 MBS Xojo Plugins, version 18.6pr3
2018-12-12 MBS FileMaker Plugin, version 8.6pr3
2018-12-11 FileMaker Go 17.0.4 now available
2018-12-11 Xojo 2018 Release 4 Now Available

Archives

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
XML: RSS Feed XML: Atom Feed