Data De-duplicate

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
denisv
Posts: 253
Joined: Thu Jan 19, 2006 4:36 pm
Location: Ireland
Contact:

Data De-duplicate

Post by denisv »

Has there been any work / tests done by yourselves or forum users to de-duplicate data.

So if I have a contact business object:

a) As data being entered (on save) certain values are checked to see if they already occur

b) Once there is data in place that a process could be done to identify duplicates
aware_support2
Posts: 595
Joined: Sun Apr 24, 2005 2:22 am
Contact:

Post by aware_support2 »

a) You can add rules to the object to check for and reject duplicate attribute values. For example, you could add the following rule for object Contact. The rule will be checked when a new Contact is created (via form or otherwise) or an existing Contact is modified:

If EXISTS Contact WHERE (Contact.FirstName = ThisContact.FirstName AND Contact.LastName = ThisContact.LastName AND Contact.ID <> This Contact.ID) Then
REPORT ERROR 'Contact with this first and last name already exists.'

b) With necessary validation rules in place (as described above) the easiest way to avoid duplicates would be to import contact data from file into Aware IM with the Validate Data option enabled. Any duplicate records (according to the rules) will be rejected. The rejected entries will be noted in the import log. You can check the import log and make corrections as necessary.
Aware IM Support Team
Post Reply