Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

IPCCX Scripting - Database Dips

Hello,

I am trying to write my first script that takes an account number input from the caller, compares it to a database of account numbers and then matches it with the correct sales rep.

Does anyone have something similar I can use as a template?

Thanks.

IPCCX 4.5(2)

2 REPLIES
New Member

Re: IPCCX Scripting - Database Dips

It's not that hard...

*** You will need IPCCX Premium to do this...

1. Configure an ODBC link on the CRS server.

2. Configure the CRS Database Subsystem.

3. In your script use a get digit string to ask the user to key in their account number, place the result into a string variable your define.

4. Use the DB Read step to enter your SQL command. Note: $ sign equals a parameter

5. Use DB Get to retrieve all rows from DB returned by executing the query. Note: you may have to put this into a loop if you are returning more than one record.

6. Put the DB Release step in to release the connection to the DB.

Follow this link to get you started... I'm assuming your on IPCCX 5.0, if not make sure you get the doc on your version

http://www.cisco.com/univercd/cc/td/doc/product/voice/sw_ap_to/apps_5_0/english/adminst/crs501sr.pdf

New Member

Re: IPCCX Scripting - Database Dips

I need more specific instructions.

Thanks.

IPCCX 4.5(2)

169
Views
0
Helpful
2
Replies
CreatePlease to create content