Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

b. AuxAmateurs_standing (remote)

c. Casalini (remote)

d. EBSCO

e EBSCOh. Harrassowitz_firm (remote)

ef. Harrassowitz_law (remote)

fg. Harrassowitz_serials (remote)

gh. Harrassowitz_standing (remote)

hi. Hein_Law (remote) *EXCEPTION: This job is done manually by Tech Services at Law.m

j. Nardecchia (remote)

ik. Yankee (remote)

 

...

Anchor
A2
A2
II. General Update

...

Location for more advanced reports and record loads with higher stakes if mistakes happen.

a. Add $h[electronic resource] to Titles: Adds GMD to the 245 where needed.b. Add Donor Names to 902$a: Checks fund code in Bib against fund code table, adds name of donor(s) to 902 field.

cb. Add Donor Plate Links: 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.

dc. Bib Flip 490 to 830 Records: Adds 830 series field to records with only a 490 field for search ability in Voyager.

ed. Enhance Level 3 Encoding Records: Finds lvl3 records in Voyager, uses ISBN to search OCLC for a better record, merges found record with Voyager record to improve encoding level.

fe. Extract Bibs Lacking Fast Subject Headings Update Via OCLC Spreadsheet: This script looks for Voyager records that lack fast subject headings and creates a .mrc file for export to OCLC.

g. Format Serial Solutions Metadata for ERM System: Prepares a file of records of e-journals not part of the Serial Solution loads for import into the electronic resource management system.

h. Format Non-Serial Solutions Metadata for ERM System: Prepares a file of records for non-serials, not part of the Serial Solution loads for import into the electronic resource management system.

...

               f. Hebrew Approvals (880 Flip): Takes vernacular in standard fields and transliterated data in 880 fields and switches them. Records are received via email attachment.

jg. Icelandic BIB Cleanup: 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.

kh. Initial Article and Title Tag Cleanup: Looks at previous month’s cataloging for errors in indicators relating to articles in title fields.

l. Invalid 899 Aggregators in Voyager: Compares 899 fields in Voyager to list on our web site. Reports out any in Voyager not in the list.

mi. Load Serial Solutions e-Book Metadata: Prepares Serial Solutions e-book file for bulk import.

nj. Load Serial Solutions e-Book-Delete Metadata: Prepares Serial Solutions e-book deletion file for bulk import and batch deletion. Produces histogram of 899 counts.

ok. Load Serial Solutions Journal Metadata: Prepares Serial Solutions e-journal file for bulk import and a separate file for batch deletion.

pl. Remove Unnecessary 948 Fields from Voyager: This is a monthly maintenance job to limit the number of 948 fields in individual BIB records.

qm. Replace Tech Services Statistics: This script allows an operator to manually gather the 948 data for a desired date range.

rn. Update Backlog Books: 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.

...

u. Records Missing OCLC Numbers: 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.

v. Remove 981$n Fields from Freshly Loaded ITSO Marc Records: Removes requestor information from bib found in 981 subfield n.w. Report of Bibs with Duplicate ISBNs: Reports out bibs with duplicate ISBNs based on the previous days 005 date.

xw. Send e-Mails to Book Requestorsmails to book requesters and purge 981, 980$s: 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.

 

...

Anchor
C3
C3
III. Direct OCLC Export

...

Various scripts for Google and HathiTrust Voyager extracts. Some are run by LTS staff; some by the project manager for the Google Project and who also serves as liaison to HathiTrust.

a. Build Google Extract List for a Location: Sends a list of candidates to Google for selection.

HathiTrust.

ab. Build MARC XML File for GOOGLE Based on List of Barcodes: Used when Google metadata is missing or needs replacing.

cb. Build MARC XML File for HATHI Based on List of Barcodes: Used when HathiTrust metadata is missing or otherwise not useable.

d. Build MARC XML File of KIRTAS Barcodes Not Found by Google: Used when Kirtas metadata is missing or needs replacing.

e. c.Google Metadata Shipment: Takes barcode to get BIB, transforms BIBS to MARC XML for shipment to Google. Used to correct previously sent data.

fd. Hathi Metadata Shipment: Takes barcode to get BIB, transforms BIBS to MARC XML for shipment to Hathi. Used to correct previously sent data.

ge. HathiTrust MultiVol Monograph Extract: Reports status of currently held/withdrawn/lost multi-vol items to Hathi (at item level).

hf. HathiTrust Serials Title Extract: Reports currently held serials to Hathi (at title level).

ig. HathiTrust Single Monograph Extract: Reports status of currently held/withdrawn/lost single mono items to Hathi (at item level).j. MARC and MARC XML Files for Google Shipment and Hathi: Creates a Voyager Bib file with 903 field with Google shipment date, to reload into Voyager. Creates MARC XML files for Google and Hathi.Hathi (at item level).

hk. Test a File of Item Barcodes for Valid Checksum: Makes sure barcodes are valid.l. Update list of materials Cornell will not supply to Google: Manually transfers a file for pick-up by either Hathi or Google.

 

...

Anchor
C5
C5
V. Reports and Extracts 

...

c. ISBN Extract: Extracts ISBNs from a MARC record file. Staff member can then batch search OCLC using these ISBNs.

d. Less than Full Level Order records: Looks for preliminary “on order” bib records.e. Lost Lost/Missing Reports: Generates a list of titles for books withdrawn due to the item being lost or missing.

fe. Mfhd Copy Number Clean-Up: 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.

gf. OCLC LHR Exception Reports: 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.)

hg. OCLC Unresolved Records: 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.)

ih. Report Duplicate Government Documents: Extracts a list of government document Voyager bibs where the OCLC number and 245 subfield a match.

ji. Suppressed Mfhds with Unsuppressed Bibs: Looks in Voyager for bibs without at least one active (unsuppressed) MFHD.

...