Trail Blazer Knowledge Base

 

Home : General : How to 'Manually Merge' Duplicate Contact Records with Drag-and-Drop

Knowledge Base







User:

Password:



Article ID: KB251
Keyword Name: Merge, Merging, Duplicates, Cleanup, Dupe, Manual, Drag-and-Drop,dedupe, duplicate
Created: November 01, 2017
Viewed: 19332

How to 'Manually Merge' Duplicate Contact Records with Drag-and-Drop




Click Here to view this article as a PDF.





Author: Kristenson, Joel

Last Updated: 2016-10-04






Overview


This article walks through the steps to perform a manual drag-and-drop merge of duplicate contact (voter/donor) records.


It also shows how to view the log notes in the contact’s record card afterwards to see what happened during the merge.  When you run the merge the system will retain all relevant information from both records (without duplicating it), such as contributions, contact info, attributes, notes, etc.



http://www.us-cert.gov/sites/default/files/images/tip-icon.pngTip: It’s good practice when cleaning up your database to:

1) Conform All Address to Meet the Postal Code Standard

2) Find Possible Duplicates by Partial Name, Address, and/or Birthdate

3) Find Possible Duplicates by Primary Email Address






Steps


Navigate to the Contacts (Voters/Donors) list.



Run your search query to pull up the duplicates so they are both displaying in the list.  In my example I pulled up duplicate ‘Bob Smith’ records with the same home address.



Click on the row for the record that you *don’t* want as the primary record so that the row turns blueIn my example I highlighted the record with the higher ‘ID’, which means it’s a newer record, which I’ll merge into the record with a lower ‘id’.



You can click-and-hold just about anywhere on the row to begin the process—I prefer to click the small black triangle icon on the far-left of the highlighted row.  Click and hold for about 3-4 seconds.



Slowly drag-and-drop the source contact record onto the target contact record.  A small rectangle icon will appear under the mouse cursor if it’s working correctly.



When you release the source record into the target record you’ll get a pop-up screen with all the details about what’s going to take place.  After verifying the information, check the box in the lower-left, and click [OK].



If the merge is successful the duplicate contact record will disappear.  *If it fails you’ll get an error message as to why.  My example is below.



To view the details of the merge click on the contact’s name to open their record card.



Navigate to the Logs tab > Log sub-tab, click the [Show Suppressed] button, and you’ll be able to view the details of the merge in the text box at the right.  My example is below where you can see the contact record has now been merged twice, the Log Type is recorded as ‘Combine Comment’.



If you make a mistake going through these steps, the roll-back tool will be your friend (if you catch it soon enough)—measure twice, cut once.


That concludes the steps, repeat until all duplicates are cleaned up.


The related resources below link to a variety of similar articles and videos on keeping your database tidy.  If you have any concerns going through these steps please call our live tech support.















Related Resources


Article: Find Possible Duplicates

Article: Rollback – Undo Function

Article: How to Find Duplicate Contact Records by Identical *Primary* Email Address, and Automatically Merge them Together

Article: Auto-Merge Duplicate Contact Records

Article: Auto-Merging Duplicate Address Records

Article: How to Merge Attributes

Article: Automatically Conform Addresses

Article: Why won’t some of my records merge?

Article: Managing Households – Creating, Deleting and Re-Creating

Article: Address Management

Article: Address Normalization (unlimited addresses per person)

Video: How to Manage Duplicates

Video: Households – What To Do B4 Householding!!

Video: Households – Delete and Recreate





Trail Blazer Live Support


http://www.somebodysattic.org/images/phone%20icon_lower%20rez.jpg  Phone:  1-866-909-8700

http://sisyphus-js.herokuapp.com/assets/email_icon-0f32f4da45c2822cbb02fb36f9b9429e.png   Email:  support@trailblz.com

   Facebook: https://www.facebook.com/pages/Trail-Blazer-Software/64872951180

   Twitter: https://twitter.com/trailblazersoft



* As a policy we require that you have taken our intro training class before calling or emailing our live support team.


Click here to view our calendar for upcoming classes and events.  Feel free to sign up other members on your team for the same training.


* After registering you’ll receive a confirmation email with the instructions for how to log into the GoToMeeting session where we host our live interactive trainings.


* This service is included in your contract.



 

Are you ready to learn more? Contact Us