- Koha - lists.katipo.co.nz

Introduction to the Koha Community
by RAGHAV ARORA 14 Jun '19

14 Jun '19

Hello everyone, I am Raghav Arora, a 3rd year undergrad student from India. I am currently working on a project on Reports Management and Decision Support System for my institute library that uses Koha as it's ILS. While working on the project, I am having certain doubts on the relationships between various tables in the koha database schema, and the purpose of some of the fields. I am joining the koha-devel mailing list as well, to understand the technical details of the database. Of the many doubts that I have, I do not understand the difference between the tables reserves and old_reserves. If I need to get a list of all the holds, for which the books are currently not available in the library, which table would I refer to? Regards *Raghav Arora* 3rd year, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 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 India.

2 1

Update OS vs Update Koha
by Coehoorn, Joel 14 Jun '19

14 Jun '19

First, some background. We currently have a Koha server running 17.05. This server has been updated in place since sometime in 2012 or 2013, going back at least to version 3.04. For a variety of reasons, it's time to start over with our Koha install. To that end, I had setup a new Ubuntu 18.04 server and installed Koha 18.11 via the packages. Going forward, I hope to not fall two years behind again, but during the re-implementation phase we did not want to do and updates. Today I ran "apt upgrade" on the Ubuntu server console, and to my surprise watched the new server update koha-common to 19.05. My prior experience is this does **not** normally update the koha-common packages. Instead, I would need to change the sources or do a dist-upgrade. What did I miss here? In the future, how can I update the OS without updating the Koha application? I want to be able to install linux, apache, etc security updates during an academic term, and be able to save the koha application updates for between terms, when have down-time for review and staff training. 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

3 2

KohaCon19 Community Report
by Charles Quain 14 Jun '19

14 Jun '19

Dear Colleagues As promised, attached is a report for the community on KohaCon19 The document is at this link, https://docs.google.com/document/d/1HwLpxVekkL4bn8xdF9YjCFsUDIIIVUCn7Ri2rSa… Regards Charles <http://www.interleaf.ie/> *Charles S. Quain* Managing Director csq(a)interleaf.ie +353-1-286-5855 +353-87-978-5911 A98 YD30 www.interleaf.ie <http://www.interleaf.ie/products-services/Library-Applications/Scooter> <http://www.interleaf.ie/products-services/Library-Applications/Koha> <http://www.interleaf.ie/products-services/PC-Reservation-and-Print-Manageme…>

6 5

How to rebuild zebra in koha 18.05?
by MAURICIO RODRIGO BRITO RIVAS 14 Jun '19

14 Jun '19

Hello Friends. I tried to rebuild the zebra index in koha 18.05 with "sudo koha-rebuild-zebra -a -f -b -v sgb" but the terminal shows: error retrieving biblio 157084 at /usr/share/koha/bin/migration_tools/ rebuild_zebra.pl line 683. .DBD::mysql::db selectrow_array failed: Unknown column 'format' in 'where clause' [for Statement " SELECT metadata FROM biblio_metadata WHERE biblionumber=? AND format='marcxml' AND marcflavour=? "] at /usr/share/koha/lib/C4/Biblio.pm line 1168. Please could you help me what is happening? Many thanks in advance! Mauricio B. -- Advertencia legal: Este mensaje y, en su caso, los archivos anexos son confidenciales, especialmente en lo que respecta a los datos personales, y se dirigen exclusivamente al destinatario referenciado. Si usted no lo es y lo ha recibido por error o tiene conocimiento del mismo por cualquier motivo, le rogamos que nos lo comunique por este medio y proceda a destruirlo o borrarlo, y que en todo caso se abstenga de utilizar, reproducir, alterar, archivar o comunicar a terceros el presente mensaje y ficheros anexos, todo ello bajo pena de incurrir en responsabilidades legales. Las opiniones contenidas en este mensaje y en los archivos adjuntos, pertenecen exclusivamente a su remitente y no representan la opinión de la Universidad de Cuenca salvo que se diga expresamente y el remitente esté autorizado para ello. El emisor no garantiza la integridad, rapidez o seguridad del presente correo, ni se responsabiliza de posibles perjuicios derivados de la captura, incorporaciones de virus o cualesquiera otras manipulaciones efectuadas por terceros.

2 1

Re: [Koha] Cannot find records created in KoHa
by Michael Kuhn 14 Jun '19

14 Jun '19

