- Koha - lists.katipo.co.nz

Help with shelf browser and classification source
by Inês M. Ferreira 18 Jan '21

18 Jan '21

Good morning, (I tried to send this email before, but I think something went wrong. If it did send, apologies for the duplicate.) I am responsible for a small private library and we have recently installed Koha (20.05.04.000, using UNIMARC and UDC). I am having some issues with the shelf browser and the classification source. The shelf browser does not appear. When clicking on the link, only a link to "close the shelf browser" does. I have just finished assigning shelving locations (995$e) to all items (due to previously having periodicals show alongside books), and for this purpose I have created 3 locations: geral (general), referência (reference), periódicos (periodicals). Before assigning the locations, the shelf browser would sometimes appear; now it never does (only the link to close it, as mentioned above). What could be the problem? I’m not sure if this is relevant and could be impacting the shelf browser, but our search doesn’t work -- it always shows no results (our IT team is working on it). A second issue (that might be related) is that although I am trying to work with UDC, I think Koha is still defaulting to Dewey. I have only found out about the setting DefaultClassificationSource a few days ago, and it is set as Dewey (I didn’t change it because I would rather change everything, including all 1000+ items, at once). On the administration menu > classification sources, I only have UDC as ‘in use’. What do I need to do to make sure all of Koha is using UDC? I am very new to Koha, so any help is appreciated! Thank you. Kindest regards, Inês F.

2 5

Migrating Koha Servers
by Charles Kelley 18 Jan '21

18 Jan '21

My library is migrating its Koha database to a new server. I have found instructions on both YouTube and static sources. But the instructions are not perfectly clear to me and I have a few questions. (1) How do you find out the password to MySQL? (2) Does it matter whether you are running MySQL or MariaDB? (3) Is "koha_library" a fixed phrase? Or is it the name of the Koha instance you are migrating, e.g., if your library is named ASDLIB, do you use "koha_library" or "ASDLIB"? (4) If you are running ElasticSearch, are there complications and if so, what are they and their solutions? (5) How does Zebra factor into all this? I'm trying to avoid * reentering frameworks; * downloading MRC files of the authority records and bibliographic records and uploading them into the new server because of suspected linkage problems between the authority records and $9 subfields in the bibliographic records; * reentering system preferences; * reentering patron information; and so forth. Thank you very much. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

3 2

koha-rebuild-zebra error
by Aswin Unnikrishnan 18 Jan '21

18 Jan '21

Hi Everyone, I am new to koha and this community , so not sure if i am sending the mail to the right group. So i've been trying to run koha on a container for some time now, and ive managed to configure everything. Now im trying to import some data that i already have into the koha database, but searching in OPAC doesnt return any results even after i load everything into the database . So i figured i might need to run koha-rebuild-zebra command, but im facing an error . This is the output of koha-rebuild-zebra: Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/${KOHA_INSTANCE}/biblios Zebra authorities directory = /var/lib/koha/${KOHA_INSTANCE}/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/zebra_koha_${KOHA_INSTANCE}/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== 58801.............................................................................................. Records exported: 58895 ==================== REINDEXING zebra ==================== 16:49:58-16/01 zebraidx(5530) [warn] sort-string-utf.chr [No such file or directory] 16:49:58-16/01 zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr 16:49:58-16/01 zebraidx(5530) [warn] sort-string-utf.chr [No such file or directory] 16:49:58-16/01 zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr 16:49:58-16/01 zebraidx(5530) [warn] sort-string-utf.chr [No such file or directory] 16:49:58-16/01 zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr 16:49:58-16/01 zebraidx(5530) [warn] sort-string-utf.chr [No such file or directory] 16:49:58-16/01 zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr 16:49:58-16/01 zebraidx(5530) [warn] sort-string-utf.chr [No such file or directory] 16:49:58-16/01 zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr 16:49:58-16/01 zebraidx(5530) [warn] sort-string-utf.chr [No such file or directory] 16:49:58-16/01 zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr 16:49:58-16/01 zebraidx(5530) [warn] sort-string-utf.chr [No such file or directory] 16:49:58-16/01 zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr 16:49:58-16/01 zebraidx(5530) [warn] sort-string-utf.chr [No such file or directory] 16:49:58-16/01 zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr 16:49:58-16/01 zebraidx(5530) [warn] sort-string-utf.chr [No such file or directory] 16:49:58-16/01 zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr 16:49:58-16/01 zebraidx(5530) [warn] sort-string-utf.chr [No such file or directory] 16:49:58-16/01 zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr I have hidden my koha instance name here This error zebraidx(5530) [warn] Failed to read character table sort-string-utf.chr keeps repeating indefinitely, until i terminate it with Ctr+C . I have checked the user permissions for all files in /var/lib/koha/ and /etc/koha/zebradb and made the owner to ${KOHA_INSTANCE}-koha . I cant seem to find the reason behind this error. I have also checked /etc/koha/zebradb/lang_defs/en and i can see the file sort-string-utf.chr My koha version is 20.11 If someone knows the reason for this error, please do help. If you require any more info regarding my installation or configuration I can provide that. Thanks

