Scott: some subfields of the 952 tag should be changed and you should add the item type.<div>The line</div><div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;"><span class="Apple-style-span" style="font-size: 13.3333px; ">=952  <a style="color: rgb(0, 0, 204); ">\\$bPINE$dPINE$kF</a> HAN$p74236$r{dollar}11.96$t5$v2010-05-13$u4245</span></span></font></div>

<div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">must be (I think)</span></font></div><div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;"><span class="Apple-style-span" style="font-size: 13.3333px; "><span class="Apple-style-span" style="font-size: 13.3333px; ">=952  <a style="color: rgb(0, 0, 204); ">\\$aPINE$bPINE$oF</a> HAN$p74236$v{dollar}11.96$t5$d2010-05-13$u4245</span>$yBOOK</span></span></font></div>

<div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">See Home&gt; Administration &gt; Koha to MARC mapping in the librarian client. </span></font></div><div>
<font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;"><br>
</span></font></div><div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">To change the 952&#39;s subfields you could use regular expressions in MarcEdit. For example, to change $b for $a </span></font></div>

<div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">1) open Find/Replace</span></font></div><div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">2) &#39;Find what:&#39;       =952(.*)\$b</span></font></div>

<div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">3) &#39;Replace with:&#39;   =952$1\$a</span></font></div><div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">&#39;Use regular expressions&#39; must be checked</span></font></div>

<div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">4) Replace all </span></font></div><div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;"><br>

</span></font></div><div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">Cheers, </span></font></div><div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;"><br>

</span></font></div><div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">Alejandro Tiraboschi</span></font></div><div><font class="Apple-style-span" face="Tahoma"><span class="Apple-style-span" style="border-collapse: collapse;">FaMAF-UNC<br>

</span></font><br><div class="gmail_quote">2010/8/11 SCOTT OWEN <span dir="ltr">&lt;<a href="mailto:SOWEN@almaschools.net">SOWEN@almaschools.net</a>&gt;</span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">




<div style="margin:4px 4px 1px;font:10pt Tahoma">
<div>Hi all,</div>
<div> </div>
<div>First, please forgive my ignorance. I&#39;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&#39;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&#39;s the &quot;holdings data&quot;?) 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>\\$a488080340</a><br>=020  <a>\\$a0763603082</a><br>=035  <a>\\$a.b11494293</a><br>

=082  <a>\\$aF</a> HAN<br>=090  <a>\\$c11$d11</a><br>=099  <a>\\$aJ</a> PICTURE BOOK HAN<br>=100  1\$aHandford, Martin.<br>=245  10$aWhere&#39;s Waldo now?/$cHandford, Martin.<br>=246  30$aFind Waldo now.<br>=260  <a>\\$aBoston</a> :$bLittle, Brown,$cc1988.<br>

=300  <a>\\$a1</a> v. :$bill. ;$cslj 2.<br>=500  <a>\\$aPreviously</a> published as Find Waldo now.<br>=500  <a>\\$a&quot;First</a> published in Great Britain by &quot;Walker Books Lts. as Where&#39;s Wally now?&quot;<br>

=650  \0$aPicture puzzles$vJuvenile fiction.<br>=942  <a>\\$cBOOK</a><br>=952  <a>\\$bPINE$dPINE$kF</a> HAN$p74236$r{dollar}11.96$t5$v2010-05-13$u4245<br>=952  <a>\\$bPINE$dPINE$kF</a> HAN$p70251$r{dollar}13.99$t1$u252<br>

=952  <a>\\$bPINE$dPINE$kF</a> HAN$p70254$r{dollar}13.99$t4$u255<br>=952  <a>\\$bPINE$dPINE$kF</a> HAN$p70253$r{dollar}13.99$t3$u254<br>=952  <a>\\$bPINE$dPINE$kF</a> HAN$p70252$r{dollar}10.99$t2$u253<br>=952  <a>\\$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>
<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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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" target="_blank">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 &quot;date last seen&quot; and &quot;Cost, replacement price&quot; fields. I also seem to have missing &quot;Koha, Item type&quot; and the &quot;Date acquired&quot; is showing the location...not the date. Lastly, the &quot;Uniform Resource Identifier&quot; 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" target="_blank">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></div>
<br>_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br></div>