Business Office Phone System

Telecommunications Consulting

Basic Actions Tab
Call List, Dial by Name and Conferencing Center Action
Logging in to Your Mailbox from a Different Location
Conditions Actions Tab
Configuration Actions Tab
Database Actions Tab
Queue Actions Tab
Mailbox Actions Tab
Miscellaneous Actions Tab
Post Dial Action, VB Script
Overview of Actions
Standard Action Tabs
Telephony Actions Tab
Basic Voicemail Pro (Compact) Software Installation
Introduction to Campaigns
Adding, Modifying & Deleting Campaigns
Centralized Voicemail Pro
Set Up Centralized Voicemail Pro
Changing SMTP and MAPI Settings

Voicemail Pro Components
Conditions
Available Condition Elements
The Voicemail Console
Customizing Auto Recording
Customizing Queuing
Start Points Voicemail Pro
Dial by Name Call Flow
System Preferences: Directories
Triggering Manual Call Recording

Wave Editor

Manager Index Pt1
Manager Index Pt2
Manager Index Pt3

Avaya IP Office

The Avaya IP Office platform is the ultimate in converged voice and data technology. IP Office brings a combination of voice and data applications formerly reserved for only the largest corporations. Cutting edge customer service with easy to use tools is now available to the smallest of businesses.

Database Actions Tab

Database Open Action

This action opens a link to a third party database. If connection to the database succeeds, the result is OK, otherwise the result is FAIL. If there is a connection to the database already then the current connection is closed and the new one requested will be opened.

• Note:
  The use of database actions with Voicemail Pro requires entry of a VMPro Database Interface license in the IP Office configuration.

Specific Tab:

• The connection string to open the database can be entered directly into the field. For help on constructing the connection string use the browse button to open the Data Link Properties form.

• Provider Tab:
  Select the OLE DB Provider of the data that is to be connected to. Click Next to move to the Connection Tab.

• Connection Tab:
  Specific information relating the Database provider needs to be completed. Help of the information required for each of the fields can be obtained by clicking the Help button. Fields available will be dependant on the type of provider. Test that the information entered will allow entry into the database, click the Test Connection button. A message Test Connection Succeeded will show if successfully connected to the database.

• Advanced Tab:
  Network Settings & other settings e.g. Access permissions. Fields showing will be dependant on the type of provider selected. Click help for specific information about any of the fields.

• All:
  The properties that have been selected on the previous tabs are shown in the All Tab. Amendments can be made as required by selecting the Name and click Edit Value.

Database Execute Action

This action performs an SQL query on a database opened a preceding Database Open action.

• Note: The use of database actions with Voicemail Pro requires entry of a VMPro Database Interface license in the IP Office configuration.

Specific Tab

• Command to Execute
  This box will contain the SQL query. This can either be entered directly or constructed using the SQL Wizard option.

Database Get Data Action

Once a query has been made against a database (see Database Execute Action), either a single result or a set of results are returned. This action will allow access to the data items if a set of results are returned.

• Note:
  The use of database actions with Voicemail Pro requires entry of a VMPro Database Interface license in the IP Office configuration.

Specific Tab

• There are four options on how the data can be retrieved.
• Retrieve the next item in the list:
  Allows the call flow to facilitate the stepping through of a list of results returned by the Database Execute action
• Retrieve the previous item in the list:
  Allows the call flow to facilitate the stepping through of a list of results returned by the Database Execute action
• Retrieve the first item in the list:
  Allows the call flow to facilitate jumping to the start of the list therefore returning all the items in the list.
• Retrieve the last item in the list:
  Allows the call flow to facilitate jumping to the end of the list therefore returning all the items in the list.

The Database Get Data action has the following possible results:

• Success:
  The current record has successfully been assigned to the $DBD variable.

• At End:
  You have reached the end of the list, the $DBD variable contains no information.

• Empty:
  The execute method returned no data, the $DBD variable contains no information.

• Failure:
  There was a problem trying to retrieve the next data record, the $DBD variable contains no information.

Database Close Action

This action will close the current database connection. If the database is open when a call terminates then a Database Close action is run automatically.

• Note:
  The use of database actions with Voicemail Pro requires entry of a VMPro Database Interface license in the IP Office configuration.