IGeLU 2023 Conference and Developers' Day

Physical session (+ live streaming with Zoom)

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.

Practical Applications