All Questions
Tagged with dedupe or duplicate-contacts
218 questions
0
votes
1
answer
32
views
Where does the "INSERT INTO civicrm_tmp_e_dedupe_" come from?
Something kills/freezes MySQL once per cron by executing:
INSERT INTO civicrm_tmp_e_dedupe_301d41956c9e2bd93bf184f95b40adef (id1, id2, weight) SELECT id1, id2, weight FROM (SELECT t1.contact_id id1, ...
- 2,186
0
votes
0
answers
15
views
Bug? Relationship lost when merging if both contacts have the same relationship with the same contact
I recreated this on the sandbox site:
Edit the employee relationship on the contact "Alabama Action Fund". Add a relationship start date (like a year ago) and an end date (like a month ago)....
- 353
3
votes
3
answers
39
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 ...
- 271
1
vote
1
answer
97
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 ...
- 71
1
vote
0
answers
25
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 ...
- 943
0
votes
1
answer
59
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 ...
0
votes
2
answers
42
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 ...
- 45
0
votes
0
answers
39
views
How do I merge duplicated contacts?
I am having problems with merging contacts. Some contacts have merged but others have not.
- 1
1
vote
0
answers
42
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 ...
1
vote
0
answers
28
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.
...
1
vote
1
answer
66
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 ...
user6274
1
vote
1
answer
47
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 ...
- 457
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 ...
- 1,856
0
votes
1
answer
46
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
- 217
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 ...
- 1
0
votes
1
answer
65
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) ...
- 717
1
vote
0
answers
25
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. ...
- 123
2
votes
1
answer
63
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 ...
- 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 ...
- 33
0
votes
0
answers
26
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' => ...
- 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 ...
0
votes
1
answer
66
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 ...
- 3,553
3
votes
1
answer
83
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 ...
- 353
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?
- 13
1
vote
1
answer
97
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
- 11
2
votes
1
answer
144
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?
- 419
2
votes
1
answer
46
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.
...
- 362
2
votes
1
answer
27
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 ...
1
vote
2
answers
130
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 ...
- 2,655
2
votes
2
answers
59
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 ...
- 660
2
votes
0
answers
13
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 (...
- 21
5
votes
1
answer
60
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' ...
- 91
1
vote
1
answer
58
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 ...
- 897
0
votes
0
answers
37
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/...
2
votes
0
answers
47
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 ...
- 363
1
vote
1
answer
43
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.
- 11
1
vote
1
answer
43
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 ...
- 752
1
vote
1
answer
111
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&...
- 21
2
votes
2
answers
73
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 ...
- 111
0
votes
1
answer
243
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 ...
- 665
3
votes
2
answers
171
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?...
- 2,343
0
votes
1
answer
23
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 ...
- 3,014
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 ...
- 4,093
0
votes
1
answer
59
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 ...
- 2,655
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 ...
- 11
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 ...
- 665
0
votes
0
answers
38
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 ...
- 1,114
0
votes
1
answer
15
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
- 21
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 ...
- 11
0
votes
1
answer
36
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 ...
- 633