3 saving the data as a csv file, Saving the data as a csv file, Data structure and output example – IDEC High Performance Series User Manual
Page 881: Saving the data as a csv file -43, Data log function
WindO/I-NV2 User’s Manual
14-43
4 Using the Data
14
Data Log Function
4.3 Saving the Data as a CSV File
●
Saving the Data as a CSV File
The Data 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 Data Log on the WindO/I-NV2 Configuration tab to display the Data
Log Settings dialog box. Select a channel number to save to the memory card and click Edit to display the
Individual 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 14-19.
• To upload the data to a PC, click the Upload menu in Downloader, and click All Log Data or Data Log Data to
display 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
HG2G-S/-5S/-5F, HG3G/4G
The data structure of the output file is as follows. The data structure for files output with batch output and real time
output is the same.
Bold items are replaced by the Data 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
“Channel No.”,”Channel number”
“Source”,”Source device”
“Sampling Method”,”Sampling condition (type)”
“Sampling condition (label)”,”Sampling condition (configuration details)”
Blank row
Label row
“Label (sampling time)”,”Label (data number 1)”,”Label (data number 2)”... times the amount of
data
Data row
“MM/DD/YYYY HH:MM:SS”,Data number 1 data value,Data number 2 data value... times the
amount of data
∙
∙
∙
Output example
Data size of each row
“Project Name”,”Dimmer Console”,”V4.50”
- 41 bytes
“File Type”,”Data Log Data”
- 29 bytes
- 2 bytes
“Channel No.”,”1”
- 19 bytes
“Source”,”LDR 100”
- 20 bytes
“Sampling Method”,”Fixed Period”
- 34 bytes
“Time[Sec]”,”1”
- 17 bytes
- 2 bytes
“Sampling Time”,”Data001”,”Data002”
- 37 bytes
“08/23/2011 18:32:04”,171,234
- 32 bytes
∙
∙
∙
• The data size for each row is counted as 2 bytes for full-width characters, 1 byte for half-width characters,
and 2 bytes for newlines. The total for each row is the total amount of space for the file.
• A space is inserted before the year in the data row.
• The display type for the date and time differs according to the language configured in Project Settings,
on the Project Details tab, in Language.
Japanese: YYYY/MM/DD HH:MM:SS
European, Chinese, Taiwanese, Korean, Central European, Baltic, Cyrillic: MM/DD/YYYY HH:MM:SS