# Latest

**URL:** https://discourse.nodered.org/latest.md?page=646

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

**Page:** 647

---

## [Best Practice For Mass Deployment Of NR node modules (i.e. packages)? Specific To Package Updates](https://discourse.nodered.org/t/best-practice-for-mass-deployment-of-nr-node-modules-i-e-packages-specific-to-package-updates/57178)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 8\
**Last updated:** [26 January 2022 11:14 UTC](https://discourse.nodered.org/t/best-practice-for-mass-deployment-of-nr-node-modules-i-e-packages-specific-to-package-updates/57178 "2022-01-26T11:14:25Z")

</div>

Is this logic considered best practice for new installation of NR, specific to package handling? install NR (via official script) npm install (load from package.json) npm list --depth 0 (just packages) npm outdated (it…

---

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

---

## [Ui\_chart: Formatting date for stacked bar chart](https://discourse.nodered.org/t/ui-chart-formatting-date-for-stacked-bar-chart/57223)

<div class="topic-metadata">

**Author:** [@rakgupta](https://discourse.nodered.org/u/rakgupta)\
**Replies:** 2\
**Last updated:** [25 January 2022 21:59 UTC](https://discourse.nodered.org/t/ui-chart-formatting-date-for-stacked-bar-chart/57223 "2022-01-25T21:59:28Z")

</div>

Hello - I displaying a chart in the dashboard that fetches data from a mySQL database and using it to create a stacked bar chart. The X-axes is the date. Currently, my dates are showing in UTC format ("2022-01-07T06:00:0…

---

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

---

## [ETH484 +IFTTT smarthome](https://discourse.nodered.org/t/eth484-ifttt-smarthome/57225)

<div class="topic-metadata">

**Author:** [@PiMo131](https://discourse.nodered.org/u/PiMo131)\
**Replies:** 0\
**Last updated:** [25 January 2022 21:17 UTC](https://discourse.nodered.org/t/eth484-ifttt-smarthome/57225 "2022-01-25T21:17:32Z")

</div>

This flow is a very basic control over ETH484 or similar ethernet I/O modules by robot electronics. Full information on the hardware module can be found hereRobot-electronics Another integration in this flow is with IFT…

---

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

---

## [uiBuilder Vue Table - Change Row Format](https://discourse.nodered.org/t/uibuilder-vue-table-change-row-format/57210)

<div class="topic-metadata">

**Author:** [@Paulf007](https://discourse.nodered.org/u/Paulf007)\
**Replies:** 7\
**Last updated:** [25 January 2022 18:30 UTC](https://discourse.nodered.org/t/uibuilder-vue-table-change-row-format/57210 "2022-01-25T18:30:19Z")

</div>

Ok here is something , that I think should be fairly simple , that I cant get my head around. I am building a MQTT device tracker with a web front end. Fairly strait forward , I keep track of regular incoming payload vi…

---

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

---

## [FlowForge is hiring](https://discourse.nodered.org/t/flowforge-is-hiring/53475)

<div class="topic-metadata">

**Author:** [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Replies:** 4\
**Last updated:** [25 January 2022 17:28 UTC](https://discourse.nodered.org/t/flowforge-is-hiring/53475 "2022-01-25T17:28:11Z")

</div>

(We didn't have a #jobs category here like we do in Slack - so I've created one. I realise this is a bit self-serving, but it's here for all of us to make use of) My company is hiring for two roles that will be of inter…

---

## [Top right Notification box too small? (No Dynamic sizing?)](https://discourse.nodered.org/t/top-right-notification-box-too-small-no-dynamic-sizing/57155)

<div class="topic-metadata">

**Author:** [@thebaldgeek](https://discourse.nodered.org/u/thebaldgeek)\
**Replies:** 4\
**Last updated:** [25 January 2022 16:57 UTC](https://discourse.nodered.org/t/top-right-notification-box-too-small-no-dynamic-sizing/57155 "2022-01-25T16:57:49Z")

</div>

Hello. I am creating a HTML message (seems to have better formatting control that way) and sending it to the Notification - Top Right. The problem is that I have too much information and the box only has a very small d…

---

## [Trying to Create a News ticker in Node red](https://discourse.nodered.org/t/trying-to-create-a-news-ticker-in-node-red/57200)

<div class="topic-metadata">

**Author:** [@Zak](https://discourse.nodered.org/u/Zak)\
**Replies:** 3\
**Last updated:** [25 January 2022 16:21 UTC](https://discourse.nodered.org/t/trying-to-create-a-news-ticker-in-node-red/57200 "2022-01-25T16:21:07Z")

</div>

Hey There. i am trying to create the following in Node Red: 1- i have a database that contain data 2- i want to select the data from the database table 3- i want to display the data in some sort of a news ticker ( mo…

---

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

---

## [How do i update values from sidebar tab into it's corresponding pallet](https://discourse.nodered.org/t/how-do-i-update-values-from-sidebar-tab-into-its-corresponding-pallet/57188)

<div class="topic-metadata">

**Author:** [@Monarch](https://discourse.nodered.org/u/Monarch)\
**Replies:** 3\
**Last updated:** [25 January 2022 09:50 UTC](https://discourse.nodered.org/t/how-do-i-update-values-from-sidebar-tab-into-its-corresponding-pallet/57188 "2022-01-25T09:50:40Z")

</div>

I have made a side bar tab which have same fields as that of its corresponding pallet. What i want to do is i want to make changes to fields under sidebar tab and same would be reflected into its corresponding pallet. …

---

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

---

## [Send data from a database to a dropdown list](https://discourse.nodered.org/t/send-data-from-a-database-to-a-dropdown-list/57172)

<div class="topic-metadata">

**Author:** [@rothestar](https://discourse.nodered.org/u/rothestar)\
**Replies:** 3\
**Last updated:** [25 January 2022 07:55 UTC](https://discourse.nodered.org/t/send-data-from-a-database-to-a-dropdown-list/57172 "2022-01-25T07:55:46Z")

</div>

I Have a sample database where I want to extract the values from the first column Called zone my flow looks like this: the code looks like this: \[{"id":"5988b4fb.4e292c","type":"ui\_dropdown","z":"33b0e6d0.3a306a…

---

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

---

## [A bit of background on NR, Dave and Nick ? - TIme permitting](https://discourse.nodered.org/t/a-bit-of-background-on-nr-dave-and-nick-time-permitting/57075)

<div class="topic-metadata">

**Author:** [@craigcurtin](https://discourse.nodered.org/u/craigcurtin)\
**Replies:** 7\
**Last updated:** [25 January 2022 05:42 UTC](https://discourse.nodered.org/t/a-bit-of-background-on-nr-dave-and-nick-time-permitting/57075 "2022-01-25T05:42:45Z")

</div>

Hey Guys, We all probably know snippets about the NR story - where it came from etc, any chance of getting a one pager on the whole thing as well as where Nick and Dave are professionally at the moment ? i.e Nick appea…

---

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

---

## [How to format input for node-red-node-ui-list](https://discourse.nodered.org/t/how-to-format-input-for-node-red-node-ui-list/56780)

<div class="topic-metadata">

**Author:** [@Callipygous](https://discourse.nodered.org/u/Callipygous)\
**Replies:** 2\
**Last updated:** [25 January 2022 03:21 UTC](https://discourse.nodered.org/t/how-to-format-input-for-node-red-node-ui-list/56780 "2022-01-25T03:21:06Z")

</div>

I am trying to use node red to play a set of chimes to act as my doorbell. I want it to have a library of saved songs users have composed, and it seemed like the "node-red-node-ui-list" would work great for this function…

[Previous page](https://discourse.nodered.org/latest.md?page=645)

[Next page](https://discourse.nodered.org/latest.md?page=647)