I'm updating the CiviCRM database with a list of individual records. All these individuals exist already in the database, but I need to create the link with existing organisations. I've already done that for other imports and I use the relationship "Employee of" -> "Organisation Name (match to contact)" to do the relationship between the individual and its organisation. When trying to import, I receive a message telling me that all my records have "mismatched contact IDs" and that no record has been updated. Any idea ? Thank you

More information on this : I have tested with a single record "Patrick Test" on the demo database - https://dmaster.demo.civicrm.org/ with the same import scheme and all went well. I make the same with one record on my CiviCRM and I receive an error. I really do not know what to do now...

The exact error message for this one record test is : Total Rows 1 Total number of rows in the imported data. Mismatched Rows (skipped) 1 Rows with mismatched contact IDs... (NOT updated). < » Download Mismatched Contacts Total Contacts 0 Total number of contact records created or modified during the import. The generated csv error file tells me that "Related contact required fields are missing." Which fields ? I really dont know...

Many thanks for you help

  • 1
    in the column that is your Org ID do you have any blanks? if so perhaps the warning is 'you had a row where you said to create a related org but you didn't give me an ID for that row'
    – petednz - fuzion
    May 25, 2020 at 18:47
  • Yes right Pete and thank you. A "blank" relationship gives this result, even if the contact is correctly imported
    – Patrick
    May 25, 2020 at 20:06
  • cool. i added as an answer if you want to Accept and/or +1
    – petednz - fuzion
    May 26, 2020 at 7:46

2 Answers 2


If the column that is your Org ID has any blanks you will get this warning. It doesn't mean anything failed in the import. It is basically saying 'you had a row where you said to create a related org but you didn't give me an ID for that row so i am just letting you know'


Apart the right answer of Pete (thanks) here above, I have found something else who explain the problem I have : I had two relationships in my import scheme: the one for the "Member of" relation and the second for the "Employee of" relation. This cannot work... and I need to make two separate imports for each relation.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.