Querying and Exporting RG information
Comments
-
Lauren Smith:
Hello All, I'm a fairly new RE user and am trying to pull some accurate data for an upgrade campaign that we will be starting soon. I was pointed to this great forum and am hoping you may have some insight. I need to find the following: All donors who give via recurring gift WHO: - Have given a minimum of one year AND - Have not missed more than 1 donation I will need to export: - Their contact details - Their first recurring gift details (date/amt/appeal) - Their next transaction due date - Their recurring gift CC/bank details - Their last one-off gift details I'm not sure whether I should be using a Constituent query or a Gift query/export. Also, since I will be importing back in a lot of changed information, do I need to be exporting import IDs at this stage? Thanks heaps!Lauren,
Still thinking about best way to get all the info you want in the easiest manner. But yes, if you are importing anytime with the chance that you may want to import info back into RE you want to export IDs for all fields that apply (example: constituent, gift, contact etc.) or may be imported back in.
Looks like the fields you're looking for are available in a gift export. I just looked there as it seems like the primary thing you're interested in. But do your donors have more than one recurring gift? Are all the gifts to one fund?
Just looking for what you'll want for query criteria. You'll need to create a query of the records/gifts to take to Export. Think you should get desired results with gift type, gift date, and number of consecutive payments missed fields.
Can I ask what fields you will be changing to import back in? Remember you will lose your original info if you change fund. Down the road, an auditor may question how a donor made a recurring gift in 2009 to a campaign that began in 2013.
Also, if you're looking at next transaction due date - sometimes you will get misinformation on this. I have had 2 cases open with support this year about records showing up that shouldn't and records not showing up that should in just a simple query recurring gifts with output of next transaction date. Just a caution to look this over carefully.
Hope this provides a little help at least. Welcome to the forums.
0 -
JoAnn Strommen:
JoAnn, Thank you for your quick response. To answer your questions... 1. Some of our donors do have more than one recurring gift, although right now they only have one ACTIVE recurring gift. 2. For this upgrade campaign, the recurring gifts currently go into one of two different funds. These funds would not be changed on the import back in. 3. The information that could be imported back in would include: Bio info, RG CC information, RG ammendment (to amount AND to split the appeal moving forward to track the upgrade success), Spouse Relationships, Address (including phone types), Actions, Appeal (to tab) I'm not sure of the 'number of consecutive payments missed' functionality. Right now we do record $0 gifts (where their CC failed, etc.) So would that get counted? I'm a bit scared at hearing of the issue with 'next transaction due date'. Were the errors there because your CRITERIA was 'next transaction due date' or because it was just in the OUTPUT? What RE version are you on? Cheers, LaurenLauren,
Still thinking about best way to get all the info you want in the easiest manner. But yes, if you are importing anytime with the chance that you may want to import info back into RE you want to export IDs for all fields that apply (example: constituent, gift, contact etc.) or may be imported back in.
Looks like the fields you're looking for are available in a gift export. I just looked there as it seems like the primary thing you're interested in. But do your donors have more than one recurring gift? Are all the gifts to one fund?
Just looking for what you'll want for query criteria. You'll need to create a query of the records/gifts to take to Export. Think you should get desired results with gift type, gift date, and number of consecutive payments missed fields.
Can I ask what fields you will be changing to import back in? Remember you will lose your original info if you change fund. Down the road, an auditor may question how a donor made a recurring gift in 2009 to a campaign that began in 2013.
Also, if you're looking at next transaction due date - sometimes you will get misinformation on this. I have had 2 cases open with support this year about records showing up that shouldn't and records not showing up that should in just a simple query recurring gifts with output of next transaction date. Just a caution to look this over carefully.
Hope this provides a little help at least. Welcome to the forums.
0 -
Lauren Smith:
For some reason, even though I am writing with paragraph spaces, the forum is cramming my posts into one wall of text. Does the forum not work with Google Chrome?
JoAnn, Thank you for your quick response. To answer your questions... 1. Some of our donors do have more than one recurring gift, although right now they only have one ACTIVE recurring gift. 2. For this upgrade campaign, the recurring gifts currently go into one of two different funds. These funds would not be changed on the import back in. 3. The information that could be imported back in would include: Bio info, RG CC information, RG ammendment (to amount AND to split the appeal moving forward to track the upgrade success), Spouse Relationships, Address (including phone types), Actions, Appeal (to tab) I'm not sure of the 'number of consecutive payments missed' functionality. Right now we do record $0 gifts (where their CC failed, etc.) So would that get counted? I'm a bit scared at hearing of the issue with 'next transaction due date'. Were the errors there because your CRITERIA was 'next transaction due date' or because it was just in the OUTPUT? What RE version are you on? Cheers, Lauren0 -
Lauren Smith:
JoAnn, Thank you for your quick response. To answer your questions... 1. Some of our donors do have more than one recurring gift, although right now they only have one ACTIVE recurring gift. 2. For this upgrade campaign, the recurring gifts currently go into one of two different funds. These funds would not be changed on the import back in. 3. The information that could be imported back in would include: Bio info, RG CC information, RG ammendment (to amount AND to split the appeal moving forward to track the upgrade success), Spouse Relationships, Address (including phone types), Actions, Appeal (to tab) I'm not sure of the 'number of consecutive payments missed' functionality. Right now we do record $0 gifts (where their CC failed, etc.) So would that get counted? I'm a bit scared at hearing of the issue with 'next transaction due date'. Were the errors there because your CRITERIA was 'next transaction due date' or because it was just in the OUTPUT? What RE version are you on? Cheers, Lauren(About the lack of paragraphs - I don't know. Happens to others at times too. Don't know why.)
I'm not sure how $0 gifts would affect number of payments missed. Might cause it not to work. You'd just have to try it in a query and see what happens I guess.
We're using 7.92 with all but very latest patch for mobile use.
On the problems with next transaction due - I was checking data for records with a next transaction due just to make sure all those with pledges were getting reminders. (We don't bill recurring gifts.) Anyway, my only criteria was "Next transaction date is not blank". I got results for recurring gifts made a number of years ago and terminated/completed a long time ago. I was told that the status of terminated/completed does not affect/is not linked to payment schedule. The only way to not have a next transaction due date was to go in each record and use creative dating to put in an end date prior to next transactin. As they were ongoing recurring gifts, we did not have end dates entered on the gift records.
So when I was talking to support I asked why it wasn't pulling any recent recurring gifts that were terminated/completed that did not have end dates either. It should have pulled them all. It didn't pull anything recent. They could not give me any reason. We did screen shares looking at older gifts and recent ones. Spent way too much time on it. Was quite frustrating. Just do a simple query and see what you get for next transaction dates and/or number of transactions missed.
You've got an awful lot of data types to attempt in one import. Pretty ambitious. Not even sure if you could do it in one. Am guessing you'd be creating new and updating current. If you're updating addresses you may lose your current data.
Our org would not do CC information in excel or an outside program due to PCI security issues with the CC #s. And we would probably enter new RG on records as needed vs. an import.
I just pulled out my RE import guide to check a couple things. If your spouses have their own RE records you can not update their info by relationship import. Guide also says that importing recurring gifts can only do individuals, even though you're importing RG, if you choose Import Recurring Gifts, you are limited in fields available. For more detailed info, use Import, but guide says several import files may be required. Here's link to the Import Guide: https://www.blackbaud.com/files/support/guides/re7/import.pdf
Best of luck.
0 -
Hello!
I appreciate the ideas in this forum, and have a related question: Is there an easy way to sychonrize the Scheduled Date with the Gift Date in RG's? Somehow our Scheduled Dates are out of synch, sometimes by years. Appreciate your thoughts. Cheers, Jane0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 3 Blackbaud Staff Discussions
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board