Manual Input Sensor with access to history

[bourliam]

Hello all,

I want to keep an eye on my eletrical consumption, but I don’t have any connected device for that (and I don’t want to buy one). So I wanted to create an input field and manually report the value.

I found this answer : https://community.home-assistant.io/t/component-for-manual-meter-readings/34515/2.

This works well, but I have some old data stored in a google sheet that i’d like to add.
Do you know how to acces the history of the input_number ? Or is there another way to do so ?

Thank you !

[fquinto]

Hi, I’m trying to find a solution to store historical data, like you.
But I don’t find a final solution in forum it self.

Normally all this requests came from meters, that the energy, water, gas… companies have in their websites for every customer, and if you download this data, all data are from “past” time, not real time.

I’m only have approximations, in order to summarize my findings:

1. One approximation is doing “insert’s” data in database…
   Documented here: History - Home Assistant exists information about fields.

   Requested by:

Insert custom data into Home Assistant Database

Hello, I am moving from a mix of SmartThings+Pi system to Home Assistant. I have set up a recorder with Postgres at the moment. In my old system I have captured some data from various sensors for over a year and wanted to migrate the data too. I already moved those sensors to HA and they are working fine. I am going to use Grafana to visualise the data going forward and would like to have all the data in HA DB if possible. Since the states table has a foreign key to event_id’s, I guess I nee…

2. Another approximation is doing POST using API.
   Documented here: https://developers.home-assistant.io/docs/en/external_api_rest.html#post-apistatesltentity_id

   Requested by:

First-Utility.com (UK) Smart Meter Data

I have just had a smart meter installed by my utility company, First Utility. The monitor (IHD) that they provide is a very simple affair and evidently runs on the Zigbee protocol. To my knowledge, however, it is not possible to read the data going to this device. Instead, I have written a little python script that logs on to their website and downloads that day’s data in csv format. #!/usr/bin/env python import requests, datetime now = datetime.datetime.now() date = now.strftime("%Y-%m-%d")…

3. Maybe another is set a file sensor
   Documented here: File - Home Assistant but note:

   Only the last line of the file is used.

One of my idea is to create a utility meter component:

Utility Meter

utility_meter:
  daily_electricity:
    source: sensor.energy_in_kwh
    cycle: daily
  monthly_electricity:
    source: sensor.energy_in_kwh
    cycle: monthly

And we can use: sensor.integration (to help you convert Watt to KiloWatts) KWh = Power in W * time in minutes / (1000 * 60)

And I like the idea of number 1 and 2 (Database and POST solution) but for example of using “past date and time” inside a attribute when you POST state sensor, for the moment I can not get this.

If anyone have a “better” approximation or a final solution I will appreciate.

[szoller (Sebastian)]

Some time has passend, i am also looking for that, did you find a solution?

[fquinto]

Hi, during this time something happen, cost of energy it’s important, then: Energy Management in Home Assistant - Home Assistant
and devices around energy Integrations - Home Assistant
And with this new explanation you will have an idea: Understanding Home Energy Management - Home Assistant but not for “historical measures”.

Maybe I’m wrong but I haven’t (yet) been able to find a “simple” solution.

[dhellerstedt]

I have been trying to do this as well. Were you able to find a solution? I get hourly sensor day from utilityapi but the API end point is only updated once per day. I can get the last several months of hourly data, but not real-time.

[fquinto]

At the moment I have not found any solution to enter historical data.