Develop IVR application with MySQL

Are there some available IVR “templates” to get the gist of how the various tools are used and integrated? Specifically, more example of how to use the various elements, how to use Prompts and Actions and Variables – Without some examples it’s hard to envision how to make a detailed working system that nicely utilizes all the facilities (and ability to extend the system) you have provided.

I found some good basic examples of the proper use of VXML on your site. The TOD sample application. That’s good.

I’m specifically looking to see any samepl “complex” .IVR files that show the proper use of the various settings when using the IVR to rapid deploy a system. I think I’ll be using IVR Studio the most. It’s easy and I like that approach. Some pieces will also need to make calls out to a MySQL database to get data. That would probably use http requests and VXML.

Understanding the interplay of IVR Studio and integrating it with a Database…that’s what I’m trying to figure out. I have a nice database that I would like to have voice access to by telephone. There may also be some “posting” to a database about who called, when, what they accessed, etc. Sort of a “metadata” application to better understand what data people are accessing by phone, and when.

To develop your own IVR application using Voicent Gateway as a platform, you have two choices. One is at the VoiceXML level, and the other at a higher GUI level.

At the VXML level, you can take a look at the Gateway tutorials and sample applications. The Time-of-day is such a sample. This is the lowest level of application development, you will have the most flexibility, but does require a lot of coding.

At the GUI level, you use IVR Studio, where you draw a call flow diagram using elements and actions. At deployment time, this call diagram is automatically converted to VXML files.

Actually, there is a mixed approach. You can use IVR studio to generate the VXML files, and then edit them manually to add features that are currently not supported by IVR Studio. But we encourage you to contact us for suggestions. For example, the exception handling (call failed, etc) is not handled in the currect IVR Studio release, but we are planning to support that in future releases.

Use IVR Studio is the recommended way of developing your IVR applications. To learn the system, you can first start with the IVR Tutorial.

The IVR templates you mentioned are the sample IVR applications. They are included in the IVR Studio installation. You can access them from the Library menu from the program main menu.

For integration with MySQL database, you can use the Java action of IVR Studio. The Java action is a generic extension method, you can use that to do almost all software integrations possible. Your application is a typical IVR Studio application.