Accounts to Contacts

[slamp]

Hi I have imported successfully from a csv file into Contacts. The issue I have now is that in the Accounts that SugarCRM created, it does not have the address that the Contacts have. How do I copy from Contacts to Accounts? I see a button Copy for Accounts to Contacts but not vice versa. Is there an SQL query I can run to automate this? Please help, we have alot of accounts!

[andopes]

Hi, slamp

Are you sure all contacts related to the same account has the same address information?

I don´t know how to do this in sql scripts, but I can help you in php.

Let me know if you need help.

Best regards.

[malcolmh]

Hi,

Maybe too late, but the way we do it is as follows:

1. Take the Contact CSV file, copy it then take out all the duplicates Accounts.
2: Import this new file into Accounts
3. Import the original file into Contacts

Hope this helps

[slamp]

thanks for all the replies. i was able to create a php script that did what we wanted. if anyone is interested here is the code.

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$dbname = 'sugarcrm_database';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

mysql_select_db($dbname);

$query  = "select a.id, c.primary_address_street, c.primary_address_city, c.primary_address_state, c.primary_address_postalcode from accounts as a, contacts as c, accounts_contacts as ac where a.id = ac.account_id and c.id = ac.contact_id";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
        if (isset($row['primary_address_street'])) {
                $update = "update accounts set billing_address_street = '$row[primary_address_street]',
                                billing_address_city = '$row[primary_address_city]',
                                billing_address_state = '$row[primary_address_state]',
                                billing_address_postalcode = '$row[primary_address_postalcode]'
                                where id = '$row[id]'";
                mysql_query($update) or die('Error, query failed');
        }
        else {
                echo "row is empty\n";
        }
}

mysql_close($conn);
?>

[aram]

When we update info in an Account, such as address it does not also get updated in the related Contacts.
I realize this may not be something that would make sense all the time
.
However, is there a method to give a choice to update Contact info with Account address updates
(like a button "Update all Related Contact info too?"

We find that most all of our Contacts (over 60,000) have the sane address as the Account they are related to, but we have to manually update the address in each Contact when updating the Account.

Aram

[sqpc]

Aram, that would save time. If you come up with solution please post it.