Hi Cab,

Take a look at meld as well.  It is another beautiful open source gui for
diff-ing files. http://meldmerge.org/

On Tue, Jan 20, 2015 at 6:07 AM, Cab Vinton <[log in to unmask]> wrote:

> 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!
>
> Cab Vinton
> Plaistow Public Library
> Plaistow, NH
>
> 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)
> > 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]
> >>
>



-- 
Ronald Houk
Assistant Director
Ottumwa Public Library
102 W. Fourth Street
Ottumwa, IA 52501
(641)682-7563x203
[log in to unmask]