[OPEN-ILS-GENERAL] Weeding Report

[Sharp, Chris]

Rebecca,

Would you be willing to share the Generated SQL from your Debugging Info?  It's possible someone can make a recommendation based on that.

Thanks,

Chris

----- Original Message -----
> From: "Rebecca Larocque" <Rebecca.LAROCQUE at cityofnorthbay.ca>
> To: "Open-ILS General Listserv (open-ils-general at list.georgialibraries.org)"
> <open-ils-general at list.georgialibraries.org>
> Sent: Tuesday, September 11, 2012 2:49:43 PM
> Subject: [OPEN-ILS-GENERAL] Weeding Report
> 
> 
> 
> 
> Good afternoon all,
> 
> 
> 
> This subject has come up from time to time, and the response has been
> vague. What I’m looking for is suggestions on how to create weeding
> reports, to see how other libraries are doing it, what filters to
> use, etc.
> 
> 
> 
> Currently, we’re still on 2.0.7, and the report I wrote filters on
> the following:
> 
> · Organization ID
> 
> · Total Circulation Count (with the operator set to “Less than or
> equal to”) – we’ve been on the system for almost a year, so anything
> that hasn’t circulated 10 times (or less than once a month) can go
> 
> · Circulation Modifier code (with the operator set to “In List”) –
> because I want to weed certain AV collections
> 
> 
> 
> The results aren’t that great:
> 
> · I’m getting far fewer results than I’m expecting (i.e. the VHS
> video collection is lightly used, and considering that a big chunk
> of it is in storage and never go out, I should be getting all of
> them but I don’t. Ditto the Talking Book on Cassette collection.)
> 
> · It’s picking up material with other circ modifiers.
> 
> 
> 
> Can anyone offer suggestions, pointers, corrections and whatnot?
> 
> 
> 
> Thanks,
> 
> Rebecca
> 
> 
> 
> Rebecca Larocque, BA (Hons), MLIS
> 
> Head of Information Services
> 
> North Bay Public Library
> 
> 271 Worthington St. E, North Bay ON
> 
> P1B 1H1
> 
> Phone: (705) 474-4830 x2821
> 
> Fax: (705) 495-4010
> 
> http://www.cityofnorthbay.ca/library
> 
> 

-- 
Chris Sharp
PINES Program Manager
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/