So we have to humanly check the skinny books with labels on the covers? Cindy
-----Original Message----- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Becky Yoose Sent: Thursday, January 15, 2015 3:14 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Identifying misshelved items Hi Cab, >Thoughts on how best to tackle this? And no, shelf-reading while >scanning is not an acceptable solution :-) Awww, but you can shelf read with your phone! http://shelvar.com/ They claim to have an inventory part in development, but I am unaware of the ETA of the feature. I do know one of the main folks behind the app, though, if you want more info. Thanks, Becky ------------------ Becky Yoose Discovery and Integrated Systems Librarian Grinnell College Libraries On Thu, Jan 15, 2015 at 1:32 PM, Cab Vinton <bibli...@gmail.com> wrote: > We're doing inventory here and would love to combine this with finding > items out of call number order. (The inventory process simply updates > the datelastseen field.) > > Koha's inventory tool generates an XLS file in the following format > (barcodes, too, actually): > > Title Author Call number The last jihad : Rosenberg, Joel, FIC > ROSEN Home repair / Rosenbarg, Liz. FIC ROSEN Abuse of power / Rosen, > Fred. FIC ROSEN California angel / Rosenberg, Nancy Taylor. FIC ROSEN > What we'd ideally like is a programmatic method of: > > 1./ identifying items like Home Repair and Abuse of Power, and > > 2./ specifying where such misshelved titles are currently located. > > For fiction, we're mostly concerned with authors out of order (i.e., > title order *within* the same author can be ignored). For non-fiction, > Dewey/ call number order is, of course, the desired result. > > Thoughts on how best to tackle this? And no, shelf-reading while > scanning is not an acceptable solution :-) > > My VBA skills are seriously rusty at this point, and there are some > complicating factors (e.g,. how to handle to books in a row which are > misshelved -- the second book's location should be compared to the > last correctly shelved book; see Rosen/ Rosenberg above). > > Has this wheel already been invented? > > Grateful for any & all suggestions! > > Best, > > Cab Vinton, Director > Plaistow Public Library > Plaistow, NH >