Re: [OPEN-ILS-GENERAL] Evergreen Reports Taskforce Meeting: December 14, 2011

2011-12-14 Thread Turner, Jennifer M
Just a quick reminder of the Reports Taskforce meeting today at 2:30 Eastern on 
IRC.  Details below.

From: Turner, Jennifer M
Sent: Friday, December 09, 2011 10:52 AM
To: evergreen-repo...@list.evergreen-ils.org; Evergreen Discussion Group 
(open-ils-general@list.georgialibraries.org)
Subject: Evergreen Reports Taskforce Meeting: December 14, 2011


Please join our next Taskforce meeting on Wednesday, December 14 at 2:30 
Eastern on the #Evergreen IRC channel (http://evergreen-ils.org/irc.php).  
Anyone interested in reports in Evergreen is welcome to attend.

The agenda has been posted: 
http://open-ils.org/dokuwiki/doku.php?id=evergreen-reports:meetings:2011-12-14-agenda.
  Feel free to add or edit agenda topics.

Jenny



Jennifer Turner | PALS, A Program of the Minnesota State Colleges and 
Universities | 507-389-2000



[OPEN-ILS-GENERAL] straw poll, call numbers in check-in screen

2011-12-14 Thread Jason Etheridge
In EG 2.1, we--well, I, this was before we started doing
sign-offs--removed the call number column from the list in the Check
In interface (in the name of fewer network calls and improved
performance), and maybe should not have.  I know of at least two
libraries that miss it.  How do others feel?

Should it be restored outright, or made into a configurable option?

Thanks!

-- 
Jason Etheridge
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  ja...@esilibrary.com
 | web:  http://www.esilibrary.com


Re: [OPEN-ILS-GENERAL] straw poll, call numbers in check-in screen

2011-12-14 Thread Gordana Vitez
Hi Jason,
 
I vote for having it restored.
 
Thanks!
Gordana

 Jason Etheridge ja...@esilibrary.com 12/14/2011 11:38 AM 
In EG 2.1, we--well, I, this was before we started doing
sign-offs--removed the call number column from the list in the Check
In interface (in the name of fewer network calls and improved
performance), and maybe should not have.  I know of at least two
libraries that miss it.  How do others feel?

Should it be restored outright, or made into a configurable option?

Thanks!

-- 
Jason Etheridge
| Equinox Software, Inc. / The Open Source Experts
| phone:  1-877-OPEN-ILS (673-6457)
| email:  ja...@esilibrary.com 
| web:  http://www.esilibrary.com


Re: [OPEN-ILS-GENERAL] straw poll, call numbers in check-in screen

2011-12-14 Thread Deanna Frazee
Yes, please restore it.  Having the call number as on option on the check in 
screen can be very helpful when you are trying to identify problems. 

Deanna Frazee
Killeen City Library System

-Original Message-
From: open-ils-general-boun...@list.georgialibraries.org 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason 
Etheridge
Sent: Wednesday, December 14, 2011 10:39 AM
To: Evergreen Discussion Group
Subject: [OPEN-ILS-GENERAL] straw poll, call numbers in check-in screen

In EG 2.1, we--well, I, this was before we started doing sign-offs--removed the 
call number column from the list in the Check In interface (in the name of 
fewer network calls and improved performance), and maybe should not have.  I 
know of at least two libraries that miss it.  How do others feel?

Should it be restored outright, or made into a configurable option?

Thanks!

--
Jason Etheridge
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  ja...@esilibrary.com
 | web:  http://www.esilibrary.com


Re: [OPEN-ILS-GENERAL] straw poll, call numbers in check-in screen

2011-12-14 Thread Jason Boyer
Is everything in the column picker retrieved, even if it's not currently
displayed? If so, the long term solution may be to only request from the
server what will actually be shown (or the smallest superset necessary) and
only retrieve things like call numbers when they're requested. Adding a
column with this arrangement would leave some columns blank, but to see
those the items could just be scanned again. That way those that need to
save network calls can not show it, and those that prefer to display it can
take the hit, without having to bother with another setting.

Also, I'd vote for it to go back in.

Jason

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

jas...@myjclibrary.org
p (812) 522-3412 ext. 227
f (812) 522-5456


