Brice Stacey home

Generating Rapid Holdings from Voyager ILS

We recently updated our Rapid holdings. I've never done that before and the procedure was undocumented. Someone from Oklahoma State University was kind enough to share their procedure, which was a series of MS Access queries that were broken up to permit large resultsets. Lucky for me, we have a relatively small collection so I rewrote it in Oracle SQL and as a single query.

SELECT
    BIB_TEXT.TITLE_BRIEF AS TITLE
  , BIB_TEXT.ISSN
  , MFHD_ITEM.ITEM_ENUM as HLDGS
  , MFHD_ITEM.CHRON as Second866
  , LOCATION.LOCATION_CODE
  , BIB_TEXT.NETWORK_NUMBER
  , MFHD_MASTER.DISPLAY_CALL_NO
FROM
  BIB_MASTER
  INNER JOIN BIB_TEXT USING(BIB_ID)
  INNER JOIN BIB_MFHD USING(BIB_ID)
  INNER JOIN MFHD_MASTER USING(MFHD_ID)
  INNER JOIN LOCATION USING(LOCATION_ID)
  INNER JOIN MFHD_ITEM USING(MFHD_ID)
WHERE
  BIB_MASTER.SUPPRESS_IN_OPAC='N' AND
  MFHD_MASTER.SUPPRESS_IN_OPAC='N' AND
  BIB_TEXT.BIB_FORMAT Like '%s' AND
  BIB_TEXT.ISSN is not null AND
  (LOCATION.LOCATION_CODE Like 'PERIODICAL' OR
   LOCATION.LOCATION_CODE Like 'ARCHIVES' OR
   LOCATION.LOCATION_CODE Like 'CURPER' OR
   LOCATION.LOCATION_CODE Like 'CURRPER' OR
   LOCATION.LOCATION_CODE Like 'CURREF' OR
   LOCATION.LOCATION_CODE Like 'CURRREF' OR
   LOCATION.LOCATION_CODE Like 'CURSTA' OR
   LOCATION.LOCATION_CODE Like 'CURRSTA' OR
   LOCATION.LOCATION_CODE Like 'MAINSTA' OR
   LOCATION.LOCATION_CODE Like 'MICROFICHE' OR
   LOCATION.LOCATION_CODE Like 'MICROFILM' OR
   LOCATION.LOCATION_CODE Like 'OVERSIZE' OR
   LOCATION.LOCATION_CODE Like 'MICROREF' OR
   LOCATION.LOCATION_CODE Like 'REFERENCE' OR
   LOCATION.LOCATION_CODE Like 'SPECCOLL' OR
   LOCATION.LOCATION_CODE Like 'WWW'
  )
ORDER BY
  ISSN ASC

I run this through a short Java program I wrote. It uses JDBC and Oracle's thin driver to execute the SQL statement and returns the result as a comma-delimited file using the CSVWriter from Java CSV Library. The above SQL will work with any Oracle driver, but will require slight modification to run under MS-Access.