- Koha - lists.katipo.co.nz

linked item subfield to unlinked item subfield (items.more_subfields_xml)
by Julien Sicot 01 Oct '21

01 Oct '21

Hi everyone, Do you know if there is a method, a script or a tool to easily migrate a linked (koha db) item subfield to an unlinked item subfield (ie : items.more_subfields_xml). We will soon upgrade koha from 18.11 to 20.11and we are trying to find a solution to the removal of items.paidfor subfield. We have used paidfor to store some item values so that can be easily searched using the item search functionality… Sadly, in 20.11 we have not determined any other column in the database that are not already in use or linked to another marc subfield… Thanks for any help, Best, Julien Sicot Applications documentaires DSI - Pôle Applications Université Rennes 2 02 22 51 44 41

2 2

Hold problems
by Ketut Gunawan 30 Sep '21

30 Sep '21

Dear all, I need a help. I have problems with Koha's Hold feature. Patron can place a hold but cannot cancel it. For cancelling a hold the message is: "Sorry, the requested page is not available. Error 500" Staff can check in a hold, bu cannot: - check out a hold - suspend a hold - delete a hold For these the error message is: "An error has occurred! Error 500 How to solve this problem? Any clue and help would be greatly appreciated. I install the latest Koha (21.05) in docker. Thank you. Best regards, K. Gunawan

1 0

Deleted Visible Records
by Charles Kelley 30 Sep '21

30 Sep '21

Hi, all! Some months ago, I deleted several records. None of the deleted records shows up in a regular search of the catalog. However, all three show up when I run a report on framework codes, they suddenly show up. When I go look by the bib. record number (999 $c), I see "NoTitle", and when I click on the link to "NoTitle", Koha tells me that the record does not exist. So the records show up only in the report(s), the evidence tells me, not in a general catalog search. Is this a known bug? Is there a fix yet if it is a known bug? Many 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

Upgrade order
by Tom Burke 29 Sep '21

29 Sep '21

Hello the list We presently have a server with 5 instances, running 19.11.22 on Deb 9 (stretch). Over the new few months we aim to upgrade both - from stretch to buster, and from 19.11 to 20.11 or maybe 21.05. Which is the best order to do the upgrades in? OS first, or Koha? My natural caution leads me to prefer to do them separately. Tom Burke

1 0

Koha Community Newsletter: September 2021
by Koha Newsletter 29 Sep '21

29 Sep '21

The Koha Community Newsletter for September 2021 is here: * https://koha-community.org/koha-community-newsletter-september-2021/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me with any corrections or suggestions. -- Michael Kuhn Editor, Koha Community Newsletter

1 0

Re: [Koha] Display of Damage Status (952 ‡4)
by Charles Kelley 28 Sep '21

28 Sep '21

Hello, all! In our latest exchange, on 28 Sept. 2021 at 08:01 [JST], I received the following from Katrin Fischer, to wit:: I think what you describe, has been reported as > > *Bug 18062* > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18062> - > Damaged Status shows unavailable in results > > I am not aware of a way to change this at the moment. > > OpacHiddenItems would hide the damaged items from view and if there are > only damaged items, the record would be hidden as well. > > Hope this helps, Thanks for the advisement. Drat! I guess we'll advise the staff and patrons to ignore the statement until the bug is exterminated. I'll sign onto the report. Thanks again. -- 気を付けて。 /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

DBMS auto increment
by Scott Owen 27 Sep '21

27 Sep '21

Hi All, https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix Is this still the best procedure when getting the following error ? ************************************************ You should not ignore this warning. The problem is that InnoDB does not keep auto_increment across SQL server restarts (it is only set in memory). So on server startup the auto_increment values are set to max(table.id)+1. To know how to avoid this problem see the related wiki page: DBMS auto increment fix <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix> Problems foundCheckouts The following ids exist in both tables issues and old_issues: 4782, 4781 ************************************************ Any sql to clean things up in the two tables ?

2 2

Purchase suggestions and acquisitions workflows
by Patricia Dowling 27 Sep '21

27 Sep '21

Good afternoon to all Koha users. We in the Irish parliamentary library (or Oireachtas) are looking at purchase suggestions in Koha and our acquisitions workflows. We are using version 20.11 As we understand it this is the way purchase suggestions and associated notices work in Koha 1) Suggestion received -- notice text sent will be NEW_SUGGESTION 2) Suggestion accepted or rejected - if you change the status to Accepted the notice text sent will be ACCEPTED. If you change the status to Rejected the notice text sent will be REJECTED. 3) Suggestion ordered - if a material is Ordered the ORDERED notice text is sent. 4) Order received - The AVAILABLE notice is sent on the point of receive and this can only be altered by holding off receiving the item until it is ready. 5) Suggestion available - We think this overlaps with the AVAILABLE notice text? We are considering deleting the Suggestion ORDERED notice so that notices are not sent out when a suggestion has been ordered as it suggest to the user that the item is ready when in reality it may not yet have been catalogued. Are other libraries are actively using purchase suggestions features in Koha and if so can you share some information on the workflows you have adopted? Do you have any tips on what works best based on your experience? Thanks in advance Patricia Dowling Leabharlannaí Sinsearach| Senior Librarian Seirbhísí Córas agus Ábhair| Systems & Content Services Leabharlann an Oireachtais | Oireachtas Library Seirbhís Thithe an Oireachtais | Houses of the Oireachtas Service +353 (0)1 6183222 library.oireachtas.ie (internal) www.oireachtas.ie/library patricia.dowling(a)oireachtas.ie Lárdheasc Fiosrúcháin | Central Enquiry Desk +353 (0)1 6184701 library.and.research(a)oireachtas.ie Cuireann Seirbhís Thithe an Oireachtais fáilte roimh chomhfhreagras i nGaeilge Beartas ríomhphoist an Oireachtais agus séanadh. oireachtas.ie/ga/email-policy/<https://www.oireachtas.ie/ga/email-policy/> Oireachtas email policy and disclaimer. oireachtas.ie/en/email-policy/<https://www.oireachtas.ie/en/email-policy/>

2 6

Renewal notice email
by Shafrizan Affendi 27 Sep '21

27 Sep '21

Hi there. Im using Koha ver 21.05. I would like to ask how can I generate renewal notice (email) and send message que in every hour? If im not mistaken, default koha will send the email in the midnight. For example, i renew 1 book at 10 am. and will get the email notice at midnight. I want to make koha send the notice email right after i renew the book so that i can receive the email at 11.01 am. Can anyone help me? Thanks in advance

1 0

Display of Damage Status (952 ‡4)
by Charles Kelley 27 Sep '21

27 Sep '21

Hi, all! My library has a fairly significant number of books with yellowing paper. The books are still usable -- we would withdraw it otherwise -- and we plan to keep them in circulation until the paper turns brown or brittle. We have marked such books with the appropriate damage value in 952 ‡4. Unfortunately, this has led to confusion among some staff and almost all the patrons because Koha reports the books "Availability: No items available: Damaged (1)." We would like to show a different statement, something akin to: "Availability: every item available but 1 damaged." The latter would mean that all items are available for circulation but one is damage. Of course, if all items are available but none is damaged, the notice would read "Availability: every item available." Is this possible? Might the OPACHiddenItems list be a solution to this? Many thanks, everyone! -- 気を付けて。 /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