Export Constituents based on Query and list the Fund
I created a constituent query with the Fund ID>One of>all the funds I want in this list. And Gift Date>between>7/1/14 and 6/30/15. It did what I expected.
Now I want to do an export and just list each donor if they gave to one of those funds and the name of the fund.
Ex: John Smith Basketball
Eve Jones Soccer
John Smith Soccer
That is where I get 815 results instead of the roughly 90 I am expecting based on the query. It is exporting every gift to those funds last year instead of just the name of the donor and the fund.
I don't really want to have to do a separate export for each fund or manually go through an Excel doc and clean it up.
Any suggestions?
Comments
-
Are you using a constituent export or a gift export? If it's a constituent export each constituent will pull once. You'll need to pull additional gifts to see the additional gifts made - may be to same fund or a different one.. My first guess is multiple gifts for why the numbers are different.
If you are doing a gift export each gift will pull once. If they did lump sum gifts, vs. monthly or mulitple gifts this could work for you.
0 -
Hi Jessica,
I guess you're exporting from within the query, rather than creating a constituent export and then using your query as the selection criteria? Unfortunately you will get this sort of duplication when exporting results straight from the query.
There are probably better ways of doing it within RE, however for now you could use Excel's "remove duplicates" tool which will leave you with just the unique entries.0 -
JoAnn Strommen:
Are you using a constituent export or a gift export? If it's a constituent export each constituent will pull once. You'll need to pull additional gifts to see the additional gifts made - may be to same fund or a different one.. My first guess is multiple gifts for why the numbers are different.
If you are doing a gift export each gift will pull once. If they did lump sum gifts, vs. monthly or mulitple gifts this could work for you.
I am using a constituent export because I need to see the people, not the gifts. If they gave once or 100 times, if they gave a million or a penny, doesn't matter. I just need to know who gave to that fund last year.
0 -
Alan French:
Hi Jessica,
I guess you're exporting from within the query, rather than creating a constituent export and then using your query as the selection criteria? Unfortunately you will get this sort of duplication when exporting results straight from the query.
There are probably better ways of doing it within RE, however for now you could use Excel's "remove duplicates" tool which will leave you with just the unique entries.No, I am doing a query then going to export and creating the export with my query as selection criteria.
0 -
This is because you are adding a Gift Field to the Output, so RE is returning all Gifts that fit your criteria.
Create a Constituent Export, based on your existing Query. Under Gifts (on the Output Tab for the Export), select Fund and then set parameters in the Gift Criteria box, including the number of possible Funds a donor might have given to (at the top of the General Tab) and which Funds to include (on the Filters Tab). When you export the data, you should have what you want...0 -
This will be tricky because there's a disconnect between the Query (which determines the Constituents) and the Export (which then knows nothing about which Gifts you're refering to in that Constituent Query).
This may be one of those rare instances where you want to export directly from the Query.
A Constituent Export to Excel format should give you only one line for each Constituent. When you select to Export the Gift information it should ask you how many Gifts you want to Export and will export a column for each of the Gifts, not an additional line/row for each Gift.
If you're trying to do a Gift Export based on the Constituent Query, then you'll potentially get ALL Gifts associated with the Constituent's in the Query.
One solution would be to do a separate Constituent Query and Export for each of the Funds. That way you know you're getting a one-to-one line up.0 -
Why not use a Donor Category Report sorted by Alpha and utlize the Filters to choose just the particular Fund you are looking for. You can do one Report for each Fund. It can be saved as a query and exported that way. Or the more straightforward is to export the Donor Category Report itself from Preview.0
-
I would suggest you use a gift query and export to excel, and use a pivot table to list the names by fund.
I guess you could do a pivot report within RE, also. Base it on a gift query, not a constituent one. You'll still get the constituents' names.0 -
I may be missing a critical point, or making it too easy, but could you just run the Gift Detail Report and export to Word and adjust as needed? You can include the Fund name in the report so it would show up as needed in the listing. You can also set the name formats so if you wanted to inlcude the Spouse, you can select that option. So you would then have the option of:
John Smith Basketball
Eve Jones Soccer
John Smith Soccer
or
John Smith Basketball (has no spouse)
Eve & John Jones Soccer (has spouse)
The John Smith Company Soccer (Prefers to have Company in the donor listing)0 -
Try adding the fund criteria again (a second time) to the bottom of your query criteria (i.e. Fund ID>One of>all the funds I want in this list.). Then export directly from the query output using the disc icon (include fields you need for name and fund). That may control the output, and may work even in a constituent query rather than gift query in your scenario.
It's not intuitive and seems unnecessary, but I've been surprised with this pleasantly before and if it works it can save you additional steps. Try it, and as usual with new processes make sure to audit your results by pulling it another way mentioned.
If that doesn't work, I'd add a filter by fund and date to your export, using the filter by fields or queries options (vary depending on whether you use a gift or constituent export).
Hope I'm not repeating any replies. And hi to James whose name brought me here to this post--his advice is excellent too as usual...0 -
After you run your query, go to export. Create Constituent Export. For output, select Constituent Information-Name, and then:
Gift -- Funds -- Description.
In resulting pop-up box, select:
General tab -- "For each Constituent, enter the number of Gifts to export" -- enter: 1
General tab -- select appropriate date for fiscal/calendar year
General tab -- select start amount for minimum gift range
Filters tab -- Funds -- "Selected" -- select only the types of funds you wish to include
Gift Types tab -- select only those gift types you wish to include
This should give you one entry per Constituent, with just their name and the name of one fund in your Fund selection to which they have donated the previous year. There shouldn't be any duplicate lines. Even if you choose to output 2 Gifts Funds on the General tab, instead of one, it should export them as additional columns, not rows, on your spreadsheet. Should look like:
Debra Smith Soccer
Bob Hope Soccer Football
Antonio Banderas Football Basketball
Good luck to you!0
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™
- 1 YourCause® from Blackbaud®
- 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
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 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