How an I reconcile which records didn't get imported?

About 2 years into Sugar and I've discovered that not all our contacts were imported. The files were uploaded but something must have happened during import that caused some records not to get in there.

I have the spreadsheet of what was supposed to be uploaded and I exported what's in Sugar. How can I reconcile these two list that contain 10,000+ contacts in a way that shows me what didn't get uploaded?

Parents

0 Patrick McQueen over 5 years ago

Hi Christopher Garcia,
If there is a common key between the data, such as name or email address, you can put both lists into Excel and use vlookup in a column to identify which rows containing the common key column in one list appear in the other.
Video and written instructions for using Excel's vlookup are aplenty online. Here is one example.
I hope this helps.
Cancel
Vote Up +2 Vote Down

Sign in to reply

Reject Answer

Cancel

Reply

0 Patrick McQueen over 5 years ago

Hi Christopher Garcia,
If there is a common key between the data, such as name or email address, you can put both lists into Excel and use vlookup in a column to identify which rows containing the common key column in one list appear in the other.
Video and written instructions for using Excel's vlookup are aplenty online. Here is one example.
I hope this helps.
Cancel
Vote Up +2 Vote Down

Sign in to reply

Reject Answer

Cancel

Children

No Data