Skip to main content
Share Your Experience: Take the 2024 Developer Survey
7 votes

Merge known duplicate

Welcome to CiviCRM SE. You can merge the contacts manually via search results. Here is a link to the specifics: https://docs.civicrm.org/user/en/latest/common-workflows/deduping-and-merging/#merging-...
KilakwaBT's user avatar
  • 2,351
7 votes

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

Yes - go to Contacts menu ยป Find and Merge Duplicate Contacts. There is dedupe documentation available. The tricky question is, "What represents a duplicate contact?". For some organizations, two ...
Jon G - Megaphone Tech's user avatar
7 votes

Unique custom field - contact creation

The "external identifier" field on contact records is available so you don't need a custom field. It won't allow duplicates.
Demerit's user avatar
  • 23.1k
6 votes
Accepted

Allow duplicate contacts with the same email

You will want to adjust your Deduping and Merging settings (top menu > Contacts > Find and Merge Duplicate Contacts). See https://docs.civicrm.org/user/en/latest/common-workflows/deduping-and-merging/ ...
Allen Hutchison's user avatar
6 votes

Import Contacts with dedupe rules

The import code's use of dedupe rules as of this writing (Civi 5.1) is...interesting. The rules, which are defined in CRM_Contact_Import_Parser_Contact::getPossibleContactMatches involve short-...
Jon G - Megaphone Tech's user avatar
6 votes

Deduping within contact records

2019 UPDATE: A year later, I had to revisit this problem space, and I improved on my old answer; ignore earlier discussion threads on this answer. When deleting duplicated emails/phone/addresses ...
Jon G - Megaphone Tech's user avatar
6 votes
Accepted

100s of duplicate contacts created of current user when using CiviCRM

I have seen this when the uf_match table does not have the proper values for WP Id (uf_id), Contact ID (contact_id) and email (uf_name). I don't know why this occurs, I've not been able to track it ...
Kevin Cristiano's user avatar
6 votes
Accepted

Where does CiviCRM store Merge 'history'?

An activity gets recorded when you merge and it looks up the target contact via that. Use $winnerContact = civicrm_api3('Contact', 'getmergedto', ['contact_id' => $contactId]). See also https://...
Demerit's user avatar
  • 23.1k
5 votes

What are the Attributes for the Reserved DeDupe Rules

Pete's answer should be correct, but reserved dedupe rules don't work like normal rules. The original assumption: First name, last name and email must all be identical - is correct. Dedupe rules ...
Jon G - Megaphone Tech's user avatar
5 votes

Error message when merging contacts

This happened to us, and it turned out that we didn't have a "supervised" dedupe rule defined for individuals. You can have at most one "supervised" and one "unsupervised" dedupe rule. Our supervised ...
Patrick Lesslie's user avatar
5 votes

Force Batch Merge All Duplicates

I ran into a similar problem today. My solution requires some tech chops, but was very effective: Install cv on the server if you haven't already. Create a text file named forcemerge.php on the ...
Jon G - Megaphone Tech's user avatar
5 votes

Merging two contacts

To merge 2 contact records, select both contacts from a list then select the action 'Merge contacts' from the 'Actions' drop down. In the resulting screen you will see there are several options that ...
Andy Clark's user avatar
  • 4,845
5 votes

Why can I no longer Merge Contact records in 5.7.3?

So I looked at the civicrm email records of the two contacts that produce such an error and they look fine. Alan figured out that this is a bug: during the merge process when data is being gathered ...
KarinG - Semper IT's user avatar
5 votes
Accepted

Can you create a dedupe rule to include individual and organisation details

The short answer is no. Dedupes for individuals and oranisations are handled separately in Civi. I'm assuming (and feel free to correct me if I'm wrong) you've got an event booking profile for an ...
Craig Almond's user avatar
  • 2,037
5 votes

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

B please. This has been a point of frustration when importing. Make the location type simply a label without deduping consideration. I thought it always takes into account location type.
Andy Burns's user avatar
  • 3,681
