*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
a. Columbia POOF Vendor Matrices (CGI41): Displays web version of vendor rule table for POOF loads.
b. Configure LS Tools Vendors (CGI36): Sets up local directory, .pl script, etc. associated with each vendor job.
c. Configure Vendor Connection (CGI31): Used to set up FTP usernames and passwords for access to vendor data files.
d. Cornell POOF Vendor Matrices (CGI41): Displays web version of vendor rule table for POOF and ITSO loads.
fe. Order records from Coutts OASIS Ally (CRN41): Takes WorldCat records chosen by selectors for ordering, loads bibs and creates POs in Voyager.
gf. POOF Analysis (CGI21): Analyzes the orders placed through POOF; looks at the number of instances of a rule's use.
hg. POOF Records from Columbia (CRN44): Prepares POOF order file for Columbia.
ih. POOF Records from Cornell (CRN43): Loads Cornell's POOF records.
j. Poof Records from Local Data: Takes MARC orders records and loads and creates purchase orders for them in Voyager
ki. Replace Columbia POOF Vendor Matrix (PR707): Infrequent manual job - Updates tables for automated ordering for vendors.
lj. Replace Cornell POOF Vendor (PR716) or Fund (PR717) Matrices: Infrequent manual job - Updates tables for automated ordering for vendors.
nk. Replace Harvard POOF Vendor Matrix (Not in LSTools): Infrequent manual job - Updates tables for automated ordering for vendors.
nl. TS Stats Upload to Database (CGI24): The monthly CRON pushes a package of monthly 948 data to “Disc”; in this job, a staff member pushes that same package to the “DB” (database) used by supervisors for creating individual and department statistics reports.
...
Section of scripts that allow for the manual running of a CRON job. Sub-sections include OCLC, General, and Privileged Cron Jobs.
a. 899 NoEx Histogram (PR105): Identifies all codes used in 899 $a for cleanup or comparison against the database of “approved” codes in use.
b. 948 Cleanup Maintenance: Each day we receive a report of incorrectly coded 948 statistics fields. We manually correct those, so that they can then be added to our next statistics extract.
codes in use.
bc. Annex Items that Comprise Multiple MFHDs (Annex Bound-Withs, PR103): Identifies bound-withs so that they can be flipped and empty item records can be created.
dc. Automated Monthly Export of No-Ex Records (CRN07): This script extracts proprietary records for matching in OCLC, without adding the vendor's .mrc record to WorldCat. If it finds a matching record, it adds the OCLC number to the Voyager record.
ed. Cleanup 008 Single Date + Cleanup 008 Multi Date (CRN25 and CRN26): Compares date in 260 or 264 to contents of 008/07-14, corrects content to make fields "congruent."
fe. Daily Annex Flip and Location Report (Not in LSTools): Identifies bound-with's so they can be flipped, and empty item records are created. This cron job is part of Voyager Utilities and runs every weekday.
gf. Daily Technical Services Statistics (CRN33): This CRON job runs daily, and gathers the 948 data from the previous day's records. Each day we receive a report of incorrectly coded 948 statistics fields. We manually correct those, so that they can then be added to our next statistics extract.
gh. E-Book Updates from OCLC (CRN37): Three scripts* for harvesting e-resource bib records lacking call numbers. One searches OCLC using the 035, the second searches OCLC by 776, and the third searches by ISBN. If an OCLC record with call number is found, it is merged with Voyager record and queued for loading into Voyager. * Ebook Updates from OCLC Based on 035, Ebook Updates from OCLC Based on 776, Ebook Updates from OCLC Based on ISBN.
ih. EDI Export from Voyager Server (CRN13): Sends EDI orders to vendors.
ji. Eliminate Redundant OCLC 035 Fields (PR323): Reviews previous week’s records in Voyager, finds malformed or duplicate OCLC 035 fields, removes duplicates and malformed instances, reports out BIBs that require further examination for manual cleanup.
kj. Generate MetaData for RAPID (CRN28, CRN29, CRN99) : Generates tab delimited list of serials or monographs for export to RAPID for Inter-Library Loan use.
lk. Monthly Technical Services Statistics (CRN34): Gathers statistical information for technical services statistics database.
ml. Notify Selectors of Rejected Records (CRN19): Pickup of records for materials not ordered for delivery to selector who placed the order.
nm. OCLC Daily Delete (CRN15): Daily export to OCLC of holdings to be deleted.
on. OCLC Manuscript-Archive Export (CRN12): Weekly export to OCLC of updated manuscript and archive bibs.
po. OCLC Master Number Maintenance (PR336): Checks master number against OCLC and adds fast headings to Voyager record, if found on master but missing in Voyager.
qp. OCLC MFHD Export (Local Holdings RecordsExport CRN10): Choose "3 day old non-serial mfhd export to OCLC" to send local holdings data to OCLC for non-serial records. Choose "3 day old serial mfhd export to OCLC" to send local holdings data to OCLC for serial records.
rq. OCLC System Number Mapping (CRN05): Better known as OCLC mapping job, as it adds the OCLC number to new cataloging from OCLC cross reference reports.
sr. OCLC WorldShare (PR335): Takes WorldShare records from OCLC ftp, searches Voyager for matching records, merges where incoming record is fuller than existing.
ts. Record Extraction to Coutts OASIS (PR705): Extracts added or changed bib records to Coutts for loading into Oasis.
ut. Records Missing OCLC NumbersNumbers (CRN08): Runs harvest of cataloged records that are lacking OCLC numbers. Resubmits monograph records to OCLC; prints out list of serials lacking OCLC numbers, to be reviewed by staff.
vu. Report of Bibs with Duplicate ISBNs (CRN03): Reports out bibs with duplicate ISBNs based on the previous days 005 date.
wv. Send e-mails to book requesters and purge 981, 980$s (CRN20): Harvest requestors’ email from day’s purchase order line items and sends emails to patron informing them that the title has been ordered for them. Removes requestor information from bib found in 981 subfield n.
...
a. Build MARC XML File for GOOGLE Based on List of Barcodes (GGL05): Used when Google metadata is missing or needs replacing.
b. Build MARC XML File for HATHI Based on List of Barcodes (GGL06): Used when HathiTrust metadata is missing or otherwise not useable.
c. Build MARC XML for HATHI - via IA - Kirtas digitized (GGL16): Used when HathiTrust KIRTAS metadata is missing or otherwise not useable.
e. Hathi Metadata Shipment (GGL07): Takes barcode to get BIB, transforms BIBS to MARC XML for shipment to Hathi. Used to correct previously sent data.
f. HathiTrust MultiVol Monograph Extract (GGL09): Reports status of currently held/withdrawn/lost multi-vol items to Hathi (at item level).
g. HathiTrust Serials Title Extract (GGL10): Reports currently held serials to Hathi (at title level).
h. HathiTrust Single Monograph Extract (GGL08): Reports status of currently held/withdrawn/lost single mono items to Hathi (at item level).i. Test a File of Item Barcodes for Valid Checksum: Makes sure barcodes are valid.
...
V. Reports and Extracts Anchor C5 C5
...
a. General Withdrawals Report (PR102): Generates a count by library of items withdrawn over a given time period, typically the prior month.
b. Inconsistent Item Location Report: Creates a serial and non-serial list of MFHDs and items where their location codes do not match.c. ISBN Daily Report ISBN Daily Report (CRN03): Searches for duplicate ISBNs and reports out.
dc. ISBN Extract from Vendor Records (PR108): Extracts ISBNs from a vendor MARC record file. Staff member can then batch search OCLC using these ISBNs.
e. Lost/Missing Reports: Generates a list of titles for books withdrawn due to the item being lost or missing.
f. d. Mfhd Copy Number Clean-Up (PR101): Compare the copy number in the MFHD 852 subfield t with the copy number in the item record. Output contains some routine fixes which are extracted for manual correction.
ge. OCLC LHR Exception Reports (Not in LSTools): Receive email announcements of our local holdings exports. The Exception Reports can be examined on the OCLC Produce Services website. Any holding that was not added will have our Institutional Record Number, i.e., our holdings ID along with a reason why it was not loaded. Staff member must correct each holding in Voyager as appropriate so that the holding will be resent to OCLC. (This is not an LS Tools script.)
hf. OCLC Unresolved Records (Not in LSTools): Receive email announcements of our daily cataloging export results. Any coded as unresolved appear in a MARC file which is downloaded from OCLC Product Services website. Our holdings for these records were not added to WorldCat due to MARC errors. Staff member must manually examine each record in Connexion to correct error(s) and add our holdings to OCLC. (This is not an LS Tools script.)
ig. Report Duplicate Government Documents (PR110): Extracts a list of government document Voyager bibs where the OCLC number and 245 subfield a match.
jh. Combined Report on Bib/Mfhd Suppression (PR104): Looks in Voyager for bibs without at least one active (unsuppressed) MFHD.
...
a. Clean Up a Local MARC File (CLN02): This job can take a .mrc file from a staff member’s LS Tools/Marc folder and clean up whatever issues are chosen from the set menu of common problems.
b. Clean Up Voyager BIB Data (CLN01): This job can take a set of Voyager BIB records and clean up whatever issues are chosen from the set menu of common problems.
c. Report on a Local MARC File (CLN12): Creates a report of any and all of three specific errors found in a .mrc file from a staff member’s LS Tools/Marc folder.
d. Report Voyager BIB Data (CLN11): Creates a report of any and all of three specific errors found in a set of Voyager BIB records.
...
CLAMSS Shelf List Tool (CGI28)Anchor E E
This tool allows catalogers to determine the proper accession number for videos and microforms. Access is given only to those individual catalogers who need to use it.