FileMaker is a powerful beast, and with every major release, just keeps becoming more powerful. In my second internship, I was responsible for figuring out a more efficient way to migrate data, stored inside of FileMaker, to a web application database.

The original “extractor” of the database ran a nightly task of looping through all new data changes for the day via ODBC, and feeding the web database. The process took quite a while, but luckily we had access to a newer version of FileMaker that allowed exporting its data much easier with web/XML publishing. Using the publishing features, I was able to trigger FileMaker to export its own data to XML and use PHP to parse/import all of the data to the web database. This turned out to be much faster, and became part of the succeeding, working model.