[Koha] Bulk import complains about invalid library location

[Peter Korsten]

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 at 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 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
>