(+39) 0424.166.02.08 support@ilevia.com

chartReport


INTRODUCTION

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.

USE CASES

  • 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.
How to set up a automatic report send procedure with the Email plugin module inside the Home automation configuration software

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:

Report component properties inside the Home automation configuration software

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:

  • 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 /http/logic/plugins/Report/templates).

 

  • 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).
How the daily report File looks like while doing the configuration
List of the components that will be recorded and then displayed inside the report from inside the home automation configuration software

%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

This is how the report looks like when you receive it at the presetted date and time inside the home automation configuration software

Still Need Help? Our Customer Service Is Here For You.