How do I set up a NodeRed connection with Domoticz for Sofar 15KTL-X data?

Question

Hello I am asking for help from colleagues in setting up a NodeRed connection to Domoticz. Currently, thanks to my colleague @michalzd, I have in NodeRed data from a Sofar 15KTL-X inverter which I would like to transfer to domoticz and use there. In this topic: all the details on how to get the...

michal.zd · Accepted Answer

See here for similar topics.
There is an example of a json object sent to domoticz
https://forum.domoticz.com/viewtopic.php?t=30637&start=20

To start with, I suggest you try to send some data typed in rigidly.
This node with the f icon is its own function, in which you enter


msg.payload = {"command":"udevice","idx":1001,"nvalue":10,"svalue":""};
return msg;

.
Check that you have access to the data in domoticz.
I have no idea what the command is,
idx is probably the device index
nvaluea svalue I suspect numeric, string value.

Added after 52 [minutes]: .

Does anyone know if and how to send multiple values to domoticz in one mqtt message?
After analysing the example above, I somehow don't see this as a possibility, but maybe it is possible.
It would be the simplest,

michal.zd · Accepted Answer

For testing instead of this ispidel use Timestamp.
Then by pressing in this area marked with an arrow you generate the pulse and flow action manually.

.

Settings for this Timestamp:

.

Settings Domoticz In you should have guessed.

Any test flow is good to do on new blank node-red cards. With this button you add:

.

Have you already taken a node-red course? It is worth getting to know this environment better, many things will become clearer.
Here an accessible (but a bit short and not much) description of the basic nodes : https://www.pomysłowydom.pl/przykladowe-reguly-node-red/
A nice course is given by Artur on his channel, here's a link to the first episode : https://www.youtube.com/watch?v=9fTMpgr3EU0
and of course https://nodered.org/docs/

Added after 1 [hour] 1 [minute]: .

Well, and don't forget to connect the nodes to each other, now the net domoticz in is not connected to the predecessor.

michal.zd · Accepted Answer

. I see that it reads modbus data right away in node-red. I had a different design premise: the whole control written as a linux program. I am slowly completing the pieces of the puzzle, as in addition to the hot water heating control, there is an element responsible for reacting to voltage increases, controlling the heating and the boiler room. Also as a program in C/Cpp. Advantage, simplicity of the programme and simple addition of extensions. JavaScript is moderately suitable for binary data. Very good for processing json objects. Mosquitto makes it easy for me to work on successive layers of control, linking everything together. Node-red only for displaying data in the dashboard. Why this? Ease of transfer in case of rpi failure. Initially everything worked on a tplink router under OpenWrt, even without node-red 😉. Only something happened to it years later, and since rpi 1 and pi zero in the meantime had become cheap, I decided to recompile this software to just rpi, adding node-red as a control panel.

Daro1003 · Answer

@michal.zd I don't really understand what I have to set in this node: . I understand that in the one with F: . Somewhere else you probably need to give the IP and port of Domoticz.

michal.zd · Answer

. In the one you have signed as domoticz in, that's where it defines itself. In the former, on the other hand, I don't know it. On that forum, look for it.

Daro1003 · Answer

Exactly @michal.zd there is no such node as Timestamp and watching some video on NodeRed they also used nodes which I don't have on mine I don't know I need to install them or something.

michal.zd · Answer

fact, for inconspicuousness in the list it is called so:

.

Added after 57 [seconds]:

Daro1003 wrote:
watching some movie about NodeRed there were also used nodes which are not there in my case I do not know I need to install them or something.

.
Some nodes do need to be installed.

Added after 2 [minutes]:

regarding:

.
I suspect that someone simply called it that, as the name of the noda can be changed. You need to read the whole thing in this forum, as it may turn out to be the usual mqtt you used earlier in my example. After all, it looks the same. Basically the colour of the noda and its icon is unchangeable, you can tell by that.

Added after 1 [minute]: .

ps: here you have two return. one unnecessary

.

Added after 12 [minutes]:

Back to adding nodes...
This is done here - manage palette:

.
It is worth installing this one:

.

Daro1003 · Answer

This is where it flies ok for me: . However, to Domoticz the error: .

michal.zd · Answer

