To help ensure data integrity, ChilliDB has features that prevent, identify, and eliminate duplicate records.
Preventing Duplicates
ChilliDB has duplicate protection for Contacts, Client Administration Clients, Organisations and through many modules such as ATAPS. When you try and create a record, ChilliDB will present a number of matching records if any are found, and give you opportunity to view those records, cancel your creation, or continue to create your record.
Duplicates can still occur especially when using Web Controls, or Data Loader, or just user error.
Duplicate Detection
To help you maintain quality data, ChilliDB makes available Duplicate Detection tools under the System menu > Data Management > Duplicate Detection.
From there, you can choose a module in ChilliDB, and it will present a list of records which look like they could be duplicated. You can then work through them and expire those records which are duplicates.
Duplicate Merging
Duplicates identified using the duplicate detection can be merged.
All fields for the source contact/organisation and relationships to other modules such as contacts, notes, events, membership, etc will be transferred to the target contact/organisation. However existing information in the target contact/organisation will not be overwritten. Once the process has completed the source contact/organisation will be expired
Merging Process
To select the records to merge you must navigate to System>Data Management>Duplicate detection. Then select a module to check for duplicates held in that module. After you have done this a list of records that are potential duplicates appear.
If you cannot see your duplicates here, you can change the name of the duplicate record so it matches the record you want to merge with and the duplicate detector will pick it up. Click the number of occurrences to show the duplicates.
Here you can select the record you want to keep (target) and what should merge with it (source). Once merged, the source record will be expired.
Contact Merge Rules
When doing a contact merge, contact references are updated in the following modules
Organisation
Note
Event
Membership
Case
Client admin
Survey
Asset Register
Contract Management
Document Register
QI
Distribution List
Group
Contact role
Quick links
Appointments
All custom live data fields of Contact type
Below are some rules for what fields can and cannot be transferred. Remember, fields in the target contact cannot be overwritten, new information is only added if the field is empty. You can work around this by manually emptying fields in the target contact if you know the source contact holds the correct data.
Organisation Merge Rules
For organisation merges, Organisation references are updated in the following modules:
Contact
Note
Event
Membership
Case
Client admin
Survey
Asset Register
Contract Management
Document Register
QI
Distribution List
Group
Contact role
Quick links
All custom live data type of Organisation type
Below are some rules for what fields can and cannot be transferred. Remember, fields in the target organisation cannot be overwritten, new information is only added if the field is empty. You can work around this by manually emptying fields in the target organisation if you know the source organisation holds the correct data.
