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

    How to query Voyager for list of print journals for vendor?

    • Article Type: General
    • Product: Voyager

    Description:
    How can we provide a list of print journals in Voyager to another vendor (i.e., Serials Solutions)?

    Resolution:
    Utilizing MS Access in Voyager, you can create a file that contains the titles and ISSNs of print serials. Generate this report from Voyager and send the file to the vendor.

    1. Open Reports.mdb (Reports.mdb must be linked to Voyager database via ODBC)
    2. In Queries, create new query in SQL view.
    3. Add following query to SQL view:
    SELECT BIB_TEXT.ISSN
    , BIB_TEXT.TITLE
    , BIB_TEXT.PUBLISHER
    , LOCATION.LOCATION_NAME
    , GetFieldAll([blob],"866") AS 866
    , GetFieldAll([blob],"853") AS 853
    , GetFieldAll([blob],"863") AS 863
    FROM
    (((BIB_MFHD INNER JOIN BIB_TEXT ON BIB_MFHD.BIB_ID = BIB_TEXT.BIB_ID)
    INNER JOIN MFHD_MASTER ON BIB_MFHD.MFHD_ID = MFHD_MASTER.MFHD_ID)
    INNER JOIN LOCATION ON MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID)
    INNER JOIN MFHDBlob ON MFHD_MASTER.MFHD_ID = MFHDBlob.MFHD_ID
    WHERE (((MFHD_MASTER.SUPPRESS_IN_OPAC)<>'Y') AND ((Mid([bib_format],2,1))='s'));
    4. Click Run.
    5. Export to desired format (Excel, Text file, etc.)


    • Article last edited: 3/5/2015