# Latest

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

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

**Page:** 765

---

## [Exec node write stderr to Logbook service (HomeAssistant)](https://discourse.nodered.org/t/exec-node-write-stderr-to-logbook-service-homeassistant/48992)

<div class="topic-metadata">

**Author:** [@cshuttle](https://discourse.nodered.org/u/cshuttle)\
**Replies:** 0\
**Last updated:** [28 July 2021 01:34 UTC](https://discourse.nodered.org/t/exec-node-write-stderr-to-logbook-service-homeassistant/48992 "2021-07-28T01:34:01Z")

</div>

I'm using 1.3.5 embedded in to HomeAssistant. I'm running the following code to trigger a backup to GH, and I would like to log the event outcome to the HomeAssistant Logbook service. I am able to write to the Logbook s…

---

## [Export excel from MS SQL Server 2019](https://discourse.nodered.org/t/export-excel-from-ms-sql-server-2019/48949)

<div class="topic-metadata">

**Author:** [@chihiep11](https://discourse.nodered.org/u/chihiep11)\
**Replies:** 2\
**Last updated:** [28 July 2021 00:53 UTC](https://discourse.nodered.org/t/export-excel-from-ms-sql-server-2019/48949 "2021-07-28T00:53:59Z")

</div>

The title says it all. Command: EXEC sp\_configure 'show advanced options', 1 RECONFIGURE GO EXEC sp\_configure 'ad hoc distributed queries', 1 RECONFIGURE GO INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Ex…

---

## [Callback when nodes are cloned](https://discourse.nodered.org/t/callback-when-nodes-are-cloned/48967)

<div class="topic-metadata">

**Author:** [@petrus](https://discourse.nodered.org/u/petrus)\
**Replies:** 1\
**Last updated:** [27 July 2021 20:31 UTC](https://discourse.nodered.org/t/callback-when-nodes-are-cloned/48967 "2021-07-27T20:31:04Z")

</div>

Hi! Can I have execute some code when I cloned some nodes? I need this to generate new names in components to ensure that there is not duplicated names.

---

## [Link in/link out R-PI bug](https://discourse.nodered.org/t/link-in-link-out-r-pi-bug/48965)

<div class="topic-metadata">

**Author:** [@dsplitz](https://discourse.nodered.org/u/dsplitz)\
**Replies:** 14\
**Last updated:** [27 July 2021 20:30 UTC](https://discourse.nodered.org/t/link-in-link-out-r-pi-bug/48965 "2021-07-27T20:30:44Z")

</div>

When I connect multiple link in nodes to a single link out node I see a memory leak on my R-PI 4 using the R-PI task manager. I'm using \[1.3.4 Maintenance Release\] I don't see the issue if I only connect 1 link in to …

---

## [Http request returning a partial response](https://discourse.nodered.org/t/http-request-returning-a-partial-response/48981)

<div class="topic-metadata">

**Author:** [@brunoamaral](https://discourse.nodered.org/u/brunoamaral)\
**Replies:** 0\
**Last updated:** [27 July 2021 20:17 UTC](https://discourse.nodered.org/t/http-request-returning-a-partial-response/48981 "2021-07-27T20:17:04Z")

</div>

I'm using the HTTP Request node with some custom headers such as these: msg.headers\['Connection'\] = 'keep-alive' msg.headers\['Pragma'\] = 'no-cache' msg.headers\['Cache-Control'\] = 'no-cache' msg.headers\['Accept…

---

## [Error on close, save, restart of node-red](https://discourse.nodered.org/t/error-on-close-save-restart-of-node-red/48963)

<div class="topic-metadata">

**Author:** [@justin](https://discourse.nodered.org/u/justin)\
**Replies:** 2\
**Last updated:** [27 July 2021 19:29 UTC](https://discourse.nodered.org/t/error-on-close-save-restart-of-node-red/48963 "2021-07-27T19:29:38Z")

</div>

I have a scenario where I have a bunch of custom nodes that I created that leverage a configuration node. I built the configuration node to run against the @elasticsearch/elasticsearch nodejs client lib. It has worked gr…

---

## [Modbus node installation failing](https://discourse.nodered.org/t/modbus-node-installation-failing/48974)

<div class="topic-metadata">

**Author:** [@ceejm1](https://discourse.nodered.org/u/ceejm1)\
**Replies:** 1\
**Last updated:** [27 July 2021 19:04 UTC](https://discourse.nodered.org/t/modbus-node-installation-failing/48974 "2021-07-27T19:04:51Z")

</div>

Hello, I am trying to install the modbus node. I've had no issues on other machines but this is throwing this error. Any guidance would be much appreciated. Thanks James 2021-07-27T17:34:40.982Z Install : node-red-…

---

## [Help| how to add timestamp into csv file](https://discourse.nodered.org/t/help-how-to-add-timestamp-into-csv-file/48973)

<div class="topic-metadata">

**Author:** [@puteramelaka](https://discourse.nodered.org/u/puteramelaka)\
**Replies:** 9\
**Last updated:** [27 July 2021 17:59 UTC](https://discourse.nodered.org/t/help-how-to-add-timestamp-into-csv-file/48973 "2021-07-27T17:59:22Z")

</div>

Hello all, recently i have manage to split data from MQTT and saved as CSV ,thanks to forum member that really kind and helpfull. For now i want to do is add timestamp(if im not mistaken) which add date and time of data…

---

## [\[SOLVED\] UI Tab Disabled, but Enabled](https://discourse.nodered.org/t/solved-ui-tab-disabled-but-enabled/48964)

<div class="topic-metadata">

**Author:** [@ChZeman](https://discourse.nodered.org/u/ChZeman)\
**Replies:** 2\
**Last updated:** [27 July 2021 17:19 UTC](https://discourse.nodered.org/t/solved-ui-tab-disabled-but-enabled/48964 "2021-07-27T17:19:48Z")

</div>

I have a simple dashboard the suddenly stopped working over the weekend. The tab is enabled, but Node Red says it's disabled. ??? Thank you, Chris

---

## [Combine two messages with two topics](https://discourse.nodered.org/t/combine-two-messages-with-two-topics/48969)

<div class="topic-metadata">

**Author:** [@myozone](https://discourse.nodered.org/u/myozone)\
**Replies:** 4\
**Last updated:** [27 July 2021 16:31 UTC](https://discourse.nodered.org/t/combine-two-messages-with-two-topics/48969 "2021-07-27T16:31:58Z")

</div>

I've got a flow that creates two values with two topics and I would like to divide one by the other. Basically I've forgotten how to do it :roll\_eyes: The two topics are "on" and "off" which the payload is the on and of…

---

## [Add Monaco Editor - how?](https://discourse.nodered.org/t/add-monaco-editor-how/48896)

<div class="topic-metadata">

**Author:** [@vikozo](https://discourse.nodered.org/u/vikozo)\
**Replies:** 13\
**Last updated:** [27 July 2021 15:38 UTC](https://discourse.nodered.org/t/add-monaco-editor-how/48896 "2021-07-27T15:38:39Z")

</div>

hello on a VM i installed node Red 2 so far it works! i wish to change to the monaco editor node-red -v \[info\] Einstellungsdatei: /root/.node-red/settings.js so i edited the file and aroud line 353 i changed the li…

---

## [Reluctantly asking for help how to handle huge data files](https://discourse.nodered.org/t/reluctantly-asking-for-help-how-to-handle-huge-data-files/48959)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 9\
**Last updated:** [27 July 2021 14:48 UTC](https://discourse.nodered.org/t/reluctantly-asking-for-help-how-to-handle-huge-data-files/48959 "2021-07-27T14:48:38Z")

</div>

Maybe because the "log files" are Node-Red generated I should ask here. For the past 18 months - or there about - I have been logging the temperature every.... 30 seconds. The file is text and is time stamped. So an e…

---

## [OPC-UA stop node-red process](https://discourse.nodered.org/t/opc-ua-stop-node-red-process/48631)

<div class="topic-metadata">

**Author:** [@Massimo](https://discourse.nodered.org/u/Massimo)\
**Replies:** 1\
**Last updated:** [27 July 2021 14:40 UTC](https://discourse.nodered.org/t/opc-ua-stop-node-red-process/48631 "2021-07-27T14:40:01Z")

</div>

Hello! I'm having this problem. I've created a flow with OPC-UA READ node. After deploying it start with these warning in the console: client\_session\_keepalive\_manag:114 warning : ClientSessionKeepAliveManager#pin…

---

## [Stopping the Flow](https://discourse.nodered.org/t/stopping-the-flow/48926)

<div class="topic-metadata">

**Author:** [@ArunKarkare](https://discourse.nodered.org/u/ArunKarkare)\
**Replies:** 5\
**Last updated:** [27 July 2021 14:39 UTC](https://discourse.nodered.org/t/stopping-the-flow/48926 "2021-07-27T14:39:48Z")

</div>

HI .. I am absolutely RAW and new to NODE-RED programming. I created a Flashing LED program as Flow1 with half second ON and half second OFF that works fine, next I created Alternately flashing two LEDs at 1 second rate…

---

## [Deployment management](https://discourse.nodered.org/t/deployment-management/48771)

<div class="topic-metadata">

**Author:** [@blunoz](https://discourse.nodered.org/u/blunoz)\
**Replies:** 14\
**Last updated:** [27 July 2021 13:08 UTC](https://discourse.nodered.org/t/deployment-management/48771 "2021-07-27T13:08:25Z")

</div>

Hey all, I’m wondering what solutions people are using for managing deployments on multiple systems that need to run the same project. Ideally I’d like to be able to remotely deploy a complete configuration to a new mach…

---

## [How to calculate CRC-16 (Modbus)?](https://discourse.nodered.org/t/how-to-calculate-crc-16-modbus/48955)

<div class="topic-metadata">

**Author:** [@quemf](https://discourse.nodered.org/u/quemf)\
**Replies:** 6\
**Last updated:** [27 July 2021 10:54 UTC](https://discourse.nodered.org/t/how-to-calculate-crc-16-modbus/48955 "2021-07-27T10:54:06Z")

</div>

Hi everyone, I am trying to calculate CRC with a function I got from Node-RED forum, but when there is a 0 at the end or at the beginning of the CRC, it does not identify it, and I just get three bytes. The fact is tha…

---

## [Extract specific data](https://discourse.nodered.org/t/extract-specific-data/48958)

<div class="topic-metadata">

**Author:** [@wael5300](https://discourse.nodered.org/u/wael5300)\
**Replies:** 1\
**Last updated:** [27 July 2021 10:20 UTC](https://discourse.nodered.org/t/extract-specific-data/48958 "2021-07-27T10:20:25Z")

</div>

How to extract/write specific data from msg.payload? I have send data to node-red and I want to deal with each data separately. msg.payload.temperature?

---

## [Bar chart formatting](https://discourse.nodered.org/t/bar-chart-formatting/48538)

<div class="topic-metadata">

**Author:** [@JoshuaG](https://discourse.nodered.org/u/JoshuaG)\
**Replies:** 5\
**Last updated:** [27 July 2021 08:56 UTC](https://discourse.nodered.org/t/bar-chart-formatting/48538 "2021-07-27T08:56:33Z")

</div>

I'll have done this topic to the death shortly. I have 10 charts on a UI page, each with the same code powering them just with a different payload variable gotten from the global context, in the picture below you can se…

---

## [Econnrefused in node SQL](https://discourse.nodered.org/t/econnrefused-in-node-sql/48946)

<div class="topic-metadata">

**Author:** [@nam1702](https://discourse.nodered.org/u/nam1702)\
**Replies:** 1\
**Last updated:** [27 July 2021 08:51 UTC](https://discourse.nodered.org/t/econnrefused-in-node-sql/48946 "2021-07-27T08:51:40Z")

</div>

hello everyone! I have I file.json, when I import it into my nodered and node SQL doesn't work (econnrefused). I try to use the same user and passwork with person who exported this file but it's still doesn't work. So c…

---

## [HTTPS - Self-signed - bad decrypt](https://discourse.nodered.org/t/https-self-signed-bad-decrypt/48956)

<div class="topic-metadata">

**Author:** [@Alelav79](https://discourse.nodered.org/u/Alelav79)\
**Replies:** 0\
**Last updated:** [27 July 2021 08:48 UTC](https://discourse.nodered.org/t/https-self-signed-bad-decrypt/48956 "2021-07-27T08:48:16Z")

</div>

Hello, i've problem with self-signed certicate . I created files .pem with openssl req -x509 -newkey rsa:4096 -keyout privkey.pem -out cert.pem -days 1095 And the logs shows this problem : 0|node-red | Failed to ge…

---

## [MQTT Publish Node](https://discourse.nodered.org/t/mqtt-publish-node/48952)

<div class="topic-metadata">

**Author:** [@wael5300](https://discourse.nodered.org/u/wael5300)\
**Replies:** 2\
**Last updated:** [27 July 2021 08:45 UTC](https://discourse.nodered.org/t/mqtt-publish-node/48952 "2021-07-27T08:45:34Z")

</div>

In the case of using MQTT Publish Node and do some calculation(+,-,/,\*..etc) on data. How to do mathematic on data? Should I use a change node or function node and what should I write on it?

---

## [Repeating incoming message for mytimeout-node](https://discourse.nodered.org/t/repeating-incoming-message-for-mytimeout-node/48917)

<div class="topic-metadata">

**Author:** [@freiheit2018](https://discourse.nodered.org/u/freiheit2018)\
**Replies:** 6\
**Last updated:** [27 July 2021 07:35 UTC](https://discourse.nodered.org/t/repeating-incoming-message-for-mytimeout-node/48917 "2021-07-27T07:35:57Z")

</div>

Hi there, I have created a small example dashboard, that shows my problem. I use mytimeout-node as a countdown timer. The duration-time needs to be able to be set via the dashboard, which I accomplished. I then have four…

---

## [Git not found when starting as service](https://discourse.nodered.org/t/git-not-found-when-starting-as-service/48951)

<div class="topic-metadata">

**Author:** [@diedder](https://discourse.nodered.org/u/diedder)\
**Replies:** 0\
**Last updated:** [27 July 2021 06:41 UTC](https://discourse.nodered.org/t/git-not-found-when-starting-as-service/48951 "2021-07-27T06:41:40Z")

</div>

Hi, I've installed Node-Red v2.0.3 on a VM in Oracle Cloud und manually Installed Git V2.x as described here ORACLE-BASE - Git 2.x Installation on Linux When starting NR manually at bash everything is finde, the projec…

---

## [Struggling with function prototypes for new node](https://discourse.nodered.org/t/struggling-with-function-prototypes-for-new-node/48869)

<div class="topic-metadata">

**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\
**Replies:** 11\
**Last updated:** [27 July 2021 05:44 UTC](https://discourse.nodered.org/t/struggling-with-function-prototypes-for-new-node/48869 "2021-07-27T05:44:38Z")

</div>

Hi folks, I am struggling with some basic Javascript knowledge, to build a new node where I need modules for the first time extensively: In file myFunctionFile.js, a function is exported:module.exports = function myFu…

---

## [Uibuilder security](https://discourse.nodered.org/t/uibuilder-security/48635)

<div class="topic-metadata">

**Author:** [@Janna](https://discourse.nodered.org/u/Janna)\
**Replies:** 2\
**Last updated:** [27 July 2021 05:31 UTC](https://discourse.nodered.org/t/uibuilder-security/48635 "2021-07-27T05:31:22Z")

</div>

Hello, I am trying to secure a uibuilder site with the help of the built-in security. I have built a small example from the default page. Actually, when the button is pressed, a record should be read from a database and…

---

## [XML value of all data](https://discourse.nodered.org/t/xml-value-of-all-data/48937)

<div class="topic-metadata">

**Author:** [@madmax](https://discourse.nodered.org/u/madmax)\
**Replies:** 9\
**Last updated:** [27 July 2021 04:56 UTC](https://discourse.nodered.org/t/xml-value-of-all-data/48937 "2021-07-27T04:56:26Z")

</div>

Hello! I have an XML file. How can I filter this value of all data? payload.HRC\_STOCK.PRODUCT \[0\] https://www.hrcdistribution.com/xml/xml\_feed\_stock.php?c=8407

---

## [How do I get to the content of this payload?](https://discourse.nodered.org/t/how-do-i-get-to-the-content-of-this-payload/48947)

<div class="topic-metadata">

**Author:** [@benflux](https://discourse.nodered.org/u/benflux)\
**Replies:** 1\
**Last updated:** [27 July 2021 04:27 UTC](https://discourse.nodered.org/t/how-do-i-get-to-the-content-of-this-payload/48947 "2021-07-27T04:27:22Z")

</div>

I've got an iCal node that is returning the content in the screenshot below, it returns an object in an array\[1\] when there is an upcoming event that matches the filtering criteria I've given the node and I want to then …

---

## [Uibuilder load components](https://discourse.nodered.org/t/uibuilder-load-components/48910)

<div class="topic-metadata">

**Author:** [@T3chn0](https://discourse.nodered.org/u/T3chn0)\
**Replies:** 4\
**Last updated:** [26 July 2021 23:33 UTC](https://discourse.nodered.org/t/uibuilder-load-components/48910 "2021-07-26T23:33:33Z")

</div>

Hi, i 'm trying to load a component lets say component.vue in the index.js i have added: components:{ 'formlogin': httpVueLoader('formlogin.vue') }, also have installed in front end libraries and from console the vu…

---

## [How can I recover my flows from a bad SD card from a PI 3b\_ SD card](https://discourse.nodered.org/t/how-can-i-recover-my-flows-from-a-bad-sd-card-from-a-pi-3b-sd-card/48887)

<div class="topic-metadata">

**Author:** [@ronbu](https://discourse.nodered.org/u/ronbu)\
**Replies:** 20\
**Last updated:** [26 July 2021 23:05 UTC](https://discourse.nodered.org/t/how-can-i-recover-my-flows-from-a-bad-sd-card-from-a-pi-3b-sd-card/48887 "2021-07-26T23:05:08Z")

</div>

Ok my bad I do not have a backup of the SD card from my PI 3b+. The card crashed and had ALL my flows and Arduino code. I have a new install on a NEW SD card setup and SD reader attached to the PI. I can see the SD ca…

---

## [Unable to insert HTML button from JavaScript](https://discourse.nodered.org/t/unable-to-insert-html-button-from-javascript/48795)

<div class="topic-metadata">

**Author:** [@aadam](https://discourse.nodered.org/u/aadam)\
**Replies:** 6\
**Last updated:** [26 July 2021 22:49 UTC](https://discourse.nodered.org/t/unable-to-insert-html-button-from-javascript/48795 "2021-07-26T22:49:23Z")

</div>

Hello, I'm fairly new to Node Red and am working to create a dynamic UI interface. I'm trying to send the code for button from a function node and execute it inside a UI template Node. What confusing me is why the but…

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

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