Staff new items (multiple) MIXED (EXCEL)

Owned by Corinna Baksik
Last updated: Feb 28, 2023



REMEMBER: Only designated staff members are permitted to run jobs. Refer to the matrix at Jobs & Batch Processes to see which staff members are approved to run which jobs.


This import profile is designed for records that include the Harvard Alma 001 MMS ID in the 001 field. No other matching criteria will be evaluated other than 001. 

This profile does nothing to the bib record. 

Input file must be Excel. 


Results:

  • No inventory will be created, unless field 049 is present. (See below for details). 
  • This profile cannot be used to map fields to holdings. 

Sample input file

serialItemsMultiple.xlsx

 Item Creation

  • This profile can be used to add multiple items to an existing holding. If no holding exists for the library/location specific in the item data, one will be added. 
  • Item details:
Input dataItem fieldDefault, if not supplied
n/aStatus"Item in place"
n/aMaterial TypeMIXED MATERIALIf you need a type other than ISSUE or MIXED, contact LTS to create a new profile, or use the Change Physical Items job if you do not need to do this frequently. 
049$bLibrary Code(no item will be produced if left empty)$b and $c must be the first subfields in the 049
049$cLocation Code(no item will be produced if left empty)
049$aBarcodeSystem generated
049$dItem policy97

Must be 2-digit number

Applies only if there is a barcode in 049$b

049$eReceiving datenone

Format must be yyyyMMdd. 

049$fFulfillment notenone
049$pEnum Anone
049$qEnum Bnone
049$rEnum Cnone
049$sChron Inone
049$tChron Jnone
049$uChron Knone
049$nDescriptionnone



Example use case:

  • Your vendor retrieves our bib via z39.50 and updates the record in their system. They then send you a file of updated bibs with the Harvard Alma MMS ID in the 001 field, and item information for serials.Â