CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Deciding between Household and Individual Contact Types
Pages: [1]

Author Topic: Deciding between Household and Individual Contact Types  (Read 6562 times)

jbertolacci

  • I post occasionally
  • **
  • Posts: 54
  • Karma: 1
Deciding between Household and Individual Contact Types
October 23, 2009, 04:23:09 pm
Like many I am chewing on the pros and cons of implementing Households vs Individuals for a "family" of contacts. Here are some of the choice threads and blogs from my reading:

http://forum.civicrm.org/index.php/topic,8052.0.html
http://forum.civicrm.org/index.php/topic,9180.0.html
http://civicrm.org/node/558
http://forum.civicrm.org/index.php/topic,6727.0.html

Our use case is fairly straight forward: in our current database we have a family membership type which is linked to a single contact. Moving to CiviCRM we need to decide between:

1) Importing these contacts as Individuals, linking the membership to that Individual, and relating new Individual contacts which are part of the family to each other through a custom relationship, or...
2) Creating both Household and Individual contacts in the import, relating the Individual to the Household ("Household Member of"), and linking the membership to the Household.

Here are some implications I need help understanding which are not covered in the URLs above:

1) If we use Households, it appears that there is no equivalent to the "I am contributing on behalf of an organization." functionality for campaign/membership pages. Consequently any new membership, which is created by the user through an online campaign page, will be linked to the Individual and not the Family. And there does not appear to be a way to move a membership from one contact to another from the CiviCRM admin interface, which means that every time we receive an online family membership, not only will staff (or a hook) need to create a new Household, the online membership will need to be deleted and recreated on the Household and a soft credit will need to be applied to the Household (if you want an accounting trail).

On the other hand if the membership is linked to an Individual and other contacts are related to that Individual, the Individual  contact will be able to contribute/join/renew online, the membership will correctly populate under her contact record, and -- assuming the membership type and relationships are setup correctly -- the membership can be extended to the related contacts, correct?

2) When manually searching for duplicate contacts, the matching rules are specific to one type of contact. Through testing it looks like the contact matching rules apply across contact types (i.e. if you are creating a new Household and the email matches an existing Individual it will warn that there is a duplicate contact), but if we run the dedupe rules manually, the contact matching rules only match within the contact type associated with the rule. So if we use Household contacts for families there will be no way to manually find contact duplications if the duplicate contacts happen to be Individual contact types. Is my testing correct?

3) In the above URLs, the CiviCRM team recommends using Households for a family of contacts in use cases like mine. It seems like there are some disadvantages to using Households, what are the advantages?

jason

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Deciding between Household and Individual Contact Types
October 24, 2009, 11:51:42 am
Hi Jason - some comments inline.. but first a caveat that the best advice on this will come from folks who have done implementations and "lived with them" - so I would certainly give significant weight to advice from folks like Tony at Dharmatech (who consistently discourages the use of households for many use cases).

Quote from: jbertolacci on October 23, 2009, 04:23:09 pm
1) If we use Households, it appears that there is no equivalent to the "I am contributing on behalf of an organization." functionality for campaign/membership pages. Consequently any new membership, which is created by the user through an online campaign page, will be linked to the Individual and not the Family. And there does not appear to be a way to move a membership from one contact to another from the CiviCRM admin interface, which means that every time we receive an online family membership, not only will staff (or a hook) need to create a new Household, the online membership will need to be deleted and recreated on the Household and a soft credit will need to be applied to the Household (if you want an accounting trail).

On the other hand if the membership is linked to an Individual and other contacts are related to that Individual, the Individual  contact will be able to contribute/join/renew online, the membership will correctly populate under her contact record, and -- assuming the membership type and relationships are setup correctly -- the membership can be extended to the related contacts, correct?

The above statements are accurate for current "out of the box" functionality. If you want to move ahead w/ households for other reasons, you could sponsor / implement generalization to the "On behalf" functionality so that it can be used for any contact type / subtype. Else, I'm pretty sure you could use custom fields in Profiles along with hooks to create the Household along with the individual, link the membership to the household and create the relationship between the two.

