Re: [Koha] language link

2014-03-20 Thread Bernardo Gonzalez Kriegel
Hi,
which letter do you want to correct?

(perhaps հայերեն instead of Հայերեն ?)

Regards,
Bernardo


-- 
Bernardo Gonzalez Kriegel
bgkrie...@gmail.com


On Thu, Mar 20, 2014 at 2:40 AM, Araik Manukyan  wrote:

> Dear community,
>
> · In opac  and intranet pages  there  are  a lnik which change
> language in which we want to correct (  <
> http://opac.flib.sci.am/cgi-bin/koha/opac-changelanguage.pl?language=hy-Armn>
> Հայերէն) a letter but can't find where that file  is stored which contain
> that word.
>
> · Best Regards,
>
> · Arayik.
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] language link

2014-03-20 Thread Bernardo Gonzalez Kriegel
Hi,
I opened a Bug for this (
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11973)

For the moment, you can execute the following sentence on MySQL

 UPDATE language_descriptions SET description = 'Հայերեն' WHERE subtype =
'hy' AND lang = 'hy';

Regards,
Bernardo



-- 
Bernardo Gonzalez Kriegel
bgkrie...@gmail.com


On Thu, Mar 20, 2014 at 7:52 AM,  wrote:

> that should be Հայերեն instead of Հայերէն
> In 3.12 it is:Languages: English   Հայերէն
>
> > Hi,
> > which letter do you want to correct?
> >
> > (perhaps հայերեն instead of Հայերեն ?)
> >
> > Regards,
> > Bernardo
> >
> >
> > --
> > Bernardo Gonzalez Kriegel
> > bgkrie...@gmail.com
> >
> >
> > On Thu, Mar 20, 2014 at 2:40 AM, Araik Manukyan 
> wrote:
> >
> >> Dear community,
> >>
> >> · In opac  and intranet pages  there  are  a lnik which change
> >> language in which we want to correct (  <
> >>
> http://opac.flib.sci.am/cgi-bin/koha/opac-changelanguage.pl?language=hy-Armn
> >
> >> Հայերէն) a letter but can't find where that file  is stored which
> >> contain
> >> that word.
> >>
> >> · Best Regards,
> >>
> >> · Arayik.
> >>
> >> ___
> >> Koha mailing list  http://koha-community.org
> >> Koha@lists.katipo.co.nz
> >> http://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> > ___
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Report Help - With Rollup

2014-03-20 Thread Nicole Engard
Hi all,

I need some help with a report that has With RollUp in it.  I have
used this before and had no problem, but for this report it keeps
showing the last value 2 times at the bottom instead of 'grand total'.

So here's how I started:

select IFNULL(a.lib,'*GRAND TOTAL*') as location, count(s.datetime) as
circs from statistics s left join items i using (itemnumber) left join
borrowers p using (borrowernumber) LEFT JOIN authorised_values a ON
(i.location=a.authorised_value) where s.type in ('issue','renew') and
p.categorycode != 'LIBRARYUSE' and s.branch=<> and a.category='LOC' and s.datetime between
<> and <> group by i.location with rollup

This runs and is right, but at the end it repeats the last shelving
location instead of showing 'Grand Total'.  Next I tried:

select if(i.location is null, '*GRAND TOTAL*', a.lib) as location,
count(s.datetime) as circs
from statistics s
left join items i using (itemnumber)
left join borrowers p using (borrowernumber)
LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
and s.branch='BAILEYCOVE'
and a.category='LOC' and s.datetime between '2014-03-19'
and '2014-03-20'
group by i.location with rollup


This repeated the same location over and over.  So then I tried this:

select ifnull(i.location, 'GRAND TOTAL') as code, a.lib as location,
count(s.datetime) as circs
from statistics s
left join items i using (itemnumber)
left join borrowers p using (borrowernumber)
LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
and s.branch=<>
and a.category='LOC' and s.datetime between <>
and <>
group by i.location with rollup

Which shows grand total, but still repeats the darn location name again.

And this which shows only one location over and over:

select case a.location when null 'grand total' else a.lib as location,
count(s.datetime) as circs
from statistics s
left join items i using (itemnumber)
left join borrowers p using (borrowernumber)
LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
and s.branch=<>
and a.category='LOC' and s.datetime between <>
and <>
group by i.location with rollup


