Answers.Body: <p>Oh dear, yes that sounds like things are in a mess. Some suggestions</p>
  
  <ol>
  <li><p>It sounds like you need to review the Dedupe Rules that are set up and in use. That should include checking that the 'threshold' has been set correctly</p></li>
  <li><p>You should check if logging is turned on (civicrm/admin/setting/misc?reset=1) and hope that it is as that should let you use the Change Log tab to try and identify and restore changes</p></li>
  <li><p>if you have access to the db and have access to some sql skills then you may be able to repair some of the problems</p></li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-31T04:59:24.643Z
Answers.LastActivityDate: 2018-01-31T04:59:24.643Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Ok, I am going to try and explain this as best I can:</p>
  
  <p>I am working with nonprofit to help export their donors for last year, but some of the contacts have their own email address listed as well as another individual's email address that is completely unrelated. Sometimes the address information is completely different as well.</p>
  
  <p>It looks like it has been merging/overriding the contacts based on their first names, but it doesn't do that for everyone with the same first name.</p>
  
  <p>They set their event registration duplicate matching rule to "Name and Address (reserved) - General" and I'm think that may have something to do with the merged contacts? My customer isn't manually merging duplicate contacts, so that's where some of the confusion lies as well.</p>
  
  <p>They also have online contributions setup, so CiviCRM is also merging/overriding the information used when making contributions if it's different than what is already showing in the contact record.</p>
  
  <p>Here are a couple of examples:</p>
  
  <ol>
  <li><p>Billy S recently donated $25 - in his CiviCRM contact record, his home email is listed as xxx@beverly-hanks.com and personal email as yyy@gmail.com</p></li>
  <li><p>Katherine (Kathy) V recently donated $1,000 online - in her CiviCRM contact record, her home email is listed as xxx@ywcaofasheville.org and her billing email is yyy@gmail.com</p></li>
  </ol>
  
  <p>**In both of these cases the "home email" is incorrect but the personal or billing email is correct.</p>
  
  <hr>
  
  <p>This example is the one that is actually combining 4 different contacts with the first name of "John", but only one John now exists as a contact in CiviCRM:</p>
  
  <p>John M donated $100 on Oct 30, 2017</p>
  
  <p>John V donated $1,000 on Dec 6, 2017</p>
  
  <p>John W donated $250 on Dec 22, 2017</p>
  
  <p>John R donated $1,000 on Dec 31, 2017 <em>(this is the only contact that is now showing in CiviCRM, but it includes all 4 of those donations)</em></p>
  
  <p>Each of these donors received their receipts to their own email addresses confirming their contribution.</p>
  
  <p>Now, when we pull a report, only John R's name is listed and he's listed as giving 4 times:</p>
  
  <p>10/30/2017 16:25 - $100.00</p>
  
  <p>12/6/2017 22:21 - $1,000.00 </p>
  
  <p>12/22/2017 7:32 - $250.00 </p>
  
  <p>12/31/2017 10:35 - $1,000.00 </p>
  
  <p>When searching contacts in CiviCRM, John R's name is the only one that comes up. When searching by email addresses, only John R's email "exists" in the system.</p>
  
  <p><a href="https://i.sstatic.net/2csPX.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/2csPX.jpg" alt="John R&#39;s CiviCRM Contributions"></a></p>
  
  <p>So, is this all related to the dedupe rule that has been used for events that these donors have also signed up for?</p>
  
  <p>Or is it something else entirely?</p>
  
  <p>Any assistance with this would be GREATLY appreciated!</p>
  
  <p>And if you need any further clarification, just let me know because I know this is very confusing and difficult to fully explain :)</p>
  
  <p>Thank You!</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-01-31T08:57:25.553Z
Comments.Text: I hope those aren't real names, emails and donations ...
Comments.UserDisplayName: Aidan
Tags: <civievent><drupal><civicontribute><contacts><duplicate-contacts>
Title: CiviCRM Contact Information Merging and Overriding Unrelated Users/Donors
ThreadText: # CiviCRM Contact Information Merging and Overriding Unrelated Users/Donors
  
  (Asked by: username_0 on 2018-01-30)
  
  Ok, I am going to try and explain this as best I can:
  
  I am working with nonprofit to help export their donors for last year, but some of the contacts have their own email address listed as well as another individual's email address that is completely unrelated. Sometimes the address information is completely different as well.
  
  It looks like it has been merging/overriding the contacts based on their first names, but it doesn't do that for everyone with the same first name.
  
  They set their event registration duplicate matching rule to "Name and Address (reserved) - General" and I'm think that may have something to do with the merged contacts? My customer isn't manually merging duplicate contacts, so that's where some of the confusion lies as well.
  
  They also have online contributions setup, so CiviCRM is also merging/overriding the information used when making contributions if it's different than what is already showing in the contact record.
  
  Here are a couple of examples:
  
  1. Billy S recently donated $25 - in his CiviCRM contact record, his home email is listed as xxx@beverly-hanks.com and personal email as yyy@gmail.com
  2. Katherine (Kathy) V recently donated $1,000 online - in her CiviCRM contact record, her home email is listed as xxx@ywcaofasheville.org and her billing email is yyy@gmail.com
  
  \*\*In both of these cases the "home email" is incorrect but the personal or billing email is correct.
  
  ---
  
  This example is the one that is actually combining 4 different contacts with the first name of "John", but only one John now exists as a contact in CiviCRM:
  
  John M donated $100 on Oct 30, 2017
  
  John V donated $1,000 on Dec 6, 2017
  
  John W donated $250 on Dec 22, 2017
  
  John R donated $1,000 on Dec 31, 2017 *(this is the only contact that is now showing in CiviCRM, but it includes all 4 of those donations)*
  
  Each of these donors received their receipts to their own email addresses confirming their contribution.
  
  Now, when we pull a report, only John R's name is listed and he's listed as giving 4 times:
  
  10/30/2017 16:25 - $100.00
  
  12/6/2017 22:21 - $1,000.00
  
  12/22/2017 7:32 - $250.00
  
  12/31/2017 10:35 - $1,000.00
  
  When searching contacts in CiviCRM, John R's name is the only one that comes up. When searching by email addresses, only John R's email "exists" in the system.
  
  [![John R's CiviCRM Contributions](https://i.sstatic.net/2csPX.jpg)](https://i.sstatic.net/2csPX.jpg)
  
  So, is this all related to the dedupe rule that has been used for events that these donors have also signed up for?
  
  Or is it something else entirely?
  
  Any assistance with this would be GREATLY appreciated!
  
  And if you need any further clarification, just let me know because I know this is very confusing and difficult to fully explain :)
  
  Thank You!
  
  **Tags:** civievent, drupal, civicontribute, contacts, duplicate-contacts
  
  > **Comments:**
  > **username_1**: I hope those aren't real names, emails and donations ...  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2018-01-31. Score: 1 | Accepted answer
  
  Oh dear, yes that sounds like things are in a mess. Some suggestions
  
  1. It sounds like you need to review the Dedupe Rules that are set up and in use. That should include checking that the 'threshold' has been set correctly
  2. You should check if logging is turned on (civicrm/admin/setting/misc?reset=1) and hope that it is as that should let you use the Change Log tab to try and identify and restore changes
  3. if you have access to the db and have access to some sql skills then you may be able to repair some of the problems
  
  
  ---
  
  