Posted: Fri Feb 24, 2006 12:31 am Post subject: [Asterisk-Users] How to query a table from the keypad?
I am trying to give users the option to query our accts. payable database by supplying their PO number. I able to write queries via perl->DBI->mysql but have no idea how to get * to do it from the IVR. Is this possible? Can anyone point me in the right direction for help or examples?
Thanks,
Richard
What are the most popular cars? Find out at [url=http://us.rd.yahoo.com/evt=38382/_ylc=X3oDMTEzNWFva2Y2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDMmF1dG9z/*http://autos.yahoo.com/newcars/popular/thisweek.html ]Yahoo! Autos[/url]
You could write a perl script to read the PO number from stdin and spit back the balance (or whatever). To read the PO number from the user, use the Read() dialplan application. To play back the balance, you could use SayDigits() (but there’s probably a more elegant solution specifically for speaking amounts of money).
I am trying to give users the option to query our accts. payable database by supplying their PO number. I able to write queries via perl->DBI->mysql but have no idea how to get * to do it from the IVR. Is this possible? Can anyone point me in the right direction for help or examples?
Thanks,
Richard
What are the most popular cars? Find out at Yahoo! Autos
Of course you will want to put in place all the error traps and when
using this function I always have a check in my hangup routine to make
sure I close the open mysql connection. So at the end of the above
dialplan, you should have the value you want in the AMOUNT-DUE variable.
You could write a perl script to read the PO number from stdin and
spit back the balance (or whatever). To read the PO number from the
user, use the Read() dialplan application. To play back the balance,
you could use SayDigits() (but there’s probably a more elegant
solution specifically for speaking amounts of money).
I am trying to give users the option to query our accts. payable
database by supplying their PO number. I able to write queries via
perl->DBI->mysql but have no idea how to get * to do it from the IVR.
Is this possible? Can anyone point me in the right direction for help
or examples?
What are the most popular cars? Find out at Yahoo! Autos
<http://us.rd.yahoo.com/evt=38382/_ylc=X3oDMTEzNWFva2Y2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDMmF1dG9z/*http:/autos.yahoo.com/newcars/popular/thisweek.html%20%0d%0a>
Posted: Sun Feb 26, 2006 6:27 pm Post subject: [Asterisk-Users] How to query a table from the keypad?
What kind of overhead do agi put on? Are they that much worst than running
mysql addon functions?
|-----Original Message-----
|From: asterisk-users-bounces@lists.digium.com
|[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of
|Chris A. Icide
|Sent: Sunday, February 26, 2006 12:23 PM
|To: Asterisk Users Mailing List - Non-Commercial Discussion
|Subject: Re: [Asterisk-Users] How to query a table from the keypad?
|
|Or you could skip the overhead associated with an AGI and use
|the dialplan command availabe after installing asterisk-addons MYSQL.
|
|exten => _X.,1,Read(PO-NUMBER,enter-yr-po-num)
|exten => _X.,2,MYSQL(Connect connid <dbhost> <dbuser> <dbpass>
|<dbname>) exten => _X.,3,MYSQL(Query resultid ${connid} SELECT
|balance FROM account-payables WHERE po_num=${PO-NUMBER}) exten
|=> _X.,4,MYSQL(Fetch fetch ${resultid} AMOUNT-DUE) exten =>
|_X.,5,MYSQL(Clear ${resultid})
|
|Of course you will want to put in place all the error traps
|and when using this function I always have a check in my
|hangup routine to make sure I close the open mysql connection.
|So at the end of the above dialplan, you should have the value
|you want in the AMOUNT-DUE variable.
|
|-Chris
|
|Mike Pollitt wrote:
|>
|> Hi Richard -
|>
|> What you want is AGI:
|> http://www.voip-info.org/tiki-index.php?page=Asterisk+AGI
|>
|> You could write a perl script to read the PO number from stdin and
|> spit back the balance (or whatever). To read the PO number from the
|> user, use the Read() dialplan application. To play back the balance,
|> you could use SayDigits() (but there's probably a more elegant
|> solution specifically for speaking amounts of money).
|>
|>
|----------------------------------------------------------------------
|> --
|>
|> *From:* asterisk-users-bounces@lists.digium.com
|> [mailto:asterisk-users-bounces@lists.digium.com] *On Behalf Of
|> *Richard Reina
|> *Sent:* Friday, 24 February 2006 9:34 AM
|> *To:* asterisk-users@lists.digium.com
|> *Subject:* [Asterisk-Users] How to query a table from the keypad?
|>
|> I am trying to give users the option to query our accts. payable
|> database by supplying their PO number. I able to write queries via
|> perl->DBI->mysql but have no idea how to get * to do it from the IVR.
|> Is this possible? Can anyone point me in the right direction
|for help
|> or examples?
|>
|> Thanks,
|>
|> Richard
|>
|>
|----------------------------------------------------------------------
|> --
|>
|>
|> What are the most popular cars? Find out at Yahoo! Autos
|>
|<http://us.rd.yahoo.com/evt=38382/_ylc=X3oDMTEzNWFva2Y2BF9TAzk3MTA3MDc
|>
|2BHNlYwNtYWlsdGFncwRzbGsDMmF1dG9z/*http:/autos.yahoo.com/newcars/popul
|> ar/thisweek.html%20%0d%0a>
|>
|>
|>
|----------------------------------------------------------------------
|> --
|>
|> _______________________________________________
|> --Bandwidth and Colocation provided by Easynews.com --
|>
|> Asterisk-Users mailing list
|> To UNSUBSCRIBE or update options visit:
|> http://lists.digium.com/mailman/listinfo/asterisk-users
|>
|
|
|_______________________________________________
|--Bandwidth and Colocation provided by Easynews.com --
|
|Asterisk-Users mailing list
|To UNSUBSCRIBE or update options visit:
| http://lists.digium.com/mailman/listinfo/asterisk-users
|
|
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
Of course you will want to put in place all the error traps and when
using this function I always have a check in my hangup routine to make
sure I close the open mysql connection. So at the end of the above
dialplan, you should have the value you want in the AMOUNT-DUE variable.
You could write a perl script to read the PO number from stdin and
spit back the balance (or whatever). To read the PO number from the
user, use the Read() dialplan application. To play back the balance,
you could use SayDigits() (but there’s probably a more elegant
solution specifically for speaking amounts of money).
I am trying to give users the option to query our accts. payable
database by supplying their PO number. I able to write queries via
perl->DBI->mysql but have no idea how to get * to do it from the IVR.
Is this possible? Can anyone point me in the right direction for help
or examples?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum