Dear Chris, Paul and KOHA devel list, Thank you very much for your responses. Our library is currently using KOHA version 3.01.00.032., so if you could write a report like I described that works with version 3.01.00.032, then we don't care right now if it works with LEK. It is also not important that I be able to specify parameters in a wizard, I am happy to go in and edit the SQL with new call numbers, dates etc. each time I run it. If a report is created that does what we want in version 3.01.00.032, I will figure out how to post it to the community repository of KOHA reports - I haven't ever done that :) - but I'll figure out how and share it, I promise. I don't see any reports like this in the repository right now. There is one called a "super weeder" but I don't think it is quite what we are looking for, so I wonder what kind of "weeding" reports other KOHA libraries are currently using? (Sorry for the delayed reponse, your responses got marked spam and I didn't find them until now.) Thank you, Adrea Adrea Lund Head of Adult Services Grand County Public Library 257 E. Center St. Moab, UT 84532 435-259-1111 ext11 ----- Original Message ----- From: "Chris Cormack" <chris@bigballofwax.co.nz> To: "Adrea Lund" <adrea@moablibrary.org> Cc: <koha-devel@lists.koha.org> Sent: Thursday, December 10, 2009 3:52 PM Subject: Re: [Koha-devel] Help with SQL report 2009/12/11 Adrea Lund <adrea@moablibrary.org>:
Thank you for all the responses. I should have explained more clearly that I know extremely little about mysql - so some of the comments I've gotten from the lists I sent this to are going right over my head. But I do promise that once we have a working report(s), I will make sure it gets posted to the KOHA community report repository.
We realized that we have a major problem with the sql reports that I posted previously. These reports do not include zero circulations when listing items with less than three circulations. We are using this for weeding so we definitely want to know about those zero circulation items! Beverly has been a wonderfully helpful, but does not know how to solve this problem. Perhaps we need to approach this report in a different way? I will explain what we are trying to get and attach an example to this email.
I'll try to answer Chris Cormack's question and describe our ideal report -
It would allow you to specify the following variables... 1) a specific call number range 2) a specific time frame - _____ date to _____ date 3) choose "greater than," "less than" or "equal to" a specific a number of circulations. For example the report could list all "copies with less than 3 circulations" in the specified call number range (MUSIC 1999 CD to MUSIC ZZ TOP CD) during the specified time period (2004-01-01 to 2009-12-31). Circulations = issues+renewals+local use
I am attaching a copy of a page from the circulation report we used to use with our old ILS - Follett. The attached .pdf is listing oversize non-fiction books with less than 3 circulations between 1/1/2004 and 4/28/2009. So it gives you items that meet this criteria and also lists the following data - total circulations for today, total circulations this month, total circulations year to date, total circulations last year, and total circulations during the specified time period.
So, that is what we need. I hope my efforts to explain, are not making this more confusing :) The final report does not need to look like the attached report, it just needs to have the data.
We would greatly appreciate any help, and think that this type of circulation report (or something similar) is an essential tool for librarians who regularly weed their collections.
Regarding Chris Nighswonger's comment - We are hoping to eventually move to LEK, and I can test the reports in our LEK sandbox. If we could get a report working with our current database that would be a great first step. We are currently using KOHA version 3.01.00.032.
Hi Andrea If you are moving to LEK, we can't really help you too much. Since LEK is not Koha, we don't know what database changes and code changes have been made in LEK. We could write something like this for Koha, so that all libraries would get the benefit of it. But I wouldn't be comfortable doing one tailored to work in LEK, so it can be locked away. Chris