This document was generated from CDN thread
Created by: Pedro Rego on 26-08-2013 01:04:19 PM
We wondering Into the Element Custom Insert Database we execute a simple insert, during this we use a Session Varible create on Elemet this for use this Data during this insert.
Could you try help us on this?
We need use each time a insert into base using the same Database Elemet custom using catch the session date (ALL TIMESTAMP) on system with milliseconds.
We need extend your funcionality for create a Session Data variable (TIMESTAMP with Miliseconds) and Return to our own element to use during this insert.
We try use your code on forum and but not works, return Null
actionData.setSessionData("date1",date1);
Thanks
Subject: Re: New Message from Pedro Rego in Customer Voice Portal (CVP) - CVP - All
Replied by: Janine Graves on 26-08-2013 02:12:48 PM
Hi Pedro, I don't quite understand the problem. Are you having trouble creating a date1 variable that contains the current date? Or are you having trouble inserting it into the DB? If you're trying to create a date1 variable, what format do you need it to be? DayMonthYearHourMinuteSecondsMilliseconds? And are you trying to store it as Session or Element data?
Subject: RE: Re: New Message from Pedro Rego in Customer Voice Portal (CVP) - CVP -
Replied by: Pedro Rego on 26-08-2013 02:30:31 PM
Today we have a Custom Database Element to insert some Data.
For try explain better we need the same Custom Element Databse have a twice functions (Extendet Original Funcion):
1º - DB Insert works as expected. (OK)
2º - Extra Funcion to Exit a Session Variable the time stamp like this 2013/08/26 13:19:33:15 - DayMonthYearHourMinuteSecondsMilliseconds (NOT HAVE)
Thanks
Subject: Re: New Message from Pedro Rego in Customer Voice Portal (CVP) - CVP - All
Replied by: Janine Graves on 26-08-2013 03:39:59 PM
OOPS - typo in previous email! Pedro, Your command to create Session data looks fine so long as you have already created the String variable named 'date1' and assigned it a value in the Java code. If you haven't already done that, the you could add the following to your code You can Google 'java simple date format' to get more information. //NOTE - the formatting letters below are case sensitive //MM=month, mm=minutes //ss=seconds, SS=milliseconds //HH=hours SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss:SS"); Date dateObject = new Date(); String dateString = sdf.format(dateObject); actionData.setSessionData("date1", dateString);
Subject: Re: New Message from Pedro Rego in Customer Voice Portal (CVP) - CVP - All
Replied by: Janine Graves on 26-08-2013 03:29:48 PM
Pedro, Your command to create Session data looks fine so long as you
have already created the String variable named 'date1' and assigned it a
value in the Java code.
If you haven't already done that, the you could add the following to
your code
You can Google 'java simple date format' to get more information.
//NOTE - the formatting letters below are case sensitive
//MM=month, mm=minutes
//ss=seconds, SS=milliseconds
//HH=hours
SimpleDateForm sdf = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss:SS");
Date dateObject = new Date();
String dateString = sdf.format(dateObject);
actionData.setSessionData("date1", dateString);
Subject: RE: Re: New Message from Pedro Rego in Customer Voice Portal (CVP) - CVP -
Replied by: Pedro Rego on 27-08-2013 09:33:41 AM
Janine, one more time when we are in trouble you were willing to help us, as happened at other times.
We had a short time to solve the problem and his help was essential to finalize.We got exactly what we wanted with their guidelines.
In previous attempts in the value of the time never refresh, now everything works. Besides the function of the database can extend the function of the element to create a session variable leaving the value of the current time in milliseconds.
On behalf of myself and the entire team Wittel I will transmit one
Thank You
Pedro Rego
Created by: Pedro Rego on 26-08-2013 01:04:19 PM
We wondering Into the Element Custom Insert Database we execute a simple insert, during this we use a Session Varible create on Elemet this for use this Data during this insert.
Could you try help us on this?
We need use each time a insert into base using the same Database Elemet custom using catch the session date (ALL TIMESTAMP) on system with milliseconds.
We need extend your funcionality for create a Session Data variable (TIMESTAMP with Miliseconds) and Return to our own element to use during this insert.
We try use your code on forum and but not works, return Null
actionData.setSessionData("date1",date1);
Thanks
Subject: Re: New Message from Pedro Rego in Customer Voice Portal (CVP) - CVP - All
Replied by: Janine Graves on 26-08-2013 02:12:48 PM
Hi Pedro, I don't quite understand the problem. Are you having trouble creating a date1 variable that contains the current date? Or are you having trouble inserting it into the DB? If you're trying to create a date1 variable, what format do you need it to be? DayMonthYearHourMinuteSecondsMilliseconds? And are you trying to store it as Session or Element data?
Subject: RE: Re: New Message from Pedro Rego in Customer Voice Portal (CVP) - CVP -
Replied by: Pedro Rego on 26-08-2013 02:30:31 PM
Today we have a Custom Database Element to insert some Data.
For try explain better we need the same Custom Element Databse have a twice functions (Extendet Original Funcion):
1º - DB Insert works as expected. (OK)
2º - Extra Funcion to Exit a Session Variable the time stamp like this 2013/08/26 13:19:33:15 - DayMonthYearHourMinuteSecondsMilliseconds (NOT HAVE)
Thanks
Subject: Re: New Message from Pedro Rego in Customer Voice Portal (CVP) - CVP - All
Replied by: Janine Graves on 26-08-2013 03:39:59 PM
OOPS - typo in previous email! Pedro, Your command to create Session data looks fine so long as you have already created the String variable named 'date1' and assigned it a value in the Java code. If you haven't already done that, the you could add the following to your code You can Google 'java simple date format' to get more information. //NOTE - the formatting letters below are case sensitive //MM=month, mm=minutes //ss=seconds, SS=milliseconds //HH=hours SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss:SS"); Date dateObject = new Date(); String dateString = sdf.format(dateObject); actionData.setSessionData("date1", dateString);
Subject: Re: New Message from Pedro Rego in Customer Voice Portal (CVP) - CVP - All
Replied by: Janine Graves on 26-08-2013 03:29:48 PM
Pedro, Your command to create Session data looks fine so long as you
have already created the String variable named 'date1' and assigned it a
value in the Java code.
If you haven't already done that, the you could add the following to
your code
You can Google 'java simple date format' to get more information.
//NOTE - the formatting letters below are case sensitive
//MM=month, mm=minutes
//ss=seconds, SS=milliseconds
//HH=hours
SimpleDateForm sdf = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss:SS");
Date dateObject = new Date();
String dateString = sdf.format(dateObject);
actionData.setSessionData("date1", dateString);
Subject: RE: Re: New Message from Pedro Rego in Customer Voice Portal (CVP) - CVP -
Replied by: Pedro Rego on 27-08-2013 09:33:41 AM
Janine, one more time when we are in trouble you were willing to help us, as happened at other times.
We had a short time to solve the problem and his help was essential to finalize.We got exactly what we wanted with their guidelines.
In previous attempts in the value of the time never refresh, now everything works. Besides the function of the database can extend the function of the element to create a session variable leaving the value of the current time in milliseconds.
On behalf of myself and the entire team Wittel I will transmit one
Thank You
Pedro Rego