# General

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

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

**Page:** 589

---

## [SocketCan and CAN\_FD frame](https://discourse.nodered.org/t/socketcan-and-can-fd-frame/42510)

<div class="topic-metadata">

**Author:** [@guillaumetournabien](https://discourse.nodered.org/u/guillaumetournabien)\
**Replies:** 0\
**Last updated:** [11 March 2021 20:32 UTC](https://discourse.nodered.org/t/socketcan-and-can-fd-frame/42510 "2021-03-11T20:32:50Z")

</div>

HEllo I'm using the CANBUS for my project but I'm not able to send/receive CAN FD frame with SocketCan. I know that it's not currently supported on the "node-red-contrib-socketcan" but I don't have the knowledge to ada…

---

## [Is it possible to set a fractional zoom level for node-red-contrib-web-worldmap?](https://discourse.nodered.org/t/is-it-possible-to-set-a-fractional-zoom-level-for-node-red-contrib-web-worldmap/42417)

<div class="topic-metadata">

**Author:** [@janvda](https://discourse.nodered.org/u/janvda)\
**Replies:** 8\
**Last updated:** [11 March 2021 19:17 UTC](https://discourse.nodered.org/t/is-it-possible-to-set-a-fractional-zoom-level-for-node-red-contrib-web-worldmap/42417 "2021-03-11T19:17:28Z")

</div>

Is it possible to enable fractional zoom levels (e.g. 2.5) for node-red-contrib-web-worldmap ? I can specify a fractional zoom level but it doesn't take the fractional part into account. When a fractional part is spec…

---

## [Node-red running port to variable](https://discourse.nodered.org/t/node-red-running-port-to-variable/42495)

<div class="topic-metadata">

**Author:** [@narc0z](https://discourse.nodered.org/u/narc0z)\
**Replies:** 2\
**Last updated:** [11 March 2021 18:46 UTC](https://discourse.nodered.org/t/node-red-running-port-to-variable/42495 "2021-03-11T18:46:30Z")

</div>

Hello! How can I retrieve the port that node-red is running on (ex. 1880) and use it as any form of variable inside the editor? I am eventually looking to have several instances running with same settings and userDir (n…

---

## ["node-red-contrib-fritz" push data to "node-red-contrib-influxdb"](https://discourse.nodered.org/t/node-red-contrib-fritz-push-data-to-node-red-contrib-influxdb/42422)

<div class="topic-metadata">

**Author:** [@duffy6](https://discourse.nodered.org/u/duffy6)\
**Replies:** 8\
**Last updated:** [11 March 2021 18:24 UTC](https://discourse.nodered.org/t/node-red-contrib-fritz-push-data-to-node-red-contrib-influxdb/42422 "2021-03-11T18:24:11Z")

</div>

Hi guys, I want to pull data from my fritzbox with node-red-contrib-fritz and send it to influxdb with node-red-contrib-influxdb. My output from fritzbox looks like this msg.payload : Object object NewTotalBytesSent…

---

## [Need some quick assistance](https://discourse.nodered.org/t/need-some-quick-assistance/42497)

<div class="topic-metadata">

**Author:** [@muddro1](https://discourse.nodered.org/u/muddro1)\
**Replies:** 3\
**Last updated:** [11 March 2021 18:04 UTC](https://discourse.nodered.org/t/need-some-quick-assistance/42497 "2021-03-11T18:04:54Z")

</div>

I am creating a flow that triggers when I receive certain text messages. The texts will always contain the following language: "MyENVERA: PERSON just arrived for ME, was verified and entry granted" I want to be able to…

---

## [MySQL - error in SQL syntax](https://discourse.nodered.org/t/mysql-error-in-sql-syntax/42370)

<div class="topic-metadata">

**Author:** [@duckmysick](https://discourse.nodered.org/u/duckmysick)\
**Replies:** 18\
**Last updated:** [11 March 2021 17:53 UTC](https://discourse.nodered.org/t/mysql-error-in-sql-syntax/42370 "2021-03-11T17:53:18Z")

</div>

Hi, I'm new here so sorry if i'm not in the good place for asking and I know this problem has been asked a lot but no one of other subjects helped me. This is my project: nodered version of security camera when it d…

---

## [File in and ui\_audio, sound not directly stopping](https://discourse.nodered.org/t/file-in-and-ui-audio-sound-not-directly-stopping/42485)

<div class="topic-metadata">

**Author:** [@jerxjac](https://discourse.nodered.org/u/jerxjac)\
**Replies:** 3\
**Last updated:** [11 March 2021 17:39 UTC](https://discourse.nodered.org/t/file-in-and-ui-audio-sound-not-directly-stopping/42485 "2021-03-11T17:39:11Z")

</div>

Hi I use 'file in' and 'audio out' node to play a mp3 file the file in is set to "a single buffer object." When I pass a msg.reset to the 'audio out' node it should stop, but continues playing. It looks like it keep …

---

## [Some help and advice please!](https://discourse.nodered.org/t/some-help-and-advice-please/42475)

<div class="topic-metadata">

**Author:** [@Dgillett](https://discourse.nodered.org/u/Dgillett)\
**Replies:** 2\
**Last updated:** [11 March 2021 17:26 UTC](https://discourse.nodered.org/t/some-help-and-advice-please/42475 "2021-03-11T17:26:35Z")

</div>

So some background on what I have used node red for. I am currently a controls engineer and was trying to find a way to track data from water flows on different circuits on a machine over my companies network. This led m…

---

## [Use installed node.js modules from node-red functions](https://discourse.nodered.org/t/use-installed-node-js-modules-from-node-red-functions/42490)

<div class="topic-metadata">

**Author:** [@Don](https://discourse.nodered.org/u/Don)\
**Replies:** 7\
**Last updated:** [11 March 2021 17:11 UTC](https://discourse.nodered.org/t/use-installed-node-js-modules-from-node-red-functions/42490 "2021-03-11T17:11:40Z")

</div>

Hi, New to node-red, new to node.js - please forgive (and correct) newbie errors. My node-red is installed on Linux, following directions from various node-red web pages. All working well. I read directions for insta…

---

## [Global configuration Nodes Help](https://discourse.nodered.org/t/global-configuration-nodes-help/41501)

<div class="topic-metadata">

**Author:** [@mich3000](https://discourse.nodered.org/u/mich3000)\
**Replies:** 6\
**Last updated:** [11 March 2021 15:38 UTC](https://discourse.nodered.org/t/global-configuration-nodes-help/41501 "2021-03-11T15:38:23Z")

</div>

I am using node-red-contrib-auth node and its config. Is it possible to set value of secret key from variable and not hardcoded? Is this specific only for this node config or all global configuration nodes? Thank fo…

---

## [Counter loop dosen't count properly](https://discourse.nodered.org/t/counter-loop-dosent-count-properly/42479)

<div class="topic-metadata">

**Author:** [@erikthegamer1242](https://discourse.nodered.org/u/erikthegamer1242)\
**Replies:** 3\
**Last updated:** [11 March 2021 14:29 UTC](https://discourse.nodered.org/t/counter-loop-dosent-count-properly/42479 "2021-03-11T14:29:24Z")

</div>

(counter loop used from node-red-contrib-counter : counter) I have a flow that receives mqtt data from a wifi button and forwards it(after some processing and node-red-ui data forwarding) to mqtt led strip controller. I…

---

## [Node red inside iframe](https://discourse.nodered.org/t/node-red-inside-iframe/42188)

<div class="topic-metadata">

**Author:** [@adigavageesh](https://discourse.nodered.org/u/adigavageesh)\
**Replies:** 7\
**Last updated:** [11 March 2021 14:16 UTC](https://discourse.nodered.org/t/node-red-inside-iframe/42188 "2021-03-11T14:16:37Z")

</div>

When I tried to integrate node red server inside iframe it's giving only header and rest of the contents are grayed out.. any solution for this..? And also to do the efficiency way of SSO integration from existing app t…

---

## [Home Assistant Value Templates in Node Red](https://discourse.nodered.org/t/home-assistant-value-templates-in-node-red/42466)

<div class="topic-metadata">

**Author:** [@liminal](https://discourse.nodered.org/u/liminal)\
**Replies:** 1\
**Last updated:** [11 March 2021 13:02 UTC](https://discourse.nodered.org/t/home-assistant-value-templates-in-node-red/42466 "2021-03-11T13:02:41Z")

</div>

Hey all, I have a yaml home assistant automation that I want to convert to NR. But I'm unsure how to have NR do the value template checks? Can a sequence be a named entity as it were, that can be referenced by other se…

---

## [CSV Parser when triggering msg includes 'parts'](https://discourse.nodered.org/t/csv-parser-when-triggering-msg-includes-parts/42380)

<div class="topic-metadata">

**Author:** [@RobC](https://discourse.nodered.org/u/RobC)\
**Replies:** 9\
**Last updated:** [11 March 2021 11:29 UTC](https://discourse.nodered.org/t/csv-parser-when-triggering-msg-includes-parts/42380 "2021-03-11T11:29:07Z")

</div>

Hi everyone, Thanks so much for a brilliant tool and community support. I'm not sure if this is a bug or by design, I understand that when parsing a CSV to produce a message per line the CSV node will add msg.parts to …

---

## [How implement switch in ui\_table?](https://discourse.nodered.org/t/how-implement-switch-in-ui-table/42467)

<div class="topic-metadata">

**Author:** [@multixz](https://discourse.nodered.org/u/multixz)\
**Replies:** 5\
**Last updated:** [11 March 2021 12:21 UTC](https://discourse.nodered.org/t/how-implement-switch-in-ui-table/42467 "2021-03-11T12:21:44Z")

</div>

Is it possible to implement a switch in ui\_table?

---

## [Alarm over email](https://discourse.nodered.org/t/alarm-over-email/42471)

<div class="topic-metadata">

**Author:** [@Madhumati](https://discourse.nodered.org/u/Madhumati)\
**Replies:** 2\
**Last updated:** [11 March 2021 12:07 UTC](https://discourse.nodered.org/t/alarm-over-email/42471 "2021-03-11T12:07:48Z")

</div>

Hello, we are trying to generate alarms in case distnace sensor shows out of range value & then alarm message to be sent to client over email. attached is our flow. In this case , alarm gets generated & email is also…

---

## [Problem with Jsonata function $toMillis](https://discourse.nodered.org/t/problem-with-jsonata-function-tomillis/42453)

<div class="topic-metadata">

**Author:** [@Xenokrates](https://discourse.nodered.org/u/Xenokrates)\
**Replies:** 9\
**Last updated:** [11 March 2021 11:37 UTC](https://discourse.nodered.org/t/problem-with-jsonata-function-tomillis/42453 "2021-03-11T11:37:39Z")

</div>

I see a strange error thrown by the JSONATA $toMillis() function, when I try to process a payload from the feedparser node. The 'article.date' field from the feedparser node seems to yield a perfect DateTime string. Wh…

---

## [How best to create node-red docker applications having flow credentials?](https://discourse.nodered.org/t/how-best-to-create-node-red-docker-applications-having-flow-credentials/19312)

<div class="topic-metadata">

**Author:** [@janvda](https://discourse.nodered.org/u/janvda)\
**Replies:** 8\
**Last updated:** [11 March 2021 11:21 UTC](https://discourse.nodered.org/t/how-best-to-create-node-red-docker-applications-having-flow-credentials/19312 "2021-03-11T11:21:48Z")

</div>

I would like to build a docker application that exists of a node-red application using nodes having credentials (which are stored in the flows\_cred.json). I am especially struggling with the credentials aspect. I woul…

---

## [Extract data from each element of an array (for train departures board)](https://discourse.nodered.org/t/extract-data-from-each-element-of-an-array-for-train-departures-board/41895)

<div class="topic-metadata">

**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Replies:** 2\
**Last updated:** [11 March 2021 09:56 UTC](https://discourse.nodered.org/t/extract-data-from-each-element-of-an-array-for-train-departures-board/41895 "2021-03-11T09:56:11Z")

</div>

Using the realtimetrains.co.uk API I can get a JSON formatted list of the next 50 (or less) trains to stop at / pass my local station. So msg.payload.services is an array containing various fields of interest, eg msg.p…

---

## [Chart plotting live data hangs due to browser high cpu/gpu usage](https://discourse.nodered.org/t/chart-plotting-live-data-hangs-due-to-browser-high-cpu-gpu-usage/41770)

<div class="topic-metadata">

**Author:** [@palaing](https://discourse.nodered.org/u/palaing)\
**Replies:** 26\
**Last updated:** [11 March 2021 09:49 UTC](https://discourse.nodered.org/t/chart-plotting-live-data-hangs-due-to-browser-high-cpu-gpu-usage/41770 "2021-03-11T09:49:26Z")

</div>

I've been working on a visualization project for a hydronic heating system and ran into a few glitches with charts. I'm posting temperature data via an MQTT broker, to a 3 line chart, with updates every 5 seconds. The ch…

---

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

<div class="topic-metadata">

**Author:** [@carmar19](https://discourse.nodered.org/u/carmar19)\
**Replies:** 4\
**Last updated:** [11 March 2021 09:15 UTC](https://discourse.nodered.org/t/node-red-mysql/42437 "2021-03-11T09:15:30Z")

</div>

Good afternoon with everyone visiting here I have a query I have generated a code watching some tutorials on node red and mysql, communication has already been established and the data is inserted all right until there, …

---

## [CRON+ Question: Turn lamp on at fixed time unless sunrise has happened](https://discourse.nodered.org/t/cron-question-turn-lamp-on-at-fixed-time-unless-sunrise-has-happened/42456)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 1\
**Last updated:** [11 March 2021 09:07 UTC](https://discourse.nodered.org/t/cron-question-turn-lamp-on-at-fixed-time-unless-sunrise-has-happened/42456 "2021-03-11T09:07:40Z")

</div>

Hi all, quick question for the brains in the forum :grin: I have a lamp that I want to turn on at a fixed time in the morning but ONLY if sunrise has not already happened. The lamp is turned off based on sunrise so obvi…

---

## [How to ensure gpio is low after deployment or nodered start](https://discourse.nodered.org/t/how-to-ensure-gpio-is-low-after-deployment-or-nodered-start/42420)

<div class="topic-metadata">

**Author:** [@riker65](https://discourse.nodered.org/u/riker65)\
**Replies:** 2\
**Last updated:** [11 March 2021 07:34 UTC](https://discourse.nodered.org/t/how-to-ensure-gpio-is-low-after-deployment-or-nodered-start/42420 "2021-03-11T07:34:47Z")

</div>

Hi I have an injection - timestamp to set GPIO to low but it is always high after a deployment or restart i did read: but did not "understande" the solution https://discourse.nodered.org/t/rpi-gpio-in-node-always-inc…

---

## [Bacnet node help](https://discourse.nodered.org/t/bacnet-node-help/38480)

<div class="topic-metadata">

**Author:** [@steven\_191](https://discourse.nodered.org/u/steven_191)\
**Replies:** 8\
**Last updated:** [11 March 2021 06:34 UTC](https://discourse.nodered.org/t/bacnet-node-help/38480 "2021-03-11T06:34:26Z")

</div>

regarding this node Im trying to set up a device that will send some values to bacnet points in a remote device. I know enough about bacnet, but cant really get my head around setting it up with this node in node red…

---

## [\[n00b Javascript\] creating an object from multiple objects using a custom function with for loop](https://discourse.nodered.org/t/n00b-javascript-creating-an-object-from-multiple-objects-using-a-custom-function-with-for-loop/42223)

<div class="topic-metadata">

**Author:** [@vongomben](https://discourse.nodered.org/u/vongomben)\
**Replies:** 13\
**Last updated:** [11 March 2021 05:03 UTC](https://discourse.nodered.org/t/n00b-javascript-creating-an-object-from-multiple-objects-using-a-custom-function-with-for-loop/42223 "2021-03-11T05:03:06Z")

</div>

Hi! I have a dataset in a excel sheet. I know how to iterate in it, every 8 cells. I need a function that would create an object from each row. I am not able in writign that function. payload\[8\].t would become pay…

---

## [What is wrong with the temperature?](https://discourse.nodered.org/t/what-is-wrong-with-the-temperature/42428)

<div class="topic-metadata">

**Author:** [@kamcio](https://discourse.nodered.org/u/kamcio)\
**Replies:** 7\
**Last updated:** [11 March 2021 04:19 UTC](https://discourse.nodered.org/t/what-is-wrong-with-the-temperature/42428 "2021-03-11T04:19:26Z")

</div>

Hello together, I don't know what I'm doing wrong with the temperature. Although we have 10.4 degrees today, all shutters fell down (see photo). Could someone help me how to configure everything to work properly? \[…

---

## [MySQL Data Logging Issue](https://discourse.nodered.org/t/mysql-data-logging-issue/42294)

<div class="topic-metadata">

**Author:** [@reachrao01](https://discourse.nodered.org/u/reachrao01)\
**Replies:** 26\
**Last updated:** [11 March 2021 03:28 UTC](https://discourse.nodered.org/t/mysql-data-logging-issue/42294 "2021-03-11T03:28:28Z")

</div>

Dear All, We are trying to insert some data to MySQL - Table but data not adding. Any issue with the following configuration since data logging is not happening. Table showing no records.

---

## [Http get with header problem](https://discourse.nodered.org/t/http-get-with-header-problem/42440)

<div class="topic-metadata">

**Author:** [@umtksa](https://discourse.nodered.org/u/umtksa)\
**Replies:** 1\
**Last updated:** [11 March 2021 03:09 UTC](https://discourse.nodered.org/t/http-get-with-header-problem/42440 "2021-03-11T03:09:43Z")

</div>

Hi all I'm getting data from an api with a bearer token. when I enter bearer token to http node I can connect to server and get my api data when ever token expires I copy the new one and paste it to http node and deplo…

---

## [String to number problem](https://discourse.nodered.org/t/string-to-number-problem/42439)

<div class="topic-metadata">

**Author:** [@Rufus](https://discourse.nodered.org/u/Rufus)\
**Replies:** 3\
**Last updated:** [11 March 2021 01:07 UTC](https://discourse.nodered.org/t/string-to-number-problem/42439 "2021-03-11T01:07:11Z")

</div>

Hello I am scarping data from a web and I need to change from string to number. If I try to use this: msg.payload = Number(msg.payload); return msg It doesn´t work for me as in Spain we use "," as "." The fisrt debu…

---

## [Light control, need help with long button press](https://discourse.nodered.org/t/light-control-need-help-with-long-button-press/42434)

<div class="topic-metadata">

**Author:** [@iamhermes](https://discourse.nodered.org/u/iamhermes)\
**Replies:** 0\
**Last updated:** [10 March 2021 22:08 UTC](https://discourse.nodered.org/t/light-control-need-help-with-long-button-press/42434 "2021-03-10T22:08:10Z")

</div>

i need help to realize a long press function for the following flow For now, a key press switches the relais on or off and defines a flow var for timeout (automatic off) Next step is to add an additional "on" time to t…

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

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