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 ch

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

[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.d

[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 ... wher

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

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 upg

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.deb

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 Ka

[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 b

[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.

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 mig

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 labele

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 cof

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] 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" witho

[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 on

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, Ne

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, Ne