Home » Forums » Community Edition » trixbox projects

IVR MySQL response

9h1lo
Posts: 3
 Member Since:
2009-10-02
Submitted by 9h1lo on Fri, 10/02/2009 - 12:04pm.

Hi have a trixbox setup and am building a small database system for people to check their membership status with our ham radio group. I would like to ask for some suggestions to get on the right track.

Basically I want an incoming number (already set this up with a voip provider)...when a member calls this number they are asked to enter their membership number (via dtmf keypad) then I want asterisk to check this number against our mysql database and give a response on the phone just saying the status of that membership number.

‹ Block Most Telemarketers is speech to text possible? ›

&nbsp

SkykingOH
Posts: 9680
 Member Since:
2007-12-17
www.asteriskdocs.org This
Fri, 10/02/2009 - 12:19pm

www.asteriskdocs.org

This book containts great examples of what you are trying to do.

To add custom code to trixbox you place it in /etc/asterisk/extensions_custom.conf and the call it as a custom destination destination in PBXSettings:

IE: get-member-info,s,1 in custom destination field in custom destination module

Then your code in extensions_custom.conf

[get-member-info]
extension => s,1,answer()
extension => s,1,background(enter_mem_num)
extension => s,n.......
--

Scott

aka "Skyking"


&nbsp

abriosso
Posts: 1
 Member Since:
2008-06-06
ivr and database interaction
Sun, 05/16/2010 - 2:31pm

Hello Scott, I would like to make people register in the ivr and then do something like get a number.
for example... to be ask for number Id, then after registration, get a number to doctor´s schedule.
So my question is, Can you give me an idea about how would you do this? things to have in mind?

Thanks in advanced,
Albert


&nbsp

SkykingOH
Posts: 9680
 Member Since:
2007-12-17
I don't know how to answer
Sun, 05/16/2010 - 5:29pm

I don't know how to answer this question other than point you to the same book that I did in my last post.

You already said exactly what you want to do, now you have to write the program in Asterisk Extensions Language to perform the operations you describe.

If you have never written a computer program and don't have a basic understanding of SQL syntax you will have quite a learning curve.

--

Scott

aka "Skyking"


&nbsp

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.