Both methods have their drawbacks, but they do allow for deployment on the FileMaker platform.
You must account for them in this scripting process by using the “Set Next Serial Value” script step in each table. If the solution uses sequential primary key fields, maintaining and updating those sequences is crucial. This process works well in a custom development solution with a single FileMaker file and is generally easy to understand. It involves writing a script using the “Delete All Records” and “Import Records” script steps in FileMaker for each table. However, this turns into a slow process with large data sets and indexed fields. With an import script, you can automate a data migration process. You can easily miss steps or perform them out of order, causing problems after deployment. This is a linear, time-consuming process.
When new fields, value lists, tables or table occurrences are created, you need to update the data file in some cases. When ready to deploy, you simply replace the UI file in production with some caveats. However, with repetition and experience, you can overcome them to build vertical market solutions in FileMaker. With data and UI files, you may find challenges with adding new tables or fields as FileMaker doesn’t truly support a separation model at this level. You could split a solution into a data and a UI file or write a FileMaker script to import data from the live production file. Traditionally, you could deploy a new version of a FileMaker file using a few different methods. This approach also provides developers with an easy way to deploy their solutions. They have allowed version control services such as GitHub to flourish. These formats make it easy to compare one version of a file to another. Most programmers work in text editors and with specific file formats such as. As programming languages evolved and the world wide web became the dominant platform, open programming languages have thrived. Your ability to locate data within BaseElements is unlimited.Since FileMaker’s inception, it has been a binary file with its own proprietary format. And you can put up new windows, or perform normal FileMaker finds at any time. Using the shift key you can do a Go To Related using the current found set, so you can from a list of fields to all of the layouts those fields are on, or go from a list of scripts to all of the fields used in those scripts. Using the option key you can open any link in a new window, so you can retain your current found set and open a new one. BaseElements can become your storage point for a whole library of functions to reuse within your other files. You can copy Custom Functions, Scripts, Script Steps, Tables and Fields directly from any solution you have in BaseElements and paste back into your open FileMaker solution.
Plus we highlight your find criteria within calculations and scripts to make locating the results quick and easy.Ĭopying your old solution data out of BaseElements into FileMaker Your BaseElements files can be made available on FileMaker Server for sharing amongst multiple users with ease.īuilt in use of the excellent fmSearchResults to allow you to search for specific text across your entire solution, and link directly to the results. That, coupled with years of iteration and improvement to our XSLT means we import faster than any other solution available. We’ve built our own custom plugin that we use to take advantage of the fact that FileMaker imports CSV files faster than any other file type. BaseElements will import any DDR from versions all the way back to 7.
We’re always on top of new releases of FileMaker Pro and quite often have an update out the same day as new versions of FileMaker are made available.
By using a Custom Privilege model we’ve made this transparent and fast.Ĭonstantly updated for the latest versions of FileMaker Pro
You can link directly from any one item to another other with a single click.Ī single checkbox to allow searching within a single Analysis, or off to allow searching across multiple versions over time. We highlight active or inactive tabs so you’re not hunting and pecking for related information. Using a clean layout structure and efficient use of space, everything in BaseElements is easy to access and simple to find. And an early warning system to locate common pitfalls before they become problems.Įvery Field, every layout, every variable = everything in your FileMaker Solution is cross referenced and linked and it’s quick and easy to see exactly where everything is used, and what all the dependencies are. A comprehensive Unreferenced system that even understands Indirection. Complete error checking and simple discovery via text highlighting and smart tabs.