I may have discovered the answer to the first problem
According to another developer if the specified Import order is changed filemaker will lose the other dialog settings and they will have to be refereshed
I think this occurred when I added a field to the record and it changed the import order on the script even though all it did was add a non importing calculated field to the end of the record.
This resulted in the Import settings getting dumped and needed to be reset.
The fix for this is to reset it using a temporary data source. So in trying to diagnose the problem I actually fixed it and didn't know it.
I still don't have an answer on the second item because Ive made no changes to the table that is being loaded via the import.
Thank you for your posts.
I'm glad you were able to fix the first issue yourself.
Regarding the second issue, I'll need some additional information.
Is this an .xls or .xlsx Excel file being imported? What options are turned on? That is, are you adding new records? Updating existing records? Don't import first record?
I see the file is being hosted. Do you have full read/write privileges to change the script? Are you able to run the script but other clients are unable to?
Anything else you can provide to help reproduce the problem would be appreciated.
Thanks for looking into this
it is an .xls file Im using Excel 2008 of a Mac Version12.4.2
The only users of the system have full access privileges (only 2-3 of us) and only I edit scripts (I replaced the previous developer)
In this case it was an add new records that was checked.
There are a number of nested scripts from these excel templates
They load into Temporary tables do validation of the data then export records to a new specified xls file then import from that file into the new tables using update and add new options the do not import first row is checked in each case.
The problem was that when selecting the file the first time it was telling me that no fields were selected for import even though there was a specified import order. I didnt change anything about the import order or any options all I did was uncheck the perform without dialog box so as to see what the dialog settings were and things worked like it was supposed to.
It was odd.