Bug 12733 - Interactive inventory tool
Summary: Interactive inventory tool
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Tools (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Jacob O'Mara
QA Contact: Testopia
URL: https://github.com/PTFS-Europe/koha-p...
Keywords:
Depends on:
Blocks:
 
Reported: 2014-08-07 21:51 UTC by Barton Chittenden
Modified: 2025-01-13 11:21 UTC (History)
14 users (show)

See Also:
Change sponsored?: Sponsored
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Barton Chittenden 2014-08-07 21:51:48 UTC
Want a tool which will allow items to be scanned and immediately checked against the inventory:

* Check item 'check-out' status, report items that are checked out.
* Check for all features of item noted in bug 11405
* Change 'last seen' status of item to current date/time
* I think that it would be useful to track item information at the time that the inventory was taken; this might require a separate 'last inventoried' table.
Comment 1 Barbara Johnson 2021-05-11 16:30:50 UTC
It would increase efficiency to be able to do inventory in real-time rather than having to upload files.
Comment 2 Katrin Fischer 2021-05-11 16:52:04 UTC
Hm, reading this bug report I wonder if it would not work to just check-in the items. The datelastseen will be updated, checkouts reports etc. ?
Comment 3 Lisette Scheer 2021-05-11 17:03:24 UTC
The original comment does mention making sure all the enhancements from 11405:
1) Have the tool warn of items possibly shelved out of order for scanned lists of barcodes ( by comparing to previous and next items ).
2) Ability to skip items with waiting holds ( in the same manners as items on issue are skipped ).
3) The ability to choose locations to not flag as "Item should have been scanned" if not scanned ( e.g. On Shelving Cart, On Display, etc )

1.The check in tool doesn't warn of items shelved out of order (although you could kind of shelf read the call number column as you go) 
2. You could run a report that excluded any items that were already waiting when you started the inventory. 
3. Again reports could probably do this for us.
Comment 4 Tom Misilo 2021-05-11 17:49:33 UTC
(In reply to Katrin Fischer from comment #2)
> Hm, reading this bug report I wonder if it would not work to just check-in
> the items. The datelastseen will be updated, checkouts reports etc. ?

Also checking in *can* mark an item used, which may not be something you would want during inventory.
Comment 5 Katrin Fischer 2021-05-11 21:35:51 UTC
Thx, good points being made!
Comment 6 Hannah Co 2021-05-12 23:37:24 UTC
I created a plugin that does scan-as-you-go shelf reading and inventory updating. https://github.com/hmconorthwestu/koha-plugin-shelfreading

The sorting is across the whole group of scanned items, not a simple comparison to previous or next items, which can mark order incorrectly when shelves get too scrambled. The plugin probably needs DDC sorting added, as my library only uses LCC and alphanumeric classification.

I have a brief description on github, with more details, but I'm happy to answer any questions about it.
Comment 7 Katrin Fischer 2021-06-03 22:45:32 UTC
(In reply to Hannah Co from comment #6)
> I created a plugin that does scan-as-you-go shelf reading and inventory
> updating. https://github.com/hmconorthwestu/koha-plugin-shelfreading
> 
> The sorting is across the whole group of scanned items, not a simple
> comparison to previous or next items, which can mark order incorrectly when
> shelves get too scrambled. The plugin probably needs DDC sorting added, as
> my library only uses LCC and alphanumeric classification.
> 
> I have a brief description on github, with more details, but I'm happy to
> answer any questions about it.

Hi Hannah, I've added your plugin to the plugin list on the wiki:
https://wiki.koha-community.org/wiki/Koha_plugins#Plugins
Please feel free to add more!
Comment 8 Martin Renvoize (ashimema) 2024-07-02 18:29:32 UTC
We're currently working on this, trialing it as a Vue app based plugin with the intention to upstream once we have something more firm to show
Comment 9 Martin Renvoize (ashimema) 2025-01-13 11:21:34 UTC
Built as a plugin and available https://github.com/PTFS-Europe/koha-plugin-interactiveinventory

We'll be adding it to the soon to be maintstrain plugin store.. Closing this bug.