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

    How to export a list of ISBNs to Excel using Prepackaged Reports

    • Product: Voyager
    • Product Version: All
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Question

    How can a list of ISBNs for records be exported to Excel from Voyager?

    Answer

    Using Prepackaged Reports linked to the Voyager database via ODBC drivers, follow steps below:

     

    1. Create > Query Design > click Close in Show Table box
    2. Click SQL View in menu bar.
    3. Paste query into view (query only checks for presence or absence of ISBN; adapt and apply additional parameters as needed to suit local data):
    SELECT MFHD_MASTER.DISPLAY_CALL_NO
    , BIB_TEXT.TITLE
    , LOCATION.LOCATION_NAME
    , BIB_TEXT.NETWORK_NUMBER
    ,BIB_TEXT.ISBN
    , BIB_TEXT.BIB_ID
    FROM MFHD_MASTER
    ,LOCATION
    ,BIB_TEXT
    ,BIB_MFHD
    WHERE MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID
    and BIB_TEXT.BIB_ID = BIB_MFHD.BIB_ID
    and BIB_MFHD.MFHD_ID=MFHD_MASTER.MFHD_ID
    and BIB_TEXT.ISBN is not null
    ORDER BY BIB_TEXT.TITLE
    ,BIB_TEXT.BIB_ID
    ,BIB_TEXT.ISBN;
    1. (optional) Click Save to save the query and give it a name.
    2. Click Run in menu bar.
    3. Click External Data menu > Export: Excel
    4. Supply file name & format.

    Additional information

    If ODBC drivers have not been installed and configured, more information on completing this task can be found here.


    • Article last edited: 30-Nov-2016