Scope: This procedure explains the process of the pickup and scripted processing of order files from various vendors and our own POOF! system. It includes the methodology of automated vendor selection and the loading of bibliographic records and creation of purchase orders through Voyager's bulk import function.
Contact: Gary Branch
Unit: Batch Processing
Date created: April 01/2017
Date of next review: April 2018
Bulk import profile will discard records that match too closely
Automated orders are processed through a variety of sources: POOF!, Coutts Oasis Ally, Harrassowitz, and others. We attempt to make the processing steps from each source as similar as possible, creating variations only when necessary and customization only when practical. The premise is to be able to add new vendors with a minimum of script adjustments.
- Pick up file from source:
- A POOF file is picked up from a cron job scheduled to run at 8:05 each weekday morning.
- Coutts Ally orders must go through an authorization process to produce a file which is downloaded to an LTS Share space: \\input\vendorRecords\Coutts_Ally That file is then processed by an lstools script. (NB: We are still attempting to get Coutts to automate the authorization and file produce process. When that is accomplished, we will institute a cron job for pickup.)
- Harrassowitz generates a file each day. Titles are selected in OttoEditions. From there we will establish a cron job to process the file. (In Process 4/18)
- Processing of files:
- Both POOF and Coutts Ally orders are processed through a set of rules commonly called the order matrix. Each line depends on a separate rule and the first time a record matches the criteria of the rule, instructions are in place to handle the record appropriately. For example, early in the table, there is a rule that "discards" records which have in the 008 position 28 an f or s for federal or state publications. They are sorted for manual examination as government publications before further processing. Another example of records removed from automated processing are bib records which contain field 981 subfield n REQ: Those records are sorted to a separate file for probable Amazon ordering.
- After initial special exceptions are handled, the country code in the 008 field is examined, and a vendor assigned accordingly.
- Titles for which no vendor is easily automatically assigned according to country code, will be sent to another LTS share space: \\input\vendorFirmOrd\cts\ Depending on which rule applies, the title will be processed as: electronic records,serials, early imprint dates, etc.
- MARC records with data errors are placed in a separate folder for manual processing.
- Harrassowitz files end with the suffix ".24.ord.mrc" generate a Harrassowitz.purchase order.
- In most cases for which a vendor creates a MARC file of ordered titles, bib records and purchase order are generated via a bulk import profile established for that vendor.
- The bulk import profile will discard records that match too closely to existing records. They will be placed in vendor-named discard folders in the cts folder on the LTS share space established for each vendor mentioned above.
- Discarded "duplicates" are based on complete title matches or ISBN or LCCN.
- Discards are manually examined to ensure discarded title is indeed a duplicate.
Next steps: Follow LTS procedure number #117 for firm order final processing.