- Koha - lists.katipo.co.nz

Webinar
by Ambika C.A. 08 Aug '17

08 Aug '17

Dear Sir, Since there is more demand for Koha, I think some experts should organise a webinar on it (It should cover both installation and usage methods in detail) Regards, *______________________________* Mrs. Ambika C.A. Librarian K.S. School of Engineering & Management #15, Mallasandra, Off. Kanakapura Road, BENGALURU - 560062 Ph: (080) 28425012 Extn: 200 Mob : 9036486519 <http://www.rediffmail.com/cgi-bin/red.cgi?red=http%3A%2F%2Flibrary%2Epes%2E…>

1 0

Any Helps
by Luis Moises Rojas 08 Aug '17

08 Aug '17

Hello, We are trynig to install 16.05, but after: sudo apt-get install koha-common we got the following error: missing dependencies This an O/S error, but we have done everything manuals say and nothing happen. Any help? -- *Luis Moisés Rojas P.*

2 3

Errors version 17.05
by Luis Moises Rojas 07 Aug '17

07 Aug '17

Hello everybody We made an upgrade to 17.05 now when a user try to return a book, we have the following errors: 1. The item has not been checked in due to configuration issues in your system. You must an administrator ..." 2. Must be an entry in <Template-cache-dir> in file koha-conf.xml? Which entry? Any help? Thanks -- *Luis Moisés Rojas P.*

1 0

MARC frameworks in Koha
by Marcel de Rooy 07 Aug '17

07 Aug '17

Hi developers or librarians, If you are interested in say sorting search results or lists by publication date based on 260 and RDA 264, please read further. OR If you use varying kohafield mappings across your MARC frameworks. Say you connected biblio.copyrightdate to 260$c in framework A, but to 264$c in framework B. Bug 10306 (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10306) is aimed to resolve the issue of having the copyrightdate in two MARC fields. It allows you to have multiple mappings per kohafield. So you can connect 260c and 264c to copyrightdate. Current Koha allowed you to add the second mapping already in the frameworks, but it silently ignores one of the two. In finishing this development however, I got stuck at the following question: Should Koha really allow varying kohafield mappings per framework? In the above example the multiple mappings feature should resolve the need of having a different assignment for copyrightdate between framework A and B. Both could simply have two mappings for copyrightdate. Although Koha more or less allows you to add kohafield assignments per framework via the MARC frameworks, it does not really support kohafields per framework. (The Koha to MARC mappings tool in Administration does change the mappings in Default and copies them to other frameworks.) We have GetMarcFromKohaField calls in the codebase that do not pass a framework code. And when we process search results or import records, we do not have a framework code either. So in those cases Koha just uses the kohafield mappings from the Default framework, although you might have specified another mapping in the associated framework of a search result. I would propose now to make the decision that we only use one set of kohafield mappings (those from Default), and that we do no longer allow changes to kohafield mappings in the other frameworks. The possibility of adding multiple mappings per kohafield hopefully removes most objections to that approach as illustrated in the frameworks A and B example. I submitted my changes so far on the Bugzilla report. If we agree on Default as the authoritative framework for these mappings, I will still add code to change GetMarcFromKohaField calls etc. If you have stringent reasons for maintaining varying kohafield mappings per framework and your need for them cannot be resolved with multiple mappings, please respond and provide information about the fields you are mapping differently across your frameworks. Any other feedback is welcome too. Thanks, Marcel

1 0

Please Help Me
by Rajesh Shelar 07 Aug '17

07 Aug '17

Dear All Friends, i request Please anybody facing the NAAC-2016-17 ,so i request please send me the NAAC submit ion Report & Point. -- ***Thanks & Regards* *Mr. Rajesh R.Shelar* *Sadhu Vaswani Institute Of Management Studies For Girl's ( MBA )* *Koregaon Road,Pune* *Mob.No.8380941380* *Save Water......Conserve Life.............*

1 0

Retirement Village Library
by Eleanor Bensemann 04 Aug '17

04 Aug '17

