How do I merge duplicate user profiles?

A:

NationBuilder pulls people's information from a lot of different places, and while we try very hard limit the number of duplicates that will appear in your database it will occur from time to time. Sometimes the information people provide in a sign-up form doesn't exactly match up with their Facebook account, or they login to your website with twitter for the first time and then someone on your staff manually enters their data from an event sign-in, it happens. Luckily NationBuilder makes it easy to merge duplicates. 

If you spot a duplicate, the first thing you want to do is decide which control panel profile is the one you want to be merged into the other. One way to decide is to see which one has less information on it. Another way to decide is which profile has existed in your database for longer. NationBuilder will not delete any information from either profile but it is still helpful to have one be the "master" profile.

 Once you've decided on a "master" profile for this person, go into that profile and look at the persons NationBuilder ID number at the very end of the url. Example:

 http://abeforprez.nationbuilder.com/admin/signups/12746

Copy that number, and then go to the person's "lesser" profile (aka the duplicate). Go to the Edit tab and at the bottom of the page you will see the "Is this a duplicate?" field. Paste the NationBuilder ID of the "master" profile into this field and click Save Person. It may take a few moments, but NationBuilder will merge the two and keep all of the data.

Screen_shot_2011-03-09_at_10.10.59_AM.png 

Was this helpful?

Showing 2 reactions


Jim Gilliam commented 2012-03-07 07:21:08 -0800
Donald – Can you give us an example of that, cause that’s not what should be happening. There is specific code to transfer the civicrm_id (along with all the other fields) over to the primary as long as the primary doesn’t already have it.
Donald Darnell commented 2012-03-07 07:16:54 -0800
I notice that if I use this method to combine two records when the “master” profile has no CiviCRM ID and the “lesser” does have one, the CiviCRM ID is lost. (Eek!) Sometimes we have a volunteer or donor wish some history which is later identified as a voter too, with a CiviCRM ID to identify them. It sure would be nice if deduping would always preserve the data (i.e. let the lesser override the master if the field in the master is blank).
Join our team
We're hiring great software developers and organizers. Learn more →