[Koha] Bulk import complains about invalid library location

[Jonathan Druart]

Hi Peter,
The foreign key is on branchcode, not branchname.
Regards,
Jonathan

Le mer. 20 mai 2020 à 14:44, Peter Korsten <pkpublic at severity-one.com> a écrit :
>
> Hi,
>
> First message on this list. My company is installing a Koha installation
> for a customer, and I've been graced with the task. Everything is working,
> pretty well, but when I attempt to import MARC records, Koha won't add
> items, only bibliographic records. From the command line:
>
> # bin/migration_tools/bulkmarcimport.pl -b -file ~ILS-VM-User01/cbom.mrc -d
> deleting biblios
> .Item not added (bib 1, item tag #1, barcode 000020147167): invalid
> homebranch Library
> .Item not added (bib 2, item tag #1, barcode 000020229757): invalid
> homebranch Library
> .Item not added (bib 3, item tag #1, barcode 000020189594): invalid
> homebranch Library
> .Item not added (bib 4, item tag #1, barcode 000020190644): invalid
> homebranch Library
> .Item not added (bib 5, item tag #1, barcode 000020197209): invalid
> homebranch Library
> .Item not added (bib 6, item tag #1, barcode 000020179052): invalid
> homebranch Library
> Item not added (bib 6, item tag #2, barcode 000020189587): invalid
> homebranch Library
> .Item not added (bib 7, item tag #1, barcode 000020176716): invalid
> homebranch Library
> .Item not added (bib 8, item tag #1, barcode 000020180645): invalid
> homebranch Library
> .Item not added (bib 9, item tag #1, barcode 000010080085): invalid
> homebranch Library
> .Item not added (bib 10, item tag #1, barcode 000020064341): invalid
> homebranch Library
> Item not added (bib 10, item tag #2, barcode 000020100155): invalid
> homebranch Library
> .Item not added (bib 11, item tag #1, barcode 000010091302): invalid
> homebranch Library
> .Item not added (bib 12, item tag #1, barcode 12482): invalid homebranch
> System Location
> .Item not added (bib 13, item tag #1, barcode 000020140502): invalid
> homebranch Library
> .Item not added (bib 14, item tag #1, barcode 000020119546): invalid
> homebranch Library
> .Item not added (bib 15, item tag #1, barcode 000020004026): invalid
> homebranch Library
> .Item not added (bib 16, item tag #1, barcode 000010007266): invalid
> homebranch Library
> .Item not added (bib 17, item tag #1, barcode 000020203818): invalid
> homebranch Library
> .Item not added (bib 18, item tag #1, barcode 000020193751): invalid
> homebranch Library
> .Item not added (bib 19, item tag #1, barcode 000020193706): invalid
> homebranch Library
> .Item not added (bib 20, item tag #1, barcode 000020205164): invalid
> homebranch Library
> .Item not added (bib 21, item tag #1, barcode 000020232375): invalid
> homebranch Library
> .Item not added (bib 22, item tag #1, barcode 000020086909): invalid
> homebranch Library
> .Item not added (bib 23, item tag #1, barcode 000010013137): invalid
> homebranch Library
> .Item not added (bib 24, item tag #1, barcode 000020203825): invalid
> homebranch Library
> .Item not added (bib 25, item tag #1, barcode 000010010976): invalid
> homebranch Library
> .Item not added (bib 26, item tag #1, barcode 000010011928): invalid
> homebranch Library
> .Item not added (bib 27, item tag #1, barcode 000020077044): invalid
> homebranch Library
> .Item not added (bib 28, item tag #1, barcode 000010010730): invalid
> homebranch Library
> .Item not added (bib 29, item tag #1, barcode 000020187729): invalid
> homebranch Library
> .Item not added (bib 30, item tag #1, barcode 000020167141): invalid
> homebranch Library
> .Item not added (bib 31, item tag #1, barcode 000010011645): invalid
> homebranch Library
> .Item not added (bib 32, item tag #1, barcode 000020001339): invalid
> homebranch Library
> .Item not added (bib 33, item tag #1, barcode 000020010348): invalid
> homebranch Archives
> .Item not added (bib 34, item tag #1, barcode 000020010386): invalid
> homebranch Archives
> .Item not added (bib 35, item tag #1, barcode 000020017439): invalid
> homebranch Archives
> .Item not added (bib 36, item tag #1, barcode 000020010423): invalid
> homebranch Archives
> .Item not added (bib 37, item tag #1, barcode 000020010416): invalid
> homebranch Archives
> .Item not added (bib 38, item tag #1, barcode 000020010409): invalid
> homebranch Archives
> .Item not added (bib 39, item tag #1, barcode 000020010454): invalid
> homebranch Archives
> .Item not added (bib 40, item tag #1, barcode 000020010447): invalid
> homebranch Archives
> ...
>
> However, these branches exist. In MySQL:
>
> mysql> select branchcode, branchname, marcorgcode from branches;
> +------------+-----------------+-----------------+
> | branchcode | branchname      | marcorgcode     |
> +------------+-----------------+-----------------+
> | ARC        | Archives        | Archives        |
> | LIB        | Library         | Library         |
> | MAIN       | System Location | System Location |
> +------------+-----------------+-----------------+
> 3 rows in set (0.00 sec)
>
> mysql>
>
> So now I'm confused. Google is usually my friend, but not in this case. I
> haven't yet added part of the MARC/MARCXML file (there are over 1200 items
> in there), but I can if necessary.
>
> Thanks,
>
> - Peter
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha