Author Topic: Switching primary location from home to work (Read 941 times)

wftl · May 14, 2008, 06:12:51 pm

Hello everyone,

We added several hundred contacts before noticing that the primary location for those contacts should have been work instead of home. Is there an easy way to change primary location from home to work? If so, how?

Thanks,

-- Marcel

Yashodha Chaku · May 15, 2008, 11:18:16 pm

IMO,there is no provision through UI.
However, you you can use the MySQL to achieve the same :

UPDATE `civicrm_address`
SET `location_type_id` = 2
WHERE `location_type_id` = 1
AND `is_primary` = 1

And the same query should be applied for civicrm_email, civicrm_im, civicrm_phone.

HTH
-Yashodha

CiviCRM Community Forums (archive)

News:

Author Topic: Switching primary location from home to work (Read 941 times)

wftl

Switching primary location from home to work

Yashodha Chaku

Re: Switching primary location from home to work