- Koha - lists.katipo.co.nz

Problem constructing a report
by Scott Zollars 09 Jul '09

09 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 09 Jul '09

09 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 09 Jul '09

09 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 09 Jul '09

09 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

(no subject)
by Roche III, Edward 09 Jul '09

09 Jul '09

Good afternoon all Is anyone using Ubuntu with Koha and have successfully connected to an ISCSI SAN? I would like to sit the Koha DB on the SAN to see if it will reduce some of the load on our server but so far have not been able to successfully connect to it. I install the open-iscsi app and try to run the following command: iscsiadm --mode discovery --type sendtargets --portal 1.1.1.1 But get the following result: iscsiadm: cannot make connection to 1.1.1.1:3260 (113) iscsiadm: connection to discovery address 1.1.1.1 failed If anyone has tried this and has had success please let me know. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

1 0

LDAP Attributes
by Roche III, Edward 09 Jul '09

09 Jul '09

Good Afternoon All I am playing with the idea of using LDAP for user authentication and to use this feature to populate the Koha patron db. I know the patron db will not be populated automatically only when a user logs in. So my issue/question is that I can match up the usual LDAP fields with the corresponding ones in KOha like , first name and last name. I can even find one to use for Branch but I am having trouble finding one for patron type. I do see in the instructions for ldap ( http://wiki.koha.org/doku.php?id=en:development:ldap) that there is a "categorycode" field, is this the field for patron type or is there another? If it is the field, does anyone know a field in LDAP/AD to use to hold this information? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

3 3