I am in the need to script an IVR based on ODBC instead of static confs.
This is because it will be connected to an CRM/ERP and should be managed by non-tech users.
Most of the time I script dialplans using AEL, maybe someone tries something similar and shares his thoughts (?).
AEL and Conf are very similar, this would not be a problem for me.
I browsed some docs and it looks like, I better build it on AMI/FastAGI using Python.
PS: AEL is worth a look. The code is much cleaner and there are no priorities needed (which is a key feature of Conf-syntax). I wonder why this has not become the default language,
It’s best to take an organic approach. And you’re already part of the way there.
Since you are creating your IVR script manually, now you should identify the common factors.
Where is the repetition
Where are the unique values
Then… you can translate this information into database queries.
I will not go into the pros and cons of AEL, but you may find AMI or AGI work better to interact with the dialplan.
You can find some details how I did it here.
I used AGI() and python, and you’re welcome to look at the code