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

[Katrin Fischer]

Hi,

we had this pop up as a problem on IRC in the last few days too, the
silent fail/missing feedback is quite annoying.

I am not sure if a default would always fix the issue as you might have
files with items from different libraries to import.

I think a good problem report would be the most helpful. Not only
listing the number of items not imported, but also the errors,
especially missing or wrong branchcodes with the wrong branchcodes
listed. That would help with debugging the import files immensely.

As we can undo an incomplete import, it would probably be ok to skip the
items instead of failing. I have no strong opinion on skip vs. fail
immediately.

Hope this helps,

Katrin

On 25.08.23 16:09, Philippe Blouin 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 <http://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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20230826/d477f461/attachment-0001.htm>