Xtrusion Domotica Project

[123unlock]

How it all started:
about 10 years ago I got my own apartment.. as I love IT and automation ofcourse things where automated there
I modified an KAKU switch and connected this directly to the LPT port of my computer, that way I was able to switch 4 things
the lights in the living room, the kitchen, the bedroom, and the coffee machine so every morning I had fresh coffee (old style filter coffee hehe)

later we moved to our current home, and from there I decided to start over again
I bought more KAKU devices, and an RFXTRX433 to switch things on and off, a few months later I also added Oregon thermo stuff, and an youw8 scale

as things where getting bigger now I also made a website so I was able to control stuff by mobile phone.
more and more devices where connected, and now also a realtime website at http://www.xtrusion.nl came online

when I saw the energy bill I really got shocked.. over 6700kWh used for 2 adults and a baby so it was time to save some energy too
I bought plugwise, and started switching things on and off.. but the domotica server (normal PC) was still consuming 300+ watts

in 2013 we got the option to buy our current rental home.. and so we did..
one month later we had 10 solar panels on the roof, and the inverter was integrated in the home automation
the old domotica pc is replaced by an laptop with SSD, and all scripts are completely rewritten from scratch and running all in PHP
the old CV installation is replaced by a new Remeha Calenta and of course also an openthem gateway was put in between.
Also all radiators in the home where replaced by more efficient ones. as it was still not comfortable enough we also put isolation in the attic and in the
walls (neoperls), on the first floor the windows where single glass so we replaced them with HR glass, all this together saves us a huge amount of gas, and makes
it a lot more comfortable.. especially in the bedrooms (January 2013 the temp in one room was hot higher than 13 degrees with heating at 21 now with the heating at 15 in the
night it's not getting colder than 17 degrees)

Also all lights in the house are replaced by LED, this saves us more than 80% on electricity for the lights

Precense detection was add tot he system based on mobile phone wifi connections, so if no-one is home we don't need to turn on the lights
and we can put the CV to low temperature (saves more gas)

a "short list of all domotica related projects" done in the house till now
- Kaku integrations with rfxtrx443
- Oregon integration
- Automated ventilation system for bathroom
- Plugwise integration
- Solar panel integration
- Remeha calenta integration with opentherm gateway
- Z-Wave Clamp energycounters and switching
- 1-Wire bus temp monitoring
- Weather station integration
- RFX meter + pulsecounters for gas and water usage
- Door and window sensors
- Fritzbox integration with push notifications (NMA), and caller display on television
- Movement sensors for alarm and to switch lights
- Webcam at the front door, when the doorbell is pressed I get a picture on the phone and an NMA notification
- Mailbox automation, with NMA and webcam screenshot
- Television Setupbox integration
- Smart Switching
- Roomba vacuum cleaner integration with roowifi
- many more

All those options are not only really cool.. but also saves me over 1500+ euro on my yearly bill for gas and electricity

most of the devices are also visible on the website at http://www.Xtrusion.nl and reporting back realtime

some plans for this year
- home-build DBE on the radiators (fans already ordered)
- 2 more solar panels on the roof of the shed
- floor isolation ? maybe
- automated roller shutters on first floor
- stairway renovation
- any cool stuff that comes up hehe

[Digit]

Impressive!
Personally I'm very interested in your plans with DBE, I've considered it but other things had a higher priority.
And since it looks like winter will be skipped this year I have decided to wait until the next one

[Bwired]

Nice indeed!

[jeroen_]

Cool project, nice description; any technical details on how you hooked it all together? Seems there is PHP + MySQL involved in it.

PS: You have a typo, "Incomming" instead of "Incoming" in the POTS/VoIP part of your site.

[123unlock]

Cool project, nice description; any technical details on how you hooked it all together? Seems there is PHP + MySQL involved in it.

PS: You have a typo, "Incomming" instead of "Incoming" in the POTS/VoIP part of your site.

Thnx i corrected it on the site

about the tech specs
system is running on a laptop with SSD consuming around 15 watts
as backend i use a mysql database, and a serial to socket server service
that way i'm able to open a socket in PHP directly to the serial port

the PHP programs are running in a loop, so listen for any RX bytes, and store info to the DB
there is also an queue on the db for TX, each loop the script polls the DB to see if there is new data to send
when it found something it will send it to the socket.

each device has his own PHP script, so i have one for z_wave, rfxtrx, solarpanels, opentherm, fritzbox, etc that way the "loop" in the scripts is extreme short (in the past i had one application in vb6 with all devices in, but as there where more and more things integrated it became slower in response, till now this solution is pretty fast (for ex, if you press the doorbell my phone buzzes on almost same time with the NMA alert)

[Dylantje]

Whaow ....
And made ​​that yourself?

How open is your project?
What hardware is it runnning?
Is there a layout for Domoticz possible, to use?

You are using an Vu Ultimo!? PLi with it?
How and what do you mean working in your home automation?.

Solar panels, how about those in your system?

Bizarre your website ..

Do have 100 questions ...

[123unlock]

Whaow ....
And made ​​that yourself?

How open is your project?
What hardware is it runnning?
Is there a layout for Domoticz possible, to use?

You are using an Vu Ultimo!? PLi with it?
How and what do you mean working in your home automation?.

Solar panels, how about those in your system?

Bizarre your website ..

Do have 100 questions ...

Hiya

in the past i tried several domotica packages, but none of them was flexible enough for me.. i want to have total control over what is happening, and since my programming background i dont need any nice and fancy gui.. just a simple notepad is enough.. so the project is not really suitable for others, as most of the applications is especially written for my situation

it's all running on a windows 7 laptop with 4gb memory and a 256gb ssd, about the television
the vu+ultimo with openpli has a webinterface you can "use" to extract data or send commands

example to get current playdata:

Code: Select all

$xml = simplexml_load_file("http://root:<password>@192.168.0.182/web/getcurrent");
$data = $xml->e2eventlist->e2event;
$channel = $data->e2eventservicename;
$playing = $data->e2eventtitle;

or send a text popup msg (in case someone is calling on the phone)

Code: Select all

$xml = simplexml_load_file("http://root:<password>@192.168.0.182/web/message?text=".$message."&type=1&timeout=10");

via my tablet/ phone interface i'm also able to switch channels etc.




At the roof we have 10 solarpanels connected to an solarriver invertor
this invertor has a serial port, as i already have network in that corner of the attic (for the opentherm) i bought a serial to ethernet convertor
on the computer is a comport created mapping to the ip adres of the convertor, in the tech-specs was a lot of info about the protocol so within a couple of hours i was able to receive the data from the invertor.

some picture of the "server" screen with all the modules running

[Phaeton]

Hi, is this php only? How do you do a cronjob? Windows Task manager?

Verstuurd vanaf mijn GT-I9300 met Tapatalk

[Phaeton]

Nice setup btw.

Verstuurd vanaf mijn GT-I9300 met Tapatalk

[Dylantje]

Respect...
With PLi...... I dream of that.

How open is your project?
Share it?

[123unlock]

Hi, is this php only? How do you do a cronjob? Windows Task manager?

Verstuurd vanaf mijn GT-I9300 met Tapatalk

yes with taskmanager, just make a call to the c:\php\php <script.php> <Parameters>

in PHP use:

Code: Select all

$arg = $_SERVER['argv'];
print_r($arg);

now you have each parameter in the $arg[x] array available, so can use one script for multiple tasks based on parameter

I use this for example to start vacuum cleaner at 2am in the night, or start my "wakeup light" (dim spots in bedroom from 0 to 100% in in 5 minutes) at 6.15am

[123unlock]

Respect...
With PLi...... I dream of that.

How open is your project?
Share it?

integrating PLI should be easy for other projects too
there is a very well documented API, response from the box is always in XML so easy to parse

see for openpli API:
http://dream.reichholf.net/wiki/Enigma2:WebInterface

you only need to make an http call to your box, use parameters as HTTP GET (for channel switching etc) and get results back in XML

[Dylantje]

@ 123.


When i have more time i will try... [ thanks!!]
So i think i can make a dummy switch and in that switch i place the code for what action i want?
Is that the way?

[123unlock]

@ 123.


When i have more time i will try... [ thanks!!]
So i think i can make a dummy switch and in that switch i place the code for what action i want?
Is that the way?

yes, that should be the way
what that solution i remember again why i wrote my own system hehe one API that can be controlled directly over http calls this saves me a lot of time for making switches for each function

[Dylantje]

@123
May I ask what nice automation solutions you continue in your system.
And then focus on PLi