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

Retrieving NodeID-SessionID-SeqNum within UCCX Scripting

Hi,

     I am working on UCCX 7.0 scripting where in I need to retrieve a unique number for the call. This unique number needs to map to the NodeID-SessionID-SeqNum of the AGent Wrap-Up Data Detail Report. I need to retrive this number in my script and write it into a custom table to be used as a primiray key in that custom table. Thus, this unique ID will link the CCDR in the standard historical reports to the custom table that I create. The custom table is being created to store some responses from the callers and will contain columns like CallID ( a unique ID), Reponse1, Response2 etc.

I tried retrieing the 'Identifier' in the GetContactInfo() step in my script assuming that this ID would be similar to the SeqNum in the NodeID-SessionID-SeqNUm of the historical reports but the 2 numbers are entirely different and hence I am unable to link the reports with the data in my custom table.

Any thoughts on how to work this through?

Thanks,
DM

1 ACCEPTED SOLUTION

Accepted Solutions
Bronze

Re: Retrieving NodeID-SessionID-SeqNum within UCCX Scripting

Here are the steps you need to use in order to retrieve the session identifier (SessionID).

1- Create two variables

     a) one variable of type "Session"

     b) one variable of type "long"

2- After the "Accept" step, add a "GetContactInfo" and retrieve the session with the session variable created in 1a

3- Then add a "GetSessionInfo" step and retrieve the identifier with the long variable created in 1b

4- That's it ! You got the same index as table ContactCallDetail.

Regards

Steven Ferland

21 REPLIES
Super Bronze

Re: Retrieving NodeID-SessionID-SeqNum within UCCX Scripting

Hi

I would consider inserting the response data into the 'Custom Variable' fields using a Set Enterprise Data step to simplify this setup. The data written to variables 1-10 is written directly to the 'custom variable 1-10' fields in the COntact Call Detail table in SQL.

That way the data is recorded against that call, and you would just need to worry about the relationships between tables that are already defined rather than trying to work in a new table.

Also I believe you aren't supposed to modify the CCX DB if you want to maintain supportability from Cisco.

Aaron

Please rate helpful posts..

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

Re: Retrieving NodeID-SessionID-SeqNum within UCCX Scripting

I am not modifying the UCCX DB. I will be creating a new DB in an external SQL server that will have a table to record the reponses of the survey. Actually, here is the actual scenario.

1. Caller calls into the contact center. Gets routed to an agent.

2. At the end of the call, the agent will transfer the call to this script (Route point) that would basically do a typical IVR functionality of asking a few questions and recording the responses.

3. These responses will then be written into an external DB (on an external SQL server) such that the table will have a unique ID, somehting like a call ID.

4. At a later point, the customer wants to map these reponses to any standard report that has the same unique ID such that, they know the entire call from end-to end.

COming to using enterprise variables, using SetEnterpriseData would display this call within CAD or wouldn't it? Also, as described above, the call gets transferred to a different route point.

If you think I can still achieve the above scenario using the Call Variables, Can you please elaborate on the steps?

Thanks in advance,

DM

Super Bronze

Re: Retrieving NodeID-SessionID-SeqNum within UCCX Scripting

Hi


I've played a little with post-call surveys, and I've found that the call to the second RP for the survey gets the same node/session with an incremented seq number.

I guess one way to make this link might be to write the unique ID from the record you add external DB to a call variable in UCCX.

Set Enterprise Info is pretty straight forward, just add the step, select a variable you want to use (Custom Variable 1 in the DB shows up as 'Call.PeripheralVariable1' in the editor). Typically if you're setting a single value (i.e. a PKID or something) you would leave tokens=All and then just assign your variable.

If I recall correctly (and I may not be correct, you could verify this by monitoring the table for changes) the SQL Contact Call Detail and other tables are updated after the call, so you may not be able to retrieve the data from the HR DB to write to your external DB while the survey call is still active.

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Bronze

Re: Retrieving NodeID-SessionID-SeqNum within UCCX Scripting

