Pushing time-delayed updates to mysql

[N Allegro]

Hello! I'm posting here after not having any luck on the FilemakerToday forums... hope to get some guidance from the community!

I'm new to FileMaker but familiar with mysql and need some help bridging these two worlds. We want to push some of our data from FM to an external mysql db on a schedule we choose.

Here's the setup:

* large, sophisticated in-house FM system managing our inventory, contacts, etc

* new mysql database on a remote web server, connected via ESS

My main question right now is how to update product prices on our mysql-powered web page. Updating fields manually via ESS is obvious, but for our workflow we need to be able to push updates out as a batch, typically at the end of the day. This could be on the order of 100 - 5000 records with just a couple fields to update. In the future we'll need to read from mysql, but for now I need to do a simple push.

Where would I start in writing a script for this?

I'm just getting my feet wet here but eager to learn -- any refs to good tutorials, etc would be welcomed! Thanks so much for any help.

Nathan

[Josh Ormond]

Hmmm. Surprised you didn't get an answer over there.

Anyway...

1. I would create a field to set when a record was last uploaded to the web server.

2. Then run a find to get all the records that have a modification date after the last upload. (You may use a simple calc field to identify them if you want)

3. Go to a layout that based on the ESS table. Show all Records.

4. Import the records from the FM table to the ESS table.

[Lee Smith]

Hmmm. Surprised you didn't get an answer over there.

.

Probably because it was down. Link

[Josh Ormond]

It was down this weekend. (It's back up now)

But this post was from the beginning of March.

[Lee Smith]

I missed the OP's original post date.

Since the OP hasn't been back since the 9th, perhaps they did received help on the other list.