[Koha-devel] Importing items with "foreign" branches fails badly

[Michael Hafen]

I was looking at the Patron import yesterday, and liked that I could
specify the categorycode and branchcode for an import batch.  Maybe
something like that would work for staging and bulkmarcimport.pl, where
there is a (command line) option to override certain fields while
processing records.

On Fri, Aug 25, 2023 at 8:09 AM Philippe Blouin <philippe.blouin at inlibro.com>
wrote:

> Hello!
>
> When importing a marc file where some items homebranch are not matching a
> branchcode in db, the import fails.  Freeze-fail.
>
> Before, it used to just skip those items, but it seems (since 23.05) to
> just fail silently (with a constraint failure in the log, but nothing for
> the user).  Is it our install or it's a known issue?  When running "show
> engin innodb status", I get some row lock.
>
> Looking at the bug list, I found nothing.  There are many ways to fix
> this, and we don't want to head into one to be told "ooh, this should be
> fixed there instead".
>
>    - Upstream
>    https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21272 Maybe
>    there could be an option in staging to overwrite the homebranches that do
>    not correspond?
>    - Just ignore the item, as before.  But at least leave some info about
>    it in the result page.
>    - Fail as soon as it happens.  Do not import and tell the user to
>    correct the data ?
>
> The first option doesn't solve bulkmarcimport.pl :(
>
> Feedbacks would be appreciated.
> --
> Philippe Blouin,
> Directeur de la technologie
>
> Tél.  : (833) 465-4276, poste 230
> philippe.blouin at inLibro.com
> inLibro | pour esprit libre | www.inLibro.com
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>


-- 
Michael Hafen
Washington County School District Technology Department
Systems Analyst
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20230825/e14729cd/attachment.htm>