Question about getting information for statistical reports
I am assuming this is a good place to ask this question. We, Chinook Library Network, are pretty new to Koha and are still working on fully understand how to do some things using Koha. One area where we could use a little more help is in pulling out information for statistical reports. This question probably particularly applies to those in the U.S. Every year we need to fill out statistical reports for the state libraries and, ultimately, the IMLS (Institute of Museum and Library Services). I am sure other libraries have had to do the same thing. From Koha we need to get information about how many items we have and how many patrons we have. We also need to know the circulation for the year. The items are broken out in categories like adult books, dvd's, etc. and children's books, dvd's, etc. Can those of you who have done this give us some clues on the best ways to pull together this information? We need the information for each library in our network. We do not need it for the network as a whole. This year we are only looking at a few weeks of information so it is not a major issue. The rest of our statistics we already pulled off of our old ILS. However, we would like to be able to pull together some of this information for each month and for next year. We also are interested in finding out the best way to create reports of daily circulation that would include checking out items at the library for that library's patrons and the items we send on intralibrary loan to other libraries in our network. Thanks for any information you can send our way. -- *Diedre Conkling** Lincoln County Library District P.O. Box 2027 Newport, OR 97365 Phone & Fax: 541-265-3066 Work email**: **diedre@lincolncolibrarydist.org*<diedre@lincolncolibrarydist.org> * Home email: **diedre08@gmail.com* <diedre08@gmail.com> "If you don't like something, change it. If you can't change it, change your attitude."--Maya Angelou
Salve! I had to rub me eyes and wonder if I were conflating listservs. :D Welcome to Koha.
Every year we need to fill out statistical reports for the state libraries and, ultimately, the IMLS (Institute of Museum and Library Services). I am sure other libraries have had to do the same thing.
A long time ago when animals could talk, there were no statistics whatsoever with Koha. Don't worry, there are now. I believe that you have Paul Poulain to thank for this very simple breakdown, or perhaps Chris Cormack. Or perhaps I'm mortally offending whoever it actually was a jillion years ago. The thing is, I asked for it, and the nice developers made it like RIGHT AWAY with a smile. Your needs should be close to the initial thingy that I asked for, since we essentially needed the same thing at my tiny olde Library in Western Massachusetts. If it is in fact what you want, the good news is that you don't have to screw about with SQL. :D You can get to the bespoke thingy by logging into the Staff side and clicking Reports (this has a nifty pie chart on the Bywater Demo, dunno about your jobby) Catalogue by itemtype
We also are interested in finding out the best way to create reports of daily circulation that would include checking out items at the library for that library's patrons and the items we send on intralibrary loan to other libraries in our network.
Thanks for any information you can send our way.
I would recommend that you boot about one of the demo sites and click lots of buttons. That way you can get comfy with reports in general. It'll help you familiarise yourself with what Koha will already run. It also will make you feel as though you can't possibly break anything, since you can't. That said, I don't think there's a Librarian alive that has all of their statistical nerdy needs satiated by the little array of preconstructed ones at hand. That level of nerdiness is a 2 part process. The first thing you ought do is head to: http://wiki.koha-community.org/wiki/SQL_Reports_Library to see if someone has already slapped one together. They prolly have. There are a mind boggling number of them. if not, then you head on over to the Staff side then Reports then Guided Reports Create from SQL If mah babbling didn't help, there's always the manual. http://manual.koha-community.org/3.8/en/reports.html Nicole did a preso on this, but it was way back at Plano. Perhaps she's done summat newer lately that the pigeons have buried deep in the Google results pages. Cheers, Brooke
participants (2)
-
BWS Johnson -
Diedre Conkling