This is not exactly what you are asking, but it may help.
I have a server-side-script which needs to do a similar function (in this case, copy records from a MySQL table using ODBC to a local filemaker table).
However, this is running on the server under FMSA11, it turns out you can't do direct imports/exports.
I found an easy work around:
* export from the SQL table to a text file
* import from the text file
I used a CSV format (aka "Merge" format) and it seems to work fine.
Although this is not what you are asking, I wonder if it may solve your problem (or at least give you some more debugging info?) Try exporting to a temporary file and import from there?
Hi, I made a system the loops thru the fields and set them. It works very well and you can have to sync records every minute
The tables to be imported are FM11 Pro tables on local computers. I know how to export data from FM11 though I have never done it through a script...but that's just detail that I can work out.
The biggest block I have right now is figuring out how to do an import of the text file from the local machine to MySQL. I am assuming there is a PHP command or some such that accomplishes the task?
I have considered just such a possibility, but if there is a simpler way, I would prefer choosing it.