Introduction

                

 

Welcome to the Duplicate Record Remover from Precision Data.

The Duplicate Record Remover can examine your customer and contacts database and find duplicate contacts, addresses, customers, clients, students, patients, members, subscribers, users, staff, etc...

It identifies duplicate contacts using an advanced fuzzy-logic data matching algorithm which recognizes similarity between records regardless of spelling mistakes, inconsistent formatting, abbreviations, typos, foreign language or data in the wrong fields.

It then provides you with an easy to use user-interface to process and merge duplicate records into a single record by showing each duplicate side by side, allowing you to validate each duplicate at a glance and merge the data from two records into one.

 

The following help files will explain some of the concepts and tasks you need to know to make full use of the Duplicate Record Remover tool.

 

Contents

 

Introduction. 1

The process of removing duplicates from your database. 3

How are duplicates identified?. 5

What are False Duplicates?. 5

Why does the Examination Process take so long?. 6

Licensing. 7

Setup Wizard. 10

STEP 1: Select Source Data Type. 10

STEP 2 (Excel): Select Excel File. 12

STEP 2 (Text): Select Text (CSV or Delimited) File. 13

STEP 2 (SQL Server): Select SQL Server Table. 14

STEP 3: Specify Data Types. 15

STEP 4: Select Merge Methods. 19

STEP 5: Select fields to be used for examination process. 22

STEP 6: Import and Validate Data. 25

STEP 7: Examine data for duplicates and perform automatic merging. 26

STEP 8: Examination Process Complete. 28

Processing Tool 30

Merging Data: An Introduction. 30

Master and Slave Records. 31

Record Operations. 32

Merging Records. 33

Color Coding. 34

Navigating through the records. 35

Manual Editing of Records. 36

Auto-Merging: How fields are automatically merged. 37

Processing Duplicates: Four Steps to Follow.. 40

Processing a Duplicate Match: An Example. 40

Exporting Data. 47

Exporting Data Introduction. 47

Export Raw Data. 49

Export Changes Made. 51

Export Changes in Batches. 52

Export Changes in a Report 53

Export Changes as T-SQL. 54

Export Changes as XML. 55

Export Changes as XML: Field Descriptions and XSD Schema. 57

Keeping False Duplicates from Reappearing. 59

 

 

 

Related Topics

The process of removing duplicates from your database
How are duplicates identified?
What are False Duplicates?
Why does the Examination Process take so long?
Licensing