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-requ...@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-requ...@lists.koha.org > > You can reach the person managing the list at > koha-devel-ow...@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 <kmk...@anantcorp.com> > Subject: [Koha-devel] Google transliteration for koha opac. Trouble > with IE.. > To: koha-devel@lists.koha.org > Message-ID: > <81fae620910050633m5fe51d21j7a7d180fc2b1e...@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 <dschu...@tx.rr.com> > Subject: [Koha-devel] Conference on Koha for 2010 NOT KOHACON NZ > To: koha-devel@lists.koha.org > Message-ID: <25755583.p...@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-tp25755583p25755583.html > 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 <dschu...@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.p...@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-tp25755923p25755923.html > Sent from the Koha - Dev mailing list archive at Nabble.com. > > > > ------------------------------ > > Message: 4 > Date: Tue, 6 Oct 2009 00:59:57 +0600 > From: Zico <mailz...@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: > <69621d830910051159s54a01473m9e460b6d648a3...@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 > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://lists.koha.org/pipermail/koha-devel/attachments/20091006/cbad9ce4/attachment.html > > ------------------------------ > > Message: 5 > Date: Mon, 05 Oct 2009 15:19:06 -0600 > From: Michael Hafen <mdha...@tech.washk12.org> > Subject: Re: [Koha-devel] Koha 3.0 total number of books, cds, dvds, > journals and others > To: Zico <mailz...@gmail.com> > Cc: koha-devel@lists.koha.org > Message-ID: <1254777546.12246.3.ca...@koha-dev> > Content-Type: text/plain > > I don't mess with the reports, so I can't help with them. For this I > would run a few SQL commands. I'll write some here for you. > > SELECT COUNT(barcode) FROM items WHERE barcode <> '' AND barcode IS NOT > NULL > > SELECT categorycode,COUNT(barcode) FROM items WHERE barcode<> '' AND > barcode IS NOT NULL GROUP BY categorycode; > > SELECT COUNT(biblionumber) FROM biblio > > These will give you the total number of barcodes, the number of barcodes > per item category, and the total number of titles in the database. > > Good luck. > > On Tue, 2009-10-06 at 00:59 +0600, Zico wrote: > > 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 > > _______________________________________________ > > Koha-devel mailing list > > Koha-devel@lists.koha.org > > http://lists.koha.org/mailman/listinfo/koha-devel > -- > Michael Hafen > Systems Analyst and Programmer > Washington County School District > Utah, USA > > for Koha checkout > http://development.washk12.org/gitweb/ > or > git://development.washk12.org/koha > > > > > ------------------------------ > > Message: 6 > Date: Tue, 6 Oct 2009 09:25:11 +1100 > From: "Bob Birchall @ Calyx" <b...@calyx.net.au> > Subject: Re: [Koha-devel] Conference on Koha for 2010 NOT KOHACON NZ > To: "'David Schuster'" <dschu...@tx.rr.com>, > <koha-devel@lists.koha.org> > Message-ID: <a7d7e8d0b30c465ab4ac59d6b2d64...@inspiron510m> > Content-Type: text/plain; charset="us-ascii" > > I would recommend holding off on any US event until 2011 to give KohaCon NZ > every chance to be successful. The alternative would be smaller, regional > gatherings in the US early in 2010, but nothing after, say, the start of > your summer. > My 2 cents, > Bob Birchall > Calyx > > > > -----Original Message----- > > From: koha-devel-boun...@lists.koha.org > [mailto:koha-devel-boun...@lists.koha.org] On > > Behalf Of David Schuster > > Sent: Tuesday, 6 October 2009 5:19 AM > > To: koha-devel@lists.koha.org > > Subject: [Koha-devel] Conference on Koha for 2010 NOT KOHACON NZ > > > > > > 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-tp25755583p25755583.html > > Sent from the Koha - Dev mailing list archive at Nabble.com. > > > > _______________________________________________ > > Koha-devel mailing list > > Koha-devel@lists.koha.org > > http://lists.koha.org/mailman/listinfo/koha-devel > > No virus found in this incoming message. > > Checked by AVG - www.avg.com > > Version: 8.5.409 / Virus Database: 270.14.3/2415 - Release Date: 10/05/09 > 06:19:00 > > > > ------------------------------ > > Message: 7 > Date: Tue, 6 Oct 2009 11:32:21 +0530 > From: Koustubha Kale <kmk...@anantcorp.com> > Subject: Re: [Koha-devel] Google transliteration for koha opac. > Trouble with IE.. > To: koha-devel@lists.koha.org > Message-ID: > <81fae620910052302o7be5eb41g9f25ceda162ea...@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > On Mon, Oct 5, 2009 at 7:03 PM, Koustubha Kale <kmk...@anantcorp.com> > wrote: > > 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? > > > > Sorry about double posting this but I never got a copy of this mail > from the list although that option is set to yes in my list > preferences. So not sure of it made it to the list. I have now set the > acknowledge preference to yes so lets see if I get an acknowledgement > AND a copy of the mail from the list. > > Anyone with google transliteration experience on the list please help > as this is quite a useful feature for libraries with Indian language > catalouges.. > > 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: 8 > Date: Tue, 6 Oct 2009 11:54:06 +0530 > From: savitra sirohi <savitra.sir...@osslabs.biz> > Subject: Re: [Koha-devel] Google transliteration for koha opac. > Trouble with IE.. > To: Koustubha Kale <kmk...@anantcorp.com> > Cc: koha-devel@lists.koha.org > Message-ID: > <8cf6c9ba0910052324n1d505c79q9eede238127d0...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Kousubha, > > We have done this already, here is the patch. > > Thanks, > Savitra Sirohi > Nucsoft OSS labs > http://www.osslabs.biz > > This is available only on the masthead search box in the OPAC. > > User has to enter a word in english and press space or return to > transliterate the word. The destination language can be selected from > a drop down list. User can temporarily turn on/off the feature by > using "ctrl +g". > > A system preference - GoogleIndicTransliteration can be used to turn > on this feature. > --- > koha-tmpl/opac-tmpl/prog/en/css/opac.css | 5 +++ > .../opac-tmpl/prog/en/includes/doc-head-close.inc | 5 +++ > koha-tmpl/opac-tmpl/prog/en/includes/masthead.inc | 4 +- > .../prog/en/js/googleindictransliteration.js | 29 > ++++++++++++++++++++ > opac/opac-main.pl | 5 +++ > opac/opac-search.pl | 5 +++ > 6 files changed, 51 insertions(+), 2 deletions(-) > create mode 100644 > koha-tmpl/opac-tmpl/prog/en/js/googleindictransliteration.js > > diff --git a/koha-tmpl/opac-tmpl/prog/en/css/opac.css > b/koha-tmpl/opac-tmpl/prog/en/css/opac.css > index de320d6..0c5c8d6 100644 > --- a/koha-tmpl/opac-tmpl/prog/en/css/opac.css > +++ b/koha-tmpl/opac-tmpl/prog/en/css/opac.css > @@ -1097,6 +1097,11 @@ float : right; > width: 100%; > } > > +#translControl{ > +float : left; > +padding-left : .4em; > +} > + > .clearfix:after { > content: "."; > display: block; > diff --git a/koha-tmpl/opac-tmpl/prog/en/includes/doc-head-close.inc > b/koha-tmpl/opac-tmpl/prog/en/includes/doc-head-close.inc > index 2238fba..eeed1a5 100644 > --- a/koha-tmpl/opac-tmpl/prog/en/includes/doc-head-close.inc > +++ b/koha-tmpl/opac-tmpl/prog/en/includes/doc-head-close.inc > @@ -80,3 +80,8 @@ > //]]> > </script><!-- /TMPL_IF --> > <link rel="unapi-server" type="application/xml" title="unAPI" > href="<!-- TMPL_VAR NAME="OPACBaseURL" -->/cgi-bin/koha/unapi" /> > +<!-- TMPL_IF NAME="GoogleIndicTransliteration" --> > + <script type="text/javascript" > src="http://www.google.com/jsapi";></script> > + <script type="text/javascript" language="javascript" > src="<!-- TMPL_VAR NAME="themelang" > -->/js/googleindictransliteration.js"></script> > +<!-- /TMPL_IF --> > + > diff --git a/koha-tmpl/opac-tmpl/prog/en/includes/masthead.inc > b/koha-tmpl/opac-tmpl/prog/en/includes/masthead.inc > index b118d18..058615b 100644 > --- a/koha-tmpl/opac-tmpl/prog/en/includes/masthead.inc > +++ b/koha-tmpl/opac-tmpl/prog/en/includes/masthead.inc > @@ -55,9 +55,9 @@ > <option value="callnum">Call Number</option> > <!-- /TMPL_IF --></select> > <!-- TMPL_IF NAME="ms_value" --> > - <input type="text" name="q" value="<!-- TMPL_VAR > ESCAPE="HTML" NAME="ms_value" -->" class="left" style="width: 35%; > font-size: 111%;" /> > + <input type="text" id = "transl1" name="q" value="<!-- > TMPL_VAR ESCAPE="HTML" NAME="ms_value" -->" class="left" style="width: > 35%; font-size: 100%;"/><div id="translControl"></div> > <!-- TMPL_ELSE --> > - <input type="text" name="q" class="left" style="width: 35%; > font-size: 111%;" /> > + <input type="text" id = "transl1" name="q" class="left" > style="width: 35%; font-size: 100%;"/><div id="translControl"></div> > <!-- /TMPL_IF --> > <!-- TMPL_UNLESS NAME="opac_limit_override" --> > <!-- TMPL_IF name="mylibraryfirst" --> > diff --git a/koha-tmpl/opac-tmpl/prog/en/js/googleindictransliteration.js > b/koha-tmpl/opac-tmpl/prog/en/js/googleindictransliteration.js > new file mode 100644 > index 0000000..414cadd > --- /dev/null > +++ b/koha-tmpl/opac-tmpl/prog/en/js/googleindictransliteration.js > @@ -0,0 +1,29 @@ > + // Load the Google Transliteration API > + google.load("elements", "1", { > + packages: "transliteration" > + }); > + > + function onLoad() { > + var options = { > + sourceLanguage: 'en', > + destinationLanguage: ['hi','kn','ml','ta','te'], > + shortcutKey: 'ctrl+g', > + transliterationEnabled: true > + }; > + > + // Create an instance on TransliterationControl with the required > + // options. > + var control = > + new > google.elements.transliteration.TransliterationControl(options); > + > + // Enable transliteration in the textfields with the given ids. > + var ids = [ "transl1" ]; > + control.makeTransliteratable(ids); > + > + // Show the transliteration control which can be used to toggle > between > + // English and Hindi and also choose other destination language. > + control.showControl('translControl'); > + } > + google.setOnLoadCallback(onLoad); > + > + > diff --git a/opac/opac-main.pl b/opac/opac-main.pl > index 5a56db0..1f4d8d5 100755 > --- a/opac/opac-main.pl > +++ b/opac/opac-main.pl > @@ -56,4 +56,9 @@ $template->param( > koha_news_count => $koha_news_count > ); > > +# If GoogleIndicTransliteration system preference is On Set paramter > to load Google's javascript in OPAC search screens > +if (C4::Context->preference('GoogleIndicTransliteration')) { > + $template->param('GoogleIndicTransliteration' => 1); > +} > + > output_html_with_http_headers $input, $cookie, $template->output; > diff --git a/opac/opac-search.pl b/opac/opac-search.pl > index ae7f4ea..e1e66a9 100755 > --- a/opac/opac-search.pl > +++ b/opac/opac-search.pl > @@ -640,4 +640,9 @@ if ($cgi->param('format') && $cgi->param('format') > =~ /rss/) { > $content_type = 'html' > } > > +# If GoogleIndicTransliteration system preference is On Set paramter > to load Google's javascript in OPAC search screens > +if (C4::Context->preference('GoogleIndicTransliteration')) { > + $template->param('GoogleIndicTransliteration' => 1); > +} > + > output_with_http_headers $cgi, $cookie, $template->output, $content_type; > -- > 1.5.6 > > > > On Mon, Oct 5, 2009 at 7:03 PM, Koustubha Kale <kmk...@anantcorp.com> > wrote: > > 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 > > _______________________________________________ > > Koha-devel mailing list > > Koha-devel@lists.koha.org > > http://lists.koha.org/mailman/listinfo/koha-devel > > > > > ------------------------------ > > _______________________________________________ > Koha-devel mailing list > Koha-devel@lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel > > End of Koha-devel Digest, Vol 47, Issue 6 > ***************************************** >
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
