[OPEN-ILS-GENERAL] Weeding Report

[Sharp, Chris]

Rebecca,

If I were you, I would use the "Classic Item List" source, which contains all the fields you're looking to display (including use count).  Here's what I just did for a test template:

Use Classic Item List source; nullability selection disabled

Displayed Fields:
Classic Item List -> Callnumber Label as "Call Number Label"
Classic Item List -> Title
Classic Item List -> Barcode
Classic Item List -> Use Count as "Total Circulation Count"

Base Filters:
Classic Item List -> Use Count -  Less than or equal to - "10"
Classic Item List -> Circ Modifier - In list
Classic Item List -> Circ Lib -> Organizational Unit ID - In list

If I were creating this template for PINES, I would also display the org unit shortname (Classic Item List -> Circ Lib -> Short (Policy) Name) since that would allow you to print a master weeding list for an entire system and subdivide it from there.

I hope that's helpful!  Please test it out and feel free to let me know if it still doesn't work for you

Chris


----- Original Message -----
> From: "Rebecca Larocque" <Rebecca.LAROCQUE at cityofnorthbay.ca>
> To: "Evergreen Discussion Group" <open-ils-general at list.georgialibraries.org>
> Sent: Tuesday, September 11, 2012 4:44:28 PM
> Subject: Re: [OPEN-ILS-GENERAL] Weeding Report
> 
> Hi Chris,
> 
> Sure - I've attached it as a text file.  Have at it!
> 
> r.
> 
> 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
> 
> -----Original Message-----
> From: open-ils-general-bounces at list.georgialibraries.org
> [mailto:open-ils-general-bounces at list.georgialibraries.org] On
> Behalf Of Sharp, Chris
> Sent: Tuesday, September 11, 2012 3:50 PM
> To: Evergreen Discussion Group
> Subject: Re: [OPEN-ILS-GENERAL] Weeding Report
> 
> 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/
> 

-- 
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/