[Koha] Importing data into Koha 3.14

Fri Jun 6 20:40:11 NZST 2014

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   72624790 =035  \\$a(CStRLIN)NYCX1001547S=035  \\$a(NIC)notisAAM7160=035  \\$a(OCoLC)1001547=035  \\$a115761=040  \\$cPU$dNIC$dCStRLIN=050  0\$aCT1886$b.I7=082  \\$a920/.055=245  00$aIran who's who.=260  \\$aTehran,$bEcho of Iran.=300  \\$av.$c21 cm.=362  0\$a1st-   ed.; 1972-=651  \0$aIran$xBiography=905  \\$a19920309120000.0=948  2\$a20100208$bm$dbatch$elts$xdel9XXtxt=950  \\$lREF$aDS271$b.I65$e\Last vol\in Ref\$i01/21/86
  N=995  \\$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 .I65$acornell$p115761Many Thanks,Layale.From: 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
Subject: Re: RE: [Koha] Importing data into Koha 3.14Hello,

=004 115761

=952 \\$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] 
Sent: Friday, June 06, 2014 10:13 AM
To: Layale Bassil
Cc: 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 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 72624790

=035 \\$a(CStRLIN)NYCX1001547S

=035 \\$a(NIC)notisAAM7160

=035 \\$a(OCoLC)1001547

=035 \\$a115761

=040 \\$cPU$dNIC$dCStRLIN

=050 0\$aCT1886$b.I7

=082 vol\in Ref\$i01/21/86 N

=995 \\$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

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
: 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
     : mishravk79 at gmail.com