a & m libraries voyager training bulk export, import, and prebulk processing february 21, 2007...
TRANSCRIPT
A & M Libraries Voyager Training
Bulk Export, Import, andPrebulk Processing
February 21, 2007Co-ming Chan
Oklahoma State University, STW
Bulk Export of MARC Records
• Also called “marcexport”• Allow the export of many MARC records at one
time• Extract records from the Voyager database to a
file in the /rpt directory on the server• You can export one type of record at a time, e.g.
bib, authority, or holdings records, or a combination of bib and holdings
Specify Type of Records
• You can use a variety of different criteria• We have specified
“Export” status in bib recordsA range of bib numbersVoyager location
• In combination with the use of Access reports
Use of Marcexport at OSU
Ftp file to OCLC semi-monthly to set OSU holdings on OCLC records
• Fits our workflow since we do cataloging on Voyager instead of OCLC
• Eliminates the need of going to OCLC to retrieve records and use <update> <send> to set holdings one by one
Voyager Record
OCLC Record
Batch Deletion of Bib Records
Using a range of bib IDs if• Records were batch loaded• Bib IDs of records were in consecutive order
This method of batch deletion was used for updating EBSCO records, because they could not be overlaid.
Each update was approximately 3,500 records.
Using Range of Bib IDsDeletion steps
• Use Marcexport to produce an interleaved file of bibs and mfhds based on range of bib IDs
• Use Bulkimport to load this file back to the Voyager database with rule set for “Replace”
• Since incoming records and the existing records are an exact match, the existing records are replaced and archived on the server in a delete file called deleted.bib.yyy.mmdd.hhmm
• The records in the incoming file were set to be deleted, and therefore they were not added
Using Voyager location & preprocessing with Access Reports
• This method of batch deletion was used to delete ProQuest records, because of change in vendor
• Some of bib records were deleted, and ProQuest mfhds were attached to paper records
• We wanted to delete only ProQuest bib records and ProQuest mfhds
• Bib IDs were not in consecutive order• Deleted approximately 1,700 bib records, and
3,000 mfhds
Using Voyager LocationDeletion steps
• Use Access Reports to generate a list of bib IDs based on ProQuest location
• From the list, create a text file for the bib IDs• Use Marcexport to extract bib records from
Voyager matching the bib IDs in the text file. Did not want to pull mfhds out or non-ProQuest mfhds would also be pulled
• Prebulk the file to create MARC file with mfhds with the PQD location
• Use Bulk Import to delete records
Prebulk
• Allows editing for bib records before importing• Strips out fields or subfields from bib records• We use it to move 856 fields for URLs from bibs
to mfhds, and add public note to mfhds• Creates an interleaved file of bibs and mfhds to
be loaded to Voyager using Bulk Import
MarcEdit for More Customization
• Excludes PrompCat records from the bib records sent to OCLC for holdings attachment
• Avoids paying twice for OCLC holdings since PromptCat service includes the charge of holdings attachment
• Batch edits of bib records converted from SCUA Access database
• Edits URLs of NetLibrary records for changing access method (In test)