I am trying to import multiple files into Filemaker 13 from Excel. There are 7 file types - each has its own structure. There is a script for each file (so seven scripts). Each script does essentially the same thing - import the data from the file into the same table. So my files are called Transact, Novia, Raymond James, Other etc. The excel files are called Transact.xlsx, Novia.xlsx, Raymond James.xlsx, Other.xlsx.
If I run the Transact script once, then this works fine.
If I then run the Novia script, I find have to reset the field mapping for this file before re-running - otherwise the data is imported into the wrong columns.
Filemaker does not seem to remember the mappings of the individual files. Can anybody see why ? Thanks
This should work as you expect it to.
I'd double check your "Specify Import Order" for each script you have to confirm it is doing what you really want it to do. Your import order, and the fields the data is being imported into, could be wrong - especially if you duplicated your original script multiple times without changing the import order for the duplicated scripts.
Thanks. I remembered that you had to "Hardcode" the file initially and then delete this. It now works.