Data Logging Format; Csv File Data Specifications - Mitsubishi Electric MELSEC iQ-R Series User Manual

15.2

Data Logging Format

This section describes file format of the data logging.

CSV file data specifications

File information row
Column No.
1st column
2nd column
3rd column
4th column
5th column
6th column
Setting data information row
The description of the setting file (json) is output. For data details, refer to the followings.
Page 461 Logging setting, Page 475 JSON File Data Specifications
Data type information row
Data type information row is output in the format of "(Data type) [additional information]".
Column No.
1st column
2nd column
3rd column and later
Last column
*1 Regarding .ssssssss at the end, three digits for information of [ms], three digits for information of [s], and two digits for information of
[ns] are output.
*2 "*" is output for trigger ON string.
For details of data column are shown below.
Data type of data
Bit
Word [unsigned]
Word [signed]
Double word [unsigned]
Double word [signed]
Single-precision real number
Double-precision real number
*1 The number of digits after the decimal point is not always same as the specified one. (Example) For 1.2345, '1.2345000' is not output.
*2 [DEC.(Number)] shows the numerical value format and the maximum number of fractional part digit. (Example) For [DEC.7], the
fractional part digit is seven with decimal notation.
Column name
File type
Type information_file version
Data type information row number
Data name row number
Data start row number
Device comment row number
Column name
Date and time column
Index column
Data column
Trigger generation information column
Output character for the data type
BIT
USHORT
SHORT
ULONG
LONG
FLOAT
DOUBLE
Description
Fixed character "[LOGGING]"
Output file version
"RD78G(H)_1" (Initial version)
Number which indicates data type information row: a
Number which indicates data name row: a + 1
Number for data starting row: a + 2
Number indicates device comment row: a + 3
When the device comment does not exist, it can be omitted.
Description
Indicates data type of date and time.
Fixed character "DATETIME[YYYY/MM/DD hh:mm:ss.ssssssss]"
Fixed character "INDEX" which indicates index column
Index does not have additional information. [] is not output.
Indicates data type of the sampled data.
The following character string is output regardless of continuous logging/
trigger logging.
*2
"TRIGGER["trigger ON string"]
The character string with double quotation "" is fixed character.
Description
Outputs in the format of "BIT[1;0]".
Outputs in the format of "USHORT[DEC.0]".
Outputs in the format of "SHORT[DEC.0]".
Outputs in the format of "ULONG[DEC.0]".
Outputs in the format of "LONG[DEC.0]".
Outputs in the format of "FLOAT[DEC.7]".
Outputs in the format of "DOUBLE[DEC.14]".
*1
*2
*2
*2
*2
*1*2
*1*2
15 LOGGING
473
15.2 Data Logging Format
15