[OPEN-ILS-GENERAL] ***SPAM*** Re: Collection Value Report

[Jason Boyer]

There are a couple shared in Evergreen Indiana now. Under Shared
Templates/jcpl-jasonb/Shared Templates/Collection there are "Simple
Estimated Collection Value By Library" and " Detailed Estimated Collection
Value By Library and Circulation Modifier"

To re-make the Simple one elsewhere: Using Item as the report source,
Item->Call Number/Volume::Owning Library::Name is the first field displayed,
the second is the Aggregate SUM of the Item::Price field. For Base Filters
Item->Call Number::Owning Library is given an In List operator, (If you
want. We have branches so I always use in list for libraries), Deleted equal
to False, and then the Item::Item Status::id with a Not In List operator.
This is for statuses you no long want to consider in your value, such as
lost or discard.

The "detailed" one just ads circ mod between Library Name and the Price sum.
It is very nice with the Pivot Lable set to the circ mod.

People using these obviously need to be aware that there will be things
like: Items with no price (this doesn't use the default item price), items
with the wrong price, items with the wrong status or circ mod, etc. They are
a great place to start for estimates though.

Jason

--
Jason Boyer, IT Specialist
Jackson County Public Library
303 W Second St
Seymour, IN 47274

jasonb at myjclibrary.org
p (812) 522-3412 ext. 227
f (812) 522-5456


On Fri, Mar 19, 2010 at 11:37 AM, Lemmer, Catherine
<clemmer at library.in.gov>wrote:

>
>
> Has anyone created or can one record a report to be used to ascertain the
> value of a library's collection.  The library is changing insurers and needs
> to estimate the value of its collection.
> Any recommendations?
> Catherine
>
>  ------------------------------
> *From:* open-ils-general-bounces at list.georgialibraries.org [mailto:
> open-ils-general-bounces at list.georgialibraries.org] *On Behalf Of *Amy
> Terlaga
> *Sent:* Wednesday, March 10, 2010 5:19 PM
> *To:* open-ils-general at list.georgialibraries.org
> *Subject:* [OPEN-ILS-GENERAL] Evergreen Canned Reports
>
>  Hi all—
>
>
> There was some discussion quite recently about reporting possibilities in
> Evergreen.
>
>
>
> I thought that my recent blog post would be of some interest to you:
>
>
>
> http://biblio-os.blogspot.com/2010/03/evergreen-canned-reports-testing.html
>
>
>
> Amy
>
>
>
> =======================
>
> Amy Terlaga
>
> Assistant Director, User Services
>
> Bibliomation
>
> 32 Crest Road
>
> Middlebury, CT  06762
>
> (203)577-4070 x101
>
> http://www.biblio.org
>
> ----
>
> Bibliomation's Open Source blog:
>
> http://biblio-os.blogspot.com/
>
>
>
> Join us on Facebook:
>
> http://www.facebook.com/group.php?gid=171935276419
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20100322/1f0e40b4/attachment.htm