Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [duplicate-contacts]

Use this tag for questions about preventing, finding, and merging duplicate contacts. This includes composing duplicate matching rules, using the dedupe system, strategies for preventing false matches, and merging a pair of contacts.

2
votes
0answers
7 views

Unsupervised de-duping - potential matches not ordered by weight score descending?

I've got contacts that share Last Name and Email, and I'm using an unsupervised de-duping rule for online contribution forms and event registrations with the following fields and weights - Email 10 ...
0
votes
0answers
37 views

Civi dedupe error during civievent registration

When registering for an event, most users are getting this error: This occurs when the event form is checking for duplicate registrations. Below is the info from the civi error log. What makes this ...
0
votes
1answer
11 views

CiviEvent backing out of contact change from dedupe rule

Is there a way to "back out" a change caused by a dedupe rule on an event administratively? I see two records with the same name, Person A. I have had a dedupe rule on an Event that was incorrect. I ...
0
votes
1answer
15 views

How do I enable or disable Ajax Deduping?

A recent bug report mentions that it affects users only when Ajax deduping is enabled. How do I find this option to review it? Both Google and code grepping are failing me. https://github.com/civicrm/...
3
votes
2answers
69 views

Bug with Check for Matching Contact(s) button

Following the upgrade to 5.3.0, we are finding that the 'Check for Matching Contacts' button, which is in the edit contact screen, is not working. The screen refreshes and reloads the same contact, ...
1
vote
1answer
10 views

Custom Field that is a Foreign key to contact in Custom Group that extends Event is not updated on merge of contacts

I have created a Custom Group for Events. This Group has one custom field Organizor which is a autocomplete with contacts. But on merging the contact the Organizor custom field is not updated ...
3
votes
3answers
45 views

Deduping between Individuals and Organisations

An issue that's come up while we've been cleaning up our records for GDPR - we have a significant number of records where organisations have been entered as individuals, and vice versa. This is ...
7
votes
2answers
49 views

Deduping within contact records

I've noticed that some of our contact records have the same email duplicated (e.g. as 'home' and 'work' or 'main' and 'work' emails). I'm not seeing a simple way to find these records so we can clean ...
4
votes
2answers
27 views

Am i able to do a search for duplicates in the database?

If I am looking to clean up my database can I do a mass search for duplicates? save the file and at a later date work on merging?
1
vote
1answer
28 views

Import Contacts creating dupes despite dedupe rules

We are currently updating a member database with returning and new students/contacts. In the past we have been able to import lists updating the returning students, but now new duplicate records are ...
0
votes
1answer
19 views

Duplicate contact when i log with this one

Apparently when i'm trying to log with a contact, this one is duplicate :-/ Someone said that it could be because the wp email is different of civi email but in my case both are the same. If someone ...
1
vote
1answer
22 views

How to Dedupe Records

I have one member who signed up 3 years in a row online. Every year he used a different variation of his name. How can I unify these files using the deduping mechanism?
4
votes
2answers
82 views

Import Contacts with dedupe rules

Recently I have encountered a problem related to the import of contacts and has to do with the dedupe rules. When you import a list of contacts through a CSV file and select a dedupe rule, the CRM ...
2
votes
0answers
29 views

When / how is a contact created when sending out a test newsletter

Recently we stumbled upon duplicate contacts in our system, who had merely an email-address. After some digging it seems that they were created when users utilize Mosaico to design an email and then ...
3
votes
1answer
35 views

Merging two contacts

I am looking to merge two contacts together as they are duplicate records. I want to ensure all the tags, groups and contributions all carry over too. I just want to do this on an individual record ...
2
votes
1answer
161 views

DataTables warning on Find and Merge page - Upgraded to 5.0 from 4.7.17

I'm Running Civi 5.0.0 with Wordpress 4.9.5 I'm looking to troubleshoot the following warning. It comes up on the Find and Merge page after select any of my Find and Merge rules - no results are ...
1
vote
0answers
36 views

Documentation on using CiviCase tokens

