5

Dedupe rules are cool, and works well for Individuals, primarily because you have multiple fields to combine.

When it comes to organisations it is more difficult. We focus on individuals but want to register the organisations they work for, so in the profile we use for most on-line registrations (events, subscriptions, ...) we ask for organisation name.

This often leads to multiple organisation records with almost the same name. Typical name variations are

  • Somecompany Inc.
  • Somecompany International
  • Somecompany

Dedupe rules are of limited help here since the best I can do AFAIK is the length of the match.

In Sweden a very common pattern is

  • Ericsson
  • Ericsson AB

I would be extremely happy if there was a way to match the full length except for the last three characters... Or if the match was true if the shorter is a true substring of the longer. Documentation is kind of flakey here, it doesn't say anything about what happens when fields are of different lengths.

Another alternative would be to match to either to the organisation name or the legal name. This would handle most of the above cases and allow me to use the names as (I suppose) they where ment to be used, causal name vs. official/legal/full name.

Actually I have a hard time figuring out how to make the best use the 'length' part of dedupe rules. (I'm a regex guy, so I'm longing for a LIKE-like option, is there one?)

Any suggestions?

3

I happen to have written an extension called the "organisation name de-duplicator". It works by doing certain REPLACE()ments on the names and seeing which ones come out the same. It hasn't had much attention for a while but more rules could be added.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.