Voicemail Pro Examples: Database Connection

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 call 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 Installation and Maintenance

Page 373

IP Office Release 6

15-601063 Issue 22e (16 May 2010)

Page 373
Image 373
Avaya 6 manual Collect Callers Details, Select the Database Execute icon