Re: [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 

Twitter:jillrhudy 

I link patrons and staff

to technology.

[OPEN-ILS-GENERAL] Cloning Trigger Event Definitions vs Creating new ones

[Tony Bandy]

Hi all,

I was working with one of our libraries today and they want to modify the
number of days before their notices go out.

In our system,I can directly modify the existing trigger event definitions
or I can clone them, thereby inactivating the old ones and creating the new
ones.

Are there any "best practices" sort of things to this that you would
recommend?

Normally, I would just go in and alter the existing ones, but not quite
sure if this is the recommended course of action.

Thanks for any thoughts as you get time

Tony

-- 
Tony Bandy
to...@ohionet.org
OHIONET
1500 West Lane Ave.
Columbus, OH  43221-3975
614-486-2966 x19

[OPEN-ILS-GENERAL] ***SPAM*** Re: ***SPAM*** Holds in Evergreen and order notifications

[Tina Ji (Project Sitka)]

Hi Jill,

You may consider setting up a recurring report on the staff client to  
receive an email on regular basis. The drawback I can see is the file  
may be empty sometimes.


Tina
Quoting Jill Minor :

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
Twitter: jillrhudy

I link patrons and staff
to technology.

From: open-ils-general-boun...@list.georgialibraries.org   
[mailto:open-ils-general-boun...@list.georgialibraries.org] On   
Behalf Of Rogan Hamby

Sent: Wednesday, February 13, 2013 7:39 PM
To: Evergreen Development Discussion List
Cc: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] [OPEN-ILS-DEV] Evergreen and QA

I'm going to look at how SCLENDS could contribute to this and make   
some recommendations.  I'm leaning towards $1 per staff member.  I   
can guarantee that my own library, York County Public Library, will   
do that if I have to pay it out of my own pocket in our name.  It   
won't be a lot.  We aren't that large but I feel like we should pay   
something for each one of us that hands on really uses Evergreen.
Actually, I will do that with a smile.


If we start adding up staff time ultimately saved by QA, speeding up  
 code, etc... I think a $1 levy is pretty cheap.  I'll be glad to   
call it a tax.  Taxes are meant for the common good and I wish   
everyone felt like they had to pay into the pool.  I'd like to   
believe that a kickstarter could raise a good bit of cash just off   
frustrations of front line staff.  (I'm not suggesting a   
kickstarter, it's just to illustrate the point of who often feels   
the greatest pain but heck, maybe it would work.  If I could   
guarantee a certain speed I'd probably have funding for a new staff   
client within days.)


So, let me say, thank you Equinox.  We need movement and direction   
made on these big ticket tasks like QA.  I remember spending a fair   
bit of time talking about this last  year at the conference, then   
regularly since and we're almost at the next conference!  I'm going   
to be blunt and say that while I'm always gladdened to see efforts   
by individual community members or small groups funding new   
features, I don't think we're headed in the right direction on the   
big things - really big features, fundamental changes that we can   
build off of, big revisions to code bases like the optimization we   
talked about at the last developer meeting, quality assurance   
processes, etc...  I know no one wants to put any one vendor in too   
central or strong a role and I'd rather QA came out of a community   
effort, but there hasn't been a community led effort and I care   
about results.


I'm not talking about the theory of community or the principles of   
open source.  I do believe in those things by the way, but  I have   
circ and reference staff report directly to me.  I man those desks   
and use it myself.  Results matter and if ESI will lead the way I'll  
 gladly buy my war bonds ... er, send them my money.




And I'm really, really interested in having a dialogue about other   
things.  I want the community to be more aware of things like the   
web sockets conversations and potential of a browser loaded staff   
client and need for optimization and I want to hear the community's   
feedback and who they think should be leading this up.  I think in   
open source there is a certain ethical mandate to take direction   
from the community and if you're willing to spend time on it to go   
that direction.  As a member of the Oversight Board I want us to be   
more aggressive about helping big things happen but do we have the   
backing of the community to do that or do they not want a central   
body in the at role?


I'll be honest, I don't think the listserv is the best place for   
these conversations.  I hope to have them a lot more at the   
conference, especially at the close where I'll be doing some talking  
 about community engagement.   I'll hold Google Hangouts.  Heck, I'm  
 willing to hold regional meetings and if I can reasonably drive to   