Civicase Tokens Extension does not have documentation. I am trying to use the tokens to do a print/merge of case information. The print page is blank. Any suggestions? Have case tokens been used ...
0
votes
1answer
18 views

CiviCRM Contact Information Merging and Overriding Unrelated Users/Donors

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 ...
0
votes
0answers
14 views

Event Calendar for United Way Washington County

I searched the videos to try to answer my question, but nothing applicable show up. How do I just add an event to the event calendar? Not create a new event or manage events.. just add/manage events ...
0
votes
2answers
105 views

Dedupe Rules to import contacts without email addresses *UPDATE*

UPDATED 1/16/2018 See screenshot. This is an example of what I am trying to import. This is the same person. The only difference is the notes. How can I import this without creating 4 duplicates? *...
0
votes
1answer
12 views

dupe_check parameter only works for contacts?

I would like to disable the dupe check on relationships. Is it true that the API parameter parameter 'dupe_check' works only for contacts or can it be also used in relationship api calls? Here under 4....
5
votes
3answers
105 views

Merge known duplicate

I have two records for the same person. How do I merge them? I know there is a function to look for possible duplicates but these records are not being picked up because of spelling errors.
2
votes
1answer
29 views

API Contact>DuplicateCheck Not Working?

Can someone please verify that the API for contact>duplicatecheck is actually working? In my case the UI will return 8 dupes, but the API will not return any. It seems to be broken as of late. ...
1
vote
1answer
53 views

Find and merge duplicate contacts error: “this is incompatible with sql_mode=only_full_group_by”

When I try to use "Contacts > find and merge duplicate contacts" (using the default rule) I get an error. Something to do with "subunion.weight" see error trace below. Anyone able to advise? tia ...
1
vote
1answer
28 views

Employer on Profile - Mismatching

I saw a few with similar questions, but not exactly the same on a major point. If moderators see value in merging this, go for it. We have a problem where people sign up for an event which includes ...
0
votes
1answer
25 views

Allow multiple registrations from the same email address requires a profile of type 'Individual'

Long time ago, we had created event and template for event. We give permission to user to register multiple participant with same email address. Now we have problem with a lot of question link to ...
3
votes
1answer
42 views

Force Batch Merge All Duplicates

I have around 900 pairs of contacts I want to force merge. From my attempts to do this, if you click "merge all duplicates", it will simply display "900 pairs skipped" and not give you the "force ...
2
votes
1answer
32 views

Comparing Duplicate address

I have set of name, addresses, phone number etc in CiviCRM. These are slightly outdated. I have an excel sheet for the same people with their new addresses. I have a unique external identifier for ...
2
votes
1answer
22 views

How can I allow a participant to enrol for an event more than once?

At our nightshelter we have some volunteers that perform more than one role - e.g. as a van driver and also as kitchen staff. To capture volunteer hours we sign volunteers in to the nightshelter ...
4
votes
1answer
116 views

Allow duplicate contacts with the same email

On Civi 4.7.22 and Wordpress 4.8.22 Here is the Scenario: Jane Doe uses her email address to signup her son Joe Doe at 123 Red Road Then Jane at 321 Blue St. decides to become a member herself, using ...
0
votes
0answers
11 views

Error deduping based on Group

Running WP 4.8.2 CiviCRM 4.7.22, we cannot run "Find and Merge Duplicate Contacts" restricted to a Group without getting the dreaded "DB Error: unknown error". Looking through this Forum, I saw a ...
1
vote
1answer
52 views

Import – match to contact by email without creating duplicate email address

Is it possible to use the import function for contacts and match by email, without creating duplicate email addresses for existing contacts? Example: We organize frequent webinars with participation ...
2
votes
0answers
8 views

View contact file while entering contribution batch?

Is it possible to view/open in a new window a contact's profile while entering a contribution batch? I know that a contact's email address will appear in the dropdown with the contact's name. However,...
1
vote
1answer
40 views

Membership imports

Can I import membership contact and membership details all in one upload without my contact already existing? Or does my contact need to already be a contact for me to upload membership specifics - ...
1
vote
1answer
29 views

