All Questions
Tagged with dedupe or duplicate-contacts
218 questions
0
votes
2
answers
116
views
Unable to add multiple participant registrations for one contact
We use CiviCRM to collect anonymous feedback and equal opps data from event attendees in custom fields connected to an event participant role, and to avoid having to create multiple anonymous ...
- 1,004
2
votes
1
answer
65
views
Problem exporting due to multiple addresses of one location type (e.g. two 'home' addresses)
I have run into a problem where someone created a Webform using Webform_CiviCRM and for some reason added two address field sets to the contact, with the street address in one of them and the city/...
- 8,288
2
votes
1
answer
75
views
Transaction integrity error when merging
I have a vanilla CiviCRM setup which has been running for quite some time.
I'm currently running 4.7.14. When attempting to merge records I get a transaction integrity error (see below for ...
- 63
4
votes
2
answers
80
views
What are the Attributes for the Reserved DeDupe Rules
The reserved dedupe rules don't tell us what they are doing behind the seens. The name and email (reserved) rule says:
This reserved rule is pre-configured with matching fields to optimize
dedupe ...
- 609
2
votes
2
answers
195
views
Make the Contact create API behave like UI in the way in checks for duplicates
I am creating a contact using CiviCRM API, what I have noticed that the duplicate checking looks inaccurate compared to the check done when entering new contacts via the User Interface.
Under the ...
- 31
2
votes
1
answer
404
views
Enable multiple event registration for same purchaser/participant
Currently if a participant purchases a ticket online and then returns at a later date to purchase another ticket, CiviCRM won't allow the same individual to purchase the 2nd ticket under their name. ...
- 111
0
votes
1
answer
43
views
Duplicate Contact Problem
The new individual record is created, written phone number.
When registration opened again with a new phone number can be the same individual.
Telephone number of systems with the same record, I want ...
1
vote
2
answers
188
views
How can I pass CiviCRM first name and last name fields to Drupal API user_save
I am calling the Drupal API "user_save" to create a brand new Drupal user. This does create a new Drupal user. But this user does not have the CiviCRM first name or last name fields set. How can I ...
6
votes
1
answer
82
views
How can I efficiently dedupe a very large number of records?
I'm working on a database with about 600,000 records, of which approximately 200,000 are believed to be duplicates.
Has anyone got experience/advice for doing dedupe at scale? I imagine that we'll ...
- 39.5k
3
votes
0
answers
111
views
Merging contacts and cases
I think I have found an issue with merging contacts (and it also seems to manifest when assigning a different client to a case - which apparently performs a similar merging function).
On the demo ...
- 371
2
votes
1
answer
175
views
Merging memberships issue [duplicate]
When I merge two contact together and each contact has a membership, I need to tick the 'add new' box to keep both memberships. Otherwise one of the memberships is deleted.
However one membership ...
- 275
1
vote
1
answer
95
views
CiviMail not removing duplicate emails
Using Joomla 3.6.2 and CiviCRM 4.7.11 and experiencing duplicate emails in CiviMail. We've tested with contacts with same email address + in same group, resulting in 2 emails received. We've also ...
- 111
2
votes
1
answer
136
views
Question about duplicate matching rule for event registrations
what happens when you select "individualsupervised-supervised" for duplicate matching rule? i have only selected unsupervised rule in the past, and it has caused problems because once the second ...
- 21
3
votes
2
answers
464
views
Using households
We are migrating our homemade contacts-management software under CiviCRM and Drupal and we have some questions about the use of households.
In our current software, we have less than 10 % of our ...
- 141
3
votes
3
answers
152
views
Merge all duplicate contacts (running version 3.4.6)
I'm helping out a nonprofit with their CiviCRM. They have thousands upon thousands of duplicate contacts. These contacts are being pulled from an email service, that is sending the same email, ...
user3540
3
votes
3
answers
233
views
"DB error: already exists" when creating a Drupal user who already exists as a Contact in CiviCRM
I'm running CiviCRM 4.7.10 and Drupal 7.50.
I have had a Civi database for a while, but am now wanting to give people front end accounts in order to use some features there.
My problem is that when ...
- 457
1
vote
1
answer
199
views
User registration creating duplicate contact in CiviCRM
I have a CiviCRM database with lots of contacts some of whom are now going to start creating Drupal accounts. I'm testing the process and have discovered that when I create Drupal user with an email ...
- 457
1
vote
1
answer
65
views
Are custom Dedupe General rules working for anyone?
On CiviCRM 4.7.8/Joomla 3.5.1, I've experimented with variety and can't seem to get this to work. The preset reserved rules, import, inclusive in contact record and main dedupe rules are all working. ...
- 811
1
vote
1
answer
88
views
Exporting deduped information
I need to do a de-dupe on a set of records. Two groups were brought in with different External ID's for each contact. I need to merge the contacts, but export the External ID that was kept and the ...
- 1,146
1
vote
0
answers
41
views
Merge contacts loses relationships
When I merge two contacts I lose relationship info on both 4.6.5 and 4.7.3 The relationships come up as inactive with the current date as the end of the relationship. I don't see any errors except ...
- 305
3
votes
1
answer
55
views
Is it safe to delete multiple membership records after ensuring the Contact record has been merged?
I am working on merging duplicate contact records, which is successful for the most part. However, I am finding that merging the contact record does not remove multiple membership records seen when ...
2
votes
1
answer
78
views
Bulk merge creating multiple address (and email) records of same location type
I'm pretty sure this is not an intended behavior, but I want to make sure.
When I try to add a second address of the same location type I get an error and civi will not let me (Image 1).
If I use ...
- 153
0
votes
1
answer
81
views
Error deduping with custom file field
when deduping contacts holding a custom file field, we're a facing the following error:
One of parameters (value: 5667c1677bca0_3f2cb71777b83d7a5ed1cca5e7dff69f.jpg) is not of the type Integer
From ...
- 1,354
0
votes
1
answer
68
views
Dedupe failing on merge
I am receiving this back trace when trying to merge records after running Individual Supervised dedupe rule. Please advise.
Apr 07 17:51:30 [info] $backTrace = #0 /home/public_html/administrator/...
- 811
3
votes
2
answers
79
views
How can I detect potential duplicates in a CSV I want to import?
I have a list of about 1000 contacts I'd like to import. Unfortunately, there's no definitive way of linking the people on my spreadsheet to the contacts already in the database like an external ...
- 39.5k
4
votes
1
answer
56
views
How does the API deal with the addition of an existing contact?
If you add a contact via the API is it passed through any of the de-duplication rules? I.e. if I add a contact that matches an existing record will it create a new record or merge with the existing ...
- 3,496
0
votes
1
answer
49
views
Batch merge error - wrong data type money?
I'm trying to clean up some duplicates using the batch merge tool, and it keeps showing this error:
[Error: Processed 2 pair of duplicates out of 9]
value: null is not of the right field data type: ...
- 668
0
votes
1
answer
46
views
Why does A/B testing cause 'dedupe by email' to fail when sending CiviMail to contacts with same email address
Client is asking why 4 emails have been delivered to 4 contacts who all have same address.
Test1: tested with 2 contacts and didn't use A/B testing.
Outcome: was told would be delivered to ~1 ...
- 28.7k
0
votes
1
answer
43
views
When users are contributing a duplicate record is created in wordpress
A member when contributing again is not linking to the member but creating a new profile even if name is different? can we have only unique email for member contribution?
2
votes
4
answers
62
views
"Invalid Contact ID" displayed after merge?
Drupal 7, Civicrm 4.7.4
I'm getting this error message after every contact merge. Any ideas?
debug message
CiviCRM_API3_Exception: "Invalid Contact Id"
/var/www/vhosts/example.com/httpdocs/sites/...
- 668
1
vote
1
answer
30
views
is the dupe finder working?
I create a general rule to search my database of 29000 contacts for matching emails - I know there are a few at least, and it says there are none. Also I give it a weight and match that in the ...
- 11
3
votes
2
answers
105
views
Turn deduping off?
Since upgrading from 4.4->4.6 we're having issues with on-behalf-of membership signups. It is very common for our use-case to have people create both an Individual and and Organization with the same ...
0
votes
0
answers
21
views
DeDupe: Prefix with and without period
Seems I've got tons of dedupe hits on prefixes with and without periods, ie, "Dr" vs "Dr."
Any advice on how to deal with this? Was this from various schema updates over the years?
- 811
3
votes
2
answers
109
views
Dedupe rule for organization always firing on membership signup form
Our unsupervised rule for organizations is Organization name with a weight of 10 and the Postal Code length of 3 with a weight of 10 and a weight threshold of 20. We wanted to test behavior on a ...
- 55
1
vote
3
answers
120
views
How can i merge custom fields?
I would like to merge some custom fields in my database. I have a set of custom fields and in this set i have a custom field with multiple options, I will like now to merge some option fields for this ...
- 1,116
4
votes
2
answers
352
views
Multiple contact entries created for WordPress users if they login with non-primary email addresses
We are running WordPress 4.4.2, CiviCRM 4.6.12, and the CiviCRM WordPress Member Sync and CiviCRM WordPress Profile Sync plugins.
Whenever someone logs in with a WordPress user ID / email that is not ...
- 183
1
vote
2
answers
298
views
Event Registration - Duplicate Matching Impossible
Our organizzation is running CiviCRM 4.6.8. We are setting up an event and participants can register online. while configuring the on-line registration page, we get the error:
Duplicate Matching ...
- 709
0
votes
1
answer
95
views
Error when merging records
I'm getting an error when trying to merge any two records. This seems to have started after I deleted a large number of records. Here's the error message the user gets:
Fatal error: Uncaught ...
- 1,047
5
votes
2
answers
110
views
Merge related activities and related groups options not available in merge contacts
We've recently upgraded a site to 4.6.10
When merging duplicate contacts the options to merge activities and groups (and tags and events etc) are missing.
I've tried merging a couple of dummy ...
- 2,037
5
votes
1
answer
114
views
Deduping organizations
Dedupe rules are cool, and works well for Individuals, primarily because you have multiple fields to combine.
When it comes to organisations it is more difficult. We focus on individuals but want to ...
- 1,241
6
votes
2
answers
71
views
In what circumstances is it safe to automatically de-duplicate contacts?
When is it safe (and when might it not be safe) to automatically de-duplicate contacts submitted from a public facing form?
How might a malicious user leverage automatic contact merges to their ...
- 9,892
3
votes
1
answer
71
views
It is possible to deduplicate contacts entered in a Webform?
I haven't found this issue in any other topic, sorry if it's been already asked.
I'm trying to automatically deduplicate contacts which enter to Civi from a registration Webform, but I haven't found ...
- 31
2
votes
1
answer
115
views
DeDupe errors when Individuals have Membership (by relationship)
I have borrowed the title from this unanswered forum post by Laryn: DeDupe errors when Individuals have Membership (by relationship).
Just encountered the same error on a Civi 4.6.9 / Drupal 7 site. ...
- 2,375
2
votes
2
answers
26
views
Is there a Notification Setting associated with "potential" Duplicates
New to CiviCRM and learning the ropes. I know how to search for duplicates and merge them but wondering if when CiviCRM finds a potential duplicate on its own is there a setting where I can be ...
- 31
2
votes
4
answers
301
views
Can the External ID have multiple values
I would like to add multiple values in External ID. Is this possible or would I have to create a new custom field?
Example
2 Duplicate contacts have different external IDs. I want to merge them but ...
- 275
3
votes
1
answer
82
views
Does Veda Consulting's dedupe workflow extension work on 4.7? Or is it now in Core?
Does Veda Consulting's dedupe workflow UI extension,which looks really cool, work on Civi 4.7, Drupal 7?
and if so, from where and how exactly do I install/git clone it? The latest commits are at
...
- 2,749
3
votes
2
answers
402
views
Dedupe Rule not working
My Dedupe rule is not working at all. I have it set to first name, last name, phone all with a weight of 10 and a weight threshold of 30. It appears like it is not working at all. I have many people ...
- 405
1
vote
1
answer
82
views
Importing data with households
I've been attempting a data import for households and contacts on a new civi install, and cannot for the life of me figure out how to import the data and keep civi from creating duplicate records of ...
- 61
2
votes
1
answer
154
views
How to modify unsupervised dedupe rule
In some of my CiviCRM database, i have contacts who share the same email.
I don't want people to modify the wrong contact when filling a public anonymous form.
To avoid that, I'd like the ...
- 2,331
2
votes
1
answer
103
views
Can I use Smart Groups to dedupe?
I am helping someone who is trying to segment their contacts into smaller chunks as they go through to dedupe, so they have created a smart group to try to filter the dedupe rule on. (e.g. a ...
- 8,288