Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. How to bulk delete mfhd (holding) records from Voyager?

    How to bulk delete mfhd (holding) records from Voyager?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
      1. BulkImport:
      2. MarcExport
      3. Procedure
    • Product: Voyager

    Question

    How to batch delete holdings records from Voyager?

    Answer

    Global Data Change can also be used to easily and safely delete Holding records and their related Items.

    Before you begin, review Technical User's Guide chapter on BulkImport and MarcExport and note the following:

    BulkImport:
    • Parameter (-r) will delete holdings (mfhd) records
    • In order for this to work, you must first have an interleaved file of bibs and mfhds.
    • mfhds cannot have any items attached to them and cannot be attached to a PO. You may mass delete item records using Pick and Scan within the Cataloging or Circulation module.
    MarcExport
    • -rG exports bib-mfhd group in interleaved file
    • -m is mode for identifying records for export; can be by record ID file, range of record IDs, Cataloging location, and other characteristics.
    Procedure

     

    1. Use MarcExport to create the interleaved file of bib and mfhds
      1. cd /m1/voyager/xxxdb/sbin
      2. Pmarcexport -rG -mM -t/m1/incoming/delete.txt to export bib-mfhd records where bib_id is in file called delete.txt which is located in /m1/incoming on the server
    2. Find file of exported records. Will be in /m1/voyager/xxxdb/rpt directory by default and named marc.exp.YYYYMMDD.HHSS
    3. System Administration > Cataloging > Bulk Import Rules > New
    4. Rule Name tab: enter a Rule Code, Rule Name
    5. Rules tab
      1. Choose Bibliographic Duplicate Detection profile that a) is set to Replace and b) is set to match on bib ID (BBID)
      2. Select Owning Library
      3. Expected Character Set = MARC21 UTF-8
    6. Profiles tab > Single MFHD > Load Bib/Auth only (this is in the Rules tab prior to Voyager 8.1.0)
    7. Save Bulk Import Rule.
    8. Test the rule:
      1. cd /m1/voyager/xxxdb/sbin
      2. Pbulkimport -iDELETE -f/m1/voyager/xxxdb/rpt/marc.exp.20130222.1523 -b1 -e2 -r where DELETE is the rule code for the Bulk Import Rule and marc.exp.20130222.1523 is the file of exported records from step 2.
    9. Review the import log in the /m1/voyager/xxxdb/rpt (log.imp.YYYYMMDD.hhmm) to ensure first two mfhds in file were deleted.
    10. If deleted as expected, delete remaining records in file: Pbulkimport -iDELETE -f/m1/voyager/xxxdb/rpt/marc.exp.20130222.1523 -b3 -r

    • Article last edited: 08-Oct-2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to bulk delete holdings (mfhd) and corresponding bibliographic records?
      • How to bulk load MFHDs into the database?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    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