Take the 2-minute tour ×
User Experience Stack Exchange is a question and answer site for user experience researchers and experts. It's 100% free, no registration required.

I am developing an app that compares source data and destination data (the data is transferred from one database into another)

I would like to create the best possible interface that clearly and intuitively displays the following:

  • Matched records
  • Mismatched records and indicating where the mismatches occurr (for each field of a row from the source and destination)
  • Missing records

Here is the schema for the data:

  • Name
  • Email
  • Job Title
  • Department
  • Team
  • Photo

Here is an example, the intial match is made on email address.

  • Source data: Imran Azad, Imran.azad@domain.com, Developer, IM&T, IT, jpeg photo
  • Destination data: Imran Azad, Imran.azad@domain.com, Developer, IM&T, IT, jpeg photo

The above example would return a match as both rows of data are identical.

An example of a mismatch would be:

  • Source data: Imran Azad, Imran.azad@domain.com, Developer, IM&T, IT, jpeg photo
  • Destination data: Imran Azad, Imran.azad@domain.com, Tester, IM&T, IT, jpeg photo

So in this example although a match was found on email address, there is an additional entry for Imran when he used to be a tester.

share|improve this question
    
Hello Imran and welcome. Is the data in a table, is it numbers, text? Can you be more explicit. An example would be appreciated. –  Gildas Frémont May 12 '13 at 7:40
    
@GildasFrémont Thank you for the warm welcome, sorry for being vague I've added some additional information to make it clearer. –  Imran Azad May 12 '13 at 8:03
add comment

1 Answer

Do not show the matching records

Since you want to see the differences between the source and the destination all you have to display are the rows with differences. For those without differences just verbalize it as a feedback of the comparison (for instance : 56 rows matched, 4 mismatched).

Make the differences obvious

Then pair the rows that mismatch together and underline the mismatching datas. Be careful not to deteriorate the format when giving emphasis (use background, text or border color).

Using tables and a consistent format will make missing records apparent.

Keep the destination data as reference as you may have different rows that matches for the same entry.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.