I am to stupid, please help with import of data

[prawnhitter]

Hello everybody, i am officially too dumb to import stuff.
I installed spook and went to the recorder describes as https://spook.boo/recorder/

But now every input (even the example) are not working.

Now en detail:
I have an photovoltaic system with historical data.
Data.csv

I do have the equivalent sensors (eg Household Energy) -> Coloum D in Data.csv
history.csv

now i want to import these data into that sensor but:
1st im not sure if everything is correct the data from history is in "W" but the data from data is in "kW". do i need to convert it first?

2nd do i need the +02:00 when i put the correct time in?

Now when i press Call Service
i do get the Error "Failed to perform the action recorder.import_statistics. expected a list for dictionary value @ data['stats']. Got None"

Where do i make a mistake?

Greetings Andreas

[Blogshot]

The issue is that the screenshot in the documentation is not correct.

If you look at the yaml-version of the action, you will see that your input equals to something like:

data:
  has_mean: false
  has_sum: false
  statistic_id: sensor.xxx
  source: csv
  unit_of_measurement: kW
  stats:
    start: "2024-12-30 00:06:04+02:00"
    state: 0.631348

The attribute "stats" expects a dictionary, so you need to input exactly that:

data:
  has_mean: false
  has_sum: false
  statistic_id: sensor.xxx
  source: csv
  unit_of_measurement: kW
  stats:
    - start: "2024-12-30 00:06:04+02:00"
      state: 0.631348

(Each - is the beginning of a new value to import. This means if you format it correctly, you should be able to import many entries at once.)

There are some other issues as well: In my testing, only recorderworked as a source. And because the statistics are aggregated by time in hours, you cant set minues or seconds, so you must set them to 00. A valid yaml could look like this:

data:
  has_mean: false
  has_sum: false
  statistic_id: sensor.xxx
  source: recorder
  unit_of_measurement: kW
  stats:
    - start: "2024-12-30 00:00:00+02:00"
      state: 0.631348

In my case, the import worked after some tinkering.

[thibaultmol]

I'm also having issue and probably something stupid I'm overlooking...

action: recorder.import_statistics
data:
  has_mean: false
  has_sum: true
  statistic_id: sensor.fluvius_totaal_productie_energie
  source: recorder
  unit_of_measurement: kWh
  stats:
    - start: "2026-03-01 00:00:00+01:00"
      sum: 28902.352
    - start: "2026-03-01 01:00:00+01:00"
      sum: 28902.352

nothing in the history after I refresh.

sensor.fluvius_totaal_productie_energie is an entity created from a helper grouping two entities together as a sum. but I wanted to backfill it with old data

[thibaultmol]

Is there a problem if the intervals don't match?

current data is:

statistics:
  sensor.fluvius_totaal_productie_energie:
    - start: "2026-03-30T13:20:00+00:00"
      end: "2026-03-30T13:25:00+00:00"
      sum: 0.01299999999901047
    - start: "2026-03-30T13:25:00+00:00"
      end: "2026-03-30T13:30:00+00:00"
      sum: 0.013999999999214197
    - start: "2026-03-30T13:30:00+00:00"
      end: "2026-03-30T13:35:00+00:00"
      sum: 0.016999999999825377
    - start: "2026-03-30T13:35:00+00:00"
      end: "2026-03-30T13:40:00+00:00"
      sum: 0.018000000000029104
    - start: "2026-03-30T13:40:00+00:00"
      end: "2026-03-30T13:45:00+00:00"
      sum: 0.01900000000023283
    - start: "2026-03-30T13:45:00+00:00"
      end: "2026-03-30T13:50:00+00:00"
      sum: 0.021000000000640284

but the data i'm trying to add is 15' instead of 5'

[Blogshot]

The first one I can not explain, maybe sum is just the wrong attribute. I believe that the sum will be calculated by the system based on the values, so try to just work with state.

The intervals are not relevant, but since you need to round to the full hour, minutes are not allowed as far as i know.