Filemaker Pro to Mysql

[khadeo]

Hi,

I got a filemaker database on a CD and I work on Linux OS (Mandrake 8.0).

I need to migrate this database to MySQL and I really don't know how to proceed. How can I access the database on Linux ? And how can I migrate it ?

By advance, thanks for helping me

khadeo

[konjo]

Hello khadeo,

did you got it working yet. Because I have the same sort of problem, but in my case I need to synchronize from Linux(mysql) to winNT(filemaker) and v.v. Could you tell me how you solved it?

Thanx in advance Konjo

[RhoXS]

Hi! I'm very interested in doing the same thing you are attempting to do. I have to support a data driven website that is mysql/php based, but I'm receiving data from a client in Filemaker Pro

I thought it would initially be easy to simply format the data appropriately in FMP, then export as tab-delimited text.

Once in tab-delimited format, one can use mysql's LOAD DATA INFILE feature to bring it into a mysql table.

The HUGE problem at this point is that FMP properly puts tabs between field data in a record but IT DOESN'T PUT A TAB BETWEEN RECORDS!!! - IT PUTS ONLY A HARD RETURN.

I usually have over 20,000 records to import/update each time. I'm going to try to write an Applescript that replaces this hard return with a tab.

let me know if you've had any more success with this.

RhoXS

[BobWeaver]

In tab delimited format, Linux probably expects to see a linefeed between records rather than a return. There should be some text editing utility that you can run the file through to convert returns to linefeeds.