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 export all bib and mfhd records in database

    How to export all bib and mfhd records in database

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer  (where xxxdb is the Voyager Database Instance)
    3. Additional Information
    • Product: Voyager
    • Product Version: All

    Question

    How to export all bibliographic and holdings (MFHD) records in database?

    Answer  (where xxxdb is the Voyager Database Instance)

    1. SSH to server as user voyager
    2. /m1/voyager/xxxdb/sbin/Pmarcexport -rG -mR -tALL

    will create an interleaved (Bib-MFHD) file of all bib/mfhd records.

    OR

    1. /m1/voyager/xxxdb/sbin/Pmarcexport -rB -mR -tALL

    will export all bibliographic records only.

     

    Record file will begin with marc.exp and be written to the /rpt directory on the server (Report Files in WebAdmin interface).

    Additional Information

    See the Technical User's Guide for a full explanation of Bulk Export of MARC Records.

    Additional considerations:

    • TIMING: Depends on size of database. Export X number of records (whatever is a reasonable sample for database) and analyze time it takes to export X, applying results to total number of records to estimate time.
    • SPACE: For very large databases, exporting in several ranges of record IDs is recommended (i.e., -mR -tNNNN-NNNN (where NNNN is the bib_id; for example -t1-20000 would export bib_ids 1-20000). As with timing, export X number of records will allow estimate of how large files will be for total number of records.

    • Article last edited: 28-Jun-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to export a single MARC record from Cataloging
      • How to export bib records based on shelving location
    • 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