Hi Zico, This is a (simple) saved Report that we use: SELECT location, count(barcode) , sum(replacementprice) FROM items GROUP BY location ORDER BY location asc Hope it helps. (Plus, this tells us how much the replacment value of the library stock is!) Nicholas Perth Bible College library.pbc.wa.edu.au On Tue, Oct 6, 2009 at 2:25 PM, <koha-devel-request@lists.koha.org> wrote:

Send Koha-devel mailing list submissions to koha-devel@lists.koha.org

To subscribe or unsubscribe via the World Wide Web, visit http://lists.koha.org/mailman/listinfo/koha-devel or, via email, send a message with subject or body 'help' to koha-devel-request@lists.koha.org

You can reach the person managing the list at koha-devel-owner@lists.koha.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha-devel digest..."

Today's Topics:

1. Google transliteration for koha opac. Trouble with IE.. (Koustubha Kale) 2. Conference on Koha for 2010 NOT KOHACON NZ (David Schuster) 3. Way to limit by 2 locations at the same time (David Schuster) 4. Koha 3.0 total number of books, cds, dvds, journals and others (Zico) 5. Re: Koha 3.0 total number of books, cds, dvds, journals and others (Michael Hafen) 6. Re: Conference on Koha for 2010 NOT KOHACON NZ (Bob Birchall @ Calyx) 7. Re: Google transliteration for koha opac. Trouble with IE.. (Koustubha Kale) 8. Re: Google transliteration for koha opac. Trouble with IE.. (savitra sirohi)

----------------------------------------------------------------------

Message: 1 Date: Mon, 5 Oct 2009 19:03:33 +0530 From: Koustubha Kale <kmkale@anantcorp.com> Subject: [Koha-devel] Google transliteration for koha opac. Trouble with IE.. To: koha-devel@lists.koha.org Message-ID: <81fae620910050633m5fe51d21j7a7d180fc2b1ef86@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1

Hi all,

I need a bit of help

I am trying to integrate google transliteration with koha opac search box. This makes it easier to search indian language keywords for english keyboard users.

I have it working with Firefox at www.granthalaya.org; but in IE I dont get the language selection box. The transliteration still works but the language selection dropdown does not appear. I cant make out anything from the error message displayed either. The error says "line: 40 char: 243 unexpected call to method or property access.Code : 0" If I use the same google transliteration code in a simple html page in IE it works. So I am doubly puzzled so as to where to look for the problem. What could it be?

Can someone please have a look at the site in both IE and Firefox and suggest something?

Regards, Koustubha Kale Anant Corporation

Contact Details : Address ?: 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), ? ? ? ? Maharashtra, India, Pin : 400601. TeleFax ?: +91-22-21720108, +91-22-21720109 Mobile ? ? : +919820715876 Website ?: http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2

------------------------------

Message: 2 Date: Mon, 5 Oct 2009 11:19:20 -0700 (PDT) From: David Schuster <dschust1@tx.rr.com> Subject: [Koha-devel] Conference on Koha for 2010 NOT KOHACON NZ To: koha-devel@lists.koha.org Message-ID: <25755583.post@talk.nabble.com> Content-Type: text/plain; charset=us-ascii

I wanted to see what type of interest there is in another conference in the US and who would be willing to help/host/committee/present...

There has been lots of discussion about other issues, but thought we should refocus our energy to helping each other.

I know Chris is working on a conference in NZ - KohaCon 2010 anniversary - but many of us I know won't be able to attend. I don't want to take any thunder from that though as well...

What are peoples thoughts - concerns...

Some people indicated if there is no other option than NZ maybe their administration would let them go to NZ - I want to hear what people have to say.

David Schuster -- View this message in context: http://www.nabble.com/Conference-on-Koha-for-2010-NOT-KOHACON-NZ-tp25755583p... Sent from the Koha - Dev mailing list archive at Nabble.com.

------------------------------

Message: 3 Date: Mon, 5 Oct 2009 11:52:06 -0700 (PDT) From: David Schuster <dschust1@tx.rr.com> Subject: [Koha-devel] Way to limit by 2 locations at the same time To: koha-devel@lists.koha.org Message-ID: <25755923.post@talk.nabble.com> Content-Type: text/plain; charset=us-ascii

is there a way in the OPAC to search 2 locations at the same time?

branch:001,901 or something of that nature?

David Schuster -- View this message in context: http://www.nabble.com/Way-to-limit-by-2-locations-at-the-same-time-tp2575592... Sent from the Koha - Dev mailing list archive at Nabble.com.

------------------------------

Message: 4 Date: Tue, 6 Oct 2009 00:59:57 +0600 From: Zico <mailzico@gmail.com> Subject: [Koha-devel] Koha 3.0 total number of books, cds, dvds, journals and others To: koha-devel@lists.koha.org Message-ID: <69621d830910051159s54a01473m9e460b6d648a3850@mail.gmail.com> Content-Type: text/plain; charset="utf-8"

Hi, If i want to see total number of inserted books,cds,dvds, journals and others which are inserted into my Koha 3.0 server, what i need to do? I went to:

Reports --> Statistics Wizards --> Catalog

But, nothing is showing but only 0. But, my inserted items are 5,000 approximately. i want to know the exact figure.

-- Best, Zico