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.


by Ben Fletcher 9 July 2025
Claris FileMaker 2025 is the ultimate platform for custom app creation, now with powerful new native features for leveraging Artificial Intelligence by integrating Large Language Models (LLMs) and integrating with Claris Connect and Claris Studio . Given its advanced features and capabilities, it's the platform of choice for SMEs seeking to start fresh building a new custom business app. However, if you're thinking about upgrading from an older Claris FileMaker version, preparation is key, and that's where we come in. This brief guide outlines the major points of consideration when upgrading. However, don't worry if these technicalities overwhelm you - our expert consulting team is just a click away, ready to guide you through any concerns. The Upgrade Process: Claris FileMaker v12-v2024 (.fmp12 format) The good news: versions 12-2024 share the same file format as the 2025 version, making upgrades a breeze. However, certain interface changes might require user adaptation if build prior to FileMaker 16. For example, if your users utilize the footer bar for zoom control, view mode changes, or status bar display, they'll have to adjust to using the upper status bar and application menus. If that's a challenge, our consultants can assist with incorporating zoom control into your interface layouts. One caveat is that while it's possible to use legacy versions of Claris FileMaker Pro to connect to Claris FileMaker Server 2025, we advise against it. Mixing client versions can prevent you from leveraging the full benefits of the Claris FileMaker 2024 feature set. For maximum security and optimal performance, make sure both the server and all users are on the latest software version and patch. Claris have compiled a handy checklist of deprecated features in Claris FileMaker 2025, so make sure to verify if these impact your usage: [ LINK] Revamping Your Legacy Systems: Claris FileMaker v11-6 (.fp7 & .fp5 format) or earlier Older versions of FileMaker are a testament to the platform's longevity. However, they do come with unique challenges, including the impossibility of direct conversion using Claris FileMaker 2024. Don't worry, we're equipped to handle these issues and are ready to bring your vintage database files into the present. We also recommend considering a fresh start. The latest Claris FileMaker boasts myriad features that can significantly boost your business operations. Remember: upgrading isn't merely about maintaining the status quo—it's about embracing innovation and driving your business forward. If you want to do the minimum possible work to convert your files into the v2025 format then look at our previous guide for FileMaker Pro 19: https://www.datatherapy.com/news/2020/6/5/planning-your-upgrade-to-claris-filemaker-19-platform General Upgrade Considerations: Let's Get Practical No matter your current version, our team can assist you through the upgrade process, even if your app involves complex dependencies, such as integrations with legacy software or plugins. Note that most plugins will require updates (sometimes paid) to ensure compatibility with Claris FileMaker 2025. We encourage you to consider the future-proofing benefits of a 'cloud-first' and 'AI-first' mindset. Older systems may not have been built with this in mind, but the modern FileMaker platform has been designed to seamlessly integrate with other cloud solutions and now leading public and private LLMs. Ultimately, we believe that your software should work for you, not the other way around. That's why we're committed to ensuring your upgrade is more than a simple technical exercise—it's a strategic move that aligns with your business' evolution. If you're ready to harness the power of the modern, interconnected, and dynamic Claris FileMaker 2025, get in touch with us today . We're here to help you achieve your business goals.
by Ben Fletcher 9 July 2025
What is new in FileMaker 2025?
Wooden blocks with LEARN written on in the style of the game Scrabble.
by Ben Fletcher 1 July 2025
Discover why staying up-to-date with Claris FileMaker certifications ensures secure, future-ready systems built by trusted, certified development experts.
Post pattern artwork.
by Ben Fletcher 30 June 2025
Integrate Claris FileMaker with local vision AI using llama3.2-vision and Ollama. Keep data private while adding powerful image processing to your workflows.
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.
More posts