Here are the steps you need to use in order to retrieve the session identifier (SessionID).

1- Create two variables

     a) one variable of type "Session"

     b) one variable of type "long"

2- After the "Accept" step, add a "GetContactInfo" and retrieve the session with the session variable created in 1a

3- Then add a "GetSessionInfo" step and retrieve the identifier with the long variable created in 1b

4- That's it ! You got the same index as table ContactCallDetail.

Regards

Steven Ferland

New Member

Re: Retrieving NodeID-SessionID-SeqNum within UCCX Scripting

Thanks, It works!

Super Bronze

Retrieving NodeID-SessionID-SeqNum within UCCX Scripting

Genius :-)

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

Retrieving NodeID-SessionID-SeqNum within UCCX Scripting

Hi Steve

    GetssionInfo (Identifier)  step only gets the SessionID, not the entire NodeID-SessionID-sessionSeqNum.

Regards

Alex

New Member

Steve, I am trying to do the

Steve, I am trying to do the same things that dmurthy74 was doing 5 years ago.

1. Caller calls into the contact center. Gets routed to an agent.

2. At the end of the call, the agent will transfer the call to this script (Route point) that would basically do a typical IVR functionality of asking a few questions and recording the responses.

3. These responses will then be written into an external DB (on an external SQL server) such that the table will have a unique ID, something like a call ID.

4. At a later point, the customer wants to map these responses to any standard report that has the same unique ID such that, they know the entire call from end-to end.

 

So I understand the process.....

The steps that you outlined in the correct answer, are those steps in the script of the original call, or are they in the script for the survey?

I am new at scripting, so I am sorry but I need a little more details.

Thanks

Pete

Super Bronze

Hi PeteThe session ID should

Hi Pete

The session ID should be the same in the original call (i.e. call to agent) and the survey call (post agent call) if the call is transferred back to CCX. It generally has the same session ID, with a bumped sequence number.

That's what can allow you to relate the survey results to a specific agent call.

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

Aaron,   Thanks.   I was able

Aaron,   Thanks.   I was able to get the session ID and sequence, how do I get other information related to the call like:

NodeID

Application Name

CSQ Name

Called ANI

Agent ID

Extension

 

Thanks

Pete

 

Super Bronze

Hi PeteDo you want to get

Hi Pete

Do you want to get this data in the CCX script?

Or when reporting later, via ODBC?

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

Hello Aaron.

Hello Aaron.

I'm facing the same issue. I want get this data to the CCX script. (Further I use DB Write to put this data into external database)

Thank you.

Hi Kanat, get what data?

Hi Kanat, get what data?

Also, what is the issue you are facing when trying to write into an external DB?

G.

New Member

Hello!

Hello!

We have two scripts in production environment. Basic CCX script, and Quality Assessment script. I'm trying to retrieve CSQ name and AgentID parametres from the session, but they become "null". I need to write CSQ Name, Agent Extension, calling number and score into an external DB. No problem with the score and calling number, but I can't get CSQ and agent ID.

Can you post the screenshots

Can you post the screenshots of the relevant parts of the scripts? Thanks. G.

New Member

Screenshots attached. Made

Screenshots attached. Made during reactive debugging.

And where are they written

And where are they written into the Session? G.

New Member

I used Set Session Info and

I used Set Session Info and Get session Info commands improperly, now it works.

Thanks for your response.

New Member

Hi Kanat,

Hi Kanat,

I am trying to do the same thing as you and face the same issue. Could you please share your script or tell me what you have done ?

Regards,

Luís.

New Member

Hey Pete how did you get

Hey Pete how did you get Sequence Number??

New Member

I am also curious how you

I am also curious how you collected the sequence number - I have been able to expose the Session ID but the sequence number is not working for me either.  My goal is to merge these two pieces of data into one callVariable.

If you have been able to accomplish this successfully please share??

Tks.

Michele

3123
Views
5
Helpful
21
Replies