Support needed: I cannot insert a single value into my InfluxDB

Hello everyone,

I try to monitor water temperature, but the sensor got wet and produced useless values. Now I’m trying to get those values removed, but unfortunately I’m constantly failing.

Currently it looks like this:


SELECT mean(“value”) AS “mean_value” FROM “homeassistant”.“autogen”.“°C” WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND “entity_id”=‘esp_temperatur_aquariumwasser’ GROUP BY time(:interval:) FILL(null)

To replace (or remove) values >30, I tried to use the script from here, because I thought this would be the easiest way. But I guess I’m simply failing, because I do not understand the basics of this DB.

When I send something like this, it tells me that something has been successfully written into the database, but I have no clue what I did:

python -s -i data.csv --dbname homeassistant -p XXX -u homeassistant --fieldcolumns °C.mean_value -tc timestamp

The CSV file looks like this:

2023-10-03 17:43:12,24.99

The content of the CSV file looks like what I got from exporting values using the UI and I thought, a file to import should look similar, but somehow I guess I’m missing the entity_id, or?

It would be nice, if somebody could point me into the right direction :wink: