All Questions
Tagged with duplicate-contacts dedupe-rules
9 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
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
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
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
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
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
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
7
votes
3
answers
69
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 ...
- 28.7k