[Koha] Koha Digest, Vol 202, Issue 11

Mercedes Portugal mportugal at ign.gob.ar
Sat Aug 13 03:33:17 NZST 2022


Thanks Katrin! 

I dont understand why in Administration-Koha-to-MARC mappings we see the following already set in the system: 

biblio.biblionumber 774 w Record control number 
biblio.biblionumber 999 c Koha biblionumber 

Field 774 w should not be there.... 



-- 
Mg. Mercedes Portugal 
Biblioteca Cnl. Manuel José Olascoaga 
Instituto Geográfico Nacional 
http://www.ign.gob.ar 
Av. Cabildo 381 – C.A.B.A. – CP: 1426 
Tel: 011 4576 5576 interno 172 


De: "koha-request" <koha-request at lists.katipo.co.nz> 
Para: "koha" <koha at lists.katipo.co.nz> 
Enviados: Jueves, 11 de Agosto 2022 21:00:01 
Asunto: Koha Digest, Vol 202, Issue 11 

Send Koha mailing list submissions to 
koha at lists.katipo.co.nz 

To subscribe or unsubscribe via the World Wide Web, visit 
https://lists.katipo.co.nz/mailman/listinfo/koha 
or, via email, send a message with subject or body 'help' to 
koha-request at lists.katipo.co.nz 

You can reach the person managing the list at 
koha-owner at lists.katipo.co.nz 

When replying, please edit your Subject line so it is more specific 
than "Re: Contents of Koha digest..." 


Today's Topics: 

1. Rebuild database / clean install (Father Vlasie) 
2. Re: Rebuild database / clean install (Arthur) 
3. Re: multiple copy holdings (Caroline Cyr La Rose) 
4. Trouble with Zebra indexes in 22.05 version (Mercedes Portugal) 
5. Re: Trouble with Zebra indexes in 22.05 version (Katrin Fischer) 


---------------------------------------------------------------------- 

Message: 1 
Date: Wed, 10 Aug 2022 22:29:17 -0700 
From: Father Vlasie <fv at spots.edu> 
To: koha at lists.katipo.co.nz 
Subject: [Koha] Rebuild database / clean install 
Message-ID: <BC41DF81-D297-453F-AA4C-1132942EDEFE at spots.edu> 
Content-Type: text/plain; charset=us-ascii 

Hello everyone! 

