- Koha - lists.katipo.co.nz

Re: [Koha] Forgiving all overdue fines
by Charles Kelley 24 Mar '22

24 Mar '22

Hello, Raymund! In a recent exchange, on 24 Mch. 2022 at 08:00 [JST], I read the following from you through the Koha Discussion Group. We did exactly the same thing. We decided to wipe all fines (not cocts of > replacements) accrued since 14th December 2019. We had PTFS Europe (our > support company) do this. They ran this little SQL: > > SELECT accountlines_id, date, accounttype, payment_type, amountoutstanding > FROM accountlines > WHERE date > '2019-12-14' > AND accounttype IN ('F','FU') > AND amountoutstanding > 0 > > The support analyst said: "This finds 5129 bills. If you are happy for > these to be deleted, let me know". > > I did, and they were gone in an instant. > I'm curious: You didn't have to make a SQL statement like this: UPDATE accountlines > SET amountoutstanding = 0 > WHERE date > '2019-12-14' AND accounttype IN ('F', 'FU') AND > amountoutstanding > 0; > Does the Koha report processor accept UPDATE clauses or do you know? Of course, if you want for posterity a report of forgiven fines before they are forgiven, you probably would want run the SELECT SQL statement above. -- よろしくお願いします。 -- 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

Forgiving all overdue fines
by Stephen Graham 23 Mar '22

23 Mar '22

Hi All - we stopped fining users for overdue items years ago, but still have quite a bit unpaid debt in our Koha system. We would like to write off all this debt in bulk. I'm just wondering if there's a "built in" way of doing this in Koha - I can't see anything in the staff client, but maybe there's a cmd line tool that might help? If not I'm looking to write a script to calling the Pay method from the Koha::Account class. I don't think there's a RESTful API endpoint for this type of activity yet? Cheers, Stephen -------------------------------------- Stephen Graham Library Technology Consultant Library and Computing Services University of Hertfordshire Hatfield, Hertfordshire, AL10 9AB Email: s.graham4(a)herts.ac.uk<mailto:s.graham4@herts.ac.uk> Website: herts.ac.uk

2 1

Elasticsearch punctuation help
by Aleisha Amohia 21 Mar '22

21 Mar '22

Hey all We have Elasticsearch running on a Koha and would like some help with our index configuration. We would like searches that include punctuation to also search as if the punctuation wasn't there. For example, we would like a search for "e-commerce" to also return results for "ecommerce" and vice versa. Or a search for "a:b" to also return results for "ab". Does anyone have any tips for token filters or anything else that we should try to make ES work how we want? Thanks! -- *Aleisha Amohia*(she/her) Koha Developer Catalyst IT - Expert Open Source Solutions Tel: +64 4 499 2267 | www.catalyst.net.nz <http://www.catalyst.net.nz> Catalyst Logo CONFIDENTIALITY NOTICE: This email is intended for the named recipients only. It may contain privileged, confidential or copyright information. If you are not the named recipient, any use, reliance upon, disclosure or copying of this email or its attachments is unauthorised. If you have received this email in error, please reply via email or call +64 4 499 2267.

1 0

How to link authority data via existing number?
by Michael Kuhn 18 Mar '22

18 Mar '22

Hi In our library we are migrating from our current system to Koha 21.11. We have migrated existing authority data and created for example Title data record * MARC 100$9 STA101744 * MARC 100$a Lansky, Ralph Authority data record (PERSO_NAME) * MARC 001 STA101744 * MARC 100$a Lansky, Ralph Both kinds of records were successully loaded, after that we tried to link these records using script "link_bibs_to_authorities.pl" but it failed. We expected this would create a link between title record and authority record via number STA101744 but instead the content of MARC 001 of the authority record was surprisingly replaced by a new number and it linked only to one title record that didn't have content in MARC 100$9 but did contain (another) "Lansky, Ralph" in MARC 100$a. While the actual records containing MARC 100$9 STA101744 were not linked to the authority record and seem to have been ignored. How can we successfully link title data records via existing numbers in MARC 001 of the authority record? 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

1 0

Time to translate: string freeze to prepare Koha 20.11.17 has begun
by Victor Grousset/tuxayo 17 Mar '22

17 Mar '22

