0

My client's outside database has changed. I have spent a few hours (fun!) matching the old and new external IDs and the internal CiviCRM contact ID as well. Not every record in the CiviCRM database has or will have an external ID.

I will probably need to do an update using SQL (mySQL/phpmySQL), but I'm a little uncertain that that's the best way and I don't want to break the entire database!

The current data is in Excel: CiviCRM ID, New ExternalID, old ExternalID.

Improve this question
3
  • 4
    does doing a Contact import just of Civi ID, and new External ID, not work? using a matching rule based on civi id
    – petednz - fuzion ♦
    Commented Nov 24, 2021 at 1:07
  • Thank you. You were correct and it was easy. For some reason I thought I ran into problems in the past. (Must choose "update" of course.) I limited the import to these two fields.
    – TimETown
    Commented Dec 7, 2021 at 17:23
  • cool. added as an Answer, pls Accept
    – petednz - fuzion ♦
    Commented Dec 9, 2021 at 3:46

1 Answer 1

Reset to default
1

Try doing a Contact import just of Civi ID, and new External ID, and set it to Update using a matching rule based on civi id.

Improve this answer

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.