Hello! There are records with items in UNIMARC format. Records are imported. Items are not imported. Why is this happening? Are there other options for importing items? Example: ... <datafield tag="995" ind1=" " ind2=" "> <subfield code="5">2001-01-01</subfield> <subfield code="9">1</subfield> <subfield code="a">NF</subfield> <subfield code="b">TPU</subfield> <subfield code="c">TPU</subfield> <subfield code="f">13821000185704</subfield> <subfield code="j">95-1389</subfield> <subfield code="k">95-1389</subfield> <subfield code="q">3700,00</subfield> <subfield code="r">BK</subfield> </datafield> ... Good Luck!
Remove subfield 9 and it will import Παραθέτοντας από "Igor A. Sychev" <igor.a.sychev@gmail.com>:
Hello! There are records with items in UNIMARC format. Records are imported. Items are not imported. Why is this happening? Are there other options for importing items?
Example: ... <datafield tag="995" ind1=" " ind2=" "> <subfield code="5">2001-01-01</subfield> <subfield code="9">1</subfield> <subfield code="a">NF</subfield> <subfield code="b">TPU</subfield> <subfield code="c">TPU</subfield> <subfield code="f">13821000185704</subfield> <subfield code="j">95-1389</subfield> <subfield code="k">95-1389</subfield> <subfield code="q">3700,00</subfield> <subfield code="r">BK</subfield> </datafield> ...
Good Luck! _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Indeed, 995$9 is for Koha internal id of item = itemnumber, the primary key in table items. Le 21/12/2022 à 13:16, gveranis@dataly.gr a écrit :
Remove subfield 9 and it will import
Παραθέτοντας από "Igor A. Sychev" <igor.a.sychev@gmail.com>:
Hello! There are records with items in UNIMARC format. Records are imported. Items are not imported. Why is this happening? Are there other options for importing items?
Example: ... <datafield tag="995" ind1=" " ind2=" "> <subfield code="5">2001-01-01</subfield> <subfield code="9">1</subfield> <subfield code="a">NF</subfield> <subfield code="b">TPU</subfield> <subfield code="c">TPU</subfield> <subfield code="f">13821000185704</subfield> <subfield code="j">95-1389</subfield> <subfield code="k">95-1389</subfield> <subfield code="q">3700,00</subfield> <subfield code="r">BK</subfield> </datafield> ...
Good Luck! _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France
Thanks for the answer. Removed $995 and: root@koha:/usr/share/koha/bin/migration_tools# perl bulkmarcimport.pl -b -file book-test.mrc -c UNIMARC .ERROR: Adding items to bib 1 failed: DBIx::Class::Row::store_column(): No such column 'stocknumber ' on Koha::Schema::Result::Item at /usr/share/koha/lib/Koha/Object.pm line 79 How to fix? пт, 23 дек. 2022 г. в 03:05, Fridolin SOMERS <fridolin.somers@biblibre.com>:
Indeed, 995$9 is for Koha internal id of item = itemnumber, the primary key in table items.
Le 21/12/2022 à 13:16, gveranis@dataly.gr a écrit :
Remove subfield 9 and it will import
Παραθέτοντας από "Igor A. Sychev" <igor.a.sychev@gmail.com>:
Hello! There are records with items in UNIMARC format. Records are imported. Items are not imported. Why is this happening? Are there other options for importing items?
Example: ... <datafield tag="995" ind1=" " ind2=" "> <subfield code="5">2001-01-01</subfield> <subfield code="9">1</subfield> <subfield code="a">NF</subfield> <subfield code="b">TPU</subfield> <subfield code="c">TPU</subfield> <subfield code="f">13821000185704</subfield> <subfield code="j">95-1389</subfield> <subfield code="k">95-1389</subfield> <subfield code="q">3700,00</subfield> <subfield code="r">BK</subfield> </datafield> ...
Good Luck! _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Removed 995$9 and: root@koha:/usr/share/koha/bin/migration_tools# perl bulkmarcimport.pl -b -file book-test.mrc -c UNIMARC .ERROR: Adding items to bib 1 failed: DBIx::Class::Row::store_column(): No such column 'stocknumber ' on Koha::Schema::Result::Item at /usr/share/koha/lib/Koha/Object.pm line 79 How to fix? пт, 30 дек. 2022 г. в 22:05, Igor A. Sychev <igor.a.sychev@gmail.com>:
Thanks for the answer. Removed $995 and: root@koha:/usr/share/koha/bin/migration_tools# perl bulkmarcimport.pl -b -file book-test.mrc -c UNIMARC .ERROR: Adding items to bib 1 failed: DBIx::Class::Row::store_column(): No such column 'stocknumber ' on Koha::Schema::Result::Item at /usr/share/koha/lib/Koha/Object.pm line 79 How to fix?
пт, 23 дек. 2022 г. в 03:05, Fridolin SOMERS <fridolin.somers@biblibre.com
:
Indeed, 995$9 is for Koha internal id of item = itemnumber, the primary key in table items.
Le 21/12/2022 à 13:16, gveranis@dataly.gr a écrit :
Remove subfield 9 and it will import
Παραθέτοντας από "Igor A. Sychev" <igor.a.sychev@gmail.com>:
Hello! There are records with items in UNIMARC format. Records are imported. Items are not imported. Why is this happening? Are there other options for importing items?
Example: ... <datafield tag="995" ind1=" " ind2=" "> <subfield code="5">2001-01-01</subfield> <subfield code="9">1</subfield> <subfield code="a">NF</subfield> <subfield code="b">TPU</subfield> <subfield code="c">TPU</subfield> <subfield code="f">13821000185704</subfield> <subfield code="j">95-1389</subfield> <subfield code="k">95-1389</subfield> <subfield code="q">3700,00</subfield> <subfield code="r">BK</subfield> </datafield> ...
Good Luck! _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
-- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Igor, looking at this I have been wondering: 'stocknumber' This looks like there could be an additional space that should not be there. Have you edited the frameworks in some way maybe? I'd check if that space is in the bibliographic frameworks you created/use for importing. Hope this helps, Katrin On 30.12.22 16:05, Igor A. Sychev wrote:
Thanks for the answer. Removed $995 and: root@koha:/usr/share/koha/bin/migration_tools# perl bulkmarcimport.pl -b -file book-test.mrc -c UNIMARC .ERROR: Adding items to bib 1 failed: DBIx::Class::Row::store_column(): No such column 'stocknumber ' on Koha::Schema::Result::Item at /usr/share/koha/lib/Koha/Object.pm line 79 How to fix?
пт, 23 дек. 2022 г. в 03:05, Fridolin SOMERS <fridolin.somers@biblibre.com>:
Indeed, 995$9 is for Koha internal id of item = itemnumber, the primary key in table items.
Le 21/12/2022 à 13:16, gveranis@dataly.gr a écrit :
Remove subfield 9 and it will import
Παραθέτοντας από "Igor A. Sychev" <igor.a.sychev@gmail.com>:
Hello! There are records with items in UNIMARC format. Records are imported. Items are not imported. Why is this happening? Are there other options for importing items?
Example: ... <datafield tag="995" ind1=" " ind2=" "> <subfield code="5">2001-01-01</subfield> <subfield code="9">1</subfield> <subfield code="a">NF</subfield> <subfield code="b">TPU</subfield> <subfield code="c">TPU</subfield> <subfield code="f">13821000185704</subfield> <subfield code="j">95-1389</subfield> <subfield code="k">95-1389</subfield> <subfield code="q">3700,00</subfield> <subfield code="r">BK</subfield> </datafield> ...
Good Luck! _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha -- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system maintainer 🦄 BibLibre, France
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Thanks for the answer. I didn't change anything. If I delete $995j, then the item are loaded. Next, I wanted to add inventory manually, it is not saved. What else could be the problem? -----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of Katrin Fischer Sent: Sunday, January 1, 2023 10:35 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Import Unimarc records with items Hi Igor, looking at this I have been wondering: 'stocknumber' This looks like there could be an additional space that should not be there. Have you edited the frameworks in some way maybe? I'd check if that space is in the bibliographic frameworks you created/use for importing. Hope this helps, Katrin On 30.12.22 16:05, Igor A. Sychev wrote:
Thanks for the answer. Removed $995 and: root@koha:/usr/share/koha/bin/migration_tools# perl bulkmarcimport.pl -b -file book-test.mrc -c UNIMARC .ERROR: Adding items to bib 1 failed: DBIx::Class::Row::store_column(): No such column 'stocknumber ' on Koha::Schema::Result::Item at /usr/share/koha/lib/Koha/Object.pm line 79 How to fix?
пт, 23 дек. 2022 г. в 03:05, Fridolin SOMERS <fridolin.somers@biblibre.com>:
Indeed, 995$9 is for Koha internal id of item = itemnumber, the primary key in table items.
Remove subfield 9 and it will import
Παραθέτοντας από "Igor A. Sychev" <igor.a.sychev@gmail.com>:
Hello! There are records with items in UNIMARC format. Records are imported. Items are not imported. Why is this happening? Are there other options for importing items?
Example: ... <datafield tag="995" ind1=" " ind2=" "> <subfield code="5">2001-01-01</subfield> <subfield code="9">1</subfield> <subfield code="a">NF</subfield> <subfield code="b">TPU</subfield> <subfield code="c">TPU</subfield> <subfield code="f">13821000185704</subfield> <subfield code="j">95-1389</subfield> <subfield code="k">95-1389</subfield> <subfield code="q">3700,00</subfield> <subfield code="r">BK</subfield> </datafield> ...
Good Luck! _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha -- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system
Le 21/12/2022 à 13:16, gveranis@dataly.gr a écrit : maintainer 🦄 BibLibre, France _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi, try and check the server logs. If new items don't save, there should be an error there that should help us figure out what's going on. Katrin On 03.03.23 03:12, Сычев Игорь Алексеевич wrote:
Thanks for the answer. I didn't change anything. If I delete $995j, then the item are loaded. Next, I wanted to add inventory manually, it is not saved. What else could be the problem?
-----Original Message----- From: Koha <koha-bounces@lists.katipo.co.nz> On Behalf Of Katrin Fischer Sent: Sunday, January 1, 2023 10:35 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Import Unimarc records with items
Hi Igor,
looking at this I have been wondering:
'stocknumber'
This looks like there could be an additional space that should not be there.
Have you edited the frameworks in some way maybe? I'd check if that space is in the bibliographic frameworks you created/use for importing.
Hope this helps,
Katrin
On 30.12.22 16:05, Igor A. Sychev wrote:
Thanks for the answer. Removed $995 and: root@koha:/usr/share/koha/bin/migration_tools# perl bulkmarcimport.pl -b -file book-test.mrc -c UNIMARC .ERROR: Adding items to bib 1 failed: DBIx::Class::Row::store_column(): No such column 'stocknumber ' on Koha::Schema::Result::Item at /usr/share/koha/lib/Koha/Object.pm line 79 How to fix?
пт, 23 дек. 2022 г. в 03:05, Fridolin SOMERS <fridolin.somers@biblibre.com>:
Indeed, 995$9 is for Koha internal id of item = itemnumber, the primary key in table items.
Remove subfield 9 and it will import
Παραθέτοντας από "Igor A. Sychev" <igor.a.sychev@gmail.com>:
Hello! There are records with items in UNIMARC format. Records are imported. Items are not imported. Why is this happening? Are there other options for importing items?
Example: ... <datafield tag="995" ind1=" " ind2=" "> <subfield code="5">2001-01-01</subfield> <subfield code="9">1</subfield> <subfield code="a">NF</subfield> <subfield code="b">TPU</subfield> <subfield code="c">TPU</subfield> <subfield code="f">13821000185704</subfield> <subfield code="j">95-1389</subfield> <subfield code="k">95-1389</subfield> <subfield code="q">3700,00</subfield> <subfield code="r">BK</subfield> </datafield> ...
Good Luck! _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha -- Fridolin SOMERS <fridolin.somers@biblibre.com> Software and system
Le 21/12/2022 à 13:16, gveranis@dataly.gr a écrit : maintainer 🦄 BibLibre, France _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (5)
-
Fridolin SOMERS -
gveranis＠dataly.gr -
Igor A. Sychev -
Katrin Fischer -
Сычев Игорь Алексеевич