File Format of Publications
Presentation
The file format of published files depends on the choice of publication method:
-
Schneider cloud services: json file format
-
SFTP and HTTPS: select json or csv file format on Panel Server webpages
File Format of CSV Publication
One .csv file contains:
-
Data relating to a single downstream device
-
All measurements configured with the same sampling period for that device
-
Data from a maximum of 24 hours of sampling
The name of the CSV files that are exported follows the naming convention ReducedID_DeviceName_DateTime_IndexNumber.csv where:
-
ReducedID
is the internal identifier of the device, which ensures that files produced are unique for devices that would share the same name (for example, 10_mb, 21_zd). -
DeviceName is the name given to the downstream device.
-
DateTime is the time stamp corresponding to when the file was published, expressed down to the millisecond in the format YYYYMMDDhhmmssSSS.
-
IndexNumber in the format _<nn> indicates the number of the file in the total number of files for a single publication (same ID, same device name and same timestamp). If there are 20 files in the publication, they are numbered _1 to _20.
-
Only the following characters are allowed in the .csv file name : UTF-8 and basic ASCII (32 to 7F, excluding \ / : * ? " < > |). Any non-supported characters will be replaced by ~.
Example: Considering the following file
name:
11_mb_F160 3P 3P+N_202412161020_19.csv where:
-
ReducedID is 11_mb.
-
DeviceName is F160 3P 3P+N, name of the device.
NOTE: This name is the default value (product model) if the user has not updated it. -
DateTime is 202412161020, which means that the file was published on December 16, 2024 at 10:20.
-
Index number is _19, which means that the file is the 19th file in the publication.
The .csv file content only supports UTF-8 standard character encoding for device name, event name, measurement name, and file name.
Quotation marks in all data fields of the .csv file help ensure compatibility with special characters.
For details and examples of the .csv file, see Appendix D SFTP and HTTPS Publication File Formats.
File Format of JSON Publication
One .json file contains measurements of multiple downstream devices configured with the same sampling period.
Each file contains the data from 24 hours of sampling, up to a limit of 256 KB of data.
The name of the JSON file that is exported follows the naming convention DateTime_IndexNumber.json where:
-
DateTime is the time stamp corresponding to when the file was published, expressed down to the millisecond in the format YYYYMMDDhhmmssSSS.
-
IndexNumber in the format _<nn> indicates the number of the file in the total number of files for a single publication (same ID, same device name and same timestamp). If there are 20 files in the publication, they are numbered _1 to _20.
For an example of a .json file, see Appendix D SFTP and HTTPS Publication File Formats.