Duplicate Matching: Create flag for "This is not a duplicate"

Details
========
1. Add a new table - civicrm_dedupe_exception (id, contact_id1 [FK to civicrm_contact], contact_id2 [FK to civicrm_contact]) with unique(contact_id1,contact_id2) constraint.

2. On "find and merge listing screen", add another link "Not a duplicate" which in a ajaxified manner (like enable/disable) adds the pair of contact to the exception table.

3. On "contact merge / field matching / compare screen" add another link below "Flip between original and duplicate contacts" say - "Mark this pair as not a duplicate" which when clicked confirms via a javascript pop-up, adds the pair to exception table, and redirects back to "find and merge listing screen".

4. Add a new page (civicrm/dedupe/exception?reset=1) to list available pairs of contacts that have been marked as "Not a duplicate" in the system. Provide a link against each pair / listing say "Could be duplicate" which will remove the corresponding pair from exception table.

5. Fix upgrade for any schema changes above.

Note that while saving contact id pair in exception table make sure contact_id1 < contact_id2 which makes it easier for dedupe engine to join with threshold query.

6. Fix dedupe threshold query to ignore pair of contacts found in exception table.

Original message
===============
Hi.

It would be really nice to have an option to flag a possible duplicate as "Not a duplicate" that shows up in the Find and Merge Duplicate Contacts list so that it does not continue to show up on that list each time you match duplicates.

Ideally there would be both a link next to the merge link on that listing page as well as a button on the merge / field matching / compare screen. I'm happy to mock up a user interface if that would help, but I think its pretty straight-forward.

I think proper implementation of this feature would also have a listing available of all those items that have been marked as "Not a duplicate" in the system so you could uncheck the two contacts in case the flag was made in error.

Thanks and let me know if I can help!

Erik. // http://quilted.coop