Avaya 15-601063 manual Collect Callers Details, Select the Database Execute icon

Voicemail Pro Examples: IVR: Connecting Voicemail Pro to a Database

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.

Voicemail Pro	Page 345
IP Office	15-601063 Issue 20l (03 March 2009)