Bulk import complains about invalid library location
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
Hi Peter, The foreign key is on branchcode, not branchname. Regards, Jonathan Le mer. 20 mai 2020 à 14:44, Peter Korsten <pkpublic@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Jonathan, Thanks for the quick reply. That did the trick. However, the marcorgcode field is confusing then, because it implies that this is what's being used to match records. Anyway, it's working now. - Peter Op wo 20 mei 2020 om 15:08 schreef Jonathan Druart < jonathan.druart@bugs.koha-community.org>:
Hi Peter, The foreign key is on branchcode, not branchname. Regards, Jonathan
Le mer. 20 mai 2020 à 14:44, Peter Korsten <pkpublic@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Jonathan Druart -
Peter Korsten