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
Consulting databases
Moderator: leecollings
- 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
well, try an sqlite odbc driver....
here is one: https://github.com/softace/sqliteodbc
here is one: https://github.com/softace/sqliteodbc
Regards,
Rob
Rob
- waltervl
- Posts: 5152
- Joined: Monday 28 January 2019 18:48
- Target OS: Linux
- Domoticz version: 2024.7
- Location: NL
- Contact:
Re: Consulting databases
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.
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
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
Who is online
Users browsing this forum: No registered users and 1 guest