I'm up for any suggestion that gets me to have the final line just
have the total and not a false location name.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] New patron restrictions data

2014-03-20 Thread Nicole Engard
Hi all,

I'm wondering where in the DB the new restrictions data is stored for
patrons.  I have a patron with 2 restrictions on her account and when
I look at borrowers.debarred I only see 1 of them. The other shows
when I view the record in the staff client so the data has to be
somewhere ... where is it? :)

Thanks
Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] New patron restrictions data

2014-03-20 Thread Heather Braum (NEKLS)
If it's the old restrictions data (from before the library upgraded to
3.14) the data is located in the borrowers table, in the borrowers.debarred
and borrowers.debarred comment fields.

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*





On Thu, Mar 20, 2014 at 9:00 AM, Nicole Engard  wrote:

> Hi all,
>
> I'm wondering where in the DB the new restrictions data is stored for
> patrons.  I have a patron with 2 restrictions on her account and when
> I look at borrowers.debarred I only see 1 of them. The other shows
> when I view the record in the staff client so the data has to be
> somewhere ... where is it? :)
>
> Thanks
> Nicole
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] New patron restrictions data

2014-03-20 Thread Nicole Engard
Yup, and 1 of the restrictions is stored there, but I have 2
restrictions on the patron record and the other isn't anywhere in the
borrowers table that I can see.

Nicole

On Thu, Mar 20, 2014 at 9:49 AM, Heather Braum (NEKLS)  wrote:
> If it's the old restrictions data (from before the library upgraded to 3.14)
> the data is located in the borrowers table, in the borrowers.debarred and
> borrowers.debarred comment fields.
>
> Heather Braum
> NExpress Coordinator
> Resource Sharing Librarian
> Northeast Kansas Library System
> hbr...@nekls.org
>
> "The illiterate of the 21st century will not be those cannot read and write,
> but those who cannot learn, unlearn, and relearn." ~Alvin Toffler,
> *Rethinking the Future*
>
>
>
>
>
> On Thu, Mar 20, 2014 at 9:00 AM, Nicole Engard  wrote:
>>
>> Hi all,
>>
>> I'm wondering where in the DB the new restrictions data is stored for
>> patrons.  I have a patron with 2 restrictions on her account and when
>> I look at borrowers.debarred I only see 1 of them. The other shows
>> when I view the record in the staff client so the data has to be
>> somewhere ... where is it? :)
>>
>> Thanks
>> Nicole
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] New patron restrictions data

2014-03-20 Thread Jonathan Druart
Hello Nicole,

It is in the borrower_debarments table.

Regards,
Jonathan

2014-03-20 15:00 GMT+01:00 Nicole Engard :
> Hi all,
>
> I'm wondering where in the DB the new restrictions data is stored for
> patrons.  I have a patron with 2 restrictions on her account and when
> I look at borrowers.debarred I only see 1 of them. The other shows
> when I view the record in the staff client so the data has to be
> somewhere ... where is it? :)
>
> Thanks
> Nicole
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] New patron restrictions data

2014-03-20 Thread Heather Braum (NEKLS)
Thank you Jonathan for correcting me. I completely misread Nicole's
question as the data she had was in the borrower_debarments table and she
was asking where was the other data was. :) I need much more coffee this
morning!

Heather Braum
NExpress Coordinator
Resource Sharing Librarian
Northeast Kansas Library System
hbr...@nekls.org

"The illiterate of the 21st century will not be those cannot read
and write, but those who cannot learn, unlearn, and relearn." ~Alvin
Toffler, *Rethinking the Future*





On Thu, Mar 20, 2014 at 9:51 AM, Jonathan Druart <
jonathan.dru...@biblibre.com> wrote:

> Hello Nicole,
>
> It is in the borrower_debarments table.
>
> Regards,
> Jonathan
>
> 2014-03-20 15:00 GMT+01:00 Nicole Engard :
> > Hi all,
> >
> > I'm wondering where in the DB the new restrictions data is stored for
> > patrons.  I have a patron with 2 restrictions on her account and when
> > I look at borrowers.debarred I only see 1 of them. The other shows
> > when I view the record in the staff client so the data has to be
> > somewhere ... where is it? :)
> >
> > Thanks
> > Nicole
> > ___
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Fwd: [ILOSC.22669] Data migration: from excel to KOHA

