[OPEN-ILS-DEV] Proposed Submission to Evergreen Contrib - 30 day card expiration courtesy pre-notice

[Peters, Michael]

All,

After some feedback, it seems seeding the database with this script can be better achieved with just one SQL file.

This may be the better route to take should you test this in your environment.

Sincerely,
Michael Peters
Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
office - 317.234.2128
email - mrpeters at library.in.gov<mailto:mrpeters at library.in.gov>

From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Peters, Michael
Sent: Wednesday, January 19, 2011 1:09 PM
To: open-ils-dev at list.georgialibraries.org
Subject: [OPEN-ILS-DEV] Proposed Submission to Evergreen Contrib - 30 day card expiration courtesy pre-notice

Hi all,

Thanks to Chris Sharp for the great idea, and Steve Callender for helping to work out a few kinks.  Would certainly appreciate testing/feedback in hopes of inclusion in a future release.

This was created and tested for 1.6.0.0 system, but should work for later eversions.

Sincerely,
Michael Peters
Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk
office - 317.234.2128
email - mrpeters at library.in.gov<mailto:mrpeters at library.in.gov>

------------------------------

Courtesy Notice - Library Card Expiration pre-notice Action Trigger Event (for Evergreen)

Author: Michael Peters, Evergreen Indiana
                inspired by Chris Sharp, PINES

Copyright 2011
License: GNU Public License v 2.0 or later

Files:
        action_trigger_filters.json.example - example JSON for "expire" filter
        at.event_definition.sql                                  - SQL to add new Event Definition for card expire pre-notice
        at.hook.sql                                               - SQL to create "expire" hook
        at.environment.sql                                      - SQL to create environments for this triggered event
        at.event_params.sql                                     - Event Parameters for this triggered event
        DCO                                                      - Developer's Certificate of Origin
        README                                                   - this file

Prerequisites:
Evergreen 1.6.0.0 or higher
This document does not cover the configuration of other triggered events.
For a more in-depth tutorial see http://docs.evergreen-ils.org/1.6/draft/html/actiontriggers.html

Installation:

First, we will need to seed the database with the new hook and event definition.
Something like "psql -U evergreen < at.hook.sql" and "psql -U evergreen < at.event_definition", should suffice,
but syntax may differ based upon your environment.

First, we will need to seed the database with the new hook and event definition.
Something like "psql -U evergreen < at.hook.sql" and "psql -U evergreen < at.event_definition", should suffice,
but syntax may differ based upon your environment.

Next, we need to load the at.environment.sql and at.event_params.sql files using the same syntax from above.

Now, add the new json for the expire filter to your existing action_trigger_filters.json.example.

The new notice will be executed along with any existing triggered events you may already have scheduled upon the next run.

Note:  By default, the event is set to active.  You may wish to change this value via the database or staff client until
you're ready to begin sending email.  The notices are also set to be sent 30 days from the expire date.
You may also wish to modify this value via the at.event_definition.sql OR from within the staff client's Action/Trigger interface.

Special thanks to Steve Callender, Equinox Software for helping to debug!



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20110119/f614b159/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 30dayexpiration-rev2.tar
Type: application/x-tar
Size: 10240 bytes
Desc: 30dayexpiration-rev2.tar
Url : http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20110119/f614b159/attachment-0001.tar