Notices



Reply
 
LinkBack Thread Tools Display Modes

Old 03-14-2007, 03:27 PM   #1 (permalink)
Junior Member

mitchgibbs's Avatar

Join Date: Oct 2006
Location: Chicago
Posts: 19
Rep Power: 0 mitchgibbs is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

Angry Exporting Organization Contacts in 7.81

Hey guys-

We've got 7.81 in our testing environment and have already confirmed a pretty major problem. When we try to export Organization Contacts, the contact names are blank. We've confirmed the problem with Blackbaud (its fixed in 7.82!) (that was a sarcastic exclamation mark) and are trying to figure out if we need to scuttle our planned upgrade.

Has anyone else encountered this problem and, if so, have you figured out a decent workaround? We're experimenting with running queries and then joining the export with the query outside of RE.

Mitch
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 03-14-2007, 03:34 PM   #2 (permalink)
BUS Driver

Peter Gulka's Avatar

Join Date: May 2006
Location: Winnipeg, MB, Canada
Posts: 1,638
Rep Power: 4 Peter Gulka is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)
- API/VBA

crazy stuff....

We don't export our contacts in that way, so we'll push through on Friday afternoon!
__________________
Peter Gulka
Chief Bus Driver
Blackbaud User Society
www.blackbus.org

Follow me on Twitter

View Peter Gulka's profile on LinkedIn
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 03-14-2007, 03:48 PM   #3 (permalink)
my feet hurt.

Melissa Siobhan's Avatar

Join Date: May 2006
Location: Connecticut
Posts: 1,455
Rep Power: 4 Melissa Siobhan is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

I am so glad we have not upgraded. Are you serious about 7.82 or do you think they can get it out sooner with a patch? At this rate we may never upgrade and at my new job we are still on 7.71. ugh.
__________________
Melissa S. Graves

Director of Development Services
The Village for Families and Children
www.villageforchildren.org



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 03-14-2007, 03:55 PM   #4 (permalink)
Living on the Edge

Tcassi's Avatar

Join Date: May 2006
Location: Seattle, WA
Posts: 185
Rep Power: 3 Tcassi is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)

Question Exporting Contacts

Quote:
Originally Posted by mitchgibbs View Post
Hey guys-

We've got 7.81 in our testing environment and have already confirmed a pretty major problem. When we try to export Organization Contacts, the contact names are blank. We've confirmed the problem with Blackbaud (its fixed in 7.82!) (that was a sarcastic exclamation mark) and are trying to figure out if we need to scuttle our planned upgrade.

Has anyone else encountered this problem and, if so, have you figured out a decent workaround? We're experimenting with running queries and then joining the export with the query outside of RE.

Mitch
Mitch - Could you please clarify HOW you are exporting; are you using export straight from a Query or creating a separate Export? What type of Export are you using - Org? Do the results change if you use a different type of export? Have you tried exporting the contact using RE: Mail - and if so, do you get the same results?We are preparing to upgrade in a few weeks...I will definitely be looking for this in issue in our test environment.

Thanks for posting this info - it's good to have a heads up!
__________________
Tracie Cassidy
Database Coordinator
Seattle Children's Hospital Foundation & Guild Assoc
www.seattlechildrens.org
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 03-14-2007, 04:45 PM   #5 (permalink)
Junior Member

mitchgibbs's Avatar

Join Date: Oct 2006
Location: Chicago
Posts: 19
Rep Power: 0 mitchgibbs is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

Export

Melissa - Yep. Support said 7.82, not a patch. Arghh!

Tracie - We're using Constituent Exports. We can get to the information using Query. We haven't tried it going through Mail. Blackbaud support suggested that it might work with Mail - however, we use Export since there are a number of fields that are unavailable through Mail.

Mitch
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 03-15-2007, 08:59 AM   #6 (permalink)
Senior Member

Join Date: Sep 2006
Posts: 257
Rep Power: 3 jas. is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

