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@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@inLibro.com

inLibro | pour esprit libre | www.inLibro.com
_______________________________________________
Koha-devel mailing list
Koha-devel@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