CRM Import Management

[simonen]

Over the years I have found it very difficult to maintain consistent data entry from importing contact lists into our CRM (customer relationship management system). Trying to keep consistency on company spelling, city spelling and the best way to determine duplicate records before import.

I am curious to know if anyone has come up with a good model to perform field comparisons that can account for spelling variations and naming inconsistencies to help identify a duplicate contact before transferring those contacts into their main customer list.

I think it would be a quite complex script, however if anyone knows of a good place to start, I would find that most helpful.