[Koha-bugs] [Bug 4246] Koha support for Itiva Talking Tech phone notification service

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4246

--- Comment #2 from Kyle M Hall <kyle.m.hall at gmail.com> 2012-03-01 14:05:44 UTC ---
Created attachment 7964
  --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=7964
Implements support for Talking Tech I-tiva phone notification for OVERDUE,
PREDUE and HOLD notifications.  Overdues respect triggers as configured for the
patron's branch.  Predue and Holds notifications respect patron's messaging
preference choices.  A n

Record of phone messages being sent to patrons is added to the patron's Notices
tab; notice of success or failure can be retrieved from I-tiva.

See the TalkingTech.README for installation and set-up instructions.

Aside from the control system preference, and the necessary changes to
Messaging Preferences
forms to make use of phone notifications, the bulk of the code resides in
external
cronjobs.

TalkingTech_itiva_outbound.pl generates the Spec C file to send to I-tiva. 
Actual transmission
of the file must be handled by the system administrator.

TalkingTech_itiva_inbound.pl processes the received Results file from I-tiva. 
Getting the
file from I-tiva to Koha is the job of the system administrator, as well.

Both scripts have a --help option with full documentation.

The only necessary change to core Koha behavior is in
C4::Letters::EnqueueLetter.  The return
value was changed from 0 or 1 (successful addition of letter to message_queue
or not), to the actual
insert ID of the letter.  This was required by the outbound script to present a
unique Transaction ID
for the notice added to the patron's record (so a 'sent' or 'failed' status
could be updated).  Since
the dbh and sth are not shared, and the last_insert_id() command is
table-specific, this should be thread-safe.
No changes are necessary to any parts of Koha, as all usage of EnqueueLetter
currently ignores the return value.

To Test:

1. Turn on TalkingTechItivaPhoneNotification system preference
2. Verify that 'phone' is now a valid notification option for patrons on both
staff and OPAC side
3. Attempt to set a 'phone' preference for PREDUE or HOLD messaging; attempt
should succeed
4. Set up the patron for notices to triggers:
   a. include checked out items due in a range of days, including the value set
up in their messaging preferences.
   b. place several holds, some in position, others waiting for pickup, others
in transit.
   c. set the patron up to have overdues, overdue by a range of days that
includes the delay values for
the patrons branch and categorycode
5. Run TalkingTech_itiva_outbound.pl --type=RESERVE --type=PREOVERDUE
--type=OVERDUE --outfile=/tmp/talkingtechtest.csv

The resulting talkingtechtest.csv file should include all the items due on X
days (where X is the patrons' preference),
and none of the ones due in other increments.  Similarly, overdues messages
should be added for each item due by a delay
value as configured; overdues of other numbers of days should be ignore.  Holds
that are waiting pick up or in transit should
have messages, those still pending should not.

Messages should be added to the patron's notices tab for each issue sent. 
Verify these messages exist, and all Notices
tokens are replaced with appropriate information.

Repeat, this time with 4c making use of the default branch overdue triggers,
instead of branch-specific triggers.

To test the inbound script, create a CSV with rows in the format
"<<Message_id>>","<<SUCCESS or FAIL>>"
Message ID should correspond to the final column of the talkingtechtest.csv
file (the transaction id) for the message.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.
You are watching all bug changes.