All Questions
Tagged with dedupe or duplicate-contacts
218 questions
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
1
vote
3
answers
151
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
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, ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
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 ...
- 2,343
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 ...
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' ...
- 3,711
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 ...
2
votes
2
answers
193
views
100s of duplicate contacts created of current user when using CiviCRM
I have recently migrated a CiviCRM instance from Joomla to Wordpress, everything went smoothly.
The installation is using CiviCRM 5.7.2 and PHP 7.2.
We're now seeing a peculiar problem where, when ...
- 1,856
5
votes
3
answers
358
views
Wordpress duplicates my contacts
I haven't quite worked out under which circumstances, but our WordPress (4.0.1) and Civi (4.5.2) seems to create duplicate contacts for the same WordPress user. I think it happens when they log in, ...
- 1,856
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
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 ...
- 3,711
2
votes
1
answer
322
views
How can I prevent spam bots from making submissions to CiviCRM?
I ALREADY had reCaptcha enabled in Civi and on my Profile type, but it seems that spam bots were still making submissions to CiviCRM and creating contacts (and got assigned to a group).
I only ...
- 8,288
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 ...
- 4,093
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) ...
- 4,093
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 ...
- 24.7k
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 ...
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 ...
- 2,037
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?
- 39.5k
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
- 3,711
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?
- 24.7k
4
votes
2
answers
207
views
Force Batch Merge All Duplicates
I have around 900 pairs of contacts I want to force merge. From my attempts to do this, if you click "merge all duplicates", it will simply display "900 pairs skipped" and not give you the "force ...
- 419
6
votes
4
answers
177
views
How do I find duplicate contacts by nickname?
Here's an example of a very common situation I have:
Database has a contact like this
first name: Robert
nick name: Bob
last name: Smith
email: [email protected]
...
Event registration form ...
- 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.
...
- 24.7k
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 ...
- 426
0
votes
1
answer
119
views
Error when merging accounts
When attempting to merge accounts, I receive this message:
CiviCRM_API3_Exception: "You have requested a non-existent service "prevnext.driver.". Did you mean one of these: "prevnext.driver.redis", "...
CommunityBot
- 1
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 ...
- 24.7k
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
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&...
- 419
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 ...
- 3,227
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/...
8
votes
2
answers
149
views
Deduping within contact records
I've noticed that some of our contact records have the same email duplicated (e.g. as 'home' and 'work' or 'main' and 'work' emails). I'm not seeing a simple way to find these records so we can clean ...
- 39.5k
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
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
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.
- 3,496
7
votes
3
answers
208
views
Import Contacts with dedupe rules
Recently I have encountered a problem related to the import of contacts and has to do with the dedupe rules.
When you import a list of contacts through a CSV file and select a dedupe rule, the CRM ...
- 187
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 ...
- 3,637
8
votes
1
answer
152
views
Can form submissions dedupe and "fill" instead of "override"?
while deduping in a contact import, you can choose whether you want new data to "fill" or "override".
is there a way to enable this feature for a form submission?
example would be ...
- 131