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 (Moderator: Dave Greenberg) »
  • Non Unique Email Addresses
Pages: [1]

Author Topic: Non Unique Email Addresses  (Read 1895 times)

polestar

  • I post frequently
  • ***
  • Posts: 162
  • Karma: 11
    • Target Integration
Non Unique Email Addresses
October 06, 2011, 10:29:23 am
Hey Guys,

We are working on implementing CiviCRM for an association whose members may not have unique email addresses. In fact, they may use one household's email address for all their communication needs.

CiviCRM and Joomla as well require that the users have unique email addresses.

Have you ever implemented this scenario? Looking for some advice and experience of some senior people here.

Thanks
Rohit
CiviCRM - Installation & Support | Virtual Private Servers (VPS) with Joomla/Drupal and CiviCRM | SugarCRM & vTiger CRM Installation and Support
Target Integration | www.targetintegration.com
Subscribe to Knowledgement - Your guide to effective business | http://www.knowledgement.ie

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Non Unique Email Addresses
October 06, 2011, 06:42:44 pm
CiviCRM does NOT require unique email addresses. You may need to change the default strict dedupe rule however depending on how data is being input (to prevent unintentional combining of records based on same email address).

Joomla and Drupal do required unique email for Users - but this isn't a problem unless the members need to have logins for some reason.
Protect your investment in CiviCRM by  becoming a Member!

polestar

  • I post frequently
  • ***
  • Posts: 162
  • Karma: 11
    • Target Integration
Re: Non Unique Email Addresses
October 11, 2011, 04:18:44 am
Hi Dave,

But CiviCRM does synchronise contacts with Joomla/Drupal on the basis of their email addresses. So even if we hack Joomla to allow for multiple registrations from same email address and change the default strict dedupe rule; the possibility is that CiviCRM will still get confused synchronising users with the content management system.
CiviCRM - Installation & Support | Virtual Private Servers (VPS) with Joomla/Drupal and CiviCRM | SugarCRM & vTiger CRM Installation and Support
Target Integration | www.targetintegration.com
Subscribe to Knowledgement - Your guide to effective business | http://www.knowledgement.ie

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Non Unique Email Addresses
October 11, 2011, 04:54:24 am
That's the other way around: it synchronises Joomla/Drupal users with contacts. You can have contacts that aren't users and that have the same email address than a user/contact

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

LindseyM

  • I post frequently
  • ***
  • Posts: 229
  • Karma: 8
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Non Unique Email Addresses
October 17, 2011, 01:19:37 pm
Hi Dave
Please could you give me a quick pointer to alter the default de-dupe rule (strict for individuals) to stop the scenario below happening (as this happened last week):

- Mr & Mrs X share the same email address
- Mr X registered two friends (Pete and James) for an event, using his own email address
- Civi locked onto the email address and changed Mr & Mrs X to be called Pete and James

At present our rule is the default (I think) of first name (length 3, weight 1), last name and email (no length, weight 1), with a weight threshold of 2 to consider contacts matching.  I haven't got my head around weights as yet and would be interested in what you'd suggest as a rule to avoid the scenario I mentioned.  Many thanks.


Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Non Unique Email Addresses
October 17, 2011, 02:42:31 pm
The default STRICT rule (which is what is used for self-service pages like online contributions and event registrations) is solely based on email address.

The way "matching" works is that each element in your rule that matches adds the "weight" amount to a total. If that total is at or above the "threshold", then it's considering a match. I suspect you have the default strict rule in place based on the behavior below (and you also have "allow same email address for multiple participants"). This is NOT a recommended combination of options since it will results in the problem you've described.

EXAMPLE with your setup:
First Name: Weight = 1
Last Name: Weight = 1
Email: Weight = 1
Threshold = 2

Existing Contact: Dan Green dan@foo.com
Input: Jane Green dan@foo.com .... 1 pt for last name match + 1 pt for email match = 2, considered dupe and will link event reg to existing contact and overwrite value (first name will be Jane after form is processed).

HTH

If many of your constituents share email addresses, you might want to consider setting that rule so that a new contact is always created and then using a different rule in your backoffice to periodically find and merge duplicates. You can do this by setting the threshold higher than any possible combination of weights.
Protect your investment in CiviCRM by  becoming a Member!

LindseyM

  • I post frequently
  • ***
  • Posts: 229
  • Karma: 8
  • CiviCRM version: 4.4.6
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3.6
Re: Non Unique Email Addresses
October 19, 2011, 01:46:18 am
Thanks Dave - I now understand it and will get going on this one.  We've had some amusing name changes but I'll forego the laughs in favour of more accurate checks!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Non Unique Email Addresses

This forum was archived on 2017-11-26.