Re: [OPEN-ILS-GENERAL] Evergreen Reports Taskforce Meeting: December 14, 2011
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
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
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
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
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
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
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
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
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
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
[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