Export - Import Summary Data

[Dennis Jones]

Daily I import and parse a report from a mainframe computer. In FileMaker, prior to the import, both the FMP table containing the raw imported data (~~ 70k records) and the FMP table containing the parsed data (~~ 7K records) are emptied (select all, delete all).

After importing and parsing the data, I need to post a summary of the information to a third table where a summary history of the parsed data is maintained.

Presently I export a summary .mer file (~~70 records) which I then import back into FileMaker in the Summary table. This process is scripted, but the user still needs to name the export file and make sure it is a .mer file. This works fine except it requires a fair amount of user intervention.

The FMP File resides on a FMS 8.5 Server.

Is there a way to take the data in the parsed data table, summarize it, then move the summary information into the summary table without user intervention.

Regards,

Dennis

[email protected]

[bcooney]

Since you rate your skill level as Advanced, I am assuming that you've explored scripting the export step with a hard-coded path is not an option? Why not?

Is a looping script instead of an import/export feasible?