[OPEN-ILS-GENERAL] Holds in Evergreen and order notifications

[Martha Driscoll]

Jill,
Because Evergreen lets you query the database using SQL, it's pretty 
simple to create purchase alert lists.  We run a script daily that 
creates a purchase alert list for each of our member libraries.  The 
report is based on the ratio of number of holds to the number of copies 
owned.  Each library can define their own ratio.

Here is one of the reports:

http://evergreen.noblenet.org/noble_stats/purchase_alerts.php?library=Danvers

The data for the report is gathered via SQL nightly then a PHP script 
formats the report for the particular library. I'm not sure you need to 
be a programmer to use SQL and PHP, but chances are if you are running 
an Evergreen system you will have someone with those skills nearby.

I believe Evergreen's built in reports function could also be used to 
create such a report, although I have not used it to do so.

Martha Driscoll
Systems Manager
North of Boston Library Exchange
Danvers, Massachusetts
www.noblenet.org

On 2/15/2013 10:33 AM, Jill Minor wrote:
> We’re curious: is there a way to set Evergreen up to flag books with a
> ceiling of holds (like say 8) to notify staff that more copies need to
> be purchased? Or do you need to be a programmer and use SQL or PHP to
> make that work?
>
> phpp2mebdAM.jpg
>
> Jill Minor
>
> Electronic Services Librarian
>
> Washington County Public Library
>
> 205 Oak Hill St
>
> Abingdon, VA 24201
>
> 276-676-6298
>
> http://www.wcpl.net <http://www.wcpl.net/>
>
> Twitter:jillrhudy <http://www.twitter.com/jillrhudy>
>
> I link patrons and staff
>
> to technology.