IVR Database Connection
Voicemail Pro Installation and Maintenance Guide
Page 211
IP Office
15-601063 Issue 15b (31 May 2006)
Collect Callers Details
Details can be entered into a database by a caller. In this example we collect the caller's credit card
number, expiry date and telephone number. All these details are collected and then the database is
updated.
The example below shows the Specific tab entry used to collect the caller's telephone number and
assign it to the system variable CP4.
When all the details have been collected, the database needs to be updated. The database Execute
Action is used. When entering information into the specific tab for the first time you are taken through a
series of steps.
1. Select the Database Execute icon.
2. At the SQL Function window the option to 'Insert
…
values' was chosen as information needs to
be added to the database.
3. Details are then entered into the SQL Wizard, as shown below. When the Database table is
selected, the list of fields contained within the table is inserted.
4. When the details have been entered the SQL wizard is closed. The specific tab of the action will
contain the command to execute, see example shown below.
