If you like to plan an event, run a conference, you may need to consider a lot of details.
First you think about what type of conference you’d like to have. It can be small like a meeting for a dinner with a few locals. A bit bigger maybe with a presentation before the dinner. Or you like to run a full conference with one or two days, you may need a lot of presentations over the day with lunch and maybe some dinner. For two days or more, it’s always nice to have a bigger evening event in-between.
(more)
Coming for the 8.4 release we have a new Copy Value command there:
You click on a cell like the database fields table with right mouse button and the menu allows you to copy the value in that cell below the mouse cursor. Of course you can still copy the whole content, the selected rows or just the value in the cell you clicked on.
This podcast features two developers talking about problems and challenges you have as an independent software developers. The latest episode is about search and they use full text search in SQLite.
Thanks to David Smith and Marco Arment for their apps and the podcast.
And thanks to Xojo Inc. for supporting the shows. Xojo is sponsor for episode #141. Coupon code is RADAR for 20% off a Xojo license.
As you may know the FileMaker Server comes with a copy of apache web server software. You can use the apache web server to host and deliver files for download. So if you copy a file to /Library/FileMaker Server/HTTPServer/htdocs/ folder on your server, you can than point to that file with the URL of your server with folder and file name attached.
We can call the following script named "Create URL". It calls a script on the server to export the picture of our current record and return the URL. As server doesn't retain the context, we need to pass the record ID fo the current record as parameter:
Perform Script on Server [ Specified: From list ; “Create URL on Server” ; Parameter: Get(RecordID) ; Wait for completion: On ]
Set Variable [ $URL ; Value: Get(ScriptResult) ]
Set Field [ Anlagen::Name ; $URL ]
The script Create URL on Server looks like this:
# go to record on Server
Set Variable [ $RecordID ; Value: Get(ScriptParameter) ]
Go to Layout [ “Images” (Anlagen) ; Animation: None ]
If [ Get(LastError) ≠ 0 ]
Exit Script [ Text Result: "" // failed ]
End If
Go to Record/Request/Page [ With dialog: Off ; $RecordID ]
If [ Get(LastError) ≠ 0 ]
Exit Script [ Text Result: "" // failed ]
End If
#
# Global settings
Set Variable [ $path ; Value: "/Library/FileMaker Server/HTTPServer/htdocs/" ]
Set Variable [ $URL ; Value: "http://127.0.0.1/" ]
Set Variable [ $folderName ; Value: Get(UUID) ]
#
# Item to export
Set Variable [ $Container ; Value: Anlagen::Bild ]
Set Variable [ $FileName ; Value: MBS( "Path.LastPathComponent"; GetAsText($Container)) ]
As you see, we create a new folder with an UUID as name, so every user has an unique folder. We write the file there and build the URL with the encoded file name. Now the client script has the URL and you can give it the user, e.g. in an email to download later.
It may be good to put all those downloads in an extra folder so the folder is not filled too much. Also we could store the folder names in a table with timestamp, so we can remove them after e.g. 30 days.
If you recently submitted a FileMaker iOS app to the App Store, you may have got the following message from Apple:
Invalid Document Configuration - Document Based Apps should support either the Document Browser (UISupportsDocumentBrowser = YES) or implement Open In Place (LSSupportsOpeningDocumentsInPlace = YES/NO)
Once again Apple improves the automatic checks on applications to find bugs in the configuration. The FileMaker app declares in the info.plist file in the bundle, that it works as editor for a few file types. For an iOS app, this usually includes the FileMaker Document type with the extension fmp12 (unless you change that).
An application declaring file types must specify whether it can open them in place or needs copies to work on. This is new since the introduction of the iCloud file synchronization. To fix, you'd need to add the missing LSSupportsOpeningDocumentsInPlace key to the info.plist file.
In Xcode, please locate to the project settings and there to the target settings. In the Info tab you find the info.plist settings for the applications. In the section for custom iOS target properties, you add a new entry with the following values:
Name: Supports opening documents in place
Type: Boolean
Value: NO
Please try and see if your app still runs. As we expect that FileMaker may not do the extra coordination for secure scoped bookmarks, we use the value NO above, so the OS may do copy files to temp folder for FileMaker to access them.
Missions :
Vous connaissez les langages de programmation XOJO ou VBA,
vous maîtrisez le langage SQL,
vous connaissez les langages et protocoles du WEB (http, https, html),
vous êtes curieux et souhaitez vous impliquer dans des projets à long terme,
vous savez vous adapter aux fonctionnements d’une entreprise à taille humaine.
Alors, rejoignez-nous pour participer au développement de notre solution de gestion disponible sur Windows, Mac OS et sur navigateurs web.
Envoyez-nous votre candidature et faites-nous part de vos motivations à contact@billjobs.com
Salaire selon profil, mutuelle, intéressement, tickets restaurant.
You may have seen Vincent Mercey in Munich at our Xojo conference.
Nur noch einen Monat bis zur FileMaker Konferenz 2018 in Malbun (Liechtenstein) und zur MBS FileMaker Plugin Schulung am Mittwoch vorher.
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 hier buchen.
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.
Für den Deutschsprachigen Raum ist diese Konferenz das Treffen des Jahres. Hier finden Sie vom Anfänger bis zum Profi Kontakte zu anderen Entwicklern und vor allem den Kontakt zu den FileMaker Mitarbeitern. Lernen Sie was es neues gibt, lernen Sie wie man Probleme löst und erzählen Sie den FileMaker Mitarbeitern was Sie sich für die Zukunft bei FileMaker wünschen!
For 2019, I have the chance to visit the Consumer Electronics Show in Las Vegas in early January.
Years ago I visited the Cebit here in Germany, but the CES will be bigger and show more hot new stuff. I hope to see a lot of innovative things to inspire me for future projects.
Anyone else going to CES next year?
In case we may have an extra meeting with developers, I made two surveys:
As you may know, FileMaker uses Unicode text with 16bit, so Character() function doesn't work with the bigger codes for getting emojis like 128512.
As an example you can go to the Full Emoji List and pick a smily. e.g. first one has unicode code point 1F600, which is a hex number, so we convert it using the calculator or Math.HexToDec function. This gives us 128512 and char(128512) gives just a wrong result. But our MBS( "Text.Character"; 128512 ) function call works and returns the smiley as text: 😀.
We can also get flags by using Text.Character and the right magic number or the start: 127397. If you add the ascii code of the letters for the country, you get back the unicode characters forming the flags.
The little DebugView application from Microsoft can be very useful to see the debug messages from various applications. If you run it as admin on Windows and set the option in the menu to capture global Win32 messages, it will show the debug messages from our plugin used by FileMaker Server:
As you see MBS FileMaker Plugin on Server always prints this welcome line including version, platform, 32/64bit, which FileMaker process and the version of the FileMaker SDK reported by the loading FileMaker application.
If you use MBS("Trace") without a file path, you will see all calls to plugin functions in the log, too. This is very handy to have a live view on what's going on with the plugin. If you set the option to trace only errors with Trace.ErrorsOnly, you only see the calls which return an error message.
Today at the Macoun conference, I visited the session about CoreML and for a nudity scanner. This included the pointer to the following CoreML model to detect nudity in pictures. That's great, if you get pictures from users and you want to know whether they include any porn pictures.
You can download the model here: Yahoo's Open NSFW detector with Core ML as part of an open source project. In the download, please locate the OpenNSFW.mlmodel file and put the path into our CoreML.fmp12 example FileMaker database or the CoreML Xojo project coming with MBS Plugins.
When you run this model with a porn image, you may get an output like this:
As you see this model has only two classes SFW (safe for work) and NSFW (not safe for work) to categorize images in. For each we get the probabilities and the classLabel for the most likely class.
This can be used in various projects in both FileMaker and Xojo. Whatever image you get to post on social platforms, add to your image database or upload to your CMS, you can pre-check images. Whether you warn the user only, mark them as porn or decline them is your choice.
We are looking forward to improvements in MacOS 10.14 Mojave and iOS 12. Looks like CreateML lets you really easily create new models.
For other models, please check the awesome list of models for Core ML here: github.com/likedan/Awesome-CoreML-Models. There are some really cool models like predicting location of a picture, what type of food you got on a picture or gender classification for names.
At the MBS Xojo Conference 2018 in Munich, I presented the keynote about MBS Plugins to show what's new from us this year. As the recording is not perfect, I recorded it again for you:
If you have questions, please do not hesitate to contact me.
In our new video, we show you how to embed the MBS Filemaker Plugin 8.4 into the app made with FileMaker iOS SDK 17.0.3:
The steps I did in the video are:
Get MBS Plugin for iOS SDK from the 8.4 download.
Get FileMaker iOS SDK from the community download.
Unpack iOSAppSDKPackage_17.0.3 archive.
Optional remove quarantine stuff via Terminal: xattr -c -r /Users/cs/Desktop/iOSAppSDKPackage_17.0.3
Change SignScript and run via terminal to sign plugins.
in Terminal move to right folder: cd /Users/cs/Desktop/iOSAppSDKPackage_17.0.3
In Terminal make new project: ./makeprojdir test test de.monkeybreadsoftware.test
Add button in placeholder.fmp12 to show dialog with version: MBS("Version") & ¶ & MBS("Platform")
Copy MBS.fmplugin.framework from simulator folder to the plugins folder
Run in Simulator
Copy plugin for device into project.
Setup Codesigning with company team.
Select device
Run on device
Take screenshot in Devices Window
If you run into problems, let me know.
You may see logs in Xcode with messages about wrong architecture (simulator vs. device), if you picked wrong plugin file. Also if plugin doesn't load on device, it may not be properly signed.
As of today, we can't submit it to App Store as a little thing needs to be changed in FileMaker iOS SDK: Issue 787652
The good news is: We have videos this time.
The bad news: The camera was not the best one and not properly configured, so we have something to improve for next conference.
Still you can watch the videos and all attendees should have an email with the download link.
Here a few screenshots:
Have fun watching them. If you didn't attend and you like to get a copy, please order here. Be sure that the money will be used for the next conference and especially for better videos.
Sunil Abraham (MBS Xojo Plugins,…): Please update libXL in th… Christian Schmitz… (FileMaker iOS SDK…): It was solved until Apple… Michael Ashley (FileMaker iOS SDK…): Hi, is the issue with sub… Steve Koger (Tip of the day: I…): This is broken in 2018rx … David Thorp (Tips for FileMake…): Ok, so it’s basically the… Christian Schmitz… (Tips for FileMake…): You can use Shell.Wait to… David Thorp (Tips for FileMake…): Some more questions about… Stefano Morandott… (FileMaker Excelle…): You absolutely deserve it… Markus Winter (FileMaker Excelle…): Super! Glückwunsch! João Coutinho (FileMaker Excelle…): Well deserved it.
Congra…
If you like to plan an event, run a conference, you may need to consider a lot of details.
Once again Xojo is sponsoring the 
New in this prerelease of version 8.4 of the MBS FileMaker Plugin:
New in this prerelease of the 18.4 plugins:
As you may know the FileMaker Server comes with a copy of apache web server software. You can use the apache web server to host and deliver files for download. So if you copy a file to /Library/FileMaker Server/HTTPServer/htdocs/ folder on your server, you can than point to that file with the URL of your server with folder and file name attached.
Our client 
Nur noch einen Monat bis zur 