I would like to migrate to a new Koha installation. On my current install I am seeing a lot of errors (mostly, I think, due to using cpan to install perl modules which means I often have the wrong versions :( ). I also have some auto-increment related problems in the DB. 

I am thinking of doing a fresh install and moving the Koha data over. However, all of the tutorials I have found recommend doing a mysqldump and then slurping that into the new DB. If I want to avoid bringing DB problems along from the old install will that method not be problematic? 

Is there a way to export the data to a different format and rebuild the SQL from that? (Maybe the export command under admin>tools?) 

I have not seen any documentation regarding my concept of a clean install hence my decision to write to the list. 

Thank you in advance for any feedback or suggestions! 

Father Vlasie 

------------------------------ 

Message: 2 
Date: Thu, 11 Aug 2022 09:00:28 +0200 
From: Arthur <arthur.suzuki at biblibre.com> 
To: koha at lists.katipo.co.nz 
Subject: Re: [Koha] Rebuild database / clean install 
Message-ID: <0300de6a-9ed1-6127-0ee0-b69e49cbc55f at biblibre.com> 
Content-Type: text/plain; charset=UTF-8; format=flowed 

Hello, 

There is a collection of scripts in the "misc" folder, some of them 
provide a way to export/import datas in Koha. 

export_borrowers.pl, export_records.pl and i just saw 
misc/admin/koha-preferences which permits to export and import all the 
system preferences. 

However there are quite other data and configuration options for which 
an export is missing like libraries, circulation rules, patron 
categories, koha-marc mapping configuration, Marc fields configurations, 
etc... 

I would first suggest trying with an erratic dump and let the update 
tool from Koha do the job. 

There are also batch scripts in misc to fix some of the erratic data. 

Best, 

Arthur Suzuki, 

Developer @BibLibre 

On 11/08/2022 07:29, Father Vlasie wrote: 


Hello everyone! 

I would like to migrate to a new Koha installation. On my current install I am seeing a lot of errors (mostly, I think, due to using cpan to install perl modules which means I often have the wrong versions :( ). I also have some auto-increment related problems in the DB. 

I am thinking of doing a fresh install and moving the Koha data over. However, all of the tutorials I have found recommend doing a mysqldump and then slurping that into the new DB. If I want to avoid bringing DB problems along from the old install will that method not be problematic? 

Is there a way to export the data to a different format and rebuild the SQL from that? (Maybe the export command under admin>tools?) 

I have not seen any documentation regarding my concept of a clean install hence my decision to write to the list. 

Thank you in advance for any feedback or suggestions! 

Father Vlasie 
_______________________________________________ 

Koha mailing list http://koha-community.org 
Koha at lists.katipo.co.nz 
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 




------------------------------ 

Message: 3 
Date: Thu, 11 Aug 2022 10:13:45 -0400 
From: Caroline Cyr La Rose <caroline.cyr-la-rose at inlibro.com> 
To: koha at lists.katipo.co.nz 
Subject: Re: [Koha] multiple copy holdings 
Message-ID: <f6ac233d-d12f-5a80-b1fa-634f03619e47 at inlibro.com> 
Content-Type: text/plain; charset=UTF-8; format=flowed 

Hi David, 

If working in MARC21, you should have one 952 tag per copy. The 
mandatory subfields for 952 are $a (home library), $b (holding library), 
$p (barcode) and $y (itemtype). 

More info in the manual: 
https://koha-community.org/manual/22.05/en/html/cataloging.html#location-and-item-information-952 

A (very minimal) record with multiple copies would look like 

100 _a Conrad, Joseph. 
245 _a 'Twixt Land and Sea / 
_c Joseph Conrad 
942 _2z 
_cBK 
952 _aCPL 
_bCPL 
_p000055 
_yEBOOK 
952 _aCPL 
_bCPL 
_p1488 
_yEBOOK 

I hope this helps, 

Caroline 

On 2022-08-10 19:02, David Schaller wrote: 

BQ_BEGIN
What is the best-practice way for preparing MARC data for Koha with respect to multiple copies of a title? One video I watched said to copy the 952 fields into 953, 954, etc. for each copy. Another video looked like it was just repeating 952p for each copy (barcode field). What does Koha actually expect for multiple copies? 

Thanks, David 
_______________________________________________ 

Koha mailing listhttp://koha-community.org 
Koha at lists.katipo.co.nz 
Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha 
BQ_END

-- 
Caroline Cyr La Rose, M.S.I. 
Bibliothécaire | Responsable de produit 

Tél. : 1-833-465-4276, poste 221 
Caroline.Cyr-La-Rose at inLibro.com <mailto:caroline.cyr-la-rose at inLibro.com> 

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com> 

------------------------------ 

Message: 4 
Date: Thu, 11 Aug 2022 15:35:02 -0300 (ART) 
From: Mercedes Portugal <mportugal at ign.gob.ar> 
To: koha at lists.katipo.co.nz 
Subject: [Koha] Trouble with Zebra indexes in 22.05 version 
Message-ID: <530410041.33248.1660242902979.JavaMail.zimbra at ign.gob.ar> 
Content-Type: text/plain; charset=utf-8 

Hi there! 

We have just installed the 22.05 version and we are having trouble with the advanced searching. 

We ran the following command many times koha-rebuild-zebra -f -v biblioteca but the advanced searching is not working at all. 

and we get this message: 


Zebra configuration information 
================================ 
Zebra biblio directory = /var/lib/koha/biblioteca/biblios 
Zebra authorities directory = /var/lib/koha/biblioteca/authorities 
Koha directory = /usr/share/koha/intranet/cgi-bin 
Lockfile = /var/lock/koha/biblioteca/rebuild/rebuild..LCK 
BIBLIONUMBER in : 774$w 
BIBLIOITEMNUMBER in : 999$d 
================================ 
Job started: 17:22:40 
skipping authorities 
==================== 
exporting biblio 17:22:41 [00:00:01] 
==================== 
15601.................................................................................................... 
Records exported: 15658 17:25:45 [00:03:05] 
==================== 
REINDEXING zebra 17:25:45 [00:03:05] 
==================== 
17:25:47-11/08 zebraid 21138) [warn] Record didn't contain match fields in (bib1,Local-number) 
==================== 
Indexing complete: 17:25:47 [00:03:07] 
==================== 
CLEANING 
==================== 
Zebra configuration information 
================================ 
Zebra biblio directory = /var/lib/koha/biblioteca/biblios 
Zebra authorities directory = /var/lib/koha/biblioteca/authorities 
Koha directory = /usr/share/koha/intranet/cgi-bin 
Lockfile = /var/lock/koha/biblioteca/rebuild/rebuild..LCK 
BIBLIONUMBER in : 774$w 
BIBLIOITEMNUMBER in : 999$d 
================================ 
Job started: 17:25:49 
==================== 
exporting authority 17:25:50 [00:00:01] 
==================== 
5001.................................................................................................... 
Records exported: 5015 17:25:56 [00:00:07] 
==================== 
REINDEXING zebra 17:25:56 [00:00:07] 
==================== 
skipping biblios 
==================== 
Indexing complete: 17:26:03 [00:00:14] 
==================== 
CLEANING 
==================== 

Does anyone know what may be happening? 

Thanks!! 

-- 
Mg. Mercedes Portugal 
Biblioteca Cnl. Manuel José Olascoaga 
Instituto Geográfico Nacional 
http://www.ign.gob.ar 
Av. Cabildo 381 – C.A.B.A. – CP: 1426 
Tel: 011 4576 5576 interno 172 


------------------------------ 

Message: 5 
Date: Thu, 11 Aug 2022 21:16:12 +0200 
From: Katrin Fischer <katrin.fischer.83 at web.de> 
To: koha at lists.katipo.co.nz 
Subject: Re: [Koha] Trouble with Zebra indexes in 22.05 version 
Message-ID: <93ef40bf-dc3c-9004-b914-c681cd0ddc9c at web.de> 
Content-Type: text/plain; charset=UTF-8; format=flowed 

Hi Mercedes, 

it looks like you are not using a standard configuration. These are the 
problematic lines: 

BIBLIONUMBER in : 774$w 

17:25:47-11/08 zebraid 21138) [warn] Record didn't contain match fields 
in (bib1,Local-number) 

