University of Cincinnati Libraries have a legacy workflow for managing the review and replacement of materials that have been lost, gone missing, or are long overdue (LMLO). Subject selector Librarians make collection development decisions, including whether to replace these materials. Staff in Technical Services have supported this activity by manually running and distributing lists of these materials, annually. Recently, following a dramatic reorganization of the Technical Services unit, as well as pressure from diminishing staff resources, we have investigated automation solutions to support the replacement workflow more efficiently.
Building on technical skills acquired through ongoing development of a new institutional repository, James Van Mil () and Sean Crowe, Electronic Resources Librarian, developed a Ruby gem for interfacing with the Libraries' Innovative Sierra ILS. A web application was built using the functionality of that gem; the application automates the Lost, Missing, Long Overdue workflow with functions that query the Sierra database, build reports, notify Selectors, and integrate with vendors for replacement orders. Reports can be scheduled at custom intervals; the results of the queries are saved to a database and accessible via an attractive web interface built with Ruby on Rails. The presentation will include an overview of the Lost, Missing, Long Overdue workflow, as well as a light, technical overview of the Lost, Missing, Long Overdue reporting application. There will be additional discussion of automation solutions for Acquisitions & Technical Services operations coming under increasing pressure from decreased resources and changing priorities. the presentation will include a discussion of added value achieved with the web application, including title URLs to vendors, account based filtering for selectors by LC and fund, and automated notifications.
This poster is co-authored by James Van Mil, Collections & Electronic Resources Librarian at the University of Cincinnati Libraries, who is unable to attend the conference.