Merging Duplicate Records Made Easy

Merging Duplicate Records Made Easy




March 20, 2018

Last modified: 

A key challenge while maintaining constituent information (on Almabase or on your database) is avoiding duplicate records of the same person. Duplicate records can happen for various reasons and it’s important to have an easy and predictable way to fix those.

That's why we decided to bring in some changes and enhancements to the feature.

Predictable merge process

Thanks to your feedback, we understood that our current merge process was very unpredictable. You couldn't be sure of what information is being used and what isn't.

That's why we introduced a new review screen. This is where you can review and decide what information you want to keep, and what you'd like to ignore while merging.

The review screen provides you complete visibility into what information is being merged

Segregating registered users from other profiles Most duplicates are created when users sign up with different email IDs and the system can’t detect that it’s the same person. Since merging these duplicates is important, we created a section where you can access all such pairs first.

All you need to do is, log in to your admin dashboard, go to “Users” > “Duplicates”

Duplicates page

You can also swap which record to keep and which to remove on this page.

Enhancing the confidence score

We improved the algorithm that was being used to compute the confidence score associated with each pair. There were a few key factors that weren’t given enough weight in the earlier algorithm. You’ll notice that the confidence score is a much better reflection of two records being potential duplicates now.

All of these enhancements are already live on your Almabase platform. Go ahead and give it a shot now!

We’re always looking for ways to make your processes simpler and this is yet another step in that direction. Let us know if you face any challenges with duplicate records and we’ll be happy to help you out!

Pro tip: You can also find a duplicate record from an individual person’s profile page using the “Merge Profiles” button. Visit any profile from the directory to try it out.

Oops! Something went wrong while submitting the form

No items found.

Related Blog Posts


How to: Quick lookup your alumni directory on Almabase

Every time you need to look up someone on your database, you would normally need to open your web browser, go to your alumni website, log in if you aren't already, and use the quick search bar on your homepage to look somebody up. If you have to do this often, we have a few things you could do to make this a whole lot easier.


Social Sync 2.0 - An updated alumni database, always!

We just launched the next version of social sync. It is more intuitive and provides much more control to users and uses the latest APIs.