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