Koha's inventory utility is handy but seems to be missing one critical element, namely the ability to flag items out of call number order. The utility also does not generate a downloadable file. This means copying & pasting the results into a spreadsheet & some rather tedious data clean-up to get workable data. Has anyone come up with a streamlined method for using the inventory tool to help identify mis-shelved items? I'm on the verge of getting into writing a macro, but my VBA skills are very rusty & I'm always happy to avoid reinventing the wheel. For what it's worth, we're not looking to get too fine-grained here. We're not too concerned with titles out of order, for example, within an author. We're really looking for authors out of order. Grateful for your thoughts & suggestions. All best, Cab Vinton, Director Plaistow Public Library
Koha's inventory utility is handy but seems to be missing one critical element, namely the ability to flag items out of call number order.
The utility also does not generate a downloadable file. This means copying & pasting the results into a spreadsheet & some rather tedious data clean-up to get workable data.
Has anyone come up with a streamlined method for using the inventory tool to help identify mis-shelved items?
I'm on the verge of getting into writing a macro, but my VBA skills are very rusty & I'm always happy to avoid reinventing the wheel.
For what it's worth, we're not looking to get too fine-grained here. We're not too concerned with titles out of order, for example, within an author. We're really looking for authors out of order. It's not clear to me what you are finding that's out of order. Is it the books on the shelf or the listing in the catalog? If the books, why is
On 12/16/2014 01:35 PM, Cab Vinton wrote: there a challenge to relocating them? As for downloading and printing the inventory, I gave up on that and just read the inventory list on a smartphone. Very portable, and the updates go live immediately. A tablet would be nicer, but isn't in the budget. Mind, if I had barcodes I could scan while walking the aisles, something more interesting might be in order. Regards, / Bruce / Bruce A. Metcalf, Librarian The Augustan Society, Inc.
It's not clear to me what you are finding that's out of order. Is it the books on the shelf or the listing in the catalog?
The books on the shelf are out of order.
If the books, why is there a challenge to relocating them?
No challenge, but this slows down the barcode scanning process remarkably. Shelf-reading is a slow, methodical business; scanning is rapid-fire. See this bug for how the development folks are approaching this issue: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11405
As for downloading and printing the inventory, I gave up on that and just read the inventory list on a smartphone. Very portable, and the updates go live immediately. A tablet would be nicer, but isn't in the budget.
No one said anything about downloading & printing the inventory (shelflist?). That's the last approach I would want to use ;-) Technology's supposed to make things easier, after all ... Best, Cab Vinton Plaistow Public Library
participants (2)
-
Cab Vinton -
Consul Bruce Metcalf