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) »
  • New contacts not matching
Pages: [1]

Author Topic: New contacts not matching  (Read 2136 times)

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
New contacts not matching
July 15, 2010, 05:21:12 pm
We have a strict rule set up for Individuals that says to match on email address.

Someone registers on the Drupal site and fills out some CiviCRM info like name and city.

CiviCRM does not match this to existing contact. Instead it creates a new contact record.

Why isn't it matching when the email addresses are exactly the same?

The rule obviously works because when I say "use rule", it does indeed recognize they are a match.

Thanks for the help.

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: New contacts not matching
July 16, 2010, 11:06:10 am
I'm wondering if this error can be replicated on the demo site?  Could you please re-create the situation and check?
Try CiviTeacher: the online video tutorial CiviCRM learning library.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: New contacts not matching
July 18, 2010, 09:13:09 pm
I'm trying to. The demo is just so filled with stuff others have added to the Drupal reg page, required fields, etc., it is taking a while to get paired down settings that I can test.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: New contacts not matching
July 18, 2010, 09:19:04 pm
Also, the demo is running 3.2 and we're only running 3.1.5. Is there a demo to use that will allow me to use that version? Otherwise testing on the demo won't tell us much since it's different versions.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: New contacts not matching
July 18, 2010, 09:33:07 pm
I've tried everything I can think of.

I have tried both with the setting on the profile to update contacts to both on as well as off.

I have only one "strict" rule for Individuals. It only has one thing to check - email, which gives 20 points. Threshold for a match is 20 points.

If I use this rule, it catches the duplicates that should be caught at the time of Drupal registration.

People enter the following when they register for a Drupal account:
Username
Email
First Name
Last Name
City

They should then be matched to their record in the db that has the same email address. That's not happening. Instead, a new record is created.

We have a database of about 350 people. They each have a CiviCRM group (or groups) assigned to them. Those groups match a role in Drupal, which sets their permissions.

Because the Drupal registrations aren't matching up to the CiviCRM record, they aren't getting their role assigned.

I've never had this be an issue before. Normally it matches on email address without issue. This is the last remaining this so I can finally get this project done.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: New contacts not matching
July 18, 2010, 11:16:08 pm
Well, tried for some help in IRC, but no one was there. Will have to try again later.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: New contacts not matching
July 19, 2010, 06:29:35 pm
I'm IRC trying to get help, but wanted to put where I am at in here too (copied from IRC)..

[18:25] <Jenni> ok, I just did a clean install of Drupal and CiviCRM 3.1.5
[18:25] <Jenni> I have created the profile to be used as the site reg for Drupal
[18:25] <Jenni> it is set for matching
[18:26] <Jenni> strict matching is set for email (the default, I didn't even change it)
[18:26] <Jenni> There is a copy of the same profile used for site reg. This one is the one they see on their Drupal 'my account' page
[18:26] <Jenni> the difference is in this one you can only view the fields, not change them (they don't want people to edit their info)
[18:27] <Jenni> I added people to a smart group depending on their "primary status" (a custom field - student, alumni, faculty, etc.)
[18:27] <Jenni> I created roles in Drupal to match those smart groups
[18:27] <Jenni> I then turned on CiviGroup Roles Sync and set it up so the Drupal roles and CiviCRM smart groups match
[18:28] <Jenni> I created a fake contact record
[18:28] <Jenni> I then went into another browser and created a new Drupal user account with the same info from the fake contact record
[18:28] <Jenni> they did not match. A duplicate was created
[18:39] <Jenni> It's not smart groups causing it, as I changed them to regular groups. Still no matching.
[18:41] <Jenni> Turned off the CiviCRM Group to Drupal role module. Still no matching?
« Last Edit: July 19, 2010, 06:45:47 pm by jsimonis »

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: New contacts not matching
July 21, 2010, 01:34:03 pm
Jenni,

Can you upgrade to 3.1.6 and check if that solves your problem.

Kurund
Found this reply helpful? Support CiviCRM

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: New contacts not matching
July 21, 2010, 02:26:08 pm
will also report back on this as is critical problem for a couple of our 3.1.5 sites
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: New contacts not matching
July 21, 2010, 04:19:02 pm
SO I gave this a whirl on.

Factors

No Profiles are set to be used for "Drupal User Registration"

Strict Individual Rule (which I don't think plays a role in this) set to First+Last+Email=5+5+5=15

create contact in civicrm = unique4 with email unique4@xxx.co.nz

create Drupal user with email unique4@xxx.co.nz

Outcome - a second record is created with the same email
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: New contacts not matching
July 21, 2010, 04:57:16 pm
I will test an upgrade of the site later today. Between this stupid head cold and the late nights, my body is kicking my butt and I'm slower than usual.

I'll report back what I find out.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: New contacts not matching
July 21, 2010, 06:08:52 pm
Ok, I upgraded that empty site that I had been using for testing.

Contact matched when I registered as a new user.

It shows that "primary status" is student. That is correct since the contact record I already had in Civi had that information in their record (primary status is a custom field I added).

What did not happen is the appropriate Drupal role was not added to the Drupal account.

We have CiviGroup Roles Sync turned on. The Drupal role "student" is set to sync with the Civi Group "student." The group is a smart group that adds anyone with the "primary status" of student to it. The contact record in question is indeed a member of the smart group.

jsimonis

  • I post frequently
  • ***
  • Posts: 316
  • Karma: 4
    • Forward Support, Inc.
  • CiviCRM version: 4.4-4.5
  • CMS version: Drupal 7
  • MySQL version: 5.5.37-cll
  • PHP version: 5.3.29
Re: New contacts not matching
July 21, 2010, 06:14:05 pm
Ok, I switched from a "smart group" to just a regular group. Now I get both contact and role matching. Yay!

I'll just have to show the client how to run a quick search and add to group each time they update the database.

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: New contacts not matching
July 30, 2010, 05:01:21 pm
I can confirm on an installation of 3.1.5 that duplicate match rules were not working properly.  I had a situation where people were entering in donations as well as tell-a-friend and the contacts were not matched on email address.  Our default strict individual rule was email (10) weight (10).  There was no match.  Dozens of duplicate contacts were getting created every week.  I'm upgrading their site to 3.1.6 today and will let you know if this nonsense continues or not.
Try CiviTeacher: the online video tutorial CiviCRM learning library.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • New contacts not matching

This forum was archived on 2017-11-26.