I have a script that runs twice a day on our FileMaker Server and the last step is to import records into a history table. This history table is in the same database that I'm importing from.
Problem is, it runs through everything else just fine and processes the data properly, but it will not run these import functions. However, if I run the script manually on my PC, it imports them correctly.
My import functions are being run without dialog. I am going to the target table and showing all records before I import. The import is set to "Update Matching Records in Found Set" and should add remaining data as new. There are records that should have processed this morning. I looked in my history table after everything ran and none of the records were written to the history table - neither as an update to an existing record, nor as a new record.
Anybody have this happen before and what you did to solve it?