Re: [OPEN-ILS-GENERAL] Weeding Report

Wed, 12 Sep 2012 16:56:10 -0700

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" <[email protected]>:


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: [email protected]
[mailto:[email protected]] 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" <[email protected]>
> To: "Evergreen Discussion Group"
> <[email protected]>
> 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: [email protected]
> [mailto:[email protected]] 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" <[email protected]>
> > To: "Open-ILS General Listserv
> > ([email protected])"
> > <[email protected]>
> > 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
> [email protected]
> http://pines.georgialibraries.org/
>

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



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

























					Reply via email to