My company is going to be rolling out a tool from our corporate parent that is based on FileMaker 6 (argh!). This tool will handle things like P.O.'s, employee timekeeping, etc. I'm looking for a way to extract certain bits of data from this FileMaker 6 solution so that the data can be used in a variety of other apps. Right now, I'm just looking to pull a list of job numbers along with a few other fields (client name, date job was created, date closed). Ideally, I'd like to set something up that can pull this information on a regular schedule, say hourly. This data would be stored in either a MySQL or a FileMaker 9 database, so that it can be used more easily across other applications.

Does anyone have any suggestions, or maybe some references where I can find some information on how to go about doing this?

Thanks!

You can only extract data from this tool using FM6. Otherwise the "tool" must use the export records facility to output the data into more common file types. CSV, TAB delimited, Excel etc. There is no SQL or FM9 option.