- Koha - lists.katipo.co.nz

Course Reserve information from customized report
by Peter Lau 21 Jan '19

21 Jan '19

I would like to draw a list of all items cataloged under Course Reserve including the Course Code, Course teacher (if input), Bib title, Bib author, ISBN etc. I don't know how to draw them easily from the report function. Thanks and regards, *Peter Lau* Librarian Tel: (852) 3977 9868 | Email: peter.lau(a)yccece.edu.hk <library(a)yccece.edu.hk> | Fax: (852) 23384320 2 Tin Wan Hill Road, Tin Wan, Aberdeen *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk

3 4

Search feature is not working
by nemecle＠riseup.net 20 Jan '19

20 Jan '19

Hi, We are having issues with a server we are building for a non-profit organization: to put it simply, the server works but no search result (on books or users) comes up and there is no error message (only "No result"). However, it is still possible to access a resource with the direct link or to list them all with "Home > Search the Catalog" (originally in french due to project constraints, translations will be approximated) and by doing an empty search. Moreover, the database seems to contain the entries. There is a lot of documentation online about this issue but none of the solutions worked out. An additional difficulty is that despite being a system administrator I have no prior knowledge in ILSs and the other persons on the project who work in libraries have no technical knowledge. Context: Server: OVH's VPS, Debian 9.6 Documentation used: [1] (links at the end of the mail) Koha: version 18.05 (and 17.11 tested as well) language setting: fr-FR format: unimarc ("unimarc-complet", no documentation on that specificity) Database: MariaDB 10.1.37 Search: Zebra (tried to switch to ElasticSearch, without success) Authority used: French National Library (Z39.50) Apache configuration: slightly tuned to fit technical constraints, intranet port moved to 8081 We originally tried the 18.05 but following an advice from someone working in a library with Koha we tried to test again with the 17.11, without success. Result of this answer [2]: <site>-koha@<server>:~$ export PERL5LIB=/usr/share/koha/lib <site>-koha@<server>:~$ export KOHA_CONF=/etc/koha/sites/<site>/koha-conf.xml <site>-koha@<server>:~$ /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -b -r -v Zebra configuration information ------------------------- Zebra biblio directory = /var/lib/koha/<site>/biblios Zebra authorities directory = /var/lib/koha/<site>/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/<site>/rebuild/rebuild..LCK BIBLIONUMBER in : 001$@ BIBLIOITEMNUMBER in : 090$a ------------------------- skipping authorities ------------------------- exporting biblio ------------------------- 1item-level_itypes set but no itemtype set for item (1) at /usr/share/koha/lib/Koha/Schema/Result/Item.pm line 698. Records exported: 1 ------------------------- REINDEXING zebra ------------------------- 19:20:06-09/01 zebraidx(752) [warn] Record didn't contain match fields in (bib1,Local-number) ------------------------- CLEANING ------------------------- Results: - No findings for the "1item-level_itypes" error; - No issue with the permissions on the index files created during the rebuild, command was launched with the dedicated koha user and not with root - the "zebraidx" warning seems to link to an anomaly with the biblio.biblionumber and biblioitems.biblioitemnumber, as well as the checkmarc.pl page (Home > Administration > MARC validation), but they actually seem ok (respectively 001_@ and 090_a, an answer [3] seems to indicate a false alarm). The zebra "indexer-output.log" file (and not error.log, strangely) contains exceptions that appear for each search: <site>-koha@<server>:~$ cat /var/log/koha/<site>/zebra-output.log 23:44:44-08/01 zebrasrv(1) [warn] ir_session (exception) 23:45:47-08/01 zebrasrv(2) [warn] ir_session (exception) 23:48:12-08/01 zebrasrv(3) [warn] ir_session (exception) 23:49:59-08/01 zebrasrv(4) [warn] ir_session (exception) 23:53:14-08/01 zebrasrv(5) [warn] ir_session (exception) 23:53:25-08/01 zebrasrv(6) [warn] ir_session (exception) 23:54:19-08/01 zebrasrv(7) [warn] ir_session (exception) 23:54:33-08/01 zebrasrv(8) [warn] ir_session (exception) 23:56:54-08/01 zebrasrv(9) [warn] ir_session (exception) 23:59:29-08/01 zebrasrv(10) [warn] ir_session (exception) 23:59:43-08/01 zebrasrv(11) [warn] ir_session (exception) 00:01:38-09/01 zebrasrv(12) [warn] ir_session (exception) 00:03:48-09/01 zebrasrv(13) [warn] ir_session (exception) 00:08:38-09/01 zebrasrv(14) [warn] ir_session (exception) 00:14:32-09/01 zebrasrv(15) [warn] ir_session (exception) 00:20:41-09/01 zebrasrv(16) [warn] ir_session (exception) 00:20:52-09/01 zebrasrv(17) [warn] ir_session (exception) 00:22:36-09/01 zebrasrv(18) [warn] ir_session (exception) 13:21:20-09/01 zebrasrv(19) [warn] ir_session (exception) 15:01:56-09/01 zebrasrv(20) [warn] ir_session (exception) 17:04:13-09/01 zebrasrv(21) [warn] ir_session (exception) But I have not found the origin The indexer-output.log is filled with SQL errors as well, <site>-koha@<server>:~$ cat /var/log/koha/<site>/indexer-output.log DBD::mysql::st execute failed: Table 'koha_<site>.zebraqueue' doesn't exist [for Statement "SELECT COUNT(*) FROM zebraqueue WHERE done = 0;"] at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl [1] line 326. DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() [for Statement "SELECT COUNT(*) FROM zebraqueue WHERE done = 0;"] at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl [1] line 327. But said table exists (despite being empty): root@<server>:~# mysql MariaDB [(none)]> use koha_<site>; MariaDB [koha_<site>]> SELECT COUNT(*) FROM koha_<site>.zebraqueue WHERE done = 0; +----------+ | COUNT(*) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) I tried to directly use zebra but no result (and no error): <site>-koha@<serveur>:~$ yaz-client -c /etc/koha/<site>/ccl.properties unix:/var/run/koha/<site>/bibliosocket Connecting...OK. Sent initrequest. Connection accepted by v3 target. ID : 81 Name : Zebra Information Server/GFS/YAZ Version: 4.2.30 98864b44c654645bc16b2c54f822dc2e45a93031 Options: search present delSet triggerResourceCtrl scan sort extendedServices namedResultSets Elapsed: 0.002458 Z> base biblios Z> f naissance Sent searchRequest. Received SearchResponse. Search was a success. Number of hits: 0, setno 1 SearchResult-1: term=naissance cnt=0 records returned: 0 Elapsed: 0.010326 Z> Finally, the original installation had a mismatch between the site (unimarc) and zebra (marc21), but a full reinstallation with the proper settings did not fixed the issue I am out of solutions to triy and trying strace some processes as a last stand did not helped either Do you have an idea on the source of the problem, or at least a lead? It seems to be related to Zebra and/or the indexation, but the service was installed as provided without trailing out of the tutorials Thank you in advance for your help, Freely, [1] https://wiki.koha-community.org/wiki/Koha_on_Debian [2] https://koha-community.org/faqs/zebra-indexing-wont-work-fix-it-aka-search-… [3] https://lists.katipo.co.nz/public/koha/2016-August/046107.html

