[Koha] Importing data into Koha 3.14

Thu Jun 12 16:42:01 NZST 2014

Hello Hugo,

Thanks a lot! I already split the files into two files as you are suggesting now. The point is that I have data from many different sources with different file formats and the data is not consistent and I have  to migrate all them into Koha as a Union List. That was easy for the case of “004” but I have files with the case, where the bib and the item are split into two records into the same file and connected using the “001” tag, which means they have the same “001” tag where the difference is in the LDR only where the item/holding has “cy” or “ny” in its LDR. Do you have any suggestion on how can I split such a file? What search can I do to be able to export all items in this case (without having the 004 field)?

One last question if I may, I will be migrating books from different universities, and we might have the same book in more than one university, is there a way to link these same books under one record when searching for the book and have the holdings list all the locations of the book? Or they will always be imported as two different bibs and will be returned in OPAC search as two different results?

Many Thanks for the continuous support,
Best Regards.

From: Hugo Agud [mailto:hagud at orex.es]
Sent: Wednesday, June 11, 2014 11:39 AM
To: Layale Bassil
Cc: Vinod Kumar Mishra; Koha list
Subject: Re: [Koha] Importing data into Koha 3.14

Ok, then I misuderstood the question..

If they're alrady in the same file, you can easly filter the records with 004 field using marcedit, I think is from archive - select selected files.... then you can get a file just with records with 004, that they're the items records
952$a$b$o$p
$ahomebranch
$bholdingbranch
$oitemcallnumber
$pbarcode

2014-06-11 8:14 GMT+02:00 Layale Bassil <lb26 at aub.edu.lb<mailto:lb26 at aub.edu.lb>>:
Hello Hugo,

Thanks a lot for your response. One quick question before I follow your suggestions: how can I separate the biblio marc from the items? They are in the same file. is there any way to separate them and split them into different files or there is no need?

I just want to know how can I import biblio marc into koha before importing the items.

What is “952$abop”? I didn’t get what “bop” is.

Many thanks,
Regards.

From: Hugo Agud [mailto:hagud at orex.es<mailto:hagud at orex.es>]
Sent: Friday, June 06, 2014 11:52 AM
To: Vinod Kumar Mishra
Cc: Layale Bassil; Koha list

Subject: Re: [Koha] Importing data into Koha 3.14

