This sounds like a perfect job for a unix/linux system. I'd export this
xls into a nice tab separated csv. Then sort the column that contains the
call no. Then compare the sorted columns to the original column with diff.
something along the lines of
diff -Nau <(original.csv | sort -k[[whatever field you want to sort by]])
For the dewey titles you could add the -n flag to sort.
This is just a rough sketch, but with a little work I think it will work
for you and what's better it won't cost you dime. :)
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
> 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!
> Cab Vinton, Director
> Plaistow Public Library
> Plaistow, NH
Ottumwa Public Library
102 W. Fourth Street
Ottumwa, IA 52501
[log in to unmask]