From CSV File

You can upload energy production values from a system using a CSV file.

This is done via the upload button in the “Collections” application, accessible at:

Apps > Collections > Comparisons > Upload.

The data must be in a .csv file with ; as the separator, prepared in advance.
This file must contain the following columns:
POD;Section;Time;Energy

These represent, respectively:

  • POD: the unique identifier of the main system POD (Point of Delivery)
  • Section: the section of the system (assumed = 1 if left blank)
  • Time: the date and time of the data entry in the format
    year-month-day hour:minute:second
    Note: time and date must be in UTC (2 hours behind Italy during daylight saving time, and 1 hour normally)
  • Energy: the amount of energy produced in kWh during that interval

The data can be daily or monthly.
If monthly values are used, the date must be set to the first day of the month (e.g., 2023-01-01 00:00:00).
For daily values, at least 27 days are required to complete a full month.

Here is a template with two example rows for the CSV file:

CSV Template

To manually upload production data into Sunreport, follow these steps:

  1. Prepare a .csv file with the columns
    POD;Section;Time;Energy. This file represents the production data you want to upload to Sunreport.
  2. Go to Apps > Collections > Comparisons.
  3. Click the “Upload” button and select the prepared .csv file.
  4. After uploading the file, Sunreport will save the data and automatically create an “Entry” device linked to the POD indicated in the .csv, and thus to a specific system. The values will be visible under:
    Measurement Source > Entry
  5. Sunreport will then use the data from the “Entry” device as if they were collected from an inverter or any other device.

This procedure allows you to manually upload production data to Sunreport. It can be used for any active system, provided that the POD is entered under
System Settings > System Data.