IPCCX Scripting - Database Dips

Unanswered Question
Dec 17th, 2007
User Badges:

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)

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
alex_hannah Mon, 12/17/2007 - 10:38
User Badges:

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


Actions

This Discussion