Directions for Extracting Gap File Records from your Horizon System

In order to extract a range of gap records you will have to convert the last extract date to Horizon format with the following SQL:

select datediff(dd, '01 Jan 1970', 'XXX')
'XXX' is the date of the last extract (in San Bernardino's case it would be '30 Nov 1998').  This will return a number.

Then you will need to use the following when you run the batch bib export using the  Horizon Catalog module [Select: File > Batch Bib Export]:
 

Screenshot
'XXX' is the number from the previous command.


You don't need to export item information with these gaps records.

Gap File Extraction Instructions

 

Last Updated: May 31, 2000