On Wed, Dec 14, 2011 at 12:13 PM, Rogan Hamby rha...@statelibrary.sc.govwrote:

 +1

 Sent from my iPhone

 On Dec 14, 2011, at 11:46 AM, Gordana Vitez gvi...@niagaracollege.ca
 wrote:

 Hi Jason,

 I vote for having it restored.

 Thanks!
 Gordana

  Jason Etheridge ja...@esilibrary.com 12/14/2011 11:38 AM 
 In EG 2.1, we--well, I, this was before we started doing
 sign-offs--removed the call number column from the list in the Check
 In interface (in the name of fewer network calls and improved
 performance), and maybe should not have.  I know of at least two
 libraries that miss it.  How do others feel?

 Should it be restored outright, or made into a configurable option?

 Thanks!

 --
 Jason Etheridge
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  ja...@esilibrary.com
 | web:  http://www.esilibrary.com




Re: [OPEN-ILS-GENERAL] straw poll, call numbers in check-in screen

2011-12-14 Thread Jason Etheridge
On Wed, Dec 14, 2011 at 12:25 PM, Jason Boyer jas...@myjclibrary.org wrote:
 Is everything in the column picker retrieved, even if it's not currently
 displayed?

In this case, since rows are inserted at the top of the list, they all
get fleshed and retrieved.  And there's no standard mechanism for per
column retrieval based on column visibility.

 If so, the long term solution may be to only request from the
 server what will actually be shown (or the smallest superset necessary) and
 only retrieve things like call numbers when they're requested.

I think that's where we're heading, long term--not sending large
objects across the wire unless we really need them.

I'll work up a branch restoring the call number (and prefix and suffix).

Thanks folks!

-- 
Jason Etheridge
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  ja...@esilibrary.com
 | web:  http://www.esilibrary.com


Re: [OPEN-ILS-GENERAL] straw poll, call numbers in check-in screen

2011-12-14 Thread Kathy Lussier
I concur with everyone else to restore the call number. I've heard from a
couple of libraries that would like to see the call number at check in.

Kathy

-
Kathy Lussier
Project Coordinator
Massachusetts Library Network Cooperative
(508) 756-0172
(508) 755-3721 (fax)
kluss...@masslnc.org
IM: kmlussier (AOL  Yahoo)
Twitter: http://www.twitter.com/kmlussier
 
 

-Original Message-
From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-
ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Boyer
Sent: Wednesday, December 14, 2011 12:26 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] straw poll, call numbers in check-in
screen

Is everything in the column picker retrieved, even if it's not
currently displayed? If so, the long term solution may be to only
request from the server what will actually be shown (or the smallest
superset necessary) and only retrieve things like call numbers when
they're requested. Adding a column with this arrangement would leave
some columns blank, but to see those the items could just be scanned
again. That way those that need to save network calls can not show it,
and those that prefer to display it can take the hit, without having to
bother with another setting.


Also, I'd vote for it to go back in.


Jason



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

jas...@myjclibrary.org
p (812) 522-3412 ext. 227
f (812) 522-5456



On Wed, Dec 14, 2011 at 12:13 PM, Rogan Hamby
rha...@statelibrary.sc.gov wrote:


  +1

  Sent from my iPhone

  On Dec 14, 2011, at 11:46 AM, Gordana Vitez
gvi...@niagaracollege.ca wrote:



  Hi Jason,

  I vote for having it restored.

  Thanks!
  Gordana

   Jason Etheridge ja...@esilibrary.com 12/14/2011 11:38
AM 
  In EG 2.1, we--well, I, this was before we started doing
  sign-offs--removed the call number column from the list in
the Check
  In interface (in the name of fewer network calls and
improved
  performance), and maybe should not have.  I know of at
least two
  libraries that miss it.  How do others feel?

  Should it be restored outright, or made into a configurable
option?

  Thanks!

  --
  Jason Etheridge
  | Equinox Software, Inc. / The Open Source Experts
  | phone:  1-877-OPEN-ILS (673-6457)
  | email:  ja...@esilibrary.com
  | web:  http://www.esilibrary.com






[OPEN-ILS-GENERAL] ***SPAM*** Action / Trigger

2011-12-14 Thread David Busby
Greetings Star-fighters;

  My goal is to create process that will email my patrons their due
date information after checkout.  I'm hoping to originate one-email
per set of items checked-out. (not one email per copy).

  I have created a Trigger Event Definition:

