Bulk import complains about invalid library location

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Bulk import complains about invalid library location

Peter Korsten
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
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: 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 <[hidden email]> 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
> [hidden email]
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________

Koha mailing list  http://koha-community.org
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: 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 <
[hidden email]>:

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

Koha mailing list  http://koha-community.org
[hidden email]
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha