CSV import

[Mees Dekker]

It seems impossible for me to import a csv file. Whatever I try, IMatch always comes back at me with "Import mislukt bij 'Failed to update database. Error 8.'" I ran IMatch as administrator, but even then I got this message.

I'm obviously missing some basic setting, but however I studied the help: nothing came to rescue. What would/could be the problem?

[Mario]

Do you import into metadata or Attributes? How many records in the CSV?
If you import into Attributes, error 8 means "unique constraint". You have set Attributes to must be unique, but your CSV file contains duplicates.
Check which Attributes you have configured that way, and then remove the duplicate values from your CSV file. A unique constraint will terminate and rollback the import.

[Mees Dekker]

I will look into this and give it another try. Will let you know.

But: is there a place where I could have found that "error 8" means a "unique constraint" and what consequences that actually has? Are there any other constraints to take into consideration?

[Mario]

It should be in the log file. I did not bother to add full-text messages for every possible error to this app.
As I said, it usually just works.

[Mees Dekker]

Well, I got it working. There was indeed a duplicate entry. Thanks for the swift reply, as almost: much appreciated.