Hi All,<br><br>I importing books data from excel to koha. book data includes both records and items.<br>Using marc editor, we can convert excel to marc file.<br>My problem is that during migration of items. koha import multiple records of same recode according to no of items.<br>
the format of mark file is:<br><br>=LDR 00000nam a2200000Ia 45e0<br>=008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d<br>=100 \\$av100a<br>=245 \\$av245a$cv245c<br>=250 \\$av250a<br>=260 \\$av260a$bv260b$cv260c<br>=300 \\$av300a<br>
=350 \\$av350a<br>=650 \\$iv650i<br>=700 \\$av700a<br>=952 \\$av952a$ov952o$pv952p$tv952t<br><br>=LDR 00000nam a2200000Ia 45e0<br>=008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d<br>=100 \\$a"Radhakrishnan, P."<br>
=245 \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V."<br>=250 \\$a2nd ed.<br>=260 \\$aNew Delhi$bNew Age International$c2000<br>=300 \\$a672p.%<br>=700 \\$a"Subramanyan, S.%Raju, V.%"<br>
=952 \\$aCL$o620.042502854 RAD$p0001$t1$yBK<br><br>=LDR 00000nam a2200000Ia 45e0<br>=008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d<br>=100 \\$a"Radhakrishnan, P."<br>=245 \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V."<br>
=250 \\$a2nd ed.<br>=260 \\$aNew Delhi$bNew Age International$c2000<br>=300 \\$a672p.%<br>=700 \\$a"Subramanyan, S.%Raju, V.%"<br>=952 \\$aCL$o620.042502854 RAD$p0002$t2$yBK<br><br>=LDR 00000nam a2200000Ia 45e0<br>
=008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d<br>=100 \\$a"Radhakrishnan, P."<br>=245 \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V."<br>=250 \\$a2nd ed.<br>=260 \\$aNew Delhi$bNew Age International$c2000<br>
=300 \\$a672p.%<br>=700 \\$a"Subramanyan, S.%Raju, V.%"<br>=952 \\$aCL$o620.042502854 RAD$p0003$t3$yBK<br><br>=LDR 00000nam a2200000Ia 45e0<br>=008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d<br>=100 \\$a"Radhakrishnan, P."<br>
=245 \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V."<br>=250 \\$a2nd ed.<br>=260 \\$aNew Delhi$bNew Age International$c2000<br>=300 \\$a672p.%<br>=700 \\$a"Subramanyan, S.%Raju, V.%"<br>
=952 \\$aCL$o620.042502854 RAD$p0004$t4$yBK<br>
<br>952 tages are used for item fileds.<br><br>Expected solution (single record with multiple items) can be obtained by using following format.<br><br>=LDR 00000nam a2200000Ia 45e0<br>=008 090519s9999\\\\xx\\\\\\\\\\\\000\0\und\d<br>
=100 \\$a"Radhakrishnan, P."<br>=245 \\$aCAD/CAM/CIM$c"Radhakrishnan, P.,Subramanyan, S.,Raju, V."<br>=250 \\$a2nd ed.<br>=260 \\$aNew Delhi$bNew Age International$c2000<br>=300 \\$a672p.%<br>=700 \\$a"Subramanyan, S.%Raju, V.%"<br>
=952 \\$aCL$o620.042502854 RAD$p0001$t1$yBK<br>=952 \\$aCL$o620.042502854 RAD$p0002$t2$yBK<br>=952 \\$aCL$o620.042502854 RAD$p0003$t3$yBK<br>=952 \\$aCL$o620.042502854 RAD$p0004$t4$yBK<br><br>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.<br>
<br>Thanks and regards<br>-- <br>Er. Amandeep Kansal<br>B.Tech, RHCE<br>Network Engineer<br>Chitkara Educational Trust<br>Plot No.11-12,Ground Floor,<br>Dainik Bhasker Building ,Sector 25-D,<br>Chandigarh- 160014.<br><a href="http://linuxtosavemoney.blogspot.com/">http://linuxtosavemoney.blogspot.com/</a><br>