1

I am getting dupes created when contributing. Contribution pages use the 'Unsupervised' dedupe rule, which I have set to First name, Last name & email, assigning 10 to each with a threshold of 30. But then I am getting duplicate contacts created every time, with exact matches on all three fields. When I change the value of email to 20 and set the threshold to 20 a match is made & no dupe. It seems that first name and last name are being ignored and only email is working. Am I misunderstanding something here? Could this be a bug? Using Stripe 4.7.2, Civi 4.7.24 with Drupal 7.

  • hi andy - can you post of a screenshot of your matching rule config just to rule out any obvious blunders – petednz - fuzion Oct 19 '17 at 8:55
1

This sounds like the reverse to what you are experiencing but one issue with email field when matching is that if a record has more than one email, then each of those matching emails is counted - and it is easy for a record to end up with the same email 3 times. So I recommend a rule such as

  • First = 10
  • Last = 10
  • Email = 2
  • Threshold = 22

That way a record would have to have 11 of the same emails to count as a match.

  • The test contact had 3 email addresses so I removed 2, and tried your recommendation. But, still got a duplicate contact. Tried other combinations & still fails every time. I notice that in the created duplicate contact the email address is set to 'Billing' - I'm using Stripe, by the way. So still wondering if some kind of a bug... – Andy Clark Oct 19 '17 at 10:32
  • @AndyClark - that might be your problem: the dedupe rules only let you specify 'email' without a location. Are your existing addresses of type Billing? If you use the same rule in a manual dedupe does it show any differences for the email fields? Since your threshold of 20 works, it might be that firstname/lastname are matching but email is not. – Aidan Oct 19 '17 at 14:48
  • Aidan - existing email addresses are usually home. Firstname & lastname just won't match at all, I'm sure it's matching on email alone. I have set the unsupervised rule to email only, less than ideal but I found there are only 30ish contacts with a shared email address. Still wondering if this is a bug but not easy to test unless you have a payment processor set up. – Andy Clark Oct 19 '17 at 18:18
  • 1
    Try testing using just the profile page that includes the first/last/email. Also - do your duplicates show up as potential duplicates when merging? And finally - just to be sure - are you using the CiviContribute page or are you using webform civicrm. – Alan Dixon Oct 19 '17 at 19:19
  • Will do, Alan. This is using a CiviContribute page, not a webform – Andy Clark Oct 20 '17 at 8:04
0

I had the same problem and can confirm that names are ignored. I worked around it by created a new rule matching on email address and postcode, and changing the settings to make it use that as the unsupervised rule.

[Edit: adding some info to help diagnose the problem]

This was the original rule:

enter image description here

When I make two online donations under the same email and both names the same, it creates two contacts.

Then I switched the rule to this:

enter image description here

and made another online donation with the same details (including the same postcode), and it logged the donation on the existing contact as expected. (But only when I included a profile with main address fields in the contribution page. Without that, it failed to match, presumably because it matches on main and not billing address).

NB: When the original (email and name) rule is set to supervised, it works - i.e, when I use the "Check for matching contacts" button it finds the one with the same name and email.

[Edit: adding another screenshot]

I also tried with this rule:

enter image description here

and it created a duplicate contact despite having the same first name, last name and email.

  • i am worried that you are reporting that a Dedupe match does not work as expected. Can you pls include a screenshot of the old Rule settings so we can understand what is not functioning correctly – petednz - fuzion Sep 17 '18 at 12:02
  • @petednz-fuzion added. Thanks! – naomi Sep 18 '18 at 14:03
  • ok but from your screenshot i don't see what the Weight and Threshold were for the first one. – petednz - fuzion Sep 18 '18 at 14:42
  • also note afaik if you have Email 1 and Postcode 1, and there is a contact that has two addresses, both with the matching postcode, then this will score 2 regardless of the email being different and hence risks overwriting the email address – petednz - fuzion Sep 18 '18 at 14:44
  • @petednz-fuzion The original rule was some kind of built-in system default. It doesn't say what the weights are. Also: Are you sure it checks multiple addresses? It certainly does not check the Billing address. Without the Gift Aid profile (which contains home address fields) added to the Contribution Page, two contacts were created with the same name and postcode whilst using that rule. – naomi Sep 18 '18 at 15:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.