Skip to main content
logo

IGeLU 2023 Conference and Developers' Day

September 11–14, 2023

Leuven, Belgium

>> Presentations and Recordings <<

Except for sessions marked as "Physical session only (no live streaming)", all sessions are accessible to physical and virtual participants.

Using an Interactive Excel Workbook and Alma Analytics for Inventory

Monday, September 11, 2023 at 5:00 PM–5:30 PM CEST add to calendar
Room AV 01.12
Session Abstract

Inspired by a Developer Network inventory application, a VBA-based Excel workbook was developed for physical item inventory. This is a hands-on inventory tool for barcoded items to compare Alma shelfmark (call number) and complete title information with a physical item. Although not real-time data access, exported inventory data from an Alma Analytics report can be updated daily. VBA macros allow for customization (e.g.: language, specific error types, etc.) to suit the needs of an institution. The interface can record shelfmark (call number)/title discrepancies between a physical item and Alma record data, display color-coded item status problems to be corrected and provide basic alerts, such as an item that has already been inventoried. A USB flash drive is used in conjunction with a laptop to access easily materials on shelves and to avoid authentication and security issues.

Track

Practical Applications

Products or Areas of Focus
Alma
Analytics
General / Other
Physical/Virtual?

Physical session (+ live streaming with Zoom)

Presenters

[photo]
Thomas E. Lundstrom, Head of Cataloging and Metadata, Embry-Riddle Aeronautical University - Hunt Library
LinkedIn URL
Twitter URL

Moderators

[photo]
Joan Kolarik, Manager, Library Integrated Technology Systems, Drexel University
[photo]
Jiří Pavlík, Project Manager, Czech National Library of Technology

Session Materials

Loading…