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

[Philippe Blouin]

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 <http://www.inLibro.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20230825/8d42977b/attachment.htm>