How to Build FileMaker Web Apps for High Traffic using MySQL Backend and 360Works MirrorSync
Why Sync FileMaker and MySQL?
FileMaker is the best tool for rapid application development, but it is not the most reliable or scalable option for high traffic web sites. MySQL provides that reliability and scalability, but can't compare to FileMaker for development productivity and user friendliness.
360Works MirrorSync bridges this gap, letting you use each tool for its best purpose. Quickly create layouts, scripts, and schema in FileMaker Pro, test and refine them, then use MirrorSync to publish all your record data to MySQL and keep both databases in sync moving forward. You can use industry-standard tools and frameworks (or hire from a vast talent pool) to create highly reliable and scalable web apps.
In the event that FileMaker Server is down or rebooted for any reason (such as software upgrades), your MySQL web app will continue running and serving users. MirrorSync will detect when FileMaker Server comes back online and bring both databases back in sync.
This video, narrated by Junior Perez of 360Works, takes you on a step-by-step walk-through of how to sync between FileMaker Server and MySQL. Junior demonstrates how to start with a completely empty MySQL Server, create the database and tables, and set up an auto-scheduled sync to run every 60 seconds. The process is the same for any other JDBC-compatible database such as SQL Server, Oracle, or PostgreSQL. The license price for syncing one FileMaker Server with any one of these databases is $1,800, with discounts available for educational and non-profit organizations.
If you would like to involve 360Works in configuring your sync, or in creating a web application backed by MySQL, please contact us for consulting and development assistance.
Read More on MirrorSync or Download Now!
360Works MirrorSync Stay updated with 360Works
Updated file management plug-in for FileMaker Pro 19 is prepared for Apple Silicon and gets the text contents from pdf files.
Lienden, the Netherlands, May 27, 2021–Troi today announced the immediate availability of Troi File Plug-in 13.0 for FileMaker 19. In this major update we made the plug-in a universal binary by adding code for the arm64 architecture of macOS. Furthermore we added new functionality and improved and enhanced several functions of the plug-in.
Tested and made compatible with Claris FileMaker Pro 19, up to and including FileMaker Pro 19.2.2. (macOS) Prepared the plug-in for Apple Silicon: made the plug-in a universal binary by adding code for the arm64 architecture of macOS. Improved PDF support
Added new function TrFile_GetAsPlainText function, which will return the text contents of a PDF as plain text. (Windows) Improved the Create Thumbnail script step and the TrFile_CreateThumbnail function: added support for creating thumbnails from PDF files. Improved ZIP functionality and enhanced ZIP64 support
(Windows) Improved the Create Zip script step and the TrFile_CreateZIP function, the plug-in now supports UTF-8 encoding. If the filepath of files to zip contains higher Unicode characters, the filename will be automatically stored in UTF-8 format. (Windows) Added new switch “-ForceUTF8Filenames” to the TrFile_CreateZIP function. When you add this switch all filenames in the ZIP file will be UTF-8 encoded. (Windows) Improved the UnZip script step and the TrFile_UnZIP function: ZIP files using the ZIP64 format extension can now be unzipped. The plug-in now has added support for unzipping files compressed with the Deflate64 method. (Windows) Improved the UnZip script step and the TrFile_UnZIP function: the plug-in now automatically detects the encoding of UTF-8 encoded filenames. (Windows) Improved the TrFile_UnZIP and the TrFile_GetZipInfo function: you can now add a -Encoding=x switch, like -Encoding=ASCII_Windows. The filenames in the ZIP file will be unzipped/decoded according to this switch. This is useful if the ZIP file was created using a non-standard filename encoding. (Windows) Improved the Create Zip script step and the TrFile_CreateZIP function, shortcuts files (with extensions .lnk) are now also zipped into the ZIP file. Improved movie and movie metadata support
Improved the TrFile_GetMetaData function: added several switches, which return a single property of a movie: -IsValidMovie, which returns 1 (true) if this is a valid movie or 0 (false) otherwise -GetMovieWidth -GetMovieHeight -GetMovieRotation -GetMovieFrameCount (it might take a while to calculate) -GetMovieSoftware -GetMovieYear Improved the TrFile_GetMetaData function with the switch “-GetMovieDescription”: you can now add an extra switch “-AddFrameCount” if you also want the frame count of the movie. Improved the TrFile_GetMetaData function with the switch “-GetMovieDescription”: (Windows) this switch now also works when running on a 64-bit version of Windows. The result now also returns the rotation angle and track size (width and height). The (general) size (width and height) now is the display size. So it reflects the rotation of the movie and also the clean aperture. It can return for example 980×1308 for a vertical rotated movie. This can be different from the internal track size, for example 1440×1080. Also changed the order of the returned size of the movie, the function now returns the width first and then the height. You can use the switch “-GetMovieDescriptionOldFormat” to get the original formatted result, i.e. height returned first and not reflecting the rotation of the movie. Added new GetMovieMetadata.fmp12 example file to the download, which demonstrates which metadata (and properties) can be returned from a movie. Improved the movie handling in several functions: added support for internally compressed movies (which contain the ‘cmov’ movie box). Improved the TrFile_GetFileStructure function: when using the -verbose switch it now returns more detailed movie structure information of a track, like the used video codec of a track or the clean aperture size. This function now also correctly returns the pixel density metadata. Improved iCloud Drive functionality (macOS)
Added switch “-AllowNonLocalCloudItems” to the TrFile_SelectFileDialog function. When used this will allow you to select files that are not downloaded to the local disk. Added switch “-iCloudStatus” to the TrFile_GetFileAttribute function,
The return values for iCloud Status can be: not on iCloud: this file is not on iCloud (Drive), it is outside the iCloud Drive, it is just a local file on the disk. on iCloud + local: the file is both on iCloud and on the local disk. on iCloud only: the file is only on iCloud, it is not downloaded on the local disk. on iCloud (updating): the file is on iCloud and on the local disk, but it is stale. A new copy is downloading to the local disk. Other changes and improvements
(macOS) Added support for using SMB styled paths as parameters for any file or folder path. You can use for example “smb://192.168.178.12/myShare/MainFolder/hello.txt” for a path to a text file. (macOS) Added a new switch “-ForceDelete” to the TrFile_DeleteFolder function.
When you use this switch in combination with the switch “-DeleteAllSubFoldersAndAllContents” the plug-in will forcefully delete any open files inside the folder and subfolders. Improved the Create Thumbnail script step and the TrFile_CreateThumbnail function. Added support for creating thumbnails from a container field (or a variable with container data), for example a JPEG or PDF in a container. Improved script triggering when using drag and drop: the plug-in now also triggers scripts where the filename parameter contains a period in the name and the (.fmp12) extension was not included (the FileMaker function “Get(Filename)” will not include the extension). For example if the filename parameter given is “Dropper1.0” the plug-in now adds the .fmp12 extension, resulting in “Dropper1.0.fmp12”. Fixed a few bugs. More detailed information on all changes and improvements implemented in Troi File Plug-in 13.0 can be found on the File Plug-in page.
Pricing & Availability
A fully functional demo version of Troi File Plug-in 13.0 is available on the File Plug-in page.
Licenses cost US$ 99 per user. Details on developer licenses and multi-user discounts can be found on the File Plug-in page. You can order licenses there or from our shop.
Version 13.0 needs a new registration. If you have a current subscription or if you bought a license on or after November 27, 2020, the upgrade is free. Eligible users will be sent a new registration. Contact us if you have not received yours after May 28, 2021.
Upgrades from licenses bought before November 27, 2020, are available from US$ 59 per user. Upgrade prices for other licenses can be found on the File Plug-in web page or in the shop. You can order upgrades there.
Last Chance: Buy a 360Works Plug-in or Add-on,
Get $100 Credit on FileMaker Hosting!
Last year we announced our new "Guaranteed Reliability" FileMaker hosting services to better support remote workers during the pandemic. We continue to offer cloud hosting for your FileMaker Server with numerous benefits for reliability, security, and support for our FileMaker products.
This is the last week to take advantage of the Hosting special for 360Works product purchases of $95 or more! If you purchase a 360Works plug-in or add-on, or renew a license, you will receive a $100 credit on your next Hosting bill.
(*Special is running for the month of May 2021.)
Existing Hosting customers are eligible. If you currently host FileMaker with us, and make a purchase this month, simply follow step 3 below to share your information with us. New hosting clients can follow the complete list of steps below:
Purchase a 360Works plug-in or add-on for FileMaker at 360works.com/products or use a product link from the list below
(*Final order total on plug-in or add-on purchase must come to at least $95 as the final paid price, if other discounts are used the total amount due must still be greater than $95. Renewals are eligible as are orders within the past 3 months.) Sign up for hosting at 360works.com/filemaker-hosting Submit your license or order number for your plug-in/add-on purchase and email to email@example.com letting us know you want your $100 credit!
360Works Plug-ins and Add-ons for FileMaker
Product Name Product Description 360Deploy Completely automate the FileMaker Data Migration Tool, simple deployment of new database versions Charts Easy-to-use charting for FileMaker CloudMail Send and track HTML email marketing campaigns Email Send and receive text and HTML emails in FileMaker, PLUS send SMS/Text Messages FTPeek FTP upload and download from your FileMaker database JDBC SQL access with JDBC Compatibility MirrorSync Sync FileMaker Go and Pro on a device without network connection, sync FileMaker Servers, and sync FileMaker with SQL databases Plastic Payment processing plug-in RemoteScripter Trigger scripts on FileMaker Pro from the web or IWP SafetyNet FileMaker Server offsite backup Scribe Read and write PDF, Word, and Excel files. Plus OCR in version 4! ScriptMaster Adds many new functions & create custom plug-ins SuperContainer A better container field Web Assistant Access internet resources, URLs, and fill out web forms Web Services Manager Publish FileMaker scripts as XML Web Services Zulu FileMaker calendar sync - integrate with Google Calendar, Exchange Calendar, and Apple Calendar - plus new support for Apple Reminders app in version 4!
Claim Your Credit or
Get Help Here
NEXT Wednesday: FileMaker Training TV Live Demo on FileMaker Calendar Integration Tool, Zulu
Joe Martin and Richard Carlton will be live on RCC's FileMaker Training TV (Twitch Stream) Wednesday, May 26, talking about Zulu, for integrating your calendars with FileMaker at 1 p.m. Pacific Time (4 p.m. Eastern)
The team at Richard Carlton Consulting will be having Joe Martin, Senior Developer and Product Manager at 360Works, on their FMTraining TV Twitch live stream NEXT Wednesday, May 26th at 1:00 p.m. Pacific Time (4:00 p.m. Eastern Time) to talk about 360Works Zulu, which syncs FileMaker to iOS, OS X, Google Calendar, and Exchange/Office 365 calendars. You can turn any FileMaker Server into a shared calendar server in a few clicks!
Using Zulu you can, manipulate the events in your calendar, and Zulu will write these changes to FileMaker records. The opposite is also true, updates to FileMaker records will be written to your calendar's events. Zulu will even respect FileMaker?s record level access privileges and record locking so you can filter records based on privilege set. Additionally, Zulu 4 introduced new support for Apple Reminders!
During the live stream, as time permits, Joe will cover:
How to integrate with Apple Calendar How to integrate with Google Calendar How to integrate with Office 365 Calendar
FMTraining TV sessions are approximately 1 hour long. Sessions will be streamed via FileMaker Training TV's Twitch, sign up below to get reminders and registered to be on at 1:00 p.m. Pacific Time (4:00 p.m. Eastern Time) next Wednesday!
Tune In Remotely
Topic: FileMaker Calendar Integration with Zulu
Date: Wednesday, May 26, 2021
Time: 1:00 p.m. Pacific Time (4:00 p.m. Eastern Time)
FMTraining TV Live Stream! Stay updated with 360Works
Nickenich, Germany - (May 18th, 2021) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 11.2 for macOS, iOS, Linux and Windows, the latest update to their product that is easily the most powerful plugin currently available for Claris FileMaker produce line. As the leading database management solution for Windows, macOS, iOS and the web, the Claris FileMaker Pro Integrated Development Environment supports a plugin architecture that can easily extend the feature set of the application. MBS FileMaker Plugin 11.2 has been updated and now includes over 6500 different functions, and the versatile plugin has gained more new functions:
Our plugin now ships with Apple Silicon support included. Claris announced they will support Apple M1 chip soon, so we are ready.
For SQL function we got support in SQLite for ICU libraries and we enabled math and geopoly functions in our internal SQLite library.
Within the Script Workspace (on macOS) you can now press option-key for the gear in Set Variable/Field script lines to jump right into the calculation dialog, thus saving you an extra mouse click.
For our XL functions to read/write Excel document we added XL.Book.AddFontFromBook and XL.Book.AddFormatFromBook functions to copy font/format definition from one document to another one. With XL.CopyCellValue function you can now copy cell values. With XL.Sheet.SetRows function you can now define height for a range of rows.
The Process.List function can list all applications running on the computer. And for Windows the RemoteControl.GetWindowsListAsJSON function can list all windows on the computer with details about them.
Our trace functions got upgraded. We can log on server the stderr and stdout messages. Trace can be paused and includes progress messages from DynaPDF functions and for Audit we log which field is audited.
For ListDialog functions we added column width and alignments. OCR functions are per thread, so they can run in parallel on server side scripts. We added SystemInfo.LinuxSystemInfo to query information about linux computer. We added SystemInfo.WindowsSystemInfo and SystemInfo.WindowsMachineInfo to query information about the environment on Windows like the CPU architecture.
Finally we updated CURL to version 7.76.1, DynaPDF to 184.108.40.206, SQLAPI to 5.1.4 with new DuckDB support and our Linux build machine to Ubuntu 18.04.
See release notes for a complete list of changes.
More details in the release notes. Please take the time to check our 600 example databases and check where you can use our plugin features in your solutions.
* macOS 10.9 or later, including macOS 11.0 Big Sur
* Windows 7 and newer, including Windows 10 and Windows Server 2020
* FileMaker Pro 7 to 19.2
* FileMaker iOS SDK
* FileMaker Server for Linux, Windows oder macOS
* FileMaker Cloud for AWS
Pricing and Availability:
MBS FileMaker Plugin is available directly from the MonkeyBread Software website with licenses starting at just $149 (USD). You can just download and try the plugin without a license or request a trail license. Not all functions are available in all platforms, please check specifications. Please join us on the next conferences and visit our booth.
MBS FileMaker Plugin Website:
Download Free Trial:
Events and conferences:
Located in beautiful Nickenich, Germany, MonkeyBread Software is a privately held company founded in 2000 by Christian Schmitz. MonkeyBread Software focuses on the Macintosh, Linux and Windows platforms. With over twenty years as a software developer, Christian's aim is developing unique and useful utilities, complemented by first-class customer support.
Copyright 2000-2021 Christian Schmitz Software GmbH.
MonkeyBread Software is a registered trademark of Christian Schmitz, Nickenich. All Rights Reserved. Apple, and the Apple logo are registered trademarks of Apple Computer in the U.S. and/or other countries. FileMaker Pro and FileMaker are trademarks of Claris International, Inc. Other trademarks and registered trademarks may be the property of their respective owners.
Who Viewed the Topic33 members have viewed this topic:Ocean West Ronnie Higgins Siva D Gordon Shewach gandi johnBuckingham mvoogt Msaeed Agnes Riley Matt.C Will Loving IdealData atomikSkull adim fishtech daveinc Nico Kobes David Zakary maverik_uk Sky Willmott Wim Decorte Franco Pagano JacobTaylor-RCC PowerSystem dubl Jim Gill Joshua Willing Halpern Matt Klein Ron Cates jayivan Amazin1 bcooney Rick Whitelaw