- Koha - lists.katipo.co.nz

Sort 1 and 2
by Himanshu Aggarwal 03 Jul '22

03 Jul '22

Is there any way one can enable Sort 1 and 2 in Self Registration? -- Assistant Librarian, Confucius Institute Scholar 13-14, R.D. National College, Bandra (W.)

2 2

(no subject)
by muiru james 03 Jul '22

03 Jul '22

Hello I want to bulk import records with items via terminal and I want to match records using title(245a) where if it exists to skip the incoming record but add items. How can I modify this script not to replace existing record with incoming one? perl bulkmarcimport.pl -framework BKS -b -file newbooks.mrc -match -Title:p Warm regards James

2 2

DB Upgrade error saga
by Keith Sorbo 02 Jul '22

02 Jul '22

I am still struggling to get my koha library database to upgrade properly. My saga: 1. I attempted an update which timed out and errored. 2. I restored from a mysql database prior to my update attempt 3. I ran the koha-upgrade-schema library update. It ran through quite few upgrades but errored with the following: Upgrading database schema for sati Upgrade to 21.12.00.057 [18:44:54]: Bug 30852 - Add index to article_requests.debit_id ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Key column 'debit_id' doesn't exist in table at /usr/share/koha/lib/C4/Installer.pm line 739 DEV atomic update /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/ bug_30899.pl [18:44:54]: Bug 30899 - Check borrower_attribute_types FK constraint (30449 follow-up) What do I need to do to get my koha library back up and functional? (We have been offline for over 2 weeks because of the database upgrade problems!)

2 1

Koha 22.05 on Ubuntu 22.04?
by Isabel Pineda 01 Jul '22

01 Jul '22

Hi. Does Koha 22.05 support Ubuntu 22.04? In the system requirements I can see that it goes only from Ubuntu version 18.04 to 21.10. Thank you Isabel

5 7

Re: [Koha] Koha SQL report with MARC field
by Holger Meissner 01 Jul '22

01 Jul '22

Hello Tadas, I suppose your MARC field is empty, then. As far as I can tell, field 675 is not used in MARC 21 bibliographic records. https://www.loc.gov/marc/bibliographic/bd6xx.html Maybe try field 657? Or rather take a look at your MARC records and check which field contains the information you need. Regards, Holger Tadas G wrote: > The report starts but does not show all the information. The column is empty

1 0

Re: [Koha] Koha SQL report with MARC field
by Tadas G 01 Jul '22

01 Jul '22

The report starts but does not show all the information. The column is empty Thanks for the help

1 0

Re: [Koha] Koha SQL report with MARC field
by Holger Meissner 01 Jul '22

01 Jul '22

Hello Tadas, does this work? SELECT i.dateaccessioned AS "Pridejimas", i.barcode AS "Barkodas", b.author AS "Autorius", b.title AS "Pavadinimas", bi.publishercode AS "Leidykla", i.copynumber AS "Inventorinis", bi.isbn AS "ISBN", i.itemnotes AS "Uzrasai", i.itype AS "Išteklis", i.homebranch AS "Lokacija", ExtractValue(m.metadata, '//datafield[@tag="675"]/subfield[@code="3"]') AS "Informacija" FROM items i LEFT JOIN biblioitems bi ON i.biblioitemnumber = bi.biblioitemnumber LEFT JOIN biblio b ON bi.biblionumber = b.biblionumber LEFT JOIN biblio_metadata m ON m.biblionumber = b.biblionumber WHERE i.dateaccessioned BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> ORDER BY i.barcode DESC Regards, Holger

1 0

How to update database from command line
by Keith Sorbo 01 Jul '22

01 Jul '22

What is the proper way to update my database from the command line? When I run from the web interface, it times out and leaves me with an error in my database. Thanks.

2 1

Koha Community Newsletter: June 2022
by Koha Newsletter 30 Jun '22

30 Jun '22

The Koha Community Newsletter for June 2022 is here: https://koha-community.org/koha-community-newsletter-june-2022/ 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

Adding an encryption_key to koha-conf.xml
by Mike Lake 30 Jun '22

30 Jun '22

Hi All Just upgraded tonight from Koha 21.11.05.000 to 22.05.00-1 That all went fine. The About Koha page now says: "Warning: You are missing the <encryption_key> entry in your koha-conf.xml file. Please generate a key." I can see a place for this is the koha-conf-site.xml.in file (and a suggestion to use pwgen 32) but how do you process this to the koha-conf.xml files for each site? The "pwgen 32" suggests this should be 32 characters and is itself just something that no one should be able to guess. So I can can just put anything in there that is long and complex? I could not find anything about this is the docs or wiki or recent emails, just the patch for it in the github repo via Google. Thanks Mike

4 7