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". ...

FMDump for FileMaker is getting a helper tool called FMDump Migrator! It helps to import a table into an existing table. Paste in the CREATE RECORD statements, match up columns, or add and match.

When ready it will export MySQL to create columns and PHP to loop and "set fields". Here's a quick demo!

Today on a FileMaker Reddit Post, I was asked what the code looks like. I start with a selected Contact record and starting with index.php, I show an over view of the code path and the code for the Contacts Info Card.

It's interesting to hear similar stories from fellow Developers like on that Reddit Post. FileMaker and Xojo have both, but separately, raised pricing. No official announcements have been made from ...

We've been converting FileMaker databases to Xanadu Web Apps over the past few years. One conversion category is Reports. Reports vary, but there are four types:

• 'Simple' with zero or minimal parameters with a simple query.
• 'Flexible' reporting on ad hoc record sets with a simple query.
• 'Forms' with data placed at specific coordinates.
• 'Customized' with complex formatting, more than one format, or multiple queries.

For most reports, we use mPDF, a popular open-source PHP library for generating PDFs. We'll create a header, footer, and body in HTML using CSS for the styling and applying ...