[Koha] Koha OPAC usage log

Greg Barniskis gbarniskis at gmail.com
Thu May 12 11:40:16 NZST 2011

On Wed, May 11, 2011 at 4:05 PM, Agnes Rivers-Moore <arm at 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,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110511/f2299623/attachment.htm 

More information about the Koha mailing list