cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
878
Views
5
Helpful
3
Replies

Script Assistance CCX

Cisco.Rookie
Level 1
Level 1

Hello Folks, 

 

I need a help in scripting. My clients want this way

 

Step 1 - Customer enters and ID. Then we have to match with the DB 

Step 2 - if the above ID matches, then script prompt to enter the account #

Step 3 - Combine both ID and Account number and populate in the finesse.

 

I simply dont have a clue, how to do that. Can someone help me creating a script or send me a sample script.

 

I am stuck and need to configure by next week. Please, apologies for shortcuts

 

Thanks in advance

 

 

3 Replies 3

Andreas Stuber
Level 4
Level 4

Hello,

We can help you via Webex to implement your script on a hourly basis 24x7, minimal engagement duration is four hours, payment via Paypal. Let me know if this interests you, and contact me at andreas.stuber (at) expertflow.com (which is both my email and Cisco Webex Teams ID).

 

Regards - Andreas

Mukesh Singh
Level 1
Level 1

Hi,

 

first You will have to integrate your external Database (Sql,oracle etc) with your UCCX system. Prerequisite:

UCCX premium license
Database is installed, up and running on some external server/s and tables, data should be populated, which will be referenced in UCCX Applications.
Database drivers should be downloaded with respect to external database.
External databases User ID, Password with read and write permission.
IP of External Database.
JDBC URL

 

Note:

  • JDBC URL is a URL of the server (External Database) to which you want to connect from UCCX server.
  • It’s like :- jdbc:jtds:sqlserver://IP of External Database:1433/database for SQL database
  • Example: - jdbc:jtds:sqlserver://10.23.134.11:1433/ccx where ccx is database name.

Integration steps:

 

  • Login to UCCX app admin page, http://uccxhostname/appadmin
  • Navigate to Subsystem>Database, Under Database you have three configuration parameters :
  • DataSource
  • Parameters
  • Drivers

 

 

  • Navigate to Subsystem->Database->Drivers
  • Click Add New
  • From Driver class name dropdown
  • Select net.sourceforge.jtds.Driver for SQL database
  • Click Browse for the Drivers downloaded
  • Navigate to Subsystem ->Database ->DataSource
  • Click Add new

dd.png

  • Give the DataSource Name
  • User name of Database through which we have installed the External database.
  • Password of above User Name
  • Confirm Password
  • Maximum Number Connections
  • Click Add

Now in your uccx .aef script.

  • use palate

ff.PNG

 

  • DB Write, DB Get, DB Read, DB Release in your script.

Regards,

Mukesh

j.huizinga
Level 6
Level 6

Hi,

You need premium, do you have premium?