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: koha-bugs@lists.koha-community.org Reporter: adolfo.rodriguez@xercode.es QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com 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.