Thanks, Ron & Becky.
I remember Shelvar, but hadn't heard anything about it for a while. Adding tags to our entire collection is an initial hurdle, but could obviously be worthwhile in the long run.
Ron's diff command approach is a bit too fine-grained for us as there are multiple acceptable shelflist orders for novels by the same author. I'd probably also need to come up with a way to make the output a bit more user-friendly for our pages :-) That said, I'll probably still spend some time messing around with Windows equivalents of diff (PowerShell, WinMerge, etc.) as that's the OS our pages are most comfortable with.
Thanks for the suggestions!
Plaistow Public Library
On Thu, Jan 15, 2015 at 7:30 PM, Ronald Houk <[log in to unmask]> wrote:
> 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]