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]