Koha ILS RFID Handheld Middleware

Koha RFID handheld middleware (and handheld middleware for Koha ILS) is a mobile-first edge service designed to bridge Android-based RFID handheld terminals (such as the Chainway C72) directly with Koha Integrated Library System (ILS). Rather than forcing library staff to toggle between proprietary scanner utilities and Koha web screens, the middleware converts multi-tag RF sweeps into native Koha bibliographic lookups, SIP2 patron validations, and instant circulation status updates. Designed for Indian university libraries, public research institutions, and school networks, it transforms grueling multi-week manual shelf stock-verifications into high-speed, walking sweeps that capture over 700 books per minute.

The middleware establishes high-speed, persistent TCP socket connections to the Koha SIP2 server (typically listening on Port 6001 or 6002). Utilizing standardized SIP2 transaction sets—including Item Information (17/18), Checkin (09/10), and Checkout (11/12) messages—the middleware parses raw RFID UID/EPC tag reads, looks up the corresponding Koha barcode or accession number, and executes circulation commands in under 120 milliseconds. In parallel, it interfaces with Koha REST API endpoints using secure Bearer tokens to fetch MARC21 metadata, call numbers, shelf locations, and item status flags without placing heavy database locking loads on the main Koha web server.

Conducting periodic stock verification across thousands of library book stacks is historically prone to errors. With OpenRFID Koha Middleware, librarians can load target pull-lists, missing item registers, or reservation rosters onto the handheld terminal. During shelf sweeping, the terminal continuously compares detected RFIDs against the target list. When a targeted or misplaced item is detected in the RF field, the handheld emits dynamic Geiger-counter style audio beeps and visual haptic alerts, guiding the librarian directly to the book's exact shelf coordinate even when filed under the wrong Dewey Decimal or classification header.

Tagging new acquisitions into Koha requires mapping physical accession numbers to digital chip memory banks. The middleware provides an automated 'Fast Tagging' wizard that reads physical barcode labels using the scanner's 2D imager, queries Koha for the item record, formats the RFID tag according to ISO 28560-2/3 library data standards (encoding the Owner Library ISIL code, primary item identifier, and set information), writes the 24-character hexadecimal EPC, and sets the Application Family Identifier (AFI / EAS) security byte to active in a single synchronized 1.5-second sequence.

A premier technical university in Bengaluru, Karnataka, housing over 140,000 volumes across 3 library floors, previously spent 6 weeks during annual vacation periods conducting manual barcode stock verification. By deploying the OpenRFID Koha Handheld Middleware across 4 Chainway C72 UHF scanners, the library completed its entire 140,000-book stock verification in just 3.5 days with zero library downtime. The audit identified 1,120 misplaced volumes and recovered 340 books previously marked as permanently lost in the Koha catalog.