Example, Database Scenario | Avaya 15-601063 specification

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

8.2.1 Example

8.2.1.1 Database Scenario

In this call flow example, an auto-attendant has been created to allow callers to order books. The book details are held within a Microsoft Access database. Callers will be able to enter either the ISBN or Author's name. The title and cost of the item will be looked up allowing the caller to purchase the item if they wish to. If the caller purchases the book they will be able to enter their credit card details and a contact number.

Example of the database used in the call flow.

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

Image 337

Avaya 15-601063 manual Example, Database Scenario

Contents

IP Office Voicemail Pro IP Office Contents Voicemail Pro Actions Using the Voicemail Pro Client Voicemail Pro Examples PromptsAppendix Page Chapter Voicemail Pro Page ∙ Voicemail Pro Server ∙ IP Office Control Unit∙ Voicemail Pro Client ∙ Telephone Extension ∙ Integrated Messaging Systems IMS ∙ Voicemail Email∙ ContactStore Server ∙ License and Service Status Display What is New∙ Outcalling Configuration ∙ Upgrade Feature Embedded Voicemail Lite Pro Features of Voicemail Pro ∙ All Voicemail Supported Languages ∙ Voicemail Pro Licenses Number of Simultaneous Voicemail Users∙ VoIP/VCM Channels Page Chapter Installing Voicemail Pro ∙ Small Office Edition ∙ IP406 ∙ IP412 ∙ IP Office General Installation RequirementsTips PC Specification Basic Voicemail Pro Not supported in caching mode Voicemail Pro plus IVR and or TTS ∙ Small Office Edition, IP406 V2 and IP500 Full duplex Network Requirements Web Server Operation Disk Space RequirementsVoicemail Email Connection ContactStore Operation Voicemail Pro Licenses ∙ Mailboxes are based on names User and Group Mailboxes∙ Voicemail is case sensitive ∙ Voicemail removes spaces at the end of mailbox names Compact Installation Basic Voicemail InstallationTypical Installation Custom Installation Before you begin Installing Compact Voicemail Pro Server and Client To install compact Voicemail Pro Server and Client Installing Voicemail Pro Basic Voicemail Installation Voicemail Pro IP Office Installing Typical Voicemail Pro Server and Client To install typical Voicemail Pro Server and Client Installing Voicemail Pro Basic Voicemail Installation Removing Software Features from a Voicemail Pro Installation Installing Custom Voicemail Pro Server and Client To configure Windows Configuring Windows 2003 to Work with Web Campaigns∙ Extension Name campaigns To check/restart the Voicemail Pro Service Voicemail Pro ServicesClose Services To Initialize the Voicemail Pro Call Flow Click the Save and Make Live icon Using a Batch File to Start Services Client Only Installation To install the Voicemail Pro Client only Installing the VoiceMail Pro Client Only Voicemail Pro IP Office Upgrading Voicemail Pro Upgrade from below version Restore the Database Upgrade from Version 3.2+To upgrade from version 3.2 or higher Select Import Call Flows Select the Mailbox Mode Upgrade to Voicemail ProMove the Voicemail Lite Folders Click Save & Make Live Installing VoiceMail Pro for Smtp Voicemail Email Voicemail Email InstallationTo install Voicemail Pro for Smtp Voicemail Email Smtp Simple Mail Transfer Protocol Creating a Voicemail Domain Account Domain MemberTo create a Voicemail Domain Account Select Computer Management Local Users and Groups Groups To configure Outlook for Voicemail Pro email Configuring Outlook for VoiceMail Email To install the Voicemail Pro software Installing the VoiceMail Pro Software To switch Voicemail Pro to Mapi Switching VoiceMail Pro to MapiClick Preferences and select General Click Save and Make Live Creating a Voicemail User Account Work Group MemberTo create a Voicemail User Account To configure Outlook Express for Internet Mail Configuring Outlook Express for Internet MailDisplay name box enter Voicemail To configure Outlook for Internet Mail Configuring Outlook for Internet MailSelect Tools Options To configure Outlook for Exchange Server Configuring Outlook for Exchange ServerHighlight Microsoft Exchange Server and click OK Installing the VoiceMail Pro Software Switching VoiceMail Pro to Mapi To change Smtp Email Account Settings Changing Smtp Email Account SettingsClick the Email Settings tab Other Phone Types and External Call Access Configuring Email Users and Groups for Voicemail EmailOperation IP Office Manager Settings How Voicemail Email Messages Look Voicemail Pro Email Action Enabling Smtp Error Reporting Smtp ErrorsSmtp Error Codes Enter SMTPLogging Centralized Voicemail Pro Restrictions Planning Requirements Licensing To configure the remote system Voicemail settings Configuring the Remote System Voicemail Settings Text to Speech TTS Install Installing Avaya Text to Speech Installing Generic Text to SpeechUsing the Speak Text Action To install Text to Speech Entering XML Tags Text to Speech Sapi Controls ∙ Attributes ∙ level= Volume∙ Examples Rate Silence Spell∙ Attributes ∙ msec= Partofsp To set up text to speech to read email Setting Up Text To Speech to Read Email∙ Select Tools Options ∙ Select Delegates ∙ Web Voicemail Access UMS Web Services∙ Imap Client Support ∙ UMS or IMS Imap Installation Select Web Service Users menu is shown ∙ Through Individual User SettingsSelect Help About Incoming Server PasswordAccount Name Example Outlook Web Voicemail Installation ∙ PC Playback ∙ o User Name and Password Configuring the IP Office for Web Services Voicemail Pro IP Office Opera Playback Control Internet Explorer Installing Voicemail Pro UMS Web Services Message Types Using Web Voicemail∙ Unread message ∙ Read message ∙ Deleted message ∙ Saved message Installing Voicemail Pro UMS Web Services IP Office Controls ∙ Select ∙ Change password∙ Save ∙ Mark as read Using Imap Checking the Voicemail Pro Service Troubleshooting Installing Voicemail Pro Troubleshooting Voicemail Console To run the service as a console ∙ Run ∙ Freeze∙ Clear Voicemail Pro User Log Tracing in Debug InstallationRun DbgView.exe Logging Run DbgView.exe Select File Log Preferences It is not required for diagnostics Close the Configure Debug Filters window IMS TracingIs not required for diagnostics EnableConnectionTracing EnableObjectTracing EnableFunctionTracingEnableProxyTracing EnableTagTracing MAPIEventTracing EnableTracingMessageProcessingTracing UMSEventTracing Installing Voicemail Pro Troubleshooting IP Office Page Chapter Configuring Voicemail Pro Overview IP Office ConfigurationIdentifying the Voicemail Server PC To identify the Voicemail Server PC To change voicemail configuration for an individual Configuring Voicemail for Individual Users· Select the Voicemail Email Mode from · Reception/Breakout Dtmf · Breakout Dtmf To add a source number Configuring User Source NumbersView the Source Numbers tab To set up voicemail transfer options for a user Setting Up Voicemail Transfer Options for a User Channel Restrictions Voicemail Channel ReservationsTo change voicemail channel reservations To view the utilisation of voicemail channels Voicemail Pro IP Office Using Voicemail to Give Error Messages To change the Voicemail Pro Client preferences Voicemail Pro PreferencesTo change the Voicemail Pro Server preferences Select IP Office Voicemail Pro From the Administration menu, select Preferences General To set up general system preferencesSystem Preferences General Click Save and Make Live and select Yes To set the location of Voicemail system folders Directories Mapi Housekeeping ∙ Message playback order System Setting∙ Automatic message deletion To set up disk space and recording time alarms Snmp Alarm∙ Space OK Alarm ∙ Critical Alarm To set the global outcalling preferences Outcalling To open the VPN window Start the Voicemail Pro Client VpnmTo add a Vpnm server To delete a Vpnm server To add a user to Vpnm server To change details of a Vpnm user To add a group of users Click the System Settings tab To specify the level of IMS service loggingControl Panel Options IMS Logging Level To specify the name of the host server PC for IMS IMS Host Server Name To configure email settings Configuring Email SettingsTo set the message parameters To configure Smtp email settings Configuring Smtp Email SettingsClick the Smtp Email Settings tab Fax Server Configuration Fax Server Configuration System Fax Number is used to Setting the VoiceMail Pro System Fax NumberTo set the Voicemail Pro system fax number · Important Voicemail Pro IP Office Setting Up a User Defined Fax Number Setting up Fax ForwardingTo set up a user defined fax number Example Routing Fax Calls Using a Menu Action To configure an analog extension number for fax use Configuring an Analog Extension Number for Fax Use Castelle Fax Server Select Embedded Services Configuring Voicemail Pro Fax Server Configuration IP Office Page Chapter Administration Logging in to the Voicemail Pro Server Starting the Voicemail Pro ClientTo start the Voicemail Pro Client To log in to the Voicemail Pro Server To switch between online and offline mode Changing Between Offline and Online ModeContinue Offline Message Window Closing Down Logging OutTo log out To close the Voicemail Pro Client down ∙ Administrator Client user Administrator ConfigurationTo add an Administrator ∙ Standard Client user Deleting an Administrator Changing Administrator DetailsTo delete an administrator To change the authority level of a user Releasing a Locked Administrator Login Resetting a PasswordTo reset a password To release a locked login Changing the Inactivity Timeout General AdministrationTo change the inactivity timeout To change the mailbox operation mode Changing Mailbox Operation Mode ∙ Cancel Changing your PasswordTo change your password Confirm Call Flow Download Window VM versus Short Codes? Routing Calls to Voicemail Transferring Calls to Voicemail Routing Calls to Voicemail Example 1 Access to the Mailbox Main Using Short Codes to Access VoicemailExample 2 Access a Voicemail Pro Module ∙ Example 1 SoftConsole access to the mailbox Main Using VM to Access Voicemail∙ Example 2 Accessing a Module from Phone Manager ∙ Example 3 Incoming Call Routing Voicemail Telephone Numbers Voicemail Pro IP Office Voicemail Pro Module Example Call Flow Creating a Matching Short Code Using the Module ∙ Using the Messages button on their telephone User Voicemail Access∙ Using a Voicemail Collect button ∙ Using Visual Voice Giving Users Button Access Administration User Voicemail Access To give a specific user access from any extension Giving Users Access from Any ExtensionTo give all users access from any extension ∙ An individual user To give users access from an external location Giving Users Access from an External LocationTo configure a trusted location Creating a Trusted Location Telephony Operation Mode Mailbox Access Controls∙ Standard IP Office Mailbox Mode ∙ Intuity Mailbox Mode Personal Distribution Lists Automatic Message Deletion ∙ Messaging Hunt Group Voicemail∙ Message Waiting Indication To change voicemail configuration for a hunt group Hunt Group Configuration in IP Office To configure message waiting indication Configuring Message Waiting Indication∙ 4400 Series Phones ∙ Voicemail Ringback To configure Group Broadcast Configuring Group BroadcastCheck Broadcast Using a Short Code to Collect Voicemail Out of Hours Operation View the Announcements tab Configuring Announcements ∙ Voicemail Pro Intuity Emulation Mode ∙ Voicemail Pro IP Office Mode To customize announcement 1 for a specific group Customizing AnnouncementsTo customize announcement 2 for a specific group ∙ Queuing On Default = On To configure queuing for a hunt group∙ Normalize Queue Length Default = Blank Hunt Group Queuing Customizing a Hunt Group Call Flow Administration Hunt Group Voicemail Recording Calls To switch the recording warning on or off Advice of Call Recording MessageCall Recording Warning Click Save & Make Live To hide the auto record indication Changing the Recording Time Click or select Administration Preferences GeneralVoice Recording Library VRL To change the recording length Manual Call Recording To use the short code To configure a users recording options Setting Manual Recording OptionsSelect the Voice Recording tab Customizing Manual Recording Incoming Call Route Automatic Call RecordingHunt Group User To set automatic call recording for a user Setting Automatic Recording Options To set automatic call recording for a hunt group To set automatic call recording for an incoming call route To set automatic call recording for an outgoing account call Customizing Auto Recording Mandatory Announcement Example Announcements Personal Announcements Support for Callers with Impaired Hearing Advice for Mailbox Owners Using a TTY Device Installing Voicemail Pro TTY PromptsChanging User Locale To change the user locale An Example of Customizing a Simple Mailbox Call Flow Changing the Language Setting for a TTY Device An Example of Customizing a Complex Mailbox Call Flow Supported Languages Changing Language Changing the Language of System Prompts To change the language of custom prompts Changing the Language of Custom Prompts ∙ CFGSet MattR twinningtype Mobile Mobile Twinning · Enter the command CFGSet 203 twinningtype Internal · Enter the command CFGSet 203 twinningtype Mobile· Enter the command CFGSet 203 mobiletwinningnumber$KEY To create the example call flow Create a short code to test the call flow ∙ Voicemail Outcalling Remote Voicemail Notification Callback To set up the callback Default Callback Start Point Using a Play Configuration Menu ActionTo set the users callback number · Callback Number Outcalling Setting the Outcalling Preferences Voicemail Pro IP Office Chapter Using the Voicemail Pro Client ∙ Modules ∙ Actions∙ Conditions Editor Main Voicemail Pro Window Toolbar Icons Importing and Exporting Call Flows Saving Changes and Making them Live To include other files Including Other Files Specific Start Points Start PointsUsers Groups Short Codes Voicemail Pro Administrators∙ Short Code *88 ∙ Telephone Number *88 Modules 246 Default Start Points Using Start Points To rename a user, group or short code start point To view a start point or module as text Viewing Call Flows as Text Speaking Variables to Callers System VariablesVariable Length ∙ $CP Available Variables ∙ $CLI∙ $DBD ∙ $ETA To add a user defined variable User Defined Variables Example Running a Module Creating Modules Not Conditions Editor To start the Condition Editor Using the Condition EditorTo add a new condition To edit elements To add elements to a condition · x or To change the logic setting of a conditionTo change the name of a condition To delete elements and conditions ∙ Apply Logical or X if more than one day selected CalendarTo add a calendar element Click Calendar Example To add a Week Planner element Week PlannerClick Week Planner Example Compare ConditionTo add a condition element Click Condition Chapter Voicemail Pro Actions To edit an action To add an actionTo delete an action To add a connection ConnectionsTo delete a connection ∙ Start Point Available ActionsBasic Actions Voicemail Pro Actions Available Actions ∙ Test User Variable Action General Standard Action Tabs∙ Token Name ∙ Description Entry Prompts To record a new prompt Using the Wave EditorTo select a prompt Voicemail Pro IP Office Reporting Specific∙ Flag the current call has been answered by Voice Mail ∙ Request to call back the current caller Results Basic Actions Generic Voicemail Pro Actions Basic Actions For examples of the action being used in a call flow, see Example of a Custom String To add a Speak Text action Speak Text Menu ∙ Invalid ∙ Timeout∙ Others To add a Goto action Goto Home DisconnectModule Return To add a Disconnect action Mailbox Actions ∙ Intuity mode ∙ IP Office modeGet Mail To add a Get Mail action Leave Mail To add a Listen action Listen Voice Question To add a campaign action Campaign· Leave campaign information e.g. customers Configuration Actions Record Name Edit Play List For a user For a hunt group Play Configuration Menu Select System Prompt Language · Installed on the Server· Possible system prompts Telephony Actions · Select a Variable Variable Routing· Does the Variable match any of the following numbers Results Route by Call Status Route Incoming CallTo add a Route Incoming Call action · Destination Transfer· Description displayed on phone Voicemail Pro 4.1+ · Notify caller of transfer to target Voicemail Pro 4.1+ Whisper Call List Dial by Name Conferencing Center Assisted Transfer Additional Examples MS-CRM Call Data Tagging Alphanumeric ∙ No Dtmf Data ∙ Dtmf Data Miscellaneous Actions Voicemail Pro IP Office Open Door Clock Alarm Set Post Dial · Enter VBScript VB Script· Expand · Syntax Check Remote Call Flow Condition Actions ∙ Return the results of the following condition Test Condition Set User Variable Test User Variable Test Variable ∙ No Match Database Actions Database Execute Database Open Database Close Database Get Data Queue Actions ∙ In Incoming Call Route Priority Queue ETATo add a Queue ETA action Queue Position Voicemail Pro IP Office Chapter Prompts US English Intuity Prompts Prompts Prompts US English Intuity Prompts 290 June First name Message will be private and priority To or forward the message press Name not found Order in which they have been received You are specifying the telephone number of a fax machine Voicemail Pro IP Office Prompts US English Intuity Prompts Voicemail Pro IP Office WAV File Non-Intuity Prompt English Non-Intuity Prompts To forward, press 0 to pause, press * to rewind Prompts English Non-Intuity Prompts To the previous menu press RECNAM02 Svm26 Timm01 One minute Timm02 Minutes Voicemail Pro IP Office Chapter Voicemail Pro Examples Voicemail Pro Examples Using VB Script Overview VBScript PropertiesInternal Variables EstimatedAnswer Property CallingParty Property∙ String Locale Property LastAccessedMsg Property NewMsgs Property Name PropertyOldMsgs Property Result Property PositionInQueue Property SavedResult Property SavedMsgs PropertyVariable Property ForwardMsg Method VBScript MethodsForwardMsgToMailbox Method GetCallingParty Method FullFilename Method GetEstimatedAnswer Method GetDTMF Method GetLocale Method GetExtension MethodGetMailbox Method GetMailboxMessages Method GetMailboxMessage Method GetMessagePrivate Method GetMessagePriority MethodGetMessageStatus Method GetNewMsgs Method GetName MethodGetOldMsgs Method GetRegister Method GetPositionInQueue MethodGetResult Method GetSavedResult Method GetSavedMsgs MethodGetVariable Method MessageDisplay Method MessageCLI MethodMessageLength Method PlayDigits Method MessageTime Method PlayLocaleWav Method PlayWav Method Key = Voice.PlayWavtest, True, Any, dlgid End if End Sub RecordRegister Method RecordMsg Method SetLocale Method Register Method SetRegister Method SetMailboxMessage Method SetSavedResult Method SetResult MethodSetVariable Method Speak Method IVR Connecting Voicemail Pro to a Database Database Scenario Example Retrieving Data from the Database Database Open Action Database Execute Action Database Get Data Action Returning Data from the Database Speak Book Title Confirm Book Details Entering Details into the Database Select the Database Execute icon Collect Callers Details Dial by Name From Mailbox Actions a Leave Mail action was added From Telephony Actions the Dial by name action was addedTo add a short code To add a Shortcode Adding a Record Name Module To changing your name using a telephone with a menu Key Using the Name TableChanging Full Names To use the Name table Campaigns Managing Campaigns Voicemail Pro IP Office Customer Prompts Customer Menu ∙ Where should this Campaign be parked Granting Access to a CampaignCampaign Identification · Select Emulation Call Park To assign a campaign to a programmable buttonTo use the UnPark Call function Select Advanced Call UnPark Call To view open the Campaign Web Campaign Using the Web Campaign Voicemail Pro IP Office Voicemail Pro Examples Campaigns Voicemail Pro IP Office Chapter Appendix ∙ Playing Messages Through the PC Installing IMS∙ Required Network and Exchange Server Knowledge IMS Limitations IMS Components IMS Client PC Requirements Minimum PC specification for an IMS Client PC IMS Server PC Requirements Installation Checks IMS Server Installation On the Mail Properties General Screen, click Add Creating the IMS Account IMS Server Preparation 100Mbps Full duplex Disable Network Card Power Saving Serial Port Feature Key USB or Parallel Port Feature KeyIP Office 500 Smart Card Feature Key Entering the IMS Licenses To install the IMS and Voicemail Pro Software Installing the IMS and Voicemail Pro Software · Important Voicemail Pro IP Office IP Office Voicemail Pro Path Settings window opens IP Office Voicemail Pro System Settings window opens Voicemail Pro IP Office To check/restart the Voicemail Pro and IMS Services Check the IMS ServicesSelect Administrative Tools Services Close Services Select Start Programs IP Office Voicemail Pro Client Initializing the Call Flow Associating Voice Mailboxes with Email Addresses Close the IMS Administration ToolTo associate a voice mailbox with an email address IMS Client Requirements IMS Client Installation To set the Client PCs Dcom Settings Adjusting Dcom Settings B2a. Setting the Changes in a Dcom Security Policy Appendix Installing IMS Click OK Repeat this process for all Dcom entries Select Start Run B2b. Dcom Settings for a Windows 2000 PC Click on the Default Security tab Appendix Installing IMS Click on Component Services. and then Computers B2c. Dcom Settings for XP Pro SP2 and Windows 2003 SP1 PCs Appendix Installing IMS Voicemail Pro IP Office On the Default Properties tab set the following To install the IMS Client software Installing the IMS Client Software· Voicemail Mailbox · IMS Server Opening the Firewall Settings for Other FirewallsUnzip AvayaFW.bat from the AvayaFW.zip file Outlook, select Tools Integrated Messaging Testing IMS Client Installation 397 To Manually Install the Form To check and observe IMS operation Observing Exchange OperationExpand the Server Name and Mailbox Store Upgrading Maintenance Import or Export Call Flows window, click Next To upgrade from version IMS Service Logging IMS Host Server Name IMS Email Settings ∙ Enable Auditing Troubleshooting Dcom Issues∙ Check Batch Job Permissions Tracing in Debug IMS Debugging EnableTracing ∙ IMS Gateway Service ∙ IMS Voice Service IMS Installation Alternatives Problems Connecting to IMS on a Domain Controller Known IssuesProblems Connecting to/Synchronizing with IMS On the Server Solution Unspecified ErrorCause Transferring an IMS Account to a New PC Outlook Cached Exchange Mode IMS Client Not Showing in Outlook Tools VMPro Error Firewall Port Settings Saving IMS Messages Past Housekeeping Windows Update Causes Voicemail Pro to Stop Outlook Delegates Cause IMS to Slow IMS Clients Not Connecting When Outlook Opened Message Waiting Indicators Not Clearing Starting IP Office Services Using a Batch FileTo set up the batch file To install the ACM Gateway Installing VoiceMail Pro as an ACM Gateway Appendix Installing VoiceMail Pro as an ACM Gateway Installing Networked Messaging Vpnm Requirements for Vpnm To install Voicemail Pro Software with Vpnm support Installing VoiceMail Pro with Vpnm Support ∙ Important Voicemail Pro IP Office Configuring Vpnm Preferences To add a user to Vpnm server To add a group of users To test the Vpnm setup Testing a Vpnm Setup To configure the Avaya Intuity Audix Configuring the Avaya Intuity AudixIP Office to Avaya Interchange To configure the Interchange Intuity interface Configuring the Avaya Interchange Appendix IP Office to Avaya Interchange Avaya Interchange Enterprise List Administration Verification and Troubleshooting Configuring a DNS Server Interchange Basic Tests Check the Voicemail Pro Smtp SettingsAudix Browser Status Test S8100 Ping Test Appendix IP Office to Avaya Interchange Voicemail Pro Page Index Callflow COM Date Twenty First September 329 DB 203 Dtmff EnableFunctionTracing 91 Help press IMS Client Requirements Voicemail Pro IP Office BLF ITU LOC MSCRM-ACT NIC POS Regmultisz Sapi XML Steve Smith Systemroot 377 VAR Select 173 WINNT/SYSTEM32 YEAR/MONTH/DAY Hour Page Voicemail Pro IP Office Voicemail Pro IP Office