[Koha] Going completely on-line with Koha

Stephen Hedges shedges at athenscounty.lib.oh.us
Sun Nov 30 09:17:32 NZDT 2003

David -

At Nelsonville Public Library, we login to MySQL and issue the following 
command to get our monthly acquisition statistics:

SELECT biblioitems.itemtype, COUNT(biblioitems.itemtype) AS count FROM 
items,biblioitems WHERE YEAR(items.dateaccessioned)=2003 AND 
MONTH(items.dateaccessioned)=11 AND 
biblioitems.biblioitemnumber=items.biblioitemnumber GROUP BY 

You'll need to change this by putting in the correct year and month, of course. 
 The report is subdivided by item type.  BTW, when you first start using Koha, 
_every_ item will be "new."  But after that first month, the report should be 

Stephen Hedges

> Dear Librarians,
> At our small school (Thailand) we are using Koha 
> and would like to do away with
> our on-paper catalog system. We have updated to 
> the most recent stable version
> of
> Koha but do not see a way to get a weekly or 
> monthly report of new books
> (acquisitions). It appears this is the main 
> stumbling block to going completely
> online. Any experience and/or advice would be 
> appreciated.
> Oh, and is there a way to add jacket cover photos 
> or Web-based links relevant
> to
> a book or its author?
> Thank you in advance for your help.
> Sincerely,
> David Bucknell
> -- 
> http://iteachnet.org/~david
> --------------------------------------------------
> --------------
> This message was sent using IMP, the Internet 
> Messaging Program.
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list