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@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@rediffmail.com<mailto:vinod_librarian@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@rediffmail.com<mailto:vinod_librarian@rediffmail.com> [mailto:vinod_librarian@rediffmail.com<mailto:vinod_librarian@rediffmail.com>] Sent: Friday, June 06, 2014 10:20 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz<mailto:koha@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@rediffmail.com<mailto:vinod_librarian@rediffmail.com> [mailto:vinod_librarian@rediffmail.com<mailto:vinod_librarian@rediffmail.com>] Sent: Friday, June 06, 2014 10:13 AM To: Layale Bassil Cc: koha@lists.katipo.co.nz<mailto:koha@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@lists.katipo.co.nz<mailto:Koha@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@rediffmail.com<mailto:vinod_librarian@rediffmail.com> : mishravk79@gmail.comGet<mailto:mishravk79@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@rediffmail.com<mailto:vinod_librarian@rediffmail.com> : mishravk79@gmail.comGet<mailto:mishravk79@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@rediffmail.com<mailto:vinod_librarian@rediffmail.com> : mishravk79@gmail.com<mailto:mishravk79@gmail.com> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@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@orex.es<mailto: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.