- Koha - lists.katipo.co.nz

add language to Koha V 3.0
by vinod kumar 10 Jul '09

10 Jul '09

Could someone help me on the process to add bangla and malyalam languages to Koha. I have it working in my library in english so far, but all mine book are in malyalam and bangla languages. if there is any url or manual for it, pl give me its location. thanks very much. v. kumar

2 1

Fwd: koha
by Amit Gupta 10 Jul '09

10 Jul '09

Post this mail to koha mailing list directly. ---------- Forwarded message ---------- From: vinod kumar <vinod.kumar.trf(a)gmail.com> Date: Fri, Jul 10, 2009 at 1:10 PM Subject: koha To: amitddng135 <amitddng135(a)gmail.com> Ata Rahman told me a lot abt you and yr wrk in indian languages. i am working for a social organisation of south india, in bihar through my org. i have installed koha for their local inhouse librry and then need bangla and malyalam languges enabled in opac and for data entry can u help in this matter . is there a manual avaialble Ata Rahman told me to convey you his regards also. where r u located. may be sometime we will meet as i keep travelling to delhi every 3 to 4 moinths for my office work v. kumar -- *Cheers, Amit Gupta Nucsoft Osslabs amitddng135(a)gmail.com www.osslabs.biz *

1 0

Problem constructing a report
by Scott Zollars 10 Jul '09

10 Jul '09

I am trying to come up with a report that will list how many items were checked out in each Dewey area, their barcode and date. If I could get the author and title, that would be icing on the cake. I haven't figured out the last part. However, I figured out this for the first part: SELECT items.datelastborrowed,items.barcode,items.itemcallnumber, (TO_DAYS(06/01/2009))-TO_DAYS(06/30/2009)) FROM borrowers LEFT JOIN statistics on (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on (biblioitems.biblioitemnumber = items.biblioitemnumber) WHERE DATE (items.datelastborrowed) BETWEEN '2009-06-01' AND '2009-06-30' It shows that there are 3 pages of a report but when I run the report, I receive the following message: Content-type: text/html <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head><title>Koha Error</title></head> <body> <h1>Koha error</h1> <p>The following fatal error has occurred:</p> <pre><code>Can't use an undefined value as an ARRAY reference at /home/slb/_kohaclone/reports/guided_reports.pl line 461. </code></pre> <table> <tr><th>Apache</th><td> Server version: Apache/2.2.3 Server built: Sep 8 2008 08:59:32 </td></tr> <tr><th>Koha</th><td> 3.01.00.032</td></tr> <tr><th>Koha DB</th><td> 3.0100032</td></tr> <tr><th>MySQL</th><td> mysql Ver 14.12 Distrib 5.0.32 for pc-linux-gnu (x86_64) using readline 5.2 </td></tr> <tr><th>OS</th><td> Linux shin.ec2.liblime.com 2.6.21.7-2.fc8xen #1 SMP Fri Feb 15 12:34:28 EST 2008 x86_64</td></tr> <tr><th>Perl</th><td> 5.008008</td></tr> </table></body></html> I have constructed another report that gives me basically what I want but shows everything that is checked out since we went live with the system. That SQL is: SELECT items.datelastborrowed,items.itemcallnumber,items.barcode, FROM borrowers LEFT JOIN statistics on (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on (biblioitems.biblioitemnumber = items.biblioitemnumber) ORDER BY items.datelastborrowed desc,items.itemcallnumber desc,items.barcode desc So how do I get the date in example one to work with example 2? Scotty "You must try to generate happiness. If you aren't happy in one place, chances are you won't be happy anyplace" Ernie Banks, former Chicago Cub

6 7

Re: [Koha] Problem constructing a report
by Nora Blake 10 Jul '09

10 Jul '09