2 1

Koha online library book recommendation on OPAC
by Peter Lau 20 Jan '19

20 Jan '19

When users recommending library books by using the online recommendation form available in OPAC, can the online recommendation be sent to a specific email for checking and/or with an alert of new recommendation? Thanks & regards, *Peter Lau* Librarian Tel: (852) 3977 9868 | Email: Peter.Lau(a)yccece.edu.hk | Fax: (852) 23384320 [image: https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE…] 2 Tin Wan Hill Road, Tin Wan, Aberdeen *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk

2 1

forgiven fines not showing up
by Margo Duncan 20 Jan '19

20 Jan '19

Good afternoon, When we forgive a fine with a manual credit the credit doesn't show up on the Pay fines tab. The correct amount due shows up on the Checkouts page, but when we click on Make payment the full amount without the credit shows up as due. The credit does show up on the Account tab, but that page isn't generally checked when fines are being paid. Fines and payments seem otherwise to be working as expected. We are on Koha 18.05.03. Thank you, Margo Margo Duncan, MLS Head of Library Systems Robert R. Muntz Library The University of Texas at Tyler 903.566.7174 | mduncan(a)uttyler.edu<mailto:mduncan@uttyler.edu>

2 1

UNABLE TO CHANGE DEFAULT CURRENCY TO OUR LOCAL CURRENCY
by Igbudu Tersoo 20 Jan '19

