# General

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

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

**Page:** 434

---

## [How to pass json data to a python script in exec-node in node-red](https://discourse.nodered.org/t/how-to-pass-json-data-to-a-python-script-in-exec-node-in-node-red/57249)

<div class="topic-metadata">

**Author:** [@Zekitui](https://discourse.nodered.org/u/Zekitui)\
**Replies:** 1\
**Last updated:** [26 January 2022 10:35 UTC](https://discourse.nodered.org/t/how-to-pass-json-data-to-a-python-script-in-exec-node-in-node-red/57249 "2022-01-26T10:35:08Z")

</div>

I'm new to node-red, and I wish I knew how to pass json data into a python script with node exec. Here is the format of my json { "fftx": \[ 2.6347945642924716e-17, 0.002915638633219862, 0.0003399789406291348…

---

## [I want open chrome in node-red](https://discourse.nodered.org/t/i-want-open-chrome-in-node-red/57234)

<div class="topic-metadata">

**Author:** [@datehoer](https://discourse.nodered.org/u/datehoer)\
**Replies:** 2\
**Last updated:** [26 January 2022 06:53 UTC](https://discourse.nodered.org/t/i-want-open-chrome-in-node-red/57234 "2022-01-26T06:53:06Z")

</div>

helo erveryone,i install node-red with docker on my windows,and i run the node-red in localhost:1880. i want use chrome in puppeteer with node-red view,but it make err. and my path is /data/node\_modules/node-red-con…

---

## [Select data from SQlite not working](https://discourse.nodered.org/t/select-data-from-sqlite-not-working/57236)

<div class="topic-metadata">

**Author:** [@TROJAN053](https://discourse.nodered.org/u/TROJAN053)\
**Replies:** 1\
**Last updated:** [26 January 2022 06:10 UTC](https://discourse.nodered.org/t/select-data-from-sqlite-not-working/57236 "2022-01-26T06:10:24Z")

</div>

Hi, I am querying from sqlite using but data is not getting selected and under debug its shows undefined. My flow is here \[{"id":"261492c80ec624f0","type":"tab","label":"Flow 1","disabled":false,"info":"","env":\[\]},{"…

---

## [Calculating values in SQL instead of NodeRed](https://discourse.nodered.org/t/calculating-values-in-sql-instead-of-nodered/57224)

<div class="topic-metadata">

**Author:** [@demokedes](https://discourse.nodered.org/u/demokedes)\
**Replies:** 4\
**Last updated:** [25 January 2022 22:12 UTC](https://discourse.nodered.org/t/calculating-values-in-sql-instead-of-nodered/57224 "2022-01-25T22:12:53Z")

</div>

I am total newbie in SQL. I am having SQL Database in Azure (Azure Database). I am having "smart electrical switches" in my home. I managed to gather data about their usage in SQL table. Attached is example of the table…

---

## [Function return type (tried to send a message of type string)](https://discourse.nodered.org/t/function-return-type-tried-to-send-a-message-of-type-string/57033)

<div class="topic-metadata">

**Author:** [@Noh](https://discourse.nodered.org/u/Noh)\
**Replies:** 3\
**Last updated:** [25 January 2022 21:49 UTC](https://discourse.nodered.org/t/function-return-type-tried-to-send-a-message-of-type-string/57033 "2022-01-25T21:49:35Z")

</div>

Function node accepts an input msg.payload = humidity % (i.e. integer 0-100) in the On Start tab, I have: var fanSwitch = {payload: "OFF", topic: 'bathroom/fanSwitch'}; flow.set('humidityThreshold', 90); flo…

---

## [Email out Issue](https://discourse.nodered.org/t/email-out-issue/57214)

<div class="topic-metadata">

**Author:** [@DVSL](https://discourse.nodered.org/u/DVSL)\
**Replies:** 7\
**Last updated:** [25 January 2022 19:32 UTC](https://discourse.nodered.org/t/email-out-issue/57214 "2022-01-25T19:32:16Z")

</div>

Hello! I'm having an issue trying to send an email, using the Email Out node. The error that I receive every time I try is the following: "Error: self signed certificate in certificate chain" If you have any suggestio…

---

## [BUG: Write file/Read file nodes labelled incorrectly](https://discourse.nodered.org/t/bug-write-file-read-file-nodes-labelled-incorrectly/57179)

<div class="topic-metadata">

**Author:** [@daxliniere](https://discourse.nodered.org/u/daxliniere)\
**Replies:** 9\
**Last updated:** [25 January 2022 17:31 UTC](https://discourse.nodered.org/t/bug-write-file-read-file-nodes-labelled-incorrectly/57179 "2022-01-25T17:31:57Z")

</div>

The newly renamed write file/read file nodes are still referred-to by their old name in the help section. Also, how do I pass a filename to the read/write nodes? I tried using msg.payload, but it didn't work Any h…

---

## [Node Red Midi to Virtual Piano](https://discourse.nodered.org/t/node-red-midi-to-virtual-piano/57089)

<div class="topic-metadata">

**Author:** [@prato](https://discourse.nodered.org/u/prato)\
**Replies:** 12\
**Last updated:** [25 January 2022 14:51 UTC](https://discourse.nodered.org/t/node-red-midi-to-virtual-piano/57089 "2022-01-25T14:51:16Z")

</div>

Hello I'm working on a project that transfers MQTT events i to a virtual piano did anyone have a examble flow to connect node red midi to a virtual piano ?

---

## [Mqtt In node shows other payload than mqtt Bridge Node](https://discourse.nodered.org/t/mqtt-in-node-shows-other-payload-than-mqtt-bridge-node/57187)

<div class="topic-metadata">

**Author:** [@pi1234](https://discourse.nodered.org/u/pi1234)\
**Replies:** 5\
**Last updated:** [25 January 2022 15:11 UTC](https://discourse.nodered.org/t/mqtt-in-node-shows-other-payload-than-mqtt-bridge-node/57187 "2022-01-25T15:11:19Z")

</div>

Hello, I have a problem with the payload I got from an In node (zigbee2mqtt). I have a Philips Hue Dimmer Switch (V1) and I can see at the bridge node that all keystrokes of the dimmer switch will be shown correctly. T…

---

## [Node-red-node-arduino installation failure](https://discourse.nodered.org/t/node-red-node-arduino-installation-failure/57205)

<div class="topic-metadata">

**Author:** [@ecymb1](https://discourse.nodered.org/u/ecymb1)\
**Replies:** 2\
**Last updated:** [25 January 2022 14:10 UTC](https://discourse.nodered.org/t/node-red-node-arduino-installation-failure/57205 "2022-01-25T14:10:41Z")

</div>

Greetings Everybody, I have been trying to install node-red-node-arduino for the past few weeks but can't seem to figure it out. I browsed the web (and forum) for some solutions and have tried all but to no avail. I hav…

---

## [Clean up CSV from unwonted chars](https://discourse.nodered.org/t/clean-up-csv-from-unwonted-chars/57202)

<div class="topic-metadata">

**Author:** [@FeliceM](https://discourse.nodered.org/u/FeliceM)\
**Replies:** 2\
**Last updated:** [25 January 2022 12:20 UTC](https://discourse.nodered.org/t/clean-up-csv-from-unwonted-chars/57202 "2022-01-25T12:20:31Z")

</div>

I am trying to log the output of a script using the csv node and the edit write file node. The script outputs a series of formatted string: tnow=('{0:%H:%M:%S.%f}'.format(datetime.now())) a= " {:.5f} {:.3…

---

## [How to send command to Arduino through serial commend?](https://discourse.nodered.org/t/how-to-send-command-to-arduino-through-serial-commend/57096)

<div class="topic-metadata">

**Author:** [@51fei](https://discourse.nodered.org/u/51fei)\
**Replies:** 4\
**Last updated:** [25 January 2022 11:58 UTC](https://discourse.nodered.org/t/how-to-send-command-to-arduino-through-serial-commend/57096 "2022-01-25T11:58:44Z")

</div>

I want to use Node-RED: inject node to send commands to Arduino, Below is the code I wrote, but it did not work. Does anyone know how to write? Thank you. void messageReceived () { if (payload = 0) { Serial.…

---

## [Replace string by schema inside array](https://discourse.nodered.org/t/replace-string-by-schema-inside-array/57199)

<div class="topic-metadata">

**Author:** [@ketpa](https://discourse.nodered.org/u/ketpa)\
**Replies:** 1\
**Last updated:** [25 January 2022 11:31 UTC](https://discourse.nodered.org/t/replace-string-by-schema-inside-array/57199 "2022-01-25T11:31:27Z")

</div>

I want to change myString by mobiles schema. myString = "Samsung, Google, Apple "; myNewString = 'Galaxy Note 9, Pixel 3, iPhone X' How to do that? const mobiles = \[ { oldWord: 'Samsung', newWord…

---

## [Hello,i want use puppeteer in node red,what i can do](https://discourse.nodered.org/t/hello-i-want-use-puppeteer-in-node-red-what-i-can-do/57194)

<div class="topic-metadata">

**Author:** [@datehoer](https://discourse.nodered.org/u/datehoer)\
**Replies:** 7\
**Last updated:** [25 January 2022 09:54 UTC](https://discourse.nodered.org/t/hello-i-want-use-puppeteer-in-node-red-what-i-can-do/57194 "2022-01-25T09:54:10Z")

</div>

it like the question I'm new at this i want use the node-red-contrib-puppeteer-core-chromium in node-red and i configure the puppeteer, it doesn't work. what i can do ?

---

## [Looking for an ESP programmer for implementing JSON export via MQTT over a smartphone hotspot](https://discourse.nodered.org/t/looking-for-an-esp-programmer-for-implementing-json-export-via-mqtt-over-a-smartphone-hotspot/57198)

<div class="topic-metadata">

**Author:** [@stefan24](https://discourse.nodered.org/u/stefan24)\
**Replies:** 0\
**Last updated:** [25 January 2022 09:50 UTC](https://discourse.nodered.org/t/looking-for-an-esp-programmer-for-implementing-json-export-via-mqtt-over-a-smartphone-hotspot/57198 "2022-01-25T09:50:24Z")

</div>

... for an existing web-based ESP application. This JSON data should then be read via MQTT and analyzed and displayed in Node-RED. Since my english is not the best, I would prefer to communicate in german. I know ther…

---

## [Conflicting messages in edit screen](https://discourse.nodered.org/t/conflicting-messages-in-edit-screen/57181)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [25 January 2022 08:07 UTC](https://discourse.nodered.org/t/conflicting-messages-in-edit-screen/57181 "2022-01-25T08:07:33Z")

</div>

NR 2.1.6 I have a duplicate subflow, so I renamed it to something else to help find it. Pictures tell the story. Give it a unique name. If not original. Looking looking looking for it. Not found. Ok, we'll de…

---

## [Wait for second message before going on - how to?](https://discourse.nodered.org/t/wait-for-second-message-before-going-on-how-to/56077)

<div class="topic-metadata">

**Author:** [@pi1234](https://discourse.nodered.org/u/pi1234)\
**Replies:** 11\
**Last updated:** [25 January 2022 07:00 UTC](https://discourse.nodered.org/t/wait-for-second-message-before-going-on-how-to/56077 "2022-01-25T07:00:58Z")

</div>

Hi, I have a problem with my Hue Motion sensor. It sends every 5 minutes (4:59 or 5mins) a message with full payload even if the room is complete empty. At first I tought its up to the sensivity but then I realize the t…

---

## [RasPi WiFi going down when I stop NR](https://discourse.nodered.org/t/raspi-wifi-going-down-when-i-stop-nr/57032)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 11\
**Last updated:** [25 January 2022 04:08 UTC](https://discourse.nodered.org/t/raspi-wifi-going-down-when-i-stop-nr/57032 "2022-01-25T04:08:46Z")

</div>

I must be going mad, but this has me confused big time. (Back - back story) I have replaced a RPZ(W) with a 3B+. But it is on WiFi. I think now it has done it a couple of times. Today I was updating some nodes and …

---

## [Why is this reporting Undefined?](https://discourse.nodered.org/t/why-is-this-reporting-undefined/57182)

<div class="topic-metadata">

**Author:** [@TheadehAnank](https://discourse.nodered.org/u/TheadehAnank)\
**Replies:** 1\
**Last updated:** [25 January 2022 03:53 UTC](https://discourse.nodered.org/t/why-is-this-reporting-undefined/57182 "2022-01-25T03:53:36Z")

</div>

\[ { "id": "cdd592f25ffd2417", "type": "tab", "label": "Flow 1", "disabled": false, "info": "", "env": \[\] }, { "id": "3a363a0b81b1330f", "type": …

---

## [Bad colours on/in browser](https://discourse.nodered.org/t/bad-colours-on-in-browser/57176)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 26\
**Last updated:** [25 January 2022 02:16 UTC](https://discourse.nodered.org/t/bad-colours-on-in-browser/57176 "2022-01-25T02:16:54Z")

</div>

Quick back story: I use FireFox. Run Ubuntu 20.04 A long time ago when entering my password a colour requester popped up (unexpectedly) and I have had this little problem since - I think. Sometimes when reading thing…

---

## [All RPi GPIO pins showing N/A](https://discourse.nodered.org/t/all-rpi-gpio-pins-showing-n-a/57144)

<div class="topic-metadata">

**Author:** [@daxliniere](https://discourse.nodered.org/u/daxliniere)\
**Replies:** 8\
**Last updated:** [25 January 2022 00:01 UTC](https://discourse.nodered.org/t/all-rpi-gpio-pins-showing-n-a/57144 "2022-01-25T00:01:28Z")

</div>

Hey gang, After a mass update of nodes, my GPIO pins are now showing N/A: 0 and are non-operational. I tried to roll back to 1.2.3 with npm install node-red-node-pi-gpio@1.2.3 but I see rollback option failed: npm WAR…

---

## [Div.ui-svg still contains the fill:inherit !important tag](https://discourse.nodered.org/t/div-ui-svg-still-contains-the-fill-inherit-important-tag/57165)

<div class="topic-metadata">

**Author:** [@letshin](https://discourse.nodered.org/u/letshin)\
**Replies:** 2\
**Last updated:** [24 January 2022 21:09 UTC](https://discourse.nodered.org/t/div-ui-svg-still-contains-the-fill-inherit-important-tag/57165 "2022-01-24T21:09:55Z")

</div>

I updated to the 3.1 of the ui-svg version and have checked svg\_graphics.html and svg\_graphics.js in ~/.node-red/node\_modules/node-red-contrib-ui-svg, and the code doesn't contain the !important tag div.ui-svg path { …

---

## [New To Node Red - Trying to educate myself](https://discourse.nodered.org/t/new-to-node-red-trying-to-educate-myself/57104)

<div class="topic-metadata">

**Author:** [@SMB1](https://discourse.nodered.org/u/SMB1)\
**Replies:** 12\
**Last updated:** [24 January 2022 20:57 UTC](https://discourse.nodered.org/t/new-to-node-red-trying-to-educate-myself/57104 "2022-01-24T20:57:22Z")

</div>

Hello to the group. This is my first post. Apologies if this has been raised in the past. I am attempting to develop a flow to download temperature/humidity data. I plan to access this device remotely (but that is my ne…

---

## [Change node w/ regex oddity](https://discourse.nodered.org/t/change-node-w-regex-oddity/57168)

<div class="topic-metadata">

**Author:** [@hobbes1069](https://discourse.nodered.org/u/hobbes1069)\
**Replies:** 2\
**Last updated:** [24 January 2022 20:24 UTC](https://discourse.nodered.org/t/change-node-w-regex-oddity/57168 "2022-01-24T20:24:49Z")

</div>

I'm prototyping using Node Red to publish device statistics (OS, Memory, CPU, etc) into a MQTT broker to later use the info for a dashboard. I had it working fine but now I'm trying to generalize it as much as possible t…

---

## [Unable to install modules on Docker](https://discourse.nodered.org/t/unable-to-install-modules-on-docker/57137)

<div class="topic-metadata">

**Author:** [@ostiniatoze](https://discourse.nodered.org/u/ostiniatoze)\
**Replies:** 4\
**Last updated:** [24 January 2022 19:23 UTC](https://discourse.nodered.org/t/unable-to-install-modules-on-docker/57137 "2022-01-24T19:23:36Z")

</div>

Hello, I recently tried to update some nodes via the manage palette menu, that failed and since I've been unable to install any new nodes, and some of the ones I attempted to update have disappeared. I'm running node-re…

---

## [Change Node Regex](https://discourse.nodered.org/t/change-node-regex/56671)

<div class="topic-metadata">

**Author:** [@hobbes1069](https://discourse.nodered.org/u/hobbes1069)\
**Replies:** 6\
**Last updated:** [24 January 2022 19:05 UTC](https://discourse.nodered.org/t/change-node-regex/56671 "2022-01-24T19:05:28Z")

</div>

So I read through a few posts but none of them seemed to be exactly what I was looking for. I know I could do this with a function node but was trying to keep things as "no-code" as possible. I have a string OKUMA.ASSET…

---

## [Logging all activity](https://discourse.nodered.org/t/logging-all-activity/57131)

<div class="topic-metadata">

**Author:** [@Timmiej93](https://discourse.nodered.org/u/Timmiej93)\
**Replies:** 2\
**Last updated:** [24 January 2022 13:33 UTC](https://discourse.nodered.org/t/logging-all-activity/57131 "2022-01-24T13:33:27Z")

</div>

I'm looking to get a log of all activity in NR, similar to how Home Assistant logs automations. I would like to be able to have the input and result of every node visible in a file in a logical way. I've seen many of th…

---

## [Aqara Zigbee Button Button Press](https://discourse.nodered.org/t/aqara-zigbee-button-button-press/57098)

<div class="topic-metadata">

**Author:** [@rnormore](https://discourse.nodered.org/u/rnormore)\
**Replies:** 7\
**Last updated:** [24 January 2022 15:41 UTC](https://discourse.nodered.org/t/aqara-zigbee-button-button-press/57098 "2022-01-24T15:41:40Z")

</div>

Hi I have a Aqara Zigbee Button setup in home assistant. I would like to use it to turn off a lamp that is connected to a Zigbee plug. The only problem i am running into is when I press the button the lamp will quickly …

---

## [Problems with creating CSV or excel](https://discourse.nodered.org/t/problems-with-creating-csv-or-excel/57041)

<div class="topic-metadata">

**Author:** [@BG6WCL](https://discourse.nodered.org/u/BG6WCL)\
**Replies:** 15\
**Last updated:** [24 January 2022 15:12 UTC](https://discourse.nodered.org/t/problems-with-creating-csv-or-excel/57041 "2022-01-24T15:12:22Z")

</div>

Nice to be in this community！ I can't append after using excelsheets to create excel, I can only cover; If multiple sheets cannot be created using CSV; I need to put the data of 2 devices into a file, each device corr…

---

## [Running Multiple Instances of Node-red using NSSM](https://discourse.nodered.org/t/running-multiple-instances-of-node-red-using-nssm/57127)

<div class="topic-metadata">

**Author:** [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Replies:** 9\
**Last updated:** [24 January 2022 15:04 UTC](https://discourse.nodered.org/t/running-multiple-instances-of-node-red-using-nssm/57127 "2022-01-24T15:04:29Z")

</div>

Continuing the discussion from Node red multiple instances: I ran through this entire thread, but unable to start second service for Node-Red One is running successfully, other doesn't start. the message says ' the se…

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

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