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
0 votes
1 answer
25 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 ...
user avatar
  • 3,122
3 votes
1 answer
56 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 ...
user avatar
  • 131
1 vote
1 answer
26 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?
user avatar
1 vote
1 answer
33 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
user avatar
  • 11
2 votes
1 answer
36 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?
user avatar
  • 355
2 votes
1 answer
30 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. ...
user avatar
2 votes
1 answer
20 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 ...
user avatar
1 vote
2 answers
40 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 ...
user avatar
2 votes
2 answers
35 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 ...
user avatar
1 vote
0 answers
7 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 (...
user avatar
0 votes
0 answers
15 views

Is there a way to allow users to merge their own profiles?

Due to poor configuration, our system is bloated with duplicate accounts. Some of the merge conflicts get complex quickly. Is there a technique for allowing users to merge their own (possible ...
user avatar
  • 355
3 votes
0 answers
23 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' ...
user avatar
1 vote
1 answer
24 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 ...
user avatar
  • 867
0 votes
0 answers
30 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/...
user avatar
2 votes
0 answers
39 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 ...
user avatar
1 vote
1 answer
22 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.
user avatar
  • 11
1 vote
1 answer
32 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 ...
user avatar
  • 740
1 vote
1 answer
44 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&...
user avatar
  • 11
2 votes
2 answers
66 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 ...
user avatar
  • 111
0 votes
1 answer
27 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 ...
user avatar
3 votes
2 answers
132 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?...
user avatar
  • 2,231
0 votes
1 answer
19 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 ...
user avatar
  • 2,846
2 votes
2 answers
26 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 ...
user avatar
  • 1,569
0 votes
1 answer
37 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 ...
user avatar
1 vote
0 answers
37 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 ...
user avatar
1 vote
2 answers
34 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 ...
user avatar
0 votes
0 answers
32 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 ...
user avatar
  • 1,103
0 votes
1 answer
9 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
user avatar
1 vote
0 answers
25 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 ...
user avatar
  • 11
0 votes
1 answer
27 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 ...
user avatar
7 votes
3 answers
64 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 ...
user avatar
  • 27.2k
0 votes
1 answer
60 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 ...
user avatar
1 vote
3 answers
135 views

Issue field DEDUPE "0 Argument 1 passed to"

After upgrading to civicrm version 5.21 we detected a problem in one of the fields of the form linked to a custom profile. For some reason, every time you try to insert that data from the form in the ...
user avatar
5 votes
1 answer
64 views

Where does CiviCRM store Merge 'history'?

After Merging Contacts -> dig up a Contact in the Trash bin and you'll see something like: Where does CiviCRM store this information? How does it track which Contact is merged with which Contact?
user avatar
0 votes
1 answer
28 views

Automated New Individual Merge

I am entering "CContacts > Find and Merge Duplicate Contacts > Add Rule for Individuals". I'm adding rules to prevent creating new individual records for both phone and email. However, no matter how ...
user avatar
1 vote
1 answer
55 views

Merging contacts not working

I am trying to merge 2 contacts (individuals). I search for the contact, select both contacts and select merge. Go through the options. A message saying: Contacts Merged, Name has been updated. ...
user avatar
  • 353
2 votes
0 answers
46 views

Batch "Not a duplicate"

Within Civi's UI, there is an option to mark "not a duplicate" when you go through the "Find and Merge Duplicate Contacts" process. I can mark not a duplicate one by one, but I would like to check off ...
user avatar
2 votes
0 answers
44 views

Why is my Unsupervised Individual Deduplication rule failing to stop duplicate creation?

I've seen a number of questions on this site suggesting that there may be problems with the deduplication rules, e.g.: Why am I getting duplicate contacts for contributions? My individual ...
user avatar
  • 3,664
2 votes
2 answers
90 views

Add dupe check parameter to an API call - Contact Form 7 plugin

I've installed the Contact Form 7 CiviCRM integration plugin, and it works fine. I'm just wondering how to add a dupe_check parameter. If I try something like: contact_type=Individual&source=...
user avatar
  • 265
1 vote
1 answer
55 views

Dedupe Rule - blank matches

We have a custom field - 80% of our contacts have this custom field in their profile - the rest are blank. We setup a rule - if 7 characters or more of the custom filed are a match - it meets the ...
user avatar
  • 3,122
3 votes
1 answer
58 views

Unique custom field - contact creation

I want to add a custom field that we use as an ID from a 3rd party. I need to ensure this value is unique as a way to prevent duplicates. What is the best way to do this?
user avatar
3 votes
2 answers
80 views

Deduplicate by name AND surname (or vice versa)?

I'm just starting to use CiviCRM. So I realize that this could be a very dumb question. I'm trying to deduplicate contacts by name AND surname. When I create a new deduplicating rule using name and ...
user avatar
  • 265
0 votes
1 answer
40 views

Preventing duplicate entries from online profile form

We currently have an online profile form in place where new charity members complete their details - This then creates a new charity group on Civi. We are having instances where new members are ...
user avatar
0 votes
1 answer
28 views

How to include validation fields to find user for a contribution page to avoid duplicate?

Although we have taken many different approaches, it was always been an issue with duplicated contact records. What I thought is, if I could include few fields like First Name Last Name Email Post ...
user avatar
  • 2,846
1 vote
1 answer
32 views

Auditing Who Merged Contacts?

Is there any way to audit which admin merged duplicate contacts? I'd like to know who performed the merge, if possible. Thanks.
user avatar
  • 753
1 vote
1 answer
27 views

Deleting duplicate contact

How do you delete a duplicate contact on CRM please? I have looked at the various fields but can't find any deletion button. Kind regards Amanda
user avatar
3 votes
1 answer
74 views

What causes this error on importing email addresses?

I'm getting some (maybe 5%) email address imports rejected with the message "Matching this contact based on the de-dupe rule would cause an external ID conflict" The email addresses in question can be ...
user avatar
  • 4,263
0 votes
1 answer
52 views

DB Error when using dupe_check in rest API

On version 5.6.0, using api v3. Not sure if something recently changed in our environment, but as of a couple of days ago, running the contact create api (via rest or the explorer) causes a "DB Error: ...
user avatar
  • 753
0 votes
0 answers
36 views

If I exclude an address from a bulk email is it rational to assume that the mailing won't go to that address?

It seems rational to me to assume that if a mailing is set up where a group (or past mailing) is excluded, then any records that share the same email address as an excluded record, should also be ...
user avatar
  • 3,664
0 votes
0 answers
42 views

Mailmerge contact of same address & print directly from Civi

There was an extension from vedaconsulting for wordmailmerge extension. But seems its broken in 5.x. Just wondering if anyone can give me a alternative suggestion of how I can achieve the same result ...
user avatar
  • 2,846

1
2 3 4 5