Re: [Koha] All I want from Santa (or possibly the great Paul Poulain ;)
On items with fictitious character subjects for characters with a first and last name, the comma that separates their name seems to be wreaking havoc with the subject headings.
This is a problem for us as well. Previously the subject headings got returned as one big string, completely unlinkable. We submitted a fix that got us to where we are now, while admitting to the problem you describe (http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=679). I think the script receives a comma-separated list of subject headings for the record, and they breaks it into an array on the comma, resulting in the mixed-up list you're seeing. We get the same thing. I guess we should submit a separate bug for this.
I am having issues with the subtitle field. I've noticed that in other Koha catalogues it will not display until you hit the records page, but I can't even manage to get it to do that.
Absence of the subtitle (whether it be 245b or 245p) in search results is a huge problem for us. Following your chosen example, search results for Frodo Baggins will bring up the Lord of the Rings DVD, but because nothing else is displayed, you can't tell which volume it is. Our OPAC installation from CVS of rel_2_0 shows the subtitle in opac-detail.pl, so I'm not sure why you're not seeing it. If it's just the template, you could change that by hand if you wanted. If the subtitle's just not there, then you have another problem. You might check for it in the subtitles table.
I wish this [additional author] was linked like the author field is, and would be searchable under a basic search.
Relating to both this question and the previous one, a LOT of work is being done to overhaul the search system to really take advantage of MARC records. This particular issue is being addressed, allowing author searches to hit the many different alternate author tags.
I know I am asking for blood on this one. But it would be fantastic if we could please have an author search from the MARC biblio management screen
I'm guessing that once the work is done on the improved MARC searching, we can roll the regular advanced search into this one and not have distinct options.
What I want to be able to generate is a raw number of records for a certain type of material.
There are a number of new reports being added in the next version, and this is one of them.
I definitely get the impression that I can at least get raw numbers. But how?
Right now? Query MySQL directly! In the meantime, submit an enhancement bug for the kind of report you'd like to see. Perhaps in the meantime some other folks can chime in on how they get the reports they need. -- Owen ---- Web Developer Nelsonville Public Library http://www.athenscounty.lib.oh.us
What I want to be able to generate is a raw number of records for a certain type of material.
Right now? Query MySQL directly! In the meantime, submit an enhancement bug for the kind of report you'd like to see. Perhaps in the meantime some other folks can chime in on how they get the reports they need.
Here are some of the SQL statements I use to prepare the Nelsonville Library reports: SELECT biblioitems.itemtype, COUNT(biblioitems.itemtype) AS count FROM items,biblioitems WHERE YEAR(items.dateaccessioned)=2004 AND MONTH(items.dateaccessioned)=4 AND biblioitems.biblioitemnumber=items.biblioitemnumber GROUP BY biblioitems.itemtype; This one produces a count of items, subdivided by item type, that were added to the catalog in any given month. (In the example above, the month would be April 2004.) If you want a count of all items by item type, just leave out the YEAR and MONTH conditionals. SELECT itemtype, COUNT(itemtype) AS count FROM statistics WHERE YEAR(datetime)=2004 AND MONTH(datetime)=4 AND branch='APL' AND type='issue' GROUP BY itemtype; This one produces a count of books issued by a particular branch in a particular month. Note that this _does not_ count renewals. I use another statement for that: SELECT biblioitems.itemtype, COUNT(biblioitems.itemtype) AS count FROM statistics,biblioitems,items WHERE YEAR(statistics.datetime)=2004 AND MONTH(statistics.datetime)=4 AND type='renew' AND statistics.itemnumber=items.itemnumber AND items.homebranch='APL' AND items.biblioitemnumber=biblioitems.biblioitemnumber GROUP BY biblioitems.itemtype; Note that modifying the SQL statement for issues by substituting "renew" for "issue" gives an inaccurate count. Also note that the issue SQL statement is more accurate yet than the renew SQL statement, since it counts by the branch where the item was issued, and the renew SQL statement counts by the home branch, which is often not the same as the issuing branch. But I haven't been able to come up with a 100% accurate SQL statement for counting renewals by issuing branch. (I'd be happy to entertain suggestions...) Note also that if you don't care about issuing branch vs. home branch, you can get a combined total of issues and renewals with this statement: SELECT biblioitems.itemtype, COUNT(biblioitems.itemtype) AS count FROM statistics,biblioitems,items WHERE YEAR(statistics.datetime)=2004 AND MONTH(statistics.datetime)=3 AND (type='renew' OR type ='issue') AND statistics.itemnumber=items.itemnumber AND items.homebranch='APL' AND items.biblioitemnumber=biblioitems.biblioitemnumber GROUP BY biblioitems.itemtype; Finally, here's one that counts newly registered borrowers at each branch in any particular month: SELECT branchcode, COUNT(branchcode) AS count FROM borrowers WHERE YEAR(dateenrolled)=2004 AND MONTH(dateenrolled)=4 AND categorycode='A' GROUP BY branchcode; -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
participants (2)
-
Owen Leonard -
Stephen Hedges