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

Question

Batch delete mfhds and corresponding bibliographic records via BulkImport

Answer

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

4. 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.

Additional Information

See GDC: Delete All Records in a Hierarchy for steps to using GDC for this process in 9.0.0 and higher.

• Article last edited: 14-Feb-2017