# General **URL:** https://discourse.nodered.org/c/general/7.md?page=711 [Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md) **Page:** 712 --- ## [Combining "form" and "dropdown" payload data and building a mysql query](https://discourse.nodered.org/t/combining-form-and-dropdown-payload-data-and-building-a-mysql-query/30377)

**Author:** [@zazas321](https://discourse.nodered.org/u/zazas321)\ **Replies:** 2\ **Last updated:** [20 July 2020 08:38 UTC](https://discourse.nodered.org/t/combining-form-and-dropdown-payload-data-and-building-a-mysql-query/30377 "2020-07-20T08:38:42Z")

Hello. I am trying to build an MYSQL query from user input "form" and "dropdown" nodes. I am using "change" nodes and "join" node to build an array out of 3 inputs that the user needs to give : Device,Item,Serial. T… --- ## [Connection with database error](https://discourse.nodered.org/t/connection-with-database-error/30172)

**Author:** [@shipra](https://discourse.nodered.org/u/shipra)\ **Replies:** 114\ **Last updated:** [20 July 2020 08:31 UTC](https://discourse.nodered.org/t/connection-with-database-error/30172 "2020-07-20T08:31:42Z")

"ConnectionError: Login failed for user 'sa'." getting this eeror i have created a databse name RFID\_ENTRIES1 ,and i am sending my data through mqtt node and data is getting correctly but i have to compare this data to … --- ## [Post data for PowerBI](https://discourse.nodered.org/t/post-data-for-powerbi/30340)

**Author:** [@giorgis](https://discourse.nodered.org/u/giorgis)\ **Replies:** 2\ **Last updated:** [20 July 2020 08:06 UTC](https://discourse.nodered.org/t/post-data-for-powerbi/30340 "2020-07-20T08:06:32Z")

Hi all! I have just started exploring my way around Node-RED so please excuse my ignorance and bear with me. What I have seen so far is that it's possible to POST data in a streaming PowerBI dataset. This implementati… --- ## [Type Error: Cannot read property of '1' of undefined](https://discourse.nodered.org/t/type-error-cannot-read-property-of-1-of-undefined/30370)

**Author:** [@Henjoe](https://discourse.nodered.org/u/Henjoe)\ **Replies:** 7\ **Last updated:** [20 July 2020 07:59 UTC](https://discourse.nodered.org/t/type-error-cannot-read-property-of-1-of-undefined/30370 "2020-07-20T07:59:31Z")

Hello, I have a node-red-contrib-file-function which allows me to create a function on nodered outside the nodered itself. My application is simple, I just read data from my influxDB and do some calculations from the dat… --- ## [How to pass payload data from user "form" to function](https://discourse.nodered.org/t/how-to-pass-payload-data-from-user-form-to-function/30106)

**Author:** [@zazas321](https://discourse.nodered.org/u/zazas321)\ **Replies:** 15\ **Last updated:** [20 July 2020 06:12 UTC](https://discourse.nodered.org/t/how-to-pass-payload-data-from-user-form-to-function/30106 "2020-07-20T06:12:58Z")

Hello. I am working with node-red and mysql database. I would like to fill a form and send the data from the form to the database. The flow : So I just have a form where I fill my data, then I have the function node … --- ## [Exec node choking on the following command sequence?](https://discourse.nodered.org/t/exec-node-choking-on-the-following-command-sequence/30282)

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\ **Replies:** 3\ **Last updated:** [20 July 2020 03:49 UTC](https://discourse.nodered.org/t/exec-node-choking-on-the-following-command-sequence/30282 "2020-07-20T03:49:25Z")

I have setup public/private key methodology for use with SSH. This is the typical implementation, create the key pair, push the public key to the remote host. Old school to be sure.. ssh-keygen -t rsa ssh-copy-id myna… --- ## [Help cron-plus and raspberry pi](https://discourse.nodered.org/t/help-cron-plus-and-raspberry-pi/30343)

**Author:** [@yotti](https://discourse.nodered.org/u/yotti)\ **Replies:** 2\ **Last updated:** [19 July 2020 23:34 UTC](https://discourse.nodered.org/t/help-cron-plus-and-raspberry-pi/30343 "2020-07-19T23:34:46Z")

hello, everyone this is my first project with node-red and raspberry pi and I need your help what I'm trying to make is... -I had my med button (GPIO input node) that turn off led -remind me later button (GPIO input … --- ## [COM port as input to Serial Node](https://discourse.nodered.org/t/com-port-as-input-to-serial-node/30238)

**Author:** [@T0T4R4](https://discourse.nodered.org/u/T0T4R4)\ **Replies:** 2\ **Last updated:** [19 July 2020 23:26 UTC](https://discourse.nodered.org/t/com-port-as-input-to-serial-node/30238 "2020-07-19T23:26:05Z")

Hi all, I am reusing a flow on 4 machines. On each machine an arduino is plugged in. Because it's windows, different COM ports are attributed to each arduino (well we can change them in Device Manager, but not sure the… --- ## [Wyze Smarthome Devices](https://discourse.nodered.org/t/wyze-smarthome-devices/30358)

**Author:** [@nicedevil](https://discourse.nodered.org/u/nicedevil)\ **Replies:** 1\ **Last updated:** [19 July 2020 23:11 UTC](https://discourse.nodered.org/t/wyze-smarthome-devices/30358 "2020-07-19T23:11:52Z")

Hey there, I was googling around on how to access Wyze IOT devices in node-red and I can‘t find anything usefull :confused: Is there anybody that was able to access these devices and turn a bulb on and off f.e.? --- ## [Having problems to use MQTT with NodeRED in an embeded server](https://discourse.nodered.org/t/having-problems-to-use-mqtt-with-nodered-in-an-embeded-server/29881)

**Author:** [@WilliamSixta](https://discourse.nodered.org/u/WilliamSixta)\ **Replies:** 17\ **Last updated:** [19 July 2020 21:23 UTC](https://discourse.nodered.org/t/having-problems-to-use-mqtt-with-nodered-in-an-embeded-server/29881 "2020-07-19T21:23:07Z")

Hello guys! I am trying to develop an application using NodeRED and share the data in the cloud (GCloud) by MQTT. For this, I am using the ADAM 6717 of Advantech which Is a gateway with NodeRED embedded. I am having pr… --- ## [Raspberry Pi dies when left on overnight](https://discourse.nodered.org/t/raspberry-pi-dies-when-left-on-overnight/30297)

**Author:** [@gbenham](https://discourse.nodered.org/u/gbenham)\ **Replies:** 10\ **Last updated:** [19 July 2020 21:06 UTC](https://discourse.nodered.org/t/raspberry-pi-dies-when-left-on-overnight/30297 "2020-07-19T21:06:31Z")

I accidentally left my Raspberry Pi on overnight. When I discovered that the next day I also found that I couldn't get it to respond. I've tried cycling power but never gotten it to respond since then. If I recall correc… --- ## [Node-red is running twice on port 1880](https://discourse.nodered.org/t/node-red-is-running-twice-on-port-1880/30348)

**Author:** [@jitrah](https://discourse.nodered.org/u/jitrah)\ **Replies:** 2\ **Last updated:** [19 July 2020 17:39 UTC](https://discourse.nodered.org/t/node-red-is-running-twice-on-port-1880/30348 "2020-07-19T17:39:50Z")

Hi guys, I'm really new at all this. I launched a EC2 Ubuntu instance to be able to run Node-Red on it. After installing it following the instructions and after setting up npm2 to auto-start on reboot, it appears that … --- ## [MySQL subtract two rows from column and places into an alias](https://discourse.nodered.org/t/mysql-subtract-two-rows-from-column-and-places-into-an-alias/30316)

**Author:** [@sonima](https://discourse.nodered.org/u/sonima)\ **Replies:** 5\ **Last updated:** [19 July 2020 13:19 UTC](https://discourse.nodered.org/t/mysql-subtract-two-rows-from-column-and-places-into-an-alias/30316 "2020-07-19T13:19:05Z")

I am working with Node-red and Mysql database. I don't know How to compare previous value with new value on each different devices then insert new value into Data column. I mean subtract new value with previous value … --- ## [Unable to display image from base64](https://discourse.nodered.org/t/unable-to-display-image-from-base64/29530)

**Author:** [@blob](https://discourse.nodered.org/u/blob)\ **Replies:** 31\ **Last updated:** [19 July 2020 12:22 UTC](https://discourse.nodered.org/t/unable-to-display-image-from-base64/29530 "2020-07-19T12:22:06Z")

Hello, I'm working with some sensors which send data through udp. Cameras are attached to each and every sensor. The data received through udp also include the data sent by the camera. The camera data is also clubbed wi… --- ## [Need advice about remote message transfer](https://discourse.nodered.org/t/need-advice-about-remote-message-transfer/30319)

**Author:** [@Hasitha\_Sudasinghe](https://discourse.nodered.org/u/Hasitha_Sudasinghe)\ **Replies:** 19\ **Last updated:** [19 July 2020 11:36 UTC](https://discourse.nodered.org/t/need-advice-about-remote-message-transfer/30319 "2020-07-19T11:36:45Z")

Dear Superiors, I have and issue to give a solution. I have two stations which are located 100m away from each other and i want to transfer strings from one statins to another. Master station is the always sending msgs… --- ## [Txt file and Http request](https://discourse.nodered.org/t/txt-file-and-http-request/30311)

**Author:** [@JoshuaMtz](https://discourse.nodered.org/u/JoshuaMtz)\ **Replies:** 2\ **Last updated:** [19 July 2020 11:30 UTC](https://discourse.nodered.org/t/txt-file-and-http-request/30311 "2020-07-19T11:30:22Z")

I am trying to upload a .txt file to an http address. The problem is that the information is published on a single line, that is: The .txt file contains the following numbers: 0 10 1 10 2 10 3 10 4 10 But when chec… --- ## [Eztimer node configurer](https://discourse.nodered.org/t/eztimer-node-configurer/30327)

**Author:** [@xale12](https://discourse.nodered.org/u/xale12)\ **Replies:** 6\ **Last updated:** [19 July 2020 08:35 UTC](https://discourse.nodered.org/t/eztimer-node-configurer/30327 "2020-07-19T08:35:33Z")

Hello, I am a newbie on node-red. I try to use Eztimer node for timer but the debugger sends the comment not suitable for my code. for example, I turn off the schedule for Thursday It send back the string"Scheduled 'ON' … --- ## [Node-Red & UI on Android device using slax](https://discourse.nodered.org/t/node-red-ui-on-android-device-using-slax/30309)

**Author:** [@nksky](https://discourse.nodered.org/u/nksky)\ **Replies:** 1\ **Last updated:** [19 July 2020 08:20 UTC](https://discourse.nodered.org/t/node-red-ui-on-android-device-using-slax/30309 "2020-07-19T08:20:46Z")

I need to develop an app to run on an android device, 5" screen, but this has a barcode reader and GPS built-in, using Slax or dietpi as OS, run Node-red and UI on top would this work or be more hassle than its worth, An… --- ## ["MQTT in" Topic and kontext](https://discourse.nodered.org/t/mqtt-in-topic-and-kontext/30305)

**Author:** [@SN-8023](https://discourse.nodered.org/u/SN-8023)\ **Replies:** 2\ **Last updated:** [19 July 2020 02:57 UTC](https://discourse.nodered.org/t/mqtt-in-topic-and-kontext/30305 "2020-07-19T02:57:34Z")

Is there a way to fill the topic field from the flow context? this would make maintenance much easier if you only had to change 1 konext instead of 5 nodes per flow --- ## [Nodered philips hue motion sensor](https://discourse.nodered.org/t/nodered-philips-hue-motion-sensor/9459)

**Author:** [@timdeloddere](https://discourse.nodered.org/u/timdeloddere)\ **Replies:** 6\ **Last updated:** [18 July 2020 22:46 UTC](https://discourse.nodered.org/t/nodered-philips-hue-motion-sensor/9459 "2020-07-18T22:46:52Z")

Hi, I have a Philips Hue bridge with some Hue Motions Sensors If I connect a debug node, the message I see is How do I get only the temperature (Celcius) value, out of this message ? --- ## [Http request node - gzip encrypted response](https://discourse.nodered.org/t/http-request-node-gzip-encrypted-response/30300)

**Author:** [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\ **Replies:** 16\ **Last updated:** [18 July 2020 21:53 UTC](https://discourse.nodered.org/t/http-request-node-gzip-encrypted-response/30300 "2020-07-18T21:53:18Z")

Trying to download some statistical data from https://c19downloads.azureedge.net/downloads/msoa\_data/MSOAs\_latest.json If I use that url in a browser, I get access to the full data, but when trying using the http reque… --- ## [Sleep function no related to time, related to values](https://discourse.nodered.org/t/sleep-function-no-related-to-time-related-to-values/30299)

**Author:** [@lalo](https://discourse.nodered.org/u/lalo)\ **Replies:** 3\ **Last updated:** [18 July 2020 20:13 UTC](https://discourse.nodered.org/t/sleep-function-no-related-to-time-related-to-values/30299 "2020-07-18T20:13:31Z")

Hi, guys I want to have like a sleep function so basically I'm reading values for example from 0 to 50 so when the value is close to 0 I need some msg.payload interrupt to no send any msg, and when it approximates to 50 … --- ## [How to use Node-RED to switch ioBroker scenes](https://discourse.nodered.org/t/how-to-use-node-red-to-switch-iobroker-scenes/30289)

**Author:** [@Bravestarr](https://discourse.nodered.org/u/Bravestarr)\ **Replies:** 1\ **Last updated:** [18 July 2020 20:10 UTC](https://discourse.nodered.org/t/how-to-use-node-red-to-switch-iobroker-scenes/30289 "2020-07-18T20:10:45Z")

I try to switch a iobroker scene. I successfully receive a boolean from my alexa node-red node. I can see the output of msg.payload with the debug node. That switches from true to false and vice-versa if I use the alexa … --- ## [Adding functions to the Raspberry Pi Dashboard](https://discourse.nodered.org/t/adding-functions-to-the-raspberry-pi-dashboard/30146)

**Author:** [@gbenham](https://discourse.nodered.org/u/gbenham)\ **Replies:** 8\ **Last updated:** [18 July 2020 19:21 UTC](https://discourse.nodered.org/t/adding-functions-to-the-raspberry-pi-dashboard/30146 "2020-07-18T19:21:09Z")

In my dashboard section of the node-RED editor, under Raspberry Pi, there are only 4 items listed including GPIO Output and GPIO Input. How do I add other functions like rpi-dht22 (temperature and humidity sensor) and th… --- ## [Date/Time formatting](https://discourse.nodered.org/t/date-time-formatting/1138)

**Author:** [@na-am](https://discourse.nodered.org/u/na-am)\ **Replies:** 12\ **Last updated:** [18 July 2020 19:05 UTC](https://discourse.nodered.org/t/date-time-formatting/1138 "2020-07-18T19:05:45Z")

hi@all I need a string like this: “2018-06-28 08:44:55.000000” So I tried to format the date: var d = new Date(); var options = { timeZone: 'UTC', year: 'numeric', month: '2-digit', day: '2-digit'}; var \_resultDate = … --- ## [Spreadsheet-in Row/Column name](https://discourse.nodered.org/t/spreadsheet-in-row-column-name/30284)

**Author:** [@AK51](https://discourse.nodered.org/u/AK51)\ **Replies:** 3\ **Last updated:** [18 July 2020 15:48 UTC](https://discourse.nodered.org/t/spreadsheet-in-row-column-name/30284 "2020-07-18T15:48:33Z")

Hi, I want to read all excel data (using sheet-to-json), when I run the example, the json file looks fine. But when I use my own excel file, the json cell labeling does not look right. Please see the picture for detail… --- ## [Excel file to mySQL](https://discourse.nodered.org/t/excel-file-to-mysql/30283)

**Author:** [@AK51](https://discourse.nodered.org/u/AK51)\ **Replies:** 5\ **Last updated:** [18 July 2020 15:46 UTC](https://discourse.nodered.org/t/excel-file-to-mysql/30283 "2020-07-18T15:46:14Z")

Hi, I have an excel file (1000 rows), I can use spreadsheet-in to convert the data in one whole json. Is it feasible to insert 1000 rows into the mysql table? If not, I am looking for a method to read the excel one row … --- ## [Types of NoSQL DB](https://discourse.nodered.org/t/types-of-nosql-db/29870)

**Author:** [@Martin10](https://discourse.nodered.org/u/Martin10)\ **Replies:** 18\ **Last updated:** [18 July 2020 09:43 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870 "2020-07-18T09:43:52Z")

Hi. How many types of NoSQL DB have in NR? And which is better for sensor data gathering (SQL or NoSQL)? --- ## [Not able to connect to my dashboard over public ip](https://discourse.nodered.org/t/not-able-to-connect-to-my-dashboard-over-public-ip/30197)

**Author:** [@caster1](https://discourse.nodered.org/u/caster1)\ **Replies:** 5\ **Last updated:** [18 July 2020 08:59 UTC](https://discourse.nodered.org/t/not-able-to-connect-to-my-dashboard-over-public-ip/30197 "2020-07-18T08:59:35Z")

I've been trying very hard to access my node re\* on pi over internet. I'm using my public ip : 1880 (node red port to connect) , I've done port forwarding over my binatone router , with service port as 1880 and internal … --- ## [Fetching data from actility server into node-red](https://discourse.nodered.org/t/fetching-data-from-actility-server-into-node-red/30286)

**Author:** [@kumaran](https://discourse.nodered.org/u/kumaran)\ **Replies:** 3\ **Last updated:** [18 July 2020 08:53 UTC](https://discourse.nodered.org/t/fetching-data-from-actility-server-into-node-red/30286 "2020-07-18T08:53:23Z")

Here am trying to fetch the data from actility server into node-red but am not aware about that. if anyone know about this please give the suggestion. [Previous page](https://discourse.nodered.org/c/general/7.md?page=710) [Next page](https://discourse.nodered.org/c/general/7.md?page=712)