2014-03-20 Thread Urmila G
-- Forwarded message --
From: baiju joy 
Date: Thu, Mar 20, 2014 at 12:49 PM
Subject: [ILOSC.22669] Data migration: from excel to KOHA
To: il...@googlegroups.com


 Dear Professionals,

I have 50 number of bound volumes of a Journal in excel sheet. I need to
import the data as one biblio (record) and  add all 50 number as item
(attachment) in to KOHA. How it is possible.

Sincerely

Baiju Joy

Senior Research Fellow

Central Library

Kerala Agricultural University

-- 
You received this message because you are subscribed to the Google Groups
"Indian Librarians Online Study Circle" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to ilosc+unsubscr...@googlegroups.com.
To post to this group, send email to il...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



-- 
Thanks & Regards
Urmila Ghadge
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Need help printing more than 3 digits on the top line of a spine label in KHOA

2014-03-20 Thread Carlock, Ruth
Our IT person installed KOHA last fall and I am still not able to print out
spine labels  I can print barcode labels.  We have finally got the spine
labels we purchased lined up so they will print.  But my problem is that we
use QUARTO for items 25-30 cm. tall and FOLIO for items over 30 cm. tall.
For some reason the first line of our spine label will not print more than
3 letters.  We use Library of Congress classification and I know the top
line of an LC # would not be more than 3 letters.  So I don't know if this
has something to do with information on Library of Congress, or something
to do with the way the printer is set up.  But when I try to print out a
label with QUARTO at the top, I get

QUA

R

.T

O

QA

76.76

.H94

L44

2003

Instead of

QUARTO

QA

76.76

.H94

L44

2003



I have communicated with another librarian at an academic library who is
using KOHA and she is able to print out the above call number like it
should print out.  So I know there is a problem with a setting somewhere.



Can you help me?



Ruth



Ruth M. Carlock
Library Director
Levitt Library
York College,
York, NE  68467
402-363-5703 | www.york.edu

The mission of York College is to transform lives through Christ-centered
education and to equip students for lifelong service to God, family, and
society.

Please consider the environment before printing this e-mail

Follow us!
facebook: York College Online
twitter: @YCOnline
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha Digest, Vol 101, Issue 43

2014-03-20 Thread DP Tripathi
Dear Sir/Madam,
Please visit the link given below to know the data migration procedure from
excel to Koha.
http://koha.librarianguide.in/?page_id=971
http://koha.librarianguide.in/?page_id=973

Hope this will solve your problem.
Thanks with kind regards,
DP Tripathi

Subject: [ILOSC.22669] Data migration: from excel to KOHA
To: il...@googlegroups.com


 Dear Professionals,

I have 50 number of bound volumes of a Journal in excel sheet. I need to
import the data as one biblio (record) and  add all 50 number as item
(attachment) in to KOHA. How it is possible.

Sincerely

Baiju Joy

Senior Research Fellow

Central Library

Kerala Agricultural University


On Thu, Mar 20, 2014 at 9:21 PM,  wrote:

