[Koha-devel] Koha 3.0 total number of books, cds, dvds, journals and others
Nicholas van Rheede van Oudtshoorn
vanoudt at gmail.com
Tue Oct 6 08:51:53 CEST 2009
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 at lists.koha.org> wrote:
> Send Koha-devel mailing list submissions to
> koha-devel at 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 at lists.koha.org
>
> You can reach the person managing the list at
> koha-devel-owner at 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 at anantcorp.com>
> Subject: [Koha-devel] Google transliteration for koha opac. Trouble
> with IE..
> To: koha-devel at lists.koha.org
> Message-ID:
> <81fae620910050633m5fe51d21j7a7d180fc2b1ef86 at 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 at tx.rr.com>
> Subject: [Koha-devel] Conference on Koha for 2010 NOT KOHACON NZ
> To: koha-devel at lists.koha.org
> Message-ID: <25755583.post at 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 <dschust1 at tx.rr.com>
> Subject: [Koha-devel] Way to limit by 2 locations at the same time
> To: koha-devel at lists.koha.org
> Message-ID: <25755923.post at 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 <mailzico at gmail.com>
> Subject: [Koha-devel] Koha 3.0 total number of books, cds, dvds,
> journals and others
> To: koha-devel at lists.koha.org
> Message-ID:
> <69621d830910051159s54a01473m9e460b6d648a3850 at 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 <mdhafen at tech.washk12.org>
> Subject: Re: [Koha-devel] Koha 3.0 total number of books, cds, dvds,
> journals and others
> To: Zico <mailzico at gmail.com>
> Cc: koha-devel at lists.koha.org
> Message-ID: <1254777546.12246.3.camel at 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 at 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" <bob at calyx.net.au>
> Subject: Re: [Koha-devel] Conference on Koha for 2010 NOT KOHACON NZ
> To: "'David Schuster'" <dschust1 at tx.rr.com>,
> <koha-devel at lists.koha.org>
> Message-ID: <A7D7E8D0B30C465AB4AC59D6B2D6488C at 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-bounces at lists.koha.org
> [mailto:koha-devel-bounces at lists.koha.org] On
> > Behalf Of David Schuster
> > Sent: Tuesday, 6 October 2009 5:19 AM
> > To: koha-devel at 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 at 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 <kmkale at anantcorp.com>
> Subject: Re: [Koha-devel] Google transliteration for koha opac.
> Trouble with IE..
> To: koha-devel at lists.koha.org
> Message-ID:
> <81fae620910052302o7be5eb41g9f25ceda162ea7ac at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> On Mon, Oct 5, 2009 at 7:03 PM, Koustubha Kale <kmkale at 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.sirohi at osslabs.biz>
> Subject: Re: [Koha-devel] Google transliteration for koha opac.
> Trouble with IE..
> To: Koustubha Kale <kmkale at anantcorp.com>
> Cc: koha-devel at lists.koha.org
> Message-ID:
> <8cf6c9ba0910052324n1d505c79q9eede238127d070b at 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 <kmkale at 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 at lists.koha.org
> > http://lists.koha.org/mailman/listinfo/koha-devel
> >
>
>
> ------------------------------
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
>
> End of Koha-devel Digest, Vol 47, Issue 6
> *****************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20091006/9c473c82/attachment-0003.htm>
More information about the Koha-devel
mailing list