export from 3.01 --> import to 3.20
Hi all, I'm trying to export my collection from an older version of Koha : Koha version:3.01.00.145OS version ('uname -a'):Linux koha3 2.6.26-2-686 #1 SMP Thu Aug 19 03:44:10 UTC 2010 i686 GNU/LinuxPerl interpreter: /usr/bin/perlPerl version:5.010001 and get the MARC file for import into a new version. (3.20.05.000) the export file seems to be OK , and I am exporting "items" (the "don't export items" option is not checked) however... when I try and import the file...they stage fine , the records show, and the import completes, but it seems that no items are added ??? (I've tried to send screen shots....but the list message size won't let me ..... ) According to the export...Items are automagically added unless otherwise "deselected" I'm guessing I may have to modify the export to get the "item" field setup correctly for import into the newer version? Anyone know exactly what needs to be modified / changed ? *************************example export mrc********************************** =LDR 01283nam a2200301 4500 =008 080817t\\\\\\\\xxu|||||\||||\00|\0\eng\d =008 040720s2004\\\\nyu\\\\c\\\\\\000\1\eng =010 \\$a 2003009602 =020 \\$a0689857942 :$c15.95 =020 \\$a9780689857959 (pbk.) :$c5.99 =082 \\$aF HAD =090 \\$c2$d2 =092 \\$aJ Haddix =100 1\$aHaddix, Margaret Peterson. =245 10$aAmong the brave /$cMargaret Peterson Haddix. =260 \\$aNew York :$bSimon & Schuster Books for Young Readers,$cc2004. =300 \\$a229 p. ;$c22 cm. =440 \0$aShadow children ;$vbk. 5. =500 \\$aSequel to: Among the Barons. =520 \\$aIn a society that allows families to have only two children, a group of third-borns tries to save themselves and others like them. =526 \\$aAccelerated Reader - Quiz #78248$b3rd-7th Grade$c5.1$d7.0 =650 \1$aScience fiction. =650 \1$aFuture in literature. =650 \1$aDystopias$vFiction. =942 \\$cBOOK =999 \\$c1$d1 =952 \\$w2010-08-20$p70234$v10.95$r2015-05-12$40$00$6F_HAD$91$bPINE$m3$10$oF HAD$d2010-08-20$t1$70$2ddc$g10.95$yBK$u235$s2015-05-07$l26$aPINE =952 \\$w2012-11-21$p74711$v11.71$r2015-06-05$40$00$6F_HAD$94586$bPINE$10$oF HAD$d2012-11-21$t2$8FIC$70$cFIC$2ddc$g11.71$yBK$s2015-05-01$l20$aPINE **************************************************************** Thanks, -S
Hi Scott, hm, your item information does look alright to me. Did you make sure that the branchcode is exactly PINE in your new installation? I think that could be a possible reason for why your items haven't been added correctly. Hope this helps, Katrin Am 05.11.2015 um 16:09 schrieb Scott Owen:
Hi all,
I'm trying to export my collection from an older version of Koha :
Koha version:3.01.00.145OS version ('uname -a'):Linux koha3 2.6.26-2-686 #1 SMP Thu Aug 19 03:44:10 UTC 2010 i686 GNU/LinuxPerl interpreter: /usr/bin/perlPerl version:5.010001
and get the MARC file for import into a new version. (3.20.05.000)
the export file seems to be OK , and I am exporting "items" (the "don't export items" option is not checked)
however... when I try and import the file...they stage fine , the records show, and the import completes, but it seems that no items are added ???
(I've tried to send screen shots....but the list message size won't let me ..... )
According to the export...Items are automagically added unless otherwise "deselected" I'm guessing I may have to modify the export to get the "item" field setup correctly for import into the newer version?
Anyone know exactly what needs to be modified / changed ?
*************************example export mrc**********************************
=LDR 01283nam a2200301 4500 =008 080817t\\\\\\\\xxu|||||\||||\00|\0\eng\d =008 040720s2004\\\\nyu\\\\c\\\\\\000\1\eng =010 \\$a 2003009602 =020 \\$a0689857942 :$c15.95 =020 \\$a9780689857959 (pbk.) :$c5.99 =082 \\$aF HAD =090 \\$c2$d2 =092 \\$aJ Haddix =100 1\$aHaddix, Margaret Peterson. =245 10$aAmong the brave /$cMargaret Peterson Haddix. =260 \\$aNew York :$bSimon & Schuster Books for Young Readers,$cc2004. =300 \\$a229 p. ;$c22 cm. =440 \0$aShadow children ;$vbk. 5. =500 \\$aSequel to: Among the Barons. =520 \\$aIn a society that allows families to have only two children, a group of third-borns tries to save themselves and others like them. =526 \\$aAccelerated Reader - Quiz #78248$b3rd-7th Grade$c5.1$d7.0 =650 \1$aScience fiction. =650 \1$aFuture in literature. =650 \1$aDystopias$vFiction. =942 \\$cBOOK =999 \\$c1$d1 =952 \\$w2010-08-20$p70234$v10.95$r2015-05-12$40$00$6F_HAD$91$bPINE$m3$10$oF HAD$d2010-08-20$t1$70$2ddc$g10.95$yBK$u235$s2015-05-07$l26$aPINE =952 \\$w2012-11-21$p74711$v11.71$r2015-06-05$40$00$6F_HAD$94586$bPINE$10$oF HAD$d2012-11-21$t2$8FIC$70$cFIC$2ddc$g11.71$yBK$s2015-05-01$l20$aPINE
****************************************************************
Thanks,
-S _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Katrin, Thanks for the response, new : Showing 1 to 1 of 1 Show 102050100All entries FirstPreviousNextLast Search: NameCodeAddressPropertiesIP Pine Ave. Elementary School LibraryPINE old : NameCodeAddressPropertiesIP Pine Ave. ElementaryPINE Library code looks OK to me ?? Could my issue be that the new(er) version of Koha now store items in an item table ? rather than keeping track of items in the 952 field ?? http://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) "As of *3.4.x*, holdings data is no longer stored in a 952 field and that information is introduced in the *items* table only." On Tue, Nov 10, 2015 at 4:53 PM, Katrin Fischer <Katrin.Fischer.83@web.de> wrote:
Hi Scott,
hm, your item information does look alright to me. Did you make sure that the branchcode is exactly PINE in your new installation? I think that could be a possible reason for why your items haven't been added correctly.
Hope this helps,
Katrin
Am 05.11.2015 um 16:09 schrieb Scott Owen:
Hi all,
I'm trying to export my collection from an older version of Koha :
Koha version:3.01.00.145OS version ('uname -a'):Linux koha3 2.6.26-2-686 #1 SMP Thu Aug 19 03:44:10 UTC 2010 i686 GNU/LinuxPerl interpreter: /usr/bin/perlPerl version:5.010001
and get the MARC file for import into a new version. (3.20.05.000)
the export file seems to be OK , and I am exporting "items" (the "don't export items" option is not checked)
however... when I try and import the file...they stage fine , the records show, and the import completes, but it seems that no items are added ???
(I've tried to send screen shots....but the list message size won't let me ..... )
According to the export...Items are automagically added unless otherwise "deselected" I'm guessing I may have to modify the export to get the "item" field setup correctly for import into the newer version?
Anyone know exactly what needs to be modified / changed ?
*************************example export mrc**********************************
=LDR 01283nam a2200301 4500 =008 080817t\\\\\\\\xxu|||||\||||\00|\0\eng\d =008 040720s2004\\\\nyu\\\\c\\\\\\000\1\eng =010 \\$a 2003009602 =020 \\$a0689857942 :$c15.95 =020 \\$a9780689857959 (pbk.) :$c5.99 =082 \\$aF HAD =090 \\$c2$d2 =092 \\$aJ Haddix =100 1\$aHaddix, Margaret Peterson. =245 10$aAmong the brave /$cMargaret Peterson Haddix. =260 \\$aNew York :$bSimon & Schuster Books for Young Readers,$cc2004. =300 \\$a229 p. ;$c22 cm. =440 \0$aShadow children ;$vbk. 5. =500 \\$aSequel to: Among the Barons. =520 \\$aIn a society that allows families to have only two children, a group of third-borns tries to save themselves and others like them. =526 \\$aAccelerated Reader - Quiz #78248$b3rd-7th Grade$c5.1$d7.0 =650 \1$aScience fiction. =650 \1$aFuture in literature. =650 \1$aDystopias$vFiction. =942 \\$cBOOK =999 \\$c1$d1 =952 \\$w2010-08-20$p70234$v10.95$r2015-05-12$40$00$6F_HAD$91$bPINE$m3$10$oF HAD$d2010-08-20$t1$70$2ddc$g10.95$yBK$u235$s2015-05-07$l26$aPINE =952 \\$w2012-11-21$p74711$v11.71$r2015-06-05$40$00$6F_HAD$94586$bPINE$10$oF HAD$d2012-11-21$t2$8FIC$70$cFIC$2ddc$g11.71$yBK$s2015-05-01$l20$aPINE
****************************************************************
Thanks,
-S _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Scott, Koha doesn't store the item information together with the bibliographic data in Koha anymore, but it's still using 952 for importing, exporting and indexing. So that should not be a problem. In your example below it looks like there is a line break after the field number. I am not sure if it's just the formatting in the email, could you check? Also an additional space after the branchcode could make a difference. What do your import results look like after importing? Does it claim items have been imported or does it say 0? Hope this helps, Katrin Am 11.11.2015 um 14:01 schrieb Scott Owen:
Katrin,
Thanks for the response,
new : Showing 1 to 1 of 1 Show 102050100All entries FirstPreviousNextLast Search: NameCodeAddressPropertiesIP Pine Ave. Elementary School LibraryPINE
old : NameCodeAddressPropertiesIP Pine Ave. ElementaryPINE
Library code looks OK to me ??
Could my issue be that the new(er) version of Koha now store items in an item table ? rather than keeping track of items in the 952 field ??
http://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx)
"As of *3.4.x*, holdings data is no longer stored in a 952 field and that information is introduced in the *items* table only."
On Tue, Nov 10, 2015 at 4:53 PM, Katrin Fischer <Katrin.Fischer.83@web.de> wrote:
Hi Scott,
hm, your item information does look alright to me. Did you make sure that the branchcode is exactly PINE in your new installation? I think that could be a possible reason for why your items haven't been added correctly.
Hope this helps,
Katrin
Am 05.11.2015 um 16:09 schrieb Scott Owen:
Hi all,
I'm trying to export my collection from an older version of Koha :
Koha version:3.01.00.145OS version ('uname -a'):Linux koha3 2.6.26-2-686 #1 SMP Thu Aug 19 03:44:10 UTC 2010 i686 GNU/LinuxPerl interpreter: /usr/bin/perlPerl version:5.010001
and get the MARC file for import into a new version. (3.20.05.000)
the export file seems to be OK , and I am exporting "items" (the "don't export items" option is not checked)
however... when I try and import the file...they stage fine , the records show, and the import completes, but it seems that no items are added ???
(I've tried to send screen shots....but the list message size won't let me ..... )
According to the export...Items are automagically added unless otherwise "deselected" I'm guessing I may have to modify the export to get the "item" field setup correctly for import into the newer version?
Anyone know exactly what needs to be modified / changed ?
*************************example export mrc**********************************
=LDR 01283nam a2200301 4500 =008 080817t\\\\\\\\xxu|||||\||||\00|\0\eng\d =008 040720s2004\\\\nyu\\\\c\\\\\\000\1\eng =010 \\$a 2003009602 =020 \\$a0689857942 :$c15.95 =020 \\$a9780689857959 (pbk.) :$c5.99 =082 \\$aF HAD =090 \\$c2$d2 =092 \\$aJ Haddix =100 1\$aHaddix, Margaret Peterson. =245 10$aAmong the brave /$cMargaret Peterson Haddix. =260 \\$aNew York :$bSimon & Schuster Books for Young Readers,$cc2004. =300 \\$a229 p. ;$c22 cm. =440 \0$aShadow children ;$vbk. 5. =500 \\$aSequel to: Among the Barons. =520 \\$aIn a society that allows families to have only two children, a group of third-borns tries to save themselves and others like them. =526 \\$aAccelerated Reader - Quiz #78248$b3rd-7th Grade$c5.1$d7.0 =650 \1$aScience fiction. =650 \1$aFuture in literature. =650 \1$aDystopias$vFiction. =942 \\$cBOOK =999 \\$c1$d1 =952 \\$w2010-08-20$p70234$v10.95$r2015-05-12$40$00$6F_HAD$91$bPINE$m3$10$oF HAD$d2010-08-20$t1$70$2ddc$g10.95$yBK$u235$s2015-05-07$l26$aPINE =952 \\$w2012-11-21$p74711$v11.71$r2015-06-05$40$00$6F_HAD$94586$bPINE$10$oF HAD$d2012-11-21$t2$8FIC$70$cFIC$2ddc$g11.71$yBK$s2015-05-01$l20$aPINE
****************************************************************
Thanks,
-S _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Katrin Fischer -
Scott Owen