CiviCRM Community Forums (archive)

Hi,

One told me that in 2.2, when you where printing labels, the address of the org was used if the individual didn't have address. Was it the behaviour or are we day dreaming ?

X+

Hi,

The solution is to properly implement it in civicrm and for that, the solution is that we all contribute to cover the cost. Do you think you could pay part of the dev ?

Xavier

One told me that in 2.2, when you where printing labels, the address of the org was used if the individual didn't have address. Was it the behaviour or are we day dreaming ?

dont think so

lobo

If one is willing to work around this issue by copying organizational address for employer into the work address of each employee, and deal with updating the same address in multiple locations, then I have a MySQL query that can help you. Note that employer addresses tend not to be as volatile as residential ones (eg up to 40 percent of apartment dwellers in Canada move every year). Still it is inelegant to have multiple copies of the same information.

The following query creates work addresses for individuals who do not have them if they have an employer and the employer has an address.

HTH someone.

INSERT INTO civicrm_address (contact_id, location_type_id, street_address, street_number, street_number_suffix, street_number_predirectional, street_name, street_type, street_number_postdirectional, street_unit,
supplemental_address_1,
supplemental_address_2,
supplemental_address_3,
city, county_id, state_province_id, postal_code_suffix, postal_code, usps_adc, country_id, geo_code_1, geo_code_2, timezone, name)
SELECT c.id AS 'Contact ID', 2 AS 'Work Location Type ID', caceM.street_address, caceM.street_number, caceM.street_number_suffix, caceM.street_number_predirectional, caceM.street_name, caceM.street_type, caceM.street_number_postdirectional, caceM.street_unit,
caceM.supplemental_address_1,
caceM.supplemental_address_2,
caceM.supplemental_address_3,
caceM.city, caceM.county_id, caceM.state_province_id, caceM.postal_code_suffix, caceM.postal_code, caceM.usps_adc, caceM.country_id, caceM.geo_code_1, caceM.geo_code_2, caceM.timezone, caceM.name

FROM civicrm_contact c
INNER JOIN civicrm_contact ce ON c.employer_id=ce.id
LEFT JOIN civicrm_address cacW ON c.id=cacW.contact_id
LEFT JOIN civicrm_address caceM ON ce.id=caceM.contact_id

WHERE c.contact_type="Individual" AND c.employer_id IS NOT NULL AND
caceM.contact_id IS NOT NULL AND
(cacW.contact_id IS NULL OR cacW.location_type_id<>2);

For all the folks mentioning support for this initiative...now's your chance.

http://civicrm.org/contribute

Integrate "Address Inheritance from Organization to an Individual" work with "Current Employer" field on Contact Edit form - This will automatically link a contact's work address with their employer's address off the contact summary (and potentially extendable to the on-behalf-of form)

I'm in.