20 Jan '19

Hi, We are using koha 18.11 running on Ubuntu 16.04. We have added our Local Currency (Naira) and made it the "Active currency", but from the Acquisition preferences on koha administration our local currency does not reflect on currency format. therefore, we are unable to change the default currency to our local currency for the acquisition to work. please i need help. Thank you. Murphy Igbudu Systems Librarian University library and Information Services Benue State University, Makurdi. Benue State, Nigeria. +8038434748

2 1

Call for News: January 2018 Newsletter
by kohanews 17 Jan '19

17 Jan '19

I'm collecting news for the January newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Tools for collection management
by Chad Roseburg 15 Jan '19

15 Jan '19

Wondering if some of you out in Koha-land wouldn't mind sharing some of your favorite collection management/development tools, reports, spreadsheets, scripts, APIs, algorithms and recipes. Looking for relatively inexpensive tools ...I'm aware of the deluxe models and their price tags. I'm fine with a station wagon. :) For questions like these ( and others ): - How do I know when to purchase more in particular collection? - How do I judge demand ...for a particular collection? - How do I decide which items will perform in this branch - etc. We use a hodgepodge of scripts and Koha reports currently, but I'm hoping to shift everything into an easier to use dashboard via Jupyter or Tableau. I thought I'd survey the collective consciousness of the Koha community for diamonds of wisdom. Thank you, and enjoy your weekend! Chad -- Chad Roseburg Assoc. Director / IT Automation Dept. North Central Regional Library

3 3

Online password reset
by Peter Lau 15 Jan '19

15 Jan '19

I have checked that under HOME > TOOLS > NOTICES & SLIPS that there’s online password reset set up. However, when I changed my password, I received no notices but I have received other check-in and check-out notices. Thanks & regards, *Peter Lau* Librarian Tel: (852) 3977 9868 | Email: Peter.Lau(a)yccece.edu.hk | Fax: (852) 23384320 [image: https://docs.google.com/uc?export=download&id=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE…] 2 Tin Wan Hill Road, Tin Wan, Aberdeen *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk

2 1

Seeking recommendations for ID card printers
by Myka Kennedy Stephens 15 Jan '19

15 Jan '19

Hello, We have a dead ID card printer that needs to be replaced. I'm most interested in replacing it with a card printer that does not rely on proprietary software and could potentially work with Koha's new patron card creator feature. Do any of you currently use or have experience with card printers? What brands and models do you recommend? Thanks, Myka -- Deaconess Myka Kennedy Stephens, MDiv, MSLIS Seminary Librarian and Assistant Professor of Theological Bibliography Lancaster Theological Seminary 555 West James Street Lancaster, PA 17603 717-290-8704 mkstephens(a)lancasterseminary.edu https://library.lancasterseminary.edu

2 1

OPAC detail
by Jenny Wolf 15 Jan '19

15 Jan '19

Dear colleagues, dear community in the library of the memorial site "Haus der Wannsee-Konferenz" we have been unsing Koha (17.11) for almost a year. Our collection includes about 100.000 records. We are planning an update to the current version (18.11) in the beginning of 2019. Currently we are customizing the OPAC detail view for our users. This includes for example renaming labels in the XSLT files. Changes like these of course can cause problems. Updates may be more difficult, because the changes we make are not part of the Koha standard. Two things are be important to us in the (normal) OPAC detail view: / variable order of the labels The order of the labels should be configurable. (See attached picture or HERE<https://www.dropbox.com/s/dxnupl4keig5oet/OPAC-detail-variable-order-of-the…> ) / presentation of the labels in a table (spreadsheet) There should be two columns. The first column should display the label, the second column shows the content. (See attached picture or HERE<https://www.dropbox.com/s/rzwlqo1f99ou0hy/OPAC-detail-presentation-of-the-l…> ) We would suggest the development of these points and their inclusion in the Koha standard. We have the following questions: Is anyone interested in these developments? Who could implement that and how much would it cost? How should we proceed, should we report a bugzilla? We are looking forward to your feedback! Best regards Jenny --- Joseph Wulf Mediothek Gedenk- und Bildungsstätte Haus der Wannsee-Konferenz Am Großen Wannsee 56-58 14109 Berlin Tel.: 030 805 001 20

2 1