# General

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

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

**Page:** 228

---

## [Getting charts to work - NOOB](https://discourse.nodered.org/t/getting-charts-to-work-noob/76909)

<div class="topic-metadata">

**Author:** [@topnotchit](https://discourse.nodered.org/u/topnotchit)\
**Replies:** 5\
**Last updated:** [28 March 2023 22:32 UTC](https://discourse.nodered.org/t/getting-charts-to-work-noob/76909 "2023-03-28T22:32:03Z")

</div>

Hi, I am very new to Node Red, but I am trying to learn. I am replicating this solar forecast service here. I installed node-red-contrib-chartjs and added it to the flow. The chart is created, but it is blank. Was wo…

---

## [A Change node JSONata question](https://discourse.nodered.org/t/a-change-node-jsonata-question/77023)

<div class="topic-metadata">

**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Replies:** 10\
**Last updated:** [28 March 2023 21:36 UTC](https://discourse.nodered.org/t/a-change-node-jsonata-question/77023 "2023-03-28T21:36:18Z")

</div>

I have two global variables: global.mac = "E4:5F:01:FE:DC:BA" and global.macvendors = { "E8:48:B8":"TP-Link", "E4:5F:01":"Raspberry Pi", "5C:CF:7F":"Espressif", "D8:49:2F":"Canon" } So the vendor bit of mac is $…

---

## [Many Tasmota Devices OR how to update many UI-Switches](https://discourse.nodered.org/t/many-tasmota-devices-or-how-to-update-many-ui-switches/77025)

<div class="topic-metadata">

**Author:** [@dondario](https://discourse.nodered.org/u/dondario)\
**Replies:** 8\
**Last updated:** [28 March 2023 21:06 UTC](https://discourse.nodered.org/t/many-tasmota-devices-or-how-to-update-many-ui-switches/77025 "2023-03-28T21:06:27Z")

</div>

Hi together, due to the fact, that my first question here got a so satisfying answer, I will try to explain my new Problem. I have many Tasmota Devices (Switched-Power Outlets) and I switch them with UI Switches. To h…

---

## [Node-red-mcu-plugin error when reinstalling](https://discourse.nodered.org/t/node-red-mcu-plugin-error-when-reinstalling/77021)

<div class="topic-metadata">

**Author:** [@Frida](https://discourse.nodered.org/u/Frida)\
**Replies:** 6\
**Last updated:** [28 March 2023 19:27 UTC](https://discourse.nodered.org/t/node-red-mcu-plugin-error-when-reinstalling/77021 "2023-03-28T19:27:36Z")

</div>

After reinstalling node-red and @ralphwetzel/node-red-mcu-plugin, I've encountered these issues: 1: After first start of node-red this error came, see pic01 2: I removed the =, and tried again. 3: After second start o…

---

## [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…

---

## [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…

---

## [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…

---

## [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…

---

## [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…

---

## [Chicken Coop Predator Lighting - Blink - JavaScript Question](https://discourse.nodered.org/t/chicken-coop-predator-lighting-blink-javascript-question/76972)

<div class="topic-metadata">

**Author:** [@richiep](https://discourse.nodered.org/u/richiep)\
**Replies:** 4\
**Last updated:** [26 March 2023 23:08 UTC](https://discourse.nodered.org/t/chicken-coop-predator-lighting-blink-javascript-question/76972 "2023-03-26T23:08:39Z")

</div>

Hey All, I'm putting together an esp8266 board with motion sensors and lights to help protect my chickens from nighttime predators. When the motion sensor is tripped I want to blink lights for a short period and then h…

---

## [Join into an array... How to pass into the same place every time](https://discourse.nodered.org/t/join-into-an-array-how-to-pass-into-the-same-place-every-time/76896)

<div class="topic-metadata">

**Author:** [@aqueousdan](https://discourse.nodered.org/u/aqueousdan)\
**Replies:** 3\
**Last updated:** [26 March 2023 19:57 UTC](https://discourse.nodered.org/t/join-into-an-array-how-to-pass-into-the-same-place-every-time/76896 "2023-03-26T19:57:10Z")

</div>

I'm moving values from the JSON nodes into an array but they seem to come through in an uncertain order. Is there a way to make sure the same node moves its value into the same place in the array every time? \[ { …

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

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