2 5

Re: [Koha] Importing Item Types from Excel Spreadsheet
by Charles Kelley 18 Jan '21

18 Jan '21

Hi, all! It's been awhile since I initially wrote on this topic, so please forgive me for this late response. In my original question, I asked whether it was possible to import the item types (DVD for 'DVD', PDF for 'Portable Document Format', BK for 'Book', etc.) because my library is porting to a new computer (and I'm trying to avoid reentering the list). In an exchange on Fri, 15 Jan 2021 at 10:11, Vikram Zadgaonkar < vikramczadgaonkar(a)gmail.com> wrote: You need to convert the file into .mrk. > You may try marcedit tool for conversion. > Sorry, but converting to .MRK or .MRC is not possible. In an exchange on Sat, 16 Jan 2021 at 13:22, Katrin Fischer < katrin.fischer.83(a)web.de> wrote: The export is provided by the tools we use for presenting data in tables. > Import is a different matter. For some data there are existing tool, but > itemtypes can only be imported using SQL at the moment. > Too bad. In an exchange on Sat, 16 Jan 2021 at 13:36, Michael Kuhn < mik(a)adminkuhn.ch> wrote: Maybe the content of file "sample_itemtypes.sql" (which imports some sample > item types during the initial configuration of Koha) will be of some help > to you when creating your own SQL file: > > INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, > imageurl, summary) VALUES > [etc., etc., etc.] Unfortunately, my SQL skills are weak -- it's been several years since I last had to make SQL statements, and I would probably err badly and spend a lot of time undoing my damage. I ended up reentering the item types after all. It took only an hour or so. Thanks for your help, all. It was a gallant effort. -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

1 0

Time to translate: string freeze to prepare Koha 19.11.14 has begun
by Victor Grousset/tuxayo 17 Jan '21

17 Jan '21

Hi, saluton, hola, bonjour, String freeze is into effect as of now for the 19.11.x maintenance branch. The release is scheduled for the 22th. This means it's the right time to head over to the translation platform: https://translate.koha-community.org/projects/ Reminder: if you add or change a translation in version 19.11, then you must also copy it to 20.05 and 20.11. Otherwise your work will be lost for future versions. Happy translating, -- Victor Grousset/tuxayo

1 0

Importing Item Types from Excel Spreadsheet
by Charles Kelley 16 Jan '21

16 Jan '21

