Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

domoticz tables and mysensors

ebioz last edited by

Hi,
i am using mysensors on 3 arduinos that are collecting data with various sensors and managing the watering of my garden. Data is collected by domoticz on a RPI.
I am trying to get the data from domoticz to send it to another system that will allow to store it for a long time and external to my home as i don't want to open domoticz itself on internet.
I choose to pull the DB every minute to get last updated data. (bad idea ? better idea ?)

And domoticz database is far to be simple ... or logic.
I started with the table deviceStatus that have all the collected metrics. But i can't find the link between the table and the table my sensorChilds : how can i know that a device in deviceStatus is link to a node and child ?
i spent hours looking for the link and was not able to find how domoticz link it in the DB....

Thanks for your help.
Reply Quote 0
1 Reply Last reply

1
Posts

14
Views

Suggested Topics

eventsystem: problem writing file
Domoticz • • Feliw05

2

0
Votes

2
Posts

10
Views

Save the script directly from Windows and test if it can be opened in Domoticz.
Blockley in Domoticz-not working correctly. Anyone know how to fix.... ?
Domoticz • • Bren

3

0
Votes

3
Posts

28
Views

@Bren Did you set you script to "on"?
Removed childs not being recognised again
Domoticz • • grumpazoid

4

0
Votes

4
Posts

43
Views

Restarting domoticz might help next time, when you have original code running on that node again. Also some PIR cause radio interference, if i remember correctly, then hc sr501 should be ok.
Roller shutter(s_cover) on Domoticz
Domoticz • • Tmaster

8

0
Votes

8
Posts

895
Views

Someone know if it is problem with Domoticz or MySensors?
How to get the bad status (red) for Temperature Node
Domoticz • • giangired

5

0
Votes

5
Posts

55
Views

Thanks everyone for the answers. However what I would like to do is create a routine with Dzvents that when I have the "red" indication (as shown in the image) causes a switch to operate which cuts the voltage to a device. The value of ".lastUpdate.minutesAgo" seems not to be the right solution because it continues to be increased in any case, regardless of the temperature value and the status of the "red" or normal indication.
Calculate Delta T of two temperature sensors with lua
Domoticz • temperature • • Mela

1

0
Votes

1
Posts

9
Views

No one has replied
Trying to automate in Domoticz
Domoticz • • Feliw05

4

0
Votes

4
Posts

33
Views

the problem is "if (switch.state == 'On') then" that not works, write: if (switch.active) then or if (switch.inActive) then Device attributes and methods for all devices
help please
Domoticz • • clivec

4

0
Votes

4
Posts

69
Views

@mutantx, sorry for the late reply, but I was on holidays I've no experience with this sketch code, nor the hardware build of this mp3 player. Try to contact the author of this player or you can check the general documentation about the use of V_VARx / S_CUSTOM : https://www.mysensors.org/download/serial_api_20 Try to break up things in little pieces when accumulating knowledge about mysensors. Big complicated sketches can be overwhelming. I start always, when troubleshouting, with the cleanest version of the script, with minimum code required for operation. And then I build it up.