Update (mass) Account Addresses to Contacts

[bilguun.m]

I am about to start on a mailing campaign and just discovered some problems with my database. Many of my contacts are missing the address information of the Accounts they are under. I know that SugarCRM has the "copy" button to copy individual Account address details to Contacts. But is there a way of doing this for a large number of records in Sugar? Or do I need to run an SQL query to import Addresses from Accounts to relevant Contacts?

[vasi2me]

Hi bilguun,

You can try this,

update contacts c, accounts a, accounts_contacts ac
set c.primary_address_city = a.billing_address_city
where a.id = ac.account_id and ac.contact_id = c.id and (c.primary_address_city = '' OR c.primary_address_city is null)

update contacts c, accounts a, accounts_contacts ac
set c.primary_address_state = a.billing_address_state
where a.id = ac.account_id and ac.contact_id = c.id and (c.primary_address_state = '' OR c.primary_address_state is null)

update contacts c, accounts a, accounts_contacts ac
set c.primary_address_country = a.billing_address_country
where a.id = ac.account_id and ac.contact_id = c.id and (c.primary_address_country = '' OR c.primary_address_country is null)

update contacts c, accounts a, accounts_contacts ac
set c.primary_address_postalcode = a.billing_address_postalcode
where a.id = ac.account_id and ac.contact_id = c.id and (c.primary_address_postalcode = '' OR c.primary_address_postalcode is null)

I know tis is a dirty way of doing things but should server the purpose.

Please use it at your own risk.

Thanks
Vasi.