# General

**URL:** https://discourse.nodered.org/c/general/7.md?page=580

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

**Page:** 581

---

## [Invert bits binary](https://discourse.nodered.org/t/invert-bits-binary/43226)

<div class="topic-metadata">

**Author:** [@raulrodca](https://discourse.nodered.org/u/raulrodca)\
**Replies:** 3\
**Last updated:** [26 March 2021 08:26 UTC](https://discourse.nodered.org/t/invert-bits-binary/43226 "2021-03-26T08:26:59Z")

</div>

hello good, I wanted to be able to change the order of the bits for their correct reading. When I want it to get a 1 in binary, it represents it to me in the following way What I wish is for it to be positioned corre…

---

## [Round a value in a function node](https://discourse.nodered.org/t/round-a-value-in-a-function-node/829)

<div class="topic-metadata">

**Author:** [@YT2310](https://discourse.nodered.org/u/YT2310)\
**Replies:** 4\
**Last updated:** [26 March 2021 08:18 UTC](https://discourse.nodered.org/t/round-a-value-in-a-function-node/829 "2021-03-26T08:18:24Z")

</div>

Hello community, could any one help me, Round a value in a function? Math.round(value,2) doesn t work

---

## [NodeRED SQLite data hashing](https://discourse.nodered.org/t/nodered-sqlite-data-hashing/43211)

<div class="topic-metadata">

**Author:** [@SKA](https://discourse.nodered.org/u/SKA)\
**Replies:** 1\
**Last updated:** [26 March 2021 00:20 UTC](https://discourse.nodered.org/t/nodered-sqlite-data-hashing/43211 "2021-03-26T00:20:14Z")

</div>

Hello, just a general question that I wanted to ask. Does anyone knows how to hash data that is being stored in the database. I searched online, but all I found was how to download, create and attach your db with your f…

---

## [Send msg.payload value to another node](https://discourse.nodered.org/t/send-msg-payload-value-to-another-node/43203)

<div class="topic-metadata">

**Author:** [@fikerplunk](https://discourse.nodered.org/u/fikerplunk)\
**Replies:** 7\
**Last updated:** [25 March 2021 22:07 UTC](https://discourse.nodered.org/t/send-msg-payload-value-to-another-node/43203 "2021-03-25T22:07:06Z")

</div>

Hi! I have this flow that sends data from the firestore to the split node, which separates each key, so I have this function that creates a string using the keys and sends it to another node of the firestore, so I can p…

---

## [Error installing "node-red-node-arduino 0.3.1"](https://discourse.nodered.org/t/error-installing-node-red-node-arduino-0-3-1/43153)

<div class="topic-metadata">

**Author:** [@tejas\_45](https://discourse.nodered.org/u/tejas_45)\
**Replies:** 6\
**Last updated:** [25 March 2021 21:48 UTC](https://discourse.nodered.org/t/error-installing-node-red-node-arduino-0-3-1/43153 "2021-03-25T21:48:00Z")

</div>

i have try to install C:\\Windows\\system32\>npm install node-red-node-arduino npm WARN deprecated bcrypt@3.0.6: versions \< v5.0.0 do not handle NUL in passwords properly npm WARN deprecated bcrypt@3.0.8: versions \< v5.0…

---

## [Error executing vcgencmd after node-red upgrade](https://discourse.nodered.org/t/error-executing-vcgencmd-after-node-red-upgrade/40554)

<div class="topic-metadata">

**Author:** [@DannyBoyKN](https://discourse.nodered.org/u/DannyBoyKN)\
**Replies:** 7\
**Last updated:** [25 March 2021 21:08 UTC](https://discourse.nodered.org/t/error-executing-vcgencmd-after-node-red-upgrade/40554 "2021-03-25T21:08:47Z")

</div>

I'm already using node-red on my RPi4 and setup flows to generate a dashboard showing the Pi's memory and cpu load as well as its temperatures. In the past I got problems getting the vcgencmd running in the node-red dock…

---

## [How to Add objects in address space?](https://discourse.nodered.org/t/how-to-add-objects-in-address-space/16734)

<div class="topic-metadata">

**Author:** [@Piyush](https://discourse.nodered.org/u/Piyush)\
**Replies:** 10\
**Last updated:** [25 March 2021 17:05 UTC](https://discourse.nodered.org/t/how-to-add-objects-in-address-space/16734 "2021-03-25T17:05:19Z")

</div>

I created an OPC server using iiot contrib nodes. There are predefined objects inside it. How can I create my own objects and add it in the OPC server. I've tried the following. I'm able to create folders and collectio…

---

## [Rockwell Contrologix string issue to dashboard](https://discourse.nodered.org/t/rockwell-contrologix-string-issue-to-dashboard/43087)

<div class="topic-metadata">

**Author:** [@Industrialogics](https://discourse.nodered.org/u/Industrialogics)\
**Replies:** 15\
**Last updated:** [25 March 2021 14:38 UTC](https://discourse.nodered.org/t/rockwell-contrologix-string-issue-to-dashboard/43087 "2021-03-25T14:38:35Z")

</div>

Get following debug error... but reads string one time to dashboard, then won't repeat read at set intervals.... "Error connecting to PLC: Error: Controller requires IP\_ADDR !!!"

---

## [Msg.payload to number for InfluxDB for Grafana](https://discourse.nodered.org/t/msg-payload-to-number-for-influxdb-for-grafana/43164)

<div class="topic-metadata">

**Author:** [@kelvins](https://discourse.nodered.org/u/kelvins)\
**Replies:** 7\
**Last updated:** [25 March 2021 13:58 UTC](https://discourse.nodered.org/t/msg-payload-to-number-for-influxdb-for-grafana/43164 "2021-03-25T13:58:13Z")

</div>

Hi all, I am struggling to convert the msg.payload to be used as a number when writing to InfluxDB. I currently send data to MQTT and my payload/content is just numbers, example 65 and under the 'change node' I have se…

---

## [Nodered as internetradio](https://discourse.nodered.org/t/nodered-as-internetradio/43134)

<div class="topic-metadata">

**Author:** [@automati](https://discourse.nodered.org/u/automati)\
**Replies:** 8\
**Last updated:** [25 March 2021 13:42 UTC](https://discourse.nodered.org/t/nodered-as-internetradio/43134 "2021-03-25T13:42:38Z")

</div>

Hello everyone, I'm new here and also brand new to the topic of node red. I have a shelly actuator at home which I want to use to turn my radio on and off. Do any of you have any ideas how I can do that? Maybe I can acce…

---

## [Creating a table with a certain number of rows](https://discourse.nodered.org/t/creating-a-table-with-a-certain-number-of-rows/43151)

<div class="topic-metadata">

**Author:** [@oussama5](https://discourse.nodered.org/u/oussama5)\
**Replies:** 5\
**Last updated:** [25 March 2021 13:24 UTC](https://discourse.nodered.org/t/creating-a-table-with-a-certain-number-of-rows/43151 "2021-03-25T13:24:03Z")

</div>

Hello guys, i wish everyone is ok. i have a project that consist me to create a table which it should be fill in with data(rows); The data is extracted from a database node with the help of a function node and an inject…

---

## [Converting/ Rebuilding Array of Objects {different length}](https://discourse.nodered.org/t/converting-rebuilding-array-of-objects-different-length/43190)

<div class="topic-metadata">

**Author:** [@Eintracht00](https://discourse.nodered.org/u/Eintracht00)\
**Replies:** 6\
**Last updated:** [25 March 2021 12:00 UTC](https://discourse.nodered.org/t/converting-rebuilding-array-of-objects-different-length/43190 "2021-03-25T12:00:55Z")

</div>

Hey, I get data from MSSQL with this code where the payload is the all entries of the named "key" This is the SELECT-Code: The payload I get is an array with all entries of named "key" I selected: Now i want to r…

---

## [Interval if state](https://discourse.nodered.org/t/interval-if-state/43149)

<div class="topic-metadata">

**Author:** [@Napster](https://discourse.nodered.org/u/Napster)\
**Replies:** 2\
**Last updated:** [25 March 2021 11:24 UTC](https://discourse.nodered.org/t/interval-if-state/43149 "2021-03-25T11:24:13Z")

</div>

Hi, I need a inject node with a interval every 10 sec, this should only need to work when payload is 0 kind regards

---

## [Help with Javascript on Function Node](https://discourse.nodered.org/t/help-with-javascript-on-function-node/43121)

<div class="topic-metadata">

**Author:** [@Dgillett](https://discourse.nodered.org/u/Dgillett)\
**Replies:** 22\
**Last updated:** [25 March 2021 10:21 UTC](https://discourse.nodered.org/t/help-with-javascript-on-function-node/43121 "2021-03-25T10:21:08Z")

</div>

I am Currently using an MQTT Gateway to receive values from a PLC using modbus. Then sending those values to a raspberry pi, and storing them into a SQLite Database. The Values only send to the Raspberry Pi "On Value Cha…

---

## [Best way to store data during Internet outages (then send)](https://discourse.nodered.org/t/best-way-to-store-data-during-internet-outages-then-send/43159)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 3\
**Last updated:** [25 March 2021 10:14 UTC](https://discourse.nodered.org/t/best-way-to-store-data-during-internet-outages-then-send/43159 "2021-03-25T10:14:35Z")

</div>

Hello. I am using NR on various devices to record temperature data every 1 minute. Readings are sent to InfluxDB (which hosted on Debian on Amazon EC2) using the Influx out node. System works perfectly. But.... When…

---

## [Send Email Alarm only once](https://discourse.nodered.org/t/send-email-alarm-only-once/43184)

<div class="topic-metadata">

**Author:** [@monokumamon](https://discourse.nodered.org/u/monokumamon)\
**Replies:** 1\
**Last updated:** [25 March 2021 09:53 UTC](https://discourse.nodered.org/t/send-email-alarm-only-once/43184 "2021-03-25T09:53:32Z")

</div>

Hello, im new to Node-RED. I'm using a vibration sensor and I manage to send an email when the alarm triggered. The problem I'm having right now is, I want Node-RED only send the alarm once not multiple times when the al…

---

## [Creating a table with certain number of rows](https://discourse.nodered.org/t/creating-a-table-with-certain-number-of-rows/43182)

<div class="topic-metadata">

**Author:** [@oussama5](https://discourse.nodered.org/u/oussama5)\
**Replies:** 1\
**Last updated:** [25 March 2021 09:46 UTC](https://discourse.nodered.org/t/creating-a-table-with-certain-number-of-rows/43182 "2021-03-25T09:46:42Z")

</div>

Hello guys, i wish everyone is ok. i have a project that consist me to create a table which it should be fill in with data(rows); The data is extracted from a database node with the help of a function node and an inject…

---

## [Doorbell alarm on my phone](https://discourse.nodered.org/t/doorbell-alarm-on-my-phone/42623)

<div class="topic-metadata">

**Author:** [@warnert](https://discourse.nodered.org/u/warnert)\
**Replies:** 8\
**Last updated:** [25 March 2021 09:44 UTC](https://discourse.nodered.org/t/doorbell-alarm-on-my-phone/42623 "2021-03-25T09:44:10Z")

</div>

Is it possible to use Node-Red to get an alarm on my phone when somebody pushes the knob of my doorbell? I sometimes do not hear that so I thought maybe I can add a relay to the bell, connect that to an input of the Rasp…

---

## [\[behavior\] Activating a function from the previous function node](https://discourse.nodered.org/t/behavior-activating-a-function-from-the-previous-function-node/43168)

<div class="topic-metadata">

**Author:** [@Nxito](https://discourse.nodered.org/u/Nxito)\
**Replies:** 7\
**Last updated:** [25 March 2021 09:31 UTC](https://discourse.nodered.org/t/behavior-activating-a-function-from-the-previous-function-node/43168 "2021-03-25T09:31:47Z")

</div>

I was testing something, and i see this behavior with node functions and the node-red. I have created two function nodes: -the first one creates a function with node.send () -the second calls this function -I get an …

---

## [CSV data to mysql using node red](https://discourse.nodered.org/t/csv-data-to-mysql-using-node-red/43179)

<div class="topic-metadata">

**Author:** [@Kins](https://discourse.nodered.org/u/Kins)\
**Replies:** 6\
**Last updated:** [25 March 2021 09:30 UTC](https://discourse.nodered.org/t/csv-data-to-mysql-using-node-red/43179 "2021-03-25T09:30:39Z")

</div>

How do I insert csv data from an online file to mysql using node red?

---

## [Exec node creating two processes](https://discourse.nodered.org/t/exec-node-creating-two-processes/43155)

<div class="topic-metadata">

**Author:** [@cocothedoges](https://discourse.nodered.org/u/cocothedoges)\
**Replies:** 2\
**Last updated:** [25 March 2021 08:55 UTC](https://discourse.nodered.org/t/exec-node-creating-two-processes/43155 "2021-03-25T08:55:30Z")

</div>

Hi guys, Im trying to place a switch to on/off my rPI =\> twitch.tv stream. The flow: \[{"id":"bcea7856.3d9df8","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"32b7b5b1.ee028a","type":"toggle","z":"bcea7…

---

## [IP camera: stream and record a fragment](https://discourse.nodered.org/t/ip-camera-stream-and-record-a-fragment/15876)

<div class="topic-metadata">

**Author:** [@Nxito](https://discourse.nodered.org/u/Nxito)\
**Replies:** 89\
**Last updated:** [25 March 2021 08:46 UTC](https://discourse.nodered.org/t/ip-camera-stream-and-record-a-fragment/15876 "2021-03-25T08:46:47Z")

</div>

Hello, before anything, Im using windows 7. I try to use an ip camera to stream live, and also i want be able to choose when to start recording and when to stop manually or by a node-red command. I've tried things in n…

---

## [Query mean value from influxDB into a gauge](https://discourse.nodered.org/t/query-mean-value-from-influxdb-into-a-gauge/43078)

<div class="topic-metadata">

**Author:** [@sahsha](https://discourse.nodered.org/u/sahsha)\
**Replies:** 16\
**Last updated:** [25 March 2021 07:53 UTC](https://discourse.nodered.org/t/query-mean-value-from-influxdb-into-a-gauge/43078 "2021-03-25T07:53:14Z")

</div>

Hello! being a mechanical engineer & new to node red, I've managed to get data from an OMRON PLC using FINS read node. And using influxdb out node I've also logged the data. Now I want to show mean value from logged valu…

---

## [Node-red projects + uibuilder -\> NodeRED UI freeze for some time](https://discourse.nodered.org/t/node-red-projects-uibuilder-nodered-ui-freeze-for-some-time/43139)

<div class="topic-metadata">

**Author:** [@eastling](https://discourse.nodered.org/u/eastling)\
**Replies:** 2\
**Last updated:** [25 March 2021 05:22 UTC](https://discourse.nodered.org/t/node-red-projects-uibuilder-nodered-ui-freeze-for-some-time/43139 "2021-03-25T05:22:06Z")

</div>

Hi, I wanted to use Nodered projects feature to get version control for the nodered flows and frontend (using uibuilder so all the frontend code also end up in the project folder). However what i noticed after running …

---

## [Run uibuilder standalone?](https://discourse.nodered.org/t/run-uibuilder-standalone/43063)

<div class="topic-metadata">

**Author:** [@eastling](https://discourse.nodered.org/u/eastling)\
**Replies:** 4\
**Last updated:** [24 March 2021 22:39 UTC](https://discourse.nodered.org/t/run-uibuilder-standalone/43063 "2021-03-24T22:39:31Z")

</div>

First of all - thank you everyone for your impressive work on uibuilder and node-red! I have a question - is it possible to run uibuilder and node-red separately? Reason I ask is that I am currently using a vue "templa…

---

## [GPIO state crazy?](https://discourse.nodered.org/t/gpio-state-crazy/43122)

<div class="topic-metadata">

**Author:** [@Herbert](https://discourse.nodered.org/u/Herbert)\
**Replies:** 1\
**Last updated:** [24 March 2021 15:12 UTC](https://discourse.nodered.org/t/gpio-state-crazy/43122 "2021-03-24T15:12:53Z")

</div>

Hello friends, I installed at my Rasperry 3B+ a 8 chanel relay card. Standard relay, not any SSR. on the Relay card is a LED for each relay - state LED. I think you know that. If the Pi is off, the relay is off. If I…

---

## [Node-Red CSV double entries](https://discourse.nodered.org/t/node-red-csv-double-entries/43082)

<div class="topic-metadata">

**Author:** [@Eintracht00](https://discourse.nodered.org/u/Eintracht00)\
**Replies:** 6\
**Last updated:** [24 March 2021 11:09 UTC](https://discourse.nodered.org/t/node-red-csv-double-entries/43082 "2021-03-24T11:09:39Z")

</div>

Is there a way how i can go sure that i don't get double entries in my CSV. I take data from a sensor every 30 sec, but if nothing changed, I want get a new entry in my CSV. Just if something changed (I get 5 different…

---

## [Node-Red CSV datatype](https://discourse.nodered.org/t/node-red-csv-datatype/43081)

<div class="topic-metadata">

**Author:** [@Eintracht00](https://discourse.nodered.org/u/Eintracht00)\
**Replies:** 6\
**Last updated:** [24 March 2021 10:56 UTC](https://discourse.nodered.org/t/node-red-csv-datatype/43081 "2021-03-24T10:56:25Z")

</div>

How can I make that my CSV File that my lines are formatted, because if i get data like "7.2" as float. it makes me in the CSV btw. Excel 7. Feb, because it thinks automatically that its a date

---

## [Found an error in the user guide](https://discourse.nodered.org/t/found-an-error-in-the-user-guide/43113)

<div class="topic-metadata">

**Author:** [@Suurballe](https://discourse.nodered.org/u/Suurballe)\
**Replies:** 1\
**Last updated:** [24 March 2021 10:27 UTC](https://discourse.nodered.org/t/found-an-error-in-the-user-guide/43113 "2021-03-24T10:27:38Z")

</div>

Hello, I was sitting and reading through the user-guide on how to write functions in Node-RED and came across a tiny error. I know it is not much at all, but it threw me off when I was reading it. https://nodered.org/d…

---

## [Mysql connection refused](https://discourse.nodered.org/t/mysql-connection-refused/43109)

<div class="topic-metadata">

**Author:** [@Eimerich](https://discourse.nodered.org/u/Eimerich)\
**Replies:** 5\
**Last updated:** [24 March 2021 10:22 UTC](https://discourse.nodered.org/t/mysql-connection-refused/43109 "2021-03-24T10:22:22Z")

</div>

Hi there, I've seen that some similar questions have already been replied but didn't seem to clarify my actual problem. The situation so far: We have installed an IOT on our system to monitor the Siemens PLC. When I'm …

[Previous page](https://discourse.nodered.org/c/general/7.md?page=579)

[Next page](https://discourse.nodered.org/c/general/7.md?page=581)
