Open source Home Automation System
https://forum.domoticz.com/
but if you don't mind me asking do you have any idea on how to store this data on a SD card ??
Exactly what I am searching. Got the CSV on my pi but need a script to import it in Domoticz. Can you please share the script?McMelloW wrote: ↑Wednesday 17 January 2018 14:58 See my previous post. With the formatter from Daniel Wippermann I can get the data from my Resol KM2 every 5 minutes into Domoticz. This can be faster if you want it.
Thanks also to Dannybloe for his support with the dzVents script
A floorplan of my Solarboiler / Heating system. Combined with values form Atag One and Weather Underground.
. Great work!, but I can't leave a network cable from the technical zone where I have the solar controller to link the router because is so far, I know that I can connect a Vonets to transmit via WiFi but I thought that maybe the ATmega could be connected to an ESP8266 to transmit via WiFi, you know if it would be possible?Here is the script I useJoost996me wrote: ↑Saturday 08 June 2019 8:42Exactly what I am searching. Got the CSV on my pi but need a script to import it in Domoticz. Can you please share the script?McMelloW wrote: ↑Wednesday 17 January 2018 14:58 See my previous post. With the formatter from Daniel Wippermann I can get the data from my Resol KM2 every 5 minutes into Domoticz. This can be faster if you want it.
Thanks also to Dannybloe for his support with the dzVents script
A floorplan of my Solarboiler / Heating system. Combined with values form Atag One and Weather Underground.
Code: Select all
--[[ Test script for dzVents KM2 Data read from KM2 communication-unit without the use og website Vbus.current_packets
Read from KM2 local-ip into current_packets.vbus binary file
current_packets.vbus (binary) is formatted to json with KM2-formatter from Daniel Wipperman
See https://github.com/danielwippermann/resol-vbus.rs for all information
KM2Output.json is read and tranfered to the devices.
]]--
local KM2output = '/tmp/KM2output.json' -- Formatted json output file
local fetchIntervalMins = 1 -- (Integer) (Minutes, Range 5-60) How often KM2 file is fetched
local idxTempCol = 61
local idxTempBoil = 62
local idxPumpRel = 63
local idxPWM_BP = 64
local idxTage = 65
local idxRelTime = 66
local ScriptVersion = '0.1.5'
return {
active = true,
logging = {
-- level = domoticz.LOG_DEBUG, -- Uncomment to override the dzVents global logging setting
marker = 'KM2 '.. ScriptVersion
},
on = {
timer = {'every minute'} -- Don't change! Verander niet! Ne changez pas!
},
execute = function(domoticz, device)
local getData = false
if (os.date('*t').min % fetchIntervalMins) == 0 then
getData = true
elseif ((os.date('*t').min -1) % fetchIntervalMins) ~= 0 then
return
end
if getData then
domoticz.utils.osExecute('wget -nv -N -P /tmp/ 192.168.xxx.yyy/current/current_packets.vbus')
domoticz.utils.osExecute('/home/pi/resol-vbus.rs/examples/formatter/KM2-formatter -- simple-json /tmp/current_packets.vbus')
--loads a json file with the provided name and returns it as a table (if it exists)
local function readLuaFromJsonFile(fileName)
KM2data ={}
local file = io.open(fileName, 'r')
if file then
-- package.path = package.path ..";./scripts/lua/?.lua;" -- This can be removed when using dzVents 2.3.1 or later
local jsonParser = require('JSON')
local _json = file:read('*a')
local json = jsonParser:decode(_json)
io.close(file)
return json
end
return nil
end -- function readLuaFromJsonFile(fileName)
local KM2data = readLuaFromJsonFile(KM2output)
if not KM2data then
domoticz.log('Could not read KM2-data from file: '.. KM2output, domoticz.LOG_ERROR)
return
end
domoticz.log('KM2output json data file has been read', domoticz.LOG_DEBUG)
-- Read KM2data in pairs and update devices
for i, item in pairs(KM2data.fields) do
if (item.id == '00_0010_2360_10_0100_004_2_0') then -- uniek id voor Temperatur Sensor 1
domoticz.devices(idxTempCol).updateTemperature(tonumber(item.rawValue) / 10)
domoticz.log('Temperatuur Collector = ' ..item.textValue.. ' °C', domoticz.LOG_DEBUG)
end
if (item.id == '00_0010_2360_10_0100_006_2_0') then -- uniek id voor Temperatur Sensor 2
domoticz.devices(idxTempBoil).updateTemperature(tonumber(item.rawValue) / 10)
domoticz.log('Temperatuur Boiler = ' ..item.textValue.. ' °C', domoticz.LOG_DEBUG)
end
if (item.id == '00_0010_2360_10_0100_016_2_0') then -- uniek id voor Tage
domoticz.devices(idxTage).updateCustomSensor(tonumber(item.rawValue))
domoticz.log('Aantal dagen = ' ..item.textValue.. ' dagen', domoticz.LOG_DEBUG)
end
if (item.id == '00_0010_2360_10_0100_034_1_0') then -- uniek id voor Pomp Relais 1
domoticz.devices(idxPumpRel).updatePercentage(tonumber(item.rawValue))
domoticz.log('Pomp Relais = ' ..item.textValue.. ' %', domoticz.LOG_DEBUG)
end
if (item.id == '00_0010_2360_10_0100_038_1_0') then -- uniek id voor PWM A
domoticz.devices(idxPWM_BP).updatePercentage(tonumber(item.rawValue))
domoticz.log('PWM Boier Pomp = ' ..item.textValue.. ' %', domoticz.LOG_DEBUG)
end
if (item.id == '00_0010_2360_10_0100_048_4_0') then -- uniek id Betriebssekunden Relais 1
RelaisTime = (tonumber(item.rawValue))
local days = math.floor(RelaisTime / 86400)
local remainder = RelaisTime % 86400
local hours = math.floor(remainder / 3600)
local remainder = remainder % 3600
local minutes = math.floor(remainder / 60)
local seconds = remainder % 60
Bedrijfstijd = tostring(days.. 'd:' ..hours.. 'u:' ..minutes.. 'm:'..seconds.. 's.')
domoticz.devices(idxRelTime).updateText(tostring(Bedrijfstijd))
domoticz.log('Bedrijfstijd Pomp Relais 1 = ' ..Bedrijfstijd, domoticz.LOG_DEBUG)
domoticz.log('Bedrijfstijd Pomp Relais 1 = ' ..item.textValue.. ' sec', domoticz.LOG_DEBUG)
end
end -- Read KM2data in pairs and update devices
end -- getData
end
}
Thank you McMelloW, you use a vbus to lan adapter in your example?. I would like to send the data via wifi from arduino to domoticz without ethernet cable.McMelloW wrote: ↑Tuesday 05 November 2019 20:19Here is the script I useJoost996me wrote: ↑Saturday 08 June 2019 8:42Exactly what I am searching. Got the CSV on my pi but need a script to import it in Domoticz. Can you please share the script?McMelloW wrote: ↑Wednesday 17 January 2018 14:58 See my previous post. With the formatter from Daniel Wippermann I can get the data from my Resol KM2 every 5 minutes into Domoticz. This can be faster if you want it.
Thanks also to Dannybloe for his support with the dzVents script
A floorplan of my Solarboiler / Heating system. Combined with values form Atag One and Weather Underground.Code: Select all
--[[ Test script for dzVents KM2 Data read from KM2 communication-unit without the use og website Vbus.current_packets Read from KM2 local-ip into current_packets.vbus binary file current_packets.vbus (binary) is formatted to json with KM2-formatter from Daniel Wipperman See https://github.com/danielwippermann/resol-vbus.rs for all information KM2Output.json is read and tranfered to the devices. ]]-- local KM2output = '/tmp/KM2output.json' -- Formatted json output file local fetchIntervalMins = 1 -- (Integer) (Minutes, Range 5-60) How often KM2 file is fetched local idxTempCol = 61 local idxTempBoil = 62 local idxPumpRel = 63 local idxPWM_BP = 64 local idxTage = 65 local idxRelTime = 66 local ScriptVersion = '0.1.5' return { active = true, logging = { -- level = domoticz.LOG_DEBUG, -- Uncomment to override the dzVents global logging setting marker = 'KM2 '.. ScriptVersion }, on = { timer = {'every minute'} -- Don't change! Verander niet! Ne changez pas! }, execute = function(domoticz, device) local getData = false if (os.date('*t').min % fetchIntervalMins) == 0 then getData = true elseif ((os.date('*t').min -1) % fetchIntervalMins) ~= 0 then return end if getData then domoticz.utils.osExecute('wget -nv -N -P /tmp/ 192.168.xxx.yyy/current/current_packets.vbus') domoticz.utils.osExecute('/home/pi/resol-vbus.rs/examples/formatter/KM2-formatter -- simple-json /tmp/current_packets.vbus') --loads a json file with the provided name and returns it as a table (if it exists) local function readLuaFromJsonFile(fileName) KM2data ={} local file = io.open(fileName, 'r') if file then -- package.path = package.path ..";./scripts/lua/?.lua;" -- This can be removed when using dzVents 2.3.1 or later local jsonParser = require('JSON') local _json = file:read('*a') local json = jsonParser:decode(_json) io.close(file) return json end return nil end -- function readLuaFromJsonFile(fileName) local KM2data = readLuaFromJsonFile(KM2output) if not KM2data then domoticz.log('Could not read KM2-data from file: '.. KM2output, domoticz.LOG_ERROR) return end domoticz.log('KM2output json data file has been read', domoticz.LOG_DEBUG) -- Read KM2data in pairs and update devices for i, item in pairs(KM2data.fields) do if (item.id == '00_0010_2360_10_0100_004_2_0') then -- uniek id voor Temperatur Sensor 1 domoticz.devices(idxTempCol).updateTemperature(tonumber(item.rawValue) / 10) domoticz.log('Temperatuur Collector = ' ..item.textValue.. ' °C', domoticz.LOG_DEBUG) end if (item.id == '00_0010_2360_10_0100_006_2_0') then -- uniek id voor Temperatur Sensor 2 domoticz.devices(idxTempBoil).updateTemperature(tonumber(item.rawValue) / 10) domoticz.log('Temperatuur Boiler = ' ..item.textValue.. ' °C', domoticz.LOG_DEBUG) end if (item.id == '00_0010_2360_10_0100_016_2_0') then -- uniek id voor Tage domoticz.devices(idxTage).updateCustomSensor(tonumber(item.rawValue)) domoticz.log('Aantal dagen = ' ..item.textValue.. ' dagen', domoticz.LOG_DEBUG) end if (item.id == '00_0010_2360_10_0100_034_1_0') then -- uniek id voor Pomp Relais 1 domoticz.devices(idxPumpRel).updatePercentage(tonumber(item.rawValue)) domoticz.log('Pomp Relais = ' ..item.textValue.. ' %', domoticz.LOG_DEBUG) end if (item.id == '00_0010_2360_10_0100_038_1_0') then -- uniek id voor PWM A domoticz.devices(idxPWM_BP).updatePercentage(tonumber(item.rawValue)) domoticz.log('PWM Boier Pomp = ' ..item.textValue.. ' %', domoticz.LOG_DEBUG) end if (item.id == '00_0010_2360_10_0100_048_4_0') then -- uniek id Betriebssekunden Relais 1 RelaisTime = (tonumber(item.rawValue)) local days = math.floor(RelaisTime / 86400) local remainder = RelaisTime % 86400 local hours = math.floor(remainder / 3600) local remainder = remainder % 3600 local minutes = math.floor(remainder / 60) local seconds = remainder % 60 Bedrijfstijd = tostring(days.. 'd:' ..hours.. 'u:' ..minutes.. 'm:'..seconds.. 's.') domoticz.devices(idxRelTime).updateText(tostring(Bedrijfstijd)) domoticz.log('Bedrijfstijd Pomp Relais 1 = ' ..Bedrijfstijd, domoticz.LOG_DEBUG) domoticz.log('Bedrijfstijd Pomp Relais 1 = ' ..item.textValue.. ' sec', domoticz.LOG_DEBUG) end end -- Read KM2data in pairs and update devices end -- getData end }
Sorry I have no experience with wifi and a KM2.
In your description you mentioned you removed the voltage divider. Which resistors did you remove ? I've tried to make the circuit on a breadboard and I've messed something up and it isn't getting any data.bbqkees wrote: ↑Monday 24 July 2017 11:54I still have not made them yet, no time.delphi wrote:
Do you have any "extra" board, that want to sell?
If you would order the components from Aliexpress/Ebay etc and buy a small breadboard it is not that hard to put it together.
The schematic is quite simple:
