Exporting file for import into MySQL database

[jasonwood]

I have a developer working on a shopping cart for me using MySQL and PHP.

I would like to be able to upload the price list but he's a windows guy and he's not sure how to deal with the Mac carriage returns without some major find & replace scripting.

I've been saving as a tab-delimeted text file, but when I upload it comes up with pages of errors, the first of which says that there are too many columns in line 1 (which is not correct), so I assume it just skips over the mac carriage returns.

Because I don't really understand the problem, it's hard to explain it any more than that... any help much appreciated!

[cjaeger]

Could you identify if the problem is the filemaker record delimiter (CR, Mac/CRLF, WIn) or the FileMaker character (return within a field?)

The easiest way to export in another character set + adding platform-specific record/field delimiters is via XML export. There is a sample at www.filemaker.com/xslt_library to accomplish this task, (custom delimiters).

You could also use calculations to export the complete sql INSERT command, or do the same with XSL.

http://www.clark-ip.com/docs/FMP_to_mySQL_OSX.html

[cjaeger]

Hi Jason.

just posted an XSL in Sample files. It writes out the create & insert into table statements for command line.

One could easily make same with calculated fields only, but that doesn't translate between Mac/Win/Unix charsets & linefeeds.

[jasonwood]

Yeah it was the record delimiter... My developer managed to write a little script for 20 that does a find/replace when I upload the new price list, so I'm all set for now.

That link may come in handy in the future as I tighten the integration between my FileMaker database and MySQL-based shopping cart. Thanks for pointing that out.