Push example_CALENDAR fields to influxDB

[JakeOfOz]

Hi!

I'm reading my smart meter and solar inverter values via Domoticz. I also have InfluxDB and Grafana set up to show all the data. I notice that in Domoticz, it's possible to see the daily values from both the meter and inverter, but I can't push those values to Influx (only the current readings, not the total of the current day).

I CAN find these values in domoticz.db, in the Meter_Calendar table. Is there a way (probably via a script) to push these values to InfluxDB? this way I can have all my data in one DB.

EDIT:
I also see that when I try to read these values directly via SQLite, I can only see the values from a 'complete' day, so not the current sum of the energy produced. Is there also a way to show this?

[waltervl]

You can publish these summary data directly in Grafana without the need to send them to influxdb. Use the Grafana SQLite plugin. See the following topic for examples: viewtopic.php?f=21&t=35101

[JakeOfOz]

Yea I know I can read them from Domoticz directly, but I want to push them to Influx (so that I have one DB, and one thing to backup). Also: my issue with reading from Domoticz is that I can only show the values from yesterday, not the current value for today.

[waltervl]

It is of course totally up to you but you have already a database: Domoticz.
Current data is in the other tables as discussed also in the Grafana SQLite plugin topic.
It depends on the log setting you use but after 1 to 7 days the current values (every 5 min) are summarized and placed in the calendar tables. So in Grafana you can merge them in 1 graph if you feel the need.

[JakeOfOz]

I know this. I have already tested both SQLite and InfluxDB. Influx gives better 'resolution', since the values are stored in a shorter interval.

My question is: Can I send the values FROM the domoticz xxx_Calendar -tables TO Influx (via dzVents or whatever)

[waltervl]

If you keep on sending the data to influxdb this is not needed. In the end all data will come in influxdb. You now only miss the history data you have not sent yet.
You have to check if you can send that history data with sql statements from SQLite to influxdb.

Personally I think it is better to keep the Domoticz database backed up because it stores more than only the sensor data. For example also the DzVents scripts from the event system. There is an automatic backup scheme that you can enable in the settings menu.