I have built dynamic menus in CVP VXML Studio using the results of a database query to control the menu structure. This was in a banking application where an identified customer (ID and PIN) has a number of different accounts and the application wants to present a menu for the user to choose the account to operate on. The database query returns the list of accounts and I constructed a menu like:
For account ending in 1234, press 1.
For account ending in 4567, press 2.
For account ending in 5678, press 3.
and so on. Once the account is selected, the next operation could be accomplished (balance, transfer etc).
Another possibility is to hand off all processing to the database, with a loop in CVP VXML, using session variables. I've done something similar with a Web service, where all the logic was in the Web server and the CVP app was just a one page shell, but I haven't tried what I am about to describe. I'm thinking you could do something like this.
Query the database to get the starting WAV file to play, which represents the top-level menu. The database query also returns a code that tells the app whether to continue, or break the loop.
SELECT WaveFile, Break FROM Menu WHERE UserInput='top'
If Break=0, use the resulting wave file in a "get single digit" element and get the digit they entered. Then loop back to the top and call the DB query again with that digit. Say they choose "1".
SELECT WaveFile, Break FROM Menu WHERE UserInput='1'
The database returns the name of the WAV file to play next (the sub-menu under 1 in the top-level menu) and the application fetches another digit. Append this digit to the first one and around it goes to the DB query again. Say they choose 2.
SELECT WaveFile, Break FROM Menu WHERE UserInput='12'
You would have to deal with all possible inputs in the database table - sometimes the WAV file would be an error message and the loop-break variable would be set to 1 and you'd be done. If Break=1, instead of using a "get single digit" element you would have a simple audio element and play the WAV file. Could be an error message or silence - either way, the menu is over.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...