Maybe you haven't defined the noda?
Look in the forum you took it from, I think it will be there.
Anyway, it's not a problem to guess. Open the parameters of the noda.

Added after 2 [minutes]: .

Here you have the def domoticz shown
https://wiki.domoticz.com/MQTT

In the image is the topic for mqtt: domoticz/in for messages sent to domoticz.
Set this in this node

Added after 1 [minute]: .

Ps. I guess that index in the idx field is important and must be compatible with domoticz.
There is some more important information on this page
if the publish topic of the MQTT hardware is set to Index then the publish topic will be domoticz/out/$idx were $idx is the idx number of the device.
if the publish topic of the MQTT hardware is set to Index with retain then the publish topic will be domoticz/out/$idx were $idx is the idx number of the device and retained in MQTT broker.
if the publish topic of the MQTT hardware is set to Name then the publish topic will be domoticz/out/$name were $name is the name of the device.
Only for domoticz/in they didn't write this, maybe then there will be a topic without an index.

Added after 11 [minutes]: .

Daro1003 wrote:
Somewhere you probably still need to give Domoticz IP and port.

.
You don't need that, it's domoticz that needs to have a connection to mosquitto.
In the noda you give the address to mosquitto. He is the intermediary.

Daro1003 · Answer

Rozu . I understand that this is about Domoticz IN - I have something not configured in this node. IDX in Domoticz is a data block with e.g. temperature. Added after 17 [minutes]: .I think I have some kind of overflow because: You can see on the block time 2 minutes inactive I click on nodeRed and it will change for a few seconds that is as if this block got some info.

michal.zd · Answer

. And somewhere you can see what it got? It should be the value from the msg field nvalue.

Daro1003 · Answer

Well, it is only after this time that I see that something has affected it.
And now yes:

1. I don't know what type to set the block in domoticz to receive this test:

.

2. what exactly is to be sent to Domoticz from NodeRed - some text from this:

.

P.S. What I'm trying to do is as if I've set about doing an electrical installation and I can't see what a cable is.

Added after 11 [minutes]:

So this value of 10 should appear in domoticz:

.

michal.zd · Answer

. Yes. Try some block in domoticz that shows something. Could be some sort of power meter. It will be immediately ready for data from the inverter.

Daro1003 · Answer

It does not transmit this value only this time changes i.e. you can see how it would violate.

I tried different temperature blocks, text, percentage, counter.

If I give a block from the energy meter sent by Tasmota, here you can see the topic that is coming from Tasmota:

.

Active power:

michal.zd · Answer

Ask about this json passed to domoticz on that domoticz forum. Maybe someone can upload an example of such a msg

Daro1003 · Answer

There is also an interesting answer: I don't quite understand how to set this up. But I'll keep trying.

michal.zd · Answer

He has given you the whole flow, copy everything from the code to a file and import it into node-red into a new empty flow.
Changes need to be made to the node in and out and it should work
Somewhere in the menu is the import

Daro1003 · Answer

Do I insert IDX from Domoticz in these underlined places ?

It says: "Edit the "Function" node and replace in line 3, your Domoticz idx number for P."

So in line 3 and this is not line 3 for me it is line 5.

.

michal.zd · Answer

. No These are the data to import into node-red, they describe the whole flow. Do as I wrote earlier, copy the whole thing to a file, then in node-red use the import option. Then there will be a new flow with nodes as in the colleague who forwarded it to you. Only after that complete the node definitions to mqtt, first and last.

Daro1003 · Answer

A So I click on options and give import as in image 1.

.

In the window as in image 2 I paste the given code and give import.

.

Two nodes appear to me as in image 3 and I guess the whole flow should appear like this:

.

I click on nod F and I have as in image 3 and there I change the IDXs to my own ?

And what next ? I create a nod as in image 4 which was previously for testing ??

xury · Answer

Start with the basics: Ps. this data from the inverter are you receiving via modbus or via LSW3? Have you seen this:?

michal.zd · Answer

. What you have imported is the finished flow, you already have in it from the left str reading the information from mosquitto, set the appropriate parameters in it as from the old one. The last one on the right passes the information back to mosquitto and it passes it to domoticz. You must configure it accordingly. Added after 2 [minutes]: . Via LWS3 modbusTCP. But through my program, writing this information to mosquitto. Node-red is supposed to receive it from mosquitto and pass it to domoticz.

