Merging Duplicate Records in CDM+

If you ever have a scenario where a giver has two or more Giving Unit Records in CDM+, you can merge these records together so that you can manage all of the Giving Unit's gifts under a single record. Keep in mind that since Giving Unit Records are tied to an Individual and Address Record, you will need to merge their Individual Records and delete the additional Address Records you no longer need when cleaning up these records. When merging, make sure to start with the Giving Unit Record first before merging the Individual Records and cleaning up the Address Records. 

Merging Givng Unit Records

1. To navigate to Giving Unit Records go to Program → Contributions → Giving Unit Records.

   

2. In the Giving Unit Record window, select All from the left sidebar and then click the Giving Unit Last Name column header to automatically sort the givers by alphabetical order. This will make it easy to spot duplicates. You can also setup a find, if you know which records you want to merge together. 

   

3. Next, you'll want to select the records that you want to merge together.
   
   Click to highlight the first record and then hold down the Control key for windows, or Command key for macOS, and click the second record. If there are more than two, you can select all the records you wish to merge. You will then see a Merge option appear on the left sidebar. Click Merge to begin. 

   

4. In the next window, you will see the list of records that you are going to merge together. Click and drag the record you want to use as the final record to the dotted box and then click Next. 

   

   

5. Fields highlighted in blue will be in the final record. You can make any changes to these fields by clicking the edit pencil. When the final record is set, click Next.

   

6. In the next window, you will see all the associated data that will be merged under the final record. When ready, click  Merge to continue to merge the records together. 

   

7. You will see a pop-up asking you if you want to proceed. Click Yes. 

   

8. You will then get a message that the records have successfully been merged. You can then click Close. 

   

Merging Individual Records

After you merge the Giving Unit Records together, you will want to merge the associated Individual Records.

1. To make sure you are merging the correct Individual Record tied to this Giving Unit Record, from the Giving Unit Record window, click the Individual jump button from the left sidebar. 

   

2. In the Individual Record window, you will want to mark this record so you know that this is the record that is tied to all of the merged Giving Unit Records. To do this, click  Change from the left-hand side menu. 

   

3. In the Last Name field, put an indicator such as the #1 or "K" for keep so that you can easily spot this record. Then, click Save in the upper left-hand corner to save your changes.

   

4. Now, setup a find to search for all the Individual Records that you want to merge. 

   Make sure you use the find qualifier "contains" or "begins with" so that your find will pick up all necessary records. 

   

5. Before you can merge the Individual Records together, only one record can have Online Credentials. You will need to clear the online credential for the Individual Records that will be merged under the main record.
   

Tip:To be able to easily see which records have a username, you can configure your results window to display the username. 

Make sure you clear the credentials for the record that you did not mark as the main record tied to the merged Giving Unit Record. 

To clear the online credentials, click to highlight the record and then click on Clear in the Online Credentials box. 

6. You'll get a pop-up asking you to confirm you want to clear these credentials, click Yes. 

   

7. Now you're ready to merge the Individual Records together.
   
   You'll want to select the records that you want to merge together. Click to highlight the first record and then hold down the Control key for windows, or Command key for macOS, and click the second record. If there are more than two, you can select all the records you wish to merge. You will then see a Merge option appear on the left-hand side menu. Click this option to begin the process. 

   

8. In the next window, you will see the list of records that you are going to merge together. Click and drag the record that you marked to use as the final record to the dotted box and then click Next. 

   

   

9. Fields highlighted in blue will be in the final record. You can make any changes to these fields by clicking the edit pencil. Here you can remove the indicator that you used to mark this record as the one tied to the merged Giving Unit Record. 

   When the final record is set, click Next.

   

   

10. In the next window, you will see all the associated data that will be merged under the final record. When ready, click Merge to continue to merge the records together. 

    

11. You will see a pop-up asking you if you want to proceed. Click Yes. 

    

12. You will then get a message that the records have successfully been merged. You can then click Close. 

    

Deleting Extra Address Records

You cannot merge Address records together. However, since you have already merged the attached Giving Unit Record and Individual Records, you can delete the Address Records that no longer have records tied to it. 

1. From the Individual Record window, click on Address from the left sidebar. 

   

2. This will take you to the Address Record that is tied to the merged Individual and Giving Unit Records. To find the other records that you want to delete, setup a find and search for the other records. 

   

3. On the Address Record that is tied to the Individual and Giving Unit Records you merged, you will see the Individual and Giving Unit jump button on the left sidebar. 

   

4. On the Address Record that you want to delete, you will not see an Individual or Giving Unit jump button. This helps to confirm that there are no records tied to this account.

If you do see Individual and Giving Unit jump buttons under multiple Address Records for this giver it is likely that you did not merge all of the needed accounts together. We would encourage you to start back at the top to make sure the records you want merged, are merged together.

5. For the record where there are no attached Individual and Giving Unit Records (no jump buttons) click Delete from the left sidebar. If there are more that one Address record you can highlight more than one record and delete them at the same time. Just ensure that none of the Address Records you are deleting have any attached Individual or Giving Unit records. 

   

6. You'll see a pop-up asking you to confirm that you want to delete this giver and all related records. Click Yes. 

   

7. You'll then see a window appear that will show the process of these records being deleted. 

   

   
   

8. You then see a window letting you know that the deletion is complete. Click Close. 

   

9. Lastly, you'll see a pop-up box letting you know that by closing this window, these records will no longer be able to be restored. Click Yes, to finish deleting these records. 

   

10. Then your merging process is complete!