SmartAXIS Touch User’s Manual 14-37
4 Using the Data
14
Data Log Function
4.3 Saving Data as a CSV File
● Saving Data as a CSV File
The Data Log data can be saved to the external memory as a CSV file.
The procedure to save the data is as follows.
On the WindO/I-NV3 System Setup tab, click Data Log to display the Data Log Settings dialog box. Select a
channel number to save to the external memory, and then click Edit to display the Individual Settings dialog box.
Select an output method check box on the External Memory tab and configure the items. The data can be saved to
the External Memory Folder on the external memory. For details, refer to “External Memory Tab” on page 14-16.
●
Data Structure and Output Example
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-NV3 version.
Files saved to external memory are read using WindO/I-NV3.
On the WindO/I-NV3 Online tab, click the arrow under Upload, and then click Data in external memory
to display the Upload from external memory dialog box. Select the Data Log Data check box, specify the
location to save the files in Path, and then click OK to be able to save the files in the specified folder.
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”,”V1.00” - 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 two bytes for full-width characters, one byte for characters, and
two 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