Scripted Import Limitations

In lots of areas of FileMaker, especially since version 7 and later we've been able to specify calculations to dynamically determine objects to reference. That isn't the case with the scripted import process.

When you have an import records script step, there are 4 critical items you need to set. These have to be manually chosen in the dialog, and can't be varied via calculation :

• Source TO
• Destination TO
• Field Matching Options
• Auto Enter Field Options

What this means is that you must have a unique "Import Records" script step for every Table you want to import. We also have the other limitation that you need to have a layout for the records to import into. Having a layout, means having a TO and that means having a File Reference that points back to the file with the data.

RefreshFM works by having all of the FileReferences/Layouts/TOs in a file that is separate from your solution. So all of the import scripting happens in these "control" files.