- Koha - lists.katipo.co.nz

Re: [Koha] Off-site storage
by Charles Kelley 25 Oct '21

25 Oct '21

Hi, Elaine et al! In our latest exchange, on 22 Oct. 2021 at 08:01 [JST], I received this from Elaine Bradtke <eb(a)efdss.org>: I would like to ask how other libraries are handling material in remote storage. > Currently, we only have a location code for off-site material. However, > it seems we need a way to clearly indicate that the material must be > requested a certain amount of time in advance. > > Do you use the holds module for these items? We haven't used patron logins, > or holds because it's primarily a reference collection. Do you treat > remote storage as a branch? So many options, please tell me what works > best for you. > Yes, after a fashion, we use a branch. Here's what I mean. - We made a library for offsite storage. Here are the Koha values we filled in. - Code = OFF - Name = Offsite Storage - OPAC Info = To get this work, please place a hold for it or contact the library staff. Please allow approximately 7-10 days. - All the other fields are left empty so that other libraries can use the OFF library. - In the item record, we change 952 $b to OFF (Offsite Storage). It's the only subfield we have to change. - In the system preferences, we make sure both the home library and the current library are to be displayed (OPACLocationBranchToDisplay). Why this arrangement? - It shows that the library still owns at least one copy, and it came from the XXX collection in the YYY shelving location. - It shows that the copy has been put in storage. - The rollover (mouseover, balloon tag or help tag if you prefer) instructs how to get the work and approximately how long it ought to take. We usually go to storage to retrieve materials twice a week (Mondays and Thursdays), so an estimate of 7-10 days probably lengthens the expectations, so that patrons are pleased, to paraphrase Scotty's "How do think I keep my reputation as a miracle worker," when the work comes 3-4 days later instead. Of course, in the long term, the general expectations will shorten to reflect reality. - The library staff will not have to record the XXX collection and YYY shelving location in 952 $x in case the work is reintegrated into the collection. It's a simple change of copying the home library into the current library. - The wording is to allow other libraries and branches to use the same code if they need it. I have to state that no procedure is perfect. But it, along with patron education, works reasonably well, and that's usually enough for the library staff and our patrons. If you have questions, please may you be encouraged to ask. -- 気を付けて。 /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.

2 1

Koha REST API Functionalities
by Aswin Unnikrishnan 25 Oct '21

25 Oct '21

Hi, Does Koha Rest API support all functionalities of the SIP2 server? I wanted to use APIs to replace some functionalities currently implemented with SIP2 like check-in, checkout etc. I searched the API documentation but did not find any for check-in or checkout Thanks, Aswin

3 2

Blood group field
by Sagar Londhe 23 Oct '21

23 Oct '21

Dear all, Greetings !!! I am working on patron card and would like to add the blood group of the patron on the card. please guide me about the exact SQL name for the blood group field. Regards, -- Mr.Sagar B. Londhe (BBA, M.Lib.I.Sc) Thane 400602, Mumbai, Maharashtra, India. Mo. No.: 9049164508

2 3

MARC modification templates w/ indicators?
by Bales (US), Tasha R 23 Oct '21

23 Oct '21

Do MARC modification templates support changes based on, or to, MARC indicators? For instance, I'd like to change all instances of 856 _8 to 956 _ _. However, I don't see a clear way to specify or insert indicators w/ or w/o RegEx. Are the indicators considered part of the field data? I could do this with MarcEdit, but I'd rather just do it here. Is MarcEdit the only option? Thanks!! Tasha Bales Enterprise Services http://isesi.web.boeing.com/

2 1

Translation platform sync delay: 2nd call to translators to prepare this month's minor release
by Victor Grousset/tuxayo 22 Oct '21

22 Oct '21

Hi, Due to a delay in getting the platform in sync with the to-be-released code, the new strings came Wednesday. So translators are advised to take another look to translate these: https://translate.koha-community.org/ The minor releases of 21.05.x 20.11.x 20.05.x 19.11.x will be around the 27th. Happy translating :) -- Victor Grousset/tuxayo

1 0

koha ugrade from 3.22.21 to 19.05.17
by George Mikuchadze 22 Oct '21

22 Oct '21

