Zone in date format change when exporting to csv

[Nas-Adora Mohd-Dan]

Hi Support team,

I'm handling the MY E-Credit Limit application which is has been GO LIVE. We facing the issue when user export the reports to csv file. Please refer attachment.

When exporting the zone change to +0000 in csv and its minus the time 8 hours before. 

Hopefully your team can help me on this issue ASAP, as this application has been GO LIVE.

Thanks and regards,

NAS ADORA BINTI MOHD DAN

MYIS Department | IT APPLICATION SPECIALIST

LAFARGE MALAYSIA | 2, Jalan Kilang, Petaling Jaya

Office:  (603) 7962 3569 I Fax : (603) 77851453

nas-adora...@lafarge.com | www.lafarge.com.my

=================================================

                                     Safety Our Way of Life

                            Keselamatan Amalan Hidup Kita

=================================================

Disclaimer:

By communicating with Lafarge Malaysia, you are deemed to have consented to processing of your personal data as set out in the Lafarge Malaysia Privacy Notice which can be viewed here.

This email and any files transmitted with it are confidential and intended only for the use of the person to whom it is addressed. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any files for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

=================================================

                                     Safety Our Way of Life

                            Keselamatan Amalan Hidup Kita

=================================================

Disclaimer:

By communicating with Lafarge Malaysia, you are deemed to have consented to processing of your personal data as set out in the Lafarge Malaysia Privacy Notice which can be viewed here.

This email and any files transmitted with it are confidential and intended only for the use of the person to whom it is addressed. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any files for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

[Pankaj Kumar]

Hi Nas,

Please try to open the exported csv file in Notepad or Notepad++  to check what exactly data is coming in the csv as sometime Microsoft excel changes the timezone by itself and modify the time accordingly.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CA%2BzfMvoo1GPB34ZFCYDiOAiPjwTvt40%3DpoBLLm%3DBZhKgPrAzVg%40mail.gmail.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Somjit Banerjee]

Hi Pankaj,

I have exported out the data, and checked with notepad++, it is coming without the time zone, i.e 8 hours less of the actual time,

This is the code,

my_date = new Date();
currentTime = Math.round(my_date.getTime()/ 1000);
RMPApplication.setVariable("current_date",currentTime);

Is there any problem regarding this,

Now i can use other type of code to generate date for a text field, but that will not allow to use the between filter for me, from the report which is another issue.

So can you suggest me any other alternatives of this issue....

Regards
Somjit

[Pankaj Kumar]

Hi Somjit,

Variable "current_date" is holding the so of seconds, its not a Date variable. Are you converting this value in Date using Free-marker?

Also please share the details how you are using this variable in report, it is as a number, Date or string.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--

=================================================
                                     Safety Our Way of Life
                            Keselamatan Amalan Hidup Kita
=================================================
Disclaimer:

By communicating with Lafarge Malaysia, you are deemed to have consented to
processing of your personal data as set out in the Lafarge Malaysia Privacy
Notice which can be viewed here

<http://www.lafarge.com.my/wps/portal/my/0_9-LegalMentions#editoEncartVide0000000000026567>

.

This email and any files transmitted with it are confidential and intended
only for the use of the person to whom it is addressed. If you are not the
intended recipient you are notified that disclosing, copying, distributing
or taking any action in reliance on the contents of this information is
strictly prohibited. Please notify the sender immediately by email if you
have received this email by mistake and delete this email from your system.
Please note that any views or opinions presented in this email are solely
those of the author and do not necessarily represent those of the company.
Finally, the recipient should check this email and any files for the
presence of viruses. The company accepts no liability for any damage caused
by any virus transmitted by this email.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/f84fcd0c-90a2-4e06-8b85-ac3253dca545%40runmyprocess.com.

[Somjit Banerjee]

Hi Pankaj,

I have initialized the current_date as numeric date variable, and in the measures i am using, it as a date. I haven't use any freemarker to convert the value of the variable, to date type. So please suggest.

Regards,
Somjit

[Pankaj Kumar]

Hi,

You can use two measures to resolved it.

date and date_str, one is timestamp and other is string, so for displaying in report, you can use date_str, for computation timestamp is good to go

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--

=================================================
                                     Safety Our Way of Life
                            Keselamatan Amalan Hidup Kita
=================================================
Disclaimer:

By communicating with Lafarge Malaysia, you are deemed to have consented to
processing of your personal data as set out in the Lafarge Malaysia Privacy
Notice which can be viewed here

<http://www.lafarge.com.my/wps/portal/my/0_9-LegalMentions#editoEncartVide0000000000026567>

.

This email and any files transmitted with it are confidential and intended
only for the use of the person to whom it is addressed. If you are not the
intended recipient you are notified that disclosing, copying, distributing
or taking any action in reliance on the contents of this information is
strictly prohibited. Please notify the sender immediately by email if you
have received this email by mistake and delete this email from your system.
Please note that any views or opinions presented in this email are solely
those of the author and do not necessarily represent those of the company.
Finally, the recipient should check this email and any files for the
presence of viruses. The company accepts no liability for any damage caused
by any virus transmitted by this email.

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/be0be0c7-5e32-4be8-a1e7-08b121f8a129%40runmyprocess.com.

[Somjit Baner-Jee]

Hi Pankaj,

Thanks for the suggestion, i will do the required implementations.

Regards,

Somjit Banerjee | RMP Developer 

IT Asia Pacific (ITAP), Lafarge Asia Sdn Bhd.

Level 2, Wisma Lafarge, 2 Jalan Kilang,

46050 Petaling Jaya, Selangor, Malaysia.

Email: somjit-baner.jee.ext@lafarge.com

Mobile: +60142551160

Helpdesk: +601 2365 7972  | Fax:+603 7962 3416

You received this message because you are subscribed to a topic in the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/DiMOzbPuvLc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@runmyprocess.com.

To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CADHrCay1gK-N4e3_Sr1LMiroBPNq8AfTtxZiONuAEUZnw5ifww%40mail.gmail.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

=================================================

                                     Safety Our Way of Life

                            Keselamatan Amalan Hidup Kita

=================================================

Disclaimer:

By communicating with Lafarge Malaysia, you are deemed to have consented to processing of your personal data as set out in the Lafarge Malaysia Privacy Notice which can be viewed here.