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]
>