5 votes

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

The results of the search lists the "primary" email associated with the contact record. While the primary email presented in the search may not match, viewing the individual contact details--...
Patrick Masson's user avatar
4 votes
Accepted

Something is seriously wrong with CiviCRM - Replicating Contacts

You can change the email account associated with a WordPress (or other CMS) account by editing the "UFMatch". If you're SQL-savvy, the correct table is civicrm_uf_match. If you want to do it through ...
Jon G - Megaphone Tech's user avatar
4 votes

Deduping between Individuals and Organisations

You can change a contact's type either by the API or (safer) using the contact-editor extension. Obviously once you fix the types the dedupe rules will work better for you - but I don't know of an ...
Aidan's user avatar
  • 13.5k
4 votes
Accepted

Reserved de-dupe rules

Demerit's and Mick's answers are incorrect for the (built-in) reserved rules - though it's definitely confusing! If a RuleGroup has a value in the name field, and that name corresponds to a filename ...
Jon G - Megaphone Tech's user avatar
4 votes
Accepted

Alerting admins when certain fields are changed via profile & checksum?

If you have hosting that allows you to turn on Detailed Logging, there are two extensions that provide address history. One is in Extended Reports; the other is Joseph Lacey's Address Log report. It ...
Jon G - Megaphone Tech's user avatar
4 votes

Moving contribution from individual to organization

Run below query in mysql UPDATE civicrm_contact SET contact_type = 'Organization', organization_name = sort_name WHERE id = 123; 123 is a contact id
Pradeep Nayak's user avatar
4 votes

Moving contribution from individual to organization

Alternatively - you can try install/use: https://civicrm.org/extensions/move-contribution
KarinG - Semper IT's user avatar
4 votes
Accepted

Table 'fthdc_civi.civicrm_translation' doesn't exist

It sounds like the upgrade didn't fully work. It gets created as part of 5.39: https://github.com/civicrm/civicrm-core/blob/bbc91a6b38e98b488867a3438d0ac0ee3f4f03c6/CRM/Upgrade/Incremental/sql/5.39....
Demerit's user avatar
  • 23.1k
3 votes

Merge all duplicate contacts (running version 3.4.6)

One Option: The easiest way I have found (in 4.6.4) is to export like you said, with contact ID, do your manipulation in excel to pull out the records you would like to keep, and re-import the records ...
Eli Lisseck's user avatar
  • 1,499
3 votes

Is it safe to delete multiple membership records after ensuring the Contact record has been merged?

It is okay to delete a duplicate membership, but if there is a payment associated with that membership record, that payment will also be deleted. If that is an issue, you may want to consider creating ...
jehanley's user avatar
3 votes

Turn deduping off?

Either change the unsupervised dedupe rule or create a new one where the conditions can't be met. So change the "Weight Threshold to Consider Contacts 'Matching':" number to something higher than ...
Paul-Tahoe's user avatar
  • 2,965
3 votes

Multiple contact entries created for WordPress users if they login with non-primary email addresses

The issue outlined in the question and comments doesn't exist in the latest version of CiviCRM. Penny mentions that the issues results because "When a Wordpress User is deleted, the WP User ID is not ...
Jon G - Megaphone Tech's user avatar
3 votes

When users are contributing a duplicate record is created in wordpress

This should be able to be controlled via your Matching Rules. I would suggest you read up about them and look at your DeDupe/Matching rules at civicrm/contact/deduperules?reset=1
petednz - fuzion's user avatar
  • 28.3k
3 votes

How can I detect potential duplicates in a CSV I want to import?

I like Allen's answer but it seems there should be an approach at the point of import that would work. Esp if you had a gazillion contacts in the db already. Is the issue here is that the potential ...
petednz - fuzion's user avatar
  • 28.3k
3 votes
Accepted

"Invalid Contact ID" displayed after merge?

Ah - if the contact id doesn't exist perhaps delete to trash is off?
eileen's user avatar
  • 2,334

Only top scored, non community-wiki answers of a minimum length are eligible