Dedupe rules for profiles in civicrm

Is there any way possible to have dedupe rules specific to particular profiles instead of for whole contact feature? Example:- Profile 1:- Name Email Dob Gender Profile 2:- Name Dob Gender ...
1
vote
0answers
16 views

No import for existing contact

When doing an import for existing contact that I want to update, after selecting Fill (For Duplicate Contacts), I get a Warning, a Notice but no import : Warning: array_pop() expects parameter ...
2
votes
2answers
22 views

How do I download duplicates of imported contacts in the past month?

I import contacts almost every day, and I automatically press "skip" on the "For Duplicate Contacts" import option. When the import is complete, I recognize that I have the ability to download the ...
3
votes
0answers
45 views

Civi duplicate rules with respect to email & primary versus location type

Civi 4.7.13, Drupal 7.56. I set up an unsupervised rule for FN/LN/email, with weights of 10 each and a weight threshold of 30. What I see happening is this: Contact A is in Civi as Jane Doe, only ...
0
votes
1answer
28 views

noob query : Importing contacts and membership

I am going to freshly import data from excel into civiCRM. I have some contact related information like addresses, educational info, etc and also membership data like membership date, enrolled by whom,...
2
votes
2answers
182 views

Contact Import explode issue with matching contacts

I am getting the following warnings when trying to import contacts: Warning: explode() expects parameter 2 to be string, array given in //wp-content/plugins/civicrm/civicrm/CRM/Contact/Import/Parser/...
1
vote
1answer
30 views

Error During “Find & Merge Duplicate Contacts”

We recently upgraded to 4.7.16 and immediately starting having problems when checking for duplicate records. I set up a very basic merging test -- same last name and email, I've tried picking a very ...
3
votes
2answers
109 views

Something is seriously wrong with CiviCRM - Replicating Contacts

Wordpress 4.7.5 & CiviCRM 4.7.19 My contact is replicating in our system, to the point there were 700+ records with just my email and name. I am not sure what is happening but I have some ideas. ...
2
votes
2answers
45 views

Duplicate Contacts

I am new to using CIVI at my work place, and there are a ton of duplicate entries in the system (we did a merge from our previous system). Is there a quick and easy way to merge all duplicate contacts?...
0
votes
1answer
15 views

Deduping's “No of contacts to find matches for” field definition

When you go to "Use Rule" on the "Find and Merge Duplicate Contacts" page, you get a new page that has 2 fields, one called "Select Group" and the other called "No of contacts to find matches for" ...
1
vote
1answer
42 views

How can I avoid my import crashing with a Fatal Error due to an existing external ID?

I've had a few separate imports crash with a fatal error in the last month: Sorry but we are not able to provide this at the moment. DB Error: already exists Fatal error: Uncaught ...
4
votes
1answer
53 views

Contact Dedupe Basics

I'm new to CiviCRM and I'm trying to help a non-profit clean up what looks to be a very large number of duplicate contact entries. I have searched this site and a few other resources and I have a ...
1
vote
0answers
38 views

Administrator contact record duplicated when do Activity Send Email

One administrator's contact record is duplicated every time she performs the Activity action "Send email". The recipient's activity record indicates it was "added by" and points to a new contact ...
0
votes
0answers
25 views

Why did a dedupe rule not work sometimes. Yet later the same rule finds the duplicate

We set up an event that lets people signup on line. The dedupe rule we used on the event is first name, last name, email address (all need to match). A few of the signups created a new contacts, ...
1
vote
1answer
323 views

DataTables warning with dedupe on find & merge (after upgrade to 4.7.18)

Is anyone else seeing a new DataTables warning in 4.7.18? We get the following warning on the dedupe page when finding duplicate contacts: [Server Name] says: DataTables warning: table id=...
2
votes
2answers
47 views

CiviCRM Dedupe - How does it really work?

There seems to be some confusion at my current organization re: de-duping. I'm under the impression that if I have two records (organizations) Case 1: name: St. John's University Zip: 11439 Name: ...