Hi Peter, The foreign key is on branchcode, not branchname. Regards, Jonathan
Le mer. 20 mai 2020 à 14:44, Peter Korsten <[email protected]> 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 > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
