Registration just started for the FileMaker Developer Conference 2018.
The training on Monday 6th costs $399. Keynote will start later that evening, probably at 6pm and is followed with the welcome reception. Prices for the conference are $1299 Early Early Bird - through March 15, $1399 Early Bird - through May 31 and $1499 USD Standard.
This is a fantastic conference hotel with 1500 rooms, 10 restaurants, several pools indoor and outdoor. And as may know this was my guess for the conference hotel.
Rooms can be reserved on the hotel website ($189 +tax per night). As you can cancel rooms and they may run out of them, you better reserve now a room and block the week in your calendar! See you there at the MBS booth.
For the next plugin version, we add a new search field for database design dialog to search fields and tables for name:
When you stop typing or press return, we search the table for the text. If no text is found, we beep. Otherwise, we jump to the next line which matches. This way you can quickly find all names, all fields with birth or whatever you look for. The visible text is only searched, so if there is text in a formula after a few paragraphs, we may not see it.
Coming soon for MBS FileMaker Plugin 8.1pr5 or if like to try on the weekend, drop us an email.
In Zusammenarbeit mit der DenkForm GmbH bieten wir eine Schulung zum MBS Plugin an. Am 1. März 2018 (auch 3. Mai 2018, 6. Dezember 2018, 7. März 2019) können Sie in Hofheim am Taunus an einer eintägigen Schulung teilnehmen. Lernen Sie die über 5000 Funktionen einmal näher kennen und wie Sie sie effektiv einsetzen. Sammeln Sie Ideen und verbessern Sie ihre FileMaker Lösungen durch den Einsatz unseres Plugins.
Das Monkeybread Software Plugin für FileMaker stellt eine vielseitige Erweiterung der eigenen Datenbank dar. Der Kurs bietet nicht nur einen tiefgreifenden Überblick in die Benutzung und Entwicklung, sondern bietet auch die Chance das Plugin günstiger zu erstehen.
Einführung in das MBS Plugin
Überblick über die Funktionsbereiche
Neues im MBS Plugin dieses Jahr und in der dann aktuellen Version 7.5
Rundgang durch ausgewählte Beispiele
Gemeinsames Implementieren von Plugin Funktionen in eine Datenbank.
Upload/Download mit CURL auf einen HTTP/FTP Server
Ausfüllen eines Formulares auf einer Webseite
Bilder bearbeiten
PDF Verarbeitung
Druckerfunktionen
Einbinden von Webservices with JSON/XML für REST/SOAP.
Fragen und Antworten
Die Teilnahme kostet 99 Euro inkl. MWSt. und Verpflegung. Trainer ist der Plugin Entwickler und Monkeybread Software Geschäftsführer Christian Schmitz persönlich.
Im Anschluss besteht die Möglichkeit zum FileMaker Rhein-Main Stammtisch zu kommen. Bei einem leckeren Abendessen im Restaurant Bella Bari in der Nähe der Denkform können Sie sich mit anderen FileMaker Entwicklern aus der Gegend austauschen.
PS: Die Mindestteilnehmerzahl wurde erreicht und die Schulung am 1. März findet statt.
Die Anmeldung zur FileMaker Konferenz 2018 ist eröffnet.
Vom 17. bis 20. Oktober diesen Jahres findet die neunte deutschsprachige FileMaker Konferenz in Malbun, Liechtenstein statt. FileMaker Anwender und Entwickler können ihre Teilnahme ab sofort buchen. Anmeldungen bis zum 23. Juni 2018 erhalten einen Frühbucher-Rabatt auf die Konferenzpauschale.
Die Veranstalter vom Verein FM Konferenz erwarten auch 2018 rund 180 Entwickler, Anwender, IT-Fachleute und Entscheidungsträger aus Wirtschaft, Bildung und Verwaltung. Rund um über 25 Fachvorträge und Workshops wird es viel Zeit zum Vernetzen in den gemeinsamen Pausen und beim Abendprogramm geben.
Eventuell gibt es auch 2018 wieder eine MBS Plugin Schulung bzw. Workshop. Hat da jemand Interesse?
Changed XML.GetPathValue to return CDATA section as text if possible.
Improved Sendmail functions to not encode subject, email names or attachment names, if it contains no special characters in more cases by reducing the characters which trigger encoding.
Added option to preferences to block ESC key on Touch Bar and use Option-ESC instead.
Changed preferences dialog to shrink on smaller screen resolution and allows scrolling through options.
With next MBS Plugin, you can put a WebKit 1.x web view on the Popover and load whatever you like.
The WebView.CreateOnPopover function will place the web view there until you close it later with WebView.Close.
Do not hesitate to contact us if you like to try the new plugin on the weekend.
Do you have a MacBook Pro with Touch Bar?
If yes, how often may you have pressed ESC key in FileMaker unintentionally?
Well, to keep you sane and not loose valuable custom functions by pressing ESC accidentally, we got a new option in MBS Plugin preferences dialog for you:
So optional the MBS FileMaker Plugin 8.1 and newer will be able to block ESC key presses without modifier keys. And if you press option key, we remove the flag for the option key from the event and pass it though to FileMaker. So ESC alone is blocked, but Option-ESC goes through as if you pressed ESC.
The feature only takes effect on MacBook Pros with TouchBar, only inside FileMaker application, only if enabled, and only if you use the internal keyboard.
If you like to try this today, please get in touch.
FileMaker, Inc. has created a dedicated web page highlighting upcoming in-person and virtual events submitted by FileMaker partners and enthusiasts around the world. Upcoming workshops, trainings, user group meetups, trade shows, and webinars can all be found in this new area in the Learn section of FileMaker’s website.
See upcoming events in your area and submit your own event by going to filemaker.com/events/.
Additionally, we will send out event notification emails periodically to help drive attendance. Manage your FileMaker email subscription here.
It's a great move to provide a gathering point for events. I do hope all the conferences and local meetings end up being there, so people can easily find them.
Currently, the events page lists over 190 events including 108 trainings, 44 workshops, 5 conferences.
Today we got a problem with SQL. It’s not the usual SQL injection worries, but more the convenience of building SQL statements containing values, which causes problem.
We see a lot of SQL queries to lookup values, but people love to include the
MBS("FM.ExecuteFileSQL"; Get(FileName); "SELECT Name FROM Contracts WHERE ID=" & $ID)
Now if ID is a text, but $ID contains the number 1234, this causes an error:
[MBS] ERROR: FQL0018/(1:32): An expression contains incompatible data types.
You would need to use quotes at least:
MBS("FM.ExecuteFileSQL"; Get(FileName); "SELECT Name FROM Contracts WHERE ID= '" & $ID & "'")
Although you don’t see the double quotes having single quotes easily here. This may work, until someone includes a single quote in that variable.
When you use parameters in the query, you can avoid this:
MBS("FM.ExecuteFileSQL"; Get(FileName); "SELECT Name FROM Contracts WHERE ID = ?"; 9; 13; $ID)
You can pass parameter as text or number even if it does not the match the field type. FileMaker will converted the data type automatically to match.
Next, lets assume you have a variable containing a number and you make a query
Set Variable [ $x ; Value: 123.45 ]
Show Custom Dialog [ MBS( "FM.ExecuteFileSQL"; Get(FillName); "SELECT Name, Price FROM Items WHERE Price= " & $x; 9; 13 ) ]
If $x is a number, it will be converted by FileMake to a text. Or it is a text already with some user entered number. Now if the field is empty, you get a syntax error, because your SQL ends in a = character. But you may have noted that the number is passed directly here without parameter. So a German user typing "123,45" with comma as decimal separator will cause a SQL error. SQL always uses dot as decimal separator, so the query fails in Germany with comma, but works in USA.
Show Custom Dialog [ MBS( "FM.ExecuteFileSQL"; Get(FillName); "SELECT Name, Price FROM Items WHERE Price = ?"; 9; 13; $x ) ]
Using parameters helps you to avoid problems here and this works for any locale. If needed, you can use GetAsNumber() to explicit convert text to number and use localized decimal separators to get a numeric value.
For years people asked for our DragDrop functions to work on Windows too.
Due to a few technical difficulties, the feature was in development for a year and put on hold several times. But last week we found the missing piece for the puzzle to get it working.
So for next prerelease, the DragDrop functions will work on Windows, too. A few little details, will be different. First we accept currently text and file drops. The image view used for drop destination needs a picture as on Widows we can't have it transparent. But that is normally not a problem as we just add a picture there with a note to user for the drop area.
Drop data can be text, file paths or file data. So some files like the files from explorer come usually by file paths. But attachments from Outlook (as seen in video), come as file descriptor with on demand data. So there is actual file, but the data comes directly from the application initiating the drag operation.
Added support for SQL Anywhere API v1 in addition to v2.
On shutdown, the plugin now closes progress dialog, frees notifications and drag & drop areas to avoid later callbacks to unloaded plugin which would crash. Usually only happend when you had such a thing in use and updated plugin.
New in this prerelease of version 8.1 of the MBS FileMaker Plugin:
In Zusammenarbeit mit der DenkForm GmbH bieten wir eine Schulung zum MBS Plugin an. Am 1. März 2018 (auch 3. Mai 2018, 6. Dezember 2018, 7. März 2019) können Sie in Hofheim am Taunus an einer eintägigen Schulung teilnehmen. Lernen Sie die über 5000 Funktionen einmal näher kennen und wie Sie sie effektiv einsetzen. Sammeln Sie Ideen und verbessern Sie ihre FileMaker Lösungen durch den Einsatz unseres Plugins.
Die 
Am 8. Februar treffen sich interessierte FileMaker Entwickler in Neu-Ulm zum Austausch von Neuigkeiten, Erfahrungen und Tipps & Tricks.