[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