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