chartReport


This component allows you to create reports using gathered information and to display them into an Excel file. Each information deriving from a specified component can be used to be represented in a chart and can be sent through Email on Daily, Weekly, Monthly or Yearly basis.

REPORT GROUP CREATION

As always you are asked to drag and drop the required components on “My components” area. The particularity of this component is given by using different components into a single group to get the job done. As the image on the left, you can see the needed components (Email Account, Email, Contact, Report).

Note:
In this guide, we will only cover the “Report” component. For the other components configuration please refer to those guides:

COMPONENT’S PROPERTIES

Customizable component’s title and icon. Please refer to “Common properties” guide.

GUI

This component’s sample is made by using Graphic UI gateway.

Please refer to “Gateways / Protocols” chapter in order to get further info

Components to report:(button) components that define data displayed in the Excel after you click it you can drag the desired component into the window (an example is the “Info” component);

Send interval:(dropdown) this option let you choose to send a report in a Daily, Weekly, Monthly or Yearly basis;

Template name:(empty text field) you can use ilevia_energy to use an already made template;

Email destination:(dropdown) select the Email component that you have configured;

 


FILEZILLA: HOW TO CONNECT TO YOUR SERVER TROUGH THE FTP PROTOCOL

 

 

 

 

Access to your report or template is very easy using a software like Filezilla (available for Windows and macOS). To connect to an FTP server, enter the address of your server into the host field of the Quickconnect bar. The username and the password is eveweb, enter it in the corresponding fields. Click on Quickconnect or press Enter to connect to the server.

Once connected, in the Remote site bar you will find all the folders inside the server, navigate to /http/logic/plugins/Report/templates and you will find the template, Double click on the file and it will download it to your computer.


HOW TO MAKE YOUR OWN DAILY ENERGY REPORT

In this part of the guide, we will explain how to customize and make your own report.

After you have downloaded the file, for example, ilevia_energy_daily.xlsx  from your server you can start editing it, so you can have your own data and layout. Below you’ll find the steps to follow to customize it:

 

  1.  Open the ilevia_energy_daily.xlsx
  2. In the row and column that you’ll prefer you should always use this format for the values: %date% and %dayvalues:YOURTEXTHERE_L1% (“Recorder” component is recommended for collecting data, it’s really important to understand this component before continuing. Remember that a recorder store data during a specific interval of time that you can set and it needs a component that shows the collected data like, for example, an “Info”).
  3. Remember that you can utilize a ready to use the template that we provide to accelerate the process (the FTP path is /http/logic/plugins/Report/templates).
  4. Remember that after you have edited it upload the ilevia_energy_daily.xlsx into your server using Filezilla (just drag and drop the file into the templates folder and overwrite it).

%date%

The date of the report.

%dayvalues:L1%

The value of the 1 st component of the “Components to report window”. In this case looking at the image below you will know that %dayvalues:L1% will be %dayvalues:Energy_Produced_L1%(L1 mean LINE1) the second value will be %dayvalues:Energy_Consumed_L2%(L2 mean LINE2) etc. . For this example, we used two “Recorder” to collect the data and two “Info” components to show the data.


EXAMPLE OF A DAILY ENERGY REPORT

Well done, keep learning!

Our suggestion for your next lesson: