Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    How to export bib records based on shelving location

    • 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