thr3ads.net - asterisk users - [Asterisk-Users] Newbie IVR question [Aug 2003]

If this information is useful, please help other people find it:
Share via:

Josh Edwards

2003-Aug-31 13:39 UTC

[Asterisk-Users] Newbie IVR question

<html><div style='background-color:'><DIV>let me first
say this is an amazing product.</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>ok here is my question</DIV>
<DIV>&nbsp;</DIV>
<DIV>what I want to do is be able to have people call me and answar
questions. The answars to there questions would need to be stored in a mysql
database.</DIV>
<DIV>&nbsp;</DIV>
<DIV>so</DIV>
<DIV>&nbsp;</DIV>
<DIV>call comes in</DIV>
<DIV>&nbsp;</DIV>
<DIV>asterisks plays question</DIV>
<DIV>&nbsp;</DIV>
<DIV>asterisk waits for answar</DIV>
<DIV>&nbsp;</DIV>
<DIV>caller presses </DIV>
<DIV>3</DIV>
<DIV>&nbsp;</DIV>
<DIV>into a sql table goes (callerid,questionnum,3)</DIV>
<DIV>&nbsp;</DIV>
<DIV>on to next question.</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>Can this be done in asterisks, if so, can anyone point me in the
correct direction? howto's code examples etc</DIV></div><br
clear=all><hr> <a
href="http://g.msn.com/8HMXENUS/2755??PS="><b>Help protect
your PC:</b> Click here to go to the Mcafee.com free online virus
scan.</a> </html>

Jeremy McNamara

2003-Aug-31 13:50 UTC

head link

[Asterisk-Users] Newbie IVR question

Josh Edwards wrote:
> what I want to do is be able to have people call me and answar 
> questions. The answars to there questions would need to be stored in a 
> mysql database.
>  
Use AGI.  


Jeremy McNamara

Steven Critchfield

2003-Aug-31 13:54 UTC

head link

[Asterisk-Users] Newbie IVR question

On Sun, 2003-08-31 at 15:39, Josh Edwards wrote:> let me first say this is an amazing product.
>  
>  
> ok here is my question
>  
> what I want to do is be able to have people call me and answar
> questions. The answars to there questions would need to be stored in a
> mysql database.
>  
> so
>  
> call comes in
>  
> asterisks plays question
>  
> asterisk waits for answar
>  
> caller presses 
> 3
>  
> into a sql table goes (callerid,questionnum,3)
>  
> on to next question.
>  
>  
> Can this be done in asterisks, if so, can anyone point me in the
> correct direction? howto's code examples etc

If you are stuck on mysql, then you will need to do this in agi. If you
could do it in postgres, then there is the PSQL commands. 
-- 
Steven Critchfield <critch@basesys.com>

Josh Edwards

2003-Aug-31 14:07 UTC

head link

[Asterisk-Users] Newbie IVR question

<html><div style='background-color:'><DIV>
<P>Are there any examples for ther psql or agi scripts....can I use php
with<BR>agi....</P>
<P>Thanks </P>
<P>Josh</P>
<P>&nbsp;</P></DIV>
<DIV></DIV>>From: Steven Critchfield <CRITCH@BASESYS.COM>
<DIV></DIV>>Reply-To: asterisk-users@lists.digium.com 
<DIV></DIV>>To: asterisk-users@lists.digium.com 
<DIV></DIV>>Subject: Re: [Asterisk-Users] Newbie IVR question 
<DIV></DIV>>Date: 31 Aug 2003 15:54:53 -0500 
<DIV></DIV>> 
<DIV></DIV>>On Sun, 2003-08-31 at 15:39, Josh Edwards wrote: 
<DIV></DIV>> > let me first say this is an amazing product. 
<DIV></DIV>> > 
<DIV></DIV>> > 
<DIV></DIV>> > ok here is my question 
<DIV></DIV>> > 
<DIV></DIV>> > what I want to do is be able to have people
call me and answar
<DIV></DIV>> > questions. The answars to there questions would
need to be stored in a
<DIV></DIV>> > mysql database. 
<DIV></DIV>> > 
<DIV></DIV>> > so 
<DIV></DIV>> > 
<DIV></DIV>> > call comes in 
<DIV></DIV>> > 
<DIV></DIV>> > asterisks plays question 
<DIV></DIV>> > 
<DIV></DIV>> > asterisk waits for answar 
<DIV></DIV>> > 
<DIV></DIV>> > caller presses 
<DIV></DIV>> > 3 
<DIV></DIV>> > 
<DIV></DIV>> > into a sql table goes (callerid,questionnum,3) 
<DIV></DIV>> > 
<DIV></DIV>> > on to next question. 
<DIV></DIV>> > 
<DIV></DIV>> > 
<DIV></DIV>> > Can this be done in asterisks, if so, can
anyone point me in the
<DIV></DIV>> > correct direction? howto's code examples
etc
<DIV></DIV>> 
<DIV></DIV>> 
<DIV></DIV>>If you are stuck on mysql, then you will need to do
this in agi. If you
<DIV></DIV>>could do it in postgres, then there is the PSQL
commands.
<DIV></DIV>>-- 
<DIV></DIV>>Steven Critchfield <CRITCH@BASESYS.COM>
<DIV></DIV>> 
<DIV></DIV>>_______________________________________________ 
<DIV></DIV>>Asterisk-Users mailing list 
<DIV></DIV>>Asterisk-Users@lists.digium.com 
<DIV></DIV>>http://lists.digium.com/mailman/listinfo/asterisk-users
<DIV></DIV></div><br clear=all><hr> <a
href="http://g.msn.com/8HMXENUS/2740??PS="><b>Get MSN
8</b>  and enjoy automatic e-mail virus protection. </a>
</html>

