Find all content items with a content category?
For accounting purposes, I need to figure out what percent of pages on my site belong to our 501(c)3 a what percent are c4.
There are 35 content types on the site. Ugh.
I have a Content Category called Ownership, with options of c3 and c4. Each item of every content type is theoretically marked with one of these.
So what I really need to get is: how many live items are there across all Content Types where the Content Category Ownership is c3 and how many have c4.
Does that question make sense? And how the heck do I do it?
Thanks!
Comments
-
The best solution I can think of is to make a page with 70 list templates (two for each Content Type) or 35 pages with 2 list templates. You'll need to configure the appropriate filter for each list: show all items of type T where Ownership == c3, show all items of type T where Ownership == c4.
Sadly, there is no easy way to consolidate one list across all Content Types.
0 -
Bruce Keilin:
The best solution I can think of is to make a page with 70 list templates (two for each Content Type) or 35 pages with 2 list templates. You'll need to configure the appropriate filter for each list: show all items of type T where Ownership == c3, show all items of type T where Ownership == c4.
Sadly, there is no easy way to consolidate one list across all Content Types.
One other thought: admin search. You can do parametric searching but it only returns the first 100 results. If you have more than 100 matches, it won't tell you how many you had. This might be useful (for the small CTs) in conjunction with the above approach.
0 -
Bruce Keilin:
The best solution I can think of is to make a page with 70 list templates (two for each Content Type) or 35 pages with 2 list templates. You'll need to configure the appropriate filter for each list: show all items of type T where Ownership == c3, show all items of type T where Ownership == c4.
Sadly, there is no easy way to consolidate one list across all Content Types.
Thanks Bruce. Though obviously not the answer I really wanted to hear. I'll try out the search option you just posted, but unfortunately I think we'll have way too many pages for it.
Is there a better way we could have set something like this up? For example, if I had different wrappers for c3 and c4 could I see how many items across all content types had each wrapper? Or is there any other functionality that will let me search for a large number of results across types?
We're looking at doing a redesign at some point, so that might be a good chance for us to clean up our content and fix some things that could be done better.
0 -
Kirsten Suhr:
Thanks Bruce. Though obviously not the answer I really wanted to hear. I'll try out the search option you just posted, but unfortunately I think we'll have way too many pages for it.
Is there a better way we could have set something like this up? For example, if I had different wrappers for c3 and c4 could I see how many items across all content types had each wrapper? Or is there any other functionality that will let me search for a large number of results across types?
We're looking at doing a redesign at some point, so that might be a good chance for us to clean up our content and fix some things that could be done better.
The only suggestion I can make is to try to reduce the number of distinct Content Types. I haven't looked at your specific CTs to see if they could be simplified. We are looking at some product enhancements that would make this sort of reporting easier, but there is nothing I can promise on that front at this point.
0 -
This is something we have also struggled with--tracing back which pages have a specific content category. Given the number of sets and content types we have, creating a separate filter for each one would be untenable. While not perfect, I have made some progress by exporting each content type and running queries in an external DB. This of course becomes instantly out of date but helps a lot.
0 -
I was working on something else and just realized that I found a solution to this quandry. It takes a little bit of work at the front end and there are limitations, but it should work for us. If you create a custom RSS feed and pull in all of your content categories with the tag <category>, when you view it in a browser, the count for each category will appear in the right hand nav. Click the category and it limits the feed to just those documents.
1) First, create a list template for each content type pulling in all of the desired data. Mine looks something list this:
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>First Content Type</title>
<link>http://www.yourwebsite</link>
<description>RSS Feed</description>
<managingEditor>Your name here</managingEditor>
<webMaster>youremail@yourdomain.org</webMaster>
<copyright>2010</copyright>
<generator>Convio Content Management System Module</generator>
<language>en-us</language><t:list>
<item>
<guid isPermaLink="false">www.preservationnation.org-${itemID}</guid>
<title><!]></title>
<link>${url}</link>
<description><!]></description><!-- Date information -->
<pubDate><t:value id="lastPublicationDate" type="date" format="8">Jan 1, 2005</t:value></pubDate>
<!-- Location information -->
<city><!]></city>
<street><!]></street>
<zipcode><!]></zipcode>
<t:list id="related_state"><state>${label}</state></t:list><!-- Category tags -->
<t:list id="cultural_diversity"><category>${label}</category></t:list>
<t:list id="related_laws"><category>${label}</category></t:list>
<t:list id="year"><category>${label}</category></t:list></item>
</t:list>
</channel>
</rss>Note that <t:list id="cultural_diversity"> must reference the exact field name within "" in each content type. If you've been inconsistent like us when you add a content category to a type, it will be different for each feed.
2) Now create a page of the XML Content Type and insert the list into your page as you would any other list. Save and view the page in your browser. Your content categories should appear in an alpha list on the right hand side.
If you have a ton of content, I recommend limiting your filter to display 100 records while you are tweaking it. One of our content types has 6,000+ records and it takes forever to load. I was new to XML but figured it out with some help from Bruce, Convio's list display documentation, and online resources like http://www.w3schools.com/xml/xml_whatis.asp.
Good luck.
(Thanks to Bruce for setting up my first custom RSS.)
0 -
Alison Hinchman:
I was working on something else and just realized that I found a solution to this quandry. It takes a little bit of work at the front end and there are limitations, but it should work for us. If you create a custom RSS feed and pull in all of your content categories with the tag <category>, when you view it in a browser, the count for each category will appear in the right hand nav. Click the category and it limits the feed to just those documents.
1) First, create a list template for each content type pulling in all of the desired data. Mine looks something list this:
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>First Content Type</title>
<link>http://www.yourwebsite</link>
<description>RSS Feed</description>
<managingEditor>Your name here</managingEditor>
<webMaster>youremail@yourdomain.org</webMaster>
<copyright>2010</copyright>
<generator>Convio Content Management System Module</generator>
<language>en-us</language><t:list>
<item>
<guid isPermaLink="false">www.preservationnation.org-${itemID}</guid>
<title><!]></title>
<link>${url}</link>
<description><!]></description><!-- Date information -->
<pubDate><t:value id="lastPublicationDate" type="date" format="8">Jan 1, 2005</t:value></pubDate>
<!-- Location information -->
<city><!]></city>
<street><!]></street>
<zipcode><!]></zipcode>
<t:list id="related_state"><state>${label}</state></t:list><!-- Category tags -->
<t:list id="cultural_diversity"><category>${label}</category></t:list>
<t:list id="related_laws"><category>${label}</category></t:list>
<t:list id="year"><category>${label}</category></t:list></item>
</t:list>
</channel>
</rss>Note that <t:list id="cultural_diversity"> must reference the exact field name within "" in each content type. If you've been inconsistent like us when you add a content category to a type, it will be different for each feed.
2) Now create a page of the XML Content Type and insert the list into your page as you would any other list. Save and view the page in your browser. Your content categories should appear in an alpha list on the right hand side.
If you have a ton of content, I recommend limiting your filter to display 100 records while you are tweaking it. One of our content types has 6,000+ records and it takes forever to load. I was new to XML but figured it out with some help from Bruce, Convio's list display documentation, and online resources like http://www.w3schools.com/xml/xml_whatis.asp.
Good luck.
(Thanks to Bruce for setting up my first custom RSS.)
That's a neat idea, Allison! Thanks!
0 -
Alison Hinchman:
I was working on something else and just realized that I found a solution to this quandry. It takes a little bit of work at the front end and there are limitations, but it should work for us. If you create a custom RSS feed and pull in all of your content categories with the tag <category>, when you view it in a browser, the count for each category will appear in the right hand nav. Click the category and it limits the feed to just those documents.
1) First, create a list template for each content type pulling in all of the desired data. Mine looks something list this:
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>First Content Type</title>
<link>http://www.yourwebsite</link>
<description>RSS Feed</description>
<managingEditor>Your name here</managingEditor>
<webMaster>youremail@yourdomain.org</webMaster>
<copyright>2010</copyright>
<generator>Convio Content Management System Module</generator>
<language>en-us</language><t:list>
<item>
<guid isPermaLink="false">www.preservationnation.org-${itemID}</guid>
<title><!]></title>
<link>${url}</link>
<description><!]></description><!-- Date information -->
<pubDate><t:value id="lastPublicationDate" type="date" format="8">Jan 1, 2005</t:value></pubDate>
<!-- Location information -->
<city><!]></city>
<street><!]></street>
<zipcode><!]></zipcode>
<t:list id="related_state"><state>${label}</state></t:list><!-- Category tags -->
<t:list id="cultural_diversity"><category>${label}</category></t:list>
<t:list id="related_laws"><category>${label}</category></t:list>
<t:list id="year"><category>${label}</category></t:list></item>
</t:list>
</channel>
</rss>Note that <t:list id="cultural_diversity"> must reference the exact field name within "" in each content type. If you've been inconsistent like us when you add a content category to a type, it will be different for each feed.
2) Now create a page of the XML Content Type and insert the list into your page as you would any other list. Save and view the page in your browser. Your content categories should appear in an alpha list on the right hand side.
If you have a ton of content, I recommend limiting your filter to display 100 records while you are tweaking it. One of our content types has 6,000+ records and it takes forever to load. I was new to XML but figured it out with some help from Bruce, Convio's list display documentation, and online resources like http://www.w3schools.com/xml/xml_whatis.asp.
Good luck.
(Thanks to Bruce for setting up my first custom RSS.)
That's very nice, Alison!
0 -
Bruce Keilin:
That's very nice, Alison!
For anyone trying this fix, I am having trouble with the way the insert component adds the XML list to the page. If it looks like this:
<DIV class="templateComponent" id="templatelist-135230750" style="DISPLAY: inline"/>
You need to edit it to look like this:
<t:include id="templatelist-135230750" />
Not a huge deal since you only have to do it once. Good luck.
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™
- 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