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:
The Xojo Web framework contains a special class to hold information on an uploaded file, the WebUploadedFile class. Used by the WebFileUploader control this class provides you the information of the uploaded file. Let's take a deeper look:
An uploaded file can either be backed in memory or backed by a temporary file. There is a threshold when files are put in memory or into a file and we don't know when exactly this happens. But there may be multiple reasons like memory usage.
Consequentially if you query length, you are returned the length of the MemoryBlock or the temporary file. If you query Data, you get back the MemoryBlock or for a file backed one, the data is read and returned. This means the file has to fit in memory to not cause an exception. And it may cause a delay for the time to load the file. Sadly the trigger to loading data in memory may be when you stop in debugger and inspect the WebUploadedFile file. You then see file property and data property have content.
The UploadComplete event is where you get the array of the uploaded files. Here you may process the data, e.g. take it pass it to Picture.FromData to read in a picture. If you store the WebUploadedFile object in a property of your web page, be aware that file backed uploaded files get their temp file deleted when the event finishes. So you have to take the data or query file property and copy the file. For performance doing a hard link into your own location may be the quickest way.
The deletion of the temp file caused a few support calls in recent times where clients passed the folder items to DynaPDF or Zip/Archive functions to process them. Our functions had trouble to open the files, which is no wonder when being deleted.
Looking on the temp folder, it looks like Xojo may push an upload into a temp file. Then later processes it and copies data into smaller temp files (or hold them in MemoryBlocks). Finally the temp file deleted when the request is processed.
For the future, I'd wish they would delete the temp file in the destructor of the WebUploadedFile object, so we could keep it around a bit longer. A trick to do that may be to open the file and keep a BinaryStream for it around. On macOS and Linux you can delete an open file, so you can read it until the BinaryStream is closed and the file is really gone. On Windows you can't delete the file while it is open, so you may need to delete it yourself later.
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.
The new Xojo update brings a few things, which didn't meet the deadline for r1. With Xojo r1.1 you get the universal linker included, which allows you can build applications on an Apple Silicon Mac without using Rosetta. The bundled utilities Debugger Stubs, Lingua and Image Maker apps are now macOS Universal as well as your worker console apps. Finally the debugger for iOS applications can use the iOS simulator with native code.
Please note that you will need newer plugins from us for arm64 code in simulator. Please update to 21.1pr4 or newer.
There is a new DesktopColorPicker control as a surprise. You may know that Xojo has a SelectColor function, but recent macOS updates broke the functionality. You must now use asynchronous mode on macOS, either with the new control or our NSColorPanelMBS class.
We are happy to see ongoing development on the web framework. The memory leak for whole sessions seems to be fixed. I hoped the JSONItem leak would also be fixed, but that didn't make it before the deadline. Well, eventually you have to ship.
If you need to localize your Xojo app, please check the updated Lingua app. It has a scripting engine (using XojoScript), which allows you to automate various tasks.
Nevertheless, this is a solid release and we used it for a few things the last weeks and had no issues with our projects. Please try it and report feedback to Xojo soon. What have you noticed?
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.
The next version of ChartDirector, version 7, will come in spring to summer 2021.
We already started with the development for a future version of our MBS Xojo ChartDirector Plugin.
We got newer headers and libraries for C++ to try. Windows and macOS builds already. Linux and iOS are still to do. And of course examples and documentation.
Not sure whether this goes in our May release yet. But if everything is ready in time, we may ship the update with MBS Plugins 20.2 in May. But otherwise it may go into 20.3 in July. If you have a current license by release date, you will get this a free update. Older licenses may need a license renewal.
Have you recently visited the Xojo forum?
There are now over 20000 members. At least that much people got the basic badge.
The forum has been steadily growing over the years and recently I think the activity increased since Xojo Inc. installed the new forum software. We just interact usually with the about 1000 people being active on the forum. The majority of members just comes from time to time to search for a tip on an issue and never ask something. I personally know a few people in Germany, which are not good in English and will probably never post, but read a little bit with help of translation software. Something like 500 people are regularly posting on the forum. And the ones we know personally have come to one of the Xojo conferences.
Since Xojo added more targets over the years, the user base got diversified a lot. 10 years ago we were mostly desktop database developers, but now you have lots of web development, some iOS developers and even people only writing utility for small linux boxes like the Raspberry Pi.
Over the years we have seen people come and go. With 20 years in business, we have seen clients get engaged, get married and raise children. Other have used our products and retired or passed away. There is always change in the member list with people coming and going.
As we make plugins for both Xojo and FileMaker, we saw quite a few people using both FileMaker and Xojo. And you may remember the table on one of the past Xojo conferences with FileMaker developers meeting there to discuss their projects? Always use the right tool for the right job!
Earlier in October 2017, we reported 18000 users and the old Real Studio forum topped at about 7500 users.
Looking forward to celebrate 25000 users. We can still take bets on what year that will be.
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.
Since I moved to using Big Sur now for macOS, I had a little trouble running apps with Xojo 2019r1, a version we still use for a couple of projects.
Lucky with a bit of searching around, I found a workaround posted by Norman Parlardy:
Big Sur and 2019r1.1
The official line is “if you want to run Big Sur you MUST use a version newer than 2019r3.2” – at least for desktop apps (web apps arent affected in the same way)
But you CAN actually get 2019r1.1 to work for desktop apps on Big Sur
Here is what I have done to be able to run Xojo 2019r1.1 on Big Sur (Intel) – and to successfully DebugRun and Build Desktop applications:
Replace these files in the Xojo 2019r1.1 application bundle with those from 2019r3.2:
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 188.8.131.52, 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; "email@example.com") ]
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.
A few months ago we saw memory leaks in the Xojo web engine. Sessions were not released properly. The suspicion was that somewhere in the web framework may be a weak reference. The bug was reported by me as 63687. By reproducing it with the official EEWeb sample project, it was clear that it's not my own code.
This bug turned out to be a duplicate of 63378. And that one was fixed in April, so it may be in current test version and may go into verification and the next release. Hurray!
Now the hunt continues because while looking for the bug we got a little code to dump class counts. The code uses runtime object iterator to loop over all objects and counts how many of each class/vartype we have. Just counts on how many arrays of each type (integer, object, boolean, etc.) and what object classes via Introspection like how many Dictionaries, JSONItems, WebPages, etc. The print showed that with newer Xojo versions the EEWeb project leaks thousands of dictionaries. At least I would expect that when a session ends, we go back to the object counts we had before. Not for the first session as it initializes a couple of global objects. But when I let first session expire and then create 3 new ones and wait for those to close, the counts should go back to normal.
To demonstrate the problem to Xojo engineers, we got this snippet:
It now listed ARM64 for Linux as an item they work on. This currently number 2 in the feedback user favorites. We are very happy Xojo Inc. finally schedules this feature for implementation. We asked for that long ago.
The feature request 42794 was created in 2016 when Raspberry Pi 3 with 64-bit CPU got available. While most Raspberry Pi computers still work in 32-bit for compatibility, you can run the newer ones with 64-bit Debian Linux distribution. And since Amazon provides ARM based server hardware for their AWS EC2 service, you may enjoy using those machines with Xojo applications soon. AWS with ARM are priced lower compared to Intel based systems. Finally Apple's recent M1 Macs run virtual machines with Linux, which could also benefit from Xojo applications.
For our plugins we have Linux ARM 64-bit support already. All our plugins are built for arm64 and wait here for a future Xojo version to test. Of course we need a newer plugin SDK, which may introduce this target and clarify a few things like the updated plugin structure.
Please know that the roadmap lists various items Xojo Inc. works on, but not all and not necessarily in the order they ship. The listed items tend to be the ones, which takes multiple releases to get finished. Smaller items, which can be done in a few days by an engineer, may not be listed there.
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.
We had NSSpellCheckerMBS class for macOS for years. But for Windows we had a missing spot in our class lists. Microsoft added spell checking for Windows 8 as a system wide service.
For MBS Xojo Plugins in version 21.2 we add the WinSpellCheckerMBS class to check for supported languages. Pick a country & language specification and initialize a new spell checker. Then you can check some text for error sand get an array of WinSpellingErrorMBS objects. Spell checking may suggest direct replacements, deletions or showing suggestions. We do have a Suggest() function to ask for suggestions and show them the user.
If you like, you can define auto corrections, ignore words and add words to teach the engine your custom words. Optionally you can use user dictionaries.
In general the functions work on Windows 8 and newer except a few newer functions like the Remove method, which needs Windows 10.
Please try and let us know how it works. You may need to develop your own integration to show in text area what is mistyped.
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 firstname.lastname@example.org 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.
Changed a couple of internal text functions to recognize that text with UTF-8 as a BOM for UTF-16 or UTF-32 and then reinterpret bytes to handle that. Useful for Shell.ReadOutputText, when a command line tool outputs UTF-16 instead of expected UTF-8.
Changed CURL functions to not print password for SFTP transfer in debug log. Left overs from debug session in 11.1 betas.
Changed our buttons for Data Viewer to hide if we can't evaluate as no file may be open.
Changed plugin on Server to log StdOut and StdErr to log files for Windows and MacOS, as we did before on Linux.
Changed SQL errors to add field name for SQL update statements for type mismatch errors.
Changed XL.Initialize to accept empty path and pick the file name automatically per platform.
1st April 2000 I founded my company. Well, I registered as a business by getting my business registration (Gewerbeanmeldung) 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. And since 2006 I got into FileMaker Plugin development.
Thanks everyone for supporting me over the years!
PS: If you need a new license this weekend, use coupon code Birthday for an 21% discount.