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 10 June 2026
Upgrade to Claris FileMaker 2026 with confidence. Learn key migration considerations, AI features, compatibility issues and best practices.
by Ben Fletcher 10 June 2026
FileMaker Server 26 Enhancements Multiple SASE Processes - FileMaker Server 26 allows you to configure the number of active process in the Server Side Script Engine (SASE), the upper limit being determined by the hardware in use. This allows for more server side processes to occur in parallel - for automated imports, sync and nightly data transformations which need high throughput. Auto-Restart - FileMaker Server's Web Publishing Engine (WPE), OData and Data API services now monitor and detect abnormal termination events and restart automatically on a crash. Export Field Contents on Server - No additional 3rd party plugins or work arounds to automate server side document generation and export to server side folders. FileMaker Go 26 for iOS Enhancements Additional support for iOS hardware and locale support. Core Platform Security Enhancements Additional corporate security enhanced with support for OpenSSL 3.5 LTS, Apache Tomcat 10.1.44+, Windows Server 2025 certification, and full macOS 2026 compatibility. Need help to upgrade to FileMaker 26? At DataTherapy, we specialise in supporting and upgrading legacy FileMaker apps as well as building new custom apps to leverage the latest features of the Claris FileMaker 26 platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. ✅ Certified Claris FileMaker Developers ✅ UK-based team of full-time professionals ✅ Platinum Claris Partner ✅ Experts in secure, on-premise and private cloud deployment of FileMaker 📞 Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
by Ben Fletcher 10 June 2026
As well as the customer facing UI enhancements, FileMaker 26 has a number of 'under the hood' tool enhancements for long standing developers: Enhanced Inspector - layout controls dynamically adjust based on the object type, reading the cognitive load of navigating the Layout Mode tools for new and veteran developers alike. Control Field Entry by Calculation - field level editablity is now controlled by a boolean calculation that evaluates at runtime based on any developer defined logic. This makes building role based editing or workflow based record locking much easier to implement. Sort Custom Functions with Folders - this now is applied at an independent folder level, making it much easier to work with distributing a shared function library that needs to display in a specific order. Set Layout Zoom by Calculation - the UI zoom can now be scripted to any decimal percentage, making it easier to make layouts which adapt to a specific user or device screen size requirements. Draco Catalog - FileMaker 2026 now includes a persistent catalog which is independent from the application data which can be used for storing JavaScript modules and persistent solution-level settings (app versions, feature flags and environment identifiers). PDF Script Workspace - dedicated script steps have been added for PDF manipulation which makes the generation of multi-page reports assembled from different layouts both using FileMaker Pro client and via FileMaker Server. Need help to upgrade to FileMaker 26? At DataTherapy, we specialise in supporting and upgrading legacy FileMaker apps as well as building new custom apps to leverage the latest features of the Claris FileMaker 26 platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. ✅ Certified Claris FileMaker Developers ✅ UK-based team of full-time professionals ✅ Platinum Claris Partner ✅ Experts in secure, on-premise and private cloud deployment of FileMaker 📞 Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
by Ben Fletcher 10 June 2026
FileMaker 2025 already added significant enhancements to leverage AI and FileMaker 26 continues to double down on this: Field Annotation A new AI tab is available within the Field Options to define a JSON calculation as the field's annotation which is used in Export dialogs, sort dialogs and most essential in Data Definition Language (DDL) for use in AI. Save as XML & Solution Upgrade Tool FileMaker Pro 26 can now save a copy of your solution as a .xml formatted text file and the enhanced Solution Upgrade Tool can now read XML input and create brand new .fmp12 files or patch existing ones. This is a huge boon for Claris FileMaker developers - it means that Claris FileMaker developers can now use AI tools to generate XML which can then be used to create real production ready FileMaker solutions. Additionally, traditional version controlling scheme and using diff tools to compare XML outputs between production and development releases can be compared. Google Gemini Support Gemini is now supported as a native option in FileMaker script steps making it substantially easier to integrate with Google Cloud and Gemini if that is your preferred AI backend provider. PDF Text Extraction The native ExtractTextfromPDF() function introduced in FileMaker 2025, can now be used to process OCR (scanned) PDFs and not just text-layer PDFs. This again reduces the reliance and cost of using additional 3rd party plugins, APIs or AI tools for text extraction. Need help to upgrade to FileMaker 26? At DataTherapy, we specialise in supporting and upgrading legacy FileMaker apps as well as building new custom apps to leverage the latest AI features of the Claris FileMaker 26 platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. ✅ Certified Claris FileMaker Developers ✅ UK-based team of full-time professionals ✅ Platinum Claris Partner ✅ Experts in secure, on-premise and private cloud deployment of FileMaker 📞 Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
by Ben Fletcher 10 June 2026
The new Claris FileMaker 2026 release includes enhancements to user experience and accessibility: WebDirect Accessibility & Platform updates WebDirect now includes better screen reader support for the visually impaired or motor disabilities: semantic HTML is now correctly labelled and there is improved focus management for modal dialogs, portals and pop-ups. This is a critical requirement for any public-facing WebDirect solutions where accessibility is a legal obligation. WebDirect in FileMaker 2026 now runs on JDK 21 - removing a barrier to corporate environments that have strict or have deprecated older versions of JDK in their infrastructure. Japanese Calendar Support Native Japanese era-based (gengō) calendar system support has been added in FileMaker 2026— drop-down date pickers now display and accept dates in the Japanese calendar across all. This is critical to Japanese solutions where there s a legal mandate for governmental and official documents to use era-based dating. Need help to upgrade to FileMaker 2026? At DataTherapy, we specialise in supporting and upgrading legacy FileMaker apps as well as building new custom apps to leverage the latest features of the Claris FileMaker 26 platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. ✅ Certified Claris FileMaker Developers ✅ UK-based team of full-time professionals ✅ Platinum Claris Partner ✅ Experts in secure, on-premise and private cloud deployment of FileMaker 📞 Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
by Ben Fletcher 10 June 2026
The new Claris FileMaker 2026 release includes two highly significant enhancements to business continuity and disaster recovery: FileMaker Standby Server FileMaker Server 2026 can be paired with a second 'hot spare' server which is always ready to become the primary, with failover only taking a few minutes to implement. This means that a hardware failure of the primary server server can be quickly recovered from by promoting the secondary server. Previously, synchronising data between a primary and fail over server would have required additional software adding complexity and cost to a FileMaker Server deployment. FileMaker Server 2026 now includes this service as standard, making it much more economic to implement. The fail over server does not have to be running on the same OS platform or network and so you can run a hybrid on-premises + cloud or split across different cloud data centres or providers for added robustness. FileMaker Server Remote Backup Claris now offer a cloud storage backup service integrated directly with FileMaker Server which can be bolted onto existing FileMaker Server installations (on-premises or running on private cloud). While many private managed hosting providers such as DataTherapy have implemented cloud backups as part of their standard service, FileMaker customers with on-premises infrastructure would often struggle to implement robust backup solutions without dedicated virtualisation teams and additional 3rd party backup software. Again, this provides an economic option for FileMaker customers to consider as part of their disaster recovery strategy. Need help to upgrade to FileMaker 2026? At DataTherapy, we specialise in supporting and upgrading legacy FileMaker apps as well as building new custom apps to leverage the latest features of the Claris FileMaker 2026 platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. ✅ Certified Claris FileMaker Developers ✅ UK-based team of full-time professionals ✅ Platinum Claris Partner ✅ Experts in secure, on-premise and private cloud deployment of FileMaker 📞 Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
by Ben Fletcher 10 June 2026
Upgrade to Claris FileMaker 2026 now! DataTherapy are pleased to announce that Claris FileMaker 2026 managed private cloud hosting packages are immediately available on both Windows and Linux platforms via FileMaker Host . DataTherapy can provide scalable, managed FileMaker packages for businesses of all size. Full details of all of our packages can be found here . Why choose DataTherapy for Claris FileMaker Hosting? Hassle-Free Hosting We handle everything – from setup to ongoing maintenance, so you can focus on your business, not server management. Personalised UK-Based Support Speak to real FileMaker experts, not call centres. All our servers are fully managed by our in-house team. Secure, High Performance Infrastructure Our hosting is fine-tuned for optimal database performance and is hosted on Amazon Web Services (AWS). Our servers are scalable, provide enterprise-grade security, and we handle backups to keep your data safe. No Long-Term Contracts Flexible quarterly billing options with a free 2-week trial for maximum flexibility without long-term commitments. Fully Customised Hosting Tailored for your Business We understand FileMaker inside out. Whether you’re running a small business system or a large enterprise solution we can provide the perfect plan based on your user and performance needs. If you need additional information, or would like to arrange a free trial of any of our packages then please don’t hesitate to contact our team .
by Ben Fletcher 10 June 2026
What is new in FileMaker 26? The Claris FileMaker 26 (version 26 - they have officially skipped versions 23-25 so that the version number aligns with the year of release ) Platform for is now available as of 10th June 2026 and demonstrates Claris’ on-going commitment to embrace transformative technologies. Whether you’re a long-time FileMaker user or just exploring how to modernise your internal systems, this latest release includes expanded AI capabilities including Google Gemini support, major server reliability improvements, and significant accessibility advances. Here’s what you need to know: AI capabilities Google Gemini support: Adds Gemini to FileMaker's growing list of supported AI providers, giving developers greater flexibility when building intelligent applications. Field and table annotations: Attach semantic meaning to fields and tables so AI models have richer context — improving the accuracy of natural language queries and LLM-generated insights. Metadata calculation functions: New functions including BaseTableComment and FieldAnnotation provide programmatic access to schema documentation, making AI-powered solutions easier to build and maintain entirely within FileMaker. Server reliability and infrastructure Automatic crash recovery: The Web Publishing Engine, OData service, and Data API now restart themselves after interruptions — reducing downtime without manual intervention. Multiple SASE processes: Support for multiple Server-Side Script Engine processes improves throughput and responsiveness under heavy workloads. Updated platform compatibility: Full support for macOS 26, Windows Server 2025, OpenSSL 3.5 LTS, and Apache Tomcat 10.1.44+ ensures deployments stay secure and supported in modern IT environments. Accessibility WebDirect improvements: Updated semantic HTML, improved screen reader compatibility, better focus management, and ARIA compliance — a significant step toward WCAG 2.1 compliance. No redesign required: Existing layouts benefit from accessibility improvements automatically, lowering the barrier for partners serving clients with compliance requirements. What benefits doe this bring to new and existing FileMaker customers? Build and deliver faster — A smarter development environment with context-aware tooling and scripting improvements means less time on layout friction and more time building solutions our clients love. Lead with AI — Google Gemini support, field annotations, and native metadata functions give us the tools to build genuinely intelligent apps — without third-party platforms or custom integrations. Reduce client downtime — Automatic service recovery means enterprise deployments keep running even when issues arise. Serve every user — Built-in accessibility improvements help clients meet WCAG 2.1 and Section 508 requirements, opening doors to new government, healthcare, and enterprise customers. Grow with a future-ready platform — Compatibility with the latest operating systems, security standards, and AI providers means the solutions we build today are designed to last. Ready to upgrade your business to FileMaker 26? The new benefits of FileMaker 26 mean you can layer power AI into existing solutions without any major redevelopment work. Support for natural language input allow smarter and more intuitive applications to improve your business decision making. At DataTherapy , we specialise in building custom apps for business using the Claris FileMaker platform. Whether you need training, support, cloud hosting or are ready to go all-in on developing a new app from scratch—we can help. ✅ Certified Claris FileMaker Developers ✅ UK-based team of full-time professionals ✅ Platinum Claris Partner ✅ Experts in secure, on-premise and private cloud deployment of FileMaker 📞 Contact us today for a free consultation and discover how local FileMaker can help your team move faster, work smarter, and stay fully in control of your data.
FileMaker Pro Logo
by Ben Fletcher 1 May 2026
Rosemary Tietge (Claris Community Engagement Manager) was kind enough to invite me to be a panelist on Community Live 45: Level up your FileMaker email game . This was off the back of our past blog post covering this topic . We were also joined by the highly knowledgeable David Sullivan of Mandelbrot LLC .
Claris FileMaker Logo
by Ben Fletcher 25 March 2026
We look at the latest FileMaker 2025 (20.0.6) security fixes.
More posts