christopherc

Scripts for exporting and exporting data

Discussion created by christopherc on Apr 12, 2012
Latest reply on Apr 17, 2012 by Stephen Huston

I am trying to write a script that would export all data in each table in a Filemaker file to import into a clone of the file. I am exporting to a separate .fp7 file for each table. I am using the 'go to layout' and 'show all records' script steps, followed by the 'export records' step. I have enabled the 'specify output file' and 'specify export order' options. When I run the script, the 'specify field order' defaults to 'current layout'. How do I setup the script so that the default is 'current table'?

 

As for the import side of things, the option will always be to 'add new records' since I am importing into a clone, which Filemaker defaults to since each table is empty. How do I get the import step to default to arrange by matching names? It defaults to 'last order'. I want to be able to run both scripts without dialog since there are a number of tables that I need to export and import.

 

Thanks,

Christopher

Outcomes