mitch (or anyone else who has 7.81 and wouldn't mind checking) --

is there any chance you could try using Mail when you get a chance? this could be a dealbreaker for the upgrade for us -- we just spent a good amount of time cleaning up our corporate contacts, but if we can't pull them, what's the point? On the other hand, the main place we use this is in Mail, so if that aspect works we could deal with it.

thanks!

--james
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 03-15-2007, 12:22 PM   #7 (permalink)
Junior Member

mitchgibbs's Avatar

Join Date: Oct 2006
Location: Chicago
Posts: 19
Rep Power: 0 mitchgibbs is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

It DOES work in Mail

I just gave it a try and it DOES appear to work in Mail. I've got members of my staff verifying it and checking some scenarios on how well different workarounds would work for us.

What we may do is reverse our process where we normally run lists through Mail for some of the spousal suppressions, etc. but then export the list from Export so we can include additional fields. However, if we instead export out of Mail and then use Export just for additional fields and join the two on Constituent Id, then it will probably work for us and may provide a more natural flow - though more work outside of RE.

Don't you just love progress???

Mitch
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 03-16-2007, 09:20 AM   #8 (permalink)
Senior Member

Bonnie Alkire's Avatar

Join Date: May 2006
Location: Buckhannon, WV
Posts: 102
Rep Power: 3 Bonnie Alkire is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

This is really strange - we are on 7.81 and do not seem to have this problem! I have posted a couple of quirky things since we went to 7.81, but this was not one of our issues. I export using a constituent export and for relationship > contact info I do mark "Primary" because we only want to export the primary contact - do you differentiate in this way? Maybe RE is just confused!! Oh, for it to be that easy!
__________________
Soon to be ex-Coordinator of Advancement Services
Davis & Elkins College
Elkins WV 26241
alkireb@davisandelkins.edu
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 03-16-2007, 09:38 AM   #9 (permalink)
Cancer Research UK

Join Date: Aug 2006
Location: London, England
Posts: 110
Rep Power: 3 SimonKoppel is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

We've had a problem (which Blackbaud haven't been able to fix) with exporting Addressee and Salutation for Organisation Contacts, though we are able to export Name. But then, we're only on 7.71, so maybe it's a different problem entirely.
__________________
Simon Koppel
Senior Database Executive
Cancer Research UK
London, England
www.cancer.org.uk
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 03-16-2007, 10:05 AM   #10 (permalink)
Senior Member

Bonnie Alkire's Avatar

Join Date: May 2006
Location: Buckhannon, WV
Posts: 102
Rep Power: 3 Bonnie Alkire is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Hmmm. I have been able to do exactly what you cannot do! When you are exporting, do you designate a particular contact type? I always mark the export to pull only Primary contacts and have had no problem. I don't know how you are selecting the type of contact - perhaps you could try using a particular type of contact, not just the general (all) - in other words, after you select the relationship>contact>addressee/salutation, click on "criteria" and select the type of cantact you want? Maybe you're already doing this..?
__________________
Soon to be ex-Coordinator of Advancement Services
Davis & Elkins College
Elkins WV 26241
alkireb@davisandelkins.edu
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 03-16-2007, 10:46 AM   #11 (permalink)
Senior Member

Join Date: Sep 2006
Posts: 257
Rep Power: 3 jas. is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

thanks so much for looking into it. I appreciate that.
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 03-19-2007, 09:10 AM   #12 (permalink)
Junior Member

mitchgibbs's Avatar

Join Date: Oct 2006
Location: Chicago
Posts: 19
Rep Power: 0 mitchgibbs is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

Bonnie-

Sorry, I was unclear on where the problem comes up -- probably important ;-).

The main area where it is a problem (possibly the only area - I'm not sure) is when using Address Processing. If you use Address Processing when doing the export and specify to use the Contact's address, you get blanks instead of identifying information for the contacts.

If, on the other hand, I go into Relationships - Contacts and use that for the export it's fine - but I only get one export record for the organization and each contact is in a separate field on that one line. 99% of the time, we need separate records.

Does that make sense and are you able to duplicate the behavior I mention above? I know of two other organizations who ran into the same problem we have and Blackbaud was able to confirm it, but not give a workaround. We've changing to exporting to Access and then joining an exported query with the contact information to our mailing list.

Thanks!

Mitch
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 03-19-2007, 09:37 AM   #13 (permalink)
Senior Member

Bonnie Alkire's Avatar

Join Date: May 2006
Location: Buckhannon, WV
Posts: 102
Rep Power: 3 Bonnie Alkire is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Mitch, I don't use Address Processing - we just fo preferred address information; however, I just tried mailing to contacts using address processing, and the business address exported instead of the contact address. I'll look into this further this afternoon and get back to you. Bonnie
__________________
Soon to be ex-Coordinator of Advancement Services
Davis & Elkins College
Elkins WV 26241
alkireb@davisandelkins.edu
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-22-2007, 07:23 AM   #14 (permalink)
Junior Member

mitchgibbs's Avatar

Join Date: Oct 2006
Location: Chicago
Posts: 19
Rep Power: 0 mitchgibbs is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

Talking Fixed in Patch 13

Despite Blackbaud's previous statements that this wouldn't be fixed until 7.82, the latest patch, #13, clears it up. We've got it in testing and it looks like a good fix.

I'll chalk it up to a victory for whining...

Mitch
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
781, 782, contacts, export, organizations


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