# Latest

**URL:** https://discourse.nodered.org/latest.md?page=566

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

**Page:** 567

---

## [Dynamically change the ip Server of the connection config MSSQL](https://discourse.nodered.org/t/dynamically-change-the-ip-server-of-the-connection-config-mssql/62879)

<div class="topic-metadata">

**Author:** [@Dumy](https://discourse.nodered.org/u/Dumy)\
**Replies:** 8\
**Last updated:** [20 May 2022 11:18 UTC](https://discourse.nodered.org/t/dynamically-change-the-ip-server-of-the-connection-config-mssql/62879 "2022-05-20T11:18:20Z")

</div>

I'm using MSSQL node from: node-red-contrib-mssql-plus. my solution this problem the problem is that the work I have to do from the second request. Can I do this with a single request? \[ { "id": "7fcde0b…

---

## [Set timer with payload](https://discourse.nodered.org/t/set-timer-with-payload/62808)

<div class="topic-metadata">

**Author:** [@matisok](https://discourse.nodered.org/u/matisok)\
**Replies:** 7\
**Last updated:** [20 May 2022 11:04 UTC](https://discourse.nodered.org/t/set-timer-with-payload/62808 "2022-05-20T11:04:04Z")

</div>

Hi I am making my own morning alarm clock with a analogue rotary dial with 5 different time presest and a 6th that's off, and a push that's snooze. I can detect the dials positions and channel each as a 1 or 0 signal t…

---

## [How to put headers only once in a csv file](https://discourse.nodered.org/t/how-to-put-headers-only-once-in-a-csv-file/62875)

<div class="topic-metadata">

**Author:** [@nke9](https://discourse.nodered.org/u/nke9)\
**Replies:** 6\
**Last updated:** [20 May 2022 10:14 UTC](https://discourse.nodered.org/t/how-to-put-headers-only-once-in-a-csv-file/62875 "2022-05-20T10:14:11Z")

</div>

Hello, I would like to know if it's possible to add juste one time the row of headers in a csv file with the csv node beaucause I don't find how to do it without programming a function ... is there another way ? Here i…

---

## [Communication Raspberry IP with FX5U (Mitsubishi)](https://discourse.nodered.org/t/communication-raspberry-ip-with-fx5u-mitsubishi/62818)

<div class="topic-metadata">

**Author:** [@kamtamer1](https://discourse.nodered.org/u/kamtamer1)\
**Replies:** 7\
**Last updated:** [20 May 2022 10:12 UTC](https://discourse.nodered.org/t/communication-raspberry-ip-with-fx5u-mitsubishi/62818 "2022-05-20T10:12:45Z")

</div>

I want to programm Raspberry Pi with Mitshubishi HMI GOT 2000 please i need help

---

## [New Grafana plugin: Websocket data source](https://discourse.nodered.org/t/new-grafana-plugin-websocket-data-source/61255)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 11\
**Last updated:** [20 May 2022 08:58 UTC](https://discourse.nodered.org/t/new-grafana-plugin-websocket-data-source/61255 "2022-05-20T08:58:39Z")

</div>

Thought this might be of interest to some people. A newly contributed Grafana plugin for getting realtime data via websocket connections. Perhaps an interesting alternative to Dashboard charts where you have lots of r…

---

## [Node-red execution error](https://discourse.nodered.org/t/node-red-execution-error/62878)

<div class="topic-metadata">

**Author:** [@haeWoozu](https://discourse.nodered.org/u/haeWoozu)\
**Replies:** 2\
**Last updated:** [20 May 2022 08:33 UTC](https://discourse.nodered.org/t/node-red-execution-error/62878 "2022-05-20T08:33:51Z")

</div>

hello. I'm not good at English, so please understand. node-red terminated abnormally. And I get the following error and it doesn't work. 20 May 17:13:21 - \[info\] Server now running at http://127.0.0.1:1880/ 20 May…

---

## [I Have Issue on MQTT to function and Template](https://discourse.nodered.org/t/i-have-issue-on-mqtt-to-function-and-template/62874)

<div class="topic-metadata">

**Author:** [@riimeister](https://discourse.nodered.org/u/riimeister)\
**Replies:** 6\
**Last updated:** [20 May 2022 08:15 UTC](https://discourse.nodered.org/t/i-have-issue-on-mqtt-to-function-and-template/62874 "2022-05-20T08:15:35Z")

</div>

I have a problem when I want to create a dashboard template. the following is the raw data from the sql server that I have and I want to make a dashboard in the data I want to create a dashboard using the if else…

---

## [Can we make a running text on node red?](https://discourse.nodered.org/t/can-we-make-a-running-text-on-node-red/62543)

<div class="topic-metadata">

**Author:** [@rzl281](https://discourse.nodered.org/u/rzl281)\
**Replies:** 5\
**Last updated:** [20 May 2022 08:07 UTC](https://discourse.nodered.org/t/can-we-make-a-running-text-on-node-red/62543 "2022-05-20T08:07:34Z")

</div>

how to make a running text on node red?

---

## [Python Virtual Environments with Node-RED](https://discourse.nodered.org/t/python-virtual-environments-with-node-red/62864)

<div class="topic-metadata">

**Author:** [@cookies](https://discourse.nodered.org/u/cookies)\
**Replies:** 1\
**Last updated:** [20 May 2022 07:07 UTC](https://discourse.nodered.org/t/python-virtual-environments-with-node-red/62864 "2022-05-20T07:07:51Z")

</div>

Hi Forum, I am working on a project that involves developing Node-RED nodes that can use Python libraries and virtual environments for interacting with Raspberry Pi. A similar example is node-red-node-pi-gpio, which I s…

---

## [Node Red Ncd Red Wireless Dashboard Installation Error](https://discourse.nodered.org/t/node-red-ncd-red-wireless-dashboard-installation-error/62871)

<div class="topic-metadata">

**Author:** [@a11ister](https://discourse.nodered.org/u/a11ister)\
**Replies:** 2\
**Last updated:** [20 May 2022 07:05 UTC](https://discourse.nodered.org/t/node-red-ncd-red-wireless-dashboard-installation-error/62871 "2022-05-20T07:05:08Z")

</div>

C:\\Users\\User\>npm i ncd-red-wireless node-red-dashboard npm ERR! code 1 npm ERR! path C:\\Users\\User\\node\_modules@serialport\\bindings npm ERR! command failed npm ERR! command C:\\WINDOWS\\system32\\cmd.exe /d /s /c prebu…

---

## [Error connecting to PLC: Error: connect EHOSTUNREACH](https://discourse.nodered.org/t/error-connecting-to-plc-error-connect-ehostunreach/62575)

<div class="topic-metadata">

**Author:** [@CY02](https://discourse.nodered.org/u/CY02)\
**Replies:** 8\
**Last updated:** [20 May 2022 04:01 UTC](https://discourse.nodered.org/t/error-connecting-to-plc-error-connect-ehostunreach/62575 "2022-05-20T04:01:31Z")

</div>

I'm currently connecting from node-red to Aubobot through TCP in node-red but node-red shows disconnected and connected frequently, and it shows an error connecting to PLC I have no idea what is this and how to solve it.…

---

## [Merging message streams](https://discourse.nodered.org/t/merging-message-streams/62870)

<div class="topic-metadata">

**Author:** [@tfuchs1987](https://discourse.nodered.org/u/tfuchs1987)\
**Replies:** 1\
**Last updated:** [20 May 2022 03:18 UTC](https://discourse.nodered.org/t/merging-message-streams/62870 "2022-05-20T03:18:17Z")

</div>

Hi Node-REDers, I want to download several email attachments and send them inside one email. Everything works so far. I just want to ask you guys what the best solution would be to merge or provide several message stre…

---

## [Ui-table scroll to specific row](https://discourse.nodered.org/t/ui-table-scroll-to-specific-row/62861)

<div class="topic-metadata">

**Author:** [@MyRandomThoughts](https://discourse.nodered.org/u/MyRandomThoughts)\
**Replies:** 1\
**Last updated:** [19 May 2022 23:10 UTC](https://discourse.nodered.org/t/ui-table-scroll-to-specific-row/62861 "2022-05-19T23:10:46Z")

</div>

I have a table containing a music playlist that has 1000 entries. Is there anyway to get it to scroll down to a specific song? I thought the command selectRow might do it, but that just selects it, it does not bring in…

---

## [How to pass method parameter into msg.payload](https://discourse.nodered.org/t/how-to-pass-method-parameter-into-msg-payload/62862)

<div class="topic-metadata">

**Author:** [@NeetaJ](https://discourse.nodered.org/u/NeetaJ)\
**Replies:** 2\
**Last updated:** [19 May 2022 22:01 UTC](https://discourse.nodered.org/t/how-to-pass-method-parameter-into-msg-payload/62862 "2022-05-19T22:01:29Z")

</div>

\[{"id":"8b4876ad871c51f5","type":"http in","z":"e97abacb4c80db24","name":"","url":"/myview","method":"get","upload":false,"swaggerDoc":"","x":250,"y":140,"wires":\[\["cb80d322be19fc9c"\]\]},{"id":"cb80d322be19fc9c","type":"t…

---

## [Find Max Value In an Array: Best Node-Red Way](https://discourse.nodered.org/t/find-max-value-in-an-array-best-node-red-way/62823)

<div class="topic-metadata">

**Author:** [@n61ab](https://discourse.nodered.org/u/n61ab)\
**Replies:** 6\
**Last updated:** [19 May 2022 21:49 UTC](https://discourse.nodered.org/t/find-max-value-in-an-array-best-node-red-way/62823 "2022-05-19T21:49:55Z")

</div>

I have an array in flow context and want to find the maximum number value. I have tried several of the Javascript math functions, with no success. Is there a contrib node for finding the maximum value in an array? Els…

---

## [Button to change images](https://discourse.nodered.org/t/button-to-change-images/62867)

<div class="topic-metadata">

**Author:** [@tai34126](https://discourse.nodered.org/u/tai34126)\
**Replies:** 0\
**Last updated:** [19 May 2022 21:41 UTC](https://discourse.nodered.org/t/button-to-change-images/62867 "2022-05-19T21:41:55Z")

</div>

Hey guys!. Sorry to bother all of you. But I have some questions about my project. I have many photos like this pic. And I want to know. How can I do the button to press the next button to change the picture and pre…

---

## [Force One Message at a Time?](https://discourse.nodered.org/t/force-one-message-at-a-time/62859)

<div class="topic-metadata">

**Author:** [@efaden](https://discourse.nodered.org/u/efaden)\
**Replies:** 2\
**Last updated:** [19 May 2022 21:25 UTC](https://discourse.nodered.org/t/force-one-message-at-a-time/62859 "2022-05-19T21:25:52Z")

</div>

I'm looking for a way to only allow a single message to be processed at a time through a block of my flow. I'd like to use a queue to queue the rest. Was going to use q-gate, but it's missing one feature. If the queu…

---

## [Help needed for 2FA with Authy](https://discourse.nodered.org/t/help-needed-for-2fa-with-authy/62764)

<div class="topic-metadata">

**Author:** [@Topolynx](https://discourse.nodered.org/u/Topolynx)\
**Replies:** 6\
**Last updated:** [19 May 2022 19:15 UTC](https://discourse.nodered.org/t/help-needed-for-2fa-with-authy/62764 "2022-05-19T19:15:55Z")

</div>

Hi! I would like to secure node-red with 2FA and a dedicated app (I'm actually using Authy for other services). What I've found in the forum and in Node-Red's support pages hasn't helped me enough. Could someone explain…

---

## [NR requires multiple browser refreshes to load flows - again](https://discourse.nodered.org/t/nr-requires-multiple-browser-refreshes-to-load-flows-again/62846)

<div class="topic-metadata">

**Author:** [@alex88](https://discourse.nodered.org/u/alex88)\
**Replies:** 6\
**Last updated:** [19 May 2022 19:11 UTC](https://discourse.nodered.org/t/nr-requires-multiple-browser-refreshes-to-load-flows-again/62846 "2022-05-19T19:11:22Z")

</div>

I am getting the same symptoms as with the issue described here: And this from the console log: Running v3.0.0 beta 2

---

## [Labor shift calculation using array.includes() method](https://discourse.nodered.org/t/labor-shift-calculation-using-array-includes-method/62863)

<div class="topic-metadata">

**Author:** [@hobbes1069](https://discourse.nodered.org/u/hobbes1069)\
**Replies:** 2\
**Last updated:** [19 May 2022 18:49 UTC](https://discourse.nodered.org/t/labor-shift-calculation-using-array-includes-method/62863 "2022-05-19T18:49:22Z")

</div>

I've got a timestamp inject node going through a date-time formatter to only output the hour of day. I'm trying to calculate the current shift, 1st, 2nd, or 3rd based on the out of day using the array.includes() method …

---

## [Node Red Internet consumption](https://discourse.nodered.org/t/node-red-internet-consumption/62851)

<div class="topic-metadata">

**Author:** [@ErosBaixauli](https://discourse.nodered.org/u/ErosBaixauli)\
**Replies:** 3\
**Last updated:** [19 May 2022 18:25 UTC](https://discourse.nodered.org/t/node-red-internet-consumption/62851 "2022-05-19T18:25:19Z")

</div>

Hi to everyone, I'm in need of some assistance for optimise the internet data consumption. I have a node red flow working on a device with a SIM card, sending sensor values through HTTP API using GPRS or 4G, once per mi…

---

## [MQTT offline broker](https://discourse.nodered.org/t/mqtt-offline-broker/62703)

<div class="topic-metadata">

**Author:** [@sn19](https://discourse.nodered.org/u/sn19)\
**Replies:** 5\
**Last updated:** [19 May 2022 17:53 UTC](https://discourse.nodered.org/t/mqtt-offline-broker/62703 "2022-05-19T17:53:04Z")

</div>

Hello All. I am trying to setup and use an offline MQTT broker. Any suggestions with this? Please let me know about it and thank you.

---

## [Serving values formed in the oneditsafe of html file as a variable for the flow](https://discourse.nodered.org/t/serving-values-formed-in-the-oneditsafe-of-html-file-as-a-variable-for-the-flow/62853)

<div class="topic-metadata">

**Author:** [@GianniCeleste](https://discourse.nodered.org/u/GianniCeleste)\
**Replies:** 0\
**Last updated:** [19 May 2022 14:58 UTC](https://discourse.nodered.org/t/serving-values-formed-in-the-oneditsafe-of-html-file-as-a-variable-for-the-flow/62853 "2022-05-19T14:58:14Z")

</div>

Hello everyone, A while ago, I was developing a node as described in this thread, to which I cannot post anymore as it was inactive for \>60 days. I got to the point where the base functionality I want to achieve is the…

---

## [How to create session id after login is validated](https://discourse.nodered.org/t/how-to-create-session-id-after-login-is-validated/62836)

<div class="topic-metadata">

**Author:** [@Rocky](https://discourse.nodered.org/u/Rocky)\
**Replies:** 0\
**Last updated:** [19 May 2022 07:17 UTC](https://discourse.nodered.org/t/how-to-create-session-id-after-login-is-validated/62836 "2022-05-19T07:17:59Z")

</div>

I am working on creating a login page for the dashboard which I have created in Node Red. As of now I am able to validate the user name and password entered by user against the data stored in database. But after validati…

---

## [\[UPDATE\] node-red-contrib-zwave-js v7.1.0](https://discourse.nodered.org/t/update-node-red-contrib-zwave-js-v7-1-0/62847)

<div class="topic-metadata">

**Author:** [@marcus-j-davies](https://discourse.nodered.org/u/marcus-j-davies)\
**Replies:** 0\
**Last updated:** [19 May 2022 12:23 UTC](https://discourse.nodered.org/t/update-node-red-contrib-zwave-js-v7-1-0/62847 "2022-05-19T12:23:19Z")

</div>

Afternoon All, Just to advise of some Feature updates for node-red-contrib-zwave-js in the form of v7.1.0 New Features Added new Advanced Transceiver Settings dialog (and where supported by the ZWave radio in use) R…

---

## [Format JSON before writing to a file](https://discourse.nodered.org/t/format-json-before-writing-to-a-file/62838)

<div class="topic-metadata">

**Author:** [@cymplecy](https://discourse.nodered.org/u/cymplecy)\
**Replies:** 3\
**Last updated:** [19 May 2022 09:33 UTC](https://discourse.nodered.org/t/format-json-before-writing-to-a-file/62838 "2022-05-19T09:33:37Z")

</div>

Dear Father, I am sinning - I'm writing a flow to modify flows.json :frowning: Now that's over with :slight\_smile: is there an easy method of nicely formatting my JSON before writing it to file e.g instead of this …

---

## [How to make Dashboard webserver more robust?](https://discourse.nodered.org/t/how-to-make-dashboard-webserver-more-robust/61295)

<div class="topic-metadata">

**Author:** [@thebaldgeek](https://discourse.nodered.org/u/thebaldgeek)\
**Replies:** 32\
**Last updated:** [19 May 2022 08:51 UTC](https://discourse.nodered.org/t/how-to-make-dashboard-webserver-more-robust/61295 "2022-05-19T08:51:38Z")

</div>

My users keep getting "Connection lost" message in the top right corner of the dashboard and shortly thereafter the site refreshes on them. Node-RED Dashboard is here: https://acars.adsbexchange.com/ I have moved my …

---

## [Velbus support for Node Red](https://discourse.nodered.org/t/velbus-support-for-node-red/6757)

<div class="topic-metadata">

**Author:** [@gertst](https://discourse.nodered.org/u/gertst)\
**Replies:** 1\
**Last updated:** [19 May 2022 07:34 UTC](https://discourse.nodered.org/t/velbus-support-for-node-red/6757 "2022-05-19T07:34:21Z")

</div>

I have created an integration with Velbus - the home automation system made by Velleman. You can find my project called node-red-contrib-velbus here or simply install it in your Node-red setup by searching for 'Velbus' …

---

## [How to deprecate / remove packages from the catalogue?](https://discourse.nodered.org/t/how-to-deprecate-remove-packages-from-the-catalogue/62833)

<div class="topic-metadata">

**Author:** [@hrueger](https://discourse.nodered.org/u/hrueger)\
**Replies:** 2\
**Last updated:** [19 May 2022 07:12 UTC](https://discourse.nodered.org/t/how-to-deprecate-remove-packages-from-the-catalogue/62833 "2022-05-19T07:12:10Z")

</div>

Hi, Is there any way to deprecate / hide / remove a packages from the catalogue / the palettes? Because of a company name change, we also moved our package from @oldcompanyname/packagename to just packagename. The prob…

---

## [Download Siemens MPI/ PPI/ DP, error](https://discourse.nodered.org/t/download-siemens-mpi-ppi-dp-error/62822)

<div class="topic-metadata">

**Author:** [@Hernane](https://discourse.nodered.org/u/Hernane)\
**Replies:** 1\
**Last updated:** [19 May 2022 06:27 UTC](https://discourse.nodered.org/t/download-siemens-mpi-ppi-dp-error/62822 "2022-05-19T06:27:12Z")

</div>

Hello friends, I'm trying to connect a siemens Profibus DP communication board, but when downloading Node - RED ... Siemens MPI/ PPI/ DP adapters, an error occurs. Can you help me?

[Previous page](https://discourse.nodered.org/latest.md?page=565)

[Next page](https://discourse.nodered.org/latest.md?page=567)