Scott: some subfields of the 952 tag should be changed and you should add the item type. The line =952 \\$bPINE$dPINE$kF HAN$p74236$r{dollar}11.96$t5$v2010-05-13$u4245 must be (I think) =952 \\$aPINE$bPINE$oF HAN$p74236$v{dollar}11.96$t5$d2010-05-13$u4245$yBOOK See Home> Administration > Koha to MARC mapping in the librarian client. To change the 952's subfields you could use regular expressions in MarcEdit. For example, to change $b for $a 1) open Find/Replace 2) 'Find what:' =952(.*)\$b 3) 'Replace with:' =952$1\$a 'Use regular expressions' must be checked 4) Replace all Cheers, Alejandro Tiraboschi FaMAF-UNC 2010/8/11 SCOTT OWEN <SOWEN@almaschools.net>

Hi all,

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.......

I'm trying to move data from Koha 2.29 to Koha 3.00.06. I am exporting MARC records from Koha 2.29 (Windows) and then trying to import the *.mrc files into Koha 3.00.06. Some fields seem to transfer fine, while others (I believe it's the "holdings data"?) seem to be a bit off.

Example: 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)

******************************************** =LDR 01080nam a2200301D1 4500 =008 080817t\\\\\\\\xxu|||||\||||\00|\0\eng\d =008 890110s1988\\\\maua\\\j\\\\\\000\0\eng\w =010 \\$a488080340 =020 \\$a0763603082 =035 \\$a.b11494293 =082 \\$aF HAN =090 \\$c11$d11 =099 \\$aJ PICTURE BOOK HAN =100 1\$aHandford, Martin. =245 10$aWhere's Waldo now?/$cHandford, Martin. =246 30$aFind Waldo now. =260 \\$aBoston :$bLittle, Brown,$cc1988. =300 \\$a1 v. :$bill. ;$cslj 2. =500 \\$aPreviously published as Find Waldo now. =500 \\$a"First published in Great Britain by "Walker Books Lts. as Where's Wally now?" =650 \0$aPicture puzzles$vJuvenile fiction. =942 \\$cBOOK =952 \\$bPINE$dPINE$kF HAN$p74236$r{dollar}11.96$t5$v2010-05-13$u4245 =952 \\$bPINE$dPINE$kF HAN$p70251$r{dollar}13.99$t1$u252 =952 \\$bPINE$dPINE$kF HAN$p70254$r{dollar}13.99$t4$u255 =952 \\$bPINE$dPINE$kF HAN$p70253$r{dollar}13.99$t3$u254 =952 \\$bPINE$dPINE$kF HAN$p70252$r{dollar}10.99$t2$u253 =952 \\$bPINE$dPINE$kF HAN$p74252$r{dollar}10.96$t6$u4261 ********************************************************

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.

Here is what shows up in koha 3.00.06 after I import the *.mrc file. ************************************************************ Date last seen Not for loan Date acquired Cost, replacement price Koha item type Uniform Resource Identifier Barcode Damaged status Lost status Withdrawn status Current Location Copy number $11.96 PINE 2010-05-13 4245<http://10.1.1.23/cgi-bin/koha/4245> 74236 Pine Ave. Elementary 5 $13.99 PINE 252<http://10.1.1.23/cgi-bin/koha/252> 70251 Pine Ave. Elementary 1 $13.99 PINE 255<http://10.1.1.23/cgi-bin/koha/255> 70254 Pine Ave. Elementary 4 $13.99 PINE 254<http://10.1.1.23/cgi-bin/koha/254> 70253 Pine Ave. Elementary 3 $10.99 PINE 253<http://10.1.1.23/cgi-bin/koha/253> 70252 Pine Ave. Elementary 2 $10.96 PINE 4261<http://10.1.1.23/cgi-bin/koha/4261> 74252 Pine Ave. Elementary 6 *********************************************************************

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?

Am I exporting/importing this data correctly? Is there an easy way to repair/fix the 952 field, or am I going to have to swap/replace cut/paste as per http://koha.org/documentation/manual/3.0/cataloging/item-fields-data-migrati... ??

Thanks for any advise.

-Scott Owen Alma Public Schools

_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha