cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
422
Views
0
Helpful
2
Replies

IPCCX Scripting - Database Dips

3tciscosupport
Level 1
Level 1

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 2

alex_hannah
Level 4
Level 4

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

I need more specific instructions.

Thanks.

IPCCX 4.5(2)

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: