I have a script that looks to see if a table is empty, and if so, it will import (add new records), and if the table is not empty, then it imports (update matching records in found set/add remaining data as new records). When run and the tables are empty, the data map should show all matching fields to be imported except the “Record Date” field (See Attached Documentation). It doesn’t. It shows up with dashes instead of arrows and the data does not import. This happens in both instances on line 55 and on line 65 of the script.
See attached PDF with screen shots.
These were working fine until I added the second half of the if statement (Else) with the Update matching records in found set import
records command. I have tried to delete the import commands and recreate them and I get the same results. Any ideas?