- Koha - lists.katipo.co.nz

OPAC research does not work
by Davide Spanu 22 Feb '19

22 Feb '19

Hello, I'm having problems configuring Koha. I've uselessly tried solving the issue on my own and also browsing forums. After the install I started cataloging, inserting titles and texts. However once inserted for some reason they don't appear in the OPAC. I can't figure out what I'm doing wrong and need assistance. Thank you in advance

2 1

Report for items held by 2 out of 3 branches
by Cab Vinton 22 Feb '19

22 Feb '19

Hi, All -- We have a report (see below) that generates a random list of items held by all 3 of our branches & purchased within the past 30 days. To generate more titles we'd like to loosen the criteria by specifying that the titles should be held by just 2 of the 3 branches. I know how I'd approach this outside of Koha's SQL-based reporting tool, but not sure how to write this without repeating a whole bunch of code ((A or B) or (A or C) or (B or C)). The code is used to populate a carousel on our OPAC's home page & it's already a bit "pokey", so efficient code is an important factor. Anyone have suggestions on how best to write this report? Many thanks in advance, Cab Vinton, Director Plaistow Public Library Plaistow, NH https://catalog.southernnh.bywatersolutions.com SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title, i.homebranch, i.itemcallnumber FROM items i LEFT JOIN biblioitems m USING (biblioitemnumber) LEFT JOIN biblio b ON i.biblionumber = b.biblionumber WHERE i.itype = 'NEWBOOK' AND b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='KIMBALL') AND b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='PLAISTOW') AND b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='SANDOWN') GROUP BY b.biblionumber HAVING isbn != "" ORDER BY rand() LIMIT 7

2 4

Koha 18.05.09 released
by Jesse Maseto 22 Feb '19

22 Feb '19

The Koha community is proud to announce the release of 18.05.09. This is a maintenance release and contains many bugfixes and enhancements. It includes 3 enhancements, 62 bugfixes. As always you can download the release from here: http://download.koha-community.org/koha-18.05.09.tar.gz Thank you very much to everyone involved in this release. Best regards, -Jesse and Lucas -------------------- Jesse Maseto Dev/Ops Support ByWater Solutions Support & Consulting for OSS Office - Stratford,CT T/F 888.900.8944 http://bywatersolutions.com Jesse(a)bywatersolutions.com

4 3

Koha 18.11.03 release
by Renvoize, Martin 22 Feb '19

22 Feb '19

The Koha community is proud to announce the release of Koha 18.11.03. This is a maintenance release. The full release notes are available at https://koha-community.org/koha-18-11-03-release/ Debian packages will be uploaded in a few days. Best regards and thanks to all those who have contributed to this release. *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize(a)ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info(a)ptfs-europe.com

1 0

z39.50 search does not return results
by Hauke Altmann 22 Feb '19

22 Feb '19

Hey there, I have another issue after moving Koha to a new server: The Z39.50/SRU search is no longer returning results (/cgi-bin/koha/cataloguing/z3950_search.pl). Settings are the same as on the old system, where everything works fine. There are no indications of errors in the logs. Can anyone give me an idea, where to look for a solution of the problem? Is there an option to make Koha more talkative to get an idea what causes this problem? Thanks for any help, Hauke

2 1

ITEM STATUS in KOHA
by Shafendi 22 Feb '19

22 Feb '19

hi everyone. can anyone tell me where in database koha store data on ITEM STATUS like Availability: Items available for loan, circulated etc? im using koha version 18.11 on debian 9. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

2 1

join/merge some tag 952 to only one
by anabela semedo 22 Feb '19

22 Feb '19

Hello people I have multiple fields in my 952 file and would like to put them together so I can track the number of copies before importing them into the database. for example I have: 952$a 952$b 952$y 952$9 and I wish it were like this: 952$a$b$y$9 but it's the only thing I can not do in the editmarc Has anyone been through this yet and solved it? Ana Bela

2 1

Offline Circulation | Issue with Borrowers.db File
by अभिषेक नागर Abhishek Nãgar 22 Feb '19

22 Feb '19

Hi, Koha Version : 18.11.02.000 Desktop Application : v1.3.2 I was able to generate the borrowers.db file using the cronjob script available, after specifying the path in Desktop Application and entering/scanning card number the search is not working a "," is seen in the address filed no name and other info is see, When i open the File in Notepad to check if data is present i can see Name, DOB etc fields kindly help on how will the info be visible on the Offline Desktop Application _________________________________________ Abhishek Nagar

1 0

Need a little help with an SQL query
by Chris Brown 21 Feb '19

21 Feb '19

Gentle Reader, We want to get a list of all patrons for who we do *not *have email addresses but who are "active" (for example, have checked a book out in the last 6 months) I know how to get a list of patrons with no email address but my knowledge of SQL and the database schema aren't good enough to write the "AND have checked a book out in the last 6 months" part of the query. Is there a kind soul out there who could help? We are using Koha 17.11 Thanks and Best Regards, Chris Brown

3 8

Koha 18.05 Patron search broken for non-superlibrarian users
by Mai 21 Feb '19

21 Feb '19

Dear all, We're experiencing problems with patron search on Koha 18.05 When a non-superlibrarian staff member looks up a patron, the following error occurs: > Can't call method "branchcode" on an undefined value at > /usr/share/koha/intranet/cgi-bin/members/member.pl line 56, <DATA> line > 751. If the superlibrarian looks up the same user, It'll retrieve it correctly. Additionaly, If the non-superlibrarian staff member looks up the same patron from either the Circulation module or the "Check out" tab at Koha's Home, it's information is also retrieved correctly. Switching the non-superlibrarian staff member to superlibrarian fixes the issue but for obvious reasons, it's not ideal. This happens regardless of the patron we look up. Thanks in advance, -- Maite Arakaki

2 1