it attend.  I'd rather have a thousand people talking and make sense  
 of overload than nothing.  I want us to look forward years ahead  
and  be ambitious but that's me.  And that's also kind of the great  
thing  about open source.  ESI can lead this because they're willing  
to.   And one guy can stand around and be loud and folks can agree  
or  ignore him but if enough agree ... well, that's open source.   
And I  love open source and results.





On Wed, Feb 13, 2013 at 2:38 PM, W. Brad LaJeunesse   
mailto:b...@esilibrary.co

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

[Jill Minor]

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
Twitter: jillrhudy

I link patrons and staff
to technology.

From: open-ils-general-boun...@list.georgialibraries.org 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan 
Hamby
Sent: Wednesday, February 13, 2013 7:39 PM
To: Evergreen Development Discussion List
Cc: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] [OPEN-ILS-DEV] Evergreen and QA

I'm going to look at how SCLENDS could contribute to this and make some 
recommendations.  I'm leaning towards $1 per staff member.  I can guarantee 
that my own library, York County Public Library, will do that if I have to pay 
it out of my own pocket in our name.  It won't be a lot.  We aren't that large 
but I feel like we should pay something for each one of us that hands on really 
uses Evergreen.  Actually, I will do that with a smile.

If we start adding up staff time ultimately saved by QA, speeding up code, 
etc... I think a $1 levy is pretty cheap.  I'll be glad to call it a tax.  
Taxes are meant for the common good and I wish everyone felt like they had to 
pay into the pool.  I'd like to believe that a kickstarter could raise a good 
bit of cash just off frustrations of front line staff.  (I'm not suggesting a 
kickstarter, it's just to illustrate the point of who often feels the greatest 
pain but heck, maybe it would work.  If I could guarantee a certain speed I'd 
probably have funding for a new staff client within days.)

So, let me say, thank you Equinox.  We need movement and direction made on 
these big ticket tasks like QA.  I remember spending a fair bit of time talking 
about this last  year at the conference, then regularly since and we're almost 
at the next conference!  I'm going to be blunt and say that while I'm always 
gladdened to see efforts by individual community members or small groups 
funding new features, I don't think we're headed in the right direction on the 
big things - really big features, fundamental changes that we can build off of, 
big revisions to code bases like the optimization we talked about at the last 
developer meeting, quality assurance processes, etc...  I know no one wants to 
put any one vendor in too central or strong a role and I'd rather QA came out 
of a community effort, but there hasn't been a community led effort and I care 
about results.

I'm not talking about the theory of community or the principles of open source. 
 I do believe in those things by the way, but  I have circ and reference staff 
report directly to me.  I man those desks and use it myself.  Results matter 
and if ESI will lead the way I'll gladly buy my war bonds ... er, send them my 
money.



And I'm really, really interested in having a dialogue about other things.  I 
want the community to be more aware of things like the web sockets 
conversations and potential of a browser loaded staff client and need for 
optimization and I want to hear the community's feedback and who they think 
should be leading this up.  I think in open source there is a certain ethical 
mandate to take direction from the community and if you're willing to spend 
time on it to go that direction.  As a member of the Oversight Board I want us 
to be more aggressive about helping big things happen but do we have the 
backing of the community to do that or do they not want a central body in the 
at role?

I'll be honest, I don't think the listserv is the best place for these 
conversations.  I hope to have them a lot more at the conference, especially at 
the close where I'll be doing some talking about community engagement.   I'll 
hold Google Hangouts.  Heck, I'm willing to hold regional meetings and if I can 
reasonably drive to it attend.  I'd rather have a thousand people talking and 
make sense of overload than nothing.  I want us to look forward years ahead and 
be ambitious but that's me.  And that's also kind of the great thing about open 
source.  ESI can lead this because they're willing to.  And one guy can stand 
around and be loud and folks can agree or ignore him but if enough agree ... 
well, that's open source.  And I love open source and results.




On Wed, Feb 13, 2013 at 2:38 PM, W. Brad LaJeunesse 
mailto:b...@esilibrary.com>> wrote:
Fellow Evergreeners:

At the "future of the staff client" developer meeting Quality Assurance (QA) 
came up repeatedly. This is a serious issue that affects every one of us. It 
obviously affects all users of Evergreen, whether staff or customer, but it 
also greatly affects Equinox in that bugs and other software defects increase