Consulting databases

Moderator: leecollings

Post Reply
Mathiasdb
Posts: 21
Joined: Wednesday 04 December 2019 18:26
Target OS: Raspberry Pi / ODroid
Domoticz version: 2020.02
Location: Laarne, Belgium
Contact:

Consulting databases

Post by Mathiasdb »

Hi guys,

Can I consult databases of components like:
P1-port (el and Gas)
Z-wave powerswitch

I would like to export and back-up them.
If possible do some calculations in excell.

Thank you!

Grtz,
Mathias
User avatar
erem
Posts: 230
Joined: Tuesday 27 March 2018 12:11
Target OS: Raspberry Pi / ODroid
Domoticz version: 2021.1
Location: Amsterdam/netherlands
Contact:

Re: Consulting databases

Post by erem »

well, try an sqlite odbc driver....
here is one: https://github.com/softace/sqliteodbc
Regards,

Rob
User avatar
waltervl
Posts: 5149
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Consulting databases

Post by waltervl »

Perhaps you do not know but is is also possible to export the data in excel through the report function
1. click on Log button on the device
2. On the (for example) year graph click in menu item-download CSV.

It is also possible to click on the report button and download more data from earlier years.

But if you want to download all data you will have to go @erems way.
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest