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/

Reply via email to