Hi Cindy, >So we have to humanly check the skinny books with labels on the covers? Good question. I know that this was talked about in the very early development stages of shelvar, but I didn't see what the solution or workaround was... a ping to [log in to unmask] might get the question answered, though. Thanks, Becky On Thu, Jan 15, 2015 at 5:42 PM, Harper, Cynthia <[log in to unmask]> wrote: > So we have to humanly check the skinny books with labels on the covers? > Cindy > > -----Original Message----- > From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of > Becky Yoose > Sent: Thursday, January 15, 2015 3:14 PM > To: [log in to unmask] > 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 <[log in to unmask]> 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 > > >