[Koha] export/import issues

[Alejandro Tiraboschi]

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 at 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-migration
> ??
>
> Thanks for any advise.
>
> -Scott Owen
> Alma Public Schools
>
>
>
>
>
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100811/9d2e3919/attachment-0001.htm