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.


Ai Robot
by Ben Fletcher 17 June 2025
Discover the power of DeepSeek R1—an efficient, open-source AI model ideal for private, local deployment using Ollama and Apple Silicon. Learn how DeepSeek compares to LLaMA, Mistral, and other LLMs in real-world applications, and explore how it integrates seamlessly with Claris FileMaker for secure, on-premise AI automation. Ideal for businesses needing low-cost, high-performance, and fully private AI solutions.
Decorating a blank wall
by Ben Fletcher 30 May 2025
Claris has added dozens of new features with each release of FileMaker - so many that it is hard to quickly see exactly how you might quickly benefit from updating. Here we summarise some of our favourite features we like to highlight to customers looking to upgrade:
A lab working doing research
by Ben Fletcher 22 May 2025
Discover why FileMaker is a cost-effective, flexible LIMS solution for 2025—ideal for labs needing secure, customisable, and rapidly deployable systems.
by Ben Fletcher 16 May 2025
Learn how to run private AI locally using Ollama and integrate it with Claris FileMaker. Discover step-by-step setup, model recommendations, and how to build secure, AI-powered workflows without sending data to the cloud. Perfect for businesses prioritising data privacy and compliance.
Possibility of AI.
by Ben Fletcher 13 May 2025
Integrate Claris FileMaker with local LLMs like LLaMA 3 to boost efficiency with AI—without risking data privacy. Secure, intelligent automation for your business
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.
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 .
Databases
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 . . .
Optimising Claris FileMaker App Performance
by Ben Fletcher 25 March 2025
What to do when your FileMaker App isn't running as well as it used to . . .
by Ben Fletcher 14 March 2025
Ensuring Business Continuity: Augmenting or Replacing Your In-House FileMaker Team
More posts