Hi everyone. I have been a librarian most of my life, and am still working in a casual on-call capacity. I have recently taken over the management of this small library and am running it with a team of helpers. There is a catalogue system of sorts on Excel sheets but it is far from user friendly. I am wondering if Koha would be a good option. This would just be a catalogue; the borrowing is strictly based on honesty with people writing their issues on a card, and crossing off when they return. Any advice appreciated. Thanks, Eleanor

4 3

Slow OPAC search
by Manoj Kummini 04 Aug '17

04 Aug '17

Hello everyone, I am new on this list, and have just begun, with a colleague, managing the KOHA installation in our library that has about 10000 books and some journals. Our OPAC had become terribly slow and on exploring we noticed that a mysqldump would result in a file of over 5GB. This large size, we realized, was due to the cleanup_database.pl script not being called. After running it for about a week with --sessdays 7 --zebraqueue --list-invites --mail --merged --import --logs --searchhistory --restrictions we have brought the mysqldump file to about 20-22 MB. While the speed of an OPAC search has improved considerably, it is still slow. For example, as suggested by a reply to a similar question, I looked at "Inspect Element > Network" and found that most queries of GET opac-detail.pl and opac-search.pl take about 9-10 seconds. Koha Version: 3.2202000 (<meta name="generator" content="Koha 3.2202000" />) running on a virtual machine (Debian 8.3). The base machine is Debian 9.0. MySQL server 5.5.47-0+deb8u1 is on the VM itself. Uses zebra. On the virtual machine # free -m gives total used free shared buffers cached Mem: 16023 2042 13981 341 174 1290 -/+ buffers/cache: 576 15446 Swap: 16383 0 16383 We plan to upgrade to Koha 17.05 soon, but wanted to understand how to speed up the search. Is moving to a stand-alone server the only solution? I am new to this, so I might not have given you all the relevant information about the problem. Please let me know if some other piece of information will help. Thank you. With regards, Manoj. -- Manoj Kummini Associate Professor, Mathematics, Chennai Mathematical Institute, Siruseri Tamilnadu 603103. India. 12 deg 50 min N, 80 deg 13 min E. http://www.cmi.ac.in/~mkummini/index.html

2 3

Report error (SQL )
by Luis Moises Rojas 03 Aug '17

03 Aug '17

Hello everybody. We have an sql senteces to extract SUBTITLE (ExtractValue(biblioitems.marcxml, '//datafield[@tag="245"]/subfield[@code="b"]') AS "Subtitulo) but now it say this field is obsolete. Where is the subttile? Thanks -- *Luis Moisés Rojas P.* <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

3 3

Having sevaral errors
by Luis Moises Rojas 03 Aug '17

03 Aug '17

Hello everybody, We are having many error: 1. When in catalogin when you search a title and click the TITLE to edit, it say: Export bib-23322.dublin...xml and Says: MARK VIEW and nothing happen 2. In report , option USE SAVE REPORT (utilizar salvados), say: UPDATING SQL. Why? 3. When try to edit a patron, we got this error (even if the patron is new o to edit) Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'koha_library.me.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /usr/share/koha/lib/Koha/Objects.pm line 120 Any help? Thanks -- *Luis Moisés Rojas P.* <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

1 0

How to remove unwanted characters when importing MARC data?
by Michael Kuhn 03 Aug '17

03 Aug '17

Hi Our library receives MARC data from EKZ (a German cataloging data provider) which includes two unwanted characters: * a beginning "non-sorting character" * an ending "non-sorting character" These characters can't be seen in the OPAC and in the hitlist of the staff client, but they do appear in the framework and also in the top line of the webbrowser. Here is an example of a file containing such characters: http://adminkuhn.ch/download/kuhn0000000 When opening the original .mrc file with vi these characters show as: <98>The<9c> obsession With "od -c" they show as: 302 230 T h e 302 234 o b s e s s i o n Of course these characters could be removed e. g. with sed (but this will result in a wrong character length in MARC LEADER positions 0-4) and also it has to be done separately on the shell outside and before the regular importing process. Or even using software like MarcEdit. Now the question is if there is an EASY way how to delete these unwanted characters within Koha, for example by using the MARC modification templates which is used anyway when loading such data? 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

5 10