Products
Download
Contact us
Back to Top
FAQ
 When outputting alarm history or sampling data in a CSV format, can a date format I prefer be  selected?

When outputting alarm history or sampling data in a CSV format, it’s possible to specify a date format.
Since the setting can be changed according to a site overseas, it’s possible to use the output CSV file immediately.

NOTE
- A display format of date may be changed as shown below due to automatic recognition of Microsoft Excel. Please be aware of it.

Ex) Date data of a CSV file : 29/11/10 (CSV Date Format : dd/mm/yy)
   
    Display on Excel: 2029/11/10
- For settings of a date format, GP-Pro EX Ver. 2.7 or later is required.
GP-Pro EX Upgrade Service
- Reference: I want to store alarm messages in CF card or USB storage device!
 
■How to specify a date format
<Alarm History>
1. Click [Alarm] on the [Common Settings] menu.
2. Click the [Common] tab and select [Date Format].
Select a date format to be output in a CSV file format from [yy/mm/dd], [dd/mm/yy], [mm/dd/yy], [20yy/mm/dd], [dd/mm/20yy], [mm/dd/20yy], or [mm/dd].
[yy] shows the lower 2 digits of the western calendar. [mm] shows a month, and [dd] a day in 2 digits.
   
 
 
   
3. Transfer the specified project file.

<Sampling data>
1. Click [Sampling] on the [Common Settings] menu.
The already registered sampling groups are displayed in a list. Double click on the cells except [Group] and [Comment].
   
 
   
2. Click the [Display/Save in CSV] tab.
Select a date format to be output in a CSV file format from [yy/mm/dd], [dd/mm/yy], [mm/dd/yy], [20yy/mm/dd], [dd/mm/20yy], [mm/dd/20yy], or [mm/dd].
[yy] shows the lower 2 digits of the western calendar. [mm] shows a month, and [dd] a day in 2 digits.
   
 
   
3. Transfer the specified project file.
Back to page top Return to the previous page
FAQ for use | Protection of Personal Information | Trademark Acknowledgments | About Intellectual Property Rights | Terms of Use
Copyright (C) 2005- Schneider Electric Japan Holdings Ltd. All Rights Reserved.