Hi Scott. Let me preface this by saying that I know nothing about SQL. A little while ago I got some help with a similar question. I needed a report that would generate a count of items added to the catalog by Dewey range. My report gathers data for a consortium implementation of Koha. I think you need to work the following elements into your statement: substring(itemcallnumber,1,1) as 'Call# range' - should be part of your SELECT statement for the item call number (I think). Group by substring(itemcallnumber,1,1) - should be part of your ORDER BY statement (I think). I tried to work these into your statement but I couldn't get it to work. It could be because I've got a different setup for my Koha system, or it could be because I'm all wet and this advice is useless. Maybe others can expand on this. Good luck, Nora ________________________ Nora Blake MassCat Manager P.O. Box 241 South Deerfield, MA 01373-0241 Toll Free in MA: 866-MASSCAT (627-7228) Local Phone: 413-665-5511 Email: nblake(a)masscat.org Website: http://www.masscat.org AIM: vegancatwoman Skype: veganlibrarian Skype: nora.blake -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Ryan Higgins Sent: Thursday, July 09, 2009 12:13 PM To: Scott Zollars Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Problem constructing a report Scott, you have an extra close-paren in that first to_days() bit. (TO_DAYS(06/01/2009)-TO_DAYS(06/30/2009)) is the corrected syntax, but adding that to the SELECT clause doesn't give you any useful information. I think you want something more like SELECT itemcallnumber, barcode, datetime, author, title from statistics LEFT JOIN items USING( itemnumber ) LEFT JOIN biblio USING( biblionumber ) WHERE type= 'issue' AND datetime > '2009-06-01' AND datetime < '2009-06-30' ORDER BY itemcallnumber Hope that helps, -- Ryan Higgins LibLime * Open-Source Solutions for Libraries Featuring KohaZOOM ILS 888-564-2457 x704 2009/7/8 Scott Zollars <ScottZ(a)labette.edu>: > I am trying to come up with a report that will list how many items were > checked out in each Dewey area, their barcode and date. If I could get the > author and title, that would be icing on the cake. I haven't figured out the > last part. However, I figured out this for the first part: > > > > SELECT items.datelastborrowed,items.barcode,items.itemcallnumber, > (TO_DAYS(06/01/2009))-TO_DAYS(06/30/2009)) FROM borrowers LEFT JOIN > statistics on (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN > items on (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on > (biblioitems.biblioitemnumber = items.biblioitemnumber) WHERE DATE > (items.datelastborrowed) BETWEEN '2009-06-01' AND '2009-06-30' > > > > It shows that there are 3 pages of a report but when I run the report, I > receive the following message: > > > > Content-type: text/html > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > > <html lang="en" xml:lang="en" > xmlns="http://www.w3.org/1999/xhtml"> > > <head><title>Koha Error</title></head> > > <body> > > > > <h1>Koha error</h1> > > <p>The following fatal error has occurred:</p> > > <pre><code>Can't use an undefined value as an ARRAY > reference at /home/slb/_kohaclone/reports/guided_reports.pl line 461. > > </code></pre> > > <table> > > <tr><th>Apache</th><td> Server version: Apache/2.2.3 > > Server built: Sep 8 2008 08:59:32 > > </td></tr> > > <tr><th>Koha</th><td> 3.01.00.032</td></tr> > > <tr><th>Koha DB</th><td> 3.0100032</td></tr> > > <tr><th>MySQL</th><td> mysql Ver 14.12 Distrib 5.0.32 > > for pc-linux-gnu (x86_64) using readline 5.2 > > </td></tr> > > <tr><th>OS</th><td> Linux shin.ec2.liblime.com 2.6.21.7-2.fc8xen #1 SMP > Fri Feb 15 12:34:28 EST 2008 x86_64</td></tr> > > <tr><th>Perl</th><td> 5.008008</td></tr> > > </table></body></html> > > > > I have constructed another report that gives me basically what I want but > shows everything that is checked out since we went live with the system. > That SQL is: > > > > SELECT items.datelastborrowed,items.itemcallnumber,items.barcode, FROM > borrowers LEFT JOIN statistics on > (statistics.borrowernumber=borrowers.borrowernumber) LEFT JOIN items on > (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on > (biblioitems.biblioitemnumber = items.biblioitemnumber) ORDER BY > items.datelastborrowed desc,items.itemcallnumber desc,items.barcode desc > > > > So how do I get the date in example one to work with example 2? > > > > Scotty > > "You must try to generate happiness. If you aren't happy in one place, > chances are you won't be happy anyplace" Ernie Banks, former Chicago Cub > > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Trouble circulating freshly imported items
by Vimal Kumar 10 Jul '09

10 Jul '09

Dear Friends, I am using Koha 3.03 with Debian Lenny. I got the following error while trying to check out records which were importing through MARC Import option in Tools. Koha error The following fatal error has occurred: No branchcode argument to new. Should be C4::Calendar->new(branchcode => $branchcode) at /usr/share/koha/lib/C4/Circulation.pm line 2306 How can I overcome this problem? -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1

mysqldump and backup
by Basu Talikoti 10 Jul '09

