Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. How to delete items, holdings

    How to delete items, holdings

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description:
    We are in the process of extensive deselection of materials, especially duplicate copies. One of our librarians has been deleting items and just was told today that she should also delete the holding at the same time.

    1. Is there a process to run to identify orphan holdings?
    2. What is the order of the workflow to delete an item? (I presume a total delete would work for a one bib one item situation, leaving no leftover bits.)
    3. I was thinking there was an export holdings for OCLC service but I'm not seeing it at the moment - does OCLC really want a -holdings- list for import to WorldCat?

     

    Resolution:
    1. The following SQL {from the article " 
    Deleting orphaned HOL records (HOL records whose items have been deleted) " (KB 8192-27444)} can be used to get non-deleted HOL records which do not have any items linked to them:

    > s+ abc50
    SQL> select substr (z103_rec_key,6,9) from inl60.z103 where substr (z103_rec_key,1,5) = 'ABC60' minus select Z30_HOL_DOC_NUMBER_X from z30; 

    2. Workflow to delete an item:

    a. bring up the item and click on "HOL links", then "Edit", then (in the HOL record) "Edit text", and "Delete record from server";

    b. back in the item, click on "Delete" (on the far right).

    3. connect with the GUI to ABC60, select Services, Retrieve Catalog records, Export Holdings records (export-02);


    Additional Information/Related Articles
    The item-11 (item deletion) Service accepts a file of item numbers as input.  See article " How to run p_item_11 item deletion for particular sublibraries *MASTER RECORD* " for more information. 

     

     


    • Article last edited: 12-Mar-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to delete groups of files from $alephe_scratch
      • How to delete local catalog template saved in GUI
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved