How do I make make Home fields Primary?

[jenred]

For some reason when I created a profile I managed to use home address fields instead of primary.

Also, shouldn't the default behavior be if only 1 record = primary?

How do I make these fields primary so they are picked up by the pre-set searches and more.

Thanks,
Jen

[Dave Greenberg]

Try setting the "Home" location type to be the default location type under Administer CiviCRM >> Option Lists >> Location Types.

Going forward (for 2.3) we are planning on simplifying the address model a bit - and will make sure that if a contact only has one address (or email or phone) that it will be considered primary w/o any other steps needed.

[jenred]

Alas, home is already set to default.  I'll try and narrow things done further.

Thanks,
Jen

[jenred]

It looks like since these were contacts coming in via CiviEvent registration their primary contact is set as "billing."

Any ideas on how to:

1) Change this behavior in civievent

2) Mass update all the existing contacts to make their primary contact "home."

I'm open to a mass update at the DB level...

Thanks,
Jen

[jenred]

And to make this issue even more fun!

The primary email addresses are recorded as "billing" therefore if  I switch the individual records to home as their primary record, I lose the email information in the preset searches, unless I copy the billing email into the home email field.

Anyway to mass duplicate billing data to home and home data to billing?

Thanks,
Jen

[jenred]

Ok here is the sql I used to update the records in case anyone else runs into this problem:

Code: [Select]

mysql> update civicrm_address set is_primary = false where location_type_id = 5;
mysql> update civicrm_address set is_primary = true where location_type_id = 1;