This project is read-only.

Match name plugin

Why do you need it

We've noticed the CRM Duplicate detection doesn't allow for much creativity, you can only create Duplicate Detection Rules with the following condition:
  • full string match
  • begins with (number of characters)
  • ends with (number of characters)

The problem with this is that people or companies aren't always entered in the same format. For instance if you look at our company name we would create the account with the name "Orbit One". Other people might write "Orbit One BVBA" (the bvba part is a type of business entity)

There are some other examples that come to mind:
"Dell NV" vs "Dell"
"HP Belgium" vs "HP"
"Gaëtan" vs "Gaetan"
"François" vs "Francois"

These exceptions will never be caught by the default CRM Duplicate detection.

How can I fix this?

We added the following attributes and filled the with data:
  • on account => new_matchname (contains the accounts name)
  • on contact => new_matchname (contains the contacts first + lastname)
  • on lead => new_matchcontact (contains the leads first+ lastname)
  • on lead => new_matchcompany (contains the lead company name)

The fields are filled with a normalized name. The process is:
  • to lower case and trim.
  • replace special characters (except parenthesis, a-z, 0-9, special characters like éèàç ..., and spaces) with empty string.
  • remove everything between the parentheses eg: "HP (was Compaq)" becomes "HP"
  • remove suffixes and prefixes that are type of business entity
  • remove all spaces
  • replace special characters (eg: é > e, à => a, ç => c, ñ => n, ...)

Next there need to be some new duplicate detection rules.
  • full string match on new_matchname for contact
  • full string match on new_matchname for account
  • full string match on new_matchcontact for lead (add companyname if needed in your specific cases)

The current implemented type of business entity which will be stripped are:
  • nv
  • sa
  • vzw
  • bvba
  • cvba
  • sarl
  • sprl
  • scrl
  • nvsa
  • bv
  • llc
  • gmbh
  • ltd
  • ag
  • kt
  • og
  • vof
  • cvoa
  • commva
  • commv
  • ebvba
  • ez
  • belgium

Some screenshots

DuplicateDetectionRulesForMatchNamePlugin.jpg

ContactDuplicateDetectionRuleWithConditionsForMatchNamePluging.jpg

Last edited Oct 9, 2009 at 9:16 AM by wdeconinck, version 2

Comments

fredriknelson Feb 9, 2010 at 3:48 PM 
Super nice! very well done!

kmaranganti Nov 20, 2009 at 5:55 PM 
Can someone help me with the installation ? I am getting a fatal error but unable to capture the error as the command window closes.

wdeconinck Oct 9, 2009 at 9:14 AM 
Hi, I'm afraid not. The plugin system has changed quite alot between CRM3 and 4. Grtz

vonigarrett Oct 8, 2009 at 4:51 PM 
Hello, can this plugin be used in Microsoft Dynamics CRM 3.0 also?