Мы предполагаем, что вам понравилась эта презентация. Чтобы скачать ее, порекомендуйте, пожалуйста, эту презентацию своим друзьям в любой соц. сети. Кнопочки находятся чуть ниже. Спасибо.
Идет загрузка презентации. Пожалуйста, подождите
Презентация была опубликована
3 года назад
© 2009 Avaya Inc. All rights reserved.1 Chapter Three, Voic Pro Advanced Functions Module Two – Database and IVR
© 2009 Avaya Inc. All rights reserved.2 Module Introduction This module provides participants details for Voic Pro Integrated Voice Response (IVR) features including: Integration with 3 rd party database programs Using TTS functions with database interactions Call Data Tagging Troubleshooting?
© 2009 Avaya Inc. All rights reserved.3 Interactive Voice Response (IVR) overview With the IVR features of Voic Pro custom automated systems can be created to allow customers to interact with business information. For example, – Account query systems – Order processing – Ticket purchasing – Reservation status – Front end system to a help / support desk
© 2009 Avaya Inc. All rights reserved.4 IVR overview - continued IVR functions can be constructed using call flow actions using the standards based ActiveX data objects (ADO) interface. Structured Query Language (SQL) scripts are used to read and write database information. Information retrieved from a database can be assigned to any system or user defined variable for use at other points within the call flow.
© 2009 Avaya Inc. All rights reserved.5 Database pre-requisites Voic Pro database interaction is enabled with the Advanced Edition license. (the legacy VMPro Database Interface license may be used) If the database being queried resides on the voic server, the speed of the query will be affected by the amount of memory available. Take into account the memory requirements of the database being queried. The playback of voice prompts and the use of TTS requires the Windows Audio components to be present and enabled on the server PC. Enabling Windows Audio does not require the server PC to have a sound card installed.
© 2009 Avaya Inc. All rights reserved.6 Database types The Voic Pro software includes the Microsoft Data Access Components (MDAC) to access most third-party databases. OLE DB (Object Linking and Embedding Database) is an API designed by Microsoft for accessing data without requiring access to the specific database engines such as Oracle, SQL Server or Sybase. OLE DB is part of the MDAC stack. OLE DB is conceptually divided into two parts: – Consumers: applications that need access to the data – Providers: software component that implements the interface and provides the data to the consumer The Microsoft Jet 4.0 OLE DB Provider is the default database engine for Microsoft Access
© 2009 Avaya Inc. All rights reserved.7 Database Demonstration Create new database OR Demonstrate existing database
© 2009 Avaya Inc. All rights reserved.8 Database Actions The following are the Voic Pro actions that can be used to interact with databases: Database Open – initiates a link to a database and authenticates the connection. If a database connection already exists, the existing link is closed in order to open a connection for this action Database Execute – executes a SQL query to read or write data to an open database Database Get Data – determines which data to use in the event multiple records are returned from the SQL query and provides an option if no data is returned Database Close – closes the database connection, if a call terminates the Database Close action runs automatically
© 2009 Avaya Inc. All rights reserved.9 Database Open action Click on the ellipsis of the Specific tab to open the Data Link Properties Click on the Provider tab Select the appropriate option for the database type Click on Next >>
© 2009 Avaya Inc. All rights reserved.10 Database Open action - continued Click on the ellipsis to select the database file or type in the name of the file including the full path If required, enter the database login credentials: – User name – Password Blank password Allow Saving password Click on Test Connection
© 2009 Avaya Inc. All rights reserved.11 Database Open action - continued Access permissions – Read = read only – ReadWrite = read and write – Share Deny Read = neither read nor write access is denied to others – Share Deny Write = prevents others from opening in read mode – Share Exclusive = prevents others from opening in read/write mode – Write = write only Click on Help for details of all option on the Advanced tab
© 2009 Avaya Inc. All rights reserved.12 Database Execute Clicking on the Specific tab of the Database Execute action invokes the SQL Wizard and confirms the information from the Database Open action (click on Next to continue)
© 2009 Avaya Inc. All rights reserved.13 Database Execute - continued The Command to execute can be typed directly in the space provided on the Specific tab using the SQL query language. Ensure that any data included in the query matches the data type (number, integer or text) of the field being queried. For example, if $KEY is used to query a text field it should be enclosed by quotation marks (e.g. $KEY)
© 2009 Avaya Inc. All rights reserved.14 Database Execute - continued The SQL Wizard can be used to build the query through a series of menus with drop down boxes for tables, fields and relational operators (=, ,, =, Contains and Starts with). Multiple criteria can be entered in the query by using the logical functions AND and OR. The resulting SQL command for this query is: SELECT name FROM Student Where (custom_nr = $KEY)
© 2009 Avaya Inc. All rights reserved.15 Database Get Data The Database Get Data action is used to determine which records should be used from the results of the Database Execute action. The values returned are stored into the call flows $DBD variables.
© 2009 Avaya Inc. All rights reserved.16 Database system variables A set of six database variables ($DBD to $DBD) are used to store information extracted from the database query. Information is stored in the variables based on the order of the fields chosen in SELECT statement of the Database Execute action. $DBD = End_Date $DBD = Location $DBD = Start_Date $DBD = Title
© 2009 Avaya Inc. All rights reserved.17 Database Close The Database Close action will close the current database connection. If the database is open when a call terminates, then a Database Close action is run automatically. There are no configurable options for this action.
© 2009 Avaya Inc. All rights reserved.18 IVR call variable use There are 16 variables ($CP0 to $CP15) used to store call parameters for the duration of a call within a call flow. Values can be written into these variables using the Generic action free format command (e.g. CP0:$DBD)
© 2009 Avaya Inc. All rights reserved.19 IVR call variable use - continued The Select Generic command may be used to store database values as an alternative free format command (e.g. CP0:$DBD) by using drop down selections.
© 2009 Avaya Inc. All rights reserved.20 IVR call variable use - continued The Speak Text action allows the stored Database variables and other Call variables to be spoken to the caller.
© 2009 Avaya Inc. All rights reserved.21 Call Data Tagging Values contained in call variables can be displayed on telephones using the Transfer or Assisted Transfer actions.
© 2009 Avaya Inc. All rights reserved.22 Condition Editor The Condition Editor Compare element is used examine the value of Call Variable to a fixed value or another Call Variable. The state (True or False) of the element is determined based on the following options: Equal to: (Value A = Value B) Not equal to: (A =! B) Less than: (A < B) Greater than: (A > B) Less than or equal to: (A = B)
© 2009 Avaya Inc. All rights reserved.23 Compare element and Data Tagging example This is an example of a call flow that retrieves data from a database, compares the results using the Test Condition action and routes the call based on the results of the action. For example, if the account balance is greater than or equal to 0, use TTS to speak the balance. If not, transfer the caller to the Collections hunt group with Call Data Tagging.
© 2009 Avaya Inc. All rights reserved. Troubleshooting Methodology Record prompts at various locations to determine where call flow is failing Check database for spaces in anything other than fields Verify ports are available – Voic Ports – Data Channels – TTS ports Use Debug View to capture a trace of a failing call flow 24
© 2009 Avaya Inc. All rights reserved.1 Chapter Two, VoiceMail Pro Components Module Two – Actions, Variables & Conditions.
© 2009 Avaya Inc. All rights reserved.1 Chapter Three, VoiceMail Pro Advanced Functions Module Four – Voicemail Campaigns.
© 2009 Avaya Inc. All rights reserved.1 Chapter Three, VoiceMail Pro Advanced Functions Module One – Text to Speech.
© 2009 Avaya Inc. All rights reserved.1 Chapter Three, VoiceMail Pro Advanced Functions Module Three – TAPI.
© 2009 Avaya Inc. All rights reserved.1 Chapter Four, UMS Web Services Module One – UMS.
© 2009 Avaya Inc. All rights reserved.1 Chapter Four, UMS Web Services Module Two – IMAP Service.
© 2009 Avaya Inc. All rights reserved.1 Chapter One, Getting Started Module Four – Setup and Functionality.
© 2009 Avaya Inc. All rights reserved.1 Chapter One, Getting Started Module Two – First Steps.
© 2009 Avaya Inc. All rights reserved.1 Chapter Nine, VoiceMail Pro in SCN Module Four – Distributed VoiceMail Pro.
© 2009 Avaya Inc. All rights reserved.1 Chapter Four, UMS Web Services Module Three – Exchange 2007.
© 2009 Avaya Inc. All rights reserved.1 Chapter Nine, VoiceMail Pro in SCN Module Three – Backup VoiceMail Pro.
© 2005 Cisco Systems, Inc. All rights reserved.INTRO v2.19-1 Managing Your Network Environment Managing Cisco Devices.
© 2009 Avaya Inc. All rights reserved.1 Chapter One, Getting Started Module Three - Installation Requirements.
© 2009 Avaya Inc. All rights reserved.1 Chapter Seven, Customer Call Reporter (CCR) Module Two – Standard Configuration.
© 2006 Avaya Inc. All rights reserved. Embedded File Management and SD-Card Handling.
© 2005 Cisco Systems, Inc. All rights reserved. IPTX v2.04-1 Configuring Additional Cisco CallManager Express Features Configuring Cisco CallManager Express.
© 2006 Avaya Inc. All rights reserved. Using File Management and SD-Card Handling.
© 2005 Cisco Systems, Inc. All rights reserved. BGP v3.23-1 Route Selection Using Policy Controls Applying Route-Maps as BGP Filters.
© 2006 Avaya Inc. All rights reserved. VoiceMail Pro Structure of Call Flows VoiceMail Pro Structure of Call Flows.
© 2005 Cisco Systems, Inc. All rights reserved. IPTX v2.04-1 Configuring Additional Cisco CallManager Express Features Defining TAPI Support for Cisco.
Еще похожие презентации в нашем архиве:
© 2017 MyShared Inc. All rights reserved.