Exporting Data Locally (Advanced Model)

Presentation

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

To export data logged on a Panel Server Advanced:

Configure data to be sampled (see Selecting Measurements to Log).
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

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

Local 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.

Parameter

Description

From

Used to select the start date of the period.

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.

NOTE: The export file contains all data points sampled during the period requested for the export, including for measurements which are no longer sampled or for devices which are no longer connected.

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

Reading 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:

Open Microsoft Excel and select Data then, in Get & Transform Data, select From Text/CSV.
Select the .csv file exported from the Panel Server Advanced and click Import.
In the window that opens, select these parameters:
- 65001: Unicode (UTF-8) in File Origin.
- Based on entire dataset in Data Type Detection.
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:

In Excel, select File > Options > Advanced
Uncheck Use system separators.
In Decimal separator, check that , (comma) is entered.
Click OK.
Reload the .csv file, if necessary.