> Send Koha mailing list submissions to
> koha@lists.katipo.co.nz
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.katipo.co.nz/mailman/listinfo/koha
> or, via email, send a message with subject or body 'help' to
> koha-requ...@lists.katipo.co.nz
>
> You can reach the person managing the list at
> koha-ow...@lists.katipo.co.nz
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Koha digest..."
>
>
> Today's Topics:
>
>1. Report Help - With Rollup (Nicole Engard)
>2. New patron restrictions data (Nicole Engard)
>3. Re: New patron restrictions data (Heather Braum (NEKLS))
>4. Re: New patron restrictions data (Jonathan Druart)
>5. Re: New patron restrictions data (Nicole Engard)
>6. Re: New patron restrictions data (Heather Braum (NEKLS))
>7. Fwd: [ILOSC.22669] Data migration: from excel to KOHA (Urmila G)
>8. Need help printing more than 3 digits on the top line of a
>   spine label in KHOA (Carlock, Ruth)
>
>
> --
>
> Message: 1
> Date: Thu, 20 Mar 2014 08:11:15 -0500
> From: Nicole Engard 
> To: Koha 
> Subject: [Koha] Report Help - With Rollup
> Message-ID:
>  4cft7qa6mvgbo...@mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Hi all,
>
> I need some help with a report that has With RollUp in it.  I have
> used this before and had no problem, but for this report it keeps
> showing the last value 2 times at the bottom instead of 'grand total'.
>
> So here's how I started:
>
> select IFNULL(a.lib,'*GRAND TOTAL*') as location, count(s.datetime) as
> circs from statistics s left join items i using (itemnumber) left join
> borrowers p using (borrowernumber) LEFT JOIN authorised_values a ON
> (i.location=a.authorised_value) where s.type in ('issue','renew') and
> p.categorycode != 'LIBRARYUSE' and s.branch=< branch|branches>> and a.category='LOC' and s.datetime between
> <> and < (-mm-dd)|date>> group by i.location with rollup
>
> This runs and is right, but at the end it repeats the last shelving
> location instead of showing 'Grand Total'.  Next I tried:
>
> select if(i.location is null, '*GRAND TOTAL*', a.lib) as location,
> count(s.datetime) as circs
> from statistics s
> left join items i using (itemnumber)
> left join borrowers p using (borrowernumber)
> LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
> where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
> and s.branch='BAILEYCOVE'
> and a.category='LOC' and s.datetime between '2014-03-19'
> and '2014-03-20'
> group by i.location with rollup
>
>
> This repeated the same location over and over.  So then I tried this:
>
> select ifnull(i.location, 'GRAND TOTAL') as code, a.lib as location,
> count(s.datetime) as circs
> from statistics s
> left join items i using (itemnumber)
> left join borrowers p using (borrowernumber)
> LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
> where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
> and s.branch=<>
> and a.category='LOC' and s.datetime between < renewed between (-mm-dd)|date>>
> and <>
> group by i.location with rollup
>
> Which shows grand total, but still repeats the darn location name again.
>
> And this which shows only one location over and over:
>
> select case a.location when null 'grand total' else a.lib as location,
> count(s.datetime) as circs
> from statistics s
> left join items i using (itemnumber)
> left join borrowers p using (borrowernumber)
> LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
> where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
> and s.branch=<>
> and a.category='LOC' and s.datetime between < renewed between (-mm-dd)|date>>
> and <>
> group by i.location with rollup
>
>
> I'm up for any suggestion that gets me to have the final line just
> have the total and not a false location name.
>
>
> --
>
> Message: 2
> Date: Thu, 20 Mar 2014 09:00:58 -0500
> From: Nicole Engard 
> To: Koha 
> Subject: [Koha] New patron restrictions data
> Message-ID:
> <
> cac0k6vfuk45oondrst0stdrggj2sdwjpwp6j+6lcprj9nld...@

Re: [Koha] Report Help - With Rollup

2014-03-20 Thread Nick Clemens
It looks like there isn't a direct way to do that, see
here,
 but you can wrap the query up and join it to authorised values and make it
work with the caution that any circs without location defined will also end
up labeled "Grand Total' and should be fixed before running the report.

SELECT IFNULL(a.lib,'Grand Total') as Location, thingy.circs AS Circulations
FROM (select i.location as loction, count(s.datetime) as
circs from statistics s left join items i using (itemnumber)
left join borrowers p using (borrowernumber)
where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE' and
s.branch=<> and s.datetime between
<> and <>
group by i.location with rollup ) AS thingy
LEFT JOIN authorised_values a on thingy.loction=a.authorised_value



On Thu, Mar 20, 2014 at 9:11 AM, Nicole Engard  wrote:

