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