About sferland

sferland · 10-18-2010

One of my customer is in the process right now to migrate his system to version 8.0.We are using database queries to MS-SQL within the scripts. Last friday, during our tests with the new system, we realized that the mapping of a database varchar to a...

sferland · 04-30-2007

Hey Guys,I need to reproduce an encryption algorithm originaly created in a Oracle Stored Procedure, into a CRS script.Two of the steps of this algorithm are using functions ASCII() and CHR().ASCII() = Returns the NUMBER code that represents the spec...

sferland · 03-15-2007

Hey guys,Is any of you find a way to run a script repeatedly (each minute, each hour or anything else) ?I need to run a script at each hour in order to check the integrity of some data in a database and then raise an alarm (send a email) if an incons...

sferland · 01-09-2006

Hi all,I'm trying to retrieved a date from an SQL request. First, I created a "Date" type variable in my script. Then I'm using a DB READ for my SQL statement. After, I put a DB GET and tried (without success) to map my variable to a "DateTime" field...

sferland · 02-17-2005

Hey Guys,I configured an Extended GetDigitString step within my script with the following timeout:First Digit Timeout = 10 secInter Digit Timeout = 5 secWhen I tried the script, I got the following error :Call,Exception=com.cisco.wfapi.WFExecutionExc...

sferland · 09-06-2011

The only way I found to delete a file in the customer folder is with this kind of step:Hope that help !Steven

sferland · 10-18-2010

Found my problem.For those interested, I changed the Data Type for all my String in the Database from "NVARCHAR" to "VARCHAR" and then add the following property into the JDBC URL :;charset=ISO-8859-1

sferland · 05-12-2010

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...

sferland · 10-30-2009

Hi,Your query in "DB Read" should look exactly the same as today. Instead of doing the query on the table you're doing it on the view.Ex:Before:SELECT * FROM WHERE ???After:SELECT * FROM WHERE ???Then, in your ""DB Get", you retrieve a String varia...

sferland · 10-29-2009

Hi,I ran into this situation before. The only way I could work around it, was to create a view in SQL, which takes the date and convert it to a String (ex: 20091029). So, instead of doing the request against the table, I'm doing it against the view. ...

Member Since	‎02-03-2004 06:59 AM
Date Last Visited	‎08-18-2017 03:54 AM
Posts	70
Total Helpful Votes Received	86

User Statistics

User Activity

UCCX 8.0 - DB Get step is returning Unicode value instead of string

Casting a int to a char

IPCC Express - Administrative script

How to retrieved a date variable with DB GET ?

Problem with Extended GetDigitString step !!!

How to delete a file saved to the uccx.customer.dir on UCCX 8.x?

Re: UCCX 8.0 - DB Get step is returning Unicode value instead of

Re: Retrieving NodeID-SessionID-SeqNum within UCCX Scripting

Re: DB Read/Get Issues with SQL

Re: DB Read/Get Issues with SQL