Home › Forums › Import Export PowerTool › Record exists error

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Ted JohnstonTed Johnston
      June 6, 2023 at 12:15 pm
      Post count: 5
      #9574

      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
        June 26, 2023 at 7:43 am
        Post count: 5
        #9686

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

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