- Koha - lists.katipo.co.nz

There is no notice template with code ACQORDER defined
by Michael Kuhn 30 Jun '19

30 Jun '19

Hi Using Koha 18.11.01 on Debian GNU/Linux 9 we get the following error message, when clicking "E-mail order" in Koha menu "Acquisitions" in the basket of a vendor: There is no notice template with code ACQORDER defined. But actually the template "ACQORDER" is defined in Koha menu "Tools > Notices & slips" (it is a standard template anyway). It can also be found in table "letter". Does anyone know what is the problem here, or is this maybe a bug? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 2

Koha Community Newsletter: June 2019
by kohanews 28 Jun '19

28 Jun '19

The Koha Community Newsletter for June 2019 is here: https://koha-community.org/koha-community-newsletter-june-2019/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. -- Chad Roseburg Editor, Koha Community Newsletter

1 0

[KOHA] BATCH ITEM MODIFICATION BARCODES NOT FOUND
by muirunyeri 28 Jun '19

28 Jun '19

Dear colleagues, I updated the barcodes field directly from the koha_library items table in mysql successfully. From the browser, searching the barcodes from the catalogue is successful but the batch item modification gives the barcodes not found result. Barcodes edited through the browser are however found using the batch modification. How do I resolve this? This is the query I used: CREATE TEMPORARY TABLE temp_koha_imports(call_number VARCHAR(40) NOT NULL, barcode VARCHAR(40) NOT NULL UNIQUE, new_barcode VARCHAR(40) NOT NULL PRIMARY KEY; LOAD DATA LOCAL INFILE '/tmp/koha_update_weeded.csv' INTO TABLE temp_koha_imports FIELDS TERMINATED BY ','; UPDATE items i INNER JOIN temp_koha_imports t ON t.barcode=i.barcode SET i.barcode=new_barcode; Someone please help

1 0

Decision Support System for library.
by RAGHAV ARORA 28 Jun '19

28 Jun '19

Hello everyone, Does anyone know of good Decision-support software that can be used for decision making for library acquisitions based on Koha database? Or any framework/model I can refer to in the direction would be really helpful. Thanks in advance. Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761, 8474975691 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

1 0

Education: Koha education meeting highlights and recording
by Caroline Cyr-La-Rose 27 Jun '19

27 Jun '19

Hello everyone! The first community education meeting took place earlier today. There were a dozen in attendance and we had a great chat. For those who couldn't make it, and for the curious, here is the recording https://drive.google.com/file/d/147jzhaEZJdsNsFFxXzb8SUvGj1T5ulRP/view there is also the transcript of the chat https://drive.google.com/open?id=1xb8TjtrDaIdZPrVUekueqzRYz4StLip8 Thanks again to ByWater Solutions who hosted the meeting. Here are some highlights from the meeting: * We created a wiki page to share our training material https://wiki.koha-community.org/wiki/Training_resources o Feel free to add to this wiki page, I already started with some resources that were shared during the meeting o If you add something, make sure to write the version of Koha it applies to. This is just to keep it the most up-to-date possible. * We also created a wiki page for how-to's or "step by step"'s https://wiki.koha-community.org/wiki/How-to o These will live along side the manual for people who need more structured instructions on how to do things in Koha o It's easier to edit than the manual, so more people can contribute o There is still the need to find a way to translate these if they are to be included in the manual eventually * We decided against creating a new mailing list for education and training as most of us are already swamped in emails and subscribed to too many listservs o We will use the regular Koha mailing list o However, it was suggested that we add "Education: " before the subject of the email. That way those of us who are interested in this topic will know to read those emails, and those of us who aren't interested in education/training can disregard the email or even create a rule in their email client to delete them automatically * Eventually, there will be example MARC records for all types of materials to help us with non-librarian library staff who do cataloging. * We also shared some best practices o We all loved koha-US' learning page, which organizes the community information in a more visual manner https://koha-us.org/learn-from-koha-us/ o ByWater do a "policy call" before the training to understand the library's setting and needs. This also helps with configuration. They have a survey that they use with that call to collect hard data from their clients for the configuration of Koha o Most support companies do the training on a test environment with the library's own data. This is kept until go-live so staff can practice. Some keep the test environment after go-live for tests, practice and training new staff. o ByWater tries to cater to all learning styles by giving the same information in different ways (videos, step-by-steps, in person training, etc.) I think that covers everything. For those who were there, don't hesitate to respond if you think I forgot anything. Next meeting will take place on November 19 at 19 UTC. It will still be hosted by ByWater and this is the link to access it https://zoom.us/j/392843340 Thank you everyone! Caroline -- Caroline Cyr La Rose, M.L.I.S. Librarian | Product Manager Phone: 1-833-465-4276, ext. 221 Caroline.Cyr-La-Rose(a)inLibro.com <mailto:caroline.cyr-la-rose@inLibro.com> INLiBRO | Document Technologies Specialists | www.inLibro.com <http://www.inLibro.com>

1 0

Koha tutorials
by MAMCET Library 27 Jun '19

27 Jun '19

Dear sir / Madam Hope you enjoy the koha tutorials video. Subscribe this channel to receive more similar content. You will learn for software knowledge and implement in your library. https://www.youtube.com/channel/UC3wql6wxktbjRCdPMo9SXoA?sub_confirmation=1 1.How to Add a Patron category and create a Super Librarian : https://youtu.be/y59GQavOpLc 2.How to Create New Library in Koha Simple Method: https://youtu.be/c04zIKLWJLk 3.How to Create koha SQL Report and 15 Library Important Customize Reports: https://youtu.be/scuXS7wVFdM 4.How to Add an Item types in koha Library: https://youtu.be/OmVYVZfq5p0 5.How to Setting Circulation and Fine Rules in Koha: https://youtu.be/GClcoI7L5EY 6.How to Create and Edit MARC Framework in koha and Download Customized MARC Frame: https://youtu.be/zEy7_o7F4hM 7.How to Koha Patrons Unwanted Field Delete in staff client and Koha OPAC client: https://youtu.be/J5iP6GhkorY 8.How to Bulk Patrons photos Upload in koha: https://youtu.be/PhhwnO7aLpo 9.How to Bulk Patron Details Upload in Koha: https://youtu.be/NJvCrM677XY 10.How to Koha Login Page Designing and Change Logo: https://youtu.be/Fqk901kjd6Y 11.How to add Koha Item Type Image: https://youtu.be/tIPUiD9UY-k 12.How to Koha Auto Backup in Dropbox: https://youtu.be/5Q0ZFofBfg8 13.How to Enable Koha Plugins: https://youtu.be/9LJb7X0NXGo 14.How to Configure of AskALibrarian Plugin in Koha (Chatting with Librarian): https://youtu.be/8d2cAOz0Q5Y 15.How to koha OPAC New Arrivals Books Display (Koha CoverFlow plugin): https://youtu.be/rB36I8lG9uk 16.How to Enable Barcode or Accession Number Search in OPAC: https://youtu.be/HD8wHCgby8Y 17.How to Enable Intranet Catalog Search Pulldown menu in Koha Staff Client: https://youtu.be/Ht8YKvBvt5Q 18.How to Create Collection or Department wise Books in koha and Generate Collections wise Report: https://youtu.be/07B4oNmRtQQ 19. Bulk Import Quotes and Beautify Quotes of the day in Koha OPAC: https://youtu.be/ksdqcgrXJzs 20. Adding a Link to the Last Patron Accessed in the koha Staff Client: https://youtu.be/Fu0KipAbyr4 21. How to install Koha In Out Management System: https://youtu.be/Jge3ps7T4Sw -- Thanking you.. Koha Power Tech <https://www.youtube.com/channel/UC3wql6wxktbjRCdPMo9SXoA?sub_confirmation=1>

1 0

Circulation rule by location
by Coehoorn, Joel 27 Jun '19

27 Jun '19

Is it possible to have a circulation rule that targets location? In the past, we've had a diarrhea of item types to encode both a location and the kind of item, and this really isn't ideal. We'd like to revise our circulation rules to target locations, and therefore simplify our item types. Joel Coehoorn Director of Information Technology 402.363.5603 *jcoehoorn(a)york.edu <jcoehoorn(a)york.edu>* *Please contact helpdesk(a)york.edu <helpdesk(a)york.edu> for technical assistance.* 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

5 5

Koha Ldap Auth
by Daniele Piccoli 26 Jun '19

26 Jun '19

Hi guys, I've an instance of Koha in lab test and I'm trying to enable ldap auth towards our active directory server (samba4 instance), but I'm experiencing some issues. Koha is correctly installed on an Ubuntu 16.04.6 LTS, fully updated. I read and followed this page [0], step by step, without any problems. Now, I've followed this step: 1. Open /etc/koha/sites/*biblioname*/koha-conf.xml 2. Enable LDAP: <useldapserver>1</useldapserver> 3. Insert settings as follow: <ldapserver id="ldapserver" listenref="ldapserver"> <hostname>ldaps://*IP-OF-DC*</hostname> <base>ou=Users,dc=*sub*,dc=*domain*,dc=*tld*</base> <user>cn=*user*,dc=*sub*,dc=*domain*,dc=*tld*</user> <pass>*password*</pass> <replicate>1</replicate> <update>1</update> <auth_by_bind>1</auth_by_bind> <principal_name>uid=%s,ou=*User*,dc=*sub*,dc=*domain*,dc=*tld*</principal_name> <mapping>record field names --> <userid is="uid"></userid> <password is="userpassword"></password> <email is="mail"></email> </mapping> </ldapserver> 4. Reload apache service After that, when I try to open the OPAC interface as well as staff interface, the follow errors appears: OPAC URL: Software error: Error reading file /etc/koha/sites/biblioname/koha-conf.xml. Try running this again as the koha instance user (or use the koha-shell command in debian) Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 30. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 30. Compilation failed in require at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 23. BEGIN failed--compilation aborted at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 23. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. STAFF URL: Software error: Error reading file /etc/koha/sites/biblioname/koha-conf.xml. Try running this again as the koha instance user (or use the koha-shell command in debian) Compilation failed in require at /usr/share/koha/lib/C4/Output.pm line 34. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Output.pm line 34. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 24. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 24. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. On the server side, the logs say: [Mon Jun 24 10:55:57.310730 2019] [cgi:error] [pid 7006] [client 192.168.199.28:54800] AH01215: [Mon Jun 24 10:55:57 2019] mainpage.pl: Compilation failed in require at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 24.: /usr/share/koha/intranet/cgi-bin/mainpage.pl [Mon Jun 24 10:55:57.310901 2019] [cgi:error] [pid 7006] [client 192.168.199.28:54800] AH01215: [Mon Jun 24 10:55:57 2019] mainpage.pl: BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/mainpage.pl line 24.: /usr/share/koha/intranet/cgi-bin/mainpage.pl [Mon Jun 24 10:55:57.826379 2019] [cgi:error] [pid 7009] [client 192.168.199.28:54802] AH01215: [Mon Jun 24 10:55:57 2019] 404.pl: : /usr/share/koha/intranet/cgi-bin/errors/404.pl, referer: http://URL-OPAC/ [Mon Jun 24 10:55:57.826605 2019] [cgi:error] [pid 7009] [client 192.168.199.28:54802] AH01215: [Mon Jun 24 10:55:57 2019] 404.pl: Error reading file /etc/koha/sites/biblioname/koha-conf.xml.: /usr/share/koha/intranet/cgi-bin/errors/404.pl, referer: http://URL-OPAC/ [Mon Jun 24 10:55:57.826778 2019] [cgi:error] [pid 7009] [client 192.168.199.28:54802] AH01215: [Mon Jun 24 10:55:57 2019] 404.pl: Try running this again as the koha instance user (or use the koha-shell command in debian): /usr/share/koha/intranet/cgi-bin/errors/404.pl, referer: http://URL-OPAC/ [Mon Jun 24 10:55:57.826827 2019] [cgi:error] [pid 7009] [client 192.168.199.28:54802] AH01215: [Mon Jun 24 10:55:57 2019] 404.pl: : /usr/share/koha/intranet/cgi-bin/errors/404.pl, referer: http://URL-OPAC/ [Mon Jun 24 10:55:57.826956 2019] [cgi:error] [pid 7009] [client 192.168.199.28:54802] AH01215: [Mon Jun 24 10:55:57 2019] 404.pl: Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 30.: /usr/share/koha/intranet/cgi-bin/errors/404.pl, referer: http://URL-OPAC/ [Mon Jun 24 10:55:57.827094 2019] [cgi:error] [pid 7009] [client 192.168.199.28:54802] AH01215: [Mon Jun 24 10:55:57 2019] 404.pl: BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 30.: /usr/share/koha/intranet/cgi-bin/errors/404.pl, referer: http://URL-OPAC/ [Mon Jun 24 10:55:57.827243 2019] [cgi:error] [pid 7009] [client 192.168.199.28:54802] AH01215: [Mon Jun 24 10:55:57 2019] 404.pl: Compilation failed in require at /usr/share/koha/intranet/cgi-bin/errors/404.pl line 21.: /usr/share/koha/intranet/cgi-bin/errors/404.pl, referer: http://URL-OPAC/ [Mon Jun 24 10:55:57.827397 2019] [cgi:error] [pid 7009] [client 192.168.199.28:54802] AH01215: [Mon Jun 24 10:55:57 2019] 404.pl: BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/errors/404.pl line 21.: /usr/share/koha/intranet/cgi-bin/errors/404.pl, referer: http://URL-OPAC/ Any hints? Thanks, Daniele [0] https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages

4 8

Unwanted e-mail about UseTransportCostMatrix
by Michael Kuhn 26 Jun '19

26 Jun '19

Hi Since two days I am receiving the following unwanted e-mail from my demo installation (running Koha 19.05.00) every hour: ################################## Subject: Cron <root@vmi47659> cd / && run-parts --report /etc/cron.hourly /etc/cron.hourly/koha-common: UseTransportCostMatrix set to yes, but matrix not populated at /usr/share/koha/lib/C4/HoldsQueue.pm line 193. ################################## But in fact system preference "UseTransportCostMatrix" is NOT set to yes: mysql> select value from systempreferences where variable="UseTransportCostMatrix"; +-------+ | value | +-------+ | 0 | +-------+ 1 row in set (0.00 sec) What does it mean and how can I prevent getting this unwanted e-mail? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik(a)adminkuhn.ch · W www.adminkuhn.ch

2 2

SQL Query to get the Waiting Holds From reserves table.
by RAGHAV ARORA 26 Jun '19

26 Jun '19

Hello all, Could someone please help me in creating the SQL query to get all the holds in the library for which the book is available,in the library (i.e, no issue exists for that book) The reserves table contains some rows for which itemnumber is Null, and the waitingdate is Null for every row even if no issue exists for the item. I came up with the following sql query, but I am not sure if I am right, can someone please verify my query, or rectify it with the correct query: ```SELECT borrowers.surname, borrowers.email, borrowers.cardnumber, items.barcode, biblio.title, reserves.reservedate FROM reserves LEFT JOIN borrowers USING (borrowernumber) LEFT JOIN items USING (itemnumber) LEFT JOIN biblio ON (reserves.biblionumber = biblio.biblionumber) WHERE (reserves.itemnumber IS NOT NULL AND NOT EXISTS(SELECT issue_id FROM issues WHERE items.itemnumber = issues.itemnumber) ) OR (reserves.itemnumber IS NULL AND EXISTS( SELECT itemnumber FROM items i2 WHERE items.biblionumber=reserves.biblionumber AND NOT EXISTS( SELECT issue_id FROM issues WHERE issues.itemnumber=i2.itemnumber ) ) ) ``` Thanks in advance Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora999(a)yahoo.in> | University Email <f20171016(a)pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031

1 0