[Koha] Import Unimarc records with items

[Сычев Игорь Алексеевич]

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 at lists.katipo.co.nz> On Behalf Of Katrin Fischer
Sent: Sunday, January 1, 2023 10:35 PM
To: koha at 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 at 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 at 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 at dataly.gr a écrit :
>>> Remove subfield 9 and it will import
>>>
>>> Παραθέτοντας από "Igor A. Sychev" <igor.a.sychev at 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 at lists.katipo.co.nz
>>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>>
>>> _______________________________________________
>>>
>>> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> --
>> Fridolin SOMERS <fridolin.somers at biblibre.com> Software and system 
>> maintainer 🦄
>> BibLibre, France
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________

Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha