# Latest

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

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

**Page:** 370

---

## [Get DayOfTheYear from moment node?](https://discourse.nodered.org/t/get-dayoftheyear-from-moment-node/77009)

<div class="topic-metadata">

**Author:** [@Gawan](https://discourse.nodered.org/u/Gawan)\
**Replies:** 9\
**Last updated:** [28 March 2023 14:15 UTC](https://discourse.nodered.org/t/get-dayoftheyear-from-moment-node/77009 "2023-03-28T14:15:53Z")

</div>

Is there a way to get the day of the year (like 120 out of 365) from the moment node ? BR G

---

## [Rearranging an Array and then adding more labels to a JSON expression](https://discourse.nodered.org/t/rearranging-an-array-and-then-adding-more-labels-to-a-json-expression/76996)

<div class="topic-metadata">

**Author:** [@mudwalker](https://discourse.nodered.org/u/mudwalker)\
**Replies:** 4\
**Last updated:** [28 March 2023 13:26 UTC](https://discourse.nodered.org/t/rearranging-an-array-and-then-adding-more-labels-to-a-json-expression/76996 "2023-03-28T13:26:15Z")

</div>

Hi, I have JSON expression of a list of devices connected to my Network. I have searched the Forum for similar requirements, with no success. Consequently I have spent quite some time trying to re-arrange the array to…

---

## [Wrong Timezone in NR - 2 hours to early](https://discourse.nodered.org/t/wrong-timezone-in-nr-2-hours-to-early/76979)

<div class="topic-metadata">

**Author:** [@Gawan](https://discourse.nodered.org/u/Gawan)\
**Replies:** 20\
**Last updated:** [28 March 2023 11:50 UTC](https://discourse.nodered.org/t/wrong-timezone-in-nr-2-hours-to-early/76979 "2023-03-28T11:50:21Z")

</div>

Hi, I just found out, that my NR is showing the wrong timezone. Although my server is using CEST and the right time ... ... if I use this function in NR msg.payload = new Date().toISOString(); I get this as a resu…

---

## [Sending data to Graphite using Node-RED](https://discourse.nodered.org/t/sending-data-to-graphite-using-node-red/76998)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 3\
**Last updated:** [28 March 2023 11:42 UTC](https://discourse.nodered.org/t/sending-data-to-graphite-using-node-red/76998 "2023-03-28T11:42:00Z")

</div>

Greetings. The subject of how to send data into a Graphite database has come up in this forum, but to my knowledge, the nut has not been cracked. I'd like to do that now, but need a little help. This post concluded th…

---

## [Nested table in node red](https://discourse.nodered.org/t/nested-table-in-node-red/76894)

<div class="topic-metadata">

**Author:** [@Jhankhana](https://discourse.nodered.org/u/Jhankhana)\
**Replies:** 9\
**Last updated:** [28 March 2023 11:13 UTC](https://discourse.nodered.org/t/nested-table-in-node-red/76894 "2023-03-28T11:13:03Z")

</div>

Hello there, How to create nested table? I have tried with template node using html but then how to pass on the value coming through mag.payload? is there any other way to create nested table? Please help me with thi…

---

## [Node red contrib mpi s7 can't be installed](https://discourse.nodered.org/t/node-red-contrib-mpi-s7-cant-be-installed/77014)

<div class="topic-metadata">

**Author:** [@ZEus](https://discourse.nodered.org/u/ZEus)\
**Replies:** 1\
**Last updated:** [28 March 2023 10:43 UTC](https://discourse.nodered.org/t/node-red-contrib-mpi-s7-cant-be-installed/77014 "2023-03-28T10:43:14Z")

</div>

error while installing node red contrib s7 please help me !

---

## [Sqlite3 not installed or broken](https://discourse.nodered.org/t/sqlite3-not-installed-or-broken/77010)

<div class="topic-metadata">

**Author:** [@nerevar](https://discourse.nodered.org/u/nerevar)\
**Replies:** 1\
**Last updated:** [28 March 2023 09:27 UTC](https://discourse.nodered.org/t/sqlite3-not-installed-or-broken/77010 "2023-03-28T09:27:00Z")

</div>

Hello, I've been trying to do reindex on my db but nothing happens when I run it through the node-red. So I tried to do it through shell, but seems there is no sqlite3 installed. Which is weid because node-red-node-sq…

---

## [Can't install "npm install @ais\_automation/node-red-node-ciss"](https://discourse.nodered.org/t/cant-install-npm-install-ais-automation-node-red-node-ciss/76975)

<div class="topic-metadata">

**Author:** [@mr.saubhagya](https://discourse.nodered.org/u/mr.saubhagya)\
**Replies:** 6\
**Last updated:** [28 March 2023 08:51 UTC](https://discourse.nodered.org/t/cant-install-npm-install-ais-automation-node-red-node-ciss/76975 "2023-03-28T08:51:35Z")

</div>

Hey there. I couldn't install npm install @ais\_automation/node-red-node-ciss. Please help me in that. Regards,

---

## [Node red on RPi refuse to connect to MySQL DB running on another RPi on local LAN](https://discourse.nodered.org/t/node-red-on-rpi-refuse-to-connect-to-mysql-db-running-on-another-rpi-on-local-lan/76990)

<div class="topic-metadata">

**Author:** [@fritserasmus](https://discourse.nodered.org/u/fritserasmus)\
**Replies:** 14\
**Last updated:** [28 March 2023 07:39 UTC](https://discourse.nodered.org/t/node-red-on-rpi-refuse-to-connect-to-mysql-db-running-on-another-rpi-on-local-lan/76990 "2023-03-28T07:39:13Z")

</div>

I have my Node-RED on a RPi 192.168.1.23 and MySQL on another RPi 192.168.1.24 I used to have Node-RED, MQTT server and MySQL DB server on one RPi , but it struggled so I am splitting it up to two RPi with Node-RED and …

---

## [NMEA Checksum calculation](https://discourse.nodered.org/t/nmea-checksum-calculation/77002)

<div class="topic-metadata">

**Author:** [@Arnie419](https://discourse.nodered.org/u/Arnie419)\
**Replies:** 2\
**Last updated:** [28 March 2023 06:50 UTC](https://discourse.nodered.org/t/nmea-checksum-calculation/77002 "2023-03-28T06:50:27Z")

</div>

Am rebuildng an exisintg NMEA sentence from a weathersensor into another NMEA format but when doing the checksum at the final end of the NMEA sentence i do get small letters while the NMEA standard describes that every c…

---

## [Concatenate Textfiled with a string triggered by a button](https://discourse.nodered.org/t/concatenate-textfiled-with-a-string-triggered-by-a-button/76987)

<div class="topic-metadata">

**Author:** [@radioman85](https://discourse.nodered.org/u/radioman85)\
**Replies:** 7\
**Last updated:** [28 March 2023 06:33 UTC](https://discourse.nodered.org/t/concatenate-textfiled-with-a-string-triggered-by-a-button/76987 "2023-03-28T06:33:54Z")

</div>

Hi, I want to send a string as an MQTT message. However I struggle when trying to set up a text field that is deployed as soon as a button is pressed. My project: I have a stepper motor connected to an Arduino Wifi. I…

---

## [How could I connect to nodered for a business cooperation?](https://discourse.nodered.org/t/how-could-i-connect-to-nodered-for-a-business-cooperation/77007)

<div class="topic-metadata">

**Author:** [@jennazhuxj](https://discourse.nodered.org/u/jennazhuxj)\
**Replies:** 0\
**Last updated:** [28 March 2023 06:01 UTC](https://discourse.nodered.org/t/how-could-i-connect-to-nodered-for-a-business-cooperation/77007 "2023-03-28T06:01:29Z")

</div>

I worked in an open-source hardware company and just released a new product natively integrated with Node-RED. And as the marketer, I'd love to talk with Node-RED for further marketing cooperation, who could help me with…

---

## [\[SOLVED\] What lightstrips are compatible with Node Red?](https://discourse.nodered.org/t/solved-what-lightstrips-are-compatible-with-node-red/76917)

<div class="topic-metadata">

**Author:** [@Aaroneisele55](https://discourse.nodered.org/u/Aaroneisele55)\
**Replies:** 7\
**Last updated:** [25 March 2023 19:21 UTC](https://discourse.nodered.org/t/solved-what-lightstrips-are-compatible-with-node-red/76917 "2023-03-25T19:21:24Z")

</div>

Hello, I'm looking for a RGB lightstrip that: (second most important): is off-the-shelf, so I don't have to worry about power supply or flash ESPs or even solder (which I'm totally bad at) (the most important thing:) i…

---

## [Node-red-contrib-mssql-plus Execute Procedure](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-execute-procedure/76985)

<div class="topic-metadata">

**Author:** [@protonmw](https://discourse.nodered.org/u/protonmw)\
**Replies:** 2\
**Last updated:** [27 March 2023 21:50 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-execute-procedure/76985 "2023-03-27T21:50:32Z")

</div>

Hi all! Could anyone give my an example of executing a stored procedure (with 2 parameters), please? gives me msg.payload: undefined This is the working SQL studio code: USE \[xxx\] GO DECLARE @return\_value int EX…

---

## [Uibuilder - example pure SVG gauge created dynamically](https://discourse.nodered.org/t/uibuilder-example-pure-svg-gauge-created-dynamically/76969)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 2\
**Last updated:** [27 March 2023 19:38 UTC](https://discourse.nodered.org/t/uibuilder-example-pure-svg-gauge-created-dynamically/76969 "2023-03-27T19:38:58Z")

</div>

Really can't genuinely call this "zero" code. However, it is certainly low-code. You will need v6.3.0 (just published) to try this example because that release now allows not just HTML to be created dynamically but SVG i…

---

## [Node-red crashing](https://discourse.nodered.org/t/node-red-crashing/76992)

<div class="topic-metadata">

**Author:** [@pbhanu368](https://discourse.nodered.org/u/pbhanu368)\
**Replies:** 1\
**Last updated:** [27 March 2023 16:24 UTC](https://discourse.nodered.org/t/node-red-crashing/76992 "2023-03-27T16:24:32Z")

</div>

node red crashing when its launched without launching rosbridge\_server websocket. Its working when rosbridge\_server\_web\_socket launched after that the node-red is launching

---

## [Node Red MQTT Nodes Not Resolving DNS CNAME Records?](https://discourse.nodered.org/t/node-red-mqtt-nodes-not-resolving-dns-cname-records/76947)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 4\
**Last updated:** [27 March 2023 16:17 UTC](https://discourse.nodered.org/t/node-red-mqtt-nodes-not-resolving-dns-cname-records/76947 "2023-03-27T16:17:10Z")

</div>

I have a DNS CNAME record set to broker.dd.org, the actual DNS name is infrastructure.dd.org. When I try to use the CNAME record the Node Red MQTT nodes fail to connect. Use of IP address works Use of actual DNS nam…

---

## [\[Announce\] node-red-contrib-discrete-fsm](https://discourse.nodered.org/t/announce-node-red-contrib-discrete-fsm/76835)

<div class="topic-metadata">

**Author:** [@mjkoster](https://discourse.nodered.org/u/mjkoster)\
**Replies:** 13\
**Last updated:** [27 March 2023 15:52 UTC](https://discourse.nodered.org/t/announce-node-red-contrib-discrete-fsm/76835 "2023-03-27T15:52:32Z")

</div>

This is a set of Node-RED nodes that implements Finite State Machines (FSM). In contrast to existing monolithic fsm nodes, each Input, Output, Condition, and State of the FSM is modeled as a discrete node in a Node-RE…

---

## [What is the proper way to clear a dashboard form? Just send an empty array payload like for a table?](https://discourse.nodered.org/t/what-is-the-proper-way-to-clear-a-dashboard-form-just-send-an-empty-array-payload-like-for-a-table/76846)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 6\
**Last updated:** [27 March 2023 13:45 UTC](https://discourse.nodered.org/t/what-is-the-proper-way-to-clear-a-dashboard-form-just-send-an-empty-array-payload-like-for-a-table/76846 "2023-03-27T13:45:09Z")

</div>

What is the proper way to clear a dashboard from? Just send an empty array payload like for a table? msg.payload = \[ \] for example?

---

## [Node-red-contrib-pccc](https://discourse.nodered.org/t/node-red-contrib-pccc/76890)

<div class="topic-metadata">

**Author:** [@ArtemFomin](https://discourse.nodered.org/u/ArtemFomin)\
**Replies:** 4\
**Last updated:** [27 March 2023 12:49 UTC](https://discourse.nodered.org/t/node-red-contrib-pccc/76890 "2023-03-27T12:49:56Z")

</div>

Hello i Have wathed this video and I can't find 08 PCCC\_Nodered (From image attached) Should i change Harware settings so the PCCC\_Nodered is determinated?

---

## [Array group by text based on certain character](https://discourse.nodered.org/t/array-group-by-text-based-on-certain-character/76982)

<div class="topic-metadata">

**Author:** [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Replies:** 3\
**Last updated:** [27 March 2023 11:27 UTC](https://discourse.nodered.org/t/array-group-by-text-based-on-certain-character/76982 "2023-03-27T11:27:19Z")

</div>

I have been in a fight with an array which is similar to (original contains 5000+ elements): \[ "Some Section ⌄", "b", "c", "d", "e", "Some Other section ⌄", "b", "c", "d", "x", …

---

## [Where to store plain-text credentials in a container volume when \`credentialSecret\` is set for multiple node-RED instances?](https://discourse.nodered.org/t/where-to-store-plain-text-credentials-in-a-container-volume-when-credentialsecret-is-set-for-multiple-node-red-instances/76981)

<div class="topic-metadata">

**Author:** [@Shan](https://discourse.nodered.org/u/Shan)\
**Replies:** 0\
**Last updated:** [27 March 2023 10:12 UTC](https://discourse.nodered.org/t/where-to-store-plain-text-credentials-in-a-container-volume-when-credentialsecret-is-set-for-multiple-node-red-instances/76981 "2023-03-27T10:12:17Z")

</div>

Based on previous discussions regarding credentialSecret and flows\_cred.json for multiple instances (See 1). I there are way to store the credentials of dedicated brokers, databases for node before spinning a container u…

---

## [Combine multiple battery sensors into one topic for MQTT for HA integration to Victron Venus](https://discourse.nodered.org/t/combine-multiple-battery-sensors-into-one-topic-for-mqtt-for-ha-integration-to-victron-venus/76967)

<div class="topic-metadata">

**Author:** [@Gliebig](https://discourse.nodered.org/u/Gliebig)\
**Replies:** 5\
**Last updated:** [27 March 2023 08:34 UTC](https://discourse.nodered.org/t/combine-multiple-battery-sensors-into-one-topic-for-mqtt-for-ha-integration-to-victron-venus/76967 "2023-03-27T08:34:58Z")

</div>

I'm new to Node red using it on the Venus Large app on a pi to monitor several data points on my RV. I've spent about 8 hours trying to figure this out watching multiple tutorials on YouTube and reading the docs and I st…

---

## [\[worldmap\] Is it possible to completely prevent the popup when a marker is clicked?](https://discourse.nodered.org/t/worldmap-is-it-possible-to-completely-prevent-the-popup-when-a-marker-is-clicked/76786)

<div class="topic-metadata">

**Author:** [@rmwiseman](https://discourse.nodered.org/u/rmwiseman)\
**Replies:** 5\
**Last updated:** [27 March 2023 08:22 UTC](https://discourse.nodered.org/t/worldmap-is-it-possible-to-completely-prevent-the-popup-when-a-marker-is-clicked/76786 "2023-03-27T08:22:28Z")

</div>

I have been trying to prevent the popup being displayed for a marker when it's clicked. With circles, I can simply set clickable to false and the popup is not displayed. But clickable seems to have no effect for marker…

---

## [Prevent flow tigger on node-red startup](https://discourse.nodered.org/t/prevent-flow-tigger-on-node-red-startup/76948)

<div class="topic-metadata">

**Author:** [@Gibbz](https://discourse.nodered.org/u/Gibbz)\
**Replies:** 5\
**Last updated:** [27 March 2023 08:17 UTC](https://discourse.nodered.org/t/prevent-flow-tigger-on-node-red-startup/76948 "2023-03-27T08:17:11Z")

</div>

I have a zigbee doorbell, its default action is "single" click. And it is the default state. So when I restart node-red it triggers the doorbell. This is annoying as I don't want this to happen when im updating the serve…

---

## [I'm not seeing the elephant - code help](https://discourse.nodered.org/t/im-not-seeing-the-elephant-code-help/76973)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 3\
**Last updated:** [27 March 2023 08:02 UTC](https://discourse.nodered.org/t/im-not-seeing-the-elephant-code-help/76973 "2023-03-27T08:02:54Z")

</div>

Given the message structure is correct: I am not understanding why I am not seeing the correct output. // msg.existing is the EXISTING value for the LEDs // Split the payload. const check = msg.payload.split(","); n…

---

## [Modbus\_assign a string to different int-values](https://discourse.nodered.org/t/modbus-assign-a-string-to-different-int-values/76736)

<div class="topic-metadata">

**Author:** [@Manuel\_o](https://discourse.nodered.org/u/Manuel_o)\
**Replies:** 2\
**Last updated:** [27 March 2023 07:05 UTC](https://discourse.nodered.org/t/modbus-assign-a-string-to-different-int-values/76736 "2023-03-27T07:05:56Z")

</div>

Hello. I hope my topic is kinda right. I am experimenting with MODBUS (again). Today i try to read a WarningCode and an AlarmCode from my pump via MODBUS. There a 2 adresses to read out warning and Alarm. Alarm = 216 …

---

## [OPCUA "ReferenceError: opcuaBasics is not defined"](https://discourse.nodered.org/t/opcua-referenceerror-opcuabasics-is-not-defined/76647)

<div class="topic-metadata">

**Author:** [@mr.saubhagya](https://discourse.nodered.org/u/mr.saubhagya)\
**Replies:** 2\
**Last updated:** [27 March 2023 06:34 UTC](https://discourse.nodered.org/t/opcua-referenceerror-opcuabasics-is-not-defined/76647 "2023-03-27T06:34:09Z")

</div>

Hello. I am using OPCUA in node-red. I am getting "ReferenceError: opcuaBasics is not defined". I have installed "node-red-contrib-opcua (0.2.299)". Plz suggest.

---

## [Socketcan results](https://discourse.nodered.org/t/socketcan-results/76949)

<div class="topic-metadata">

**Author:** [@Phoenix](https://discourse.nodered.org/u/Phoenix)\
**Replies:** 2\
**Last updated:** [27 March 2023 06:04 UTC](https://discourse.nodered.org/t/socketcan-results/76949 "2023-03-27T06:04:00Z")

</div>

Dear all, I am having some trouble reading the results from a SocketCan out. First of all I am receiving also what I'm sending. Don't know why. How could I filter that? Second is that the result is already in decimal. …

---

## [Problem with npm](https://discourse.nodered.org/t/problem-with-npm/75650)

<div class="topic-metadata">

**Author:** [@demokedes](https://discourse.nodered.org/u/demokedes)\
**Replies:** 5\
**Last updated:** [27 March 2023 01:44 UTC](https://discourse.nodered.org/t/problem-with-npm/75650 "2023-03-27T01:44:27Z")

</div>

Dear all, I am using node-red for a while already. Today I was doing something outside of node-red on the server where node-red is running. As a consequence, server became unresponsive. I forced restart of virtual machi…

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

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