# General

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

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

**Page:** 113

---

## [Stuck! at Send multiple sensor data to a PSQL](https://discourse.nodered.org/t/stuck-at-send-multiple-sensor-data-to-a-psql/87338)

<div class="topic-metadata">

**Author:** [@RND\_NIM](https://discourse.nodered.org/u/RND_NIM)\
**Replies:** 6\
**Last updated:** [3 May 2024 08:17 UTC](https://discourse.nodered.org/t/stuck-at-send-multiple-sensor-data-to-a-psql/87338 "2024-05-03T08:17:49Z")

</div>

I am new to database and node-red. Here is my setup. Raspberry Pi 4 Raspbian OS Node-Red Pi plates - (THERMOplate) K-Type sensors Database - PSQL I have created a flow with one sensor output and it works and no errors…

---

## [Reading a device](https://discourse.nodered.org/t/reading-a-device/87633)

<div class="topic-metadata">

**Author:** [@jmgimo75](https://discourse.nodered.org/u/jmgimo75)\
**Replies:** 3\
**Last updated:** [2 May 2024 18:00 UTC](https://discourse.nodered.org/t/reading-a-device/87633 "2024-05-02T18:00:41Z")

</div>

Before, on a device it read as follows: {"dps":24,"set":"000000000000"} text {"data":{"dps":{"1":false},"t":1714599444},"deviceId": "bfb66a17fd95982996kw4n"," deviceName":""Input Light"} Now after changing the device f…

---

## [Send data to MYSQL](https://discourse.nodered.org/t/send-data-to-mysql/87606)

<div class="topic-metadata">

**Author:** [@younesDV](https://discourse.nodered.org/u/younesDV)\
**Replies:** 17\
**Last updated:** [2 May 2024 17:35 UTC](https://discourse.nodered.org/t/send-data-to-mysql/87606 "2024-05-02T17:35:45Z")

</div>

Hello I'm trying to send data to a database in MySQL, My Problem is that I can't insert data in the same time, the first type of data is a string and the second is a float. here's my nodes : the first function : a…

---

## [MQTT Subscription lost](https://discourse.nodered.org/t/mqtt-subscription-lost/87630)

<div class="topic-metadata">

**Author:** [@c2promax](https://discourse.nodered.org/u/c2promax)\
**Replies:** 3\
**Last updated:** [2 May 2024 14:05 UTC](https://discourse.nodered.org/t/mqtt-subscription-lost/87630 "2024-05-02T14:05:01Z")

</div>

Hello, Has anyone seen this issue before? I have 128 Axis D4100-e strobe/sirens that are using MQTT to turn on and off during a school lockdown procedure. They work great when the subscription is entered. But, what seem…

---

## [Saving only csv email attachments](https://discourse.nodered.org/t/saving-only-csv-email-attachments/87650)

<div class="topic-metadata">

**Author:** [@E-J-D](https://discourse.nodered.org/u/E-J-D)\
**Replies:** 6\
**Last updated:** [2 May 2024 13:36 UTC](https://discourse.nodered.org/t/saving-only-csv-email-attachments/87650 "2024-05-02T13:36:38Z")

</div>

Hi, I also fetch mails with Node-RED and try to save the "CSV" attachments included. I would appreciate if @stephan1827, @Fed or any other here would share a flow where this is realised. Thanks in advance. Unfortunatel…

---

## [Save Email Attachment with node-red-node-email](https://discourse.nodered.org/t/save-email-attachment-with-node-red-node-email/7926)

<div class="topic-metadata">

**Author:** [@northhacks](https://discourse.nodered.org/u/northhacks)\
**Replies:** 11\
**Last updated:** [28 April 2020 16:33 UTC](https://discourse.nodered.org/t/save-email-attachment-with-node-red-node-email/7926 "2020-04-28T16:33:35Z")

</div>

Hello everybody, can someone help me save my E-mail Attachment with node-red-node-email to process the files further? I'm new with Node Red. Thanks

---

## [Trying to save an .xlsx file attached to an email into a local directory](https://discourse.nodered.org/t/trying-to-save-an-xlsx-file-attached-to-an-email-into-a-local-directory/17057)

<div class="topic-metadata">

**Author:** [@gv\_gv](https://discourse.nodered.org/u/gv_gv)\
**Replies:** 4\
**Last updated:** [2 May 2024 08:41 UTC](https://discourse.nodered.org/t/trying-to-save-an-xlsx-file-attached-to-an-email-into-a-local-directory/17057 "2024-05-02T08:41:18Z")

</div>

Hello Guys, I am trying to fetch an email attachment which is a .xlsx file. I moved the arraybuffer of the attachment content to msg.payload and used file node to try to save it as test.xlsx. But the saved .xlsx file …

---

## [How to develop project with thousand rows of code](https://discourse.nodered.org/t/how-to-develop-project-with-thousand-rows-of-code/87635)

<div class="topic-metadata">

**Author:** [@Alexander\_xD](https://discourse.nodered.org/u/Alexander_xD)\
**Replies:** 1\
**Last updated:** [2 May 2024 07:21 UTC](https://discourse.nodered.org/t/how-to-develop-project-with-thousand-rows-of-code/87635 "2024-05-02T07:21:30Z")

</div>

I need to any suggestion, how to develop a project with thousand rows. Create many files and edit code from console or a any IDE. My project use this technique: Load core object as global param const \_Notify = class …

---

## [How to use "Watch" only for .txt and .xml](https://discourse.nodered.org/t/how-to-use-watch-only-for-txt-and-xml/87639)

<div class="topic-metadata">

**Author:** [@Perkele](https://discourse.nodered.org/u/Perkele)\
**Replies:** 2\
**Last updated:** [2 May 2024 07:59 UTC](https://discourse.nodered.org/t/how-to-use-watch-only-for-txt-and-xml/87639 "2024-05-02T07:59:07Z")

</div>

Hello everyone, I use the “Watch” command to monitor a directory including its subdirectories. As soon as it reads data from the subdirectories I get the error message. "Error: EISDIR: illegal operation on a directory,…

---

## [Can Node-red force browser to reload the editor?](https://discourse.nodered.org/t/can-node-red-force-browser-to-reload-the-editor/87621)

<div class="topic-metadata">

**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Replies:** 5\
**Last updated:** [1 May 2024 21:09 UTC](https://discourse.nodered.org/t/can-node-red-force-browser-to-reload-the-editor/87621 "2024-05-01T21:09:15Z")

</div>

On the Raspberry Pi you can turn on the read-only overlay filesystem by editing /boot/firmware/cmdline.txt and rebooting, easy enough with exec nodes. I show the readonly status of the Pi in the editor header, eg or …

---

## [NodeRed stürzt unter Windows alle paar stunden ab](https://discourse.nodered.org/t/nodered-sturzt-unter-windows-alle-paar-stunden-ab/87626)

<div class="topic-metadata">

**Author:** [@fpfeifer](https://discourse.nodered.org/u/fpfeifer)\
**Replies:** 5\
**Last updated:** [1 May 2024 20:16 UTC](https://discourse.nodered.org/t/nodered-sturzt-unter-windows-alle-paar-stunden-ab/87626 "2024-05-01T20:16:19Z")

</div>

Moin zusammen, Ich habe bei mir auf einer Windows 10 VM NodeRed im Terminal laufen. Seit ein paar Tagen stürzt entweder die Konsole ab oder hängt sich auf und ist nicht mehr erreichbar. Dann habe ich mal NodeJS und Node…

---

## [How to form a new number with two bytes?](https://discourse.nodered.org/t/how-to-form-a-new-number-with-two-bytes/9259)

<div class="topic-metadata">

**Author:** [@qpongoaka](https://discourse.nodered.org/u/qpongoaka)\
**Replies:** 10\
**Last updated:** [1 May 2024 16:00 UTC](https://discourse.nodered.org/t/how-to-form-a-new-number-with-two-bytes/9259 "2024-05-01T16:00:42Z")

</div>

Hello everyone. I am facing the following problem: In MQTT, i'm suscribe to a topic and i'm constantly receiving a frame consisting in three bytes like so: (SoF) ( byte1) (byte2). Where (SoF) represents the start of …

---

## [(HTTP IN) in local node-red](https://discourse.nodered.org/t/http-in-in-local-node-red/87628)

<div class="topic-metadata">

**Author:** [@MaxTryhub](https://discourse.nodered.org/u/MaxTryhub)\
**Replies:** 1\
**Last updated:** [1 May 2024 16:29 UTC](https://discourse.nodered.org/t/http-in-in-local-node-red/87628 "2024-05-01T16:29:18Z")

</div>

I'm facing a problem with incoming http requests to local node-red, I'm trying to send a request from the Server, or postman, it writes about a timeout and returns the error "no response from the server", I would be grat…

---

## [Why does concat give back empty value?](https://discourse.nodered.org/t/why-does-concat-give-back-empty-value/87617)

<div class="topic-metadata">

**Author:** [@novski](https://discourse.nodered.org/u/novski)\
**Replies:** 10\
**Last updated:** [30 April 2024 21:10 UTC](https://discourse.nodered.org/t/why-does-concat-give-back-empty-value/87617 "2024-04-30T21:10:49Z")

</div>

This .concat function does not work. let device = {"spot1":{"value": \[1,1\] }}; let k = "spot1"; let value = \[\]; node.warn("value:" + value + ", typeof value:" + typeof value); if (typeof device\[k\].value === 'number') { …

---

## [Need help with huemagic](https://discourse.nodered.org/t/need-help-with-huemagic/87596)

<div class="topic-metadata">

**Author:** [@aredhone](https://discourse.nodered.org/u/aredhone)\
**Replies:** 6\
**Last updated:** [30 April 2024 19:58 UTC](https://discourse.nodered.org/t/need-help-with-huemagic/87596 "2024-04-30T19:58:25Z")

</div>

so here i am again most posible asking you guys aa easy quistion i have trouble setting up somthing that recieves a singnal of my hue dot and do somthing with it i got \[{"id":"79f1f61985718e40","type":"debug","z":"d5d…

---

## [Error loading settings file: /data/settings.js](https://discourse.nodered.org/t/error-loading-settings-file-data-settings-js/87608)

<div class="topic-metadata">

**Author:** [@Mil05h](https://discourse.nodered.org/u/Mil05h)\
**Replies:** 7\
**Last updated:** [30 April 2024 16:02 UTC](https://discourse.nodered.org/t/error-loading-settings-file-data-settings-js/87608 "2024-04-30T16:02:26Z")

</div>

Hi, I have issues to run node-red locally using docker-compose up. My colleagues are using Mac and Linux and can run the remote repo locally. I am using Windows, and am getting this error: Attaching to nodered-1 nodered…

---

## [Why does that dynamic selector select both spotlights?](https://discourse.nodered.org/t/why-does-that-dynamic-selector-select-both-spotlights/87610)

<div class="topic-metadata">

**Author:** [@novski](https://discourse.nodered.org/u/novski)\
**Replies:** 5\
**Last updated:** [30 April 2024 12:49 UTC](https://discourse.nodered.org/t/why-does-that-dynamic-selector-select-both-spotlights/87610 "2024-04-30T12:49:42Z")

</div>

Hi I use a dynamic selector to pick my device in a flow object by name. But it changes the offset values of all devices. let init = { "offset": 0 } let spotlights = flow.get("spotlights") ?? flow.set("spotlights",…

---

## [Someone with experience with REDIS subscribing?](https://discourse.nodered.org/t/someone-with-experience-with-redis-subscribing/87561)

<div class="topic-metadata">

**Author:** [@JeromeVISUALS](https://discourse.nodered.org/u/JeromeVISUALS)\
**Replies:** 11\
**Last updated:** [30 April 2024 12:41 UTC](https://discourse.nodered.org/t/someone-with-experience-with-redis-subscribing/87561 "2024-04-30T12:41:19Z")

</div>

Hi, I have no experience with REDIS yet, but for one of my flows I need to subscribe to a REDIS . I tried this : https://flows.nodered.org/node/node-red-v4-contrib-redis And loaded the example flow, but everything I g…

---

## [Ui-template set httpstatic for dashboard 2](https://discourse.nodered.org/t/ui-template-set-httpstatic-for-dashboard-2/87591)

<div class="topic-metadata">

**Author:** [@denissanga](https://discourse.nodered.org/u/denissanga)\
**Replies:** 7\
**Last updated:** [30 April 2024 12:20 UTC](https://discourse.nodered.org/t/ui-template-set-httpstatic-for-dashboard-2/87591 "2024-04-30T12:20:35Z")

</div>

Hi all, I'm trying using dashboard2 and I would understand where locate the external javascript scripts for dashboard 1 I set httpstatic path in the setting file adding the folder where my script are located in "/static…

---

## [Ui-template: javascript to run function when a global var define in script changes](https://discourse.nodered.org/t/ui-template-javascript-to-run-function-when-a-global-var-define-in-script-changes/87578)

<div class="topic-metadata">

**Author:** [@denissanga](https://discourse.nodered.org/u/denissanga)\
**Replies:** 3\
**Last updated:** [29 April 2024 17:18 UTC](https://discourse.nodered.org/t/ui-template-javascript-to-run-function-when-a-global-var-define-in-script-changes/87578 "2024-04-29T17:18:01Z")

</div>

Hi all, I'm writing a script in ui-template and I defined a global var. I would like to add a function which is called when the global var change \<script type="text/javascript"\> var generic; function sendMessag…

---

## [In Change Node, setting output of mySQL node to Flow.Context gives "\[object Object\]"](https://discourse.nodered.org/t/in-change-node-setting-output-of-mysql-node-to-flow-context-gives-object-object/87580)

<div class="topic-metadata">

**Author:** [@IanH](https://discourse.nodered.org/u/IanH)\
**Replies:** 11\
**Last updated:** [29 April 2024 13:43 UTC](https://discourse.nodered.org/t/in-change-node-setting-output-of-mysql-node-to-flow-context-gives-object-object/87580 "2024-04-29T13:43:57Z")

</div>

I am trying to store the output of a node-red-node-mysql mysql node into a flow Context variable to aid verification and debuging (I keep missing output in debug pane as they only occur every 10 minutes or so). But all…

---

## [Updated coding window node-red editor](https://discourse.nodered.org/t/updated-coding-window-node-red-editor/87576)

<div class="topic-metadata">

**Author:** [@verkerkGIT](https://discourse.nodered.org/u/verkerkGIT)\
**Replies:** 2\
**Last updated:** [29 April 2024 08:18 UTC](https://discourse.nodered.org/t/updated-coding-window-node-red-editor/87576 "2024-04-29T08:18:38Z")

</div>

Hi, when I install node-red on a raspberry pi, or some other devices I get a neat code editor with autocomplete, code hints etc, kind of like a Visual Studio environment. However on my main machine I only have a older lo…

---

## [Use dynamic context based variable in change node for setting a variable](https://discourse.nodered.org/t/use-dynamic-context-based-variable-in-change-node-for-setting-a-variable/87519)

<div class="topic-metadata">

**Author:** [@psmtvdw](https://discourse.nodered.org/u/psmtvdw)\
**Replies:** 4\
**Last updated:** [29 April 2024 06:02 UTC](https://discourse.nodered.org/t/use-dynamic-context-based-variable-in-change-node-for-setting-a-variable/87519 "2024-04-29T06:02:44Z")

</div>

I have a subflow, inside this subflow I want to use the value of an env variable of this subflow in a change node to write a global variable This is how it looks like (and works succesfully) in a function node: global.…

---

## [Node "delay" doesn't work as expected anymore](https://discourse.nodered.org/t/node-delay-doesnt-work-as-expected-anymore/87568)

<div class="topic-metadata">

**Author:** [@cairon](https://discourse.nodered.org/u/cairon)\
**Replies:** 5\
**Last updated:** [28 April 2024 23:08 UTC](https://discourse.nodered.org/t/node-delay-doesnt-work-as-expected-anymore/87568 "2024-04-28T23:08:23Z")

</div>

Hi there, I have an automation to turn on my coffee machine. I am using a motion sensor in the kitchen for that. The idea was that the coffee machine gets power when I am entering the kitchen for the first time a day. …

---

## [Pass the name of a database table into a function?](https://discourse.nodered.org/t/pass-the-name-of-a-database-table-into-a-function/87560)

<div class="topic-metadata">

**Author:** [@questuk](https://discourse.nodered.org/u/questuk)\
**Replies:** 8\
**Last updated:** [28 April 2024 16:40 UTC](https://discourse.nodered.org/t/pass-the-name-of-a-database-table-into-a-function/87560 "2024-04-28T16:40:20Z")

</div>

Hi I am uploading data from Node-RED to my PostgreSQL database via a function. Currently i have to change the INSERT INTO table in this function, what I would like to do is pass the table into this function via msg.tab…

---

## [Getting the rain amount with OpenWeather](https://discourse.nodered.org/t/getting-the-rain-amount-with-openweather/87567)

<div class="topic-metadata">

**Author:** [@alveron](https://discourse.nodered.org/u/alveron)\
**Replies:** 2\
**Last updated:** [28 April 2024 15:35 UTC](https://discourse.nodered.org/t/getting-the-rain-amount-with-openweather/87567 "2024-04-28T15:35:09Z")

</div>

Working with the openweather API and am trying to get the precipitation forecasted in the next 24h. The forecast message gives you the expected rain in three hour chunks so using a function to sum this should do the tri…

---

## [How to use serial port control node](https://discourse.nodered.org/t/how-to-use-serial-port-control-node/87564)

<div class="topic-metadata">

**Author:** [@ALOKA1432](https://discourse.nodered.org/u/ALOKA1432)\
**Replies:** 1\
**Last updated:** [28 April 2024 14:37 UTC](https://discourse.nodered.org/t/how-to-use-serial-port-control-node/87564 "2024-04-28T14:37:05Z")

</div>

How can i use serial port control node to change the port and other parameters on the fly. Kindly help someone.

---

## [Send msg.payload from ui template to nodered](https://discourse.nodered.org/t/send-msg-payload-from-ui-template-to-nodered/87340)

<div class="topic-metadata">

**Author:** [@denissanga](https://discourse.nodered.org/u/denissanga)\
**Replies:** 16\
**Last updated:** [28 April 2024 14:16 UTC](https://discourse.nodered.org/t/send-msg-payload-from-ui-template-to-nodered/87340 "2024-04-28T14:16:53Z")

</div>

hi all, I have a ui template with some javascript function i would like return a value to node-red \<script type="text/javascript"\> function onQRCodeScanned(scannedText) { var scannedTextM…

---

## [NodeRed and Alexa for dialogues](https://discourse.nodered.org/t/nodered-and-alexa-for-dialogues/87363)

<div class="topic-metadata">

**Author:** [@Gnomi](https://discourse.nodered.org/u/Gnomi)\
**Replies:** 9\
**Last updated:** [28 April 2024 12:48 UTC](https://discourse.nodered.org/t/nodered-and-alexa-for-dialogues/87363 "2024-04-28T12:48:01Z")

</div>

Hi, I am using node-red-contrib-alexa-remote2-applestrudel to play announcements or prompts for different automatic or via my alexa skill requested information from the home environment, mainly from Homematic. I now wa…

---

## [Project of vehicle using node red](https://discourse.nodered.org/t/project-of-vehicle-using-node-red/87558)

<div class="topic-metadata">

**Author:** [@Ndolothom](https://discourse.nodered.org/u/Ndolothom)\
**Replies:** 1\
**Last updated:** [27 April 2024 22:26 UTC](https://discourse.nodered.org/t/project-of-vehicle-using-node-red/87558 "2024-04-27T22:26:53Z")

</div>

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

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