Watermeter lezen met raspberry en Inductieve NPN sensor Topic is solved

[u01pei]

Hello, I want to include water-usage in my Domoticz as well, and although it will be dificult to get a wire running between the metercabinet in the hallway where the water-meter is and my livingroom where I have my Raspberry Pi, I am guessing it is going to be the only way...

So: 2 questions:
First off: the device in Domoticz you have a screenshot of is a counter that is modified to display water. I can reproduce that, but I also see a type "Counter incremental". What is the difference between these two, and following that: what is the correct one to use?
Aside from that: Can I connect the blue and brown wires to another power supply, and just the black one to the Pi or does that not work? That would save me 2 wires that I have to move through the rooms... Also: is it a problem if the signal-wire is relatively long? Say, 10 meters?

Oh, and do you need to use any resistor or anything before the signal-wire goes ino the GPIO, or can the Pi handle the output from the sensor as-is?

Why don't you connect the sensor to an esp8266? with esp easy installed on it, I find it is the best solution to get data wireless to your pi. I bought https://www.aliexpress.com/item/new-Wir ... 0.0.RhBndZ

[pvangorp]

Thats also a way of fixing it

[pvangorp]

I've upgraded my script by adding a "uservariable" this makes it possible to set the initial value and to make a correction when your PI is off for a while. Create a user variable called "WaterMeter" and enter the meter value eg "999999" (Where "999999" = 999.999m3). When the value is "0" it ignores the user variable.
I also added a variable for IDX, to make it easier to change the script.
So you don't need the line

To set the initial meter values http://<<YOUR DOMOTICZ IP>>/json.htm?type=command&param=udevice&idx=34&svalue=999999

any more

My updated script

Code: Select all

commandArray = {}

-- Set IDX of Watermeter
iIDX = 34

-- Set Watermeter based on user variable "WaterMeter"
if ( uservariables["WaterMeter"] > 0 ) then
    print("Water usage is set to " .. uservariables["WaterMeter"] / 1000 .. "m3 by user")
    commandArray['UpdateDevice'] = ''..iIDX..'|0|'..uservariables["WaterMeter"]..''
    commandArray['Variable:WaterMeter'] = tostring(0)
end

-- Water usage
-- Retrieve value from water meter device:
sWaterUsage = otherdevices_svalues['Waterverbruik']

-- To have a better readable format, divide number by 1000:
sWaterUsagePrint = tonumber(sWaterUsage / 1000);

-- calculation is done with the unmodified water value
sWaterUsage = tonumber(sWaterUsage);

-- For Debuging
-- print("Water usage until now is " .. sWaterUsagePrint .. "m3 ")
-- print('GPIO Watermeter = '..otherdevices['GPIO Watermeter'])

function timedifference(s)
   year = string.sub(s, 1, 4)
   month = string.sub(s, 6, 7)
   day = string.sub(s, 9, 10)
   hour = string.sub(s, 12, 13)
   minutes = string.sub(s, 15, 16)
   seconds = string.sub(s, 18, 19)
   t1 = os.time()
   t2 = os.time{year=year, month=month, day=day, hour=hour, min=minutes, sec=seconds}
   difference = os.difftime (t1, t2)
   return difference
end

if (devicechanged['GPIO Watermeter'] == 'Off')
then
	sWaterUsageTot = (sWaterUsage + 1)
	
	print("Water usage is set to " .. sWaterUsageTot / 1000 .. "m3 ")
	commandArray['UpdateDevice'] = ''..iIDX..'|0|'..sWaterUsageTot..''
else
    -- Keep a live device
    if (timedifference(otherdevices_lastupdate["Waterverbruik"]) > 300)
    then
        print("Water usage is still " .. sWaterUsage / 1000 .. "m3 ")
        commandArray['UpdateDevice'] = ''..iIDX..'|0|'..sWaterUsage..''   
    end
end

return commandArray

[Hobbybob]