Quote from: jbertolacci on October 23, 2009, 04:23:09 pm
2) When manually searching for duplicate contacts, the matching rules are specific to one type of contact. Through testing it looks like the contact matching rules apply across contact types (i.e. if you are creating a new Household and the email matches an existing Individual it will warn that there is a duplicate contact), but if we run the dedupe rules manually, the contact matching rules only match within the contact type associated with the rule. So if we use Household contacts for families there will be no way to manually find contact duplications if the duplicate contacts happen to be Individual contact types. Is my testing correct?

Interesting. I guess it's debatable as to whether a household with the same email address as an Individual is actually a duplicate. Which flow did you test where the email was detected as duplicate in HH and Individual?

Quote from: jbertolacci on October 23, 2009, 04:23:09 pm
3) In the above URLs, the CiviCRM team recommends using Households for a family of contacts in use cases like mine. It seems like there are some disadvantages to using Households, what are the advantages?

HH provide a mechanism to understand how constituents are "related" by physical location. The "Use Household Address" mechanism allows you to maintain a single piece of address data for multiple individuals. That said, there are also complications which relying on householding for membership management (as noted above) as well as potentially for "communicating" with constituents (described in tony's blog ref'd above).
Protect your investment in CiviCRM by  becoming a Member!

dharmatech

  • I post frequently
  • ***
  • Posts: 280
  • Karma: 53
    • dharmatech.org
Re: Deciding between Household and Individual Contact Types
November 04, 2009, 09:47:33 am
Hey Jason and Dave. I'm late but thought I would add my two cents.

It's no surprise but I don't think you should use households.  You should go the individual route for reasons already stated. I think there are limitations to using individuals but those aren't big enough to justify using HH's, in my opinion. When we started deploying CiviCRM, we used HH's and our clients are still suffering from that decision to be frank.

I think using hooks would be a timesaver for your admins/staff.  With custom fields you would ask people who their spouse is then the hook creates an individual from those fields and the relationship to the individual filling out the form, thereby extending the membership. We've never actually done this yet (not needed by our clients) but it seems doable.

Regarding the use HH address feature, as noted in my blog post, that's one area that should definitely be extended to all contacts (which is on the road map somewhere).

Not sure if this helps but I don't think your use case requires using HH's

Tony
http://dharmatech.org
oss@dharmatech.org
801.541.8671

scotdb

  • Guest
Re: Deciding between Household and Individual Contact Types
November 06, 2009, 04:37:05 pm
I've just discovered CiviCRM and am going to be doing a demo to a client next week to see if it meets their needs.

I've got a demo system running, and have a question about something similar to the "Household" debate above.

The client has Individual and Family members, with different subscription amounts.   But they have said that a "Family" is actually only 2 people (normally husband and wife, but could be mother and daughter or whatever).   I'm wondering how I should set this up ?

Thanks.

And just to say that you guys have done an amazing job of this and I think my client will be delighted ... I'll keep you posted.

Phil Nelson
ScotDB Limited

PS : ever thought of porting to another DBMS ?    I'd like to use it with IBM DB2 Express-C (no cost version).

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Deciding between Household and Individual Contact Types
November 06, 2009, 04:53:50 pm
You wlll need to do some custom coding with hooks to enforce the 2 person limitation (if it needs to be "enforced"). That said, one straightforward way to set most of this up in the UI:

- create a new relationship type => "Family Member"
- create two membership types: "Individual Membership", "Family Membership" - with the family membership configured to extend to related "Family Member"

With this approach, you can sign up a person for the Family Membership, and then when a "Family Member" relationship is created between them and another person - the other person inherits the membership.

Perhaps others will chime in w/ other approaches (based on real-world implementations)...
Protect your investment in CiviCRM by  becoming a Member!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Deciding between Household and Individual Contact Types
November 06, 2009, 07:57:59 pm
Quote from: scotdb on November 06, 2009, 04:37:05 pm
PS : ever thought of porting to another DBMS ?    I'd like to use it with IBM DB2 Express-C (no cost version).

I dont think this is a trivial undertaking and may not be worth the amount of time/energy spent on doing the port. I dont think we've spent any time ensuring that the sql / schema is portable to other DB's so i suspect there will be a few "mysql" specific things in there. I dont think we've used too many (or any) mysql specific constructs, but we have not been looking at it from that point either

We do fairly frequent releases, so you will need to sync with the latest code base quite often

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Deciding between Household and Individual Contact Types

This forum was archived on 2017-11-26.