10 Jul '09

hi I have taken backup from the server which run koha 3.0 on centos and i want to load in other computer installed same version of koha. but give the following error; [root@localhost ~]# mysql -u root -p koha</root/Desktop/koha01july.sql Enter password: ERROR 1064 (42000) at line 3325: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '��<nrb��O<R�0,�Q}�9��R�,j�i��{��0�%�π1h8R} 3��]��2�hӱ�Ǉ:� ��m�' at line 1 [root@localhost ~]# it load up to 97 tables . when uploading systempreference table it give the above error Can anyone explain what the problem is and how to solve it.. basu

2 1

Validating bibliographic records
by Sébastien Hinderer 09 Jul '09

09 Jul '09

Hi, In our library we have two types of cataloguers: professional and non-professional ones. When a non-prrofesisional adds a record, we would like this record to b validated by a professional before being integrated in the running catalogue. Is there a way to achieve this ? Perhaps somehting that would let the non-professional enter the record as usually, but add it to the reservoir rather than to the catalogue ? Many thanks in advance for any hint, Sébstien.

1 0

Email overdue notice info not displaying
by Emrys Minnig 09 Jul '09

09 Jul '09

When our patrons receive an overdue notice, neither <<biblio.title>> nor <<biblio.author>> are showing up, though <<borrowers.firstname>> and <<borrowers.lastname>> are. For example, our message template is: Dear <<borrowers.firstname>> <<borrowers.surname>>, According to our records, you have items that are overdue. Varndean Library does not charge late fines, but please return or renew them as soon as possible. <<biblio.title>> by <<biblio.author>> Do not reply directly to this email. If you wish to email your librarians, please send an email to 'TheLibrary'. Thanks! What is actually received is: Dear Emrys Minnig, According to our records, you have items that are overdue. Varndean Library does not charge late fines, but please return or renew them as soon as possible. by Do not reply directly to this email. If you wish to email your librarians, please send an email to 'TheLibrary'. Thanks! I am using Koha 3.00.02.012 on Debian Etch, using qmail instead of the standard sendmail. Anyone have an idea why elements are able to be pulled from the 'borrowers' table but not the 'biblio' table? Emrys

2 1

Cronjob doubts solved
by Vimal Kumar 09 Jul '09

09 Jul '09

Dear Friends, At last I could found the reason of not calculating fine. To make Koha cronjobs functional, follow the steps, Open a terminal and try the commands, localhost:~# su localhost:~# cd /usr/share/koha/bin/cronjobs localhost:~# crontab -u root crontab.example localhost:~# crontab -u username crontab.example Above mentioned steps should be try after the Koha installation. Following changes in crontab are necessary, localhost:~# crontab -e change the following values there, # ENVIRONMENT: PERL5LIB=/usr/share/koha/lib KOHA_CONF=/etc/koha/koha-conf.xml # Some additional variables to save you typing KOHA_CRON_PATH = /usr/share/koha/bin/cronjobs Notes: Enable the Finemode to Production. Goto System Preferences>Circulation>Production Set the time of fine calculation in cron jobs. Default time setting in crontab is for 24 hr live servers. If your Koha server work only day time, set the day time for fine calculation. For example, if your library close at 5 pm evening, you can set the fine calculation time 16.45 pm. Format of the entry is "m h dom mon dow command" Many non techie library professionals confronted the same problem. I hope that, this solution will be helpful for them. -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

password and usrname + koha 3
by Kete Jourge 09 Jul '09

09 Jul '09

hi i want to change koha 3 password and username on my OS ubuntu i used the mysql command mysql> SET PASSWORD FOR 'kohaadmin'@'localhost' = PASSWORD('newpassword'); Query OK, 0 rows affected (0.10 sec) but when i login to koha Koha error The following fatal error has occurred: Access denied for user 'kohaadmin'@'localhost' (using password: YES) at /usr/share/koha/lib/C4/Context.pm line 666. Compilation failed in require at /usr/share/koha/lib/C4/Circulation.pm line 25. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Circulation.pm line 25. Compilation failed in require at /usr/share/koha/lib/C4/Overdues.pm line 24. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Overdues.pm line 24. Compilation failed in require at /usr/share/koha/lib/C4/Members.pm line 27. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Members.pm line 27. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 27. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 27. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 24. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 24. shall i must change the password in file in etc like koha on windows ... i asking what is this file i shall change password in it thank's

2 1