I've upgraded empty koha(on ubuntu 18.04) from 3.22.21 to 19.05.17 using only the tarball file(without sudo apt-get install koha-common). Everything was nice - until I tried to login intranet site with a super admin account after a successful web installer procedure of upgrading the koha tables: "Error: Invalid username or password". I checked the koha-conf.xml file and the username and password were unchanged! What happened with koha - did the Memcached server change the settings? George Mikuchadze National Scientific Library of Georgia

2 1

Error "500" on Opac
by Bruce Yelen 20 Oct '21

20 Oct '21

Being rather new to this list, I will apologize in advance if I'm mis-framing this question. After upgrading from Koha 20.05 to 21.05, I started receiving an HTTP 500 error when an OPAC user clicks on a specific title in the list returned by a catalog search. This does not occur when doing a catalog search on the staff pages. I have looked through the various Koha logs, but cannot find any errors pointing to a script, or anything. Any ideas and suggestions of where to look for the cause and resolution of this would be helpful. Many Thanks! Bruce Yelen

4 9

Local use preference OPACviewMARC doesn't switch off?
by Elaine Bradtke 20 Oct '21

20 Oct '21

As an experiment, we thought we'd switch this off because there's some information in the MARC record that we need internally but would rather it wasn't displayed in the OPAC. However, when I switched OPACviewMARC off and saved the change, it didn't seem to make a difference. Is there something we need to run behind the scenes to make this work? Usually when I make changes it's visible immediately. We're using 21.05.04 Elaine Bradtke VWML <https://www.vwml.org> English Folk Dance and Song Society <https://www.efdss.org> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999

4 6

patron permission for one library
by Yatheesh lis 20 Oct '21

20 Oct '21

Hi how to set patron permission for only one library (all permissions). This patron should not edit other library data -- Y.Yatheesh Babu 8247838231

3 4

Handling SELECT with Empty Input
by Charles Kelley 20 Oct '21

20 Oct '21

Hi, all! In one of my library's reports, the full SELECT statement reads as follows: SELECT items.barcode AS 'Barcode Number' ExtractValue(metadata,'//datafield[@tag="092"]/subfield[@code="a"]') AS 'Class Number', ExtractValue(metadata,'//datafield[@tag="092"]/subfield[@code="b"]') AS 'Cutter', items.ccode AS 'Collection', items.location AS 'Shelf Location', items.itype AS 'Item Type', items.itemnumber AS 'Item Record Number', biblio.biblionumber AS 'Bib Record Number' FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) JOIN biblio_metadata ON (biblioitems.biblionumber = biblio_metadata.biblionumber) WHERE items.dateaccessioned = <<Which day?|date>> AND items.ccode = <<Which collection?|ccode>> AND items.location = <<Which shelving location?|loc>> I have a question: On a test run, I forgot to input a date (dateaccessioned = <<Which date? ...>) and I got a software error. On the next and subsequent runs, I included a date, and it ran perfectly well. My question is this: is it possible to test for input and substitute a default value. With IF, WHILE, etc. statements, program application code handles this sort of thing well. SQL, I don't know. It might look like the following in pseudo SQL code picking up from the SQL: WHERE (items.dateaccessioned = <<Which collection?|ccode>> BUT IF items.dateaccessioned IS NULL THEN items.dateaccessioned = TODAY) AND (items.ccode = <<Which collection?|ccode>> BUT IF items.ccode IS NULL THEN items.ccode = THIS_COLLECTION) AND (items.location = <<Which shelving location?|loc>> BUT IF items.location IS NULL THEN items.ccode = THIS_LOCATION) in order to avoid a software error. A conditional input check, so to speak. (BUT, IF, and THEN are my pseudocode extensions to SQL statements.) I know this is partly built on my limited understanding of SQL and I probably hope against hope. That's fine; I'll just make sure the staff are taught to select something from the dropdown menus or enter something in textboxes if te want to avoid the software error. If it's possible in a Perl routine or, dare I say, required in a Perl routine, I'll try to teach myself enough Perl to do the Perl analog to something like this with the understanding that in future editions of Koha, the schema and structure may change enough to render the Perl routine obsolete. Thanks, all. -- 気を付けて。 /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.

2 1