# Latest

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

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

**Page:** 492

---

## [Make your own AI chatbot with GPT-3, world's most powerful linguistic AI](https://discourse.nodered.org/t/make-your-own-ai-chatbot-with-gpt-3-worlds-most-powerful-linguistic-ai/55990)

<div class="topic-metadata">

**Author:** [@mistywind](https://discourse.nodered.org/u/mistywind)\
**Replies:** 1\
**Last updated:** [28 September 2022 11:02 UTC](https://discourse.nodered.org/t/make-your-own-ai-chatbot-with-gpt-3-worlds-most-powerful-linguistic-ai/55990 "2022-09-28T11:02:00Z")

</div>

Here is Node Red flow to make your own AI chatbot using GPT-3. Do share your experience after trying this.

---

## [Editable list validate with external value](https://discourse.nodered.org/t/editable-list-validate-with-external-value/68335)

<div class="topic-metadata">

**Author:** [@alevher](https://discourse.nodered.org/u/alevher)\
**Replies:** 1\
**Last updated:** [28 September 2022 09:53 UTC](https://discourse.nodered.org/t/editable-list-validate-with-external-value/68335 "2022-09-28T09:53:46Z")

</div>

Hello Everyone, I'm tryng to validate a value of an editable list based on the value of a checkbox of the node, is it possible ? I'd like to check if value3 is not " " only if the checkbox duplicates is checked. here'…

---

## [Getting find() timed out messages with correct creds](https://discourse.nodered.org/t/getting-find-timed-out-messages-with-correct-creds/68334)

<div class="topic-metadata">

**Author:** [@tinychaos42](https://discourse.nodered.org/u/tinychaos42)\
**Replies:** 0\
**Last updated:** [28 September 2022 09:30 UTC](https://discourse.nodered.org/t/getting-find-timed-out-messages-with-correct-creds/68334 "2022-09-28T09:30:32Z")

</div>

Hi folks, not sure if nodered forum is the right place to put this question, but I've put this on 2x relevant GH repos as well, and I'll close/update them according to my progress with the issue. The bug / issue Got a …

---

## [Node-RED-Dashboard freezes when loading MySQL database](https://discourse.nodered.org/t/node-red-dashboard-freezes-when-loading-mysql-database/68135)

<div class="topic-metadata">

**Author:** [@JustinB](https://discourse.nodered.org/u/JustinB)\
**Replies:** 18\
**Last updated:** [28 September 2022 08:26 UTC](https://discourse.nodered.org/t/node-red-dashboard-freezes-when-loading-mysql-database/68135 "2022-09-28T08:26:33Z")

</div>

Hello people, I created a dashboard, which you can do messurements with at the Raspberry Pi. The results are getting displayed in a table and saved inside a MySQL database. The user is also able to download the database…

---

## [Display the daily work of heating system](https://discourse.nodered.org/t/display-the-daily-work-of-heating-system/68292)

<div class="topic-metadata">

**Author:** [@edstobi](https://discourse.nodered.org/u/edstobi)\
**Replies:** 8\
**Last updated:** [28 September 2022 05:59 UTC](https://discourse.nodered.org/t/display-the-daily-work-of-heating-system/68292 "2022-09-28T05:59:27Z")

</div>

Hello I need the collective knowledge to work out a solution for my node red. I get a 1 second pulse (state goes to 1) via mqtt when my gas meter has advanced by 0.001 qm. I now want to see in the dashboard the runtim…

---

## [Generate modbus flex sequence](https://discourse.nodered.org/t/generate-modbus-flex-sequence/68203)

<div class="topic-metadata">

**Author:** [@xjust](https://discourse.nodered.org/u/xjust)\
**Replies:** 4\
**Last updated:** [27 September 2022 21:37 UTC](https://discourse.nodered.org/t/generate-modbus-flex-sequence/68203 "2022-09-27T21:37:41Z")

</div>

I have a few registers to read using modbus flex: To avoid modbus congestion,can anyone help me generate a sequence of registers/quantity to have as little queries as possible ? For example : numbers = \[10,11,12,18,5…

---

## [OPC UA "OPC SUBSCRIBE: StatusCode: Good#Overflow (0x00000080)"](https://discourse.nodered.org/t/opc-ua-opc-subscribe-statuscode-good-overflow-0x00000080/68322)

<div class="topic-metadata">

**Author:** [@piwi447](https://discourse.nodered.org/u/piwi447)\
**Replies:** 0\
**Last updated:** [27 September 2022 20:58 UTC](https://discourse.nodered.org/t/opc-ua-opc-subscribe-statuscode-good-overflow-0x00000080/68322 "2022-09-27T20:58:52Z")

</div>

Hello, I am using OPC UA node-red-contrib-opcua to read structure from a codesys OPC UA server running on Raspberry Pi target. This interface was developped originally 2 years ago on Nodered 1.2.6 with OPC UA version 0…

---

## [Date() giving incorrect time](https://discourse.nodered.org/t/date-giving-incorrect-time/68290)

<div class="topic-metadata">

**Author:** [@pmknowles](https://discourse.nodered.org/u/pmknowles)\
**Replies:** 10\
**Last updated:** [27 September 2022 21:00 UTC](https://discourse.nodered.org/t/date-giving-incorrect-time/68290 "2022-09-27T21:00:54Z")

</div>

I have a function node which starts with var date = new Date(); The output comes out at 'Zulu time' I read that the time is the computer time but it doesn't seem to be. I can't see how to fix it

---

## [Node-red-contrib-shelly for 2 PM in cover mode](https://discourse.nodered.org/t/node-red-contrib-shelly-for-2-pm-in-cover-mode/67899)

<div class="topic-metadata">

**Author:** [@Simone](https://discourse.nodered.org/u/Simone)\
**Replies:** 8\
**Last updated:** [27 September 2022 20:46 UTC](https://discourse.nodered.org/t/node-red-contrib-shelly-for-2-pm-in-cover-mode/67899 "2022-09-27T20:46:56Z")

</div>

Hi there, I can't find the syntax of the message to control the position of the roller/cover using node-red-contrib-shelly (Shelly Gen 2) and the Shelly Plus 2PM.

---

## [Http post request with image to python webservice](https://discourse.nodered.org/t/http-post-request-with-image-to-python-webservice/68257)

<div class="topic-metadata">

**Author:** [@vanTuxen](https://discourse.nodered.org/u/vanTuxen)\
**Replies:** 6\
**Last updated:** [27 September 2022 20:09 UTC](https://discourse.nodered.org/t/http-post-request-with-image-to-python-webservice/68257 "2022-09-27T20:09:58Z")

</div>

Hi everybody. I am kind of become desperate on a task which seems quite easy at the first glace. I want to call a webservice which is hosted on the same machine to analyze photos for faces etc. The service is provided …

---

## [Sorting MySQL-Payload Data for Apex-Charts using JSONata](https://discourse.nodered.org/t/sorting-mysql-payload-data-for-apex-charts-using-jsonata/68258)

<div class="topic-metadata">

**Author:** [@Martin12](https://discourse.nodered.org/u/Martin12)\
**Replies:** 6\
**Last updated:** [27 September 2022 19:20 UTC](https://discourse.nodered.org/t/sorting-mysql-payload-data-for-apex-charts-using-jsonata/68258 "2022-09-27T19:20:30Z")

</div>

Hey everyone! I'm trying to use JSONata to get a MySQL-Payload in the right format to display that data with ApexCharts. I'm quite new to Node-Red and not sure if my task is probably too complex for JSONata. Here's an e…

---

## [How to create a JSON variable to store an OPCUA value](https://discourse.nodered.org/t/how-to-create-a-json-variable-to-store-an-opcua-value/68304)

<div class="topic-metadata">

**Author:** [@Ghassen](https://discourse.nodered.org/u/Ghassen)\
**Replies:** 2\
**Last updated:** [27 September 2022 18:29 UTC](https://discourse.nodered.org/t/how-to-create-a-json-variable-to-store-an-opcua-value/68304 "2022-09-27T18:29:34Z")

</div>

Hello! I'm actually working on a project to retrieve OPCUA values from a PLC and visualize them on a cloud dashboard. I managed to get the data I wanted but I struggle to send this via http request on the cloud because…

---

## [\[Minor Update\] alternate-node-red-installer v2.0.3](https://discourse.nodered.org/t/minor-update-alternate-node-red-installer-v2-0-3/45026)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 6\
**Last updated:** [27 September 2022 11:36 UTC](https://discourse.nodered.org/t/minor-update-alternate-node-red-installer-v2-0-3/45026 "2022-09-27T11:36:41Z")

</div>

alternate-node-red-installer is not a node. It is, as it says, a template for an alternative way to install and manage Node-RED. Install globally using npm so that the nrinstall application is globally available. Should…

---

## [How to use variables in msg path?](https://discourse.nodered.org/t/how-to-use-variables-in-msg-path/68289)

<div class="topic-metadata">

**Author:** [@Purize](https://discourse.nodered.org/u/Purize)\
**Replies:** 2\
**Last updated:** [27 September 2022 11:29 UTC](https://discourse.nodered.org/t/how-to-use-variables-in-msg-path/68289 "2022-09-27T11:29:56Z")

</div>

Hi, I'm having problems with this "easy" task, please help. Tasks: Lookup value of "msg.data.game\_id" in "msg.data.games" Copy the attribute "media\_image\_url" to "msg.data.game\_image" Is the change node able to perfo…

---

## [Docker gives Error: EACCES: permission denied, copyfile -\> ‘/data/settings.js’](https://discourse.nodered.org/t/docker-gives-error-eacces-permission-denied-copyfile-data-settings-js/68285)

<div class="topic-metadata">

**Author:** [@arseny-sandaar](https://discourse.nodered.org/u/arseny-sandaar)\
**Replies:** 1\
**Last updated:** [27 September 2022 11:14 UTC](https://discourse.nodered.org/t/docker-gives-error-eacces-permission-denied-copyfile-data-settings-js/68285 "2022-09-27T11:14:58Z")

</div>

Dear community members, I tried to deploy node-red on Azure IoT edge device using nodred lates image, though I receive the following error: Error: EACCES: permission denied, copyfile '/usr/src/node-red/node\_modules/nod…

---

## [Alternative to subflow](https://discourse.nodered.org/t/alternative-to-subflow/68286)

<div class="topic-metadata">

**Author:** [@hazymat](https://discourse.nodered.org/u/hazymat)\
**Replies:** 2\
**Last updated:** [27 September 2022 11:14 UTC](https://discourse.nodered.org/t/alternative-to-subflow/68286 "2022-09-27T11:14:32Z")

</div>

Is there a new feature in NodeRED that provides alternative functionality to subflows? Some kind of function template I'm sure I read about it somewhere (/watched a video). I recall thinking "wow, there are now three d…

---

## [My current Dashboard](https://discourse.nodered.org/t/my-current-dashboard/68240)

<div class="topic-metadata">

**Author:** [@stefan24](https://discourse.nodered.org/u/stefan24)\
**Replies:** 5\
**Last updated:** [27 September 2022 10:38 UTC](https://discourse.nodered.org/t/my-current-dashboard/68240 "2022-09-27T10:38:36Z")

</div>

My current Dashboard (all labels are in german): If someone wants to know, how I realized certain elements or what these elements are for please ask. On my (new) Smarthome website (https://smarthome.sb242.de) I alre…

---

## [Join based on identifier](https://discourse.nodered.org/t/join-based-on-identifier/67745)

<div class="topic-metadata">

**Author:** [@smitterer](https://discourse.nodered.org/u/smitterer)\
**Replies:** 13\
**Last updated:** [27 September 2022 09:14 UTC](https://discourse.nodered.org/t/join-based-on-identifier/67745 "2022-09-27T09:14:48Z")

</div>

Hi! I'm getting several payloads from a sql query in an array. Example: \[{"COL\_PRIMARY\_KEY":7,"COL\_CALL":"ABC123","COL\_QSL\_VIA":"","COL\_TIME\_ON":"2022-08-23T08:47:15.000Z","COL\_MODE":"FT8","COL\_BAND":"20m","COL\_RST\_SE…

---

## [GPIO access on Odroid N2+](https://discourse.nodered.org/t/gpio-access-on-odroid-n2/68280)

<div class="topic-metadata">

**Author:** [@tramanah](https://discourse.nodered.org/u/tramanah)\
**Replies:** 0\
**Last updated:** [27 September 2022 09:10 UTC](https://discourse.nodered.org/t/gpio-access-on-odroid-n2/68280 "2022-09-27T09:10:23Z")

</div>

Hi, is there any way to access odriod N2 gpio via node red. I am stuck here.

---

## [Junction node - issue with touch (iPad)](https://discourse.nodered.org/t/junction-node-issue-with-touch-ipad/68279)

<div class="topic-metadata">

**Author:** [@hazymat](https://discourse.nodered.org/u/hazymat)\
**Replies:** 2\
**Last updated:** [27 September 2022 08:19 UTC](https://discourse.nodered.org/t/junction-node-issue-with-touch-ipad/68279 "2022-09-27T08:19:12Z")

</div>

Anyone else here use NodeRED admin with iPad Pro / touch / pencil? It’s surprisingly good because you can combine the use of finger to pan around and move nodes, and pencil to do more accurate stuff, e.g. double clicking…

---

## [Time Question Windows 10](https://discourse.nodered.org/t/time-question-windows-10/68237)

<div class="topic-metadata">

**Author:** [@MarkusW](https://discourse.nodered.org/u/MarkusW)\
**Replies:** 5\
**Last updated:** [27 September 2022 07:09 UTC](https://discourse.nodered.org/t/time-question-windows-10/68237 "2022-09-27T07:09:42Z")

</div>

Hi, I am new to node-red. I already searched with google etc. But I did not find an answer. If I start node-red in windows 10 via cmd. The time in node red has an offset to my system time. For example: node-red: 10:0…

---

## [Updating to the latest/newest NR - just asking](https://discourse.nodered.org/t/updating-to-the-latest-newest-nr-just-asking/68264)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 1\
**Last updated:** [27 September 2022 02:59 UTC](https://discourse.nodered.org/t/updating-to-the-latest-newest-nr-just-asking/68264 "2022-09-27T02:59:26Z")

</div>

Ok, I may seen to be a stubborn person with NR 2.x but it isn't without reason. Three machines are running 24/7 and I updated one to 2.2.2 and the dashboad to 3.1.6 Now (for a long time) when I deploy I get a message a…

---

## [Replace port with TCP In](https://discourse.nodered.org/t/replace-port-with-tcp-in/68268)

<div class="topic-metadata">

**Author:** [@lastheim](https://discourse.nodered.org/u/lastheim)\
**Replies:** 0\
**Last updated:** [27 September 2022 02:49 UTC](https://discourse.nodered.org/t/replace-port-with-tcp-in/68268 "2022-09-27T02:49:01Z")

</div>

Hi, How do replace the port in below code to the output from a TCP in node? I want the piping part to work in below code... import { connect } from 'net' // substitute 192.168.4.1 with the IP address of your module c…

---

## [The Node-Red with Apache2 - Reverse Proxy - Web Sockets Labyrinth](https://discourse.nodered.org/t/the-node-red-with-apache2-reverse-proxy-web-sockets-labyrinth/68263)

<div class="topic-metadata">

**Author:** [@mrSidX](https://discourse.nodered.org/u/mrSidX)\
**Replies:** 0\
**Last updated:** [27 September 2022 00:49 UTC](https://discourse.nodered.org/t/the-node-red-with-apache2-reverse-proxy-web-sockets-labyrinth/68263 "2022-09-27T00:49:44Z")

</div>

Summary of Issues: NR Proxy Routing in the Apache2 - conf files for Virtual Host, WSS connection errors, Cannot Click Inject Nodes, Dashboard "Not Loading" Scenario: I am consolidating multiple websites I host onto…

---

## [Hvac graphic animation gif format](https://discourse.nodered.org/t/hvac-graphic-animation-gif-format/68256)

<div class="topic-metadata">

**Author:** [@Gus83](https://discourse.nodered.org/u/Gus83)\
**Replies:** 4\
**Last updated:** [26 September 2022 21:25 UTC](https://discourse.nodered.org/t/hvac-graphic-animation-gif-format/68256 "2022-09-26T21:25:22Z")

</div>

hi all I would like to add some graphics to the dashboard this are gif's format and to put them together probably need canvas can someone help me with this any idea? i haven't done it yet but the point is when yo…

---

## [How to create payloads (strings merged/concatenated from array objects) from Excel data?](https://discourse.nodered.org/t/how-to-create-payloads-strings-merged-concatenated-from-array-objects-from-excel-data/68050)

<div class="topic-metadata">

**Author:** [@AleXSR700](https://discourse.nodered.org/u/AleXSR700)\
**Replies:** 19\
**Last updated:** [26 September 2022 20:07 UTC](https://discourse.nodered.org/t/how-to-create-payloads-strings-merged-concatenated-from-array-objects-from-excel-data/68050 "2022-09-26T20:07:03Z")

</div>

Hello everyone, I am just getting back into Node-Red and I am trying to send MQTT payloads. I have an Excel spreadsheet that contains one column with the topics and one column with the commands. I have read the excel…

---

## [Node-RED in a pro environment: version control, DevOps & no side effect](https://discourse.nodered.org/t/node-red-in-a-pro-environment-version-control-devops-no-side-effect/68261)

<div class="topic-metadata">

**Author:** [@hyamanieu](https://discourse.nodered.org/u/hyamanieu)\
**Replies:** 0\
**Last updated:** [26 September 2022 19:59 UTC](https://discourse.nodered.org/t/node-red-in-a-pro-environment-version-control-devops-no-side-effect/68261 "2022-09-26T19:59:00Z")

</div>

tl;dr: I am suggesting a solution to turn Node-RED into a production-ready environment. Any thoughts? Negative & positive feedbacks are welcome. Hello Node-RED community, working in a professional industrial environm…

---

## [Dashboard settings on backend page are empty](https://discourse.nodered.org/t/dashboard-settings-on-backend-page-are-empty/68255)

<div class="topic-metadata">

**Author:** [@SteffenRoessler](https://discourse.nodered.org/u/SteffenRoessler)\
**Replies:** 1\
**Last updated:** [26 September 2022 19:28 UTC](https://discourse.nodered.org/t/dashboard-settings-on-backend-page-are-empty/68255 "2022-09-26T19:28:20Z")

</div>

Hello all, i use Nodered 3.0.2 in a docker enviroment. It works very well an the dashboard UI is also working fine. But on the backend page the settings for the dashboard are empty. There is no entry visible. Dose so…

---

## [Why importing sometimes misses some nodes?](https://discourse.nodered.org/t/why-importing-sometimes-misses-some-nodes/67549)

<div class="topic-metadata">

**Author:** [@SeRiusRod](https://discourse.nodered.org/u/SeRiusRod)\
**Replies:** 15\
**Last updated:** [26 September 2022 19:25 UTC](https://discourse.nodered.org/t/why-importing-sometimes-misses-some-nodes/67549 "2022-09-26T19:25:25Z")

</div>

This is the original flow in one machine: And this is the same flow imported in a new machine: This has been happening to me since months. And sometimes it's very difficult to find if something is missing. In th…

---

## [Chart-Issue: Timestamp seems to be null](https://discourse.nodered.org/t/chart-issue-timestamp-seems-to-be-null/68216)

<div class="topic-metadata">

**Author:** [@Pinky](https://discourse.nodered.org/u/Pinky)\
**Replies:** 4\
**Last updated:** [26 September 2022 19:00 UTC](https://discourse.nodered.org/t/chart-issue-timestamp-seems-to-be-null/68216 "2022-09-26T19:00:34Z")

</div>

Good morning everybody, I am currently trying to feed a line chart with the values from an iobroker device. It is either true or false. I want to display the state in the line chart so I can see if the device was turned…

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

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