ReadiVoice Administration & Maintenance Guide
128 Proprietary & Confidential
Enabling Account Options Updating
With Account Options Updating enabled, you can use the Provisioning Stored
Procedure Interface (PSPI) to retrieve records of the account options changes
that your subscribers make (using the account options menu in the call flow).
This lets you update your customer management database through PSPI.
At this time, the Account Options Updating mechanism only records changes
made via DTMF commands; changes made through the Moderator aren’t
available.
This feature works as follows:
1 When a subscriber uses the account options menu (prior to conference) to
change a feature setting on his or her account, the ReadiVoice system
writes a record of that change to a special table,
AccOptChanges
(in
addition to updating the subscriber record, of course).
The
AccOptChanges
record identifies the subscriber, the time of the
change, the subscriber field that was changed, and its old and new values.
2 Using the
GetAccOptChanges
stored procedure (see the ReadiVoice PSPI
Reference), you retrieve the new options update records from the
AccOptChanges
table from time to time. This flags those records as
processed.
3 Periodically, you must run the
cleanAccOptChanges.pl
purge script to
delete the processed records from the
AccOptChanges
table.
To use this feature:
1 Review the
GetAccOptChanges
stored procedure description in the
ReadiVoice PSPI Reference and ensure that you have a process in place for
retrieving options update records from the
AccOptChanges
table.
2 In cnow’s
crontab
file, schedule the
cleanAccOptChanges.pl
purge
script to run every 24 to 48 hours. See “Purging the AccOptChanges
Table” on page 110 for details of how to use this script.
3 As user cnow, open the
.odprocrc
file for editing, and find the
[bridgeInt]
section. To enable the Account Options Updating feature,
set the
dtmfOptChanges
variable as follows:
Caution!
Don’t attempt to perform these tasks unless you’re an experienced Informix
database and UNIX system administrator. Perform the following procedure after
operational hours.
[bridgeInt]
...
dtmfOptChanges = 1