MARCcat: MARC Bibliographic records (UXPROD-786)

[UXPROD-1013] Heading - Delete Created: 03/Aug/18  Updated: 16/Sep/20  Resolved: 13/Apr/19

Status: Closed
Project: UX Product
Components: None
Affects versions: None
Fix versions: Q4 2019
Parent: MARCcat: MARC Bibliographic records

Type: New Feature Priority: P2
Reporter: Cate Boerema (Inactive) Assignee: Tiziana Possemato
Resolution: Done Votes: 0
Labels: MARCcat-Bib, cataloging, heading_management, po-sow, q3-2019-developed
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Attachments: PNG File Skærmbillede 2018-10-11 kl. 16.17.33.png    
Issue links:
Defines
defines UXPROD-786 MARCcat: MARC Bibliographic records Closed
Relates
relates to UXPROD-922 Heading - Management (cross-reference... Closed
Requires
requires MODCAT-130 Process to delete 0-headings in a sch... Closed
Epic Link: MARCcat: MARC Bibliographic records
Analysis Estimate: Medium < 5 days
Analysis Estimator: Annalisa Di Sabato
Front End Estimate: Medium < 5 days
Front End Estimator: Christian Chiama
Back End Estimate: Medium < 5 days
Back End Estimator: Christian Chiama
Development Team: @cult
UX Lead: David García Sánchez
Rank: Chalmers (Impl Aut 2019): R5
Rank: Chicago (MVP Sum 2020): R1
Rank: Cornell (Full Sum 2021): R5
Rank: Duke (Full Sum 2021): R1
Rank: 5Colleges (Full Jul 2021): R4
Rank: FLO (MVP Sum 2020): R1
Rank: GBV (MVP Sum 2020): R5
Rank: hbz (TBD): R5
Rank: Lehigh (MVP Summer 2020): R4
Rank: Leipzig (Full TBD): R5
Rank: Leipzig (ERM Aut 2019): R5
Rank: TAMU (MVP Jan 2021): R1

 Description   

The function to delete an heading (for each heading type). The system takes care of all possible constrains, such as: if the heading is used in bibligraphic records, if cross-references are linked to it, if the heading is used in an authorty record, and so on.



 Comments   
Comment by Natascha Owens [ 03/Oct/18 ]

Based on most recent discussions in the MARCcat subgroup, the modification of "headings" will not affect authority records. The group still needs to establish which headings will be visible to users and how headings should be edited. It should be made clear that if a user edits (or deletes) a field within a bib record that is connected to a heading, the heading should not be affected. (UChicago)

Comment by Annalisa Di Sabato [ 01/Mar/19 ]

At the moment all headings in MARCcat will be create behind the scenes. So the user can't delete them from the database.

To avoid to keep wrong and dirty headings in the database, we can use the tool already developed and used in WeCat to clean-up/remove all wrong headings from db (db manteneince operations executed during the night) . This tool will take in account, before deleting the heading, if it is associated to a cross reference, a record (bib or auth) or Name/Title.

Our technician will analyse the tool to verify if it can be used on postgres db, or if it needs some modifications to work there.

Comment by Mirko Fonzo [ 06/Mar/19 ]

We have a set of Oracle Stored Procedures to delete the following Zero Headings:

  • Names
  • Titles
  • Subjects
  • Control Numbers
  • Classifications

These procedures can be definitely ported to Postgres without a big effort. Deletion of Zero Headings for Publishers is not available in WeCat, but it can be implemented.

To be discussed with MARCcat developers if it is better to implement a service which calls such procedures or to call them directly via psql, bash scripts or something else.
The Zero Heading procedures shouldn't be called by the MARCcat end users, but by administration users or as part of maintenance procedures (to be discussed).

Comment by Christian Chiama [ 13/Apr/19 ]

Issue done. Each night run a script to delete heading.

Comment by Tiziana Possemato [ 08/Aug/19 ]

The process to delete, in a scheduled time, the 0-headings (headings not used in bib or authority records, and not used in cross-references) existes: it has to be included in the MARCcat/FOLIO environment: each library needs to be able to define each more useful time. See the issue https://folio-org.atlassian.net/projects/MODCAT/issues/MODCAT-105

Generated at Fri Feb 09 00:12:14 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.