8
votes
Accepted
Can the External ID have multiple values
The External ID field isn't just a regular field--it allows matching by ID alone. It would be a waste to have External ID be concatenated fields, for a couple of reasons:
You can't search easily. ...
- 7,422
8
votes
Dedupe Rule not working
Perhaps the best free explanation of CiviCRM's deduplication is from the CiviCRM blog last year (July 31, 2014): Understanding CiviCRM Dedupe Rules
For the whole process, I will let the author speak ...
- 4,994
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-...
- 2,341
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 ...
- 38.4k
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.
- 21.4k
6
votes
Accepted
How to modify unsupervised dedupe rule
On our site we simply created a new rule, and chose the 'Unsupervised' option when creating it.
That creates the rule, and marks it as the default 'Unsupervised' one. The old default is downgraded to ...
- 1,922
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-...
- 38.4k
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 ...
- 38.4k
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 ...
- 2,706
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://...
- 21.4k
5
votes
Dedupe Rule not working
You don't say what version of CiviCRM you are on, and you do say this is occurring on both contributions and on event registrations, but I will note here (for those happening onto this related issue) ...
- 2,465
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 ...
- 38.4k
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 ...
5
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/ ...
- 4,994
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 ...
- 38.4k
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 ...
- 4,585
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 ...
- 15.1k
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 ...
- 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.
- 3,461
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--...
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 ...
- 38.4k
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 ...
- 12.8k
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 ...
- 38.4k
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 ...
- 38.4k
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
- 29.4k
4
votes
Moving contribution from individual to organization
Alternatively - you can try install/use:
https://civicrm.org/extensions/move-contribution
- 15.1k
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....
- 21.4k
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 ...
- 38.4k
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 ...
- 2,933
3
votes
Deduping organizations
I happen to have written an extension called the "organisation name de-duplicator". It works by doing certain REPLACE()ments on the names and seeing which ones come out the same. It hasn't had much ...
- 1,517
Only top scored, non community-wiki answers of a minimum length are eligible