Notices


Reply
 
LinkBack Thread Tools Display Modes

Old 04-28-2008, 09:48 AM   #1 (permalink)
Jetula

jetula's Avatar

Join Date: Nov 2007
Location: Welland, Ontario
Posts: 33
Rep Power: 0 jetula is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

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.
__________________
Robert Addis
Database Coordinator
Niagara College Foundation
Niagara College Centre for Community Leadership

http://www.niagaracollege.ca/contributing/
raddis@niagarac.on.ca
300 Woodlawn Road
Welland, ON. L3C 7L3
ph: 905-735-2211 x 7841

Last edited by jetula; 04-28-2008 at 09:50 AM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 04-28-2008, 10:35 AM   #2 (permalink)
Jetula

jetula's Avatar

Join Date: Nov 2007
Location: Welland, Ontario
Posts: 33
Rep Power: 0 jetula is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Further more, I believe that the ID's were added manually instead of letting Raiser's Edge apply the ID. And on my last try to correct the invalid CnBio_id's the CnBio_import_id's were also invalid making this more difficult then need be.
__________________
Robert Addis
Database Coordinator
Niagara College Foundation
Niagara College Centre for Community Leadership

http://www.niagaracollege.ca/contributing/
raddis@niagarac.on.ca
300 Woodlawn Road
Welland, ON. L3C 7L3
ph: 905-735-2211 x 7841
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 05-16-2008, 07:53 AM   #3 (permalink)
Jetula

jetula's Avatar

Join Date: Nov 2007
Location: Welland, Ontario
Posts: 33
Rep Power: 0 jetula is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

I have corrected the issue. no assistance is needed.
__________________
Robert Addis
Database Coordinator
Niagara College Foundation
Niagara College Centre for Community Leadership

http://www.niagaracollege.ca/contributing/
raddis@niagarac.on.ca
300 Woodlawn Road
Welland, ON. L3C 7L3
ph: 905-735-2211 x 7841
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
import


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Cheap Electricity - Loans - Loan - Loans
All times are GMT -6. The time now is 06:01 PM.

Miscellaneous


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by BBpixel Team 2008 :: jvbPlugin R1012.364.1

SEO by vBSEO 3.2.0 Copyright 2008 Blackbaud User SocietyAd Management by RedTyger
Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70