[Koha] Importing data into Koha 3.14

Wed Jun 11 20:39:20 NZST 2014

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>:

> 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 kohanota: 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>:
>
> 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.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
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> 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 · 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 · 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.