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