<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>Hi all,</DIV>
<DIV> </DIV>
<DIV>First, please forgive my ignorance. I'm a tech, not a librarian, so if my terminology is off or if I seem a bit dense, please be patient and use small words.......</DIV>
<DIV> </DIV>
<DIV>I'm trying to move data from Koha 2.29 to Koha 3.00.06.</DIV>
<DIV>I am exporting MARC records from Koha 2.29 (Windows) and then trying to import the *.mrc files into Koha 3.00.06.</DIV>
<DIV>Some fields seem to transfer fine, while others (I believe it's the "holdings data"?) seem to be a bit off.</DIV>
<DIV> </DIV>
<DIV>Example:</DIV>
<DIV>Here is a record for an item exported from Koha 2.29 and then opened with MarcEdit5.1 (after it was made into a *.mrk file)</DIV>
<DIV> </DIV>
<DIV>********************************************</DIV>
<DIV>=LDR 01080nam a2200301D1 4500<BR>=008 080817t\\\\\\\\xxu|||||\||||\00|\0\eng\d<BR>=008 890110s1988\\\\maua\\\j\\\\\\000\0\eng\w<BR>=010 <A href="file://\\$a488080340">\\$a488080340</A><BR>=020 <A href="file://\\$a0763603082">\\$a0763603082</A><BR>=035 <A href="file://\\$a.b11494293">\\$a.b11494293</A><BR>=082 <A href="file://\\$aF">\\$aF</A> HAN<BR>=090 <A href="file://\\$c11$d11">\\$c11$d11</A><BR>=099 <A href="file://\\$aJ">\\$aJ</A> PICTURE BOOK HAN<BR>=100 1\$aHandford, Martin.<BR>=245 10$aWhere's Waldo now?/$cHandford, Martin.<BR>=246 30$aFind Waldo now.<BR>=260 <A href="file://\\$aBoston">\\$aBoston</A> :$bLittle, Brown,$cc1988.<BR>=300 <A href="file://\\$a1">\\$a1</A> v. :$bill. ;$cslj 2.<BR>=500 <A href="file://\\$aPreviously">\\$aPreviously</A> published as Find Waldo now.<BR>=500 <A href='file://\\$a"First'>\\$a"First</A> published in Great Britain by "Walker Books Lts. as Where's Wally now?"<BR>=650 \0$aPicture puzzles$vJuvenile fiction.<BR>=942 <A href="file://\\$cBOOK">\\$cBOOK</A><BR>=952 <A href="file://\\$bPINE$dPINE$kF">\\$bPINE$dPINE$kF</A> HAN$p74236$r{dollar}11.96$t5$v2010-05-13$u4245<BR>=952 <A href="file://\\$bPINE$dPINE$kF">\\$bPINE$dPINE$kF</A> HAN$p70251$r{dollar}13.99$t1$u252<BR>=952 <A href="file://\\$bPINE$dPINE$kF">\\$bPINE$dPINE$kF</A> HAN$p70254$r{dollar}13.99$t4$u255<BR>=952 <A href="file://\\$bPINE$dPINE$kF">\\$bPINE$dPINE$kF</A> HAN$p70253$r{dollar}13.99$t3$u254<BR>=952 <A href="file://\\$bPINE$dPINE$kF">\\$bPINE$dPINE$kF</A> HAN$p70252$r{dollar}10.99$t2$u253<BR>=952 <A href="file://\\$bPINE$dPINE$kF">\\$bPINE$dPINE$kF</A> HAN$p74252$r{dollar}10.96$t6$u4261</DIV>
<DIV> ********************************************************</DIV>
<DIV> </DIV>
<DIV>If this is working as I think, the 952 field represents the 6 copies of the book that we have in our collection at the PINE location. </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Here is what shows up in koha 3.00.06 after I import the *.mrc file.</DIV>
<DIV>************************************************************</DIV>
<DIV>
<TABLE id=items>
<TBODY>
<TR>
<TH>Date last seen </TH>
<TH>Not for loan </TH>
<TH>Date acquired </TH>
<TH>Cost, replacement price </TH>
<TH>Koha item type </TH>
<TH>Uniform Resource Identifier </TH>
<TH>Barcode </TH>
<TH>Damaged status </TH>
<TH>Lost status </TH>
<TH>Withdrawn status </TH>
<TH>Current Location </TH>
<TH>Copy number </TH></TR>
<TR>
<TD>$11.96</TD>
<TD> </TD>
<TD>PINE</TD>
<TD>2010-05-13</TD>
<TD> </TD>
<TD><A href="http://10.1.1.23/cgi-bin/koha/4245">4245</A></TD>
<TD>74236</TD>
<TD> </TD>
<TD> </TD>
<TD> </TD>
<TD>Pine Ave. Elementary</TD>
<TD>5</TD></TR>
<TR>
<TD>$13.99</TD>
<TD> </TD>
<TD>PINE</TD>
<TD> </TD>
<TD> </TD>
<TD><A href="http://10.1.1.23/cgi-bin/koha/252">252</A></TD>
<TD>70251</TD>
<TD> </TD>
<TD> </TD>
<TD> </TD>
<TD>Pine Ave. Elementary</TD>
<TD>1</TD></TR>
<TR>
<TD>$13.99</TD>
<TD> </TD>
<TD>PINE</TD>
<TD> </TD>
<TD> </TD>
<TD><A href="http://10.1.1.23/cgi-bin/koha/255">255</A></TD>
<TD>70254</TD>
<TD> </TD>
<TD> </TD>
<TD> </TD>
<TD>Pine Ave. Elementary</TD>
<TD>4</TD></TR>
<TR>
<TD>$13.99</TD>
<TD> </TD>
<TD>PINE</TD>
<TD> </TD>
<TD> </TD>
<TD><A href="http://10.1.1.23/cgi-bin/koha/254">254</A></TD>
<TD>70253</TD>
<TD> </TD>
<TD> </TD>
<TD> </TD>
<TD>Pine Ave. Elementary</TD>
<TD>3</TD></TR>
<TR>
<TD>$10.99</TD>
<TD> </TD>
<TD>PINE</TD>
<TD> </TD>
<TD> </TD>
<TD><A href="http://10.1.1.23/cgi-bin/koha/253">253</A></TD>
<TD>70252</TD>
<TD> </TD>
<TD> </TD>
<TD> </TD>
<TD>Pine Ave. Elementary</TD>
<TD>2</TD></TR>
<TR>
<TD>$10.96</TD>
<TD> </TD>
<TD>PINE</TD>
<TD> </TD>
<TD> </TD>
<TD><A href="http://10.1.1.23/cgi-bin/koha/4261">4261</A></TD>
<TD>74252</TD>
<TD> </TD>
<TD> </TD>
<TD> </TD>
<TD>Pine Ave. Elementary</TD>
<TD>6</TD></TR></TBODY></TABLE></DIV>
<DIV>*********************************************************************</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>So.....looking at this it seems that I need to swap the "date last seen" and "Cost, replacement price" fields. I also seem to have missing "Koha, Item type" and the "Date acquired" is showing the location...not the date. Lastly, the "Uniform Resource Identifier" link just takes me to a 404 error page... I have no clue what this is supposed to do? </DIV>
<DIV> </DIV>
<DIV>Am I exporting/importing this data correctly?</DIV>
<DIV>Is there an easy way to repair/fix the 952 field, or am I going to have to swap/replace cut/paste as per <A href="http://koha.org/documentation/manual/3.0/cataloging/item-fields-data-migration">http://koha.org/documentation/manual/3.0/cataloging/item-fields-data-migration</A>??</DIV>
<DIV> </DIV>
<DIV>Thanks for any advise.</DIV>
<DIV> </DIV>
<DIV>-Scott Owen</DIV>
<DIV>Alma Public Schools</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>