Develop a software to read and write large sets of data to ECOBee Thermostat. (small Project)

Project Details

Ecobee Application will contain following features and functionalities.

User Management

• There will a Login page where user can login and access the Ecobee manager.

• There will not be any forgot password functionality.

• There will not be any registration or Add/Edit User functionality.

• If we need to add another user, then we should directly add a record in database.

Dashboard

• There will be few options/icons present on dashboard which will navigate to different pages.

• Icons present will

 Manage Thermostat

 Update Thermostat Data

 Regenerate Ecobee Pin

Manage Thermostat

• Manage Thermostat will contain list of all thermostat.

• 2- what would be happened if I add on a new thermostat? Can I see that on the app?

If you add a new thermostat on [url removed, login to view] panel then our cron will sync that thermostat as well in our application.

• There will be a button for each thermostat with name “View Details”.

• On Click of View Details button a new page will open with a list of all records for that thermostat, 50 records per page

• 3- Is this record including temperature sensors in different rooms?

It will store all major details returned by api for each thermostat, if each room has one thermostat then it will return details for each room, basically it will return details for each thermostat

• On Same page, there will be a button with name “Export Latest 50 Records”

• On click of Export Latest 50 Records (each records takes place in 5 min?) a csv file will get export with 50 records for that thermostat.

• 4 - Please increase Records up to 280 to cover whole day. (60 min/5 min = 12 * 24 = 280)

You want automated cron to run at every 30 min or every 5 min. If every 5 min then I will change the number of records to 280. Please note its not always the case that it will return 280 record of same day, if you click on this button at 01:00 PM then it will return records of last 24 hours.

Based on my Matlab code requirements, I need to have access to last 24 hrs. Please set up the app based on 280 record.

Regenerate Ecobee Pin

• This page will be use to regenerate the Ecobee Pin Code which will need to setup the application in case of Access Token expiration.

• 5- How often should I use that? Each time at the beginning of running the program?

Basically you will not be needed to do that. Its for case if the access token get expired if you don’t use the application for so many days.

Update Thermostat Data

• To be determine, will need the fields to update. Added a support ticket to Ecobee team to get the API details for update thermostat

Automated Cron Jobs

• We will need few automated cron jobs to perform data collection of thermostats and data cleaning.

• First cron will be use to fetch the data of thermostat at an interval of 30 min.

• We will need to create a database table to store these records.

• Second cron will be needed to clean the database as we cannot keep all data in the database. It is recommended to delete the old data i.e. 1 month or 2-month-old from the database to reduce size of the database.

• 6- NO need to clean. I need to have a copy of all info for thermal modelling.

Sending Hours as 1,2,3,4 will be confusing for application, better option will be to send date and time like below example

Thermostat ID Date Time Set Point

645678299358 2017-06-13 10:00:00 22

645678299358 2017-06-13 11:00:00 23

645678299358 2017-06-13 12:00:00 22

645678299358 2017-06-13 13:00:00 29

645678299358 2017-06-13 14:00:00 21

645678299358 2017-06-13 15:00:00 22

645678299358 2017-06-13 16:00:00 26

845852125462 2017-06-13 10:00:00 22

845852125462 2017-06-13 11:00:00 24

845852125462 2017-06-13 12:00:00 25

845852125462 2017-06-13 13:00:00 27

Format is OK

Your app just need to read the set points from a csv generated by my Matlab code.

CSS HTML MySQL PHP Arquitectura de software

Nº del proyecto: #14349464

Sobre el proyecto