CiviCRM Community Forums (archive)

Wondering if this is possible.
For example Joe Smith (Individual Record) works for Acme (Organization) and instead of entering the address for Joe Smith which is the same as his work address we just want to enter it once under that organization then check a box saying use that address when we go to edit his contact record. This seems to be available for households (see attached image).

If it is possible then I could use the existing code that is used for household to make it happen but I just want to check how far off this is? For example when they go to Individuals and create labels it will pull this address.

Thanks

How would I find out if it is being worked on.
I would hate to try and make it happen (like I have time) only to find out it is almost done by someone else?
I tried the link you sent, but then there is just made it seem like it was roadmapped for 2.3

Hi there,

I need to implement similar functionality, and can't wait till 2.3.  This issue http://issues.civicrm.org/jira/browse/CRM-1917 has lots of useful details on the original "use household address" implementation for CiviCRM 1.8

CiviCRM 1.8 had three tables for contacts (one for organisations, one for households and one for individuals).  These tables are now merged, and that makes hacking this considerably easier than it would have been before because the mail_to_household_id is now a mail_to_contact_id field which can be used to assign an organisation address to an individual in the same way that you would assign a household address.  In fact in can be used to to refer/divert any mail addressed to any contact to any other contact so use with care!

I think I am write in assuming that all you need to do is alter the SQL that populates the Dojo autocomplete field.  This can be found in CRM_Core_Page_AJAX::Search().  You can pass GET parameters to do this from the following variable in CRM_Contact_Form_Individual::buildQuickForm()

        $dataURL =  CRM_Utils_System::url( 'civicrm/ajax/search',
                                                   "hh=1",
                                                   true, null, false );

Have a look at CRM_Core_Page_AJAX::Search() and change "hh=1" to something sensible.  I changed it to "org=1" (which in fact replicates the I'm not using households in this data model, so that works fine for me.  You could also replace it with null, which would then replicate the Contact search autocomplete.  Or you could make your own and post it here.

I've done limited testing and as far as I can tell, it pulls off the correct address when you make labels, etc.  You'll probably also want to change the templates etc., to reflect the new operation ("Use organisational address", etc.)

In an ideal world / when this is implemented in 2.3, it would be good to have a proper consideration of how this relates to the Current Employer box.  Maybe the following radio options would work: use custom address / use current employer address / use another contact's address.  And when you come to 3.0 it would be good to consider how Current employer relates to the relationship, "is employee of" )

PS. This is only my second hack to the core so I might not understand the ramifications - use at your own risk!

The way Use Household Address works is:
* The individual's civicrm_contact.mail_to_household_id is populated w/ contact ID of the household.
* A "read-only" copy of the household's civicrm_address record is created and linked to the individual's contact record
* Whenever the linked (primary) household address is edited, the "linked" individual address record is also updated automatically

The "use employer address" issue is currently scheduled for 2.3.

Hi Xavier,

I had noticed that extra household relationship creation, and was about to post on that but you beat me to it.  Am going to hack around that as well and will post my solution here.  Did you say you had noticed another problems with my solution as well?  Can you elaborate on all that jazz?!

I think the benefit of copying is when you come to produce mailing labels you won't have to join the tables.

Michael

use case:

I add Dave Greenberg as a contact

First Name:dave
last name: greenberg
current employee: civicrm (it's autocompleted, as the company is already in the db)

The "work" address is automatically checked "use company address" and checked as the default location

Still a bit confused about the civicrm_loc_block and address and the relations, but couldn't the same address being shared between two (or more) contacts instead of doing a read only copy ?

@michael,

No, not a lot more than the additional relationship, and I gave up short of trying to see if it still update the address properly even when you delete the relationship.


Have you been able to progress ?

X+

Nope.  But never say never   I'd really like to get this done before then and will try and have another look soon.

Michael