Provide an example to import data from CSV

[arthurzenika]

Issue #3 talks about having an UI for importing CSV. Maybe a step forward would be to have some example code for people at ease with python to start manipulating / inserting data using this custom_component ? (am trying to figure out how ideenergy is using this module)

[beanonymous]

After revewing the code I noted that the function "async_update_historical" is some what important to relaying the data to HA in the file "sensor.py" but suspect that the real work is undertaken in file "api.py".

Based off the only function in that file "fetch" it appears to generate random data as what I can see generating in HA

@ldotlopez any chance you can provide a dummy example of the way you want the CSV data loaded into the sensor?

[pafnow]

Interested as well !

[ldotlopez]

Hi,

Historical sensors doesn't support importing from CSV (but it's feature I want to add).

@beanonymous, you are right, api.py just generates random (but stable) data, it simulates an external data provider.

The simplified schema is:

• api.py from example integration simulates the external API
• The example integration DelorianSensor.async_calculate_statistic_data it's called periodically by HistoricalSensor and uses that data to populate sensor.historical_states property
• Finally, HistoricalSensor.async_write_ha_historical_states reads that property and writes states and statistics to the database.

In order to import CSV data we need to define "how":

• import csv data into HistoricalSensor.historical_states and wait to HistoricalSensor.async_write_ha_historical_states to handle it?
• or wrap HistoricalSensor.async_write_ha_historical_states directly to import CSV data?
• or any other way

However, CSV data format should be very simple:
timestamp-or-ISO-8601 (UTC), value

Value needs to be parsed to native type in some second phase.