Hello, I want to include water-usage in my Domoticz as well, and although it will be dificult to get a wire running between the metercabinet in the hallway where the water-meter is and my livingroom where I have my Raspberry Pi, I am guessing it is going to be the only way...

So: 2 questions:
First off: the device in Domoticz you have a screenshot of is a counter that is modified to display water. I can reproduce that, but I also see a type "Counter incremental". What is the difference between these two, and following that: what is the correct one to use?
Aside from that: Can I connect the blue and brown wires to another power supply, and just the black one to the Pi or does that not work? That would save me 2 wires that I have to move through the rooms... Also: is it a problem if the signal-wire is relatively long? Say, 10 meters?

Oh, and do you need to use any resistor or anything before the signal-wire goes ino the GPIO, or can the Pi handle the output from the sensor as-is?

Why don't you connect the sensor to an esp8266? with esp easy installed on it, I find it is the best solution to get data wireless to your pi. I bought https://www.aliexpress.com/item/new-Wir ... 0.0.RhBndZ

I have somthing setup now with a wire, but perhaps for future sensors (I don't think this will be the last one I connect). Is there a wiki or tutorial or anything on how to connect and configure one of these for usage in Domoticz? I'm very interested.

[u01pei]

I have somthing setup now with a wire, but perhaps for future sensors (I don't think this will be the last one I connect). Is there a wiki or tutorial or anything on how to connect and configure one of these for usage in Domoticz? I'm very interested.

Yes there is:

https://www.letscontrolit.com/wiki/index.php/ESPEasy

[ratjenl]

I received another 2 sensors. Both are working fine except one wont read through the plastic on my watermeter. As far as i can see i have the same meter posted here in this topic.

Can anybody explain why i don't get the liters but the total amount as stated in the attachment ?

[pvangorp]

Disconnect it from your pi and test it with a 9v battery. The higher the voltage, the bettter the detection. When it works oke you'll need a 9v or 12v adapter and a step-down converter otherwise you'll fry your pi.

The litres is only the first day. The counter is set initially today.

[ratjenl]

One is working from within the pi, the other one just isn't strong enough even with an 12v or 24v adapter is just doenst read through the plastic. I guess there is a slight difference in both npn's.

[Hobbybob]

One is working from within the pi, the other one just isn't strong enough even with an 12v or 24v adapter is just doenst read through the plastic. I guess there is a slight difference in both npn's.

I had the same problem. The sensor worked when I tested it by holding it against something metal, but the plastic top on the watermeter was too thick or something. Also with a 12v adapter. I now have a working setup with a tcrt5000 with the help of heggink. That uses an infared detector, maybe you could look at that.

[D'rMorris]

I received another 2 sensors. Both are working fine except one wont read through the plastic on my watermeter. As far as i can see i have the same meter posted here in this topic.

Can anybody explain why i don't get the liters but the total amount as stated in the attachment ?

If you share your script we can have a look. Perhaps you are mixing up nvalues and svalues?

[LouiS22]

I received another 2 sensors. Both are working fine except one wont read through the plastic on my watermeter. As far as i can see i have the same meter posted here in this topic.

Can anybody explain why i don't get the liters but the total amount as stated in the attachment ?

1 m3 is 1000 liter. So your screenshot seems correct. 914 m3 is 914000 liter.

One more thing: have you set the divider at domoticz's settings page (Settings/Meters-Counters/) (as stated on the first post)? Maybe that'S the step you missed.

[gielie]

I've upgraded my script by adding a "uservariable" this makes it possible to set the initial value and to make a correction when your PI is off for a while. Create a user variable called "WaterMeter" and enter the meter value eg "999999" (Where "999999" = 999.999m3). When the value is "0" it ignores the user variable.
I also added a variable for IDX, to make it easier to change the script.
So you don't need the line

To set the initial meter values http://<<YOUR DOMOTICZ IP>>/json.htm?type=command&param=udevice&idx=34&svalue=999999

any more

My updated script

Code: Select all

commandArray = {}

-- Set IDX of Watermeter
iIDX = 34

-- Set Watermeter based on user variable "WaterMeter"
if ( uservariables["WaterMeter"] > 0 ) then
    print("Water usage is set to " .. uservariables["WaterMeter"] / 1000 .. "m3 by user")
    commandArray['UpdateDevice'] = ''..iIDX..'|0|'..uservariables["WaterMeter"]..''
    commandArray['Variable:WaterMeter'] = tostring(0)
end

-- Water usage
-- Retrieve value from water meter device:
sWaterUsage = otherdevices_svalues['Waterverbruik']

-- To have a better readable format, divide number by 1000:
sWaterUsagePrint = tonumber(sWaterUsage / 1000);

-- calculation is done with the unmodified water value
sWaterUsage = tonumber(sWaterUsage);

-- For Debuging
-- print("Water usage until now is " .. sWaterUsagePrint .. "m3 ")
-- print('GPIO Watermeter = '..otherdevices['GPIO Watermeter'])

function timedifference(s)
   year = string.sub(s, 1, 4)
   month = string.sub(s, 6, 7)
   day = string.sub(s, 9, 10)
   hour = string.sub(s, 12, 13)
   minutes = string.sub(s, 15, 16)
   seconds = string.sub(s, 18, 19)
   t1 = os.time()
   t2 = os.time{year=year, month=month, day=day, hour=hour, min=minutes, sec=seconds}
   difference = os.difftime (t1, t2)
   return difference
end

if (devicechanged['GPIO Watermeter'] == 'Off')
then
	sWaterUsageTot = (sWaterUsage + 1)
	
	print("Water usage is set to " .. sWaterUsageTot / 1000 .. "m3 ")
	commandArray['UpdateDevice'] = ''..iIDX..'|0|'..sWaterUsageTot..''
else
    -- Keep a live device
    if (timedifference(otherdevices_lastupdate["Waterverbruik"]) > 300)
    then
        print("Water usage is still " .. sWaterUsage / 1000 .. "m3 ")
        commandArray['UpdateDevice'] = ''..iIDX..'|0|'..sWaterUsage..''   
    end
end

return commandArray

OK i tried this script but i can't get to work, i don't understand any of it, the python script works great but id like this one to work either and there must be something im missing.

Can you change the script with some additions of the variables in the beginning like IDX=? GP0=?
What kind of switch do i have to add? and how does the script know what gpo pin i use.

[ratjenl]

Everything is working now ok for me. Domoticz is showing a lot more then the actual usage ( domoticz says 915.333 while the meter says 915.261. I am trying to figure out how to fix this, maybe it is because i placed the npn not good enough. Sometimes the red led keeps burning. Anybody else got this issue aswell ?

[Micha123]

Check hownyour sensor works.


If you sensor short/unshort VCC then you need to pulldown gpio
If your sensor is short/unshort GND then you need to pullup gpio


Then you need to know when your sensor is shorting unshorting pin (vcc of gnd)

If it unshort pin by bounce so you need in your script


if (devicechanged['GPIO Watermeter'] == 'Off')


If it shorts the pin by bounce you need


if (devicechanged['GPIO Watermeter'] == 'on')

If you have that wrong, so you became wrong measure.

[ratjenl]

Check hownyour sensor works.


If you sensor short/unshort VCC then you need to pulldown gpio
If your sensor is short/unshort GND then you need to pullup gpio


Then you need to know when your sensor is shorting unshorting pin (vcc of gnd)

If it unshort pin by bounce so you need in your script


if (devicechanged['GPIO Watermeter'] == 'Off')


If it shorts the pin by bounce you need


if (devicechanged['GPIO Watermeter'] == 'on')

If you have that wrong, so you became wrong measure.

I don't get anything of what you are saying my friend. I got exactly the same sensor as the topicstarter

[Trigun]

hi pvangorp,

I recently received a new NPN sensor.
I tested t with a 9v battery and it works!

when I put in on my meter, it doesn't work. I believe th glass is too thick for the sensor to measure anything.
is there a solution for this problem?
all tests work so I am close to the final step.

Thnx in advance!

[gielie]

hi pvangorp,

I recently received a new NPN sensor.
I tested t with a 9v battery and it works!

when I put in on my meter, it doesn't work. I believe th glass is too thick for the sensor to measure anything.
is there a solution for this problem?
all tests work so I am close to the final step.

Thnx in advance!

I had the same with one of my sensors (one worked out of the box one didnt).
What i did i took some of the plastic tip of the sensor with sandpaper, just a small bit and tested it and it worked, probably the plastic tip is too thick.

[Trigun]

hi pvangorp,

I recently received a new NPN sensor.
I tested t with a 9v battery and it works!

when I put in on my meter, it doesn't work. I believe th glass is too thick for the sensor to measure anything.
is there a solution for this problem?
all tests work so I am close to the final step.

Thnx in advance!

I had the same with one of my sensors (one worked out of the box one didnt).
What i did i took some of the plastic tip of the sensor with sandpaper, just a small bit and tested it and it worked, probably the plastic tip is too thick.

Sounds like an idea! Will test it, thnx for Your reply!


Sent from my iPhone using Tapatalk

[Trigun]

hi pvangorp,

I recently received a new NPN sensor.
I tested t with a 9v battery and it works!

when I put in on my meter, it doesn't work. I believe th glass is too thick for the sensor to measure anything.
is there a solution for this problem?
all tests work so I am close to the final step.

Thnx in advance!

I had the same with one of my sensors (one worked out of the box one didnt).
What i did i took some of the plastic tip of the sensor with sandpaper, just a small bit and tested it and it worked, probably the plastic tip is too thick.

Sounds like an idea! Will test it, thnx for Your reply!


Sent from my iPhone using Tapatalk

It Worked! thanks for the great tip!

[Trigun]

The problem with my previous script is that when no water used, the devices shows offline.
I fixed this with a keep a live part. When no water detected update with keep a live every 5 minutes, just like the other smart meters in Domoticz.

Code: Select all

commandArray = {}

-- Water usage
-- Retrieve value from water meter device:
sWaterUsage = otherdevices_svalues['Waterverbruik']

-- To have a better readable format, divide number by 1000:
sWaterUsagePrint = tonumber(sWaterUsage / 1000);

-- calculation is done with the unmodified water value
sWaterUsage = tonumber(sWaterUsage);

-- For Debuging
-- print("Water usage until now is " .. sWaterUsagePrint .. "m3 ")
-- print('GPIO Watermeter = '..otherdevices['GPIO Watermeter'])


function timedifference(s)
   year = string.sub(s, 1, 4)
   month = string.sub(s, 6, 7)
   day = string.sub(s, 9, 10)
   hour = string.sub(s, 12, 13)
   minutes = string.sub(s, 15, 16)
   seconds = string.sub(s, 18, 19)
   t1 = os.time()
   t2 = os.time{year=year, month=month, day=day, hour=hour, min=minutes, sec=seconds}
   difference = os.difftime (t1, t2)
   return difference
end

if (devicechanged['GPIO Watermeter'] == 'Off')
then
	sWaterUsageTot = (sWaterUsage + 1)
	
	print("Water usage is set to " .. sWaterUsageTot / 1000 .. "m3 ");
	commandArray['UpdateDevice'] = '34|0|'..sWaterUsageTot..''
else
    -- Keep a live device
    if (timedifference(otherdevices_lastupdate["Waterverbruik"]) > 300)
    then
        print("Water usage is still " .. sWaterUsage / 1000 .. "m3 ");
        commandArray['UpdateDevice'] = '34|0|'..sWaterUsage..''    
    end
end

return commandArray

Hi pvangorp,

where did you put this script and how to use it. I am experiencing the same.

Thnx in advance!