CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
I've got about 80 records in my database for contacts who all work for an important organisation that we liaise with. They've just changed their email domain, but all of the front part of their email addresses don't change, e.g. bob@old-domain.org is now bob@new-domain.org.
What's the simplest way to update all 80 addresses in CiviCRM?
Run a sql query on mysql table
UPDATE civicrm_email
SET email = REPLACE(email, '@old-domain.org', '@new-domain.org')
WHERE email LIKE '%@old-domain.org';
You can do a contact search for contacts with that email adress ending, and then bulk update with profile. And then manually copy/paste the correct ending on all 80 emails, before saving.
It takes more time than the SQL, but on the other hand you do it in the UI and have full control of the result without having to do extensive testing (which you should do when using SQL-commands pasted from online)
You could export the above 80 with their Contact ID, then do a find/replace in a s/sheet, then reimport them using 'update' and match on Contact ID
(hmm having written this i now wonder if it would overwrite the existing email address or just add another one. will leave this here for now but delete if someone points out i am wrong)
As Alan says below "Using civicrm.org/extensions/api-csv-import-gui [you can work] directly with the email entities"
