Search found 48 matches

by Romac
Sat May 27, 2017 9:59 pm
Forum: For Sale Forum (Dutch allowed)
Topic: [Te koop] Xanura X10 (veel), RFXcom spullen.
Replies: 32
Views: 31395

Re: [Te koop] Xanura X10 (veel), RFXcom spullen.

Ok, ik hoor het graag.


Sent from my iPhone using Tapatalk
by Romac
Fri May 26, 2017 7:49 am
Forum: For Sale Forum (Dutch allowed)
Topic: [Te koop] Xanura X10 (veel), RFXcom spullen.
Replies: 32
Views: 31395

Re: [Te koop] Xanura X10 (veel), RFXcom spullen.

Is de RFXMeter nog beschikbaar? Zo ja, wat is de vraagprijs?


Sent from my iPhone using Tapatalk
by Romac
Thu Feb 25, 2016 7:41 am
Forum: Questions & Discussions Forum
Topic: Database design
Replies: 31
Views: 52815

Database design

Thanks for your reply. I managed to get some graphs generated where I display daily use. Now working on getting the hourly use visible.


Sent from my iPhone using Tapatalk
by Romac
Sun Feb 21, 2016 9:44 pm
Forum: Homeseer algemeen Forum
Topic: Zonnepanelen en homeseer
Replies: 56
Views: 66359

Re: Zonnepanelen en homeseer

Dank je wel. Dan zal ik een poging wagen via de api. Laten we hopen dat deze informatie nog een keer beschikbaar komt. Het moet er wel zijn, want de webportal kan het wel weer geven....
by Romac
Sun Feb 21, 2016 8:33 pm
Forum: Homeseer algemeen Forum
Topic: Zonnepanelen en homeseer
Replies: 56
Views: 66359

Re: Zonnepanelen en homeseer

Ik ben me aan het oriënteren op zonnepanelen en waarschijnlijk gaat het dan ook een SolarEdge omvormer worden. Nu heb ik begrepen dat de SolarEdge zowel via de ethernet connectie (json) en via de rs485 port is uit te lezen. Ik ben echter neg niet tegengekomen dat de data dan ook op paneelniveau toeg...
by Romac
Mon Feb 08, 2016 12:12 am
Forum: Questions & Discussions Forum
Topic: Database design
Replies: 31
Views: 52815

Re: Database design

Thanks Rene. At the moment all my data is in SQL Server and would like to stay with this solution. Just looking for a SQL query to group the data by day/week/month/year...


Sent from my iPhone using Tapatalk
by Romac
Sun Feb 07, 2016 10:15 pm
Forum: Questions & Discussions Forum
Topic: Database design
Replies: 31
Views: 52815

Re: Database design

Finally back on this topic and trying to make it more visable. Having now lots of data, I'm trying to make some nice graphs. For this I'm using Highcharts which is working quite well for data I can read directly from the database. I just struggle to setup a query to calculate the delta per day or pe...
by Romac
Tue Dec 09, 2014 11:05 pm
Forum: Off Topic
Topic: Wifi network with 3 AP's
Replies: 21
Views: 27944

Re: Wifi network with 3 AP's

I have just purchased and in installed two Ubiquiti ap's. They work great. I have one on the ground floor and one on the second floor. Everywhere I have excellent wifi reception. Devices roam from one ap to the other without noticing. The management software is vey nice to setup and monitor your dev...
by Romac
Sun Mar 16, 2014 9:43 am
Forum: Questions & Discussions Forum
Topic: Database design
Replies: 31
Views: 52815

Re: Database design

It working!! :) I ended up doing it differently but the solutions posted here pointed me in the right direction. For anybody struggling to get this to work, this is what I did (using HS3). I run the below script every time a device value changes. 'Log to Database for HS3 'WR. Muller '08/03/2014 'Ver...
by Romac
Thu Mar 13, 2014 11:21 pm
Forum: Questions & Discussions Forum
Topic: Database design
Replies: 31
Views: 52815

Re: Database design

Thanks Digit. This is much appreciated. I will have a look at your query and try to implement in my system. The query is definitely different and more complex then what I am running now.
by Romac
Thu Mar 13, 2014 9:35 pm
Forum: Questions & Discussions Forum
Topic: Database design
Replies: 31
Views: 52815

Re: Database design

Bringing up this topic as I have been working on a historical database for my energy reading. I'm using Homeseer 3 to load the changed values to a database table in SQL Server and used the approach outlined in this topic. I have for each hour a record, starting at the beginning of the hour and updat...
by Romac
Thu Feb 27, 2014 8:59 pm
Forum: Homeseer P1 Smart Meter - Plugin HS3
Topic: Versie 3.0.0.3
Replies: 3
Views: 6742

Re: Versie 3.0.0.3

Super bedankt! :) Dat werkt perfect. Ik zie nu ook het gas verbruik per dag en het totaal verbruik.
by Romac
Mon Feb 24, 2014 10:38 pm
Forum: Homeseer P1 Smart Meter - Plugin HS3
Topic: Versie 3.0.0.1
Replies: 13
Views: 14917

Re: Versie 3.0.0.1

Perfect!

En lang leve de standardizatie ...... :)


Sent from my iPad using Tapatalk
by Romac
Mon Feb 24, 2014 10:12 pm
Forum: Homeseer P1 Smart Meter - Plugin HS3
Topic: Versie 3.0.0.1
Replies: 13
Views: 14917

Re: Versie 3.0.0.1

Ik heb geen teruglevering. Netjes dat de plugin deze waarden dan ook niet laat zien. Een gasmeter heb ik wel en deze is gekoppeld. De gegevens komen als volgt binnen:

0-1:24.2.1(140215110000W)(00081.926*m3)

Volgens mij is dat anders dan bij de andere meters.
by Romac
Mon Feb 24, 2014 8:57 pm
Forum: Homeseer P1 Smart Meter - Plugin HS3
Topic: Versie 3.0.0.1
Replies: 13
Views: 14917

Re: Versie 3.0.0.1

De plug-in werkt en de data stroomt binnen. Super! Ik heb alleen wel het idee dat er wat wijzigingen zijn in het protocol van de nieuwe meter. Ik mis ook een aantal waardes ten opzichte van het screenshot in de eerste post. Ik weet niet of dit aan te passen is. Eventueel heb ik wel een omschrijving ...

Go to advanced search