[Koha] Going completely on-line with Koha

[Stephen Hedges]

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 
biblioitems.itemtype;

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 
accurate.

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
>