04-28-2008, 09:48 AM
|
#1 (permalink)
|
| Jetula Join Date: Nov 2007 Location: Welland, Ontario
Posts: 33
Rep Power: 0  | Incorrect Import ID's Recently We had are data checked for address accuracy and correction.
I created a CSV file containing all our records and all fields related to my objective
CnBio_ID
CnBio_import_ID
first name and last, and all address line in including CnAdrPrf_import_ID Regardless of our score, I got our corrected data back and created smaller more manageable sizes to import and incase of unforeseen errors. I created two separate import processes, Step1 check for valid addresses and correct name spelling and Step 2 update addresses As per Canada national change of address standards. On my first try I got over 300 exceptions due to invalid CnBio_ID. So after checking a few records I found that YES the ID output was not the same as the original record. I then tried to update my CnBio_Id by specifying CnBio_import_Id as my identifier, this did not work, I rechecked the properties of one of my exceptions and found that not only was the CnBio_Id was incorrect by so was the CnBio_import_Id. So, now I have created a new export of all my records that only contain their first and last name, CnBio_import_id. My results are the same. The ID output is not matching my original records. Any useful help would be appreciated.
Last edited by jetula; 04-28-2008 at 09:50 AM.
|