CSV import

Started by Mees Dekker, June 17, 2021, 05:39:21 PM

Previous topic - Next topic

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.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

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.
-- Mario
IMatch Developer
Forum Administrator
http://www.photools.com  -  Contact & Support - Follow me on 𝕏 - Like photools.com on Facebook

Mees Dekker

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