evergreen=# select * from action_trigger.event_definition where id = 101;
-[ RECORD 1 
]---+
id  | 101
active  | t
owner   | 1
name| Circ Checkout Due Email
hook| checkout
validator   | NOOP_True
reactor | SendEmail
cleanup_success | NOOP_True
cleanup_failure | NOOP_True
delay   | 05:00:00
max_delay   |
usr_field   |
opt_in_setting  |
delay_field | circ.create_time
group_field | usr
template| [%- USE date -%]
| [%- user = target.0.usr -%]
| To: [%- params.recipient_email || user.email %]
| From: [%- params.sender_email || default_sender %]
| Subject: [kcls.org] Item Due Reminder
|
| Dear [% user.family_name %], [% user.first_given_name %]
|
| A friendly reminder, these items you checked out
today are due at:
|
| [%- params.recipient_email || user.email %][%-
params.sender_email || default_sender %]
|
| [% FOR circ IN target %]
| Title: [%
circ.target_copy.call_number.record.simple_record.title %]
| Barcode: [% circ.target_copy.barcode %]
| Due: [%
date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %]
| Item Cost: [% helpers.get_copy_price(circ.target_copy) %]
| Total Owed For Transaction: [%
circ.billable_transaction.summary.total_owed %]
| Library: [% circ.circ_lib.name %]
|
| [% END %]
|
granularity | Hourly

  After creating this definition, I perform a checkout (which becomes
visible in the circulation view)
-[ RECORD 2 ]---+--
id  | 2
usr | 389
xact_start  | 2011-12-14 17:08:48.497165-08
xact_finish |
unrecovered |
target_copy | 364
circ_lib| 4
circ_staff  | 1
checkin_staff   |
checkin_lib |
renewal_remaining   | 2
grace_period| 1 day
due_date| 2011-12-21 23:59:59-08
stop_fines_time |
checkin_time|
create_time | 2011-12-14 17:08:48.497165-08
duration| 7 days
fine_interval   | 1 day
recurring_fine  | 0.05
max_fine| 5.00
phone_renewal   | f
desk_renewal| f
opac_renewal| f
duration_rule   | default
recurring_fine_rule | default
max_fine_rule   | default
stop_fines  |
workstation | 1
checkin_workstation |
checkin_scan_time   |
parent_circ |

  Then I run the processor as follows (manually for now, cron later)

./action_trigger_runner.pl \
  --debug-stdout \
  --osrf-config=/openils/etc/opensrf_core.xml \
   --process-hooks \
  --run-pending

This script never produces output, but I do see this kind of stuff in
my logs (orsfsys.log)

request en-US open-ils.cstore.direct.action_trigger.event.id_list
[{+atevdef:{granularity:null},run_time:{:now},state:pending},{order_by:{atev:[run_time,add_time]},join:atevdef}]
open-ils.cstore 2011-12-14 18:07:25
[INFO:19675:osrf_application.c:1040:] CALL: open-ils.cstore
open-ils.cstore.direct.action_trigger.event.id_list
{+atevdef:{granularity:null},run_time:{:now},state:pending},{order_by:{atev:[run_time,add_time]},join:atevdef}
open-ils.cstore 2011-12-14 18:07:25
[INFO:19675:osrf_app_session.c:991:] [open-ils.cstore] sent 175 bytes
of data to opensrf@private.localhost/open-ils.trigger_drone_at_localhost_19700
open-ils.cstore 2011-12-14 18:07:25 [INFO:19675:osrf_stack.c:159:]
Message processing duration 0.004140
[2011-12-14 18:07:25] open-ils.trigger
[INFO:19700:CStoreEditor.pm:109:] editor[1|0]
action_trigger.event.search : returned 0 result(s)
open-ils.cstore 2011-12-14 18:07:25 [INFO:19675:osrf_stack.c:159:]
Message processing duration 0.19

  I am confused  using Evergreen 2.0.1a, PostgreSQL 9.1
  Also, many thanks to the IRC folks for helping me get this far.

--
David Busby
Managing Director
Edoceo, Inc.
http://edoceo.com/
206.282.6500


Re: [OPEN-ILS-GENERAL] ***SPAM*** Action / Trigger

2011-12-14 Thread Bill Erickson

Hi David,

Try changing the delay_field from circ.create_time to just
create_time.  Since the hook has a core_type of circ, circ. is
implied.

-b

