Skip to main content

Daily Export of New Cataloging and Records To Be Deleted to OCLC

(Updated January 2009)

This program combines the former script for weekly export of new cataloging to OCLC with the monthly batch delete script. It will now run as a daily chron job starting every night at 12:05 am.

 


A. New Cataloging

1. Extract BIB records based on the following criteria:

a. BIB is unsuppressed
b. Record does not contain a 995 field with the text NoEx
c. Item is not a serial (Leader/07 = s) with record lacking the text OCoLC in an 035 field
d. BIB contains a 948 $a with previous day's date (for example, the target date for the job that starts at 12:05 am on May 1, 2008 will be '20080430')
e. This same 948 contains $b with one of the following values: c, f, k, o, s, u, v, x, or z

2. Pre-process the extracted records as follows:

a. Set Leader/05 to n
b. Change all instances of NIC in 040 field to COO
c. Remove 541 and 583 fields, if present

B. Records To Be Deleted

1. Extract all suppressed BIB records with an 005 date reflecting the previous day that meet the following criteria:

a. Record contains Leader/05 = d, OR
b. Record contains at least one 948 $a date for the previous day, with 948 $b = w

2. Discard all extracted records containing: 995 ## $aNoEx

3. Pre-process the extracted records as follows:

a. Set Leader/05 value to d
b. Change all instances of NIC in 040 field to COO

C. Exporting Records and Reports

1. Send combined files to OCLC

2. Report the following:

a. BIB keys that satisfy the either of the criteria in Step B.1. LTS will delete these from Voyager using Strawn software
b. BIB keys for serials lacking OCLC numbers
c. BIB keys for new cataloging (Step A) that lack unsuppressed MFHDs
d. BIB keys for records to be deleted (Step B) that lack suppressed MFHDs