Error when importing from table

  • 0
  • 1
  • Question
  • Updated 1 year ago
Background: We have two separate qb applications -- one which is used as an internal database and the other which is used as an external, open to everyone, application-submission portal. External parties complete an application-form in the application-submission portal and that information then has to be imported into our internal database. I have an "import from table" set up to pull the submitted information from the application-submission side into the internal database. I have set up everything including the appropriate merge key in both applications.

Problem: When I click import on the receiving side, I get an error saying that my field "Organization name" has duplicate values (and the duplicate values are ALL of the records I am trying to import). The organization name field must be unique, so I'm not sure why I'm getting the duplicate values error. How can I fix this?
Photo of Cheryl Lee

Cheryl Lee

  • 70 Points

Posted 1 year ago

  • 0
  • 1

Be the first to post a reply!