Flood Recovery

Index

Updates

Recovery Stats

Return Rates

Book Recovery

OPAC Status

Causes & Prevention

Flood Photos

Articles

OPAC flood status analysis February 27, 1998 This is the plan and pertinent details of the project to indicate in the OPAC that a book from Green Lower Level likely is in the flood recovery process. I think our staffs have outdone themselves on this one - really nifty approach to a very tricky problem. 1. Systems builds a file of all items (Unicorn item_id) in the P and Z classifications which have Current Location of STACKS. P and Z items excluded from this file will be those with Unicorn Current Locations of: a. Charged Out b. Lost c. Missing d. At Bindery e. Temp LL [charged to temporary booktrucks and shelving in SM] including · Returns since the flood · Dry books from bottom shelves or that otherwise were pulled up from Lower Level during flood recovery · Dry books from the Sort Room 2. File will be sorted by call number with local programs attempting to fix the most common data vagaries which otherwise would affect proper call number sort, including: a. Treating N.S. and N. S. [intervening space] as same string b. Normalizing periods before Cutter numbers c. Normalizing spaces between multiple Cutters 3. With the all-clear from Systems, Jennie’s project people (Loan Division and others from Cataloging) will collect via portable scanners the last barcode on the shelf above the bottom shelf and the first barcode on the top shelf in the next vertical. a. If last/first book does not have barcode, the item will be barcoded (double dumb) on the fly. Record will be added to DB same day b. Pairs of last/first barcodes must remain in ascending order c. Anticipate this scanning project to take one day to collect barcodes; input of double-dumb records, a few hours. Target giving to Systems on Thursday afternoon, March 5. d. Barcode collection must be completed before reshelving on LL begins 4. A local program takes the file of call-number-sorted item_ids (point 1 above) and the file of item_id pairs (item 3 above) and writes an output file of the item _ids that would reside in between the pairs of scanned barcodes. 5. Another program then takes resulting file (bottom shelf item_ids) and passes to an Edit Item API transaction to change in Unicorn the Current Location for each of these item_ids to FLOOD-ITEM. This should be an overnight job. OPAC results: a. In Socrates 2 full display, FLOOD-ITEM will be under Status (just as other Current Locations noted in 1. above display. Library Call Number Copy Location Status GREEN E184.I6 M117 1996 1 STACKS FLOOD-ITEM b. In Socrates 2 brief display, the Library and Current Location will take this form on a single line: Snyder, Gary. Riprap ; and, Cold Mountain poems / by Gary Snyder. 1990. [PS3569 .N88 R5 1990 -- 1 copy in GREEN/FLOOD-ITEM] c. In original Socrates the Current Location does not appear in either full or brief display; however, it will appear FLOOD-ITEM if a Display Circulation command is explicitly given, just as is the case with the other Current Locations noted in 1. above. 6. When reshelving is about to start in the lower level, all books which currently say Temp LL will have barcodes scanned; result will be Current Location of STACKS. 7. Some material will not be identified as FLOOD-ITEM in the OPAC even though they are in the freezer. a. wet items from the Sort Room not otherwise destined for bottom shelf b. wet Folios which were on the bottom shelf but not in call number range for bottom shelf c. Items misshelved on bottom shelf d. Non-bottom shelf items in Faculty Studies or Lockers e. Locked Stack wet items f. Wet materials found elsewhere in Lower Level g. wet items within bottom-shelf range whose call numbers have data problems not corrected by programming in 2. above. 8. When dried books are sent from our project "Recovery Room" to Access Services, their barcodes will be scanned and Current Location will revert to STACKS. Damaged books sent to the Bindery will be charged as usual to Current Location Bindery. 9. Systems projects the OPAC change in place for Sunday, March 8 if JNN meets March 5. 10. Government Documents present different problems (few are barcoded, many don’t have online records for titles) and that analysis is not yet complete. We wish to go ahead with the Green project and then analyze the Government Documents data situation to determine if anything helpful can be done in the OPAC. Catherine M. Tierney Assistant University Librarian for Technical Services Stanford University