Data Base

Data Base

Postby alicia » Sun Jun 22, 2014 5:08 pm

I need to setup an IVR which play a welcome message and ask the customer for a code.
After that, the IVR shall query a MySQL DB to retrive some customer order information.

Is it possibile to do it with Shuttle?
alicia
 
Posts: 8
Joined: Sun Jun 22, 2014 4:06 pm

Re: Data Base

Postby Shuttle Team » Sun Jun 22, 2014 5:17 pm

Hello Alicia,

You can use Cally Square, available inside the xCALLY Shuttle interface: it includes the possibility to connect to external DB (MySQL or via ODBC) and to use the DB IVR box to make all the queries you need.
See also here for more information:
http://www.callysquare.com/documentatio ... se_example

You can perform any queries and call procedures according to standard php sintax.

Remember the result of your DB query will be stored inside an array, so if you choose the variable RESULTSET to store the query result, you will need to look here to get the datum:
RESULTSET[#row][field_name]

i.e.
RESULTSET[0][order_number]

Cheers
xCALLY Shuttle TEAM
User avatar
Shuttle Team
 
Posts: 84
Joined: Mon Jun 16, 2014 3:14 pm


Return to Cally Square

Who is online

Users browsing this forum: No registered users and 1 guest

cron