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.
- The user wants to send an email with monthly report of the its home energy consumption.
- The user wants to get a weekly report about the energy consumption made inside its home.
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).
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:
- Open the ilevia_energy_daily.xlsx
- 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”).
- Remember that you can utilize a ready to use the template that we provide to accelerate the process (the FTP path is /
- 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).
The date of the report.
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.