xury · Answer

A colleague @starob made one a long time ago: After minor modifications, I have been using it for a long time and save it to Domoticz and to Influxdb

michal.zd · Answer

. Hmm, unless a colleague has only specified these two. If so, include your node that receives data from mosquitto.

Daro1003 · Answer

And there it went.
A colleague from the domoticz forum helped here the whole topic: https://forum.domoticz.com/viewtopic.php?t=43153

Maybe it will be useful for someone.

If anything happens to that topic I will paste the flow to be imported in NodeRed:

[
    {
        "id": "9faeea04b2b50403",
        "type": "function",
        "z": "c03666d911c02a8f",
        "name": "Prepare for Domoticz",
        "func": "// Declaration of variables\n\nlet idx1 = 123;\nlet idx2 = 456;\nlet idx3 = 789;\n\nlet msg1 = {};\nlet msg2 = {};\nlet msg3 = {};\n\nmsg1.payload = { \"command\": \"udevice\", \"idx\": idx1, \"svalue\": msg.payload.P.toString() + \";0\"};\nmsg2.payload = { \"command\": \"udevice\", \"idx\": idx2, \"svalue\": msg.payload.GP.toString() + \";0\" };\nmsg3.payload = { \"command\": \"udevice\", \"idx\": idx3, \"svalue\": msg.payload.CP.toString() + \";0\" };\n\nreturn[[msg1,msg2,msg3]];",
        "outputs": 1,
        "timeout": 0,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 460,
        "y": 180,
        "wires": [
            [
                "85eb0898c7979634",
                "5b94fc5b22b41f4e"
            ]
        ]
    },
    {
        "id": "5b94fc5b22b41f4e",
        "type": "mqtt out",
        "z": "c03666d911c02a8f",
        "name": "MQTT Domoticz",
        "topic": "",
        "qos": "",
        "retain": "",
        "respTopic": "",
        "contentType": "",
        "userProps": "",
        "correl": "",
        "expiry": "",
        "broker": "175c3dc01f359e9d",
        "x": 710,
        "y": 180,
        "wires": []
    },
    {
        "id": "175c3dc01f359e9d",
        "type": "mqtt-broker",
        "name": "Raspberry Pi 1B",
        "broker": "192.168.10.51",
        "port": 1883,
        "clientid": "",
        "autoConnect": true,
        "usetls": false,
        "protocolVersion": 4,
        "keepalive": 60,
        "cleansession": true,
        "autoUnsubscribe": true,
        "birthTopic": "",
        "birthQos": "0",
        "birthRetain": "false",
        "birthPayload": "",
        "birthMsg": {},
        "closeTopic": "",
        "closeQos": "0",
        "closeRetain": "false",
        "closePayload": "",
        "closeMsg": {},
        "willTopic": "",
        "willQos": "0",
        "willRetain": "false",
        "willPayload": "",
        "willMsg": {},
        "userProps": "",
        "sessionExpiry": ""
    }
]

.

1 You need to edit the IP address of the broker:

2.

2. you need to edit the IDXs:

3.

3. attach data from Sofar and it should work:

3.

michal.zd · Answer

This kind of information: currently the broker sends a properly formatted json for domoticz to mosquitto, so node-red is a redundant jkao intermediary.
But it is, of course, possible for node-red to completely take control of the whole thing, without additional home assistant software.

Daro1003 · Answer

I believe that this topic has been exhausted and is to be closed.
This is because the connection between NodeRed and Domoticz as described above has been achieved.

Those interested in integrating Sofar with Domoticz should definitely follow the whole topic given in the first post and especially here there is a discussion about direct communication of Sofar with Domoticz.

[Solved] How do I set up a NodeRed connection with Domoticz for Sofar 15KTL-X data?

Post #1

Post #2

Post #3

Post #4

Post #5

Post #6

Post #7

Post #8

Post #9

Post #10

Post #11

Post #12

Post #13

Post #14

Post #15

Post #16

Post #17

Post #18

Post #19

Post #20

Post #21

Post #22

Post #23

Post #24

Post #25

Post #26

Post #27

Post #28

Topic summary