Dear Koha-List Members! presently I am working on importing a school library (>10000 records) into koha. I have a csv file with all items. The actual format is: author, title, full call number(shelf place), barcode I convert this file via marcedit into mrk, and mrc file. mrc sample: =LDR 00232nam a2200109Ia 45e0 =008 120501s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$aauthor =245 \\$atitle =952 \\$oFCN(Shelf) =952 \\$pbarcode Importing this mrc file via 'Stage marc record ...' results in a record with two items, one 952$o item and one 952$p item. I would expect to have one record with one item having the 952$o and the 952$p entry. Is this the standard behaviour? Are there any settings where I can define which mrc syntax will result in creating a new item? Is there a documentation how the import is handled? Some of my records have multiple item for one record, they look like: author, title, full call number(shelf place), barcode1 author, title, full call number(shelf place), barcode2 How should the mrc file look like to get a multiple item import with each having the 952$o entry? Maybe a marcedit forum would be the better address but maybe one of you can help how to set marcedit for converting the above mentioned csv structure into the necessary mrc file syntax?! any hints, links are welcome. Thanks all the best Marcel -- NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone! Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a
Hi You have to join the 952 fields into one...Koha ceate one item per 952 line. However you need more fields there... 952$a, $b and 952$y as minimum I think (a part of the $o and $p)... using MARCedit.. just control and select both fields... mousse: right buttom and click to join... that'sll ;) Hugo 2012/5/2 Marcel Sandow <MarcelSandow@gmx.de>
Dear Koha-List Members!
presently I am working on importing a school library (>10000 records) into koha. I have a csv file with all items. The actual format is:
author, title, full call number(shelf place), barcode
I convert this file via marcedit into mrk, and mrc file.
mrc sample: =LDR 00232nam a2200109Ia 45e0 =008 120501s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$aauthor =245 \\$atitle =952 \\$oFCN(Shelf) =952 \\$pbarcode
Importing this mrc file via 'Stage marc record ...' results in a record with two items, one 952$o item and one 952$p item. I would expect to have one record with one item having the 952$o and the 952$p entry.
Is this the standard behaviour? Are there any settings where I can define which mrc syntax will result in creating a new item? Is there a documentation how the import is handled?
Some of my records have multiple item for one record, they look like:
author, title, full call number(shelf place), barcode1 author, title, full call number(shelf place), barcode2
How should the mrc file look like to get a multiple item import with each having the 952$o entry?
Maybe a marcedit forum would be the better address but maybe one of you can help how to set marcedit for converting the above mentioned csv structure into the necessary mrc file syntax?!
any hints, links are welcome. Thanks
all the best
Marcel -- NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone! Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- *Hugo Agud - Orex Digital * *www.orex.es* * * Director Avenida Sarriá 29 · 08029 Barcelona <http://twitter.com/OrexDigital> :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 33 30 hagud@orex.es · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
Hi Koha List! with your help I have managed to solve the import. The mrc syntax:
=952 \\$oFCN(Shelf)$pbarcode$abranchcode$branchcode$yitemtype
and the "join" marcedit submenu hint was quite helpful. Thanks for your help. I'm not sure if it is the easiest way, I solved the multiple item import by spliting the dataset into a single item dataset and a dataset with the extra copies. The single item dataset is imported. The extra copies are imported by using a record matching rule, in my case using author and title, and setting the import for only importing items if a record is present. Marcel
Hi
You have to join the 952 fields into one...Koha ceate one item per 952 line.
However you need more fields there... 952$a, $b and 952$y as minimum I think (a part of the $o and $p)... using MARCedit.. just control and select both fields... mousse: right buttom and click to join... that'sll ;)
Hugo 2012/5/2 Marcel Sandow <MarcelSandow@gmx.de>
Dear Koha-List Members!
presently I am working on importing a school library (>10000 records) into koha. I have a csv file with all items. The actual format is:
author, title, full call number(shelf place), barcode
I convert this file via marcedit into mrk, and mrc file.
mrc sample: =LDR 00232nam a2200109Ia 45e0 =008 120501s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$aauthor =245 \\$atitle =952 \\$oFCN(Shelf) =952 \\$pbarcode
Importing this mrc file via 'Stage marc record ...' results in a record with two items, one 952$o item and one 952$p item. I would expect to have one record with one item having the 952$o and the 952$p entry.
Is this the standard behaviour? Are there any settings where I can define which mrc syntax will result in creating a new item? Is there a documentation how the import is handled?
Some of my records have multiple item for one record, they look like:
author, title, full call number(shelf place), barcode1 author, title, full call number(shelf place), barcode2
How should the mrc file look like to get a multiple item import with each having the 952$o entry?
Maybe a marcedit forum would be the better address but maybe one of you can help how to set marcedit for converting the above mentioned csv structure into the necessary mrc file syntax?!
any hints, links are welcome. Thanks
all the best
Marcel -- NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone! Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
--
*Hugo Agud - Orex Digital *
*www.orex.es*
* *
Director
Avenida Sarriá 29 · 08029 Barcelona <http://twitter.com/OrexDigital> :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 33 30 hagud@orex.es · http://www.orex.es/
No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
-- Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
Thanks Hugo for your very intelligent tips. Very few people would know this. I am new to MarcEdit and I have been battling this normally for two days where after importing the marc records into KOHA, the 952 fields are scattered all over in different rows and not recognizable as compound entries for a single item. I have successfully used your tips in the MarcEdit utility and now I am ready to deploy Koha for our new library at Masinde Muliro University in Kenya. On 5/2/12, Hugo Agud <hagud@orex.es> wrote:
Hi
You have to join the 952 fields into one...Koha ceate one item per 952 line.
However you need more fields there... 952$a, $b and 952$y as minimum I think (a part of the $o and $p)... using MARCedit.. just control and select both fields... mousse: right buttom and click to join... that'sll ;)
Hugo 2012/5/2 Marcel Sandow <MarcelSandow@gmx.de>
Dear Koha-List Members!
presently I am working on importing a school library (>10000 records) into koha. I have a csv file with all items. The actual format is:
author, title, full call number(shelf place), barcode
I convert this file via marcedit into mrk, and mrc file.
mrc sample: =LDR 00232nam a2200109Ia 45e0 =008 120501s9999\\\\xx\\\\\\\\\\\\000\0\und\d =100 \\$aauthor =245 \\$atitle =952 \\$oFCN(Shelf) =952 \\$pbarcode
Importing this mrc file via 'Stage marc record ...' results in a record with two items, one 952$o item and one 952$p item. I would expect to have one record with one item having the 952$o and the 952$p entry.
Is this the standard behaviour? Are there any settings where I can define which mrc syntax will result in creating a new item? Is there a documentation how the import is handled?
Some of my records have multiple item for one record, they look like:
author, title, full call number(shelf place), barcode1 author, title, full call number(shelf place), barcode2
How should the mrc file look like to get a multiple item import with each having the 952$o entry?
Maybe a marcedit forum would be the better address but maybe one of you can help how to set marcedit for converting the above mentioned csv structure into the necessary mrc file syntax?!
any hints, links are welcome. Thanks
all the best
Marcel -- NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone! Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
--
*Hugo Agud - Orex Digital *
*www.orex.es*
* *
Director
Avenida Sarriá 29 · 08029 Barcelona <http://twitter.com/OrexDigital> :<http://orexsl.blogspot.com>hugoaguda - Tel: 93 539 40 70 Fax: 93 539 33 30 hagud@orex.es · http://www.orex.es/
No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Hugo Agud -
Iddi Juma -
Marcel Sandow