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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Questions on Making Email The Unique Key in Civi
Pages: [1]

Author Topic: Questions on Making Email The Unique Key in Civi  (Read 948 times)

pbarmak

  • I post occasionally
  • **
  • Posts: 111
  • Karma: 3
  • CiviCRM version: 3.3.5
  • CMS version: Pressflow 6.19
  • MySQL version: 5.1
  • PHP version: 5.2.10
Questions on Making Email The Unique Key in Civi
May 10, 2012, 08:45:20 am
Hello folks,
We currently have Civi set up with First, Last, and Email as the Strict Dedupe rule, making those three fields the unique key for contacts.  We have a desire to change this so that Email alone is unique - no two contacts can have the same email address.  We want to use email as their login to our extranet, which links to their Civi contact record.

I'm having issues figuring out how this will work with Event Registrations and areas we use the API with (importing donations/contributions, etc).  I would like to get some strategies of folks who are going the same route (maybe due to Drupal accounts or otherwise).

If we have just Email be the unique identifier (making it the only field in the default strict rule), if a person registers using an existing Contact's email (because they share an email address or just maliciously) during Event Registration, it seems Civi will go ahead and overwrite the existing Contact's information - so the name and history of events/donations will belong to this new person.  Here is the scenario I'm thinking of:
1. Papa Smith sponsors a child monthly and donates to us with email = smithfamily@none.com.  He gets into Civi, no problem, gets ID = 10.
2. Mama Smith then donates to us with email = smithfamily@none.com.  Civi sees the email matches ID = 10, so it updates the Contact's information, including the names.
3. Kiddo Smith then registers for an Event with email = smithfamily@none.com.  Civi sees the email matches ID = 10, so it updates the Contact's information again, including the names, passport, everything.

Am I thinking about this the right way?  How are people handling this situation if they want to make Email unique in Civi?  I'm trying hard to avoid having Civi simply create duplicates and forcing an admin to dedupe all the time (that uses up a lot of our time nowadays).  I would appreciate some help in thinking this through ... thanks!

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: Questions on Making Email The Unique Key in Civi
May 10, 2012, 11:34:50 am

I think this might be a case of wanting to keep the cake and at the same time wanting to gobble it up :(

If your org has the below use case where families are sharing an email address, making that the unique key will not work, IMO

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

pbarmak

  • I post occasionally
  • **
  • Posts: 111
  • Karma: 3
  • CiviCRM version: 3.3.5
  • CMS version: Pressflow 6.19
  • MySQL version: 5.1
  • PHP version: 5.2.10
Re: Questions on Making Email The Unique Key in Civi
May 10, 2012, 12:56:47 pm
Well, our goal is to stop that behavior and have people use unique email addresses.  So we want to force that change (no gobbling up my cake :) ).  That's why I'm wondering how we can make this happen the right way.  We're convinced we should do it, just need to know how to implement it. 

How do others who have this uniqueness set things up in Civi so it checks appropriately without messing up a contact's information?

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Questions on Making Email The Unique Key in Civi

This forum was archived on 2017-11-26.