Just from my experence, it's a lot easier to write the whole logic, for a complex IVR in something (lua, perl, python, C#, F#) or anything else that FS supports, rather then trying to cram it in to the simple IVR application. Remember you can do foreign DB access or talk to anything else (web service, raw http service, etc...) from any of the languages directly.
 
I do almost all external interaction with C# modules, runnig inside of FS. Makes life real easy :)
 
--Dave


From: Brian Foster [mailto:bdfoster@davri.com]
To: FreeSWITCH Users Help [mailto:freeswitch-users@lists.freeswitch.org]
Sent: Sat, 18 May 2013 09:49:59 -0700
Subject: Re: [Freeswitch-users] Complex IVRs using data from MySQL

Whether or not you hand it back to mod_ivr or not, to set a channel variable in Lua:

session:setVariable("varname", "varvalue");

This has the same effect as using the set application in the dialplan:

<action application="set" data="varname=varvalue"/>

You can read the variable in Lua like this:

varname = session:getVariable("varname");

-BDF

On May 18, 2013 12:35 PM, "Telecube - John" <john@telecube.com.au> 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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org