On Wed, Dec 14, 2011 at 10:54:46AM -0800, David Busby wrote:
 Greetings Star-fighters;
 
   My goal is to create process that will email my patrons their due
 date information after checkout.  I'm hoping to originate one-email
 per set of items checked-out. (not one email per copy).
 
   I have created a Trigger Event Definition:
 
 evergreen=# select * from action_trigger.event_definition where id = 101;
 -[ RECORD 1 
 ]---+
 id  | 101
 active  | t
 owner   | 1
 name| Circ Checkout Due Email
 hook| checkout
 validator   | NOOP_True
 reactor | SendEmail
 cleanup_success | NOOP_True
 cleanup_failure | NOOP_True
 delay   | 05:00:00
 max_delay   |
 usr_field   |
 opt_in_setting  |
 delay_field | circ.create_time
 group_field | usr
 template| [%- USE date -%]
 | [%- user = target.0.usr -%]
 | To: [%- params.recipient_email || user.email %]
 | From: [%- params.sender_email || default_sender %]
 | Subject: [kcls.org] Item Due Reminder
 |
 | Dear [% user.family_name %], [% user.first_given_name %]
 |
 | A friendly reminder, these items you checked out
 today are due at:
 |
 | [%- params.recipient_email || user.email %][%-
 params.sender_email || default_sender %]
 |
 | [% FOR circ IN target %]
 | Title: [%
 circ.target_copy.call_number.record.simple_record.title %]
 | Barcode: [% circ.target_copy.barcode %]
 | Due: [%
 date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %]
 | Item Cost: [% helpers.get_copy_price(circ.target_copy) 
 %]
 | Total Owed For Transaction: [%
 circ.billable_transaction.summary.total_owed %]
 | Library: [% circ.circ_lib.name %]
 |
 | [% END %]
 |
 granularity | Hourly
 
   After creating this definition, I perform a checkout (which becomes
 visible in the circulation view)
 -[ RECORD 2 ]---+--
 id  | 2
 usr | 389
 xact_start  | 2011-12-14 17:08:48.497165-08
 xact_finish |
 unrecovered |
 target_copy | 364
 circ_lib| 4
 circ_staff  | 1
 checkin_staff   |
 checkin_lib |
 renewal_remaining   | 2
 grace_period| 1 day
 due_date| 2011-12-21 23:59:59-08
 stop_fines_time |
 checkin_time|
 create_time | 2011-12-14 17:08:48.497165-08
 duration| 7 days
 fine_interval   | 1 day
 recurring_fine  | 0.05
 max_fine| 5.00
 phone_renewal   | f
 desk_renewal| f
 opac_renewal| f
 duration_rule   | default
 recurring_fine_rule | default
 max_fine_rule   | default
 stop_fines  |
 workstation | 1
 checkin_workstation |
 checkin_scan_time   |
 parent_circ |
 
   Then I run the processor as follows (manually for now, cron later)
 
 ./action_trigger_runner.pl \
   --debug-stdout \
   --osrf-config=/openils/etc/opensrf_core.xml \
--process-hooks \
   --run-pending
 
 This script never produces output, but I do see this kind of stuff in
 my logs (orsfsys.log)
 
 request en-US open-ils.cstore.direct.action_trigger.event.id_list
 [{+atevdef:{granularity:null},run_time:{:now},state:pending},{order_by:{atev:[run_time,add_time]},join:atevdef}]
 open-ils.cstore 2011-12-14 18:07:25
 [INFO:19675:osrf_application.c:1040:] CALL: open-ils.cstore
 open-ils.cstore.direct.action_trigger.event.id_list
 {+atevdef:{granularity:null},run_time:{:now},state:pending},{order_by:{atev:[run_time,add_time]},join:atevdef}
 open-ils.cstore 2011-12-14 18:07:25
 [INFO:19675:osrf_app_session.c:991:] [open-ils.cstore] sent 175 bytes
 of data to opensrf@private.localhost/open-ils.trigger_drone_at_localhost_19700
 open-ils.cstore 2011-12-14 18:07:25 [INFO:19675:osrf_stack.c:159:]
 Message processing duration 0.004140
 [2011-12-14 18:07:25] open-ils.trigger
 [INFO:19700:CStoreEditor.pm:109:] editor[1|0]
 action_trigger.event.search : returned 0 result(s)
 open-ils.cstore 2011-12-14 18:07:25 [INFO:19675:osrf_stack.c:159:]
 Message processing duration 0.19
 
   I am confused  using Evergreen 2.0.1a, PostgreSQL 9.1
   Also, many thanks to the IRC folks for helping me get this far.
 
 --
 David Busby
 Managing Director
 Edoceo, Inc.
 http://edoceo.com/
 206.282.6500

-- 
Bill Erickson
| Senior Software Developer
| phone: 877-OPEN-ILS (673-6457)
| email: erick...@esilibrary.com
| web: http://esilibrary.com 

Re: [OPEN-ILS-GENERAL] straw poll, call numbers in check-in screen

2011-12-14 Thread Sharon Herbert (Project Sitka)

Hi Jason,

Sitka's preference is also to restore the call number, as most of our  
sites will expect to see this at check-in.


Thanks,
Sharon
--
Sharon Herbert
Sitka Project Manager
BC Libraries Cooperative
Tel: 604.854.5618
Email: sherb...@sitka.bclibraries.ca
Quoting Kathy Lussier kluss...@masslnc.org:


