CiviCRM Community Forums (archive)

i dont think import supports the "uses household address" concept as yet.

lobo

I suspect we will need to tackle this when we do import restructuring and optimization. This is  a fairly large project. The import code today is fairly gnarly

lobo

Sarah - I have fairly high on my agenda to see if I can do this using civimigrate so I'll let you know.

I am still trying to tackle this for contacts which were previously imported. ( Using the browser-based "Contacts-> Import Contacts" tool ). Any suggestions?

I can write a script that pulls the household id for each contact. The missing piece is how to update the individual contact record correctly.

My script correctly updates the "uses household address" flag , which I can verify when I check the individual in the GUI, however it does not display the household address in the "address" area of the individual. 

Here is my code:
$loc_params = array('version'    => '3.0',
                        'contact_id' => $hhid   
                        );
     
        $hhLocation =& civicrm_location_get($loc_params);
 
 print "<br> hh location id: <br>";
 
 $hh_loc_id = $hhLocation['address'][1]['id']; 

$params = array(
                    'contact_id'    => $cid,
                    'contact_type'    => 'Individual',
                    'location_id' =>  $hh_loc_id ,
                    'mail_to_household_id'      => $hhid);

    $contact =&civicrm_contact_update( $params );

-------------------------------

Note: both the individual contact and the household contact exist before I run my script.

I updated my code  to retrieve the household location, then create a new location based on that. Then finally update the individual contact with the location id as part of  the param list. Still no luck:

print "<hr><br>contact id: $cid  household id:  hhid: $hhid  <br>";
 
 
 $loc_params = array('version'    => '3.0',
                        'contact_id' => $hhid   
                        );
     
        $hhLocation =& civicrm_location_get($loc_params);
        if( civicrm_error( $newLocation ) ) {
            echo 'Error occured while getting hh Location';
        } else {
            echo '<br>Got Location:';
            print_r( $hhLocation );
            echo "<br>";
        }
 
 
 //print "<br> hh location id: <br>";
 
 $tmp_address = $hhLocation['address'][1];
 echo "<br>tmp_address: ";
 print_r($tmp_address);
 
 $params = array('version'    => '3.0',
                        'contact_id' => $cid,
                        'address'    => $tmp_address
                        );
     
        $newLocation =& civicrm_location_add($params);
        if( civicrm_error( $newLocation ) ) {
            echo 'Error occured while creating Location';
        } else {
            echo '<br>Location Created:';
            print_r( $newLocation );
            echo "<br>";
        }
 
 $hh_loc_id = $hhLocation['address'][1]['id']; 
 //print "$hh_loc_id ";
 //print "<hr>";
 
 
 $params = array(
                    'contact_id'    => $cid,
                    'contact_type'    => 'Individual',
                    'location_id' =>  $hh_loc_id ,
                    'mail_to_household_id'      => $hhid);
    $contact =&civicrm_contact_update( $params );
    print_r($contact);