> Hi all,
>
> I need some help with a report that has With RollUp in it.  I have
> used this before and had no problem, but for this report it keeps
> showing the last value 2 times at the bottom instead of 'grand total'.
>
> So here's how I started:
>
> select IFNULL(a.lib,'*GRAND TOTAL*') as location, count(s.datetime) as
> circs from statistics s left join items i using (itemnumber) left join
> borrowers p using (borrowernumber) LEFT JOIN authorised_values a ON
> (i.location=a.authorised_value) where s.type in ('issue','renew') and
> p.categorycode != 'LIBRARYUSE' and s.branch=< branch|branches>> and a.category='LOC' and s.datetime between
> <> and < (-mm-dd)|date>> group by i.location with rollup
>
> This runs and is right, but at the end it repeats the last shelving
> location instead of showing 'Grand Total'.  Next I tried:
>
> select if(i.location is null, '*GRAND TOTAL*', a.lib) as location,
> count(s.datetime) as circs
> from statistics s
> left join items i using (itemnumber)
> left join borrowers p using (borrowernumber)
> LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
> where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
> and s.branch='BAILEYCOVE'
> and a.category='LOC' and s.datetime between '2014-03-19'
> and '2014-03-20'
> group by i.location with rollup
>
>
> This repeated the same location over and over.  So then I tried this:
>
> select ifnull(i.location, 'GRAND TOTAL') as code, a.lib as location,
> count(s.datetime) as circs
> from statistics s
> left join items i using (itemnumber)
> left join borrowers p using (borrowernumber)
> LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
> where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
> and s.branch=<>
> and a.category='LOC' and s.datetime between < renewed between (-mm-dd)|date>>
> and <>
> group by i.location with rollup
>
> Which shows grand total, but still repeats the darn location name again.
>
> And this which shows only one location over and over:
>
> select case a.location when null 'grand total' else a.lib as location,
> count(s.datetime) as circs
> from statistics s
> left join items i using (itemnumber)
> left join borrowers p using (borrowernumber)
> LEFT JOIN authorised_values a ON (i.location=a.authorised_value)
> where s.type in ('issue','renew') and p.categorycode != 'LIBRARYUSE'
> and s.branch=<>
> and a.category='LOC' and s.datetime between < renewed between (-mm-dd)|date>>
> and <>
> group by i.location with rollup
>
>
> I'm up for any suggestion that gets me to have the final line just
> have the total and not a false location name.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Nick Clemens
Quechee & Wilder Libraries
n...@quecheelibrary.org
http://www.QuecheeLibrary.org
Q (802) 295-1232 W (802) 295-6341
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] New patron restrictions data

2014-03-20 Thread Nicole Engard
Thank you all!

Nicole

On Thu, Mar 20, 2014 at 9:55 AM, Heather Braum (NEKLS)  wrote:
> Thank you Jonathan for correcting me. I completely misread Nicole's question
> as the data she had was in the borrower_debarments table and she was asking
> where was the other data was. :) I need much more coffee this morning!
>
> Heather Braum
> NExpress Coordinator
> Resource Sharing Librarian
> Northeast Kansas Library System
> hbr...@nekls.org
>
> "The illiterate of the 21st century will not be those cannot read and write,
> but those who cannot learn, unlearn, and relearn." ~Alvin Toffler,
> *Rethinking the Future*
>
>
>
>
>
> On Thu, Mar 20, 2014 at 9:51 AM, Jonathan Druart
>  wrote:
>>
>> Hello Nicole,
>>
>> It is in the borrower_debarments table.
>>
>> Regards,
>> Jonathan
>>
>> 2014-03-20 15:00 GMT+01:00 Nicole Engard :
>> > Hi all,
>> >
>> > I'm wondering where in the DB the new restrictions data is stored for
>> > patrons.  I have a patron with 2 restrictions on her account and when
>> > I look at borrowers.debarred I only see 1 of them. The other shows
>> > when I view the record in the staff client so the data has to be
>> > somewhere ... where is it? :)
>> >
>> > Thanks
>> > Nicole
>> > ___
>> > Koha mailing list  http://koha-community.org
>> > Koha@lists.katipo.co.nz
>> > http://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Report Help - With Rollup

2014-03-20 Thread Nicole Engard
Thank you so much Nick!!

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Report Help - With Rollup

2014-03-20 Thread Nicole Engard
Okay, any idea why the Juveasy might be showing 2 times?

http://screencast.com/t/6dbByW4eZ

I added the location code in case that was it - they're identical as
are their numbers.

On Thu, Mar 20, 2014 at 1:50 PM, Nicole Engard  wrote:
> Thank you so much Nick!!
>
> Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Koha error at Printer Profile

