[OPEN-ILS-GENERAL] Weeding Report

[Sharp, Chris]

Tom,

I definitely agree that we shouldn't have the view show in the available sources if the views don't exist in the DB, so +1 for commenting them out.  I think they are useful, so some inline documentation in the IDL file pointing to the need to run the example.reporter-extension.sql to fully enable them would be ideal, IMHO.  If others are in favor of removing them altogether, though, I'd go along with that, but I would want some documentation informing admins about their existence and usage (which I'd be willing to contribute).

Chris

----- Original Message -----
> I am going to assume that it isn't there because nothing installs it
> by default.
> 
> There is an example reporter extension SQL file that contains it, but
> it doesn't get run by default during an install.
> 
> Which makes me wonder if we should be removing, or at least
> commenting
> out, the IDL entries for these views.
> 
> Thomas Berezansky
> Merrimack Valley Library Consortium
> 
> 
> Quoting "Sharp, Chris" <csharp at georgialibraries.org>:
> 
> > Rebecca,
> >
> >> 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
> >
> > So you were able to create the template with the Classic Item List
> > source but you got this error?  If so, I would notify your system
> > administrator about why that table (view, actually) isn't there.
> >
> > The report should be able to be created without that view, but
> > that's definitely the most straightforward approach (assuming the
> > view can be created in your database).
> >
> >
> >> 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/
> >
> 
> 

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