You use the little configuration app on Windows to tell it which IP and port to connect to. Our normal TCP Socket example coming with our MBS FileMaker Plugin can do the receiving and show you the data. As text encoding use Hex since you get binary data. The first 4 characters are timestamp, package type and data length followed with up to 16 bytes of card UID. And since we need only that UID, we cut it from the data block with Middle($text, 13, 32). In hex all bytes take two characters. We get the UID as hex string and can store it in a database field for later comparison.
If you have trouble getting a connection, please make sure the Firewall lets the connection coming in. Beside a FileMaker Pro waiting for connection, you could of course use a little app or script on a computer to accept it and trigger whatever connection. For example a Xojo app using our MBS Xojo FMAPI Plugin could listen with a ServerSocket in Xojo, take the request and then use data API to create a record in FileMaker or perform a query to find the record for the UID. This may even run on a little Raspberry Pi computer and if the card is accepted put power on a PIN to trigger a door opener.
Please do not hesitate to contact us with your questions.
This conference is organized by Egbert Friedrich and takes place from 3rd to 5th June 2021 in Berlin, Germany.
Since this year the meeting will be virtual again and in English, FileMaker developers from all over the world can join live from home.
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 2nd June 2021 in the later afternoon with a relaxed "Beer and Sausages" in the virtual beer garden. The session days itself last from 3rd until 5th June with various socializing events in the evenings. 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
This year it is virtual, so you can join from your home. 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. A donation to help on the equipment cost is also welcome.
See you there!
When you deliver your FileMaker solution on macOS, you may customize the look of your application. This may include custom menus, toolbars and dock icons.
You probably use a custom menu in FileMaker when you do a serious solution. Because you may not want to expose all the normal menu commands to your users, but reduce the feature set to what they actual need.
Early in the start script you may want to call App.SetProcessName to set your solution name. This defines for example how the top left menu next to the Apple Menu is named on macOS.
After you set the custom menu, you may further customize the menu and rename the content of the some menu entries. For example here we change the hide command to have a different name:
After we updated compilers for macOS and Windows recently, it may be time for Linux.
To build all our plugins for 64-bit Linux (x86_64) we moved to Ubuntu 18.04 this week.
It turns out that updating to a new version of a compiler is easy. You rebuild everything, check new warnings and handle some error messages for changes in C++ frameworks.
But then we tried the plugin on CentOS 7.9 and this was a disappointment. Tons of missing libraries. Well, looks like the c and c++ libraries in CentOS are a few years older than the one in Ubuntu 18.04. Now either we fix the dependencies or we have to redo with CentOS to have a common base.
It turns out you can track down dependency by dependency and use various compiler options to disable newer features and stay with older C++ version 11 instead of 14 or 17. I'd wish this would be easier, but I had to recompile dozens of times to see what each changes causes. e.g. for a normal standard C++ string, you have nine ways to construct them. But we now have to avoid the newer variants and then it works.
On the end the plugin now loads on CentOS 7.8 and Ubuntu 18.4.
If you use an older version of Linux 64-bit, we may be able to avoid another function for you, but not a dozen!
Our first build of the plugins required glibc version 2.27, glibcxx 3.4.21 and cxxabi 1.3.9 as those are the ones coming with Ubuntu 18.04.
The final builds are down to glibc version 2.17, glibcxx 3.4.18 and cxxabi 1.3, which makes it compatible with CentOS 7.9.
Ubuntu 16 comes with CXXABI 1.3.9 and glibc 2.23, so we expect the plugins load on Ubuntu 16, too.
We also tried a fresh installed CentOS 7.7 and it seems like things work there, too.
Coming soon for pr5. If you like to try before that, please let us know.
Vom 17. bis 19. Juni 202122. bis 24. Juli 2021abgesagt findet die elfte deutschsprachige FileMaker Konferenz in Malbun, Liechtenstein statt. Aktuell läuft die Frühbucherphase bis 28. Februar mit vergünstigten Tickets.
Die Veranstalter vom Verein FM Konferenz erwarten auch 2021 rund 120 Entwickler, Anwender, IT-Fachleute und Entscheidungsträger aus Wirtschaft, Bildung und Verwaltung. Rund um über 20 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. Lernen Sie was es neues gibt, nehmen Sie Impulse mit für die eigene Arbeit und erfahren Sie mehr zu FileMaker von deutschsprachigen Experten!
Die MBS Plugin Schulung vorher findet voraussichtlich am statt im gleichen Hotel am 16. Juni 202121. Juli 2021abgesagt.
Bitte planen Sie wenigstens einen extra Tag ein für ihren Besuch in Liechtenstein, damit Sie die Natur in dem schönen Tal geniessen können. Den Aufstieg auf den Sareis können Sie bequem zu Fuß vom Hotel aus starten und die Turnastraße hinauf spazieren bis zum Restaurant am Gipfel. Oder alternativ die Seilbahn nehmen.
Hoffen wir, dass sich im Frühjahr die Corona Lage verbessert und die Konferenz stattfinden kann.
We have a video to explain our new Option-Click feature coming to MBS FileMaker Plugin for version 11.2:
So Option-Click on the gear icon will let FileMaker open the dialog or show the popover. The MBS Plugin notices the option key is down and then clicks for you the button to open the calculation dialog.
The new MBS FileMaker Plugin 11.2 are coming in May 2021 and include this feature. We may tune it a bit more and if you like to try it, please play with 11.2pr4.
Set Variable [ $version ; Value: MBS( "Files.Delete"; $Path) ]
As you see this script gets a temp path, writes the plugin there with DLL file extension and queries file information. Since MBS Plugin has all metadata in the right headers for DLL handler, the file information can be read by OS functions.
Since this uses OS functions, it needs to run on Windows. Technically we could also do something cross platform, but that would need to read file in memory, scan for the version entry and return it.
Here is a table documenting the release versions of our MBS FileMaker Plugin from the last years. You see how regular we release and what the build number the final version had. If you still use an older one like 220.127.116.11, you may notice you have the pre-release version. Pre-release versions usually are not ready for new/changed features and contain some more debug code to do runtime checks. We disable those for final builds.
Added support for FileMaker
This table also lists which version introduces support for newer FileMaker version. Older plugins can't know what a newer FileMaker version brings, so while the plugin is usually ready in time, there are something breaking things. For example the 32 to 64 bit move, the addition of new Linux platform or upcoming Apple Silicon support. Sometimes things change in FileMaker like the Web Viewer switch to WebKit 2 in FileMaker 16, which caused us to rewrite those functions.
A similar table could be assembled for operation system. On macOS you may prefer to use 11.0 or better 11.1 for Big Sur.
Please do not hesitate to contact us if you have questions.
As you may know we have support for sending and receiving emails with our MBS FileMaker Plugin and MBS Xojo Plugins. Using CURL functions we do the transfers for SMTP, POP3 and IMAP. Our SendMail functions help assemble emails including html content, inline graphics and multiple attachments. All with proper text encoding, so your umlauts or asian characters survive. The EmailParser functions help to parse emails and our IMAP Email example shows how to use them to load emails and preview them in a web viewer.
Now Gmail has some security enhancements. And you can use a few ways. In general if you use an account for automating processing of emails, it may be good to make a separate account. Don't use your main account, but maybe have an extra gmail account to send your emails and process the bounces. Keep this separate to your other accounts.
1. Access by less secure applications
Gmail has an option to allow use of less secure applications.
You can enable that option and then just use your login to gmail for our email functionality.
Here are some sample script lines:
# set server without SSL here, as we enable TLS later
Set Variable [ $r ; Value: MBS("SendMail.SetSMTPServer"; $EmailID; "smtp.gmail.com" ) ]
# put in your login here
Set Variable [ $r ; Value: MBS("SendMail.SetSMTPUserName"; $EmailID; "firstname.lastname@example.org") ]
Set Variable [ $r ; Value: MBS("SendMail.SetSMTPPassword"; $EmailID; "MonkeyLikesToSendEmail") ]
And later in the script configure CURL:
# This turns TLS on and requires connection to be encrypted
Set Variable [ $r ; Value: MBS("CURL.SetOptionUseSSL"; $curl; 3) ]
# force TLS version 1.2 or newer
Set Variable [ $r ; Value: MBS("CURL.SetOptionSSLVersion"; $curl; 6) ]
# You may want to put in the root certificate related for google. We have the cacert-google.pem file on our blog, which contains the GlobalSign Root CA - R2 used by Google. By using only this certificate, you can avoid a man in the middle attack with a gmail.com certificate from another CA. Since the cacert expires someday, you may need to update that every few years.
Set Variable [ $r ; Value: MBS( "CURL.SetOptionCAINFO"; $curl; "/Users/cs/Documents/cacert-google.pem") ]
# now enable full verification:
Set Variable [ $r ; Value: MBS("CURL.SetOptionSSLVerifyHost"; $curl; 2) ]
Set Variable [ $r ; Value: MBS("CURL.SetOptionSSLVerifyPeer"; $curl; 1) ]
This seems to work as of April 2021. But better use the following method:
2. App Passwords
Now you should have a 2 factor authentication enabled for your account. And once you have it, always be cautious if you see a request coming to your device. Whenever you login, you will be asked for a token, which comes via sms or app. Eventually someday there may be a hacker, who got your right password and tries to login. Then please don't grant access and don't tell anyone the code you get. Not that someone is on the phone and tells you to read the code google sends to you to enter a lottery.
Once 2 factor authentication is enabled, the security settings website from Google shows App-Password section. There you can create a new one by selecting app and then device. I select Email in left and other use in right popup. Then it shows a text field and I just enter "FileMaker SMTP" and generate button. A new password like oagveoxdhvgzxnhr is created. We copy this password in our example and we can send emails. Once you send an email, the app password website shows the last usage time:
Screenshot is in German, so your texts may be in a different language. The script to send emails with look same as above, just with a different password.
You can also use oAuth to authenticate. Perform the login and get the bearer token, then pass it to CURL.SetOptionXOAuth2Bearer to do the login via CURL.
Client contact us in various ways. Mostly email, but some go via website chat, feedback form, text/iMessage/Signal messages, some use Skype or send private messages on LinkedIn, Facebook, Twitter or Xing. All the messages usually arrive and we get notified. But sometimes it fails.
If you don't get an answer within a reasonable time, e.g. 2 days, please contact us again using an alternative way. The idea with 2 days is that there may always be a holiday or time in an airplane while traveling, where we have no chance to look into your message.
Recently we had a client putting several support requests into a web form on our website which all were not delivered. Not sure what the outage was that let a few of many messages not come through. Other clients sent messages before, in-between and after and those worked. If the web form doesn't work, please come back via email. The client was of course very disappointed, but waited weeks before they contacted us via email about this. We could have helped quicker.
One thing not to forget is to put our domain monkeybreadsoftware.de on a white list for your spam filter or add our support email address to your contacts. This may prevent spam filters to block us. Regularly our emails get blocked and answers or even license key delivery fails. A way to overcome that is to provide a second email for us, so we can answer to that one. And finally typing your own email address into a form can be difficult. If we have you in the database or a previous email, we can correct a typo, but for new clients, we often have no way to answer them.
We also encourage users to post on the relevant forums. The community may help with questions about our plugins and often answer quicker than us. But even while we monitor a dozen forums for new posts regularly, we may still miss a message there. But feel free to refer to @Monkeybreadsoftware in your postings to call us specifically.
As always, please don't hesitate to contact us if you have questions.
Claris FileMaker Server 19.2.1 is the last version on CentOS and will be supported till October 28, 2022. The next Claris FileMaker Server release will require Ubuntu. We expect this to be released within a few months.
Our MBS FileMaker Plugin already runs fine on Ubuntu servers with pre-release FileMaker Server software. If you’re interested in testing FileMaker Server on Ubuntu, send an email to email@example.com to be considered for the External Testing Site (ETS) program. Then you can install a server in a VM and install our current MBS Plugin.
If you have a Linux server, you may just spin up a new one later this year, install Ubuntu and a newer Claris FileMaker version. Then copy your database over and change DNS to point to the new server. Don't try to upgrade. Keep the old server as a backup, ready to take over if the setup of the new one fails. Once you migrated, you can then retire the old server (VM).
In case Claris decides to support Linux on ARM 64-bit in the future, we can would be happy to build our plugin for such a platform.
For my birthday last Sunday I got a lot of nice emails, greetings and comments. But a few people went further and surprised me with letters, cards and even some presents!
We collected them all and put them on a fish net in the hallway, so we can remember them.
Thanks everyone for your good wishes and heart-warming texts. The Xojo people for example printed a special postcard with several pictures with me and staff on it.
See you all soon on the next conferences!
We continue to be a Claris Partner as we just renewed our FBA membership:
It is already nine years since we applied for this and being a Claris Partner helps:
The listing on the website as well as recommendations to prospects by Claris employers helps to bring business to your company. You get a discount for license purchase so you can make some money selling your solution bundled with the FileMaker licenses and offer one stop shopping to your clients. You can list your products on the marketplace and use Solution Bundle Agreement if you like to sell a lot of bundles. Access to beta versions, extra training sessions, exclusive partner meetings and a few test licenses are included. And you can bundle tools like the data migration utility with your solutions.
If you like to become Claris Partner, you can read more on the Claris website.