*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
a. Alexander Street Press (Not in LS Tools): Vendor record load, run from a .pl script in the input/vendor records/Alex Street folder. Collections include e-books, e-videos, e-audio. Files are downloaded from the vendor website, loaded quarterly.
b. BNABloom e-Journals (New (VEL16) and Revised (VEL17)): Formerly BNA e-Journals. Vendor record load, run by Law Tech Services staff. Both new and updated records are downloaded from the vendor's website.
...
t. Skillsoft E-books (BPro VEL12, ITPro VEL11, ENGPro VEL13): Vendor record load for Skillsoft Ebooks, formerly BKS24x7. Records are retrieved via FTP.
u. Skillsoft E-videos (ITProdesktop MSC07, LDC MSC08): Vendor record load for Skillsoft Evideos, formerly BKS24x7. Records are retrieved via FTP.
F. Prepare a Vendor Print Load: Acquisitions bulk import of vendor supplied MARC records with or without purchase order creation via embedded order data. Selection of this button in LS Tools gives a choice of various pre-scripted jobs connecting to a folder on the vendor’s website or locally on a server.Anchor VPRT VPRT
...
g. Chinese Approvals (Not in LS Tools): This is a two-step task. We receive a file of MARC records for Chinese blanket order books that is loaded as "On Order" while the books are in shipment. We then reload the file on arrival, creating a second holdings record. We batch delete the original holdings and do editing as appropriate for Oversize, accompanying material, and multi-volume works.
h. Coutts PDP (VPR08): Loads patron directed print records from Coutts, which were retrieved via FTP.
i. Coutts Approval (VPR09): Extracts ISBNs from Yankee file, searches OCLC, prepares file of best available Bibs, bulk imports them into Voyager.
j j Derex Print (VPR03):
k. Eastview Print (VPR13): Loads acquisitions-level print records from vendor.
...
r.Korean Print(Not in LS Tools): Vendor-supplied records processed manually by inputting staff member.
s. Kozmenko Print (VPR13)
t. Leila (VPR18): Vendor-supplied records are edited using an LS Tools modification job kept in a staff member's LS Tools folder.
u. LC Cairo Arabic Records (VPR31): Vendor load of print records. Files are delivered via email; statistics and local fields are added and records are loaded into Voyager.
v. Lexicon (VPR16): Vendor print load of preliminary records. Files are received via email.
w. MIPP Print (VPR14): Loads preliminary-level vendor records.
x. PanMun (Not in LS Tools): In this manual job, the staff member takes a tab-delimited file of data from the vendor, converts it into MARC records using MarcEdit, and loads it into Voyager.
y. Retta Print (VPR07):
z. Serbica (VPR17): Vendor print load of preliminary records. Files are received via email.
aa. SofiaBooks Print (VPR15): Loads preliminary print ordering records from the vendor. Records are received via email attachment.
...
c. BatchMatch*: Takes less-than-full bibs and sends to OCLC for automated matching with full records, retrieves, bulk imports them into Voyager. First part of process: In LS Tools under "Reports and Extracts/OCLC Batch Records Export." Creates extract that is to be sent to OCLC. Then the BatchMatch script loads the resulting records. *OCLC Batchmatch Monthly by Date Ranges is a cron (CRN38); OCLC Batchmatch by Bib Id Range can be run at any time via Privileged Procedure (PR338).
d. Coutts Shelf Ready (MSC05): Processes and loads records for shelf-ready books, reports out records requiring manual intervention for oversize, multivol, added pieces, etc.
e. General OCLC MARC Selection from a List of ISBNS (MSC09): Takes ISBNs, runs them against the OCLC rule matrix and finds the best available matching record.
f. Marcive (MSC02): Loads Federal Government e-resource records. Creates files of new and existing Marcive records for loading.
...
B. Execute a Privileged Production Procedure: Location for more advanced reports and record loads with higher stakes if mistakes happen.Anchor PRIVPROD PRIVPROD
a. Add Donor Names to 902$a (PR326): Checks fund code in Bib against fund code table, adds name of donor(s) to 902 field.
b. Add Donor Plate Links (Not in LS Tools): Monthly extract of approved invoice line items paid for on endowed gift funds. The fund is linked to a specific donor book plate which has been placed on the web. A link to that plate is placed in the holdings as an 856 field. This job is run from a .pl script.
c. Bib Flip 490 to 830 Records (PR321): Adds 830 series field to records with only a 490 field for search ability in Voyager.
d. Create 856 link for Table of Contents Images (PR707): Scans serial volume tables of contents, uploads .pdf's tagged with the bib id. Adds an 856 for the URL and reloads.
e. Enhance Level 3 Encoding Records(PR324): Finds lvl3 records in Voyager, uses ISBN to search OCLC for a better record, merges found record with Voyager record to improve encoding level.
f. Enhance Voyager Records with Vernacular Characters (PR333): Using the OCLC Search API and the process described in the specification Component: OCLC Record Retrieval we will identify the best possible match to our Voyager record and copy vernacular name and title fields to our record and load back into voyager.
g.Fast Headings Update Via OCLC Spreadsheet (PR714): This script looks for Voyager records that lack fast subject headings and creates a .mrc file for export to OCLC.
h. General Bib field Cleanup (CRN27): This script searches for invalid fields, subfields, and indicators in BIB records, and reports out the errors for manual cleanup.
i. Icelandic BIB Cleanup (Not in LS Tools): This job adds a 710 "Fiske Icelandic Collection" to Icelandic records, and is run from a "modify" job in the LS Tools folder of a staff member.
j. Initial Article and Title Tag Cleanup (PR327): Looks at previous month’s cataloging for errors in indicators relating to articles in title fields.
k. Order Record Enhancements from OCLC (CRN35): Running every Sunday, this job looks at preliminary level records with a date of the past thirty days, searches for a better record in OCLC, and merges it with the Voyager record if found.
l. Serial Solutions e-Books Combined (PR354): Prepares Serial Solutions e-book files for bulk import, prepares Serial Solutions e-book deletion file for bulk import and batch deletion.
m. Serial Solutions Journals Combined (PR344): Prepares Serial Solutions e-journal file for bulk import and a separate file for batch deletion.
n. Update Backlog Books (PR322): Finds “in process” records for desired storage code in Voyager, searches OCLC by ISBN for a better record, merges with Voyager record, and queues for loading into Voyager.
...
B. Cron Jobs for Interaction with OCLC
a. 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.
b. 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;
c. Records with no OCLC numbers (CRN08): Runs harvest of cataloged records from the previous month that are lacking OCLC numbers. Resubmits monograph records to OCLC; prints out list of serials lacking OCLC numbers, to be reviewed by staff.
d. WorldShare Local Holdings Export to OCLC (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.
e. OCLC Manuscript-Archive Export (CRN12): Weekly export to OCLC of updated manuscript and archive bibs.
f. OCLC Daily Delete (CRN15): Daily export to OCLC of holdings to be deleted.
g. OCLC Daily Export (CRN16): Daily export to OCLC.
h. OCLC BatchMatch for Date Ranges (CRN38): Searches for less-than-full bibs within a given date range and sends to OCLC for automated matching with full records, retrieves, bulk imports them into Voyager. First part of process: In LS Tools under "Reports and Extracts/OCLC Batch Records Export." Creates extract that is to be sent to OCLC. Then the BatchMatch script loads the resulting records. Note: OCLC Batchmatch by Bib Id Range can be run at any time via Privileged Procedure (PR338).
i. OCLC WorldShare Update (PR335): Takes WorldShare records from OCLC ftp, searches Voyager for matching records, merges where incoming record is fuller than existing.
...
D. Cron Jobs with General AccessAnchor CRNGEN CRNGEN
a. Report of bibs with duplicate ISBNs (CRN03): Reports out bibs with duplicate ISBNs based on the previous days 005 date.
b. Bib call number maintenance (CRN18)
c. Serial Metadata List for RAPID (CRN28): Generates tab delimited list of serials or monographs for export to RAPID for Inter-Library Loan use/
...
e. Wrapper for CRN29 Rapid Monographs (CRN99): Generates tab delimited list of serials or monographs for export to RAPID for Inter-Library Loan use.
f. Annex boundwith items (PR103): Identifies bound-withs so that they can be flipped and empty item records can be created.
g. Combined report on Bib/Mfhd suppression (PR104): Looks in Voyager for bibs without at least one active (unsuppressed) MFHD.
h. Histogram of 899 with NoEx needing 035 OCoLC (PR105): Identifies all codes used in 899 $a for cleanup or comparison against the database of “approved” codes in use.
i. 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.
...
d. General MFHD field field cleanup (CRN24)
e. Cleanup 008 Single Date (CRN25) and Cleanup 008 Multi Date (CRN26): Compares date in 260 or 264 to contents of 008/07-14, corrects content to make fields "congruent.”
f. General BIB field cleanup (CRN27): This script searches for invalid fields, subfields, and indicators in BIB records, and reports out the errors for manual cleanup.
g. Daily Tech 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.
h. Monthly Tech Services Statistics (CRN34): Gathers statistical information for technical services statistics database.
i. Order record enhancements from OCLC (CRN35): Running every Sunday, this job looks at preliminary level records with a date of the past thirty days, searches for a better record in OCLC, and merges it with the Voyager record if found.
j. 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.
k. Order records from Coutts via Oasis with fund and location separate (CRN41): Takes WorldCat records chosen by selectors for ordering, loads bibs and creates POs in Voyager.
l. Vendor order pickup--Harrassowitz (CRN42)
m. POOF records for Cornell fund and location together (CRN43): Loads Cornell's POOF records.
n. POOF records from Columbia (CRN44): Prepares POOF order file for Columbia.
o. Bib flip 490 to 830 records (PR321): Adds 830 series field to records with only a 490 field for search ability in Voyager.
p. OCLC Master Number Maintenance Project (PR336): Checks master number against OCLC and adds fast headings to Voyager record, if found on master but missing in Voyager.
q. Daily Record Extraction to OASIS (PR705): Extracts added or changed bib records to Coutts for loading into Oasis.
...
F. Execute an Administrative Production ProcedureAnchor ADPROD ADPROD
a. Rank OCLC records returned for an isbn, issn, etc. (CGI01)
b. TS STATS Summary (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.
...
f. Cornell ITSO Vendor Matrix Replacement (PR713): Updates tables for automated ordering for vendors.
g. Fast Headings updates via spreadsheet from OCLC (PR714): This script looks for Voyager records that lack fast subject headings and creates a .mrc file for export to OCLC.
...