DOCA0172EN-12

Appendix D: SFTP Publication File Formats

CSV Publication

The following table provides the details of each row of the .csv file, with sample data:

Row

Data in .csv file

Description

1

Gateway Name,Gateway SN,Gateway IP Address,Gateway MAC Address,Device Name,Device Local ID,Device Type ID,Device Type Name,Logging Interval,Historical Intervals

This row contains the column headings for the information provided in row 2:

  • Gateway Name: name given to Panel Server during commissioning

  • Gateway SN: serial number of Panel Server

  • Gateway IP: IP address of Panel Server

  • Gateway MAC Address: MAC address of Panel Server

  • Device Name: name given to the device during commissioning

  • Device Local ID: reference of the logged device, unique across Panel Server

  • Device Type ID: device model

  • Device Type Name: device model

  • Logging Interval: sampling period expressed in minutes

  • Historical Intervals: total number of rows of logged data in this file

2

Device TypeEcoStruxure Panel Server,542206310926,10.195.253.81,00:00:54:E5:8A:36,F160 3P 3P+N,modbus:1_mb_81,F160 3P 3P+N,F160 3P 3P+N,5,7

This row contains information about the Panel Server that produced the file, and the downstream device from which the measurements were sampled.

3

4

,,,Topic ID1,Topic ID2

This row contains the column headings for the topic IDs. A topic ID is a reference to the quantity being logged. The name given to a quantity may differ between devices and languages. Topic IDs are used to identify the quantity regardless of the device or language. Topic IDs are unique across the Panel Server .

NOTE: The first 3 commas are used for layout purposes in a spreadsheet application.

5

,,,"modbus:1_mb_VAB","modbus:1_mb_VAN"

This row contains the topic IDs of the measurements logged.

6

7

Error,UTC Offset (minutes),Local Time Stamp,RmsVoltagePhsAB (V),RmsVoltagePhsAN (V)

This row contains the column headings for the data logged in rows 8 and more:

  • Error: 0 for success, 19 when at least one measurement was invalid or not available for sampling (NaN).

  • UTC Offset (minutes): offset of local timestamp from UTC timezone.

  • Local Time Stamp: date and time of the samples

From the fourth item onward, each measure is described by its name and unit (if known).

8 and more

0,0,2022-11-04 08:10:00,127.80000305,235.3999939

0,0,2022-11-04 08:15:00,128.1000061,235.69999695

0,0,2022-11-04 08:20:00,127.69999695,234.8999939

These rows contain the logged data.

JSON Publication

The following lines provide an example of a .json file with data consisting of a list of two time series with a collection of several records:

QR Code is a registered trademark of DENSO WAVE INCORPORATED in Japan and other countries.

Was this helpful?