• Archived  

By jnc - July 13, 2007

Can someone help with my need to summarize under a field name? I have several situations where I need to include a list of articles under a particular fieldname. For example, I need to include a list of books under a list of book authors. The list of book authors is several hundred long so I'll paginate after 20 or so.

Author A (field name is "book_author")
Book title 1 (field name is "title")
Book title 2
Book title 3
Author B
Book title 4
Book title 5
Book title 6

I've figured out how to list the author name next to every book, but then I'm repeating the author name multiple times (next to book 1,2,3.) Both the "book_author" field and the "title" field are located in my article database under every article so for example, 10 articles may use the same book author name.

Now, maybe I should have created a separate book author database and just selected the author's name in my article database from a drop down. Currently if the same author wrote another book, I'm re-entering the book author bio and picture into the new article -- a time consuming effort. The only way I know how to include the author information (bio, picture, name) is to include from the article database (i.e. $article.author_image$, $article.book_author$, $article.authorBio$). Any hints or suggestions on this would be VERY much appreciated.

Jerry

Re: [jerrycharles] help needed to summarize under a fieldname

  • Archived  

By deniseb - July 15, 2007

Hi Jerry,

Thanks for the post!

There's usually many ways that you can set things like this up with Article Manager. In this situation you could create a new publish rule that will output a list of books published by each author. Then you could set-up your index page template to pull in that file directly after the Author' name. For example, your index page code may look similar to this:

<p><a href="">$article.bookAuthor$<a/><br />

<ul>

<!--#include virtual="Author's Books Publish Rule Placeholder Here" -->

</ul>


Setting this up would require a little work but can be done, if this is a possibility that interests you let me know and I will be happy to provide you with more detailed instructions. :)

Re: [ChetW] help needed to summarize under a fieldname

  • Archived  

By jnc - July 17, 2007

Chet,

Thanks for the reply. But, in your example if $article.bookAuthor$ wrote 14 books, won't his/her name be repeated 17 times? As a point of clarification, I've created my own "bookAuthor" field in the article database and am not using the standard "Author" field at this time. And, every book is in a separate article record.

I would definitely appreciate more detailed instructions. I would essentially like to create an index page under a "by Author" parent category. The category index page will list the author's name followed by the books he/she wrote on separate rows.

Re: [jerrycharles] help needed to summarize under a fieldname

  • Archived  

By Jake - July 18, 2007

Hi Jerry,

Thanks for posting!

How are your categories set up right now? Are your authors set up as categories, or is the only reference to them done through the bookAuthor field? Some more information about your site should help us figure something out for you.

I look forward to your reply. [:)]
-----------------------------------------------------------
Cheers,
Jake Marvin - Product Specialist
support@interactivetools.com

Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.

Re: [jerrycharles] help needed to summarize under a fieldname

  • Archived  

By deniseb - July 19, 2007

Hi Jerry,

Thanks for the follow-up!

I have been taking another look at this for you and it looks like there may not be a good solution for this inside of Article Manager's default set-up. That being said I can see this being possible through the use of either Javascript or PHP/MySQL. Javascript and PHP are a little outside the scope of what we can support here. My thoughts had been based around storing all the author names in an array (basically a list of article authors), then running a request against that array which removes all the duplicate author names. :)

Perhaps a member of our community who is well versed in either PHP, MySQl or Javascript may be able to help point you in the right direction.

Re: [ChetW] help needed to summarize under a fieldname

  • Archived  

By jnc - July 20, 2007

Chet,

Thanks for looking into this. As an alternative, what if I set all my authors up as categories as you eluded to before? I already have a "$category.content$ field in the category database that could include the author bio. If I could call the $category.name$ (author name) and $category.content$ (author bio) into my article in the appropriate places this could work, couldn't it? For example, I would first use a TemplateIf to check if $article.category3num$ = "the author category" and if so, display $Category.name$ and $Category.content$. Do you think this would work? Would that pull in the correct category content or is content pulled automatically always select fields from the $article.categorynum$ category?

Jerry

Re: [jerrycharles] help needed to summarize under a fieldname

  • Archived  

By deniseb - July 21, 2007

Hi Jerry,

Thanks for the follow-up!

Setting up your author's as categories will most likely be your best option here Jerry, I would suggest giving it a try and if you need a hand at any point we'll be happy to help out. :)