Hi
There is no problem you have separate records from bib & items, Koha imports tool it is able to join both without any problem.....
1st import biblio marc into koha as usuarl
2nd ajust items marc records according the 952 requirements of koha, the most important fields 952$abop, you should map 852 into 952 the besto possible way, i suggest to copy items.001 to some empty firlds of 952 in order to be able to track
3rd change 004 into 001 in items.marc record
4rd create a new matching rule in koha to match the index control-number
5 import marc.items records into koha, assign match record using 001
note:make sure to not replace existing marc record in koha
nota: maje sure to ignore new records (it shouldn't be new records)
nota: configure add items.
If you do wll all these steps, the items will be attached to the right bibliographic record
I hope it helps

2014-06-06 10:40 GMT+02:00 Vinod Kumar Mishra <vinod_librarian at rediffmail.com<mailto:vinod_librarian at rediffmail.com>>:
Hello,

At least second record should show the item details as it contains 952 field but check the location, item type field, better is to enter one record in koha then export it in marc format and view structure of exported record so that you can convert your all records accordingly.

On Fri, 06 Jun 2014 13:11:36 +0530  wrote
> Hello,I really appreciate your prompt response. I fixed the record as you suggested and added the $p number to the 952 field but still when importing, I get a record without items and the second record also imported separate from the first one. Here is the record imported. Please let me know what wrong I am doing and if there are special settings I should select while importing for Koha to map them correctly. =LDR  00762cas a2200277   4500=001  115761=005  20100208102331.0=008  740909u19729999ir\gr\\\\h\\\\0\\\a0eng\u=010  \\$a<file:///\\$a>   72624790 =035  \\$a(CStRLIN)NYCX1001547S=035<file:///\\$a(CStRLIN)NYCX1001547S=035>  \\$a(NIC)notisAAM7160=035<file:///\\$a(NIC)notisAAM7160=035>  \\$a(OCoLC)1001547=035<file:///\\$a(OCoLC)1001547=035>  \\$a115761=040<file:///\\$a115761=040>  \\$cPU$dNIC$dCStRLIN=050<file:///\\$cPU$dNIC$dCStRLIN=050>  0\$aCT1886$b.I7=082  \\$a920/.055=245<file:///\\$a920\.055=245>  00$aIran who's who.=260  \\$aTehran,$bEcho<file:///\\$aTehran,$bEcho> of Iran.=300  \\$av.$c21<file:///\\$av.$c21> cm.=362  0\$a1st-   ed.; 1972-=651  \0$aIran$xBiography=905  \\$a19920309120000.0=948<file:///\\$a19920309120000.0=948>  2\$a20100208$bm$dbatch$elts$xdel9XXtxt=950  \\$lREF$aDS271$b.I65$e\Last<file:///\\$lREF$aDS271$b.I65$e\Last> vol\in Ref\$i01/21/86
  N=995  \\$aHivolm$d20100208=LDR<file:///\\$aHivolm$d20100208=LDR>  00742cy  a22001333  4500=001  151381=004  115761=005  20060220173142.0=008  9301235u\\\\8\\\2\\\uu\\\\\\\\\\=014  1\$aAAM7160CU001=014  0\$9000148016=852  01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector & order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd & (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003=866  \1$a1st-2nd,4th ed. (1972-1974,1993)=952  \\$yCR$colin$2z$z-$bolin,anx$oDS271<file:///\\$yCR$colin$2z$z-$bolin,anx$oDS271> .I65$acornell$p115761Many Thanks,Layale.From: vinod_librarian at rediffmail.com<mailto:vinod_librarian at rediffmail.com> [mailto:vinod_librarian at rediffmail.com<mailto:vinod_librarian at rediffmail.com>]
Sent: Friday, June 06, 2014 10:20 AM
To: Layale Bassil
Cc: koha at lists.katipo.co.nz<mailto:koha at lists.katipo.co.nz>
Subject: Re: RE: [Koha] Importing data into Koha 3.14Hello,

=004 115761
=952 \\$p115761<file:///\\$p115761>

However, few more things need to be add in 952 field for each accession number like location, item type, call number etc all these are possible through marcedit and you have to explore the options given their.

On Fri, 06 Jun 2014 12:46:16 +0530 wrote
> Hello,Thanks a lot for the prompt response. Can you please tell me how the below data should look like? Just to make sure I got you correctly.Many thanks,Regards.From: vinod_librarian at rediffmail.com<mailto:vinod_librarian at rediffmail.com> [mailto:vinod_librarian at rediffmail.com<mailto:vinod_librarian at rediffmail.com>]
Sent: Friday, June 06, 2014 10:13 AM
To: Layale Bassil
Cc: koha at lists.katipo.co.nz<mailto:koha at lists.katipo.co.nz>
Subject: Re: [Koha] Importing data into Koha 3.14Hello,
Simply use find and replace option in marcedit and replace =004 acc. number with =952 \\$p<file:///\\$p> acc. number.

On Fri, 06 Jun 2014 11:43:32 +0530 wrote
>Hello,

I am trying to import data into Koha 3.14 from a .mrc file. I know that in order to insert an item it has to be under tag 952. But my file has a special structure where the items are separated from the bib record and linked to it through tag 004. Below is a sample record with its item. I appreciate any idea that you can give which helps me importing these records into Koha.

=LDR 00713cas a2200265 4500

=001 115761

=005 20100208102331.0

=008 740909u19729999ir\gr\\\\h\\\\0\\\a0eng\u
=010 \\$a<file:///\\$a> 72624790

=035 \\$a(CStRLIN)NYCX1001547S<file:///\\$a(CStRLIN)NYCX1001547S>

=035 \\$a(NIC)notisAAM7160<file:///\\$a(NIC)notisAAM7160>

=035 \\$a(OCoLC)1001547<file:///\\$a(OCoLC)1001547>

=035 \\$a115761<file:///\\$a115761>

=040 \\$cPU$dNIC$dCStRLIN<file:///\\$cPU$dNIC$dCStRLIN>

=050 0\$aCT1886$b.I7
=082 vol\in Ref\$i01/21/86 N

=995 \\$aHivolm$d20100208<file:///\\$aHivolm$d20100208>

=LDR 00675cy a22001213 4500

=001 151381

=004 115761

=005 20060220173142.0

=008 9301235u\\\\8\\\2\\\uu\\\\\\\\\\

=014 1\$aAAM7160CU001

=014 0\$9000148016

=852 01$bolin,anx$hDS271$i.I65$xdbe=c$xCHECK-IN RECORD CREATED$xOrder for 2003 ed. requested via email to Farjam Behnam 02/12/04; Possibly not a continuation order, best to check w/selector & order as needed; Prompted by email from F.Behnam 11/03/04 who is looking for payment, discovered that this title not yet rec'd & (this is my mistake-pc) PO not set up at time of order. Requesting trace be made on shipment for 2003

=866 \1$80$a1st-2nd,4th ed. (1972-1974,1993)

As you can see, tag =004 115761 in the second record is the same as tag =001 115761 in the first record which is used to link those two records.

How can I import such a file into Koha correctly?

Many thanks,

Regards.

_______________________________________________

Koha mailing list http://koha-community.org

Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
http://lists.katipo.co.nz/mailman/listinfo/koha

With regards,
Vinod Kumar Mishra,
Assistant Librarian,
(Library In-Charge)
Biju Patnaik Central Library,
NIT Rourkela,
Mob:91+9439420860
91+6612462103 (O)
email: vinod_librarian at rediffmail.com<mailto:vinod_librarian at rediffmail.com>
: mishravk79 at gmail.comGet<mailto:mishravk79 at gmail.comGet> your own FREE website, FREE domain & FREE mobile app with Company email. Know More >

With regards,
Vinod Kumar Mishra,
Assistant Librarian,
(Library In-Charge)
Biju Patnaik Central Library,
NIT Rourkela,
Mob:91+9439420860
    91+6612462103 (O)
email: vinod_librarian at rediffmail.com<mailto:vinod_librarian at rediffmail.com>
     : mishravk79 at gmail.com<mailto:mishravk79 at gmail.com>
_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz<mailto:Koha at lists.katipo.co.nz>
http://lists.katipo.co.nz/mailman/listinfo/koha

--

Hugo Agud - Orex Digital

www.orex.es<http://www.orex.es>

Director

Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70<tel:93%20539%2040%2070>   hagud at orex.es<mailto:hagud at 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.

--

Hugo Agud - Orex Digital

www.orex.es<http://www.orex.es>

Director

Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70   hagud at orex.es<mailto:hagud at 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.