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:[email protected]] 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 <[email protected]<mailto:[email protected]>>: 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:[email protected]<mailto:[email protected]>] 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 <[email protected]<mailto:[email protected]>>: 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: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] Sent: Friday, June 06, 2014 10:20 AM To: Layale Bassil Cc: [email protected]<mailto:[email protected]> 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: > [email protected]<mailto:[email protected]> > [mailto:[email protected]<mailto:[email protected]>] Sent: Friday, June 06, 2014 10:13 AM To: Layale Bassil Cc: [email protected]<mailto:[email protected]> 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 [email protected]<mailto:[email protected]> 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: [email protected]<mailto:[email protected]> : [email protected]<mailto:[email protected]> 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: [email protected]<mailto:[email protected]> : [email protected]<mailto:[email protected]> 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: [email protected]<mailto:[email protected]> : [email protected]<mailto:[email protected]> _______________________________________________ Koha mailing list http://koha-community.org [email protected]<mailto:[email protected]> 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> [email protected]<mailto:[email protected]> · 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 [email protected]<mailto:[email protected]> · 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 [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
