Error while importing: duplicates in non-id field are rejected

I have a test csv with a few records:

The unique id is RelID (so NOT FamID):

The Data Importer throws an error, stating that there already is a node with FamID "T9":

and as a consequence, nothing is imported:

Schermafbeelding 2023-09-10 144746

Does anyone know what is going wrong here?
Thanks.

Does you database have a unique constraint defined for Label Family and property FamID? Execute 'show constraints' in the browser and look for one.

I created that scenario in a test database and got that error during import. Nothing was changed because I assume the error rolled back the transaction, so nothing was persisted.

1 Like

Hi @glilienfield ,

Thanks again for your help.
It turned out to be a constraint indeed.

Guido

P.S. there is now definite proof that I'm writing code while sleepwalking: I did know about the existence of constraints, but never used them. I didn't even know the syntax... :smile: