DOCA0172EN-12

Data Log Export (Advanced Model)

Presentation

The Panel Server Advanced can export data measured on the connected devices and logged through data sampling. Data can be exported on your PC in a .csv file.

To export data logged on a Panel Server Advanced :

  1. Configure data to be sampled (see Selecting Measurements to Log).

  2. Activate sampling.

NOTE: To enable exporting of logged data to a CSV file after backup restore on the same Panel Server Advanced (see detailed topic), you must first reset the Panel Server to factory settings (see procedure).

When the Panel Server is connected to Schneider Electric cloud services, data logged on Panel Server is controlled by the cloud configuration. When a new cloud configuration is received by the Panel Server , data previously logged in the Panel Server is lost.

Availability

This function is available on Panel Server Advanced .

Setting the Parameters

Data logging export is set on the EcoStruxure Panel Server webpages, at Settings > Data Management > Local export .

Data Log Export Settings

The following table describes the settings.

Parameter Description

From

Used to select the start date of the period.

To

Used to select the end date of the period.

Device selection

Used to select one of the following from which to export sample data:

  • One device

  • All devices

NOTE: To export data from several devices, consider performing multiple single device exports to improve readability. Select one device and click Export data to generate the .csv file for the selected device. Repeat for each device.

Exporting Data

To export data that has been sampled by the Panel Server Advanced , click Export data. Data is exported into a CSV file on your PC. Data can be exported for a period of time by selecting the start-date and the end-date of the required period of time.

Up to 6.5 million data points can be exported to a single file; larger sets of data must be exported to several files. An error is generated if you attempt to export more than 6.5 million data points. Take note of the over configuration factor included in the error to assist your selection of a valid shorter export period. For example, if you attempt to export 20 days of data, but receive an error that you are 1.0 times over the limit, you would reduce the duration of each export period to less than 10 days.

You can calculate the size of your export file by calculating for each device, the number of samples, and then adding the samples of all devices together. For example, if you have three currents for one device configured for data logging at a 1 minute sampling rate, the total number of samples is 1,581,120. The following table illustrates the calculation.

Measurement

Sampling period (minute)

Start date

End date

Elapsed time (minute)

Number of samples

Current A

1

July, 28 2022

July, 29 2023

527,040

527,040

Current B

1

July, 28 2022

July, 29 2023

527,040

527,040

Current C

1

July, 28 2022

July, 29 2023

527,040

527,040

File Format of CSV Export Saved on a PC

Data is logged in a .csv file. The date is appended in the format yyyymmdd to the file name data-export_. For example, data exported on June 8, 2022 are in the file named data-export_20220608.csv.

Data time stamps in the CSV file are in the format DD/MM/YYYY HH:MM UTC (Coordinated Universal Time).

The following table provides the details of each row of the .csv file, with sample data. Data for each device is displayed per column.

Row

Data in .csv file

Description

Example of data in comma-separated values (CSV) format

1

Element ID

Element ID for each of the columns

modbus:2_mb_PkWD, modbus:1_mb_PFTtl

2

Device Name

Customer specified device name for each of the columns

myPM5560, myPM8000

3

Device Type

Device type defined by the Panel Server for each of the columns

PM5560, PM8000

4

Measurement Name

Data name for each of the columns

Total Demand Max Active Power, Total Rms Power Factor

5

Measurement Unit

Unit of the data for each of the columns

W

6 and more

DD/MM/YYYY HH:MM

Logged data

02/10/2022 20:20, 8880.13, -1

Read the .csv File

To read the .csv file, you need to import data into Microsoft Excel and use the correct data encoding.

By default, Excel uses Western European character encoding, as shown below:

However, the Panel Server Advanced exports data using UTF-8 character encoding. Therefore, to get all characters to display correctly, such as °C, you need to select UTF-8 as File Origin as shown below:

To select UTF-8 encoding in the exported .csv file, proceed as follows:

  1. Open Microsoft Excel and select Data then, in Get & Transform Data, select From Text/CSV.

  2. Select the .csv file exported from the Panel Server Advanced and click Import.

  3. In the window that opens, select these parameters:

    • 65001: Unicode (UTF-8) in File Origin.

    • Based on entire dataset in Data Type Detection.

  4. Click Load.

    Result: The Panel Server Advanced data logging file displays in Excel with UTF-8 character encoding, as shown in the following illustration:

To ensure that the separators are correctly configured to avoid data reading issues, proceed as follows:

  1. In Excel, select File > Options > Advanced

  2. Uncheck Use system separators.

  3. In Decimal separator, check that , (comma) is entered.

  4. Click OK.

  5. Reload the .csv file, if necessary.

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

Was this helpful?