NASIG 2013

The current protocol for updating data in an institution’s Ebsco A to Z list requires manipulation of a large data file using Microsoft Excel; modifications, additions, and deletions to custom holdings are accomplished through an upload of a comma delimited text that adheres to the vendor’s specifications. The College of Saint Rose, which tracks approximately 77,000 titles in its A to Z list, has developed a front end interface to this data set using Microsoft Access. This interface allows staff to easily retrieve and modify data through multiple indexes, export changes made to the master list, and produce a file in a format acceptable for upload in Ebsco’s A to Z admin module. While this interface provides a way to simplify a complicated workflow, the inclusion of title information in an Access table allows for additional reporting, such as overlap analysis and unique title reports. Potentially this data can be linked to usage and budget data to provide even richer analysis on both the package and title levels.

Presenter: Peter Koonz, The College of Saint Rose