Search found 8 matches
- Wednesday 15 February 2023 23:12
- Forum: Python
- Topic: extract mysensor data
- Replies: 16
- Views: 1275
Re: extract mysensor data
the final goal of the export is to display on an external website the data by location, by node or by type of sensor. So i need to know of witch node belongs each probe. So need relation between device_id and node-child.... So my message to domo devs is : use the same rules of data mapping for all ...
- Wednesday 15 February 2023 16:09
- Forum: Python
- Topic: extract mysensor data
- Replies: 16
- Views: 1275
Re: extract mysensor data
for example i have 3 weather stations with 4 probes : (temp-hum-baro-lux) The code is the same, some same sketch name, same childs ids, but node id is not the same. Examples of the db domoticz complexity For temp, hum and baro : in devicestatus.deviceid we have something stored in int format to ...
- Wednesday 15 February 2023 14:43
- Forum: Python
- Topic: extract mysensor data
- Replies: 16
- Views: 1275
Re: extract mysensor data
Hi, What i want to get from domoticz every minute is the following information for each device that is a domoticz device ( probe ) : - domoticz device id - my Sensor node id - my sensor child id - type-subtype of value - value of the measurement - date And my script with it will insert the data in ...
- Sunday 12 February 2023 13:33
- Forum: Python
- Topic: extract mysensor data
- Replies: 16
- Views: 1275
Re: extract mysensor data
To sump up what i am looking for is : - if i have a deviceStatus.id value, how can i do the link with the nodeid in mysensor.id - how to group the domoticz devices by nodeId The nodeId refers to the "arduino" that have the sensors and collect the data. If a solution by API exists i whould be very ...
- Thursday 09 February 2023 21:32
- Forum: Python
- Topic: extract mysensor data
- Replies: 16
- Views: 1275
Re: extract mysensor data
indeed code is available... i had a look on it. Code is very poor regarding comments.... and is there that a i found that the nodeid information is spread in various columns depending on device type without any visible logic... And yes you are right i am not suppose to get infos from DB but from ...
- Wednesday 08 February 2023 21:24
- Forum: Python
- Topic: extract mysensor data
- Replies: 16
- Views: 1275
Re: extract mysensor data
i didn't know this domoticz capabilities to send data. Interesting i will explorate the http later. But i am still looking for the rules used to populate the devicestate table. Because influx just relay the contents of this table. Sometimes childId will be in unit column, sometimes it is encoded in ...
- Tuesday 07 February 2023 22:53
- Forum: Python
- Topic: extract mysensor data
- Replies: 16
- Views: 1275
Re: extract mysensor data
thanks for your reply. In my case i pool domoticz db every minute but i only take data that is older less than one minute. And it works well. Here my issue is to have the link between deviceStatus and mysensor tables. I started to read the source code and it seems that something id encoded in the ...
- Tuesday 07 February 2023 22:01
- Forum: Python
- Topic: extract mysensor data
- Replies: 16
- Views: 1275
extract mysensor data
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 ...