Synchronize MySQL on web server w/ FileMaker in-house

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Crashin
Forum Contributor
Posts: 223
Joined: Mon May 06, 2002 3:42 pm
Location: Colorado

Synchronize MySQL on web server w/ FileMaker in-house

Post by Crashin »

Hi all...here's what I'd like to do. We have a form on our website with which users can submit tech support questions. Our in-house support log and call-back system is in FileMaker Pro. What I would like to do is automate the process so when the user fills out the form on the site it will end up in our FM log sheets.

I know ODBC is the beginning to solving my issue, and I am able to connect to my MySQL tables from FM and import my data. My dilema is the automation of the process. Does anyone know FM well enough to give me some tips on how to set up this system so FM will "check" on a cycle for new records? Additionally, I will need to update the MySQL table from FM after importing the records so FM will know the next time which records are new.

Thanks! :D
Post Reply