Home Forums Import Export PowerTool Record exists error

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Ted JohnstonTed Johnston
      Post count: 6

      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?

      Ted JohnstonTed Johnston
        Post count: 6

        The record exists error occurs when you have two fields in your import with the same name. Double check your field names.

      Viewing 2 posts - 1 through 2 (of 2 total)
      • You must be logged in to reply to this topic.