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

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;

4. (optional) Click Save to save the query and give it a name.
5. Click Run in menu bar.
6. Click External Data menu > Export: Excel
7. 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