In a standard Koha MARC21 installation, the first line would read 999$c. 
Zebra needs the biblionumber in order to make the connection between the 
record in the index and the one in your database. 

Check your records to see where your biblionumber is actually stored. If 
they are still in 999$c, it might just be a matter of fixing your 
Koha-to-MARC mappings. 

Hope this helps, 

Katrin 




On 11.08.22 20:35, Mercedes Portugal wrote: 

BQ_BEGIN
Hi there! 

We have just installed the 22.05 version and we are having trouble with the advanced searching. 

We ran the following command many times koha-rebuild-zebra -f -v biblioteca but the advanced searching is not working at all. 

and we get this message: 


Zebra configuration information 
================================ 
Zebra biblio directory = /var/lib/koha/biblioteca/biblios 
Zebra authorities directory = /var/lib/koha/biblioteca/authorities 
Koha directory = /usr/share/koha/intranet/cgi-bin 
Lockfile = /var/lock/koha/biblioteca/rebuild/rebuild..LCK 
BIBLIONUMBER in : 774$w 
BIBLIOITEMNUMBER in : 999$d 
================================ 
Job started: 17:22:40 
skipping authorities 
==================== 
exporting biblio 17:22:41 [00:00:01] 
==================== 
15601.................................................................................................... 
Records exported: 15658 17:25:45 [00:03:05] 
==================== 
REINDEXING zebra 17:25:45 [00:03:05] 
==================== 
17:25:47-11/08 zebraid 21138) [warn] Record didn't contain match fields in (bib1,Local-number) 
==================== 
Indexing complete: 17:25:47 [00:03:07] 
==================== 
CLEANING 
==================== 
Zebra configuration information 
================================ 
Zebra biblio directory = /var/lib/koha/biblioteca/biblios 
Zebra authorities directory = /var/lib/koha/biblioteca/authorities 
Koha directory = /usr/share/koha/intranet/cgi-bin 
Lockfile = /var/lock/koha/biblioteca/rebuild/rebuild..LCK 
BIBLIONUMBER in : 774$w 
BIBLIOITEMNUMBER in : 999$d 
================================ 
Job started: 17:25:49 
==================== 
exporting authority 17:25:50 [00:00:01] 
==================== 
5001.................................................................................................... 
Records exported: 5015 17:25:56 [00:00:07] 
==================== 
REINDEXING zebra 17:25:56 [00:00:07] 
==================== 
skipping biblios 
==================== 
Indexing complete: 17:26:03 [00:00:14] 
==================== 
CLEANING 
==================== 

Does anyone know what may be happening? 

Thanks!! 



BQ_END

------------------------------ 

Subject: Digest Footer 

_______________________________________________ 
Koha mailing list 
Koha at lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha 


------------------------------ 

End of Koha Digest, Vol 202, Issue 11 
************************************* 




More information about the Koha mailing list