<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18928"></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV> </DIV>
<DIV>"multiple copies of a book appear as independent records"</DIV>
<DIV> </DIV>
<DIV>This first thing I would do is use MARCedit to tear apart 2 of these independent records from your old system and examine them closely.</DIV>
<DIV>Find out where and how they are different.</DIV>
<DIV>Once you find the difference it my become apparent how to fix the problem.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Here are some rough notes I kept on migrating from Koha 2.29 to 3.xx</DIV>
<DIV>You may need to use much the same process to create the correct 952 field entries.</DIV>
<DIV>(in this case I create a temporary 998 field and use it to rebuild the 952 field.)</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>*************************************************</DIV>
<DIV>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Koha 2.29 export </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">=952<SPAN style="mso-spacerun: yes"> </SPAN>\\$bPINE$d$kF HAR$p70268$r{dollar}12.89$t2$u269</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">=952<SPAN style="mso-spacerun: yes"> </SPAN>\\</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$9 <SPAN style="mso-tab-count: 2"> </SPAN>--- price</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$bPINE <SPAN style="mso-tab-count: 1"> </SPAN>---holding branch<SPAN style="mso-spacerun: yes"> </SPAN></FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$d <SPAN style="mso-tab-count: 2"> </SPAN>-- Date Acquired<SPAN style="mso-spacerun: yes"> </SPAN></FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$kF HAR <SPAN style="mso-tab-count: 1"> </SPAN>-- itemcallnumber</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$p70267 <SPAN style="mso-tab-count: 1"> </SPAN>--- barcode<SPAN style="mso-spacerun: yes"> </SPAN></FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$r <SPAN style="mso-tab-count: 2"> </SPAN>-- replacementprice </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$t1 <SPAN style="mso-tab-count: 2"> </SPAN>--- copy number<SPAN style="mso-spacerun: yes"> </SPAN></FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$u268<SPAN style="mso-tab-count: 2"> </SPAN>--- URI<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN></FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$v <SPAN style="mso-tab-count: 2"> </SPAN>-- dateacces<SPAN style="mso-tab-count: 3"> </SPAN></FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$w <SPAN style="mso-tab-count: 2"> </SPAN>-– replacementpricedate</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">KOHA 3 EXPORT</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">=952<SPAN style="mso-spacerun: yes"> </SPAN>\\$70$kF HAN$p70262$r{dollar}13.99$40$00$911$bPINE$yBOOK$10$u263$dPINE$t2</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">KOHA3<SPAN style="mso-tab-count: 3"> </SPAN>KOHA3 CODE<SPAN style="mso-tab-count: 6"> </SPAN>action on KOHA229</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$7—- 0<SPAN style="mso-tab-count: 2"> </SPAN>Not for loan<SPAN style="mso-tab-count: 4"> </SPAN>--</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$c-- F HAN<SPAN style="mso-tab-count: 2"> </SPAN>Shelving location code<SPAN style="mso-tab-count: 3"> </SPAN>--$k<SPAN style="mso-tab-count: 1"> </SPAN>Copy to $o, rpl w/$c</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$p—- 74255<SPAN style="mso-tab-count: 2"> </SPAN>barcode<SPAN style="mso-tab-count: 5"> </SPAN>--$p<SPAN style="mso-tab-count: 1"> </SPAN>SAME</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$r—- 2010-8-7<SPAN style="mso-tab-count: 1"> </SPAN>Date last seen<SPAN style="mso-tab-count: 4"> </SPAN>--$v<SPAN style="mso-tab-count: 1"> </SPAN>COPY TO $s, rpl w/$r </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$4—- 0<SPAN style="mso-tab-count: 2"> </SPAN>Damaged status<SPAN style="mso-tab-count: 4"> </SPAN>--</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$0—- 0<SPAN style="mso-tab-count: 2"> </SPAN>Withdrawn status<SPAN style="mso-tab-count: 4"> </SPAN>--</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$9—- 12<SPAN style="mso-tab-count: 2"> </SPAN>Koha itemnumber (autogenerated)<SPAN style="mso-tab-count: 1"> </SPAN>--</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$b—- PINE<SPAN style="mso-tab-count: 1"> </SPAN><SPAN style="mso-tab-count: 1"> </SPAN>branchcode<SPAN style="mso-tab-count: 5"> </SPAN>--$b<SPAN style="mso-tab-count: 1"> </SPAN>SAME</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$y—- BOOK<SPAN style="mso-tab-count: 2"> </SPAN>Koha item type<SPAN style="mso-tab-count: 4"> </SPAN>--BK (must match)<SPAN style="mso-tab-count: 2"> </SPAN></FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$1—- 0<SPAN style="mso-tab-count: 2"> </SPAN>Lost status<SPAN style="mso-tab-count: 5"> </SPAN>--</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$u—- 4264<SPAN style="mso-tab-count: 2"> </SPAN>Uniform Resource Identifier<SPAN style="mso-tab-count: 2"> </SPAN>--$u<SPAN style="mso-tab-count: 1"> </SPAN>SAME</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$d—2007-8-17<SPAN style="mso-tab-count: 1"> </SPAN>Date acquired<SPAN style="mso-tab-count: 4"> </SPAN>--$d<SPAN style="mso-spacerun: yes"> </SPAN>DELETE</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$t—- 6<SPAN style="mso-tab-count: 2"> </SPAN>Copy number<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-tab-count: 2"> </SPAN>--$t<SPAN style="mso-tab-count: 1"> </SPAN>SAME</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$o-- F HAN <SPAN style="mso-tab-count: 2"> </SPAN>Koha Full call number<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-tab-count: 2"> </SPAN>--</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">$v–-<SPAN style="mso-spacerun: yes"> </SPAN>cost replacement price<SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-tab-count: 2"> </SPAN>--$r<SPAN style="mso-tab-count: 1"> </SPAN>REPLACE WITH A $v</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">COPY FIELD 952 to 998</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">SWAP FIELDS</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">998$k to 952$o</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">ADD TO EXISTING FIELD</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">SWAP FIELDS</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">998$v COPY TO 952$s</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">ADD TO EXISTING FIELD</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Replace </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">=952(.*)\$k</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">=952$1$c</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">=952(.*)\$r</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">=952$1$v</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">=952(.*)\$s</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">=952$1$r</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">EDIT subfield:</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Field 952 </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Subfield y</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Field data BK</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Replace with BK</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Check—add subfield if not present</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">EDIT subfield:</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Field 952 </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Subfield a</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Field data PINE</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Replace with PINE</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Check—add subfield if not present</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">EDIT subfield:</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Field 952 </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Subfield d</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Field data </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Remove text</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">EDIT subfield:</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Field 952 </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Subfield v</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Field data </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">Remove text </FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">SWAP FIELDS</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">998$r to 952$v</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">ADD TO EXISTING FIELD</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><o:p><FONT face="Courier New"> </FONT></o:p></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">DELETE field 998</FONT></P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New"></FONT> </P>
<P style="MARGIN: 0in 0in 0pt" class=MsoPlainText><FONT face="Courier New">******************************************</FONT></P></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR><BR>>>> Vikram Vincent<vincentvikram@gmail.com> 9/13/2010 12:03 PM >>><BR>Hello!<BR>I am migrating data from a old library system to Koha. Right now<BR>multiple copies of a book appear as independent records.<BR>How do I display them as multiple items in a single record. Something<BR>like {Check_out; item--;Check_in; item++}<BR>I saw that the mrk file record needs to have data with multiple 952$p<BR>values. How do I automate the matching process?<BR>Thanks.<BR>Regards<BR>-- <BR>Vikram Vincent<BR>+919448810822<BR>080 4012 9072<BR>It's 'Free' as in Swatantra.<BR>_______________________________________________<BR>Koha mailing list<BR>Koha@lists.katipo.co.nz<BR><A href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</A><BR><BR></DIV></BODY></HTML>