Move all addresses over from accounts to contact

[anicolais]

I imported all my accounts expecting that if i imported the account address it would automatically copy to the contact address as well like it does when you manually enter in information. This didn't happen so I am wondering an easy way that I can take all my accounts billing addresses and move them into the contact primary addresses. I have about 4 contacts for every account.

Sugar 5.5
Windows Vista
Thanks!

[eggsurplus]

A simple sql update statement would do the trick. The accounts_contacts table links the accounts to contacts. Use that to create your update statement.

[eggsurplus]

I'm feeling the Christmas spirit here:

For MySQL:

update contacts c
inner join accounts_contacts ac on c.id = ac.contact_id and ac.deleted = 0
inner join accounts a on ac.account_id = a.id and a.deleted = 0
set c.primary_address_street = a.billing_address_street
   ,c.primary_address_city = a.billing_address_city
   ,c.primary_address_state = a.billing_address_state
   ,c.primary_address_postalcode = a.billing_address_postalcode
   ,c.primary_address_country = a.billing_address_country
where c.deleted = 0

Update as needed.

[anicolais]

hahaha thank you very much!!!!!!!

[anicolais]

I am using SQL Server and I have no idea how to convert that into a SQL Server Query. Do you by chance know what the query would look like????

[eggsurplus]

SQL Server version:

update c
set c.primary_address_street = a.billing_address_street
   ,c.primary_address_city = a.billing_address_city
   ,c.primary_address_state = a.billing_address_state
   ,c.primary_address_postalcode = a.billing_address_postalcode
   ,c.primary_address_country = a.billing_address_country
from contacts c
inner join accounts_contacts ac on c.id = ac.contact_id and ac.deleted = 0
inner join accounts a on ac.account_id = a.id and a.deleted = 0
where c.deleted = 0

[anicolais]

Thanks really appreciate it!