[Koha] Data migration with multiple items

Amandeep Kansal kansalbpa at gmail.com
Wed May 20 17:51:57 NZST 2009


Hi All,

I importing books data from excel to koha. book data includes both records
and items.
Using marc editor, we can convert excel to marc file.
My problem is that during migration of items. koha import multiple records
of same recode according to no of items.
the format of mark file is:

=LDR  00000nam a2200000Ia 45e0
=008  090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=100  \\$av100a
=245  \\$av245a$cv245c
=250  \\$av250a
=260  \\$av260a$bv260b$cv260c
=300  \\$av300a
=350  \\$av350a
=650  \\$iv650i
=700  \\$av700a
=952  \\$av952a$ov952o$pv952p$tv952t

=LDR  00000nam a2200000Ia 45e0
=008  090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=100  \\$a"Radhakrishnan, P."
=245  \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V."
=250  \\$a2nd ed.
=260  \\$aNew Delhi$bNew Age International$c2000
=300  \\$a672p.%
=700  \\$a"Subramanyan, S.%Raju, V.%"
=952  \\$aCL$o620.042502854 RAD$p0001$t1$yBK

=LDR  00000nam a2200000Ia 45e0
=008  090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=100  \\$a"Radhakrishnan, P."
=245  \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V."
=250  \\$a2nd ed.
=260  \\$aNew Delhi$bNew Age International$c2000
=300  \\$a672p.%
=700  \\$a"Subramanyan, S.%Raju, V.%"
=952  \\$aCL$o620.042502854 RAD$p0002$t2$yBK

=LDR  00000nam a2200000Ia 45e0
=008  090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=100  \\$a"Radhakrishnan, P."
=245  \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V."
=250  \\$a2nd ed.
=260  \\$aNew Delhi$bNew Age International$c2000
=300  \\$a672p.%
=700  \\$a"Subramanyan, S.%Raju, V.%"
=952  \\$aCL$o620.042502854 RAD$p0003$t3$yBK

=LDR  00000nam a2200000Ia 45e0
=008  090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=100  \\$a"Radhakrishnan, P."
=245  \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V."
=250  \\$a2nd ed.
=260  \\$aNew Delhi$bNew Age International$c2000
=300  \\$a672p.%
=700  \\$a"Subramanyan, S.%Raju, V.%"
=952  \\$aCL$o620.042502854 RAD$p0004$t4$yBK

952 tages are used for item fileds.

Expected solution (single record with multiple items) can be obtained by
using following format.

=LDR  00000nam a2200000Ia 45e0
=008  090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=100  \\$a"Radhakrishnan, P."
=245  \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V."
=250  \\$a2nd ed.
=260  \\$aNew Delhi$bNew Age International$c2000
=300  \\$a672p.%
=700  \\$a"Subramanyan, S.%Raju, V.%"
=952  \\$aCL$o620.042502854 RAD$p0001$t1$yBK
=952  \\$aCL$o620.042502854 RAD$p0002$t2$yBK
=952  \\$aCL$o620.042502854 RAD$p0003$t3$yBK
=952  \\$aCL$o620.042502854 RAD$p0004$t4$yBK

with multiple item 952 tags. for this format, how we can convert excel file
in this format. may be it is a join of two excel files, please tell the "how
to" solution for data migration for multiple items.

Thanks and regards
-- 
Er. Amandeep Kansal
B.Tech, RHCE
Network Engineer
Chitkara Educational Trust
Plot No.11-12,Ground Floor,
Dainik Bhasker Building ,Sector 25-D,
Chandigarh- 160014.
http://linuxtosavemoney.blogspot.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090520/fe5a6670/attachment.htm 


More information about the Koha mailing list