Home Automation Domotica Forum Europe, Bwired Forum

I take your point of the data relevancy. I'm always a back both horses kind of guy. So for the moment the data redundancy doesn't both me so much I think I'll set up multiple tables for quicker reference, then purge the main database for information older than 6 months. Try to get a balance Cheers D...

yes there is an flashing LED, this is how I'm recording it at the moment

I suppose I'm being picky but I wanted to leave the led uncovered so I myself could see it flashing or not.

A quick look, I can tell if I'm generating / exporting or importing.

ok not sure i understand

i connect a voltage to that pin ? it then changes the constant voltage into a pulse that you can read ?

I guess I've not put much thought into it when I set it up. I have 3 sensor rows every 30 seconds. So the table has we'll say the maximum resolution, which gives the flexibility that I can dig down to any detail but its not cpu friendly to get what I want when using max, sums etc. Would a good optio...

I know there are quite a few that monitor energy usage I'm interested on your database layout. I'm using mysql 5 and I have a single table that logs 3 sensors fields uniqueid = self explanitory sensorid = self explanitory reading = counter reading date = unix timestampe hour = 2 digit integer minute...

Hello, I've just had some solar panels fitted and now I need to monitor 3 seperate electrical usages Import Export Generation From this I can calculate what the house has used. So I've got 3 Iskra ME162 meters installed. on each meter there are 2 pinouts, 60 and 61 I'm told they are pulse ouputs The...

Anyone ever made / bought a circuit that could reboot a laptop ? I need the relay to operate as Closed for 10 seconds Open for 5 seconds Closed for 1 second Open This will power off the laptop and then power it back on. The reason for this is the dam think keeps crashing and I want to reset it remot...

Hello, Ive been looking into using my laptops built in modem to monitor incoming phone numbers opend hyperterminal and could communicate with the modem using AT commands. turned on Caller Display using AT+VCID=1 got the OK command back when the phone rings I only get a series of RING commands sent b...

bert as always thanks your a star.

Only moving the antenna into the horizontal position made a fantastic improvement

ps. yes i was talking about the RFXMeter

I've been increasing the number of sensors I use over the weekend. I have 2 USB rfxmodules 1 433mhz 1 310mhz On the 433 mhz module I have the following:- 2 x RFXcounter modules. An Oregon rain meter 4 Oregon temperature sensors On the 310 mhz module I have about 10 MS13 detectors. I've noticed that ...

Thanks Bert, I created an array of the 5 readings, if two are more of the same I record the reading.

sorry, bit dumb here, can you explain correct parity ?

how do you guys do error checking on your rfxmeter readings ? I have the following checks. If the previuos reading was taken less than 10 seconds ago ignore reading If the current reading is less than the previous reading AND the difference between the readings is more than 16000000 the meter has sk...

lo m8, just to let you know I think I've sussed it.

got insert, update and read working

used the mysql connector/net

thanks for the pointer

I don't have any problems using the connector/net. I've got that installed as well I think.

The thing I wasn't sure about was do you need to add references etc as well as installing the driver and using the code.

thanks for your help