Jump to content

FM5 MySQL Sync


mikotondria
 Share

This topic is 5773 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Halloo..

A client of ours has an FM5 database, and we have recently constructed a php/mysql order collection set up on another box.

Now of course, they want to have the 2 db's synced together daily..

I have been investigating using XML import/export with FM8.5, but then learned that the client has only fm5, and I do not currently have access to that system..

So, I was just wondering about which topics I need to learn to allow me to build an import/export syncing system..

I intend to run php scripts to dump the day's orders/processing into a ? csv/xml/?? file, which I will then either remotely point the FM to, or upload/import somehow..

whilst...

The other way, I feel moderately competent to write a script to export that day's FM orders to a file, that I can then parse with php and update the mySQL db..

Any broad or specific pointers/middleware anyone can point me to would be gratefully received :)

Thanks, all !

Mike.

Link to comment
Share on other sites

This topic is 5773 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.