Author Topic: How do I link an individual to a household in the API? (Read 3083 times)

twowheeler · February 28, 2008, 03:44:50 am

If I add/edit an individual contact, I can select "Use household address" and then choose to create a new household or link to an existing household. How do I do that in the API? Any suggestions appreciated.

Kurund Jalmi · February 28, 2008, 05:31:09 am

Currently you cannot do this using api. You will have to manually first create household, then create Individual and then add address to it.

kurund

twowheeler · February 28, 2008, 05:16:40 pm

Ok thanks, but I'm not sure what that means. I can create the household and create the individual, no problem. Is adding the address to the individual just a matter of writing the household_id into the mail_to_household_id field in civicrm_individual? Do I have to create a relationship?

Kurund Jalmi · February 28, 2008, 05:42:43 pm

Quote

Is adding the address to the individual just a matter of writing the household_id into the mail_to_household_id field in civicrm_individual?

Yes, that's the first step. Then you need to create new location for Individual with same details as in Household location.

Quote

Do I have to create a relationship?

Yes

You might want to check following functions in CRM/Contact/Form/Individual.php
createSharedHousehold()
handleSharedRelation();
copyHouseholdAddress();

HTH

kurund

twowheeler · February 28, 2008, 05:57:53 pm

Eeek. I'll give it a go.

twowheeler · March 04, 2008, 04:53:33 am

Well, I'm part of the way there. I can create a new household with

Code: [Select]

CRM_Contact_Form_Individual::createSharedHousehold( $params );and then create the relationships with

Code: [Select]

CRM_Contact_Form_Individual::handleSharedRelation( $pid, $params );
I am setting these variables,

Code: [Select]

$params['mail_to_household_id'] = $hhold_id;
$params['use_household_address'] = 1;
$params['contact_type'] = 'Household';
$params['create_household'] = $family. " Household";  // like "Jones Household"

I also figured out that I have to fill out an array like $params['location']['1']['address']
to hold the street address variables.

Yet I can't get it to actually link the household address to the individual record.
The 'use_household_address' should be doing that. The command,

Code: [Select]

CRM_Contact_Form_Individual::copyHouseholdAddress( $params );doesn't seem to actually do anything. It does not return any errors either.

So obviously I am missing something. I'd be grateful for any additional pointers.
Thanks guys!

Kurund Jalmi · March 05, 2008, 02:56:49 am

Can you check "mail_to_household_id" field for Individual record in civicrm_contact. It should have Household id that you created.

HTH

kurund

CiviCRM Community Forums (archive)

News:

Author Topic: How do I link an individual to a household in the API? (Read 3083 times)

twowheeler

How do I link an individual to a household in the API?

Kurund Jalmi

Re: How do I link an individual to a household in the API?

twowheeler

Re: How do I link an individual to a household in the API?

Kurund Jalmi

Re: How do I link an individual to a household in the API?

twowheeler

Re: How do I link an individual to a household in the API?

twowheeler

Re: How do I link an individual to a household in the API?

Kurund Jalmi

Re: How do I link an individual to a household in the API?