2014-03-20 Thread Anthony Mao
Hi community,

I am using Koha 3.14.04 under Ubuntu 12.04.

There is an error while I try edit Printer profle.

Home › Tools › Patron card creator › Printer profiles › Edit Printer Profile

After click save button, screen shows fellowing message:

-->
Software error:

Can't call method "save" without a package or object reference at
/usr/share/koha/intranet/cgi-bin/patroncards/edit-profile.pl line 72.

For help, please send mail to the webmaster ([no address given]),
giving this error message and the time and date of the error.
<--

Can someone give me a hand.


-- 
Wishing you all the best. . . .


Anthony Mao 毛慶禎
+886 2 29052334 (voice)
+ 886 2 29017405 (FAX)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Asking how to set up the Overdrive API

2014-03-20 Thread Agnes Rivers-Moore
Hello

We have an Overdrive subscription through a consortium, and Koha 3.14.

The Overdrive Developer Portal wants to know which APIs I am signing up for, 
and I checked off a few.

While I wait for acceptance and the security keys - does anyone know which APIs 
I should ask for?
That is, which one or ones are integrated into Koha?

Are there any other settings that are needed for this to work?

If anyone has this up and running I would like to hear about your experience.

Thank you
Agnes

--
Agnes Rivers-Moore
CEO / Chief Librarian
Hanover Public Library
451 10th Ave,
Hanover, ON, N4N 2P1

Tel: 519.364.1420 | Fax: 519.364.1747
Email: a...@hanover.ca | Web: 
www.hanoverlibrary.ca

Please consider the environment before printing this message or attachments.
Support your library! Could you make a donation, volunteer, or remember us in 
your will?
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] unable to locate koha-conf.xml

2014-03-20 Thread SATISH
Hello Sir,

@Indranil: Thank you, as you indicated, koha-conf.xml is traceable at
/etc/koha/sites//koha-conf.xml.

My actual problem is:

Firstly I added one RECORD with 3 items along with Dewey Number.
Later I added 10 items to the same RECORD,
after adding many such records in to the koha db,

Next I tried to run, sudo koha-rebuild-zebra --full -v instancename

Still, I can not see, Dewey number is not reflecting for 10 items which are
added later to the same record.


Next I tried for ./rebuild_zebra.pl -run-as-root -b -r -a
and got following error:
unable to locate Koha configuration file koha-conf.xml at
/usr/share/koha/lib/C4/Context.pm line 372. ( for this I got answer from
Mr. Indranil)
and other sources, redirected me to copy and paste the koha-conf.xml file
from

/etc/koha/sites//koha-conf.xml  to   /etc/koha/ directory.

Please advice me what might be causing this? since everything is being done
by packages?

click here to view my problem: (click here)

History: Installed koha 3.10 on Ubuntu 12.04.3 LTS (GNU/Linux
3.5.0-47-generic i686) via packages method and later upgraded to 3.14.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] unable to locate koha-conf.xml

2014-03-20 Thread SATISH
Hello Sir,

@Indranil: Thank you, as you indicated, koha-conf.xml is traceable at
/etc/koha/sites//koha-conf.xml.

My actual problem is:

Firstly I added one RECORD with 3 items along with Dewey Number.
Later I added 10 items to the same RECORD,
after adding many such records in to the koha db,

Next I tried to run, sudo koha-rebuild-zebra --full -v instancename

Still, I can not see, Dewey number is not reflecting for 10 items which are
added later to the same record.


Next I tried for ./rebuild_zebra.pl -run-as-root -b -r -a
and got following error:
unable to locate Koha configuration file koha-conf.xml at
/usr/share/koha/lib/C4/Context.pm line 372. ( for this I got answer from
Mr. Indranil)
and other sources, redirected me to copy and paste the koha-conf.xml file
from

/etc/koha/sites//koha-conf.xml  to   /etc/koha/ directory.

Please advice me what might be causing this? since everything is being done
by packages?

click here to view my problem: (click
here
)

History: Installed koha 3.10 on Ubuntu 12.04.3 LTS (GNU/Linux
3.5.0-47-generic i686) via packages method and later upgraded to 3.14.


With Thanks
Satish
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha