Just realized I had a typo. Should look something like. diff -Nau <(sort -k[[whatever field you want to sort by]] original.csv) original.csv On Jan 15, 2015 2:29 PM, "Ronald Houk" <[log in to unmask]> wrote: > 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]]) > original.csv > > 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 >> 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 >> > > > > -- > Ronald Houk > Assistant Director > Ottumwa Public Library > 102 W. Fourth Street > Ottumwa, IA 52501 > (641)682-7563x203 > [log in to unmask] >