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, <[email protected]> wrote: > Send Koha-devel mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > Subject: [Koha-devel] Google transliteration for koha opac. Trouble > with IE.. > To: [email protected] > Message-ID: > <[email protected]> > 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 <[email protected]> > Subject: [Koha-devel] Conference on Koha for 2010 NOT KOHACON NZ > To: [email protected] > Message-ID: <[email protected]> > 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 <[email protected]> > Subject: [Koha-devel] Way to limit by 2 locations at the same time > To: [email protected] > Message-ID: <[email protected]> > 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 <[email protected]> > Subject: [Koha-devel] Koha 3.0 total number of books, cds, dvds, > journals and others > To: [email protected] > Message-ID: > <[email protected]> > 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 <[email protected]> > Subject: Re: [Koha-devel] Koha 3.0 total number of books, cds, dvds, > journals and others > To: Zico <[email protected]> > Cc: [email protected] > 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 > > [email protected] > > 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" <[email protected]> > Subject: Re: [Koha-devel] Conference on Koha for 2010 NOT KOHACON NZ > To: "'David Schuster'" <[email protected]>, > <[email protected]> > 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: [email protected] > [mailto:[email protected]] On > > Behalf Of David Schuster > > Sent: Tuesday, 6 October 2009 5:19 AM > > To: [email protected] > > 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 > > [email protected] > > 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 <[email protected]> > Subject: Re: [Koha-devel] Google transliteration for koha opac. > Trouble with IE.. > To: [email protected] > Message-ID: > <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1 > > On Mon, Oct 5, 2009 at 7:03 PM, Koustubha Kale <[email protected]> > 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 <[email protected]> > Subject: Re: [Koha-devel] Google transliteration for koha opac. > Trouble with IE.. > To: Koustubha Kale <[email protected]> > Cc: [email protected] > Message-ID: > <[email protected]> > 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 <[email protected]> > 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 > > [email protected] > > http://lists.koha.org/mailman/listinfo/koha-devel > > > > > ------------------------------ > > _______________________________________________ > Koha-devel mailing list > [email protected] > http://lists.koha.org/mailman/listinfo/koha-devel > > End of Koha-devel Digest, Vol 47, Issue 6 > ***************************************** >
_______________________________________________ Koha-devel mailing list [email protected] http://lists.koha.org/mailman/listinfo/koha-devel
