Re: [CODE4LIB] Identifying misshelved items

2015-01-22 Thread Brent Hanner
erv.nd.edu Subject: Re: [CODE4LIB] Identifying misshelved items I was doing something and it came to me. So basically you should calculate the distance between where it is and where it should be. So you take the belong list and actual place list and put them both into an array. Then you go t

Re: [CODE4LIB] Identifying misshelved items

2015-01-22 Thread Pikas, Christina K.
- From: Code for Libraries [mailto:CODE4LIB@listserv.nd.edu] On Behalf Of Brent Hanner Sent: Wednesday, January 21, 2015 8:20 PM To: CODE4LIB@listserv.nd.edu Subject: Re: [CODE4LIB] Identifying misshelved items I was doing something and it came to me. So basically you should calculate th

Re: [CODE4LIB] Identifying misshelved items

2015-01-21 Thread Brent Hanner
I was doing something and it came to me. So basically you should calculate the distance between where it is and where it should be. So you take the belong list and actual place list and put them both into an array. Then you go through the belong list and find its location in the actual plac

Re: [CODE4LIB] Identifying misshelved items

2015-01-20 Thread Brent Hanner
To reduce the fineness of the grain truncate the field. Sent from Windows Mail From: Cab Vinton Sent: ‎Tuesday‎, ‎January‎ ‎20‎, ‎2015 ‎6‎:‎07‎ ‎AM To: Code for Libraries Thanks, Ron & Becky. I remember Shelvar, but hadn't heard anything about it for a while. Adding tags to our en

Re: [CODE4LIB] Identifying misshelved items

2015-01-20 Thread Ronald Houk
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 wrote: > Thanks, Ron & Becky. > > I remember Shelvar, but hadn't heard anything about it for a while. Adding > tags to our entire c

Re: [CODE4LIB] Identifying misshelved items

2015-01-20 Thread Cab Vinton
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 s

Re: [CODE4LIB] Identifying misshelved items

2015-01-16 Thread Becky Yoose
cky Yoose > Sent: Thursday, January 15, 2015 3:14 PM > To: CODE4LIB@LISTSERV.ND.EDU > Subject: Re: [CODE4LIB] Identifying misshelved items > > Hi Cab, > > >Thoughts on how best to tackle this? And no, shelf-reading while > >scanning > is not an acceptable solution

Re: [CODE4LIB] Identifying misshelved items

2015-01-15 Thread Ronald Houk
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" wrote: > This sounds like a perfect job for a unix/linux system. I'd export this > xls into a nice tab separated cs

Re: [CODE4LIB] Identifying misshelved items

2015-01-15 Thread Harper, Cynthia
So we have to humanly check the skinny books with labels on the covers? Cindy -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Becky Yoose Sent: Thursday, January 15, 2015 3:14 PM To: CODE4LIB@LISTSERV.ND.EDU Subject: Re: [CODE4LIB] Identifying

Re: [CODE4LIB] Identifying misshelved items

2015-01-15 Thread Ronald Houk
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

Re: [CODE4LIB] Identifying misshelved items

2015-01-15 Thread Becky Yoose
Hi Cab, >Thoughts on how best to tackle this? And no, shelf-reading while scanning is not an acceptable solution :-) Awww, but you can shelf read with your phone! http://shelvar.com/ They claim to have an inventory part in development, but I am unaware of the ETA of the feature. I do know one of

[CODE4LIB] Identifying misshelved items

2015-01-15 Thread Cab Vinton
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