MySQL - ODBC Two Way

[NetherChris]

Okay, seemingly simple problem, yet no aparent solution to me after hours of searching on the topic, so any help is greatly appreciated

I have a FileMaker 6 database that consists of all computers in the school district I work for, done by one of our assistant principals, along with fields for problems and tickets. Working in the Technology department, I wrote a PHP application to be used for web problem ticketing... teachers and faculty can report problems, it creates a ticket, and then allows for administrators and IT personnel to update the status of that ticket, and even view history per computer by their unique town asset tag.

I can import these tickets into my Filemaker database just using ODBC and the vanilla MySQL driver available from their website, and it works great... can now view history per tag inside of filemaker, and all the fields match up perfectly after a little bit of doctoring. So, I have my ticket program that makes tickets and Filemaker which can manually get those tickets from my MySQL database.

I realize this action can be scripted.. i'd really like to do that at some point.. I have yet to find the time to do so. But that is besides the point.. my true question lies with getting the data out of Filemaker and into MySQL. I would like to be able to update these tickets and computer history, and possibly be able to add additional computers, inside Filemaker, and then export these (preferably over ODBC) to my MySQL database. Nowhere have I found any real useful information on how to do so, and I am almost positive it can be accomplished (possibly using the Execute SQL script step I was reading about?)

Personally having about 3 days of experience with Filemaker (I had nothing to do with the building of the computer database, and I didn't even know about it when writing the PHP app), I'd love for there to be a more simple way to update these tickets with a two way system rather than one. If anybody is aware of something, I would greatly appreciate any input on how to do so. Thanks for your time.

[doughogg]

You might check out

http://www.garrison.com.au/products/fmsql_synch.html

(I have not tried it personally.)

Doug Hogg