Hi, all! I see there is a means to export the item types (BKS for books, PER for periodicals, etc.) into various formats, e.g., CVS and Excel spreadsheet. Is there a way to import them? I can't find documentation, and my library is migrating to a new machine. I have looked at the Tools but I see authority records and bibliographic records but not other types of data. Many thanks! -- 気を付けて。 /ki wo tukete/ = Take care. -- Charles. Charles Kelley, MLS PSC 704 Box 1029 APO AP 96338 Charles Kelley Tsukimino 1-Chome 5-2 Tsukimino Gaadenia #210 Yamato-shi, Kanagawa-ken 〒242-0002 JAPAN +1-301-741-7122 [US cell] +81-80-4356-2178 [JPN cell] mnogojazyk(a)aol.com [h] cmkelleymls(a)gmail.com [p] linkedin.com/in/cmkelleymls <http://www.linkedin.com/in/cmkelleymls> Meeting Your Information Needs. Virtually.

4 3

Re: [Koha] Local Use Only item type in Koha
by Michael Adamyk 16 Jan '21

16 Jan '21

Hi Katrin, thanks for your reply. We do currently have several item types set up sort of like that: they have specific circ rules that should prevent holds from any library, or from any library other than the home library. https://pasteboard.co/JJaZzPd7.png The downside is that anyone with permission to override any kind of hold restrictions can override these circ rules. Now that I'm writing it, I'm almost positive there is no way to do this, but... it would be handy if there were a way to place hard limits on holds for some items. I'd love to have a "Local Use Only" item type with hold limits that couldn't be overruled by a librarian. From: Katrin Fischer <katrin.fischer.83(a)web.de> To: koha(a)lists.katipo.co.nz Cc: Bcc: Date: Sat, 9 Jan 2021 14:24:07 +0100 Subject: Re: [Koha] Setting up a Local Use Only item type Hi Michael, is setting up a new item type for these kind of items an option for you? I believe with an item type you could achieve what you want to do within the circulation conditions. Katrin On 07.01.21 22:10, Michael Adamyk wrote: > Hi everyone, > I am the manager for a Koha consortium, and I'm trying to figure out the > best way to make an item that is available for checkout only at the local > branch, and nowhere else. (Generally we share items freely between > libraries ("branches").) In this case, though, there shouldn't be any holds > placed on it from anywhere other than the home library. Think a special > collection that is only available to local patrons. > > In the past, we've gotten around this two ways: > 1. Set up a "Local Availability Only" lost status. This works well, except > that it is temporary and is cleared every time an item is checked in. Not > very good for a long-term solution. > 2. Set up our circ rules to prevent holds on specific item types. This > works only as long as other librarians don't decide to override the holds > restrictions. If they do, it doesn't work as planned. > > What are your suggestions? Is there a Koha setting for precisely this type > of situation that I am overlooking? Thanks in advance for your help! >

2 1

Time to translate: string freeze to prepare January release
by Fridolin SOMERS 15 Jan '21

15 Jan '21

Hi, String freeze is into effect today for the 20.11.x maintenance branch for 20.11.02 release. The release is scheduled for around the 22th of January. This means it's the right time to head over to the translation platform: https://translate.koha-community.org/projects/ Happy translating 🌎🌍🌏 -- Fridolin SOMERS <fridolin.somers(a)biblibre.com> Software and system maintainer 🦄 BibLibre, France

1 0

patron notice
by vinod kumar 15 Jan '21

15 Jan '21

I am using Koha 17.05.07 in debian 8 and Koha & mails are working fine in this instance. I upgrade it to new Koha 20.05.07 in debian 10, and suddenly circulation mails get stopped. Overdues mails are working fine but check-in, check-out mails are not working. When I checked there is no entry in message_queue table for circulation. I don't know what is the issue. Any point of help is highly appreciated.

2 3

Koha web admin changes saved to master *.conf file?
by Bales (US), Tasha R 14 Jan '21

14 Jan '21

Good afternoon, I'm configuring a new Koha instance and am interested if the changes made via the web admin interface, such as Circulation settings, are all saved to a consolidated file on the server. Whatever changes I make, I'd like to reproduce them when I have the chance to move from a VM to a real server. For now, I am copying/pasting. However, I thought perhaps there is an easier, neater way to keep track of any changes I make from the defaults. I'm still new to navigating all the documentation, so please pardon me if I've missed the obvious. Thanks for your time! Tasha R. Bales

2 3