# Latest

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

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

**Page:** 1022

---

## [Is there a range limit for node-red-contrib-i2c 'i2c out' node?](https://discourse.nodered.org/t/is-there-a-range-limit-for-node-red-contrib-i2c-i2c-out-node/31458)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 4\
**Last updated:** [12 August 2020 14:37 UTC](https://discourse.nodered.org/t/is-there-a-range-limit-for-node-red-contrib-i2c-i2c-out-node/31458 "2020-08-12T14:37:10Z")

</div>

Is there a range limit for node-red-contrib-i2c 'i2c out' node payload value? Looking at the NR module node code I don't any defined limit for a single byte value to be defined as signed? It should be unsigned 0-255. …

---

## [So you have a tsl2591 sensor? Have I got a deal for you!](https://discourse.nodered.org/t/so-you-have-a-tsl2591-sensor-have-i-got-a-deal-for-you/31480)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 0\
**Last updated:** [12 August 2020 14:02 UTC](https://discourse.nodered.org/t/so-you-have-a-tsl2591-sensor-have-i-got-a-deal-for-you/31480 "2020-08-12T14:02:50Z")

</div>

The following flow can drive the tsl2591 light intensity sensor. This flow is a bit more involved, based on nodes, than functional code, this was done by design to better illustrate how to use the i2c nodes in NR. Refe…

---

## [Node maths help with two values](https://discourse.nodered.org/t/node-maths-help-with-two-values/31472)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 11\
**Last updated:** [12 August 2020 14:21 UTC](https://discourse.nodered.org/t/node-maths-help-with-two-values/31472 "2020-08-12T14:21:05Z")

</div>

I seem to really be suffering today with thinking. What I want to do in a function node: Get a context variable. (Say: value1) msg.payload is the second variable. (value2) Say they are both between 1 and 10. Ge…

---

## [A function with if is not working](https://discourse.nodered.org/t/a-function-with-if-is-not-working/31394)

<div class="topic-metadata">

**Author:** [@edstobi](https://discourse.nodered.org/u/edstobi)\
**Replies:** 10\
**Last updated:** [12 August 2020 14:18 UTC](https://discourse.nodered.org/t/a-function-with-if-is-not-working/31394 "2020-08-12T14:18:00Z")

</div>

Hi I nead help. I cant finde my error. the debug (msg.test : string\[2\] "01" ) the debug ( msg.out : clicked : msg.out : string\[20\] "10.11.12.144:8080/00") the debug ( msg.topic: clicked : msg.topic : string\[7\] "clic…

---

## [Logon authentication and token expiry](https://discourse.nodered.org/t/logon-authentication-and-token-expiry/31173)

<div class="topic-metadata">

**Author:** [@oywino](https://discourse.nodered.org/u/oywino)\
**Replies:** 9\
**Last updated:** [12 August 2020 11:30 UTC](https://discourse.nodered.org/t/logon-authentication-and-token-expiry/31173 "2020-08-12T11:30:55Z")

</div>

Initially I installed and used NR without any logon requirements. It worked OK. Then I established an admin user and a hashed pwd in settings.js. It worked OK the first time I tried, I was asked to type in the username …

---

## [Read historical data and makes reports on dashboard using REST API](https://discourse.nodered.org/t/read-historical-data-and-makes-reports-on-dashboard-using-rest-api/31431)

<div class="topic-metadata">

**Author:** [@V\_M](https://discourse.nodered.org/u/V_M)\
**Replies:** 4\
**Last updated:** [12 August 2020 11:24 UTC](https://discourse.nodered.org/t/read-historical-data-and-makes-reports-on-dashboard-using-rest-api/31431 "2020-08-12T11:24:35Z")

</div>

Hello Everyone, I want to make a dashboard where I can give an option to the user to select date intervals and fetch reports accordingly. ( Ex- Meter1 Duration Date - 5 Aug to 10 Aug Result = Amp = 2.0 kW= 1250 PF= 6594…

---

## [Node-red-node-sqlite using "Via msg.topic" reports ""Error: SQLITE\_RANGE: column index out of range""](https://discourse.nodered.org/t/node-red-node-sqlite-using-via-msg-topic-reports-error-sqlite-range-column-index-out-of-range/31462)

<div class="topic-metadata">

**Author:** [@janvda](https://discourse.nodered.org/u/janvda)\
**Replies:** 6\
**Last updated:** [12 August 2020 11:13 UTC](https://discourse.nodered.org/t/node-red-node-sqlite-using-via-msg-topic-reports-error-sqlite-range-column-index-out-of-range/31462 "2020-08-12T11:13:49Z")

</div>

My node-red-node-sqlite which is configured as reported error: Error: SQLITE\_RANGE: column index out of range when I am passing as input: WORKAROUND: I managed to fix this by deleting the msg.payload from my inp…

---

## [Sort node not working with split node](https://discourse.nodered.org/t/sort-node-not-working-with-split-node/31466)

<div class="topic-metadata">

**Author:** [@Sangoku](https://discourse.nodered.org/u/Sangoku)\
**Replies:** 1\
**Last updated:** [12 August 2020 10:59 UTC](https://discourse.nodered.org/t/sort-node-not-working-with-split-node/31466 "2020-08-12T10:59:28Z")

</div>

I am getting a collection of entities from Home Assistant and i am trying to sort the entities by name The sort function just wont sort the incoming data... any idea why? Here is the code: Here is one of the entities …

---

## [\`Range\` node setting values from variables](https://discourse.nodered.org/t/range-node-setting-values-from-variables/31428)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 17\
**Last updated:** [12 August 2020 10:53 UTC](https://discourse.nodered.org/t/range-node-setting-values-from-variables/31428 "2020-08-12T10:53:37Z")

</div>

I am wanting to use a range node but the scales need to be set by external values. I don't mind doing all this with a function node, but thought I would ask. (map is the command to basically do what the range node does…

---

## [Node-red-contrib-telegrambot complains chatId is empty](https://discourse.nodered.org/t/node-red-contrib-telegrambot-complains-chatid-is-empty/29908)

<div class="topic-metadata">

**Author:** [@dclear](https://discourse.nodered.org/u/dclear)\
**Replies:** 8\
**Last updated:** [12 August 2020 10:10 UTC](https://discourse.nodered.org/t/node-red-contrib-telegrambot-complains-chatid-is-empty/29908 "2020-08-12T10:10:29Z")

</div>

Trying to send myself a file using Telegram and the 'telegram sender' node is always moaning about chatId being missing - am I doing this wrong? \[{"id":"f9da9fc7.b66e6","type":"telegram sender","z":"85dfd613.ecdcc8","na…

---

## [Issue with IBM Node-Red Login](https://discourse.nodered.org/t/issue-with-ibm-node-red-login/30178)

<div class="topic-metadata">

**Author:** [@avinashchuahan](https://discourse.nodered.org/u/avinashchuahan)\
**Replies:** 2\
**Last updated:** [12 August 2020 07:55 UTC](https://discourse.nodered.org/t/issue-with-ibm-node-red-login/30178 "2020-08-12T07:55:16Z")

</div>

Hi All, This is the issue I am facing that every time I am providing the login credential in Node-Red Application,It again goes to the login page. I looked into the log file.I found an message like below. =\>GIven be…

---

## [Dashboard User input?](https://discourse.nodered.org/t/dashboard-user-input/31369)

<div class="topic-metadata">

**Author:** [@mhswa](https://discourse.nodered.org/u/mhswa)\
**Replies:** 9\
**Last updated:** [12 August 2020 07:30 UTC](https://discourse.nodered.org/t/dashboard-user-input/31369 "2020-08-12T07:30:58Z")

</div>

Hi All i am looking at building a dashboard in grafana/node red that will show data for our machineshop (Job Que, Capacity of maines etc..) i was wondering i need to display a live view of current job is it possible to…

---

## [Home Assistant Entity node sometimes errors](https://discourse.nodered.org/t/home-assistant-entity-node-sometimes-errors/31302)

<div class="topic-metadata">

**Author:** [@mellis](https://discourse.nodered.org/u/mellis)\
**Replies:** 2\
**Last updated:** [12 August 2020 01:39 UTC](https://discourse.nodered.org/t/home-assistant-entity-node-sometimes-errors/31302 "2020-08-12T01:39:18Z")

</div>

I'm using Node Red for to take a RESTful POST output and parse it out to various "edit entity nodes". I thought everything was working fine, but recently notices some "State must be defined" errors. They come and go as t…

---

## [Alexa Device not found](https://discourse.nodered.org/t/alexa-device-not-found/31448)

<div class="topic-metadata">

**Author:** [@asharratt](https://discourse.nodered.org/u/asharratt)\
**Replies:** 1\
**Last updated:** [11 August 2020 22:39 UTC](https://discourse.nodered.org/t/alexa-device-not-found/31448 "2020-08-11T22:39:14Z")

</div>

Hi All. Thanks for the add. I am totally new on node-red so please excuse any dumb questions I have Node-Red under HA on an rpi 4 which is wired to my Unifi UDM. I am trying to use the 'Alexa Home' node but it cant find…

---

## [Sanity check on my node-red version](https://discourse.nodered.org/t/sanity-check-on-my-node-red-version/31368)

<div class="topic-metadata">

**Author:** [@sjack](https://discourse.nodered.org/u/sjack)\
**Replies:** 15\
**Last updated:** [11 August 2020 22:07 UTC](https://discourse.nodered.org/t/sanity-check-on-my-node-red-version/31368 "2020-08-11T22:07:02Z")

</div>

I've been running Node-Red for years on a Raspberry Pi. I originally installed prior to version 1 coming out. I wanted to upgrade to the latest and did so. I've updated it previously, but it's been a while. I have a fee…

---

## [Reading single row in csv file](https://discourse.nodered.org/t/reading-single-row-in-csv-file/31432)

<div class="topic-metadata">

**Author:** [@Ward](https://discourse.nodered.org/u/Ward)\
**Replies:** 1\
**Last updated:** [11 August 2020 20:51 UTC](https://discourse.nodered.org/t/reading-single-row-in-csv-file/31432 "2020-08-11T20:51:26Z")

</div>

Hi, Is it possible to select and read a single row in a csv file? I have a csv document with the text of all my alarms (automatic generated so that's why i start from this file source) and now i want only read the row …

---

## [Anyone using appy pie to connect to node-red?](https://discourse.nodered.org/t/anyone-using-appy-pie-to-connect-to-node-red/31445)

<div class="topic-metadata">

**Author:** [@mattk](https://discourse.nodered.org/u/mattk)\
**Replies:** 0\
**Last updated:** [11 August 2020 20:26 UTC](https://discourse.nodered.org/t/anyone-using-appy-pie-to-connect-to-node-red/31445 "2020-08-11T20:26:33Z")

</div>

Hi, been using Blynk for a while to connect to my node-red @pi. I'm reviewing moving node-red host to the cloud for better availability and connectivity, as well as more users connecting to the systems I have integrated…

---

## [How to insert multiple data into the correct field of mysql database](https://discourse.nodered.org/t/how-to-insert-multiple-data-into-the-correct-field-of-mysql-database/11139)

<div class="topic-metadata">

**Author:** [@Jimjiy](https://discourse.nodered.org/u/Jimjiy)\
**Replies:** 7\
**Last updated:** [11 August 2020 18:59 UTC](https://discourse.nodered.org/t/how-to-insert-multiple-data-into-the-correct-field-of-mysql-database/11139 "2020-08-11T18:59:26Z")

</div>

Hello, i am trying to insert multiple data into a mysql database but i am unable to insert them into the correct field here is my flow diagram here is how i've written my node function... msg.topic="INSERT Into fire\_…

---

## [Exec bug? Design limit? Or Editor limit? Lyons, Tigers, and Bears](https://discourse.nodered.org/t/exec-bug-design-limit-or-editor-limit-lyons-tigers-and-bears/31418)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 10\
**Last updated:** [11 August 2020 18:23 UTC](https://discourse.nodered.org/t/exec-bug-design-limit-or-editor-limit-lyons-tigers-and-bears/31418 "2020-08-11T18:23:49Z")

</div>

Ok, I could not resist the Lyons, Tigers, and Bears humor... I have seen a few forum references to exec node dropping stdout, such that what is outputted is just part of what stdout should be, as compared to say output …

---

## [Memory issue in nodered](https://discourse.nodered.org/t/memory-issue-in-nodered/31421)

<div class="topic-metadata">

**Author:** [@SiddharthJoshi](https://discourse.nodered.org/u/SiddharthJoshi)\
**Replies:** 5\
**Last updated:** [11 August 2020 14:15 UTC](https://discourse.nodered.org/t/memory-issue-in-nodered/31421 "2020-08-11T14:15:54Z")

</div>

Raising this topic in continuation of my old topic as it got closed. As I haven't found solution yet, I was thinking if I could do something different to reduce the memory usage. I would like to know if any of the be…

---

## [How to control HTML5 Audio Element from UI-Template?](https://discourse.nodered.org/t/how-to-control-html5-audio-element-from-ui-template/31430)

<div class="topic-metadata">

**Author:** [@Herold](https://discourse.nodered.org/u/Herold)\
**Replies:** 1\
**Last updated:** [11 August 2020 14:04 UTC](https://discourse.nodered.org/t/how-to-control-html5-audio-element-from-ui-template/31430 "2020-08-11T14:04:50Z")

</div>

I'm a newbie. Would like some example code to get DOM Audio element basic custom control (play() / pause() methods from a button or clickable image) on HTML5 audio element rendered in browser. I succeed to play audio f…

---

## [Need help getting xml "i:type" value into node red](https://discourse.nodered.org/t/need-help-getting-xml-i-type-value-into-node-red/31403)

<div class="topic-metadata">

**Author:** [@sedgington](https://discourse.nodered.org/u/sedgington)\
**Replies:** 6\
**Last updated:** [11 August 2020 13:16 UTC](https://discourse.nodered.org/t/need-help-getting-xml-i-type-value-into-node-red/31403 "2020-08-11T13:16:18Z")

</div>

Hi, I'm hoping someone can help me with a perplexing problem I'm having getting a value out of xml.I'm trying to pull specific values out of an xml document and publish them to a csv file. I've had no problem with getti…

---

## [Copying dashboard TABs - is it possible?](https://discourse.nodered.org/t/copying-dashboard-tabs-is-it-possible/15500)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 8\
**Last updated:** [11 August 2020 11:10 UTC](https://discourse.nodered.org/t/copying-dashboard-tabs-is-it-possible/15500 "2020-08-11T11:10:59Z")

</div>

I have designed a layout which I am repeating on my dashboards. I have made a GUI with buttons and a layout and would like to know if there is a way rather than selecting all the nodes and copying all the nodes and re-p…

---

## [Node red minimun configuration](https://discourse.nodered.org/t/node-red-minimun-configuration/31416)

<div class="topic-metadata">

**Author:** [@varunyc](https://discourse.nodered.org/u/varunyc)\
**Replies:** 4\
**Last updated:** [11 August 2020 10:21 UTC](https://discourse.nodered.org/t/node-red-minimun-configuration/31416 "2020-08-11T10:21:01Z")

</div>

Dear Friends, I am Varun and very much new to the Node-red. I am looking for a board which has the following capacity It should have 4g mobile connectivity We should be able to install Node-RED on the board. Could yo…

---

## [Uibuilder riot not found](https://discourse.nodered.org/t/uibuilder-riot-not-found/31387)

<div class="topic-metadata">

**Author:** [@StefanSchmelz](https://discourse.nodered.org/u/StefanSchmelz)\
**Replies:** 5\
**Last updated:** [11 August 2020 08:41 UTC](https://discourse.nodered.org/t/uibuilder-riot-not-found/31387 "2020-08-11T08:41:14Z")

</div>

Hi Folks, I followed the following uibuilder wiki page about using riotjs. The simple html part in index.html works just fine, but nothing happens! I made shure to follow every step in the tutorial. Taking a look…

---

## [SEPIA Open Assistant - Privacy respecting, self-hosted voice-control](https://discourse.nodered.org/t/sepia-open-assistant-privacy-respecting-self-hosted-voice-control/28238)

<div class="topic-metadata">

**Author:** [@sepia-assistant](https://discourse.nodered.org/u/sepia-assistant)\
**Replies:** 15\
**Last updated:** [11 August 2020 08:34 UTC](https://discourse.nodered.org/t/sepia-open-assistant-privacy-respecting-self-hosted-voice-control/28238 "2020-08-11T08:34:51Z")

</div>

Hello everybody, I'd like to introduce you to a project of mine called SEPIA Open Assistant. SEPIA is an open-source, self-hosted digital voice assistant that works on your mobile phone (similar to Google Assistant) an…

---

## [TypeError: Cannot set property 'latitude' of undefined](https://discourse.nodered.org/t/typeerror-cannot-set-property-latitude-of-undefined/31337)

<div class="topic-metadata">

**Author:** [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Replies:** 7\
**Last updated:** [11 August 2020 07:21 UTC](https://discourse.nodered.org/t/typeerror-cannot-set-property-latitude-of-undefined/31337 "2020-08-11T07:21:23Z")

</div>

Hi, I have a msg from TTN - I want to extract msg.payload\_fields.latitudeDeg and msg.payload\_fields.ongitudeDeg - but I get a error - "TypeError: Cannot set property 'latitude' of undefined" My function node: The m…

---

## [Bcrypt generate /](https://discourse.nodered.org/t/bcrypt-generate/31399)

<div class="topic-metadata">

**Author:** [@josekavunkal](https://discourse.nodered.org/u/josekavunkal)\
**Replies:** 2\
**Last updated:** [11 August 2020 05:31 UTC](https://discourse.nodered.org/t/bcrypt-generate/31399 "2020-08-11T05:31:05Z")

</div>

I am using bcrypt node to create a encoded password and this is updated in settings.js programatically. Sometimes the encrypted password have / (slash) and when I write this to file it encode it and it will result in p…

---

## [Json with hyphen](https://discourse.nodered.org/t/json-with-hyphen/31424)

<div class="topic-metadata">

**Author:** [@spidgrou](https://discourse.nodered.org/u/spidgrou)\
**Replies:** 2\
**Last updated:** [11 August 2020 05:47 UTC](https://discourse.nodered.org/t/json-with-hyphen/31424 "2020-08-11T05:47:43Z")

</div>

I have an object coming from MQTT, inside the Json there is some hyphen and I'm not able to read it. I cannot understand where is my error. \[{"id":"6d828b17.342db4","type":"inject","z":"3c5213a5.c4284c","name":"","prop…

---

## [Install Node-RED with Docker or with Node.js or using Home Assistant (Video Tutorial)](https://discourse.nodered.org/t/install-node-red-with-docker-or-with-node-js-or-using-home-assistant-video-tutorial/31420)

<div class="topic-metadata">

**Author:** [@KPeyanski](https://discourse.nodered.org/u/KPeyanski)\
**Replies:** 0\
**Last updated:** [11 August 2020 03:52 UTC](https://discourse.nodered.org/t/install-node-red-with-docker-or-with-node-js-or-using-home-assistant-video-tutorial/31420 "2020-08-11T03:52:35Z")

</div>

This content is for Node-RED beginners where I will show you not one, but three different ways to install Node-RED, so you can choose which one is the best for you. On top I will show you how to integrate Node-RED with H…

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

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