Mitsubishi Electric MELSEC-L Series - CSV File Output Format; CSV Format Specifications; Output Details of Lines and Columns

33
CHAPTER 3 SPECIFICATIONS
3
3.3 CSV File Output Format 3.3.1 CSV format specifications
3.3 CSV File Output Format
This section describes the CSV format specifications and lines and columns output.
3.3.1 CSV format specifications
The CSV file format is specified as shown below.
*1 When "Output device comments for data column" is selected in "CSV output" of the data logging setting, if a double
quotation mark (" or ") or comma (,) is included in a device comment, the data must be as follows:
ÅEThe entire data must be enclosed with double quotation marks (" ").
ÅEEmbedded double quotation marks (" ") must be doubled.
3.3.2 Output details of lines and columns
An example of the lines and columns output is shown below.
Item Description
Delimiter Comma (,)
Line feed code CRLF (0x0D, 0x0A)
Character code ASCII or Shift JIS
Field data
Double quotation marks
(" ") and commas (,) must not be included in each of data.
*1
Data line
File information line
Comment line
Data name line
Data type information line
File type File version
Data type information line number
Data name line number
Comment line number
Data start line number
Date column Data sampling
interval column
Execution step No. column
Execution program name column
Index column
Data column Trigger
information
column
[
LOGGING
]
LOGGING TEST
DATETIME
[
YYYY/MM/DD hh.mm.ss.s
]
TIME
2010/1/10 14:25:34
2010/1/10 14:25:34
2010/1/10 14:25:34
2010/1/10 14:25:34
2010/1/10 14:25:34
2010/1/10 14:25:34
2010/1/10 14:25:34
L1
INTERVAL
0
60000000
60000000
60000000
60000000
60000000
60000000
60000000
3
STEP NO.
STEP NO.
10
2
15
100
100
1
0
0
4
PROGRAM NAME
PROGRAM NAME
MAIN
MAIN1
MAIN1
MAIN2
MAIN2
MAIN
MAIN
MAIN
5
INDEX
INDEX
1
2
3
4
5
6
7
8
2010/1/10 14:25:34
BIT
[
1;0
]
FFFF
1
FFFF
1
FFFF
1
FFFF
1
M0
1
0
0
0
0
0
0
0
1234
1234
0
0
12345678
12345678
12345679
12345680
USHORT
[
HEX
]
W30
LONG
[
DEC.0
]
D100
2
TRIGGER
[
*
]
Trigger
*
INTERVAL
[ s]