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 holdings (mfhd) and corresponding bibliographic records?

    How to bulk delete holdings (mfhd) and corresponding bibliographic records?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
      1. FOR WEBADMIN USERS
    4.  
    • Article Type: Q&A
    • Product: Voyager
    • Product Version: 8.0.0
    • Relevant for Installation Type: Total Care; Dedicated-Direct; Direct; Local

    Question

    How to batch delete mfhds and corresponding bibliographic records via BulkImport?

    Answer

    While the workflow described below is still valid, it may be easier to use Global Data Change to delete all records in a hierarchy.  See:  GDC: Delete All Records in a Hierarchy for steps to using Global Data Change for this process in Voyager 9.0.0 and higher.

    Parameters in Voyager Bulkimport program (Pbulkimport) will delete mfhds/holdings records and the corresponding bib records. Requirements to use these parameters:

    • Interleaved file of bibs and mfhds.
    • Bulk Import with interleaved file and -r parameter (delete holdings) and -x (delete bibs).
    • MFHDs cannot be associated with Items or Purchase Orders (POs).
    • -m and -r flags (load and delete MFHDs, respectively) cannot be used together; -r would be used for deleting MFHD records.
      • The Webadmin import setting "Import file has interleaved bib and holdings records,"  if checked, adds -m parameter to load holding records.  Never combine this with the Delete holdings checkmark.

    Additional Information

    Voyager Technical User's Guide for more information on BulkImport and MarcExport

    1. Use MarcExport (Pmarcexport) to create an interleaved file of bib and mfhds
      1. Use -rG parameter (bib/mfhd group record type parameter).
      2. export mode (-m parameter) can be a file of bibliographic ids,  bib_id range, bibs marked as OK to export or other parameters.
      3. resulting file of bibs and mfhds will be in /m1/voyager/xxxdb/rpt & named marc.exp.yyyymmdd.hhmm.
    2. Create Bibliographic Duplicate Detection Profile and Bulk Import Rule.
      1. System Administration > Cataloging > Bibliographic Duplicate Detection Profile
        1. Duplicate handling = Replace
        2. Field Definitions tab: match on index BBID (bib id).
      2. System Administration > Cataloging > Bulk Import Rules
        1. Select Bib Dupe Profile from step 2.a.
        2. Expected Character Set = MARC21 UTF-8 
        3. Load Bib/Auth only
    3. Import file from step 1.c. using BulkImport (Pbulkimport) with -r parameter (delete mfhds) and -x (delete bibs), and Bulk Import Rule from step 2.b.

    IMPORTANT: See Step 4 before executing this step.
    Pbulkimport -f/m1/voyager/xxxdb/rpt/marc.exp.yyyymmdd.hhmm -i<import_code> -r -x

    1. Ex Libris highly recommends testing 1 record first to make sure that it works before doing the entire file. To do so

    Pbulkimport -f/m1/voyager/xxxdb/rpt/marc.exp.yyyymmdd.hhmm -i<import_code> -b1 -e4 -r -x

     

    1. use the -b and -e parameters in Bulk Import for begin and end record. For example, to test the first 4 records in file
    2. Check import log which will be created in /m1/voyager/xxxdb/rpt with name log.imp.yyyymmdd.hhmm. This will tell you the bib and mfhd that were deleted.
    3. If deletion successful, return to step 2 and execute deletion of full file.

    FOR WEBADMIN USERS

    There are equivalent options in WebAdmin for the command line options described above:

    • MarcExport / Pmarcexport = "Bulk Export MARC Records"
    • -rG = Record Type: Bib-Mfhd Groups
    • BulkImport = "Bulk Import MARC Records"
    • -r parameter = "Delete holdings records matched in import file?"
    • -x parameter = "Delete bib records matched in import file?"
    • -b parameter = "Begin Record"
    • -e parameter = "End Record

     

     

     

     


    • Article last edited: 14-Feb-2017
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to batch delete Social Security Numbers?
      • How to bulk delete mfhd (holding) records from Voyager?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      1. 8.0.0
      2. Batch jobs
      3. contype:kba
      4. Dedicated-Direct
      5. Direct
      6. Local
      7. Prod:Voyager
      8. Total Care
      9. Type:Q&A
    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