# Latest

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

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

**Page:** 1039

---

## [Having problems to use MQTT with NodeRED in an embeded server](https://discourse.nodered.org/t/having-problems-to-use-mqtt-with-nodered-in-an-embeded-server/29881)

<div class="topic-metadata">

**Author:** [@WilliamSixta](https://discourse.nodered.org/u/WilliamSixta)\
**Replies:** 17\
**Last updated:** [19 July 2020 21:23 UTC](https://discourse.nodered.org/t/having-problems-to-use-mqtt-with-nodered-in-an-embeded-server/29881 "2020-07-19T21:23:07Z")

</div>

Hello guys! I am trying to develop an application using NodeRED and share the data in the cloud (GCloud) by MQTT. For this, I am using the ADAM 6717 of Advantech which Is a gateway with NodeRED embedded. I am having pr…

---

## [Raspberry Pi dies when left on overnight](https://discourse.nodered.org/t/raspberry-pi-dies-when-left-on-overnight/30297)

<div class="topic-metadata">

**Author:** [@gbenham](https://discourse.nodered.org/u/gbenham)\
**Replies:** 10\
**Last updated:** [19 July 2020 21:06 UTC](https://discourse.nodered.org/t/raspberry-pi-dies-when-left-on-overnight/30297 "2020-07-19T21:06:31Z")

</div>

I accidentally left my Raspberry Pi on overnight. When I discovered that the next day I also found that I couldn't get it to respond. I've tried cycling power but never gotten it to respond since then. If I recall correc…

---

## [Node-red is running twice on port 1880](https://discourse.nodered.org/t/node-red-is-running-twice-on-port-1880/30348)

<div class="topic-metadata">

**Author:** [@jitrah](https://discourse.nodered.org/u/jitrah)\
**Replies:** 2\
**Last updated:** [19 July 2020 17:39 UTC](https://discourse.nodered.org/t/node-red-is-running-twice-on-port-1880/30348 "2020-07-19T17:39:50Z")

</div>

Hi guys, I'm really new at all this. I launched a EC2 Ubuntu instance to be able to run Node-Red on it. After installing it following the instructions and after setting up npm2 to auto-start on reboot, it appears that …

---

## [Ui-table: options how - example no header](https://discourse.nodered.org/t/ui-table-options-how-example-no-header/30252)

<div class="topic-metadata">

**Author:** [@hklages](https://discourse.nodered.org/u/hklages)\
**Replies:** 12\
**Last updated:** [19 July 2020 17:57 UTC](https://discourse.nodered.org/t/ui-table-options-how-example-no-header/30252 "2020-07-19T17:57:41Z")

</div>

I would like to format a table created with node-red-node-ui-table but struggle with the ui\_control "Tabulator" property. How to use that? In the following example I try to hide the header but it does not work. What's…

---

## [OPC UA . Read Value ok but Write not possible](https://discourse.nodered.org/t/opc-ua-read-value-ok-but-write-not-possible/30260)

<div class="topic-metadata">

**Author:** [@pfe](https://discourse.nodered.org/u/pfe)\
**Replies:** 2\
**Last updated:** [19 July 2020 03:58 UTC](https://discourse.nodered.org/t/opc-ua-read-value-ok-but-write-not-possible/30260 "2020-07-19T03:58:48Z")

</div>

Hello Forum, I have a OPC UA server where UaExpert, CTT ( conformity Test Tool) can Read/Write nodes without problems. If a make a simple flow with node-red using the node-red-contrib-opcua to read and write this boolea…

---

## [Import flow overriding current one](https://discourse.nodered.org/t/import-flow-overriding-current-one/30267)

<div class="topic-metadata">

**Author:** [@gfcittolin](https://discourse.nodered.org/u/gfcittolin)\
**Replies:** 9\
**Last updated:** [19 July 2020 16:00 UTC](https://discourse.nodered.org/t/import-flow-overriding-current-one/30267 "2020-07-19T16:00:51Z")

</div>

Hi there! I have a usability feedback that we may find a solution together for it. Very often I find myself receiving an exported flow from somebody asking for help. I'll open an instance of Node-RED, import the flow, …

---

## [MySQL subtract two rows from column and places into an alias](https://discourse.nodered.org/t/mysql-subtract-two-rows-from-column-and-places-into-an-alias/30316)

<div class="topic-metadata">

**Author:** [@sonima](https://discourse.nodered.org/u/sonima)\
**Replies:** 5\
**Last updated:** [19 July 2020 13:19 UTC](https://discourse.nodered.org/t/mysql-subtract-two-rows-from-column-and-places-into-an-alias/30316 "2020-07-19T13:19:05Z")

</div>

I am working with Node-red and Mysql database. I don't know How to compare previous value with new value on each different devices then insert new value into Data column. I mean subtract new value with previous value …

---

## [Unable to display image from base64](https://discourse.nodered.org/t/unable-to-display-image-from-base64/29530)

<div class="topic-metadata">

**Author:** [@blob](https://discourse.nodered.org/u/blob)\
**Replies:** 31\
**Last updated:** [19 July 2020 12:22 UTC](https://discourse.nodered.org/t/unable-to-display-image-from-base64/29530 "2020-07-19T12:22:06Z")

</div>

Hello, I'm working with some sensors which send data through udp. Cameras are attached to each and every sensor. The data received through udp also include the data sent by the camera. The camera data is also clubbed wi…

---

## [Need advice about remote message transfer](https://discourse.nodered.org/t/need-advice-about-remote-message-transfer/30319)

<div class="topic-metadata">

**Author:** [@Hasitha\_Sudasinghe](https://discourse.nodered.org/u/Hasitha_Sudasinghe)\
**Replies:** 19\
**Last updated:** [19 July 2020 11:36 UTC](https://discourse.nodered.org/t/need-advice-about-remote-message-transfer/30319 "2020-07-19T11:36:45Z")

</div>

Dear Superiors, I have and issue to give a solution. I have two stations which are located 100m away from each other and i want to transfer strings from one statins to another. Master station is the always sending msgs…

---

## [Txt file and Http request](https://discourse.nodered.org/t/txt-file-and-http-request/30311)

<div class="topic-metadata">

**Author:** [@JoshuaMtz](https://discourse.nodered.org/u/JoshuaMtz)\
**Replies:** 2\
**Last updated:** [19 July 2020 11:30 UTC](https://discourse.nodered.org/t/txt-file-and-http-request/30311 "2020-07-19T11:30:22Z")

</div>

I am trying to upload a .txt file to an http address. The problem is that the information is published on a single line, that is: The .txt file contains the following numbers: 0 10 1 10 2 10 3 10 4 10 But when chec…

---

## [Dashboard theme - switch, using custom icon](https://discourse.nodered.org/t/dashboard-theme-switch-using-custom-icon/30325)

<div class="topic-metadata">

**Author:** [@hklages](https://discourse.nodered.org/u/hklages)\
**Replies:** 1\
**Last updated:** [19 July 2020 11:07 UTC](https://discourse.nodered.org/t/dashboard-theme-switch-using-custom-icon/30325 "2020-07-19T11:07:43Z")

</div>

When customizing a switch, using a custom icon (example "power") and not providing any color the default switch is displayed. Is color a "must field"? Does that work as designed? I would expect that the power icon is di…

---

## [Eztimer node configurer](https://discourse.nodered.org/t/eztimer-node-configurer/30327)

<div class="topic-metadata">

**Author:** [@xale12](https://discourse.nodered.org/u/xale12)\
**Replies:** 6\
**Last updated:** [19 July 2020 08:35 UTC](https://discourse.nodered.org/t/eztimer-node-configurer/30327 "2020-07-19T08:35:33Z")

</div>

Hello, I am a newbie on node-red. I try to use Eztimer node for timer but the debugger sends the comment not suitable for my code. for example, I turn off the schedule for Thursday It send back the string"Scheduled 'ON' …

---

## [Node-Red & UI on Android device using slax](https://discourse.nodered.org/t/node-red-ui-on-android-device-using-slax/30309)

<div class="topic-metadata">

**Author:** [@nksky](https://discourse.nodered.org/u/nksky)\
**Replies:** 1\
**Last updated:** [19 July 2020 08:20 UTC](https://discourse.nodered.org/t/node-red-ui-on-android-device-using-slax/30309 "2020-07-19T08:20:46Z")

</div>

I need to develop an app to run on an android device, 5" screen, but this has a barcode reader and GPS built-in, using Slax or dietpi as OS, run Node-red and UI on top would this work or be more hassle than its worth, An…

---

## ["MQTT in" Topic and kontext](https://discourse.nodered.org/t/mqtt-in-topic-and-kontext/30305)

<div class="topic-metadata">

**Author:** [@SN-8023](https://discourse.nodered.org/u/SN-8023)\
**Replies:** 2\
**Last updated:** [19 July 2020 02:57 UTC](https://discourse.nodered.org/t/mqtt-in-topic-and-kontext/30305 "2020-07-19T02:57:34Z")

</div>

Is there a way to fill the topic field from the flow context? this would make maintenance much easier if you only had to change 1 konext instead of 5 nodes per flow

---

## [Node-red-contrib-lcd20x4-i2c orange pi zero info](https://discourse.nodered.org/t/node-red-contrib-lcd20x4-i2c-orange-pi-zero-info/30320)

<div class="topic-metadata">

**Author:** [@88bit](https://discourse.nodered.org/u/88bit)\
**Replies:** 0\
**Last updated:** [19 July 2020 02:43 UTC](https://discourse.nodered.org/t/node-red-contrib-lcd20x4-i2c-orange-pi-zero-info/30320 "2020-07-19T02:43:50Z")

</div>

Hi all this is just a note for every one which may encounters this problem. even so it is quite a simple problem it took me some time to work this out. I have a cheap 4 x 20 LCD around $8 which I connected to my orange …

---

## [UI Control - Back to last tab](https://discourse.nodered.org/t/ui-control-back-to-last-tab/30266)

<div class="topic-metadata">

**Author:** [@nksky](https://discourse.nodered.org/u/nksky)\
**Replies:** 7\
**Last updated:** [19 July 2020 00:30 UTC](https://discourse.nodered.org/t/ui-control-back-to-last-tab/30266 "2020-07-19T00:30:41Z")

</div>

Hi, Setting up a menu system on Node-Red dashboard. On each screen I have 2 buttons, "Main Menu" and "Back", what do I need send to go back to the last tab that was used, I have tried a few things but to no avail. Than…

---

## [Nodered philips hue motion sensor](https://discourse.nodered.org/t/nodered-philips-hue-motion-sensor/9459)

<div class="topic-metadata">

**Author:** [@timdeloddere](https://discourse.nodered.org/u/timdeloddere)\
**Replies:** 6\
**Last updated:** [18 July 2020 22:46 UTC](https://discourse.nodered.org/t/nodered-philips-hue-motion-sensor/9459 "2020-07-18T22:46:52Z")

</div>

Hi, I have a Philips Hue bridge with some Hue Motions Sensors If I connect a debug node, the message I see is How do I get only the temperature (Celcius) value, out of this message ?

---

## [Http request node - gzip encrypted response](https://discourse.nodered.org/t/http-request-node-gzip-encrypted-response/30300)

<div class="topic-metadata">

**Author:** [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Replies:** 16\
**Last updated:** [18 July 2020 21:53 UTC](https://discourse.nodered.org/t/http-request-node-gzip-encrypted-response/30300 "2020-07-18T21:53:18Z")

</div>

Trying to download some statistical data from https://c19downloads.azureedge.net/downloads/msoa\_data/MSOAs\_latest.json If I use that url in a browser, I get access to the full data, but when trying using the http reque…

---

## [Controlling model train](https://discourse.nodered.org/t/controlling-model-train/30276)

<div class="topic-metadata">

**Author:** [@Jacad](https://discourse.nodered.org/u/Jacad)\
**Replies:** 4\
**Last updated:** [18 July 2020 20:43 UTC](https://discourse.nodered.org/t/controlling-model-train/30276 "2020-07-18T20:43:24Z")

</div>

Node-Red, Raspberry Pi 4 and 0, Esp32, MQTT. In the last months, a lot of spare time, I build my 40 year old model train set and tried to control it with Node-Red. First step: Manually controlling with the Dashboard. …

---

## [Sleep function no related to time, related to values](https://discourse.nodered.org/t/sleep-function-no-related-to-time-related-to-values/30299)

<div class="topic-metadata">

**Author:** [@lalo](https://discourse.nodered.org/u/lalo)\
**Replies:** 3\
**Last updated:** [18 July 2020 20:13 UTC](https://discourse.nodered.org/t/sleep-function-no-related-to-time-related-to-values/30299 "2020-07-18T20:13:31Z")

</div>

Hi, guys I want to have like a sleep function so basically I'm reading values for example from 0 to 50 so when the value is close to 0 I need some msg.payload interrupt to no send any msg, and when it approximates to 50 …

---

## [How to use Node-RED to switch ioBroker scenes](https://discourse.nodered.org/t/how-to-use-node-red-to-switch-iobroker-scenes/30289)

<div class="topic-metadata">

**Author:** [@Bravestarr](https://discourse.nodered.org/u/Bravestarr)\
**Replies:** 1\
**Last updated:** [18 July 2020 20:10 UTC](https://discourse.nodered.org/t/how-to-use-node-red-to-switch-iobroker-scenes/30289 "2020-07-18T20:10:45Z")

</div>

I try to switch a iobroker scene. I successfully receive a boolean from my alexa node-red node. I can see the output of msg.payload with the debug node. That switches from true to false and vice-versa if I use the alexa …

---

## [Adding functions to the Raspberry Pi Dashboard](https://discourse.nodered.org/t/adding-functions-to-the-raspberry-pi-dashboard/30146)

<div class="topic-metadata">

**Author:** [@gbenham](https://discourse.nodered.org/u/gbenham)\
**Replies:** 8\
**Last updated:** [18 July 2020 19:21 UTC](https://discourse.nodered.org/t/adding-functions-to-the-raspberry-pi-dashboard/30146 "2020-07-18T19:21:09Z")

</div>

In my dashboard section of the node-RED editor, under Raspberry Pi, there are only 4 items listed including GPIO Output and GPIO Input. How do I add other functions like rpi-dht22 (temperature and humidity sensor) and th…

---

## [Date/Time formatting](https://discourse.nodered.org/t/date-time-formatting/1138)

<div class="topic-metadata">

**Author:** [@na-am](https://discourse.nodered.org/u/na-am)\
**Replies:** 12\
**Last updated:** [18 July 2020 19:05 UTC](https://discourse.nodered.org/t/date-time-formatting/1138 "2020-07-18T19:05:45Z")

</div>

hi@all I need a string like this: “2018-06-28 08:44:55.000000” So I tried to format the date: var d = new Date(); var options = { timeZone: 'UTC', year: 'numeric', month: '2-digit', day: '2-digit'}; var \_resultDate = …

---

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

<div class="topic-metadata">

**Author:** [@mellis](https://discourse.nodered.org/u/mellis)\
**Replies:** 7\
**Last updated:** [18 July 2020 17:31 UTC](https://discourse.nodered.org/t/node-red-bacnet/30155 "2020-07-18T17:31:14Z")

</div>

I just found the node-red-contrib-bacnet and am testing it with a BACnet IP device. It works extremely well! 0.2.4. just a few questions: Is there any way to make the BACnet-read-node payload output on a BACnet COV in…

---

## [Plotly, data formats](https://discourse.nodered.org/t/plotly-data-formats/30063)

<div class="topic-metadata">

**Author:** [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Replies:** 16\
**Last updated:** [18 July 2020 16:33 UTC](https://discourse.nodered.org/t/plotly-data-formats/30063 "2020-07-18T16:33:25Z")

</div>

I'm learning a little about plotly for dashboard charts, and found it very easy to load their CDN library via a ui\_template node, and display some dummy data. However I've found using real data is not quite straightforw…

---

## [Spreadsheet-in Row/Column name](https://discourse.nodered.org/t/spreadsheet-in-row-column-name/30284)

<div class="topic-metadata">

**Author:** [@AK51](https://discourse.nodered.org/u/AK51)\
**Replies:** 3\
**Last updated:** [18 July 2020 15:48 UTC](https://discourse.nodered.org/t/spreadsheet-in-row-column-name/30284 "2020-07-18T15:48:33Z")

</div>

Hi, I want to read all excel data (using sheet-to-json), when I run the example, the json file looks fine. But when I use my own excel file, the json cell labeling does not look right. Please see the picture for detail…

---

## [Excel file to mySQL](https://discourse.nodered.org/t/excel-file-to-mysql/30283)

<div class="topic-metadata">

**Author:** [@AK51](https://discourse.nodered.org/u/AK51)\
**Replies:** 5\
**Last updated:** [18 July 2020 15:46 UTC](https://discourse.nodered.org/t/excel-file-to-mysql/30283 "2020-07-18T15:46:14Z")

</div>

Hi, I have an excel file (1000 rows), I can use spreadsheet-in to convert the data in one whole json. Is it feasible to insert 1000 rows into the mysql table? If not, I am looking for a method to read the excel one row …

---

## [\[Flow\] Corona country comparison with Hubei (China)](https://discourse.nodered.org/t/flow-corona-country-comparison-with-hubei-china/23237)

<div class="topic-metadata">

**Author:** [@janvda](https://discourse.nodered.org/u/janvda)\
**Replies:** 91\
**Last updated:** [9 June 2020 14:00 UTC](https://discourse.nodered.org/t/flow-corona-country-comparison-with-hubei-china/23237 "2020-06-09T14:00:44Z")

</div>

Comparison Charts (new section!!) I will regularly post new country comparison charts as comment to this forum topic. Here below the list of charts I have posted so far. Italy (lock down date=2020-03-05) generated a…

---

## [Config node settings not saved](https://discourse.nodered.org/t/config-node-settings-not-saved/30293)

<div class="topic-metadata">

**Author:** [@Colin](https://discourse.nodered.org/u/Colin)\
**Replies:** 4\
**Last updated:** [18 July 2020 14:36 UTC](https://discourse.nodered.org/t/config-node-settings-not-saved/30293 "2020-07-18T14:36:16Z")

</div>

I am creating my first node with an associated config node. I have used node-red-contrib-influxdb for inspiration and have got most of it working in the editor. The config node dropdown (Create New ...) appears ok and …

---

## [Types of NoSQL DB](https://discourse.nodered.org/t/types-of-nosql-db/29870)

<div class="topic-metadata">

**Author:** [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Replies:** 18\
**Last updated:** [18 July 2020 09:43 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870 "2020-07-18T09:43:52Z")

</div>

Hi. How many types of NoSQL DB have in NR? And which is better for sensor data gathering (SQL or NoSQL)?

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

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