[Koha] export/import issues

SCOTT OWEN SOWEN at almaschools.net
Thu Aug 12 01:25:34 NZST 2010


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 ( file://\$a488080340 )
=020  \\$a0763603082 ( file://\$a0763603082 )
=035  \\$a.b11494293 ( file://\$a.b11494293 )
=082  \\$aF ( file://\$aF ) HAN
=090  \\$c11$d11 ( file://\$c11$d11 )
=099  \\$aJ ( file://\$aJ ) PICTURE BOOK HAN
=100  1\$aHandford, Martin.
=245  10$aWhere's Waldo now?/$cHandford, Martin.
=246  30$aFind Waldo now.
=260  \\$aBoston ( file://\$aBoston ) :$bLittle, Brown,$cc1988.
=300  \\$a1 ( file://\$a1 ) v. :$bill. ;$cslj 2.
=500  \\$aPreviously ( file://\$aPreviously ) published as Find Waldo now.
=500  \\$a"First ( 'file://\$a"First' ) published in Great Britain by "Walker Books Lts. as Where's Wally now?"
=650  \0$aPicture puzzles$vJuvenile fiction.
=942  \\$cBOOK ( file://\$cBOOK )
=952  \\$bPINE$dPINE$kF ( file://\$bPINE$dPINE$kF ) HAN$p74236$r{dollar}11.96$t5$v2010-05-13$u4245
=952  \\$bPINE$dPINE$kF ( file://\$bPINE$dPINE$kF ) HAN$p70251$r{dollar}13.99$t1$u252
=952  \\$bPINE$dPINE$kF ( file://\$bPINE$dPINE$kF ) HAN$p70254$r{dollar}13.99$t4$u255
=952  \\$bPINE$dPINE$kF ( file://\$bPINE$dPINE$kF ) HAN$p70253$r{dollar}13.99$t3$u254
=952  \\$bPINE$dPINE$kF ( file://\$bPINE$dPINE$kF ) HAN$p70252$r{dollar}10.99$t2$u253
=952  \\$bPINE$dPINE$kF ( file://\$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 PINE2010-05-13 4245 ( http://10.1.1.23/cgi-bin/koha/4245 )74236   Pine Ave. Elementary5
$13.99 PINE  252 ( http://10.1.1.23/cgi-bin/koha/252 )70251   Pine Ave. Elementary1
$13.99 PINE  255 ( http://10.1.1.23/cgi-bin/koha/255 )70254   Pine Ave. Elementary4
$13.99 PINE  254 ( http://10.1.1.23/cgi-bin/koha/254 )70253   Pine Ave. Elementary3
$10.99 PINE  253 ( http://10.1.1.23/cgi-bin/koha/253 )70252   Pine Ave. Elementary2
$10.96 PINE  4261 ( http://10.1.1.23/cgi-bin/koha/4261 )74252   Pine Ave. Elementary6
*********************************************************************
 
 
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-migration??
 
Thanks for any advise.
 
-Scott Owen
Alma Public Schools
 
 
 
 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100811/7b58b81f/attachment.htm 


More information about the Koha mailing list