Hi Patric > ==================== > exporting biblio > ==================== > 1......error retrieving biblio 7 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > ..error retrieving biblio 9 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 10 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 11 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 12 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 13 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 14 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 15 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > > Records exported: 7 > ==================== > REINDEXING zebra > ==================== > 08:48:30-07/06 zebraidx(39989) [warn] Record didn't contain match fields in (bib1,Local-number) > ==================== > CLEANING > ==================== > > ---- 8< ---- > > And yes, I have 7 records;-) Since the above output looks like there is something wrong - can you now successfully search your Zebra index? 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 Am 07.06.19 um 09:25 schrieb Lichtsteiner Patric (lici): > Hi Michael > > Thanks a lot for detailed answer and sorry for the delay. > >> It seems like you don't have an index that you could search. You should probably build one. > I reindexed our koha instance and got the following error message: > > ---- 8< ---- > # koha-rebuild-zebra -b -f -v ausleihe-test > > Zebra configuration information > ================================ > Zebra biblio directory = /var/lib/koha/ausleihe-test/biblios > Zebra authorities directory = /var/lib/koha/ausleihe-test/authorities > Koha directory = /usr/share/koha/intranet/cgi-bin > Lockfile = /var/lock/koha/ausleihe-test/rebuild/rebuild..LCK > BIBLIONUMBER in : 001$@ > BIBLIOITEMNUMBER in : 090$a > ================================ > skipping authorities > ==================== > exporting biblio > ==================== > 1......error retrieving biblio 7 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > ..error retrieving biblio 9 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 10 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 11 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 12 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 13 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 14 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > .error retrieving biblio 15 at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 681. > > Records exported: 7 > ==================== > REINDEXING zebra > ==================== > 08:48:30-07/06 zebraidx(39989) [warn] Record didn't contain match fields in (bib1,Local-number) > ==================== > CLEANING > ==================== > > ---- 8< ---- > > And yes, I have 7 records;-) > >> As you see there are two processes more than in your installation. Maybe you should just restart Zebra or if you don't know how, restart all of Koha (including Zebra), or restart your host with everything (including Koha, Zebra and the rest). > To make sure everything is clean, I restarted the whole server. > When I use the same ps command "ps -ef | grep zebra” I get just 4 processes. I have only one “zebrasrv”, you have two of them. > >> The following MARC fields are "mandatory" by default: LEADER ("000" in the Koha framework) 003 008 040$c 245$a 942$c - in the framework they are marked with a very small red asterisk. Whatever "mandatory" means: >> >> I tried to destroy a framework like you have one - exporting the standard framework, importing it as a new framework TEST, then deleting the MARC LEADER ("000"). In Koha menu "Administration > MARC Bibliographic framework test" it still says for this mutilated framework: "Configuration OK, you don't have errors in your MARC parameters table". This seems like some kind of higher nonsense to me. >> >> Interestingly enough even without the "mandatory" MARC LEADER ("000") in the framework a test record can be saved - it will then just insert some default values (as can be seen in the "MARC view"). However, as said, such a record can be saved and also be searched. See http://koha.adminkuhn.ch/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=469 (but only until about 04:00 AM tomorrow) >> >> So the mutilated framework is probably not the initial reason for your problem. Still, I wouldn't ever advise to delete the MARC LEADER in any framework. As I wrote above, I assume you don't have a (correct) Zebra index at all. > Ok, thanks a lot for this testing and for all these suggestions. > >> Hope this helps. > Definitely, thanks a lot for your time. > > Best, > Patric >

3 5

Regarding marc framework - extra subfields
by Suresh Kumar Tejomurtula 13 Jun '19

13 Jun '19

Hi, Having a query related to marc framework. Currently we are using 16.05(This is old version, but due to unavailability of internet we had to use this). For our serial control, I added few extra subfields in marc framework for 952 tag and they are added to "more_subfields_xml" coloumn in the items table. Now when I tried to import this sql database(16.05) to koha version 17.11.11, indexing is not working. After deleting the coloumn data of more_subfields_xml in the items table, indexing is working without any problem. Is this a normal behavior or any issue. Please guide me if any possibility is there to import the data into 17.11 without having to delete the data in more_subfields_xml in items table.

2 2

Koha Updates
by Muhammad Salihu Zubair 13 Jun '19

13 Jun '19

I write to request for Koha Updates on the following aspects: 1. Current Version in use 2. Core Modules 3. Features of Acquision Module 4. Features of Cataloguing Module 5. Features of Serials Control Module 6. Features of Web OPAC 7. Features of Article Indexing 8. Features of Web 2.0/3.0 9. Other enhanced features of Koha ILS I look forward to hearing from you. Thank you Dr. Muhammad S. Zubair University Library Bayero University, Kano +2348036557705

1 0

Introductory message
by Muhammad Salihu Zubair 12 Jun '19

12 Jun '19

I wish to join the Koha User Community through this mailing lists for knowledge and experience sharing as our University Library, Bayero University, Kano prepares to migrate from Virtua to Koha. Hope my request will be accepted. I look forward to hearing from you. Regards Dr. Muhammad S. Zubair University Library Bayero University, Kano PMB 3011, BUK Kano mszubair.lib(a)buk.edu.ng +2348036557705

1 0

How to koha OPAC New Arrivals Books Display (Koha CoverFlow plugin)
by MAMCET Library 11 Jun '19

11 Jun '19

https://youtu.be/rB36I8lG9uk https://youtu.be/9LJb7X0NXGo -- Thanking you.. Librarian, MAMCET <http://mamcet.com/> Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105.

2 1

Events and Program tracking
by Chad Roseburg 11 Jun '19

11 Jun '19

Hello ~ Just curious as to what other libraries in the Koha community are using for events and program tracking, reservations ...etc. Anything, in particular, you like about it? Does it integrate with your website and Koha? Thanks! -- Chad Roseburg Assoc. Director / IT Automation Dept. North Central Regional Library

3 4