IP IVR - Query to a DB as a Phone Service

[Juan Carlos Arias Perez]

I already develop a script for IP IVR to access a DB on MS SQL 2005 which is working very good.  But I was wondering if I could do this same task to make a query to the DB using a Phone service, in the xml mode, is this possible??  Can I use the same script or have to develop another one??

If the answer is yes, give some ideas, commands or anything to look at, it will be very helpful your help.

Regards,

[Aaron Harrison]

Hi

Sure, you can, in theory.. the phones basicaly retrieve info over HTTP (so you'll need HTTP triggers) and display only specificcally formatted XML objects (more detail here

http://developer.cisco.com/web/ipps/home)

You can have both types of contacts (HTTP/Telephony) in one script, just determine what type the contact is with get contact info, and then don't send http stuff to a telephony contact or vice versa.

Regards

Aaron

[Gergely Szabo]

Hi,

... and of course, you can also use UCCX (Premium or IP IVR) to act as a server for IP Phone Services. Take a look at this document if you are interested: https://supportforums.cisco.com/docs/DOC-27750

So for instance, it would be very easy to set up a directory on the IP phone if you have the contacts in an SQL capable database.

G.

[Juan Carlos Arias Perez]

Working on DB Access for HTTP trigger, I could make a query based on an .html file which is not a very nice way but it's working, based on that .html file:

http://172.31.254.248:9080/DBAccess">

UCCX HTTP Triggering - DB Access

User ID Number:

I get the value from end user from a browser and make a query to DB, from here everything is fine, but I'm stuck to get the next step, how can I display the query results on browser??   And next step, is how to display query results on xml format??

Any ideas that could help it will be a great help.

Regards,

[Gergely Szabo]

Hi,
the step you might want to look at is "Send HTTP Response", did you try it?
g.


Sent from Cisco Technical Support iPad App

[Juan Carlos Arias Perez]

Well that's the must logical next command, but how to I define the value on Document field??  I tried to use the lines created before for telephony trigger, but it's logical that the syntax I'm ussing it's not correct.

I tried with this lines:

{

StringBuffer buffer = new StringBuffer(100);

buffer.append("First Name(s):  ");

buffer.append(GetFirstName);

buffer.append(System.getProperty("line.separator"));

buffer.append("Last Name:  ");

buffer.append(GetLastName);

buffer.append(System.getProperty("line.separator"));

buffer.append("Your account is:  ");

BigDecimal bd_orig = new BigDecimal(GetBalance);

BigDecimal bd_frac = bd_orig.divide(new BigDecimal(1),2,BigDecimal.ROUND_HALF_UP);

String GetBalanceEmail =  java.text.NumberFormat.getCurrencyInstance(java.util.Locale.US).format(bd_frac);

buffer.append(GetBalanceEmail);

buffer.append(" dollars");

return buffer.toString();

}

and I received the message error "unassignable type: String; expecting Document"

How would it be on xml format??

Regards,