https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43979
Bug ID: 43979
Summary: Importing a MARC framework silently drops subfields
whose authorised value category does not exist
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: System Administration
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
Target Milestone: ---
When importing a MARC bibliographic framework (CSV or ODS) from
Administration > MARC bibliographic frameworks > Actions > Import, a
subfield whose authorised value category does not exist in the
installation cannot be saved: the insert fails on the
marc_subfield_structure_ibfk_1 foreign key. The error only goes to the
logs:
- If the framework is new, the subfield is just not created.
- If the subfield already existed in the framework, it is deleted: the rows
that are not in the file are removed at the end of the import, and a row
that failed is treated as "not in the file".
In both cases the import is reported as successful and the librarian is sent
to the framework structure page with no warning, so the framework ends up
silently incomplete. The same happens with any other row that fails to be
imported.
This is easy to hit when moving a framework between installations that do
not have the same authorised value categories.
Expected:
- The subfield is imported without the authorised value category (which is
what the foreign key itself does when a category is deleted: ON DELETE SET
NULL).
- A row that fails for any other reason does not delete the existing one.
- The librarian is told which subfields were affected.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/