Josh Edwards

2003-Aug-31 14:27 UTC

head link

[Asterisk-Users] Newbie IVR question

<html><div style='background-color:'><DIV>
<P>So I guess what i need is an agi app that goes is passed&nbsp;
callerid and ext</P>
<P>then does a "wait for digit"</P>
<P>&nbsp;</P>
<P>then writes (callerid,ext,<the digit>) to a database.</P>
<P>&nbsp;</P>
<P>&nbsp;</P>
<P>I do not know perl, so I guess my real question is, is this hard to
write, has anyone else done it?</P>
<P>Josh<BR></P></DIV>
<DIV></DIV>>From: Steven Critchfield <CRITCH@BASESYS.COM>
<DIV></DIV>>Reply-To: asterisk-users@lists.digium.com 
<DIV></DIV>>To: asterisk-users@lists.digium.com 
<DIV></DIV>>Subject: Re: [Asterisk-Users] Newbie IVR question 
<DIV></DIV>>Date: 31 Aug 2003 15:54:53 -0500 
<DIV></DIV>> 
<DIV></DIV>>On Sun, 2003-08-31 at 15:39, Josh Edwards wrote: 
<DIV></DIV>> > let me first say this is an amazing product. 
<DIV></DIV>> > 
<DIV></DIV>> > 
<DIV></DIV>> > ok here is my question 
<DIV></DIV>> > 
<DIV></DIV>> > what I want to do is be able to have people
call me and answar
<DIV></DIV>> > questions. The answars to there questions would
need to be stored in a
<DIV></DIV>> > mysql database. 
<DIV></DIV>> > 
<DIV></DIV>> > so 
<DIV></DIV>> > 
<DIV></DIV>> > call comes in 
<DIV></DIV>> > 
<DIV></DIV>> > asterisks plays question 
<DIV></DIV>> > 
<DIV></DIV>> > asterisk waits for answar 
<DIV></DIV>> > 
<DIV></DIV>> > caller presses 
<DIV></DIV>> > 3 
<DIV></DIV>> > 
<DIV></DIV>> > into a sql table goes (callerid,questionnum,3) 
<DIV></DIV>> > 
<DIV></DIV>> > on to next question. 
<DIV></DIV>> > 
<DIV></DIV>> > 
<DIV></DIV>> > Can this be done in asterisks, if so, can
anyone point me in the
<DIV></DIV>> > correct direction? howto's code examples
etc
<DIV></DIV>> 
<DIV></DIV>> 
<DIV></DIV>>If you are stuck on mysql, then you will need to do
this in agi. If you
<DIV></DIV>>could do it in postgres, then there is the PSQL
commands.
<DIV></DIV>>-- 
<DIV></DIV>>Steven Critchfield <CRITCH@BASESYS.COM>
<DIV></DIV>> 
<DIV></DIV>>_______________________________________________ 
<DIV></DIV>>Asterisk-Users mailing list 
<DIV></DIV>>Asterisk-Users@lists.digium.com 
<DIV></DIV>>http://lists.digium.com/mailman/listinfo/asterisk-users
<DIV></DIV></div><br clear=all><hr> <a
href="http://g.msn.com/8HMXENUS/2752??PS=">Enter for your chance to
IM with Bon Jovi, Seal, Bow Wow, or Mary J Blige using MSN Messenger</a>
</html>

Steven J. Sobol

2003-Sep-01 14:47 UTC

head link

[Asterisk-Users] Newbie IVR question

On Sun, 31 Aug 2003, Josh Edwards wrote:
> 
> Are there any examples for ther psql or agi scripts....can I use php
> with
> agi....
You most certainly can, but I recommend something more efficient like
c++ or perl, at least for any backend functions. 

That said, if you insist on using PHP for the backend or if you would
like to try to use PHP to create some web-based tools for configuring
*, I may be able to help.

-- 
JustThe.net Internet & Multimedia Services
22674 Motnocab Road * Apple Valley, CA 92307-1950 
Steve Sobol, Proprietor 
888.480.4NET (4638) * 248.724.4NET * sjsobol@JustThe.net

Apparently Analagous Threads

Search for more maybe matching threads

asterisk users - Aug 2003 - Newbie IVR question

[Asterisk-Users] Newbie IVR question

[Asterisk-Users] Newbie IVR question

[Asterisk-Users] Newbie IVR question

[Asterisk-Users] Newbie IVR question

[Asterisk-Users] Newbie IVR question

[Asterisk-Users] Newbie IVR question

Apparently Analagous Threads