HelpIT

Duplicate Prevention on Entry

matchIT API - plug-in dedupe and data cleansing components

Duplicate prevention & data formatting

Accurate capture of names and addresses can be very time-consuming. First of all, you have to make sure that the customer or enquirer is not already on the database, perhaps by looking up the postcode or name.

Of course, this is not infallible, because the name or postcode may have been entered wrongly, or differ slightly from the information that you have now. Or you may have so many records for that name, that you don't see the record you want.

free trial

for duplicate prevention

If the user first enters the postcode and name for the new record, can perform a fuzzy matching lookup to check whether the record already exists.

In this case, suggests that Tony Shaw could be the same person as Mr A Shore, who is already on the database, with the same postcode. Using its proprietary phonetic algorithm soundIT, knows that Shaw sounds like Shore. Also, through its user-defined lookup tables, it knows that Tony is a short form of Anthony. Alternatively, the user may want to consider Tony Shaw at a slightly different postcode as a match.

speeds up data capture and improves formatting

When a new record needs to be added, entering each name and address element into its correct field and ensuring it is correctly cased needs careful attention to detail. Staff training is a costly and lengthy process. And no matter how effective the training, human error will always be a factor.

If the record does not exist, the data entry form can be simplified and the user can enter the data all in lower case. intelligently splits the name into prefix, first and last names and at the same time, cases it correctly. It also creates a salutation and addressee field.

Here, determines that Kevin is male and that "ceng" is a qualification, to enable it to split out name fields as required. It also cases the data and expands abbreviations.