FileMaker2MySQL via XSLT

[cjaeger]

The following stysheet allows to insert FileMaker data into mysql. It creates the

apropriate data structure from FileMaker METADATA and the INSERT statements.

It does not, however, create the database itself, nor does it support container fields.

Of course, you have to be careful to avoid special characters in your field names

(no spaces, ".", ";", ",", "@" etc. allowed).

USAGE: on the mysql pc, execute

mysql databasename [-u<user[@host]>] [-p<password>] < output.sql

If you want to keep your existing table, comment out the "DROP TABLE" and CREATE TABLE

statements. This XSLT converts dates in M/d/yyyy (US) and d.M.yyyy (European) formats to

mysql internal date format. It is also implied that dateformat M/d/yyyy uses

US decimal separator "." and European dateformat uses ",". You may change that according

to your local date and number formats.

Enjoy.

mysql_create.xsl.zip