4 saving data as a csv file, Saving data as a csv file, Data structure and output example – IDEC High Performance Series User Manual
Page 836: Saving data as a csv file -38
4 Using Data and Detected Alarms
13-38
WindO/I-NV2 User’s Manual
4.4 Saving Data as a CSV File
●
Saving Data as a CSV File
The Alarm Log data can be saved to the memory card as a CSV file or uploaded to a PC.
The procedure to save the data is as follows.
• To save the data to a memory card, click Alarm Log on the WindO/I-NV2 Configuration tab to open the Alarm
Log Settings dialog box. Select an output method check box on the Memory Card Output tab and configure the
items. The data can be saved to the memory card folder on the memory card. For details, refer to “Memory Card
Output Tab” on page 13-21.
• To upload the data to a PC, click the Upload menu in Downloader, and click All Log Data or Alarm Log Data to
open the Select Path dialog box. Specify the location to save the file and click OK to save the file to the specified
folder. For details, refer to the Downloader manual.
●
Data Structure and Output Example
The data structure for files output with batch output and real time output is different.
HG2G-S/-5S/-5F, HG3G/4G
■
Batch
Batch output shows the recovery and confirmation time for an alarm that has occurred on a single line.
The data structure of files output with batch output is as follows. Bold items are replaced by the Alarm Log settings,
sampled data, project file name, and WindO/I-NV2 version.
Headers
"Project Name","Project name","Version number"
"File Type","Log type"
Blank row
Title row
"Ch.No.","Message","Occurrence Time","Recovery Time","Confirmation Time"
Data row
" Channel number","Message"," MM/DD/YYYY HH:MM:SS"," MM/DD/YYYY HH:MM:SS",
" MM/DD/YYYY HH:MM:SS"
∙
∙
∙
Output example
Data size of each row
"Project Name","Dimmer Console","V4.50"
- 41 bytes
"File Type","Alarm Log Data"
- 30 bytes
- 2 bytes
"Ch.No.","Message","Occurrence Time","Recovery Time","Confirmation Time"
- 74 bytes
" 1-0","Voltage drop"," 08/11/2011 14:46:12"," 08/11 14:46:13"," 08/11
14:46:16"
- 82 bytes
" 1-1","Temperature abnormal"," 08/11/2011 14:47:18"," 08/11 14:47:19",
" 08/11 14:47:20"
- 90 bytes
∙
∙
∙