Author Topic: Best way to mass-update email domains? (Read 446 times)

daveatkins · January 03, 2013, 08:23:44 am

Several times now, we have had situations where an organization changes its domain name. I need to change all the email addresses to fit the new domain name; e.g. "dave@example.com" is now "dave@example.gov"

also, many of these users have linked Drupal accounts. probably the same kind of update needed there.

sounds like a direct database update query or two but I HATE the risk factor of messing around like that. If that is the only or best way, can someone post an example of exact syntax?

jclemo · January 03, 2013, 02:34:46 pm

Hi Dave
Can't give you the syntax but a different approach that may work and avoids messing with the database directly...

1) perform an advanced search for the email domain %@olddomain.com
2) export these results
3) Modify domains
4) import the edited csv using the duplicate checking feature and update record option

Not sure how this would work for the drupal user side but just an approach to think about hope it helps

CiviCRM Community Forums (archive)

News:

Author Topic: Best way to mass-update email domains? (Read 446 times)

daveatkins

Best way to mass-update email domains?

jclemo

Re: Best way to mass-update email domains?