Home › Forums › Import Export PowerTool › Record exists error
First try of this tool- Importing from NAV to BC.
Copied Campaign table out to Excel. Saved as CSV. Error on import as it doesn’t like CSV. Something for the documentation? Specify tab delimited.
Changed to tab delimited. First record errors with a key violation. There are no records in the table in BC.
Set “Do Two-Step Insert” to No and the import worked.
Deleted the data using the tool- cool!
Set Do Two-Step Insert to True AND Allow Record Updates to True and the import ran. Perhaps a check in code that if Two-Step is set, make sure Allow Record Updates is set?
The record exists error occurs when you have two fields in your import with the same name. Double check your field names.