Hi, String freeze is into effect as of now for the 20.11.x maintenance branch. 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 20.11, then you must also copy it to 21.05 and 21.11. Otherwise your work will be lost for future versions. Happy translating :) -- Victor Grousset/tuxayo

1 0

The Terrific Every Other Thursday Training Videos - Season 2 / Episode 12: jQuery: Remove the Trailing Slash from Titles
by BRANNON, CHRISTOPHER 17 Mar '22

17 Mar '22

We're so CRAZY but we're not slashing prices! No! We ARE slashing the slashes in the titles! That's right! You too can slash the slash! Simply watch this video and apply our jQuery, and you and your patrons can enjoy endless results in staff AND OPAC searches without all those pesky trailing slashes! (Only applies if you modify the XSLT to remove authors and contributors from the title line and may not be valid in all 50 states (just kidding). Side effects may include spontaneous jumping for joy after endless ranting about slashes being part of the MARC standard for titles, and may alleviate strange looks from co-workers as you recount your annoyance at the existence of characters mixed in with your data which would otherwise be pristine.) https://youtu.be/eXW5gZoYsFU Christopher Brannon koha-US

1 0

Koha's OPAC package
by erlanda_simonyan＠flib.sci.am 17 Mar '22

17 Mar '22

Hello List, Can we use only Koha's OPAC package as full-text searching engine without INTRANET package and its components?, and can we use Koha with Solr for OPAC searching? Thanks

2 1

Koha online bill copy format
by MASTeR Library 17 Mar '22

17 Mar '22

How to Create an Email Receipt Template for Payment in Koha (Online Bill Copy) https://youtu.be/ARFcSJ_l76I https://libpowertech.blogspot.com/2022/03/how-to-create-email-receipt-templ… -- Thanking you.. Librarian, MAMCET <http://mamcet.com/> Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105.

1 0

Records in Koha with no metadata / no MARC in the BLOB.
by Raymund Delahunty 16 Mar '22

16 Mar '22

We have managed to save 40 biblios into Koha where there is no data in the metadata field in the biblio_metadata table. I can see data in the biblio table so that part of the 'save' has worked, but the MARC data is nowhere to be seen or found. Our support company is investigating as so far my attempts to overlay the bib record with new bib data have not fixed the problem. I wasn't able to export the data out for a simple overlay (well, I don't think there **is** any MARC data to go grab). I created a brief MARC record for one of the part-missing records, and gave it the old Koha biblionumber 322949 by keying data that into the 999. =LDR 00254 a2200073 4500 =100 1\$aBaerselman le Gros, Natalie =245 10$aObsession, possession and oppression: collecting and social structures in French art deco 'exoticism' furniture =942 \\$n0$01<file://$n0$01> =999 \\$c322949$d322949<file://$c322949$d322949> But when I tried to import this into our test server, matching on the existing biblionumber, no match was found, so a new record was going to be created. There just doesn't seem to be enough left of 322949 to latch onto. Has anyone experienced this before, and if so, is there a fix I can apply (I don't have write access to the tables). Ray Delahunty This email and any attachments are intended solely for the addressee and may contain confidential information. If you are not the intended recipient of this email and/or its attachments you must not take any action based upon them and you must not copy or show them to anyone. Please send the email back to us and immediately and permanently delete it and its attachments. Where this email is unrelated to the business of University of the Arts London or of any of its group companies the opinions expressed in it are the opinions of the sender and do not necessarily constitute those of University of the Arts London (or the relevant group company). Where the sender's signature indicates that the email is sent on behalf of UAL Short Courses Limited the following also applies: UAL Short Courses Limited is a company registered in England and Wales under company number 02361261. Registered Office: University of the Arts London, 272 High Holborn, London WC1V 7EY

1 0

Koha security release available ⚠
by Victor Grousset/tuxayo 16 Mar '22

16 Mar '22

Hello! :) The Koha Community is happy to announce the release of Koha 21.05.12, 20.11.16, 19.11.27. The previous release of 21.11.03 already contained the fixes. Users are advised to upgrade their Koha to these versions The full release notes can be found at: https://koha-community.org/koha-21-05-12-released https://koha-community.org/koha-20-11-16-released/ https://koha-community.org/koha-19-11-27-released/ The latest Koha packages and tarballs are ready. Thanks to everyone involved :) -- Victor Grousset/tuxayo

1 0