serial reading

[jendrush]

I have little success too. I modified some code from other project, and now i can report temperatures(DS18B20), temperatures + humidity(DHT22), motion sensor to Domoticz. Today i will try to handle turning on, and off a switch, and also i am planning to modify relay code to handle my wireless 433MHz wall plugs to work as normal relay. Next time maybe reading status of power meter? But in this case i see a problem - how to read last value of acumulated energy from Domoticz? Now some information about solution. Serial gateway is connected to Raspberry Pi(Domoticz), and there is Node.js script. Script can read, and send messages through serial, and post links to Domoticz by JSON.

[jendrush]

And screenshoot http://screenshooter.net/1288732/gimyqda

[BulldogLowell]

@jendrush

very nice!

[jendrush]

Now i am lack of arduinos, DHT22 is connected directly to atmega on breadboard:) Maybe i recieve this week few of 4 i've ordered lately.

I have one Stellaris launchpad, someone tried to make it work with mysensors? :)

[hek]

:thumbsup:

[epierre]

@jendrush you can see from my Xively script how to do it: http://www.domoticz.com/wiki/Perl_for_Domoticz#Pachube_.2F_Cosm_.2F_Xively, in short you get all the nodes, you aprse the one you need, and you get the data field, first one is instant, second cumulated separated by a semicolon (";").

To push data, please see http://www.domoticz.com/wiki/Domoticz_API/JSON_URL's#Electric.28Instant_and_Counter.29, I updated it recently.

BTW, as you can see in the first script, I post all my values to Xyvely/COSM/Pachube... but this is another story for I made modification yesterday and I've not reported them to the wiki yet.

[epierre]

Ok so today I've added a conf file reading, and started to work on the database model (hardware-device-sensor) in sqlite3 to keep track of last known value and last affected sensor id. This speeds up the whole thing at startup.

Next step is to store all devices data in the table, and update them whenever they are received.

Afterward, I'll try creating a new sensor automatically, and then try to extend it to other sensors type.

If anyone is interrested in trying it (very beta yet...)...

[jendrush]

@epierre I wish to see the code:)

[epierre]

Hello,

This is very alpha, it handles only one node with id=1 till I manage the sqlite3 database fully (data model is not right yet...).
mysensors-gw.pl : main file, reader, tested only with DHT11 Temp+Humidity
.conf-mysensors : conf file to set serial port, domoticz IP/PORT, hardware device (for future virtual sensors creation, I prefer to leave it configurable by now)

github repository

You will need those packages:
sudo apt-get install libdevice-serialport-perl libdatetime-perl libdbd-sqlite3-perl libdbi-perl sqlite3 libjson-perl libfile-slurp-unicode-perl libwww-perl libconfig-simple-perl

Discussion:

• What I need to see is how to handle existing nodes that wouldn't be in the database, I thought of a config file ? In RFX433 devices, when you change the battery, it resets all ... painfull... here I would like to avoid this situation but this will be complicated without a GUI.
• Other point, to send orders, I would need to have some JSON API, or a script that is called from the DZ to interract with the sensors. the Gateway.py from @wannabee does it.
• I will try maybe to implement the same conf file than @wanabee link text for he has identified the same issues as me, meaning all mapping of a sensor will be done in the conf file (see wiki)

[jendrush]

@epierre I will try to use MySQL with my project.

[epierre]

@jendrush mysql is only a small conf change (replace dbi:SQLite:dbname=mysensors.db by DBI:mysql:database=$database;host=$hostname;port=$port ;-)