Total newbie question

[merkaba22]

I have project to upgrade from 5.5 to 7 including FM Server 7. I think that will be fairly easy but wonder if there are any specific issues I should know about before taking this on?

Maybe more importantly, I need to get info created on our website in MYSQL during a registration process to dynamically cooperate with FM; ie., is there a way to automate FM such that when the info is entered on the website it will be entered into the "Customer" DB?

Also, out there in dream land, is there a way to get the data created in MAS 90 to cooperate with FM 7?

Is there other information needed to answer these question? Are there scripts or plugings, etc.?

[Garry Claridge]

You could either "push" or "pull" the new customer to the FM database.

If you "pull" then you would have to be constantly polling the MySQL database looking for new customer entries. This can be done with AppleScript or other scripting programes on OS X.

If you "push" from the MySQL database you may be able to use some scripting to accept the data and update FM. (Alternatively, you could look at the POPit plugin for receiving Forms as an email into FM.)

Good Luck.

Garry

[Steve T.]

Hi, m! I'd probably "push" as Garry recommends and do a 1/day synchronization or something. But I was wondering... are you using PHP with your MySQL web registration form? If so, maybe data submitted by users to a PHP processing page can be near-simultaneously submitted to both the MySQL db and a FileMaker db in a single script. You'd probably have to verify synchronization between db's from time to time to make sure they have identical data, but a double-write may be worth exploring. You would either need FM7SA or something like cafePHP, but I think it would work even though I haven't used PHP with FM yet.

Or for that matter, if you don't really need the MySQL part specifically, you could just go directly with PHP/FM solutions.

--ST