# General

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

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

**Page:** 311

---

## [Voice Assistant](https://discourse.nodered.org/t/voice-assistant/68820)

<div class="topic-metadata">

**Author:** [@Sineos](https://discourse.nodered.org/u/Sineos)\
**Replies:** 9\
**Last updated:** [13 October 2022 13:55 UTC](https://discourse.nodered.org/t/voice-assistant/68820 "2022-10-13T13:55:56Z")

</div>

I'm currently digging into the topic of a self-hosted Voice Assistant to complement our existing Node-Red Smart Home automation. The more I read about the topic, the less I really know where to start. I have an existin…

---

## [Can users be set for authentication without passwords in the \`users\` array?](https://discourse.nodered.org/t/can-users-be-set-for-authentication-without-passwords-in-the-users-array/68982)

<div class="topic-metadata">

**Author:** [@Shan](https://discourse.nodered.org/u/Shan)\
**Replies:** 6\
**Last updated:** [13 October 2022 13:17 UTC](https://discourse.nodered.org/t/can-users-be-set-for-authentication-without-passwords-in-the-users-array/68982 "2022-10-13T13:17:47Z")

</div>

According to certain examples in the Securing Node-RED : Node-RED guide there are mentions of users within the users array that do not seem to have a password. Is this a typo or does the Auth Engine allow users with only…

---

## [Newbie need Help with an export to Excel](https://discourse.nodered.org/t/newbie-need-help-with-an-export-to-excel/68987)

<div class="topic-metadata">

**Author:** [@makro01](https://discourse.nodered.org/u/makro01)\
**Replies:** 0\
**Last updated:** [13 October 2022 13:19 UTC](https://discourse.nodered.org/t/newbie-need-help-with-an-export-to-excel/68987 "2022-10-13T13:19:11Z")

</div>

Hello, I'm brand new to Node-Red. I got most things from my themp and voltet measurements. Now I want to start a new project. I send a request to my car and I want to automatically write it to an Excel spreadsheet at t…

---

## [Can I use RPI camera for scanning barcodes on node-RED?](https://discourse.nodered.org/t/can-i-use-rpi-camera-for-scanning-barcodes-on-node-red/68792)

<div class="topic-metadata">

**Author:** [@fkristofb](https://discourse.nodered.org/u/fkristofb)\
**Replies:** 12\
**Last updated:** [13 October 2022 12:46 UTC](https://discourse.nodered.org/t/can-i-use-rpi-camera-for-scanning-barcodes-on-node-red/68792 "2022-10-13T12:46:41Z")

</div>

Hi! I am looking for a way to scan barcodes using RPI camera with minimal to none Python coding. Please note that I am not looking for QR but barcode scanning. Could anyone help? If so, and would be willing to, please…

---

## [Syntax issues with SQL](https://discourse.nodered.org/t/syntax-issues-with-sql/68978)

<div class="topic-metadata">

**Author:** [@milner236](https://discourse.nodered.org/u/milner236)\
**Replies:** 3\
**Last updated:** [13 October 2022 12:31 UTC](https://discourse.nodered.org/t/syntax-issues-with-sql/68978 "2022-10-13T12:31:28Z")

</div>

Hey everyone, I've been trying to figure out how to deal with this syntax issue i'm having. I'm using a template node to design my query and then pass it to an mssqlplus node. This is the query (in the template node) …

---

## [Modbus TCP node regarding points](https://discourse.nodered.org/t/modbus-tcp-node-regarding-points/68964)

<div class="topic-metadata">

**Author:** [@DSongra11\_forum.com](https://discourse.nodered.org/u/DSongra11_forum.com)\
**Replies:** 8\
**Last updated:** [13 October 2022 11:09 UTC](https://discourse.nodered.org/t/modbus-tcp-node-regarding-points/68964 "2022-10-13T11:09:18Z")

</div>

Hello, I have few queries as below. How many numbers of Modbus TCP slave devices we can connect to Modbus TCP Client node? How much data size/parameters can we read/write in Modbus TCP node? Can we configure multiple …

---

## [How can I compare a value to a result from another node?](https://discourse.nodered.org/t/how-can-i-compare-a-value-to-a-result-from-another-node/68839)

<div class="topic-metadata">

**Author:** [@Mastiff](https://discourse.nodered.org/u/Mastiff)\
**Replies:** 13\
**Last updated:** [13 October 2022 10:40 UTC](https://discourse.nodered.org/t/how-can-i-compare-a-value-to-a-result-from-another-node/68839 "2022-10-13T10:40:26Z")

</div>

I don't know if the heading is the correct terminology, but what I want to do is this: Every 20 minutes my core system (a combination of Girder and Event Ghost) sends a command to the Sensibo pod with the Sensibo node, …

---

## [NR Conundrum sett flow context changes global context](https://discourse.nodered.org/t/nr-conundrum-sett-flow-context-changes-global-context/68955)

<div class="topic-metadata">

**Author:** [@Sandmman](https://discourse.nodered.org/u/Sandmman)\
**Replies:** 2\
**Last updated:** [13 October 2022 10:34 UTC](https://discourse.nodered.org/t/nr-conundrum-sett-flow-context-changes-global-context/68955 "2022-10-13T10:34:13Z")

</div>

I'm trying to understand how it could be that after reading global context into a flow context, checking for the existence of a value ("on") in the flow context in order to determine what groups I need to serve, that act…

---

## [Reset an array in a function node](https://discourse.nodered.org/t/reset-an-array-in-a-function-node/68952)

<div class="topic-metadata">

**Author:** [@PowerZone21](https://discourse.nodered.org/u/PowerZone21)\
**Replies:** 10\
**Last updated:** [13 October 2022 10:11 UTC](https://discourse.nodered.org/t/reset-an-array-in-a-function-node/68952 "2022-10-13T10:11:29Z")

</div>

Hi, I found this code on this forum var myArray = context.get("myArray"); if (!myArray) { console.log("Set the array on context memory"); context.set("myArray", \[\]); myArray = context.get("myArray"); } my…

---

## [How to make dimmer light](https://discourse.nodered.org/t/how-to-make-dimmer-light/68960)

<div class="topic-metadata">

**Author:** [@daniel2g](https://discourse.nodered.org/u/daniel2g)\
**Replies:** 1\
**Last updated:** [13 October 2022 09:43 UTC](https://discourse.nodered.org/t/how-to-make-dimmer-light/68960 "2022-10-13T09:43:19Z")

</div>

I already connect the node red to the ESP32 to send the signal to the arduino and to the light bulb. My problem is that I send the brightness which is from 255 until 0, and the serial monitor from the arduino received ra…

---

## [Influxdb showing arbitrary timestamps](https://discourse.nodered.org/t/influxdb-showing-arbitrary-timestamps/68897)

<div class="topic-metadata">

**Author:** [@Pera](https://discourse.nodered.org/u/Pera)\
**Replies:** 13\
**Last updated:** [13 October 2022 08:26 UTC](https://discourse.nodered.org/t/influxdb-showing-arbitrary-timestamps/68897 "2022-10-13T08:26:56Z")

</div>

Hi folks, I've been programming a simple flow for regularly storing temperature forecasts to Influxdb. The flow is basically as follows: 1. Get the forecast temperature for the next 24+ hours with an hourly timestamp fr…

---

## [Non addressable RGB / RGBW strip LED Raspberry Pi Node RED](https://discourse.nodered.org/t/non-addressable-rgb-rgbw-strip-led-raspberry-pi-node-red/68966)

<div class="topic-metadata">

**Author:** [@aquapark\_lodz](https://discourse.nodered.org/u/aquapark_lodz)\
**Replies:** 0\
**Last updated:** [13 October 2022 08:09 UTC](https://discourse.nodered.org/t/non-addressable-rgb-rgbw-strip-led-raspberry-pi-node-red/68966 "2022-10-13T08:09:10Z")

</div>

Hi, I would like to ask about connection non addressable RGB / RGBW strip LED or for example GOQ Samsung module RGB / RGBW to Raspberry Pi and make light show / sequence in Node RED. There are many tutorials where I can…

---

## [MySQL - Too many connections](https://discourse.nodered.org/t/mysql-too-many-connections/68943)

<div class="topic-metadata">

**Author:** [@Prathamesh\_Gharat](https://discourse.nodered.org/u/Prathamesh_Gharat)\
**Replies:** 6\
**Last updated:** [13 October 2022 07:31 UTC](https://discourse.nodered.org/t/mysql-too-many-connections/68943 "2022-10-13T07:31:18Z")

</div>

Hi, I am observing an odd thing that I wanted to highlight. I'll briefly highlight my setup. I have multiple flows that use the MYSQL node as follows (in similar ways). Cron Plus Timer (30m interval) --\> HTTP Request …

---

## [Jsonata help once again please guys](https://discourse.nodered.org/t/jsonata-help-once-again-please-guys/68835)

<div class="topic-metadata">

**Author:** [@craigcurtin](https://discourse.nodered.org/u/craigcurtin)\
**Replies:** 10\
**Last updated:** [13 October 2022 07:34 UTC](https://discourse.nodered.org/t/jsonata-help-once-again-please-guys/68835 "2022-10-13T07:34:09Z")

</div>

Guys, Trying to do what i thought would be some basic maths with Jsonata here In a msg stream i get passed from my inverters Battery Voltage and Battery Amps - this allows me to work out the charging rate for each inve…

---

## [Need help about Securing Node-RED on Docker](https://discourse.nodered.org/t/need-help-about-securing-node-red-on-docker/68837)

<div class="topic-metadata">

**Author:** [@yingkhun](https://discourse.nodered.org/u/yingkhun)\
**Replies:** 2\
**Last updated:** [13 October 2022 07:14 UTC](https://discourse.nodered.org/t/need-help-about-securing-node-red-on-docker/68837 "2022-10-13T07:14:12Z")

</div>

Hi, I just installed node-red on docker and need to use username and password to login before go to node-red page install sudo docker run -d --restart=always -p 1880:1880 -v node\_red\_data:/data --name node-red nodered/…

---

## [Splitting a Serial string in to individual packets](https://discourse.nodered.org/t/splitting-a-serial-string-in-to-individual-packets/68890)

<div class="topic-metadata">

**Author:** [@DAWaller79](https://discourse.nodered.org/u/DAWaller79)\
**Replies:** 18\
**Last updated:** [13 October 2022 02:27 UTC](https://discourse.nodered.org/t/splitting-a-serial-string-in-to-individual-packets/68890 "2022-10-13T02:27:54Z")

</div>

Good evening Hoping someone can point me in the right direction, I need to remove individual packets (so i can further extract the info i need) from a long serial string of several packets, that also seem to change orde…

---

## [OpenWeatherMap problem](https://discourse.nodered.org/t/openweathermap-problem/68941)

<div class="topic-metadata">

**Author:** [@TadyTheFish](https://discourse.nodered.org/u/TadyTheFish)\
**Replies:** 3\
**Last updated:** [12 October 2022 21:58 UTC](https://discourse.nodered.org/t/openweathermap-problem/68941 "2022-10-12T21:58:13Z")

</div>

Hello I'm trying to use the openweathemap node. I registered on the site and I have the API key But when I deploy there is an error and the API key disappears. When I go to manage palette and navigate to installed node…

---

## [Increment slowly until certain point](https://discourse.nodered.org/t/increment-slowly-until-certain-point/68938)

<div class="topic-metadata">

**Author:** [@ujjwalkuikel](https://discourse.nodered.org/u/ujjwalkuikel)\
**Replies:** 2\
**Last updated:** [12 October 2022 16:14 UTC](https://discourse.nodered.org/t/increment-slowly-until-certain-point/68938 "2022-10-12T16:14:17Z")

</div>

Hi, Sorry for asking a silly question. But I am a super beginner at node-red and trying my best to learn something. I want to have a function that slowly increases the value to 100 (I want that value to pass to IOT devi…

---

## [Import Template in another Template](https://discourse.nodered.org/t/import-template-in-another-template/68929)

<div class="topic-metadata">

**Author:** [@NIFO43](https://discourse.nodered.org/u/NIFO43)\
**Replies:** 1\
**Last updated:** [12 October 2022 15:31 UTC](https://discourse.nodered.org/t/import-template-in-another-template/68929 "2022-10-12T15:31:43Z")

</div>

Hey, is it possible to include an template in another template.

---

## [Push button to steering a few GPIO in sequence](https://discourse.nodered.org/t/push-button-to-steering-a-few-gpio-in-sequence/68932)

<div class="topic-metadata">

**Author:** [@aquapark\_lodz](https://discourse.nodered.org/u/aquapark_lodz)\
**Replies:** 4\
**Last updated:** [12 October 2022 15:11 UTC](https://discourse.nodered.org/t/push-button-to-steering-a-few-gpio-in-sequence/68932 "2022-10-12T15:11:57Z")

</div>

Hi, I would like to know is it possible to steer a few GPIO in a sequence by push button. I made that but if I push the same button when the sequence is running I can again start the sequence. I want to achieve that to p…

---

## [Unable to install @tensorflow/tfjs-node](https://discourse.nodered.org/t/unable-to-install-tensorflow-tfjs-node/68120)

<div class="topic-metadata">

**Author:** [@Creamsoda](https://discourse.nodered.org/u/Creamsoda)\
**Replies:** 4\
**Last updated:** [12 October 2022 07:48 UTC](https://discourse.nodered.org/t/unable-to-install-tensorflow-tfjs-node/68120 "2022-10-12T07:48:49Z")

</div>

Hi, I am a beginner to node-red. I have been trying to install the @tensorflow/tfjs-node to node-red. In Winodws cmd and node-red on IBM cloud. Here is the cmd result: C:\\\<\<path\>\>\\.node-red\>npm install @tensorflow/tfjs…

---

## [Converting msg.payload array into an object to access its value](https://discourse.nodered.org/t/converting-msg-payload-array-into-an-object-to-access-its-value/68905)

<div class="topic-metadata">

**Author:** [@Vedant](https://discourse.nodered.org/u/Vedant)\
**Replies:** 3\
**Last updated:** [12 October 2022 07:42 UTC](https://discourse.nodered.org/t/converting-msg-payload-array-into-an-object-to-access-its-value/68905 "2022-10-12T07:42:36Z")

</div>

Hello everyone! Greetings of the day! I am currently stuck on a pronlem and need your expert opinion regarding the same. I want to convert a msg.payload which is an array into an object as I want to access a value from…

---

## [Node-red-node-pi-mcp3008 displays "inactive" in flow](https://discourse.nodered.org/t/node-red-node-pi-mcp3008-displays-inactive-in-flow/68908)

<div class="topic-metadata">

**Author:** [@leeg77](https://discourse.nodered.org/u/leeg77)\
**Replies:** 0\
**Last updated:** [12 October 2022 06:59 UTC](https://discourse.nodered.org/t/node-red-node-pi-mcp3008-displays-inactive-in-flow/68908 "2022-10-12T06:59:35Z")

</div>

I have added a node node-red-node-pi-mcp3008 to my palette but when I try to use it I get the node-inactive under the node. Any ideas? I have turned on the SPI bus via raspi-config

---

## [Read data from SPI bus RasPi](https://discourse.nodered.org/t/read-data-from-spi-bus-raspi/68802)

<div class="topic-metadata">

**Author:** [@leeg77](https://discourse.nodered.org/u/leeg77)\
**Replies:** 1\
**Last updated:** [12 October 2022 06:51 UTC](https://discourse.nodered.org/t/read-data-from-spi-bus-raspi/68802 "2022-10-12T06:51:35Z")

</div>

Hello, I have a MIKROE-2523 AC Current Click connected to a current clamp that I want to read on the Raspberry Pi SPI bus. Does anyone know how I can achieve this? Here is a link to the current click webpage: https://…

---

## [Serial permission denied /dev/ttyUSB0](https://discourse.nodered.org/t/serial-permission-denied-dev-ttyusb0/68889)

<div class="topic-metadata">

**Author:** [@sudomac](https://discourse.nodered.org/u/sudomac)\
**Replies:** 5\
**Last updated:** [12 October 2022 06:48 UTC](https://discourse.nodered.org/t/serial-permission-denied-dev-ttyusb0/68889 "2022-10-12T06:48:41Z")

</div>

node-red-node-serialport error "\[serialconfig:e2b92f3a20e71366\] serial port /dev/ttyUSB0 error: Error: Error: Permission denied, cannot open /dev/ttyUSB0" I am using Ubuntu. I looked through previous threads about this…

---

## [Inject node activated each time system boots](https://discourse.nodered.org/t/inject-node-activated-each-time-system-boots/68892)

<div class="topic-metadata">

**Author:** [@Lostcat67](https://discourse.nodered.org/u/Lostcat67)\
**Replies:** 1\
**Last updated:** [12 October 2022 02:32 UTC](https://discourse.nodered.org/t/inject-node-activated-each-time-system-boots/68892 "2022-10-12T02:32:59Z")

</div>

How can I make a inject node to "inject" something each time the system is booted up?

---

## ["node-red-contrib-play-sound" fails in node-red on miniPC started from systemd service](https://discourse.nodered.org/t/node-red-contrib-play-sound-fails-in-node-red-on-minipc-started-from-systemd-service/68624)

<div class="topic-metadata">

**Author:** [@fip](https://discourse.nodered.org/u/fip)\
**Replies:** 20\
**Last updated:** [12 October 2022 00:49 UTC](https://discourse.nodered.org/t/node-red-contrib-play-sound-fails-in-node-red-on-minipc-started-from-systemd-service/68624 "2022-10-12T00:49:39Z")

</div>

hi @zenofmud , This is cool isn't it. I my self built also something like this. I was using a miniPC. I used mplayer to play mp3 files from nodered ui. But I have still an unsolved problem regarding the setup. I have v…

---

## [Less than does not work but greater than works. Any assistance will be appreciated](https://discourse.nodered.org/t/less-than-does-not-work-but-greater-than-works-any-assistance-will-be-appreciated/68731)

<div class="topic-metadata">

**Author:** [@Andries](https://discourse.nodered.org/u/Andries)\
**Replies:** 8\
**Last updated:** [11 October 2022 20:24 UTC](https://discourse.nodered.org/t/less-than-does-not-work-but-greater-than-works-any-assistance-will-be-appreciated/68731 "2022-10-11T20:24:22Z")

</div>

\[ { "id": "e23c99f9e5c74834", "type": "function", "z": "c3e2344d2de8acfd", "name": "if Fan Machine", "func": "node.status({fill:\\"blue\\",shape:\\"dot\\",text:msg.payload});\\n\\n …

---

## [Need an if operation, don't know how to do](https://discourse.nodered.org/t/need-an-if-operation-dont-know-how-to-do/68887)

<div class="topic-metadata">

**Author:** [@igmam](https://discourse.nodered.org/u/igmam)\
**Replies:** 5\
**Last updated:** [11 October 2022 18:28 UTC](https://discourse.nodered.org/t/need-an-if-operation-dont-know-how-to-do/68887 "2022-10-11T18:28:31Z")

</div>

Hi there, I'm doing a geolocation lookup via Google API. I get the MAC Addresses proper, but i need a function wich will lookup if the address has 12 characters, if not, i need a "0" in front of my string. Sorry for t…

---

## [How to insert multiple ":" in a string](https://discourse.nodered.org/t/how-to-insert-multiple-in-a-string/68867)

<div class="topic-metadata">

**Author:** [@igmam](https://discourse.nodered.org/u/igmam)\
**Replies:** 2\
**Last updated:** [11 October 2022 15:38 UTC](https://discourse.nodered.org/t/how-to-insert-multiple-in-a-string/68867 "2022-10-11T15:38:39Z")

</div>

Hi there, I'm getting a MAC Address without ":" character betweend the characters. example: 001122334455 But want to get this version 00:11:22:33:44:55 How to do this in a efficient way? Thank you!

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

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