[Freeswitch-users] Complex IVRs using data from MySQL

[Tim St. Pierre]

Hi John,

You can use xml_curl to build configuration for the simple IVR module on
the fly.

Every time the IVR application is called, there will be a configuration
request, and in the request data is the name of the IVR that was called.

You can run a server side script on your CURL server that will build the
relevant IVR configuration and send it back.  That's only one
transaction, and it's pretty light weight.

I'm not sure if it will work for your application or not, but I think it
would.  In our case, I have a table that is IVR menus (unique key,
timeout, what sounds to play, etc.)  I have another table that includes
all the entries, and what action to take on a match.  Any time an IVR is
called, it can lookup the ivr row to create the IVR, and then iterate
through all the entry rows to create all the options.

If you have multi-level IVR trees, just make sure that you return all
the IVRs that could be referenced through the sub menu action, so that
they are available as well.  There isn't a second config request when a
sub-menu is run.

Hope that helps!

-Tim

On 13-05-18 12:28 PM, Telecube - John wrote:
> Ok, if someone could point me in the right direction I would be very 
> grateful.
> 
> I need to integrate database lookups into multi level IVRs to gather 
> call routing info.
> 
> The lookups are for variable multi digit keypress data as well as 
> multiple sets of routing information.
> 
> So far I can see my options are xml_curl or hand the call off to a lua 
> script to handle the processing.
> 
> I can catch the multi digit keypresses with regex and give that detail 
> to a lua script, no problem.
> 
> I'm hoping to be able to use the mod_ivr process as much as possible but 
> I'm struggling to see how I can get data back into the call flow after 
> dishing the duty off to lua.
> 
> Can anyone point me down the right path please?
> 
> Should I be happy to pass it off to lua and finish the lookups and 
> routing in there?
> 
> Should I try to keep as much as possible in the core ivr?
> 
> Thanks..
> 
> - John
> 
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>