Skip to main content

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.

Filter by
Sorted by
Tagged with
3 votes
3 answers
36 views

Limit duplicate search

We have a very large Civi database and are looking to dedupe. I have created smaller groups to work from (ex. all records with last name starting with "A") but even that group has 12,000 ...
erin's user avatar
  • 271
1 vote
1 answer
92 views

Is there a report that shows what is duplicated between contacts ? For example: contacts sharing an email, or a phone number

Is there a report that shows what is duplicated between contacts ? For example: contacts sharing an email, or a phone number. In other words, they have duplicate data, but they are actually not ...
barbaraec's user avatar
1 vote
0 answers
24 views

Possible to set a contact as the default for a particular email

I'm not even certain how best to ask this question. Here's the situation: Staff people at an org I support often wind up accidentally creating duplicates of themselves during event testing in Civi but ...
kapn's user avatar
  • 919
0 votes
1 answer
42 views

One person registers multiple people to an event, but CiviCRM stores all registrations to one person

We're seeing event sign-ups for multiple (non-member) participants that are made by one (non-member) person - in our case, a parent registering two children to two different swim trainings. They ...
Torben Gundtofte-Bruun's user avatar
0 votes
2 answers
37 views

Merge fails with DB Constraint violation

When merging 2 contacts this error appears however when the contact is checked the merge has succeeded: $Fatal Error Details = array:3 [ "message" => "DB Error: constraint ...
Paul Butler's user avatar
0 votes
0 answers
30 views

How do I merge duplicated contacts?

I am having problems with merging contacts. Some contacts have merged but others have not.
Sarah's user avatar
  • 1
1 vote
0 answers
36 views

Deduper fails with punctations in the name (dot, semicolon, underscore, parenthesis...)

As per this documentation page of the Deduper extension, the Uninformative characters resolver should be able to detect names such as O.Donel / O Donel / O;Donel as duplicates, but after testing, I ...
stackexchange user's user avatar
1 vote
0 answers
25 views

deduper not working with hyphen character in the name (uninformative character)

After testing some specific examples about deduping contacts with the deduper extension, I came to the follwing conclusion : diatrics / accent / lower and upper case are very well taken into acount. ...
stackexchange user's user avatar
1 vote
1 answer
62 views

Create User Record action on a Contact summary page throws error. Is this a bug?

This is with CiviCRM 5.60.0 on Drupal 9.5.5. On the Contact Summary page there is an action to "Create User Record" When this is clicked it gives an error: After this the system shows the ...
user avatar
1 vote
1 answer
44 views

Feature request: Combine log and activities when merging double contacts

When contacts are merged, only the log and activities of one of the contacts are kept. Part of the change history is deleted and this is not always the right way, e.g. for auditing purposes. It would ...
Webmaster COVS's user avatar
1 vote
2 answers
73 views

How are large sites handling duplicate contact scanning?

On sites with fairly small numbers of contacts, running a "Find duplicate contacts" operation on all contacts is not an issue. But as the number of contacts grows, this becomes increasingly ...
TwoMice's user avatar
  • 1,824
0 votes
1 answer
37 views

Form builder: how to prevent duplicate contacts

With Form Builder, do you know how I can prevent duplicate contacts creation with the same name and email? I have not found anywhere how to set the 'dedupe rule' for the contact. Thanks
masetto's user avatar
  • 183
0 votes
1 answer
17 views

Trying To Get A Full Contact Report

There’s been a lot of turnover at my job, which means there are tons of duplicate entries in our civi records. I’m trying to do a reconciliation to remove the duplicates by downloading all the ...
M011y's user avatar
  • 1
0 votes
1 answer
45 views

How can we prevent contact record overwrites once and for all?

I've been working with CiviCRM in Drupal for about 12 years and this issue never seems to go away entirely. Someone, typically the president of an organization (just to make things more interesting) ...
Andrew Wasson's user avatar
1 vote
0 answers
24 views

Can I dedupe by primary email or primary phone only?

I want to dedupe contacts who have the same primary email address (ditto for contacts with the same primary phone). However, I'm not seeing a way to include primary-ness as a factor in a dedupe rule. ...
Lindsey Challis's user avatar
2 votes
1 answer
56 views

Deduping and Merging missing

I am brand new to CiviCRM and trying to clean up a very messy database. I read the user guide for deduping and merging, and it made it seem like this is a built in feature I should find under ...
erin's user avatar
  • 271
0 votes
0 answers
12 views

Contact Editor Extension "Custom Data" error

We installed the Contact Editor Extension to change profiles from an Individual to an Organization and vice versa. We are getting an error that says, "The contact has custom data that is not ...
HPerez4's user avatar
  • 33
0 votes
0 answers
23 views

Is it possible with "Detailed Logging" enabled to perform a revert of a contact merge?

I had a glitch in a script that caused some unwanted contact merges to happen programmatically: $result = civicrm_api3('Contact', 'merge', [ 'to_remove_id' => $existingContactId, 'to_keep_id' => ...
dsmith63's user avatar
  • 419
3 votes
0 answers
51 views

Supervised dedupe rule finds duplicate when manually run but not automatically

I'm running CiviCRM 5.51.0 (the problem was the same with 5.50.4) on WordPress 6.0 I defined a supervised dedupe rule using personalized fields which is properly working (i.e. finds duplicates on one ...
Christophe Destrieux's user avatar
0 votes
1 answer
53 views

Possible Deleted Contact - Trying to Restore Records - Possible SQL Solution?

So here is the issue - that I think was caused by a merger of contacts without transferring the related fields to the new contact. I have a contact, that seems to be missing a large number of ...
themak's user avatar
  • 3,441
3 votes
1 answer
77 views

Allow deletion of contacts but not in trash?

I have the impression that many CiviCRM users share this scenario: They would like to allow everyday users to delete contacts and they are happy about the fact, that in case of mistakes these can be ...
Andreas's user avatar
  • 323
1 vote
1 answer
32 views

Find Contacts Custom Searches Zip Code Range Search lists duplicates

I entered a range of zip codes and the selected records were duplicated. How do I go about reporting the issue to have my request analyzed for an error on my part or get bug fixed?
Bill Davis's user avatar
1 vote
1 answer
88 views

duplicate memberships for the same member

What is the recommendation to deleting duplicate memberships. some members have at least 3 - 10 entries and we want to clean it up. please advise
Gina's user avatar
  • 11
2 votes
1 answer
120 views

Is it possible to "unmerge" two contacts?

Two contacts in my system were accidentally merged. Is it possible to unmerge them and restore all of their respective data to the original states?
dsmith63's user avatar
  • 419
2 votes
1 answer
42 views

Table 'fthdc_civi.civicrm_translation' doesn't exist

This is likely an error that has come about as part of an upgrade. We went from CiviCRM 5.31 to 5.44 about a month ago and everything appeared to go well with the incremental database updates, etc. ...
Rich Smith's user avatar
2 votes
1 answer
26 views

Rule to "Find and Merge Duplicate Contacts" returns unexpected results

I have created a new individual rule, "Test Rule" where the only field (criteria) selected is "Email." I have assigned a weight of 10 to the email field and a total value for the ...
Patrick Masson's user avatar
1 vote
2 answers
115 views

How to merge two Memberships for the same contact?

For some reason I ignore, a few contacts - that have been merged by our client - have 2 identical memberships when they should only have one. I want to merge these memberships but can't find if it's ...
Guillaume Sorel's user avatar
2 votes
2 answers
54 views

Preventing duplicate organisations being created

I wonder if anyone can help me with what I'm missing re duplicate contacts. We have a profile form which also creates a wordpress account - it asks only for first & last name, email, username and ...
Robin Fenwick's user avatar
1 vote
0 answers
10 views

Civimail 'Dedupe by email': Add Activity 'Bulk email' to all contacts (with same e-mail address) not just to 1

An e-mail address is used by 3 contacts. These contacts belongs to a group. Sending a mail by Civimail to the group and tick 'Dedupe by email' works fine: only 1 mail is sent. But only 1 contact (...
Bart Bosman's user avatar
5 votes
1 answer
53 views

Batch marking 'not a duplicate'

Just wondering if it's possible to batch mark multiple contacts as 'Not a duplicate' through the dedupe rule menu. I've tried selecting all the contacts via the checkmark and using 'not a duplicate' ...
Jbeamish's user avatar
1 vote
1 answer
43 views

How to enable multiple bulk email address just for organizations?

The question is about the seeting Enable multiple bulk email address for a contact. in /civicrm/admin/setting/preferences/mailing The problem is that in I have many organizations that have multiple ...
Marko's user avatar
  • 877
0 votes
0 answers
36 views

Datatables Warning in Find and Merge Page

This issue is similar to this one. The only difference is that we are on CiviCRM 5.22.1. Problem The following error pops-up when use the 'Find and Merge Duplicate Contacts' page (civicrm/contact/...
Rupert Raphael Amodia's user avatar
2 votes
0 answers
43 views

Membership issues when people have two different emails

Given how difficult it is to merge two contacts, each with memberships (as detailed in How can I merge two memberships in the same contact (without losing contribution info, etc)?) we are anxious to ...
David Hyman's user avatar
1 vote
1 answer
37 views

What is the best option to merge duplicated membership?

We have some members using similar names to register a membership at different years. What is the best way to merge their membership? Thank you.
Grammy's user avatar
  • 11
1 vote
1 answer
36 views

Why is my phone only dedup not working?

I created a dedup rule "Phone only", and set the only criteria to Phone, weight 30, and threshold 10. (I also tried 1 and 1). It fails to find duplicate contacts that clearly have matching ...
P a u l's user avatar
  • 752
1 vote
1 answer
107 views

DataTables warning: table id=dupePairs - Ajax error

Getting this error when running any merge rule in Civi 5.10.4. I tracked it down to a 502 ajax request failure triggered by this post: admin.php?page=CiviCRM&q=civicrm%2Fajax%2Fdedupefind&...
CiviDan's user avatar
  • 21
2 votes
2 answers
71 views

Merge contacts deletes left hand user in Wordpress

I'm working with a new membership site and have migrated the data. When members renew, if the email address is different, it creates a new contact, as expected. So I have been merging a few contacts ...
user8292's user avatar
  • 111
0 votes
1 answer
173 views

Dedupe rule to reject record rather than creating new record

i understand that you can use the dedupe rule to identify matching record to merge a new record or to create a new record altogether. Is there a means to reject the new record altogether if a match ...
Clement Leong's user avatar
3 votes
2 answers
164 views

Moving contribution from individual to organization

I have a contact in CiviCRM that is of contact-type Individual in CiviCRM. In real life, this is an organization. I want to convert this contact from an Individual to an Organization. How do I do that?...
Flying's user avatar
  • 2,291
0 votes
1 answer
22 views

Modify unsupervised dedupe rule to ignore whitespace?

I have noticed in many occasions, duplicate contact is created just because there’s an extra space in names or a missing one. Just wondering is it possible to setup the unsupervised dedupe rule in a ...
Tapash's user avatar
  • 3,004
2 votes
2 answers
32 views

Cannot merge certain contact pairs - 503 error

I have a few pairs of contacts for which merging fails with an immediate 503 page. For these contacts, merging always fails, while for almost all contacts, it works as expected. A couple errors are ...
Lars SG's user avatar
  • 4,083
0 votes
1 answer
58 views

Dedupe based on custom fields?

My organization contacts can sometimes share the same email address but I have one custom field that is unique to each organization (registration number) and I want to add this custom field to enhance ...
Guillaume Sorel's user avatar
1 vote
0 answers
43 views

Contacts Duplicated on Login for Wordpress

We have been facing a recurring issue where Civi is duplicating contacts. We were able to test and confirm that it happens whenever a person logs in, and then another duplicate contact is created ...
user8186's user avatar
1 vote
2 answers
35 views

Merging only records in a Group

i wanted to just merge records that are in a Group. But the documentation seems to indicate that the records that will be flagged as duplicates will be from where at least 1 of the record is within ...
Clement Leong's user avatar
0 votes
0 answers
35 views

Merge CiviCRM data from D6 to existing D7 database

I need to merge CiviCRM data from a Drupal 6 site into a Drupal 7 site that has an existing CiviCRM installation. The sites are running under Aegir. In both cases the Drupal and CiviCRM tables are in ...
Davy Ivins's user avatar
  • 1,114
0 votes
1 answer
11 views

dedupe rule using birth date is not working using drupal

A dedupe rule using birth date is not working with drupal CMS. I receive the message "unknown error, please contact your administrator". The rule is working well in WordPress
Francesco's user avatar
1 vote
0 answers
26 views

Repeated data entry

I work on a volunteer resource office and we use a CIVICRM to manage our organizations and their volunteer opportunities. The organizations post "activities" in the database, however, those have ...
wandass's user avatar
  • 11
0 votes
1 answer
30 views

What message triggers can be found in the dedupe process?

We a deduping a lot of records, many of which were imported from sources prior to using CiviCRM. Apparently, at least one merged record triggered a change of email notification. Can I kill those ...
LyonsDigital's user avatar
7 votes
3 answers
68 views

Dedupe rule ignores the location type for Email/Phone but does not ignore for Addresses. Should we make this consistent

per the title, what do others think is the better behaviour a/ ignore Location Type for Email, Phone, but use Location Type for Address (status quo) b/ change so Location Type is never taken in to ...
petednz - fuzion's user avatar
  • 28.4k
0 votes
1 answer
72 views

How to trouble-shoot 'critical error' while merging duplicates?

Using civicrm-5.21.2-wordpress.zip, (and also 5.20), I get a 'crash' ('There has been a critical error on your website. Please check your site admin email inbox for instructions.') for any attempt to ...
Mike Steigerwald's user avatar

1
2 3 4 5