Synching 3 Databases (MYSQL, Filemaker, Hard Copy)

[LLX]

Our company is a bit disorganized in our filing system. See we're transitioning from previous dbs to one doen via file maker. We have authoirze.it as our ordering gate way and it stores soem info, we have a php/mysql (that passes to authoize.net) for online ordering. And we have our file maker files. I was hoping to get a heads up on wherei shoud look to get me started on intergrating File maker (which we use to manually add over phone, and more "personal" subcriptions) with our automated php system.

[Tim W]

Hi,

Are you trying to get data from mysql or some other dbs? or Does the mysql data bypass filemaker and fixing this is your goal?

Need a little more info on your goal and current disorganization status.

Ready to help, I syncronize with SQL daily.

Tim

[LLX]

Well offline we have a filemaker database that is updated manually.

online we have a SQL database which is tied to onlin registration but not to our ofline mailing database in file maker. I want to synch the two

[Tim W]

Gotcha,

The direct real-time connection with SQL is a technology called ADO. This is not currently available in filemaker, but keep your fingers crossed I think it just might be on the plate. Under the current versions, you must execute an SQL statement from a script or do a import through ODBC. Do you have the SQL data source setup on your filemaker computer? If not that is your first step. If so, how much data do you need to pull from SQL at a time? For a large dataset, I suggest a scripted import. For a small one-record-at-a-time dataset, I suggest a field(s) populated by a script using the execute SQL step.

Filemaker has a SQL statment builder which helps if you don't speak SQL.

I currently populate 5 tables at a time via the import script, at will throughout the day. 2500 - 3000 records over a network connection. Takes about 1 minute.

HTH

Tim

[LLX]

Can i do the reverse and update the SQL database from a file make source so i cna keep the 2 in sync?

[Tim W]

I cannot see why not. SQL update statement would push data onto the SQL table from an outside source. I don't have any experience with pushing data to SQL, since I sync FM from SQL rather than the other way. My SQL source is an accounting solution with a very sticky rule set. The script step execute SQL, I believe supports all SQL statements, including update.

Maybe someone else has done this but, SQL is not really that difficult. Backup your SQL tables and give her a try.

Tim