[Koha] Importing data into Koha 3.14

Wed Jun 11 18:14:40 NZST 2014

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]
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   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.