beautypg.com

2 structure of the standard csv format – SMA Sunny Data Control V.4.2 User Manual

Page 101

background image

SMA

Technologie AG

Managing Data and Saving Data Locally

User Manual

SDC-TEN080642

Page 101

11.3. 2 Structure of the Standard CSV Format

Every CSV file contains a fixed file header, and a data block into which the
measurement data are written. The file header comprises 8 rows, and has the following
structure:

All attributes of the CSV format appear in row 1, separated by pipe symbols.

Row 1

Version CSV1|Tool SDC|Linebreaks CR/LF|Delimiter
semicolon|

Decimalpoint comma|Precision 3|Language en|Plant

Plant-CSV-1|

User [email protected]|

Row 2

empty

Row 3

device name
1

device name
1

device name
2

device name
2

Row 4

Device type

Device type

Device type

Device type

Row 5

serial number serial number serial number serial number

Row 6

channel
name1

channel name
2

channel
name1

channel name
2

Row 7

channel type channel type channel type channel type

Row 8

time
stamp
format

Channel unit

Channel unit

Channel unit

Channel unit

Row 9

Date

channel value

channel value

channel value

channel value

Row...

Date

channel value

channel value

channel value

channel value