The benefits of upgrading to FileMaker 18 Platform

The benefits of upgrading to FileMaker 18 Platform – New Data File Support

Ben Fletcher • 28 May 2019

One of the most significant enhancements in the FileMaker 18 Platform is the array of new script steps related to external data files. These include ‘Create Data File’, ‘Open Data File’, ‘Write to Data File’, ‘Read from Data File’ and ‘Close Data File’. This ability to read and write to external data files is great new addition to an already strong FileMaker platform, and one for which we envisage a number of useful applications: in FileMaker 17 and earlier has always been possible to export database data to files in tab separated values, comma separated values, DBF, Merge, HTML table, XML and Excel formats. ‘Live’ database data can be queried via Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC) and also https/JSON with the new FileMaker Data API.

So how is this different from the existing features and why is it needed?

Firstly, all of the above methods, only allow for the export and transfer of data which is already within a database table structure. If you wanted to capture debugging information or create a new export then the first step would be to have to create the database structure necessary to store the information and then script to export it. If the information is transient then you may also then need to write maintenance routines to ‘prune’t or delete this information. With the new script steps, data can be captured directly to a variable and this variable is then written to the external data file - no new structure needed, making the code potentially simpler and more portable. This is really helpful when for example, you are writing debugging routines or persistent error logs to be saved on your server at timed intervals..

Secondly, there are many cases where you might want to transform data structure and then export it into another format. I can think on many occasions where I wanted create a simple XML export without having to write XSLT to achieve this quickly. Similarly, it could be used for local dumps of data to JSON or SQL formats for example.

This feature is not without its limitations. FileMaker is limited to writing 64MB of data at a time with the Write to File script step and so for large scale exports it will be necessary to parcel out the writes into 64MB chunks.

< Older Post

Newer Post >

Google Sheets vs. Claris FileMaker: Why Spreadsheets Aren’t Enough for Serious Business Applications in 2025

by Ben Fletcher • 29 April 2025

Still running your business on Google Sheets? Spreadsheets are great—until they start holding you back. If you’re managing complex processes, critical data, or multiple users through Google Sheets, it’s time to upgrade.

Claris FileMaker Server 21.1.4 Update now available

by Ben Fletcher • 25 April 2025

The Claris FileMaker Server 21.1.4 update is now available and includes important fixes that address known issues from previous versions: Key Fixes 1. Field definitions incorrectly read from cache. A bug introduced in version 21.0 caused field definitions to be incorrectly cached, resulting in symptoms such as: Empty related fields Missing value lists and indexes “Insufficient privileges (error -9)” messages 2. Windows only: Server-side script sessions limited by CPU cores. Version 21.1.3 limited simultaneous server-side script sessions to the number of CPU cores on Windows. This impacted I/O-bound environments by unnecessarily queuing sessions. 21.1.4 resolves this by allowing up to 50 concurrent script sessions on Windows before queueing begins—regardless of CPU cores. These sessions may be triggered by schedules, OData, or Perform Script on Server (PSoS). Note: This behavior is not controlled by the AllowPSoS setting. Claris Recommends: To ensure system stability, it is advised to limit active clients to 40 - 45 simultaneous sessions. Exceeding 50 may result in delays, memory overload, or session hangs. Do you need assistance with upgrading? DataTherapy are pleased to announce that Claris FileMaker 2024 (version 21.1) managed private cloud hosting packages are immediately available. DataTherapy can provide scalable, managed FileMaker packages for businesses of all size. Full details of all of our packages can be found here . We can offer a range of a variety of enhanced options such as domain management, custom SSL certificates, VPN, VLAN, disaster recovery and integration with other technologies. If you need additional information on upgrading to the new release, advise on how to migrate your current on-premises FileMaker Server to the cloud, or would like to arrange a free trial of any of our packages then please don’t hesitate to contact our team .

Microsoft Access is Holding Your Business Back – Here’s Why You Should Switch to Claris FileMaker in 2025

by Ben Fletcher • 16 April 2025

Using Microsoft Excel for workflows and complex data management instead of a dedicated database presents several inherent problems. These issues stem from Excel’s limitations in scalability, data integrity, collaboration, automation, and security. Below is a detailed breakdown of these challenges and how a custom Claris FileMaker App can meet these challenges . . .