- Koha - lists.katipo.co.nz

Koha SQL report with MARC field
by Tadas G 04 Jul '22

04 Jul '22

Hello, My Koha 21.05.11 version. I use this report to view the inventory. It works well. The question would be how would I go about adding a MARC field from Record e.g 675$3 Maybe someone has an idea how to add it? SELECT items.dateaccessioned AS Pridėjimas,items.barcode AS Barkodas,biblio.author AS Autorius,biblio.title AS Pavadinimas,biblioitems.publishercode AS Leidykla,items.copynumber AS Inventorinis,biblioitems.isbn AS ISBN,items.itemnotes AS Uzrasai,items.itype AS Išteklis,items.homebranch AS Lokacija FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.dateaccessioned BETWEEN <<Between Date (yyyy-mm-dd)|date>> and <<and (yyyy-mm-dd)|date>> ORDER BY items.barcode DESC I think you need to add lines: CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',b.biblionumber, '\">', b.title, '</a>' ) AS Title, ExtractValue(bi.metadata, '//datafield[@tag="675"]/subfield[@code="3"]') AS "Informacija", But I don't know how to add them to work Thanks for the help

2 1

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 03 Jul '22

03 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 02 Jul '22

02 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