This is essentially a post for Erwin Van der Zwart.
Helllo Erwin,
First of all (and I repeat myself but it cannot be said enough) : thank you for the great development work on the HomeLynk/LogicMachine product. I just love what you get out of this little wonder (reminds me of the C64-days : anything seemed possible)
Anyway, an hour ago, a Schneider representative told me about this PowerTag product combined with the Smartlink interface. It sure looks promising and easy to implement as an after-market solution for smart metering.
However, he could not answer my technical questions about logging and export capabilities but as I read through the specs, I noticed it uses the Modbus TC/IP protocol.
So, I was wondering, can this module be linked to a HomeLynk for 1) logging 2) Visualisation in the Trends logs 3) Action triggering to knx on treshold valiues to be defined in the HomeLynk?
26.10.2017, 13:31 (This post was last modified: 26.10.2017, 13:33 by Erwin van der Zwart.)
Hi,
Yes the powertag can be integrated to HL/SL/LM just like any other modbus metering device, difference is that the smartlink SID or SIB will function like a IP to RTU gateway,
only here is RTU in fact a Zigbee communication.
So basicly you read a modbus IP gateway, set a slave (150 to 220) and under this slave are these points:
4 Power Tags on the SI D and 4 iEM3555 : data are concentrated in the SpaceLYnk but I have gap on the trends for the current phase. See an example on the attached file.
I have a problem for a lot of current phase from the Power Tags and from the iEM3555. The gap is not on the same hour.
I don't understand because for the Total Energy, it's ok all the data are seen on the trends.
2/ there is no Reactiv energy/and active reister in your JSON, are these information available ?
3/ is there a way to replace the json file for existing modbus element ? I try to change the file in the archive after a save but it keep the old value. Is it it stored in DB ? Can I change the code in the DB. Cause I have 100 counter to change !
-----------
FRANCE SMARTHOME & SMARTBUILDING INTEGRATION
SE ECO EXPERT
I try to change in DB table 'modbus_device' the profile from powertag to powertagkw (I add the profile before), without sucess ! I tried also to delete the record in the table 'modbus_mapping' thinking it will generated again with the new profil !
But doesn't work !
-----------
FRANCE SMARTHOME & SMARTBUILDING INTEGRATION
SE ECO EXPERT
Yes the powertag can be integrated to HL/SL/LM just like any other modbus metering device, difference is that the smartlink SID or SIB will function like a IP to RTU gateway,
only here is RTU in fact a Zigbee communication.
So basicly you read a modbus IP gateway, set a slave (150 to 220) and under this slave are these points:
Once modbus device is added it will use current profile data. Changing profile after that will not affect already created devices. There were some examples by Erwin on how to create bulk modbus devices from a script.
27.06.2018, 09:33 (This post was last modified: 27.06.2018, 10:13 by domotiqa.)
I should not be good enought !
I try this on script to change the units and multiplier
Code:
query = 'SELECT * FROM modbus_mapping WHERE "address" = 3203'
for _, mapping in ipairs(db:getall(query)) do
db:update('value_multiplier', 0.001)
db:update('units', 'kWh')
end
query = 'SELECT * FROM modbus_mapping WHERE "address" = 3059'
for _, mapping in ipairs(db:getall(query)) do
db:update('value_multiplier', 0.001)
db:update('units', 'kW')
end
doesn't work for me !
(27.06.2018, 09:33)domotiqa Wrote: I should not be good enought !
I try this on script to change the units and multiplier
Code:
query = 'SELECT * FROM modbus_mapping WHERE "address" = 3203'
for _, mapping in ipairs(db:getall(query)) do
db:update('value_multiplier', 0.001)
db:update('units', 'kWh')
end
query = 'SELECT * FROM modbus_mapping WHERE "address" = 3059'
for _, mapping in ipairs(db:getall(query)) do
db:update('value_multiplier', 0.001)
db:update('units', 'kW')
end
doesn't work for me !
I also try to edit the DB in backup file current.db and backup.db
changing the record (editing the units change from w to kw and value_multiplier from null to 0.001
try to reload the backup ! But device are all erase ! I edit with dbbrowser for sqlite
-----------
FRANCE SMARTHOME & SMARTBUILDING INTEGRATION
SE ECO EXPERT
04.07.2019, 15:32 (This post was last modified: 04.07.2019, 15:33 by Erwin van der Zwart.)
Hi,
There is indeed a new gateway but the system registers are not changed in this new gateway. This does not change any register in the powertag itself.
We have entered the most used registers in the profile and we could add a few more as they already excisted in the powertag device.
Here is the register list of both (system gateway and powertag) See page 66 for the system registers to be read on slave ID 255 and page 68 for the powertag registers to be read at slave ID ### depending on the selected powertag.
14.02.2021, 16:30 (This post was last modified: 15.02.2021, 01:01 by stemic01.)
Hi all. Very interesting and helpfull thread.
I have now successfully addeded my powertags and PowerTag link (A9XMWD20) and have started to get the readings which seems to work fine.
2 QUESTIONS:
1) ACCUMULATED CONSUMPTION
----------------------------------------------------
What is the best way to accumulate/count the consumption per day / month? --> SOLVED: counter; - Just had to send a "0" value to the "Active Energy Write Value" and NOT to the "Active Energy Resettable". Solved.
a) By trending, b) by scripting or by c) using the built in counter in the PowerTag?
It seems like the C) built in resetable register in the powerTag is the more precise way to go as trends will be more incorrect? I was looking at the register "3255-Active Energy Resettable" which seems like a interesting way to go if we could reset it daily by midnight.
[s]--> SOLVED: How do we reset this value easily with a script? I tried to make the JSON register "writable:1", as with other modbus items, but I could not reset the value to 0. [/s]
--> What is the best way to accumulate monthly values for trends if I reset the counter at midnight daily? I guess there are not 2 counters built in to each powerTag?
2) Powertag 230v rated voltage issue?
----------------------------------------------------
A Schneider 3-phase PowerTag "A9MEM1543" which should be rated voltage 230v can not be changed to anything less than 380v. Anything less, like the correct 230v, Returns "the form contains error" message. Using "browser web interface" for seting up the powertag. The other "A9MEM1521" are OK and accept 230v. What am I doing wrong here?
