Skip to content

CRM 2011 Duplicate Detection Toolkit available in Codeplex

August 1, 2011

The way CRM 2011 handles duplicates had always been a bit of a mystery to me. Detection of duplicates through matchcodes is quite straightforward, but reporting on them and understanding the effectiveness of de-duplication rules is difficult, and this is compounded by the CRM 2011 UI, which allows to check duplicates only one by one.

So I decided to do a little research, which resulted in this codeplex project: CRM 2011 Duplicate Detection Toolkit.

The project contains a set of stored procedures that allow to get a list of duplicates that can then be consolidated in a report. At a minimum, one can see how duplicates are related to each other by looking at the queries. This is not for the faint-hearted, you need to have some good understanding of the CRM 2011 data structure and, of course, of T-SQL.

Have a look at this post: CRM 2011 and Duplicate Detection for more information about duplicates.

Happy de-duplicating!
Alberto “Taking-it-apart” Gemin

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: