[OPEN-ILS-GENERAL] Weeding Report

[Sharp, Chris]

Rebecca,

I have created a version that doesn't require the view.  Could you try this out?:

Uses Item source with nullability selection enabled 

Displayed Fields: 
Item -> (Default) Call Number/Volume -> Call Number Label (Raw Data) 
Item -> (Default) Call Number/Volume -> (Default) Bib Record -> (Default) Simple Record Extracts -> Title Proper (normalized) (Raw Data) as "Title" Item -> Barcode (Raw Data) 
Item -> (Child) Circulations -> Circ ID (Count Distinct) as "Total Circulation Count" 

Aggregate Filters: 
Item -> (Child) Circulations -> Circ ID (Count Distinct) - Less than or equal to - "10" 

Base Filters: 
Item -> Circluation Modifier (Raw Data) - In list 
Item -> (Default) Circulating Library -> Organizational Unit ID - In list 

Please let me know if that works for you.

Thanks,

Chris

----- Original Message -----
> Hey Chris,
> 
> I gave it a shot, and got the following error message when I went to
> output:
> 
> DBD::Pg::st execute failed: ERROR: relation
> "reporter.classic_item_list" does not exist at character 265
> 
> I also tried "Classic circulation view" and enabling the nullability
> selection.  I'll keep poking at it for now.
> 
> 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: Wednesday, September 12, 2012 8:28 AM
> To: Evergreen Discussion Group
> Subject: Re: [OPEN-ILS-GENERAL] Weeding Report
> 
> 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/
> 

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