# General

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

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

**Page:** 772

---

## [How to retrieve integer value from SQLite for display and comparison](https://discourse.nodered.org/t/how-to-retrieve-integer-value-from-sqlite-for-display-and-comparison/24180)

<div class="topic-metadata">

**Author:** [@teladia](https://discourse.nodered.org/u/teladia)\
**Replies:** 7\
**Last updated:** [4 April 2020 17:34 UTC](https://discourse.nodered.org/t/how-to-retrieve-integer-value-from-sqlite-for-display-and-comparison/24180 "2020-04-04T17:34:32Z")

</div>

Good Day, I am new to the node red environment. The project at hand is a Smart Vending machine which is for my final year project. I have managed to get a bit done on my own by reading up and using advice from the forums…

---

## [./ command in exec node](https://discourse.nodered.org/t/command-in-exec-node/24113)

<div class="topic-metadata">

**Author:** [@RogierQ](https://discourse.nodered.org/u/RogierQ)\
**Replies:** 19\
**Last updated:** [4 April 2020 16:24 UTC](https://discourse.nodered.org/t/command-in-exec-node/24113 "2020-04-04T16:24:48Z")

</div>

Hi! I cannot get this working from node red... when i run this "sudo ./fm\_transmitter -f 102.7 acoustic\_guitar\_duet.wav" in the dir "/home/pi/fm\_transmitter/" It works on command line but when i do the following from…

---

## [Probleme lecture conditions (Problem reading conditions)](https://discourse.nodered.org/t/probleme-lecture-conditions-problem-reading-conditions/24203)

<div class="topic-metadata">

**Author:** [@micke007](https://discourse.nodered.org/u/micke007)\
**Replies:** 2\
**Last updated:** [4 April 2020 15:07 UTC](https://discourse.nodered.org/t/probleme-lecture-conditions-problem-reading-conditions/24203 "2020-04-04T15:07:16Z")

</div>

bonjours a tous, quand je j'appuie sur A puis sur B ma variable "compteur" ne s'incremente pas alors que dans l'autre sens (B puis A) mon "compteur" monte quelqu'un pourrais me dire comment faire pour que ça monte peu…

---

## [Limit on ewelink event listener?](https://discourse.nodered.org/t/limit-on-ewelink-event-listener/23995)

<div class="topic-metadata">

**Author:** [@demokedes](https://discourse.nodered.org/u/demokedes)\
**Replies:** 6\
**Last updated:** [4 April 2020 13:49 UTC](https://discourse.nodered.org/t/limit-on-ewelink-event-listener/23995 "2020-04-04T13:49:28Z")

</div>

I am using nodered to create reports for usage od my ewelink/sonoff devices in my home. In my house I have majority light switches from Sonoff. I am using Node-res to listen to all changes in switcher and then I am str…

---

## [Ui builder control messages](https://discourse.nodered.org/t/ui-builder-control-messages/23725)

<div class="topic-metadata">

**Author:** [@albydnc](https://discourse.nodered.org/u/albydnc)\
**Replies:** 5\
**Last updated:** [4 April 2020 13:01 UTC](https://discourse.nodered.org/t/ui-builder-control-messages/23725 "2020-04-04T13:01:39Z")

</div>

Hi everyone, I am moving to uibuilder to build dashboards, but I can't understand how the control messages are passed. I am using this flow debug example by injecting a msg object built like this: { uibuilderCtrl: "t…

---

## [Node-red to WampServer on my laptop](https://discourse.nodered.org/t/node-red-to-wampserver-on-my-laptop/24206)

<div class="topic-metadata">

**Author:** [@iankillz](https://discourse.nodered.org/u/iankillz)\
**Replies:** 4\
**Last updated:** [4 April 2020 10:21 UTC](https://discourse.nodered.org/t/node-red-to-wampserver-on-my-laptop/24206 "2020-04-04T10:21:55Z")

</div>

Hello guys, im new to node-red and I am trying to send my sensor readings to a database but MySql DB is on my laptop and not locally to my pi. How can send data to MySql on my laptop?

---

## [Cannot access microphone](https://discourse.nodered.org/t/cannot-access-microphone/24207)

<div class="topic-metadata">

**Author:** [@lingzhongli](https://discourse.nodered.org/u/lingzhongli)\
**Replies:** 6\
**Last updated:** [4 April 2020 10:01 UTC](https://discourse.nodered.org/t/cannot-access-microphone/24207 "2020-04-04T10:01:08Z")

</div>

i cannot using the microphone.... cause i cannot allow my microphone.... is because it is not secure? Have any solution to make it secure so i can allow mcrophone??

---

## [Windows 10 - Upgrade unable to via CMD](https://discourse.nodered.org/t/windows-10-upgrade-unable-to-via-cmd/24161)

<div class="topic-metadata">

**Author:** [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Replies:** 2\
**Last updated:** [4 April 2020 07:42 UTC](https://discourse.nodered.org/t/windows-10-upgrade-unable-to-via-cmd/24161 "2020-04-04T07:42:43Z")

</div>

Hi, Trying to upgrade Node -red on my Windows 10 PC. I am using CDM and not powershell and as the directory is C:\\Program Files\\nodejs Error from Powershell, I think it is due the the space in the directory structure …

---

## [Object on msg deleted after file in node, msg per line configuraton](https://discourse.nodered.org/t/object-on-msg-deleted-after-file-in-node-msg-per-line-configuraton/23815)

<div class="topic-metadata">

**Author:** [@bug00](https://discourse.nodered.org/u/bug00)\
**Replies:** 12\
**Last updated:** [4 April 2020 05:52 UTC](https://discourse.nodered.org/t/object-on-msg-deleted-after-file-in-node-msg-per-line-configuraton/23815 "2020-04-04T05:52:00Z")

</div>

Hi, I don't understand why with file in node, in "msg per line" configuration i loose every object on msg. If if add a change node with a key msg : { test : 'toto' } then, after the file in node msg is totaly replace …

---

## [Spliting Payload to Insert into Mysql](https://discourse.nodered.org/t/spliting-payload-to-insert-into-mysql/24193)

<div class="topic-metadata">

**Author:** [@nksky](https://discourse.nodered.org/u/nksky)\
**Replies:** 6\
**Last updated:** [4 April 2020 00:23 UTC](https://discourse.nodered.org/t/spliting-payload-to-insert-into-mysql/24193 "2020-04-04T00:23:39Z")

</div>

I'm getting stuck splitting a payload to insert it into MySql table, I know its something simple, but I cant figure it. Any help greatly appreciated. This is my payload and this is my function node var myDataArray …

---

## [Question about \`calculate\` node](https://discourse.nodered.org/t/question-about-calculate-node/24191)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [3 April 2020 22:59 UTC](https://discourse.nodered.org/t/question-about-calculate-node/24191 "2020-04-03T22:59:47Z")

</div>

(From the library I was pointed here for "feedback and support") Sort of tied in with my "Rate detection" thread. Would this node be useful to me for doing what I want to do? The description is a bit vague for me to g…

---

## [Help finding the source of this error:](https://discourse.nodered.org/t/help-finding-the-source-of-this-error/24181)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [3 April 2020 21:21 UTC](https://discourse.nodered.org/t/help-finding-the-source-of-this-error/24181 "2020-04-03T21:21:27Z")

</div>

As much as I have tried to catch errors in my flows and identify them, this one is not playing the game. This is the error message: And when I search for the source I get: Anyone - please.

---

## [Questions. Machine in development](https://discourse.nodered.org/t/questions-machine-in-development/24168)

<div class="topic-metadata">

**Author:** [@gonzalito](https://discourse.nodered.org/u/gonzalito)\
**Replies:** 8\
**Last updated:** [3 April 2020 20:59 UTC](https://discourse.nodered.org/t/questions-machine-in-development/24168 "2020-04-03T20:59:29Z")

</div>

Hello guys, this is my first post here. But mainly i'm doing this to ask a few things about our approach on a product being developed. We have a developed a self propelled machine for milk distribution among calves. …

---

## [Monthly signal - help please](https://discourse.nodered.org/t/monthly-signal-help-please/24125)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 10\
**Last updated:** [3 April 2020 20:36 UTC](https://discourse.nodered.org/t/monthly-signal-help-please/24125 "2020-04-03T20:36:14Z")

</div>

(Brain failure) I'm wanting a monthly signal to happen at ...... 23:50. (say) (Sorry.... The rub: last day of the month) The inject nodes doesn't quite seem to do that. cronplus may. bigtimer seems possible too. …

---

## [AWS Cloud MQTT IOT connection Problem](https://discourse.nodered.org/t/aws-cloud-mqtt-iot-connection-problem/12892)

<div class="topic-metadata">

**Author:** [@RoundTriangle](https://discourse.nodered.org/u/RoundTriangle)\
**Replies:** 3\
**Last updated:** [3 April 2020 16:34 UTC](https://discourse.nodered.org/t/aws-cloud-mqtt-iot-connection-problem/12892 "2020-04-03T16:34:41Z")

</div>

Hello NODE-Red- Forum! Not sure if this is a node red problem, but maybe someone has experience with it. Its like a kind of Hybrid .. I want to connect with Node-red via the mqtt node to the aws IoT. I use a Simatic I…

---

## [I2c reading Atlas Scientific PH EZO](https://discourse.nodered.org/t/i2c-reading-atlas-scientific-ph-ezo/7343)

<div class="topic-metadata">

**Author:** [@debouttek](https://discourse.nodered.org/u/debouttek)\
**Replies:** 4\
**Last updated:** [3 April 2020 15:53 UTC](https://discourse.nodered.org/t/i2c-reading-atlas-scientific-ph-ezo/7343 "2020-04-03T15:53:04Z")

</div>

I would like to read from i2c device (PH EZO Atlas Scientific) (https://www.atlas-scientific.com/product\_pages/circuits/ezo\_ph.html) I can read out the PH sensor using a Python script so hardware wise it's working fine.…

---

## [How to show analog/digital information in a URL from a PLC via MQTT](https://discourse.nodered.org/t/how-to-show-analog-digital-information-in-a-url-from-a-plc-via-mqtt/24025)

<div class="topic-metadata">

**Author:** [@qmf](https://discourse.nodered.org/u/qmf)\
**Replies:** 4\
**Last updated:** [3 April 2020 14:56 UTC](https://discourse.nodered.org/t/how-to-show-analog-digital-information-in-a-url-from-a-plc-via-mqtt/24025 "2020-04-03T14:56:55Z")

</div>

Hi everyone, First of all, I am brand new in IoT technologies so excuse me if I make a mistake and say something wrong. I am trying to control inputs and outputs from a PLC via MQTT and get all data in node-red, to sen…

---

## [RBE Node for msg.payload Array](https://discourse.nodered.org/t/rbe-node-for-msg-payload-array/23655)

<div class="topic-metadata">

**Author:** [@Andreas703](https://discourse.nodered.org/u/Andreas703)\
**Replies:** 8\
**Last updated:** [3 April 2020 14:54 UTC](https://discourse.nodered.org/t/rbe-node-for-msg-payload-array/23655 "2020-04-03T14:54:05Z")

</div>

Hi, I am using a device with NodeRed 0.18.7. I am getting an array of msg.payload looks like Is there a possibility to address all msg.payload.value of the array in the rbe node without splitting the Array? Thx

---

## [Replace space Full Name regex?](https://discourse.nodered.org/t/replace-space-full-name-regex/24112)

<div class="topic-metadata">

**Author:** [@niclas.w82](https://discourse.nodered.org/u/niclas.w82)\
**Replies:** 3\
**Last updated:** [3 April 2020 14:43 UTC](https://discourse.nodered.org/t/replace-space-full-name-regex/24112 "2020-04-03T14:43:06Z")

</div>

Hi. Have tried to read about regex expressions but don't succeed. Maybe there is an easier way to do this. I want to replace the space between first name and surname in a payload with %20. The payload is for example J…

---

## [Msg.payload in http request?](https://discourse.nodered.org/t/msg-payload-in-http-request/24151)

<div class="topic-metadata">

**Author:** [@niclas.w82](https://discourse.nodered.org/u/niclas.w82)\
**Replies:** 4\
**Last updated:** [3 April 2020 14:41 UTC](https://discourse.nodered.org/t/msg-payload-in-http-request/24151 "2020-04-03T14:41:11Z")

</div>

Hi is it possible to use{{msg.payload}} in http request? Cant get it to work? Can I somehow see what's getting out from the http node. Tried http logger but it doesn't show anything. Even if filter is blank.

---

## [USB HID RELAY node - question/s](https://discourse.nodered.org/t/usb-hid-relay-node-question-s/14624)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 7\
**Last updated:** [3 April 2020 13:31 UTC](https://discourse.nodered.org/t/usb-hid-relay-node-question-s/14624 "2020-04-03T13:31:15Z")

</div>

I just saw this in the "library": Nice. I can't resolve how to ask the person, so here goes: (From the page) \` Models supported: HW-348 HW-343 HW-341 Models with USB-Relay-1, USB-Relay-2 or USB-Relay-4 printed on…

---

## [Node for reading data of BME680 Sensor](https://discourse.nodered.org/t/node-for-reading-data-of-bme680-sensor/24039)

<div class="topic-metadata">

**Author:** [@Jobi](https://discourse.nodered.org/u/Jobi)\
**Replies:** 20\
**Last updated:** [3 April 2020 13:21 UTC](https://discourse.nodered.org/t/node-for-reading-data-of-bme680-sensor/24039 "2020-04-03T13:21:22Z")

</div>

Hello, I am totally new in raspberry pi programming and I started with a node-red project for measure temperature and humidity (Temperature 3 - 20 °C, humidity 80-100%). The measurement is going to be in a refigerator …

---

## [Json, how can i add the msg.payload object as a variable in JSON](https://discourse.nodered.org/t/json-how-can-i-add-the-msg-payload-object-as-a-variable-in-json/24108)

<div class="topic-metadata">

**Author:** [@Beefy\_carrot](https://discourse.nodered.org/u/Beefy_carrot)\
**Replies:** 5\
**Last updated:** [3 April 2020 12:40 UTC](https://discourse.nodered.org/t/json-how-can-i-add-the-msg-payload-object-as-a-variable-in-json/24108 "2020-04-03T12:40:35Z")

</div>

Hi! im new to node red, but im trying to send a payload from a sensor over to a database. this works fine using a text string. But my question is, how can i add the msg.payload variable(that holds the data from the senso…

---

## [Receiving input to function node while the function is running](https://discourse.nodered.org/t/receiving-input-to-function-node-while-the-function-is-running/24153)

<div class="topic-metadata">

**Author:** [@mansahlgren](https://discourse.nodered.org/u/mansahlgren)\
**Replies:** 6\
**Last updated:** [3 April 2020 12:39 UTC](https://discourse.nodered.org/t/receiving-input-to-function-node-while-the-function-is-running/24153 "2020-04-03T12:39:47Z")

</div>

I want to receive input to a function that is already running without restarting the function, and I want this to be able to happen an arbitrary amount of times during the functions execution. I tried using the flow con…

---

## [Arduino with Json to node red to make a chart](https://discourse.nodered.org/t/arduino-with-json-to-node-red-to-make-a-chart/24143)

<div class="topic-metadata">

**Author:** [@JonasG](https://discourse.nodered.org/u/JonasG)\
**Replies:** 1\
**Last updated:** [3 April 2020 12:34 UTC](https://discourse.nodered.org/t/arduino-with-json-to-node-red-to-make-a-chart/24143 "2020-04-03T12:34:42Z")

</div>

Hey. My task is to send some numbers to node red and make a chart with them. I have to use the Form {"Temperature":22.0,"Humidity":32.0} When I am in node red I go from the Serial Inport into a json and from that into …

---

## [Sending html table data from ui template to sql or to msg .payload](https://discourse.nodered.org/t/sending-html-table-data-from-ui-template-to-sql-or-to-msg-payload/24137)

<div class="topic-metadata">

**Author:** [@Aklex1](https://discourse.nodered.org/u/Aklex1)\
**Replies:** 0\
**Last updated:** [3 April 2020 09:27 UTC](https://discourse.nodered.org/t/sending-html-table-data-from-ui-template-to-sql-or-to-msg-payload/24137 "2020-04-03T09:27:58Z")

</div>

Greetings to all users of NODE RED After establishing a connection to the sql database, I create a dynamic HTML table using the syntax tr ng-repeat = "x in msg.payload | limitTo: 200"\> \<td class = "allbdrCenTop" al…

---

## [Ultrasonic sensor object detection](https://discourse.nodered.org/t/ultrasonic-sensor-object-detection/24007)

<div class="topic-metadata">

**Author:** [@iankillz](https://discourse.nodered.org/u/iankillz)\
**Replies:** 10\
**Last updated:** [3 April 2020 06:55 UTC](https://discourse.nodered.org/t/ultrasonic-sensor-object-detection/24007 "2020-04-03T06:55:12Z")

</div>

Hello im new in using raspberry pi and node-red and i am doing a smart parking project using ultrasonic sensors. How can I use node-red with an ultrasonic sensor to detect the car if the spot is taken or not and get resu…

---

## [Dashboard: changing tab's with mouse slide](https://discourse.nodered.org/t/dashboard-changing-tabs-with-mouse-slide/24124)

<div class="topic-metadata">

**Author:** [@greenembrace](https://discourse.nodered.org/u/greenembrace)\
**Replies:** 2\
**Last updated:** [3 April 2020 04:23 UTC](https://discourse.nodered.org/t/dashboard-changing-tabs-with-mouse-slide/24124 "2020-04-03T04:23:03Z")

</div>

Hi, On one of my dashboards I can move between tabs by 'holding down mouse button (left or right) then sliding left or right before releasing the button. I have tried it in three different browsers with the same result.…

---

## [Using Nextcloud, webdav and node-red](https://discourse.nodered.org/t/using-nextcloud-webdav-and-node-red/24072)

<div class="topic-metadata">

**Author:** [@Nxito](https://discourse.nodered.org/u/Nxito)\
**Replies:** 1\
**Last updated:** [3 April 2020 02:37 UTC](https://discourse.nodered.org/t/using-nextcloud-webdav-and-node-red/24072 "2020-04-03T02:37:49Z")

</div>

I am trying to list and upload a file to nextcloud with node-red I have tried using the kuehnelbs node/node-red-contrib-nextcloud I was successful in the listing but uploading gave me an error : "self signed certifica…

---

## [Filebased installation of Nodes](https://discourse.nodered.org/t/filebased-installation-of-nodes/23660)

<div class="topic-metadata">

**Author:** [@DSiekmeier](https://discourse.nodered.org/u/DSiekmeier)\
**Replies:** 4\
**Last updated:** [3 April 2020 01:46 UTC](https://discourse.nodered.org/t/filebased-installation-of-nodes/23660 "2020-04-03T01:46:06Z")

</div>

Hi everybody, are there any plans for a possibility to install new Nodes from a file which was created via npm pack? Kind Regards, Dennis

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

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