I concur with everyone else to restore the call number. I've heard from a
couple of libraries that would like to see the call number at check in.

Kathy

-
Kathy Lussier
Project Coordinator
Massachusetts Library Network Cooperative
(508) 756-0172
(508) 755-3721 (fax)
kluss...@masslnc.org
IM: kmlussier (AOL  Yahoo)
Twitter: http://www.twitter.com/kmlussier




-Original Message-
From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-
ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Boyer
Sent: Wednesday, December 14, 2011 12:26 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] straw poll, call numbers in check-in
screen

Is everything in the column picker retrieved, even if it's not
currently displayed? If so, the long term solution may be to only
request from the server what will actually be shown (or the smallest
superset necessary) and only retrieve things like call numbers when
they're requested. Adding a column with this arrangement would leave
some columns blank, but to see those the items could just be scanned
again. That way those that need to save network calls can not show it,
and those that prefer to display it can take the hit, without having to
bother with another setting.


Also, I'd vote for it to go back in.


Jason



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

jas...@myjclibrary.org
p (812) 522-3412 ext. 227
f (812) 522-5456



On Wed, Dec 14, 2011 at 12:13 PM, Rogan Hamby
rha...@statelibrary.sc.gov wrote:


+1

Sent from my iPhone

On Dec 14, 2011, at 11:46 AM, Gordana Vitez
gvi...@niagaracollege.ca wrote:



Hi Jason,

I vote for having it restored.

Thanks!
Gordana

 Jason Etheridge ja...@esilibrary.com 12/14/2011 11:38
AM 
In EG 2.1, we--well, I, this was before we started doing
sign-offs--removed the call number column from the list in
the Check
In interface (in the name of fewer network calls and
improved
performance), and maybe should not have.  I know of at
least two
libraries that miss it.  How do others feel?

Should it be restored outright, or made into a configurable
option?

Thanks!

--
Jason Etheridge
| Equinox Software, Inc. / The Open Source Experts
| phone:  1-877-OPEN-ILS (673-6457)
| email:  ja...@esilibrary.com
| web:  http://www.esilibrary.com














[OPEN-ILS-GENERAL] Equinox offering two scholarships for the 2012 Code4Lib conference

2011-12-14 Thread Galen Charlton
[Please excuse the cross-posting.  Potential applicants should be aware 
of a new piece of information since the initial announcement: as part of 
our overall sponsorship of the conference, Equinox had one attendance 
slot that was reserved for an Equinox employee.  We are now using that 
slot in order to make the scholarship of benefit to somebody who would 
otherwise not be able to attend the conference.  If you meet the 
eligibility criteria and either didn't register for the conference yet 
or are on the waiting list, we encourage you to apply for the scholarship.]


Equinox Software is offering 2 scholarships to the code4lib conference 
in February.


The scholarships will reimburse travel and accommodation expenses up to 
$750.00 USD for a full-time employee from public libraries using either 
Evergreen or Koha to attend the Code4Lib Conference in Seattle, 
Washington, USA, from February 6-9, 2012.  The awardees will also 
receive (depending on their circumstances) free registration to Code4Lib 
or reimbursement of an already-paid registration.


ELIGIBILITY
The applicants must be presently working in a public library that is 
currently using or is actively committed to moving to either Evergreen 
or Koha as their ILS.


The applicants must indicate any amount and source of additional funding 
which, combined with the Scholarship, will permit them to cover their 
expenses to attend the Conference.  (This will not reduce the amount of 
the award.)


Preference will be given to underfunded libraries or libraries in budget 
crisis.


DEADLINE FOR APPLICATIONDecember 31, 2011

The email application should include a current resume, including all 
contact information, education, and experience, along with an essay as 
described below.


The applicants will write up to 750 words of narrative in English to 
address the following:
•Description of the library’s mission and commitment to open source 
solutions

•How attendance may benefit the applicant
•How the applicant intends to share the benefit of the experience 
with colleagues
•Description of funding constraints, budgetary limitations, or 
travel/hiring freezes pertinent to the applicant’s situation


APPLICATION ADDRESS: Please send resumes and essays to Grace Dunbar 
before December 31, 2011 by email attachment to c4lgr...@esilibrary.com


NOTIFICATION:   The successful applicants will be notified by January 5, 
2012.


Feel free to re-post this announcement and/or our press release 
(http://esilibrary.com/esi/newsitem.php?id=2182)


Regards,

Galen
--
Galen Charlton
Director of Support and Implementation
Equinox Software, Inc. / The Open Source Experts
email:  g...@esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org  
http://evergreen-ils.org