On Wed, May 11, 2011 at 4:05 PM, Agnes Rivers-Moore <arm@hanover.ca> wrote:
Hello all
Is there a way to extract usage statistics for the public catalogue of Koha? I would like to be able to make a report that would show daily numbers of main page access, number of searches, number of holds placed, number of renewals done by our patrons through the OPAC.
Does anyone have a method for this? Is there a log file we could query to generate these number? Has anyone added a web page analytics thing to get this kind of usage information?
We are on 3.00.06, moving to 3.2 soon.
Thank you Agnes
Hi Agnes, You may need to try a couple of different methods to get at the different kinds of information you're looking for. A statistic like "how many times was the main page accessed?" is probably best answered by looking at the log files for the web server and running them through software designed to analyze web server logs. So, Apache log files if your web server runs Apache (it probably does). Your web log may also have a lot to say about the kinds of searches being made. A statistic like number of holds might be better exposed through a SQL query, particularly if you wanted to combine that with questions like "who placed holds?" and "on what?". Off the cuff, I don't know the syntax you'd need for any of that, but it might be in the community's SQL report wiki, found at http://wiki.koha-community.org/wiki/SQL_Reports_Library. In any case, a lot of useful things are there. If you come up with some clever new SQL query to get at your desired info, please contribute it there. Hope that helps, Greg