Retrieving Data from the Database | Avaya 15-601063 specs

8.2.1.2 Retrieving Data from the Database

The Bookshop_Welcome module allows callers to choose to search the database by either the books ISBN number or the author's name. The screen below shows the call flow module used when a search by ISBN is selected. The database actions that have been used are shown below the call flow diagram, with details on the following pages.

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

Image 338

Avaya 15-601063 manual Retrieving Data from the Database

Contents

IP Office Voicemail Pro IP Office Contents Using the Voicemail Pro Client Voicemail Pro Actions Appendix PromptsVoicemail Pro Examples Page Chapter Voicemail Pro Page ∙ Voicemail Pro Client ∙ IP Office Control Unit∙ Voicemail Pro Server ∙ Telephone Extension ∙ ContactStore Server ∙ Voicemail Email∙ Integrated Messaging Systems IMS ∙ Outcalling Configuration What is New∙ License and Service Status Display ∙ Upgrade Features of Voicemail Pro Feature Embedded Voicemail Lite Pro Supported Languages ∙ All Voicemail ∙ VoIP/VCM Channels Number of Simultaneous Voicemail Users∙ Voicemail Pro Licenses Page Chapter Installing Voicemail Pro Tips General Installation Requirements∙ Small Office Edition ∙ IP406 ∙ IP412 ∙ IP Office PC Specification Basic Voicemail Pro Not supported in caching mode Voicemail Pro plus IVR and or TTS Network Requirements ∙ Small Office Edition, IP406 V2 and IP500 Full duplex Voicemail Email Connection Disk Space RequirementsWeb Server Operation ContactStore Operation Voicemail Pro Licenses ∙ Voicemail is case sensitive User and Group Mailboxes∙ Mailboxes are based on names ∙ Voicemail removes spaces at the end of mailbox names Typical Installation Basic Voicemail InstallationCompact Installation Custom Installation Installing Compact Voicemail Pro Server and Client Before you begin Installing Voicemail Pro Basic Voicemail Installation To install compact Voicemail Pro Server and Client 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 Installing Custom Voicemail Pro Server and Client Removing Software Features from a Voicemail Pro Installation ∙ Extension Name campaigns Configuring Windows 2003 to Work with Web CampaignsTo configure Windows Close Services To Initialize the Voicemail Pro Call Flow Voicemail Pro ServicesTo check/restart the Voicemail Pro Service Click the Save and Make Live icon Using a Batch File to Start Services Client Only Installation Installing the VoiceMail Pro Client Only To install the Voicemail Pro Client only Voicemail Pro IP Office Upgrade from below version Upgrading Voicemail Pro To upgrade from version 3.2 or higher Upgrade from Version 3.2+Restore the Database Select Import Call Flows Move the Voicemail Lite Folders Upgrade to Voicemail ProSelect the Mailbox Mode Click Save & Make Live To install Voicemail Pro for Smtp Voicemail Email Voicemail Email InstallationInstalling VoiceMail Pro for Smtp Voicemail Email Smtp Simple Mail Transfer Protocol To create a Voicemail Domain Account Domain MemberCreating a Voicemail Domain Account Select Computer Management Local Users and Groups Groups Configuring Outlook for VoiceMail Email To configure Outlook for Voicemail Pro email Installing the VoiceMail Pro Software To install the Voicemail Pro software Click Preferences and select General Switching VoiceMail Pro to MapiTo switch Voicemail Pro to Mapi Click Save and Make Live To create a Voicemail User Account Work Group MemberCreating a Voicemail User Account Display name box enter Voicemail Configuring Outlook Express for Internet MailTo configure Outlook Express for Internet Mail Select Tools Options Configuring Outlook for Internet MailTo configure Outlook for Internet Mail Highlight Microsoft Exchange Server and click OK Configuring Outlook for Exchange ServerTo configure Outlook for Exchange Server Installing the VoiceMail Pro Software Switching VoiceMail Pro to Mapi Click the Email Settings tab Changing Smtp Email Account SettingsTo change Smtp Email Account Settings Operation Configuring Email Users and Groups for Voicemail EmailOther Phone Types and External Call Access IP Office Manager Settings How Voicemail Email Messages Look Voicemail Pro Email Action Smtp Error Codes Smtp ErrorsEnabling Smtp Error Reporting Enter SMTPLogging Centralized Voicemail Pro Planning Requirements Restrictions Licensing Configuring the Remote System Voicemail Settings To configure the remote system Voicemail settings Text to Speech TTS Install Using the Speak Text Action Installing Generic Text to SpeechInstalling Avaya Text to Speech To install Text to Speech Text to Speech Sapi Controls Entering XML Tags ∙ Examples Volume∙ Attributes ∙ level= Rate ∙ Attributes ∙ msec= SpellSilence Partofsp ∙ Select Tools Options ∙ Select Delegates Setting Up Text To Speech to Read EmailTo set up text to speech to read email ∙ Imap Client Support UMS Web Services∙ Web Voicemail Access ∙ UMS or IMS Imap Installation Select Help About ∙ Through Individual User SettingsSelect Web Service Users menu is shown Account Name PasswordIncoming Server Example Outlook Web Voicemail Installation ∙ o User Name and Password ∙ PC Playback Configuring the IP Office for Web Services Voicemail Pro IP Office Playback Control Opera Internet Explorer Installing Voicemail Pro UMS Web Services ∙ Unread message ∙ Read message ∙ Deleted message Using Web VoicemailMessage Types ∙ Saved message Installing Voicemail Pro UMS Web Services IP Office ∙ Save ∙ Change passwordControls ∙ Select ∙ Mark as read Using Imap Troubleshooting Checking the Voicemail Pro Service Installing Voicemail Pro Troubleshooting To run the service as a console Voicemail Console ∙ Clear ∙ Freeze∙ Run Voicemail Pro User Log Run DbgView.exe InstallationTracing in Debug Logging Run DbgView.exe Select File Log Preferences Is not required for diagnostics Close the Configure Debug Filters window IMS TracingIt is not required for diagnostics EnableConnectionTracing EnableProxyTracing EnableFunctionTracingEnableObjectTracing EnableTagTracing MessageProcessingTracing EnableTracingMAPIEventTracing UMSEventTracing Installing Voicemail Pro Troubleshooting IP Office Page Chapter Configuring Voicemail Pro Identifying the Voicemail Server PC IP Office ConfigurationOverview To identify the Voicemail Server PC · Select the Voicemail Email Mode from Configuring Voicemail for Individual UsersTo change voicemail configuration for an individual · Reception/Breakout Dtmf · Breakout Dtmf View the Source Numbers tab Configuring User Source NumbersTo add a source number Setting Up Voicemail Transfer Options for a User To set up voicemail transfer options for a user To change voicemail channel reservations Voicemail Channel ReservationsChannel Restrictions To view the utilisation of voicemail channels Voicemail Pro IP Office Using Voicemail to Give Error Messages To change the Voicemail Pro Server preferences Voicemail Pro PreferencesTo change the Voicemail Pro Client preferences Select IP Office Voicemail Pro System Preferences To set up general system preferencesFrom the Administration menu, select Preferences General General Click Save and Make Live and select Yes Directories To set the location of Voicemail system folders Mapi ∙ Automatic message deletion ∙ Message playback order System SettingHousekeeping ∙ Space OK Alarm Snmp AlarmTo set up disk space and recording time alarms ∙ Critical Alarm Outcalling To set the global outcalling preferences To add a Vpnm server VpnmTo open the VPN window Start the Voicemail Pro Client To delete a Vpnm server To add a user to Vpnm server To add a group of users To change details of a Vpnm user Control Panel Options To specify the level of IMS service loggingClick the System Settings tab IMS Logging Level IMS Host Server Name To specify the name of the host server PC for IMS To set the message parameters Configuring Email SettingsTo configure email settings Click the Smtp Email Settings tab Configuring Smtp Email SettingsTo configure Smtp email settings Fax Server Configuration Fax Server Configuration To set the Voicemail Pro system fax number Setting the VoiceMail Pro System Fax NumberSystem Fax Number is used to · Important Voicemail Pro IP Office To set up a user defined fax number Setting up Fax ForwardingSetting Up a User Defined Fax Number Example Routing Fax Calls Using a Menu Action Configuring an Analog Extension Number for Fax Use To configure an analog extension number for fax use Select Embedded Services Castelle Fax Server Configuring Voicemail Pro Fax Server Configuration IP Office Page Chapter Administration To start the Voicemail Pro Client Starting the Voicemail Pro ClientLogging in to the Voicemail Pro Server To log in to the Voicemail Pro Server Continue Offline Message Window Changing Between Offline and Online ModeTo switch between online and offline mode To log out Logging OutClosing Down To close the Voicemail Pro Client down To add an Administrator Administrator Configuration∙ Administrator Client user ∙ Standard Client user To delete an administrator Changing Administrator DetailsDeleting an Administrator To change the authority level of a user To reset a password Resetting a PasswordReleasing a Locked Administrator Login To release a locked login To change the inactivity timeout General AdministrationChanging the Inactivity Timeout Changing Mailbox Operation Mode To change the mailbox operation mode To change your password Changing your Password∙ Cancel Confirm Call Flow Download Window Routing Calls to Voicemail VM versus Short Codes? Routing Calls to Voicemail Transferring Calls to Voicemail Example 2 Access a Voicemail Pro Module Using Short Codes to Access VoicemailExample 1 Access to the Mailbox Main ∙ Example 2 Accessing a Module from Phone Manager Using VM to Access Voicemail∙ Example 1 SoftConsole access to the mailbox Main ∙ Example 3 Incoming Call Routing Voicemail Telephone Numbers Voicemail Pro IP Office Example Call Flow Voicemail Pro Module Using the Module Creating a Matching Short Code ∙ Using a Voicemail Collect button User Voicemail Access∙ Using the Messages button on their telephone ∙ Using Visual Voice Giving Users Button Access Administration User Voicemail Access To give all users access from any extension Giving Users Access from Any ExtensionTo give a specific user access from any extension ∙ An individual user To configure a trusted location Giving Users Access from an External LocationTo give users access from an external location Creating a Trusted Location ∙ Standard IP Office Mailbox Mode Mailbox Access ControlsTelephony Operation Mode ∙ Intuity Mailbox Mode Automatic Message Deletion Personal Distribution Lists ∙ Message Waiting Indication Hunt Group Voicemail∙ Messaging Hunt Group Configuration in IP Office To change voicemail configuration for a hunt group ∙ 4400 Series Phones Configuring Message Waiting IndicationTo configure message waiting indication ∙ Voicemail Ringback Check Broadcast Configuring Group BroadcastTo configure Group Broadcast Using a Short Code to Collect Voicemail Out of Hours Operation Configuring Announcements View the Announcements tab ∙ Voicemail Pro IP Office Mode ∙ Voicemail Pro Intuity Emulation Mode To customize announcement 2 for a specific group Customizing AnnouncementsTo customize announcement 1 for a specific group ∙ Normalize Queue Length Default = Blank To configure queuing for a hunt group∙ Queuing On Default = On Hunt Group Queuing Customizing a Hunt Group Call Flow Administration Hunt Group Voicemail Recording Calls Call Recording Warning Advice of Call Recording MessageTo switch the recording warning on or off Click Save & Make Live To hide the auto record indication Voice Recording Library VRL Click or select Administration Preferences GeneralChanging the Recording Time To change the recording length Manual Call Recording To use the short code Select the Voice Recording tab Setting Manual Recording OptionsTo configure a users recording options Customizing Manual Recording Hunt Group Automatic Call RecordingIncoming Call Route User Setting Automatic Recording Options To set automatic call recording for a user 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 Announcements Mandatory Announcement Example Personal Announcements Support for Callers with Impaired Hearing Changing User Locale Installing Voicemail Pro TTY PromptsAdvice for Mailbox Owners Using a TTY Device To change the user locale Changing the Language Setting for a TTY Device An Example of Customizing a Simple Mailbox Call Flow An Example of Customizing a Complex Mailbox Call Flow Changing Language Supported Languages Changing the Language of System Prompts Changing the Language of Custom Prompts To change the language of custom prompts Mobile Twinning ∙ CFGSet MattR twinningtype Mobile · Enter the command CFGSet 203 mobiletwinningnumber$KEY · Enter the command CFGSet 203 twinningtype Mobile· Enter the command CFGSet 203 twinningtype Internal To create the example call flow Create a short code to test the call flow Remote Voicemail Notification ∙ Voicemail Outcalling To set up the callback Callback To set the users callback number Using a Play Configuration Menu ActionDefault Callback Start Point · Callback Number Outcalling Setting the Outcalling Preferences Voicemail Pro IP Office Chapter Using the Voicemail Pro Client ∙ Conditions Editor ∙ Actions∙ Modules Main Voicemail Pro Window Toolbar Icons Saving Changes and Making them Live Importing and Exporting Call Flows Including Other Files To include other files Users Start PointsSpecific Start Points Groups ∙ Short Code *88 ∙ Telephone Number *88 Voicemail Pro AdministratorsShort Codes Modules Default Start Points 246 Using Start Points To rename a user, group or short code start point Viewing Call Flows as Text To view a start point or module as text Variable Length System VariablesSpeaking Variables to Callers ∙ $DBD Available Variables ∙ $CLI∙ $CP ∙ $ETA User Defined Variables To add a user defined variable Example Creating Modules Running a Module Conditions Editor Not To add a new condition Using the Condition EditorTo start the Condition Editor To add elements to a condition To edit elements To change the name of a condition To change the logic setting of a condition· x or To delete elements and conditions To add a calendar element Calendar∙ Apply Logical or X if more than one day selected Click Calendar Example Click Week Planner Example Week PlannerTo add a Week Planner element To add a condition element ConditionCompare Click Condition Chapter Voicemail Pro Actions To delete an action To add an actionTo edit an action To delete a connection ConnectionsTo add a connection Basic Actions Available Actions∙ Start Point Voicemail Pro Actions Available Actions ∙ Test User Variable Action ∙ Token Name Standard Action TabsGeneral ∙ Description Entry Prompts To select a prompt Using the Wave EditorTo record a new prompt Voicemail Pro IP Office ∙ Flag the current call has been answered by Voice Mail SpecificReporting ∙ Request to call back the current caller Results Basic Actions Generic Voicemail Pro Actions Basic Actions Example of a Custom String For examples of the action being used in a call flow, see Speak Text To add a Speak Text action Menu ∙ Others ∙ Timeout∙ Invalid Goto To add a Goto action Module Return DisconnectHome To add a Disconnect action Mailbox Actions Get Mail ∙ IP Office mode∙ Intuity mode To add a Get Mail action Leave Mail Listen To add a Listen action Voice Question · Leave campaign information e.g. customers CampaignTo add a campaign action Configuration Actions Edit Play List Record Name Play Configuration Menu For a user For a hunt group · Possible system prompts · Installed on the ServerSelect System Prompt Language Telephony Actions · Does the Variable match any of the following numbers Variable Routing· Select a Variable Results To add a Route Incoming Call action Route Incoming CallRoute by Call Status · Description displayed on phone Voicemail Pro 4.1+ Transfer· Destination · Notify caller of transfer to target Voicemail Pro 4.1+ Whisper Call List Dial by Name Conferencing Center Assisted Transfer MS-CRM Call Data Tagging Additional Examples Alphanumeric ∙ Dtmf Data ∙ No Dtmf Data Miscellaneous Actions Voicemail Pro IP Office Open Door Alarm Set Clock Post Dial · Expand VB Script· Enter VBScript · Syntax Check Remote Call Flow Condition Actions Test Condition ∙ Return the results of the following condition Set User Variable Test User Variable Test Variable ∙ No Match Database Actions Database Open Database Execute Database Get Data Database Close Queue Actions To add a Queue ETA action Queue ETA∙ In Incoming Call Route Priority Queue Position Voicemail Pro IP Office Chapter Prompts Prompts US English Intuity 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 English Non-Intuity Prompts WAV File Non-Intuity Prompt 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 Using VB Script Voicemail Pro Examples Internal Variables VBScript PropertiesOverview ∙ String CallingParty PropertyEstimatedAnswer Property LastAccessedMsg Property Locale Property OldMsgs Property Name PropertyNewMsgs Property PositionInQueue Property Result Property Variable Property SavedMsgs PropertySavedResult Property ForwardMsgToMailbox Method VBScript MethodsForwardMsg Method FullFilename Method GetCallingParty Method GetDTMF Method GetEstimatedAnswer Method GetMailbox Method GetExtension MethodGetLocale Method GetMailboxMessage Method GetMailboxMessages Method GetMessageStatus Method GetMessagePriority MethodGetMessagePrivate Method GetOldMsgs Method GetName MethodGetNewMsgs Method GetResult Method GetPositionInQueue MethodGetRegister Method GetVariable Method GetSavedMsgs MethodGetSavedResult Method MessageLength Method MessageCLI MethodMessageDisplay Method MessageTime Method PlayDigits Method PlayLocaleWav Method PlayWav Method Key = Voice.PlayWavtest, True, Any, dlgid End if End Sub RecordMsg Method RecordRegister Method Register Method SetLocale Method SetMailboxMessage Method SetRegister Method SetVariable Method SetResult MethodSetSavedResult Method Speak Method IVR Connecting Voicemail Pro to a Database Example Database Scenario Retrieving Data from the Database Database Open Action Database Execute Action Database Get Data Action Returning Data from the Database Speak Book Title Entering Details into the Database Confirm Book Details Collect Callers Details Select the Database Execute icon Dial by Name To add a short code From Telephony Actions the Dial by name action was addedFrom Mailbox Actions a Leave Mail action was added Adding a Record Name Module To add a Shortcode Changing Full Names Using the Name TableTo changing your name using a telephone with a menu Key To use the Name table Campaigns Managing Campaigns Voicemail Pro IP Office Customer Prompts Customer Menu Campaign Identification Granting Access to a Campaign∙ Where should this Campaign be parked To use the UnPark Call function To assign a campaign to a programmable button· Select Emulation Call Park Select Advanced Call UnPark Call Using the Web Campaign To view open the Campaign Web Campaign Voicemail Pro IP Office Voicemail Pro Examples Campaigns Voicemail Pro IP Office Chapter Appendix ∙ Required Network and Exchange Server Knowledge Installing IMS∙ Playing Messages Through the PC IMS Limitations IMS Components Minimum PC specification for an IMS Client PC IMS Client PC Requirements IMS Server PC Requirements IMS Server Installation Installation Checks Creating the IMS Account On the Mail Properties General Screen, click Add IMS Server Preparation Disable Network Card Power Saving 100Mbps Full duplex IP Office 500 Smart Card Feature Key USB or Parallel Port Feature KeySerial Port Feature Key Entering the IMS Licenses Installing the IMS and Voicemail Pro Software To install the IMS and Voicemail Pro Software · Important Voicemail Pro IP Office IP Office Voicemail Pro System Settings window opens IP Office Voicemail Pro Path Settings window opens Voicemail Pro IP Office Select Administrative Tools Services Check the IMS ServicesTo check/restart the Voicemail Pro and IMS Services Close Services Initializing the Call Flow Select Start Programs IP Office Voicemail Pro Client To associate a voice mailbox with an email address Close the IMS Administration ToolAssociating Voice Mailboxes with Email Addresses IMS Client Installation IMS Client Requirements Adjusting Dcom Settings To set the Client PCs Dcom Settings B2a. Setting the Changes in a Dcom Security Policy Appendix Installing IMS Click OK Repeat this process for all Dcom entries B2b. Dcom Settings for a Windows 2000 PC Select Start Run Click on the Default Security tab Appendix Installing IMS B2c. Dcom Settings for XP Pro SP2 and Windows 2003 SP1 PCs Click on Component Services. and then Computers Appendix Installing IMS Voicemail Pro IP Office On the Default Properties tab set the following · Voicemail Mailbox Installing the IMS Client SoftwareTo install the IMS Client software · IMS Server Unzip AvayaFW.bat from the AvayaFW.zip file Settings for Other FirewallsOpening the Firewall Testing IMS Client Installation Outlook, select Tools Integrated Messaging 397 To Manually Install the Form Expand the Server Name and Mailbox Store Observing Exchange OperationTo check and observe IMS operation Maintenance Upgrading To upgrade from version Import or Export Call Flows window, click Next IMS Service Logging IMS Host Server Name IMS Email Settings ∙ Check Batch Job Permissions Troubleshooting Dcom Issues∙ Enable Auditing Tracing in Debug IMS Debugging EnableTracing IMS Installation Alternatives ∙ IMS Gateway Service ∙ IMS Voice Service Problems Connecting to/Synchronizing with IMS Known IssuesProblems Connecting to IMS on a Domain Controller On the Server Cause Unspecified ErrorSolution Outlook Cached Exchange Mode Transferring an IMS Account to a New PC IMS Client Not Showing in Outlook Tools Firewall Port Settings VMPro Error Windows Update Causes Voicemail Pro to Stop Saving IMS Messages Past Housekeeping IMS Clients Not Connecting When Outlook Opened Outlook Delegates Cause IMS to Slow To set up the batch file Starting IP Office Services Using a Batch FileMessage Waiting Indicators Not Clearing Installing VoiceMail Pro as an ACM Gateway To install the ACM Gateway Appendix Installing VoiceMail Pro as an ACM Gateway Installing Networked Messaging Vpnm Requirements for Vpnm Installing VoiceMail Pro with Vpnm Support To install Voicemail Pro Software with Vpnm support ∙ Important Voicemail Pro IP Office Configuring Vpnm Preferences To add a user to Vpnm server To add a group of users Testing a Vpnm Setup To test the Vpnm setup IP Office to Avaya Interchange Configuring the Avaya Intuity AudixTo configure the Avaya Intuity Audix Configuring the Avaya Interchange To configure the Interchange Intuity interface Appendix IP Office to Avaya Interchange Avaya Interchange Enterprise List Administration Configuring a DNS Server Verification and Troubleshooting Audix Browser Status Test Check the Voicemail Pro Smtp SettingsInterchange Basic Tests 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