xml export to mySQL

[Michael Pazurik]

I have several thousand records in my FM db which are created from "cut and paste" methods in various fonts and sizes. I am looking for a style sheet which converts my data as formed (and added to each day) for xml EXPORT to replace "bad characters" then be read by server which has SQL (windows) environment. The "bad characters" are four; the apostrophe, the start quote (NOT using smart quotes), the end quote and the smart quote (both start and end are same). I am told it will take only two lines added to a stylesheet. Interested in finding developer who sells that stylesheet but prefer I test it first to see if it works.

[cjaeger]

Hi Michael,

since my FM2MySQL styleshhet is open source & totally free, I gather you change it yourself.

No need to pay for it. You can use the stylesheet unaltered if you use a Filemaker calculation Substitute(Substitute(field,""","""")"'","') ( escape all the other illigal characters with a as well).

Or you can use the attached improved FM2MySQL Stylesheet.

FMP2Mysql_new.txt