procedures for bulk loading l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Procedures for Bulk Loading: PowerPoint Presentation
Download Presentation
Procedures for Bulk Loading:

Loading in 2 Seconds...

play fullscreen
1 / 22

Procedures for Bulk Loading: - PowerPoint PPT Presentation


  • 117 Views
  • Uploaded on

Procedures for Bulk Loading:. Authority, Bibliographic, Holdings, and Purchase Order Records into Voyager. Planning. Who needs to be involved? Systems Cataloging Acquisitions Public Services RSC Vendors. Planning. Decide how you want to load the records Add Unconditionally Replace

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Procedures for Bulk Loading:' - seymour


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
procedures for bulk loading

Procedures for Bulk Loading:

Authority, Bibliographic, Holdings, and Purchase Order Records into Voyager

planning
Planning

Who needs to be involved?

  • Systems
  • Cataloging
  • Acquisitions
  • Public Services
  • RSC
  • Vendors
planning3
Planning

Decide how you want to load the records

  • Add Unconditionally
  • Replace
  • Merge
  • Create Mfhds, purchase orders, items?
planning4
Planning

Where will holdings information come from?

  • Vendor
  • Create during Prebulk
  • Create during Bulk Import
  • Create holdings tag with MarcEdit
duplicate detection profiles
Duplicate Detection Profiles

http://www.library.yale.edu/lso/databaseadmin/dbloads/dupdetect.htm

  • Choose how you want the records loaded (add-unconditionally, replace, merge)
  • Define which fields (tags) to use as a match point between incoming records and records in the database
  • For merge profile, indicate which tags should be copied from the existing database record and merged with the incoming record.
bulk import rules
Bulk Import Rules

http://www.library.yale.edu/lso/databaseadmin/dbloads/bulkimport.htm

The loader pulls information from the Bulk Import Rules for the specific load.

Type of records being loaded: bibs, auths, mfhds, P.O.’s, items, or a combination of these

Duplicate Detection profile to use

Item types, call number hierarchy, mapping locations, barcodes, and P.O. information

preprocessing programs
Preprocessing Programs

Decide which preprocessing programs will be needed in order to load, match, and display the records correctly.

  • tagchangernew.jar
  • cjkloadernew.jar
  • tag949buildernew.jar
  • addlocalyale.jar
  • addmfhdindicators.jar
  • addmultiple 866.jar
  • MarcEdit
  • Prebulk
uses for prebulk
Uses for Prebulk

http://www.library.yale.edu/lso/databaseadmin/dbloads/prebulk.htm

  • Remove bad records from file before loading
  • Strip fields from records
  • Create an interleaved file of bibs and mfhds for loading
  • Record count in file
configuration files
Configuration Files

http://www.library.yale.edu/lso/databaseadmin/dbloads/configfile.htm

  • Configuration profiles are used by Prebulk to determine how records are to be preprocessed before being loaded into production by the Bulk Import program.
  • Configuration files are written using the vi editor on the server because they must be tab delimited.
database loads page a work in progress
Database Loads Page(a work in progress)

http://www.library.yale.edu/lso/databaseadmin/dbloads/loads.htm

  • Includes detail for each database load we are currently running
  • More detail on Duplicate Detection profiles, Prebulk, and Bulk Import
  • YUL Tag Table updates notes
  • Database loads schedule
  • More to come!