[OPEN-ILS-GENERAL] Weeding Report

Wed Sep 19 15:39:41 EDT 2012

Hi Chris,

So yes, that worked wonderfully - thanks!  Now I have a weeding list for my videos and audiocassettes...

...which are both collections for which we haven't added any new material in the last few years.  It becomes an issue if I try to use it on something like DVDs or audiobooks on CD or MP3 that have low circ numbers due to only having been added in the last few months.  Right now, I'm experimenting with adding a filter for Check in date (if it hasn't been taken out since a certain date) or Record Creation Date/Time (if the record was created before a certain date and has less than a specified number of circulations).

And that's where I am 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: Thursday, September 13, 2012 8:27 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Weeding Report

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/