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 bib records based on shelving location

    How to export bib records based on shelving location

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Voyager

    Description:
    Export bib records based on shelving location

    Resolution:
    1. Generate a list of bib_id numbers for bibs with MFHDs at desired shelving location.
    1.a. Identify needed LOCATION_ID by LOCATION_NAME using LOCATION table.
    1.b. Query MFHD_MASTER and BIB_MFHD for list of bib_id numbers. Example query:
    SELECT BM.BIB_ID
    from BIB_MFHD BM
    , MFHD_MASTER MM
    where BM.MFHD_ID=MM.MFHD_ID
    and MM.LOCATION_ID={desired LOCATION_ID from step 1.a.}
    2. Create a text file of bib_id numbers from resulting list, one bib_id per line.
    3. Place bib_id file on server in /m1/incoming or other directory.
    4. Run Pmarcexport from /m1/voyager/xxxdb/sbin directory.
    Example command for bib_id file called main.txt in /m1/incoming
    Pmarcexport -rB -mM -t/m1/incoming/main.txt


    • Article last edited: 3/6/2015
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to export all bib and mfhd records in database
      • How to extend the Voyager Fiscal Period End Date
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      1. contype:kba
      2. Prod:Voyager
      3. Type:General
    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