FMDump Migrator was able to generate Xanadu PHP code to import data from FileMaker into existing MySQL tables today!
I've migrated tables manually quite few times and wanted to automate for a while. The automation took a bit, but I think I could now migrate a bunch of tables in a day depending on how much it needed massaging. In Step 2 you can see five massages.
It's so easy now. FMDump from FileMaker to MySQL Create/Insert statements. Load the Dump files to MySQL. Then Migrator can use the Create statements to generate the SQL for new columns and PHP to set and massage the data.
I recently was helping a client with a migration and they refused to have a migration process since the import was a "one time thing". It resulted in a hot mess. If they would have just planned and created a process they would have been much happier!
Currently, we are migrating a clients FileMaker database we created in 2008. Like many, they were no longer interested in paying to rent FileMaker. Instead, they will now use a Xanadu Web App written in PHP/MySQL/Bootstrap.
Migrate Steps
Step 1: Paste CREATE TABLE statements from FMDump for the Source and from an existing MySQL table for the Target. Then click the Update Columns button.
Step 2: Columns with Matching Names will have the Source Column set. Below is the end result for the Contacts table. On the Left, the Source Unused and Used Columns are shown. Beyond the Left, the Target Columns are listed and the assigned Source Column. If the Target Column does not exist, it can be created in ColumnNameAdd. Types are Green if they match, pink if they exist and do not match, and purple if the target does not exist.
Massage Rules is the most power part. If data needs massaging, I can optionally call the PHP function messageValue which handles Append or Select. Appends are for appending data together. Selects help with Popup Menus and their value lists.
Step 3: Generate Code! Left side is SQL to generate the new columns. Right side is PHP code generated to move and massage the data using the Massage Rules.
Step 4: Generate Code Collection makes a list of all SQL and PHP code generated. Currently I copy paste the generated code into the SQL and PHP blocks of a PHP page that runs the code.
That's it! FMDump the FileMaker data, the FMDump Migrator to set and massage!