11.2 csv file date time format

2 Posts
2 Users
0 Likes
23 Views
(@m.nau@ypsys.com)
Posts: 0
New Member Guest
 

Hi eveveryone,

Is there a reason to have 2 differents date time format with data export when you export in csv (between trend and event)?

For the trends, there is only one column for the date time : YYYY-MM-DD hh:mm:ss
2016-06-22 15:45:30;16;73
For the events, there is 2 columns (one for the date & one for the time) with a different date format separator "/" ("-" for the events) : YYYY/MM/DD;hh:mm:ss
2016/06/22;15:42:19;Alarm on - not ack.;Water stream 0;ALARMS.EAU.COURANT1;11;

when you use a third part software to implement those data, it's painfull to recreate the datetime format for csv (when the data are created with the same software).

Thank you for your answer.

 
Posted : 22/06/2016 7:02 pm
n.kunzer
(@n-kunzerarcinfo-com)
Posts: 1236
Member Moderator
 

Hi Manu,

It is possible customizing the Date&Time format for the logs when you create your log page. So, I guess you can fix your issue easily.

But I agree the choice done for the default values is not so good.

For trends: The format is got from the General Settings / Language / Parameters and if nothing is specified here it is got from the system
For Logs: The format looks hard coded. It should follow the same rules that Trends.

I will check this point and make an anomaly accordingly.

Nico

 
Posted : 23/06/2016 2:39 pm