# General

**URL:** https://discourse.nodered.org/c/general/7.md?page=408

[Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md)

**Page:** 409

---

## [The transport protocol is not supported](https://discourse.nodered.org/t/the-transport-protocol-is-not-supported/58301)

<div class="topic-metadata">

**Author:** [@tienanh2910](https://discourse.nodered.org/u/tienanh2910)\
**Replies:** 1\
**Last updated:** [9 March 2022 14:21 UTC](https://discourse.nodered.org/t/the-transport-protocol-is-not-supported/58301 "2022-03-09T14:21:54Z")

</div>

Hi everyone! I am facing problem in configuring OPC UA - Client . In my Command Prompt the error message is red as follows: "09:28:30.568Z :client\_tcp\_transport :47 \[NODE-OPCUA-E05\] this transport protocol is not suppor…

---

## [Trying to use Admin Http API to install a module from github](https://discourse.nodered.org/t/trying-to-use-admin-http-api-to-install-a-module-from-github/59595)

<div class="topic-metadata">

**Author:** [@davec1001](https://discourse.nodered.org/u/davec1001)\
**Replies:** 2\
**Last updated:** [9 March 2022 14:20 UTC](https://discourse.nodered.org/t/trying-to-use-admin-http-api-to-install-a-module-from-github/59595 "2022-03-09T14:20:44Z")

</div>

Hi, I am 'posting' this to http://127.0.0.1:1880/nodes msg.payload = { "module" : "https://github.com/davidcreager/node-red-contrib-denonsocket.git" } and receiving this response {"code":404,"message":"Module not …

---

## [Room Occupancy Using Motion and Contact Sensors](https://discourse.nodered.org/t/room-occupancy-using-motion-and-contact-sensors/59556)

<div class="topic-metadata">

**Author:** [@rebel102285](https://discourse.nodered.org/u/rebel102285)\
**Replies:** 9\
**Last updated:** [9 March 2022 14:11 UTC](https://discourse.nodered.org/t/room-occupancy-using-motion-and-contact-sensors/59556 "2022-03-09T14:11:29Z")

</div>

Really struggling with what I feel should be a simple flow but for some reason no matter what I try I cannot seem to get the flow to run the way I want. Attempting to build a presence detection for rooms based on Motion…

---

## [Publishing Foto from ESP32Cam to Dashboard via mqtt](https://discourse.nodered.org/t/publishing-foto-from-esp32cam-to-dashboard-via-mqtt/59594)

<div class="topic-metadata">

**Author:** [@maxmueller50](https://discourse.nodered.org/u/maxmueller50)\
**Replies:** 0\
**Last updated:** [9 March 2022 13:34 UTC](https://discourse.nodered.org/t/publishing-foto-from-esp32cam-to-dashboard-via-mqtt/59594 "2022-03-09T13:34:04Z")

</div>

Hi what is wrong on my flow??? { "id": "1e03ce048d71e10b", "type": "ui\_template", "z": "fcb20266.ce938", "group": "", "name": "show image", "order": 4, "width…

---

## [Different priorites for toggling devices on or off](https://discourse.nodered.org/t/different-priorites-for-toggling-devices-on-or-off/59593)

<div class="topic-metadata">

**Author:** [@jesjimher](https://discourse.nodered.org/u/jesjimher)\
**Replies:** 1\
**Last updated:** [9 March 2022 13:40 UTC](https://discourse.nodered.org/t/different-priorites-for-toggling-devices-on-or-off/59593 "2022-03-09T13:40:39Z")

</div>

Hi, I'm trying to achieve something that I think should be pretty common, but haven't found how to implement it without resorting to custom coding, and I'd rather not reinvent the wheel if possible. I've tried searching …

---

## [Show data on ui-table coming from SQL database](https://discourse.nodered.org/t/show-data-on-ui-table-coming-from-sql-database/59573)

<div class="topic-metadata">

**Author:** [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Replies:** 6\
**Last updated:** [9 March 2022 11:50 UTC](https://discourse.nodered.org/t/show-data-on-ui-table-coming-from-sql-database/59573 "2022-03-09T11:50:41Z")

</div>

Hello, I'm new in node-red and javascript. I have created a flow able to make a connection to a SQL database and select the first row of a specific table. \</\> I correctly see in the payload data of the first row of…

---

## [Create decimal value](https://discourse.nodered.org/t/create-decimal-value/59580)

<div class="topic-metadata">

**Author:** [@Espene](https://discourse.nodered.org/u/Espene)\
**Replies:** 5\
**Last updated:** [9 March 2022 11:48 UTC](https://discourse.nodered.org/t/create-decimal-value/59580 "2022-03-09T11:48:32Z")

</div>

HI I am receiving av value from a temp sensor in the range from 0 to 400. I need to create a desimal value like this, 0 to 0.0 and 400 to 40.0 How can i do this?

---

## [Error: ENOENT: no such file or directory, open ‘/data/package.json’](https://discourse.nodered.org/t/error-enoent-no-such-file-or-directory-open-data-package-json/59582)

<div class="topic-metadata">

**Author:** [@Utkarsh](https://discourse.nodered.org/u/Utkarsh)\
**Replies:** 0\
**Last updated:** [9 March 2022 11:16 UTC](https://discourse.nodered.org/t/error-enoent-no-such-file-or-directory-open-data-package-json/59582 "2022-03-09T11:16:07Z")

</div>

Hello, I am trying to run Node-red using Docker. My Dockerfile is as follows: FROM nodered/node-red:latest-12-minimal COPY settings.js /data/ USER root RUN chown -R node-red:root /data USER node-red RUN npm install I…

---

## [MODBUS TCP over ETHERTNET cable](https://discourse.nodered.org/t/modbus-tcp-over-ethertnet-cable/59566)

<div class="topic-metadata">

**Author:** [@Milanovic](https://discourse.nodered.org/u/Milanovic)\
**Replies:** 2\
**Last updated:** [9 March 2022 09:01 UTC](https://discourse.nodered.org/t/modbus-tcp-over-ethertnet-cable/59566 "2022-03-09T09:01:16Z")

</div>

Hi I want to read some Modbus registers but not over the wifi, over a ethernet cable. How can I do that? I have already a script for Modbus reading over wifi, do I need other settings? \[{"id":"c659bcf3dcb7a08e","type"…

---

## [Lost Connection to Server Reconnecting](https://discourse.nodered.org/t/lost-connection-to-server-reconnecting/59522)

<div class="topic-metadata">

**Author:** [@ALPF5555](https://discourse.nodered.org/u/ALPF5555)\
**Replies:** 12\
**Last updated:** [9 March 2022 08:57 UTC](https://discourse.nodered.org/t/lost-connection-to-server-reconnecting/59522 "2022-03-09T08:57:14Z")

</div>

I am not sure if anyone can help or not I am running Node Red Version 2.2.2 and running a simple big timer to turn lights on and off. Recently I find that the garden lights turn off after 37 minutes and the back on then …

---

## [Values changing](https://discourse.nodered.org/t/values-changing/59131)

<div class="topic-metadata">

**Author:** [@Herbert](https://discourse.nodered.org/u/Herbert)\
**Replies:** 9\
**Last updated:** [8 March 2022 20:10 UTC](https://discourse.nodered.org/t/values-changing/59131 "2022-03-08T20:10:54Z")

</div>

Hello experts, I have a question about MQTT value changes. My photovoltaik (PV) system is displayes in green, the load from house in red. You can see the load starts ab 1500W and go ahead... At Time 14:29 the load …

---

## [Node-red : switch - strange behaviour](https://discourse.nodered.org/t/node-red-switch-strange-behaviour/59529)

<div class="topic-metadata">

**Author:** [@ylechasseur](https://discourse.nodered.org/u/ylechasseur)\
**Replies:** 13\
**Last updated:** [8 March 2022 17:23 UTC](https://discourse.nodered.org/t/node-red-switch-strange-behaviour/59529 "2022-03-08T17:23:37Z")

</div>

OS: Windows 11 Dashboard version: 2.2.0 All my nodes are to the latest version. Browser: Chrome Hi, I am not sure if this strange behaviour happened after a node-red update. I am using the switch node ( not from th…

---

## [Flow doesnt read data from xlsx](https://discourse.nodered.org/t/flow-doesnt-read-data-from-xlsx/59538)

<div class="topic-metadata">

**Author:** [@milner236](https://discourse.nodered.org/u/milner236)\
**Replies:** 9\
**Last updated:** [8 March 2022 16:10 UTC](https://discourse.nodered.org/t/flow-doesnt-read-data-from-xlsx/59538 "2022-03-08T16:10:30Z")

</div>

Hello everyone. I have created a flow that watches for excel files in a folder, then writes the data from the excel file to an MSSQL database. For a strange reason, my flow does not read the data from the excel file. It…

---

## [Raspberry Pi Zero Errors](https://discourse.nodered.org/t/raspberry-pi-zero-errors/59496)

<div class="topic-metadata">

**Author:** [@jsail](https://discourse.nodered.org/u/jsail)\
**Replies:** 7\
**Last updated:** [8 March 2022 15:38 UTC](https://discourse.nodered.org/t/raspberry-pi-zero-errors/59496 "2022-03-08T15:38:36Z")

</div>

Hello, a fresh new Raspien runns well on a Pi3B. When I insert the same microSD to my Raspberry Pi Zero, NodeRed does not Start. I get the followin Errors: Start Node-RED Once Node-RED has started, point a browser at …

---

## [Themes from themes collection not applied on startup on Chrome](https://discourse.nodered.org/t/themes-from-themes-collection-not-applied-on-startup-on-chrome/59383)

<div class="topic-metadata">

**Author:** [@Colin](https://discourse.nodered.org/u/Colin)\
**Replies:** 2\
**Last updated:** [8 March 2022 14:44 UTC](https://discourse.nodered.org/t/themes-from-themes-collection-not-applied-on-startup-on-chrome/59383 "2022-03-08T14:44:36Z")

</div>

I have a rather annoying symptom when using @node-red-contrib-themes/midnight-red (latest - 2.2.0) with Chrome (on Ubuntu). \[Edit: In fact this applies to other themes in the collection too\] If I stop and restart node r…

---

## [Jsonata to chart when payload data has extra \[ \]](https://discourse.nodered.org/t/jsonata-to-chart-when-payload-data-has-extra/59532)

<div class="topic-metadata">

**Author:** [@Auto351](https://discourse.nodered.org/u/Auto351)\
**Replies:** 3\
**Last updated:** [8 March 2022 10:36 UTC](https://discourse.nodered.org/t/jsonata-to-chart-when-payload-data-has-extra/59532 "2022-03-08T10:36:23Z")

</div>

Hello. I'm trying to produce a Node-Red chart from SQLite. I'm stuck on the Jsonata expression and its due to extra layer of "\[ \]" with in the payload. please ref to the image below. If i remove these "\[ \]"…

---

## [Sending a body for http request outside the node](https://discourse.nodered.org/t/sending-a-body-for-http-request-outside-the-node/59526)

<div class="topic-metadata">

**Author:** [@Milanovic](https://discourse.nodered.org/u/Milanovic)\
**Replies:** 10\
**Last updated:** [8 March 2022 11:04 UTC](https://discourse.nodered.org/t/sending-a-body-for-http-request-outside-the-node/59526 "2022-03-08T11:04:51Z")

</div>

Hi, I want to send a http request but I need to send a body with it. This I want to do with a template node. But when I send it, it doesn't work.

---

## [How to replace node-RED frontend](https://discourse.nodered.org/t/how-to-replace-node-red-frontend/59527)

<div class="topic-metadata">

**Author:** [@namph-sgn](https://discourse.nodered.org/u/namph-sgn)\
**Replies:** 4\
**Last updated:** [8 March 2022 10:35 UTC](https://discourse.nodered.org/t/how-to-replace-node-red-frontend/59527 "2022-03-08T10:35:58Z")

</div>

Hi all, I currently developing an application using Jointjs as the diagraming library. I have read the node-RED documents and I'd love to use node-RED runtime as the backend for my application. Is it possible and where…

---

## [How to change state of the switch](https://discourse.nodered.org/t/how-to-change-state-of-the-switch/59514)

<div class="topic-metadata">

**Author:** [@alda](https://discourse.nodered.org/u/alda)\
**Replies:** 36\
**Last updated:** [8 March 2022 10:15 UTC](https://discourse.nodered.org/t/how-to-change-state-of-the-switch/59514 "2022-03-08T10:15:48Z")

</div>

I have simple flow where I can enable/disable button and when is clicked, only 5sec delay is done. My question is, if is possible somehow implement this: When delay is finished that button is again disabled and when bu…

---

## [Node-Red data showing NaN](https://discourse.nodered.org/t/node-red-data-showing-nan/59519)

<div class="topic-metadata">

**Author:** [@weishoose](https://discourse.nodered.org/u/weishoose)\
**Replies:** 8\
**Last updated:** [8 March 2022 09:20 UTC](https://discourse.nodered.org/t/node-red-data-showing-nan/59519 "2022-03-08T09:20:22Z")

</div>

Hello everybody! I'm new to Node-Red so please go easy on me :slightly\_smiling\_face: I am trying to populate sensor data collected from an Arduino on to google sheets using Node-Red. However, the sensor data comes out …

---

## [How to parse JSON object to value](https://discourse.nodered.org/t/how-to-parse-json-object-to-value/59217)

<div class="topic-metadata">

**Author:** [@mrrobot](https://discourse.nodered.org/u/mrrobot)\
**Replies:** 1\
**Last updated:** [2 March 2022 09:09 UTC](https://discourse.nodered.org/t/how-to-parse-json-object-to-value/59217 "2022-03-02T09:09:15Z")

</div>

Hi @Steve-Mcl and everyone, Please help and advise how to parse JSON object to value. Expected value is need data timings value of sunrise, sunset, midnight and date readable Already try to create a flow and have erro…

---

## [Calculating with several if loops](https://discourse.nodered.org/t/calculating-with-several-if-loops/59490)

<div class="topic-metadata">

**Author:** [@Milanovic](https://discourse.nodered.org/u/Milanovic)\
**Replies:** 1\
**Last updated:** [7 March 2022 15:34 UTC](https://discourse.nodered.org/t/calculating-with-several-if-loops/59490 "2022-03-07T15:34:25Z")

</div>

Hi I have a dashboard with 3 options, when 1 is chosen there must be made a calculation. This choice is a string, but how can I say: if the string is equal with the other. Like in this case I choosed 3 x 230 in a norm…

---

## [Advice needed on migrating a NR project to a Cloud based solution](https://discourse.nodered.org/t/advice-needed-on-migrating-a-nr-project-to-a-cloud-based-solution/59515)

<div class="topic-metadata">

**Author:** [@CreativeWarlock](https://discourse.nodered.org/u/CreativeWarlock)\
**Replies:** 0\
**Last updated:** [7 March 2022 22:04 UTC](https://discourse.nodered.org/t/advice-needed-on-migrating-a-nr-project-to-a-cloud-based-solution/59515 "2022-03-07T22:04:07Z")

</div>

Hi guys. I would like to ask for your advice on a project that I've been working for many years now. It's using Node-Red, MongoDB, mySQL. All three are running in separate docker instances on my Synology NAS. In the ne…

---

## [Round all values of an object (2)](https://discourse.nodered.org/t/round-all-values-of-an-object-2/59410)

<div class="topic-metadata">

**Author:** [@Becker](https://discourse.nodered.org/u/Becker)\
**Replies:** 10\
**Last updated:** [7 March 2022 21:30 UTC](https://discourse.nodered.org/t/round-all-values-of-an-object-2/59410 "2022-03-07T21:30:30Z")

</div>

Hi, is it possible to round all values of an object with "parseFloat" like this: Object.entries(msg.payload).forEach((v) =\>{ msg.payload\[v\[0\]\] = Math.round(v\[1\]); }) return msg; but with any decimal places like pa…

---

## [Enable/disable button via switch](https://discourse.nodered.org/t/enable-disable-button-via-switch/59497)

<div class="topic-metadata">

**Author:** [@alda](https://discourse.nodered.org/u/alda)\
**Replies:** 2\
**Last updated:** [7 March 2022 17:42 UTC](https://discourse.nodered.org/t/enable-disable-button-via-switch/59497 "2022-03-07T17:42:04Z")

</div>

I want enable/disable a button with switch, but not working for me. What is wrong ? : \[{"id":"fb381298223f4873","type":"ui\_button","z":"59fb2f9263e14661","name":"","group":"8c11279992e11f1f","order":7,"width":0,"height"…

---

## [Snapshot tool to update UI table, last missing piece: implement timer/stopwatch problems](https://discourse.nodered.org/t/snapshot-tool-to-update-ui-table-last-missing-piece-implement-timer-stopwatch-problems/59370)

<div class="topic-metadata">

**Author:** [@WBr](https://discourse.nodered.org/u/WBr)\
**Replies:** 21\
**Last updated:** [7 March 2022 20:13 UTC](https://discourse.nodered.org/t/snapshot-tool-to-update-ui-table-last-missing-piece-implement-timer-stopwatch-problems/59370 "2022-03-07T20:13:31Z")

</div>

Dear all. Before I begin my question, first a big thanks to @Christian-Me who helped me intensively with making this flow. Introduction to the question. I run experiments (I am a chemist and teacher). In these experim…

---

## [Node-Red MySQL 1.0.1 crashing MySQL](https://discourse.nodered.org/t/node-red-mysql-1-0-1-crashing-mysql/59409)

<div class="topic-metadata">

**Author:** [@HarryPottar](https://discourse.nodered.org/u/HarryPottar)\
**Replies:** 4\
**Last updated:** [7 March 2022 19:42 UTC](https://discourse.nodered.org/t/node-red-mysql-1-0-1-crashing-mysql/59409 "2022-03-07T19:42:53Z")

</div>

HI, Running into odd MySQL issue where high use of ram then crashes. I have node red and mysql running in a kubernetes cluster, each in their own container. I have given MySQL 16gb of ram. Nothing else is running, I'm …

---

## [Sample flow for including JS file](https://discourse.nodered.org/t/sample-flow-for-including-js-file/59454)

<div class="topic-metadata">

**Author:** [@KevinT](https://discourse.nodered.org/u/KevinT)\
**Replies:** 6\
**Last updated:** [7 March 2022 19:12 UTC](https://discourse.nodered.org/t/sample-flow-for-including-js-file/59454 "2022-03-07T19:12:25Z")

</div>

I am trying to build a flow to generate and display an html-page with an included js files. As this is on the edge of my capabilities and it took me a little effort to set up my docker system I would like to test it bef…

---

## [OPC UA to Modbus TCP/IP Slave](https://discourse.nodered.org/t/opc-ua-to-modbus-tcp-ip-slave/59507)

<div class="topic-metadata">

**Author:** [@Tariqb15](https://discourse.nodered.org/u/Tariqb15)\
**Replies:** 0\
**Last updated:** [7 March 2022 18:48 UTC](https://discourse.nodered.org/t/opc-ua-to-modbus-tcp-ip-slave/59507 "2022-03-07T18:48:36Z")

</div>

Hello, Is there a way to Get the data from OPC Client then Convert it into a modbus TCP/IP Slave ?? Do you guys have an example for this !! Thank you,

---

## [Semaphore status](https://discourse.nodered.org/t/semaphore-status/59492)

<div class="topic-metadata">

**Author:** [@alda](https://discourse.nodered.org/u/alda)\
**Replies:** 9\
**Last updated:** [7 March 2022 18:09 UTC](https://discourse.nodered.org/t/semaphore-status/59492 "2022-03-07T18:09:45Z")

</div>

I'm using a semaphore take and semaphore leave to send a multiple commands to main unit. Problem is, that at this moment I can't see if all commands are already sent. Is it any possibilty how to implement any status LED …

[Previous page](https://discourse.nodered.org/c/general/7.md?page=407)

[Next page](https://discourse.nodered.org/c/general/7.md?page=409)