# General

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

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

**Page:** 752

---

## [Error in insert data to database](https://discourse.nodered.org/t/error-in-insert-data-to-database/26406)

<div class="topic-metadata">

**Author:** [@lingzhongli](https://discourse.nodered.org/u/lingzhongli)\
**Replies:** 10\
**Last updated:** [10 May 2020 11:51 UTC](https://discourse.nodered.org/t/error-in-insert-data-to-database/26406 "2020-05-10T11:51:03Z")

</div>

i got this kind of error when insert data... USER database HISTORY database var spokenAsText = msg.payload;// or where ever the speech to text is var SQL = "INSERT INTO HISTORY (NAME) SELECT NAME FROM USER WHERE…

---

## [Organising Data for a temperature logger](https://discourse.nodered.org/t/organising-data-for-a-temperature-logger/26375)

<div class="topic-metadata">

**Author:** [@Hylkebab](https://discourse.nodered.org/u/Hylkebab)\
**Replies:** 6\
**Last updated:** [10 May 2020 11:43 UTC](https://discourse.nodered.org/t/organising-data-for-a-temperature-logger/26375 "2020-05-10T11:43:17Z")

</div>

Hello, Im doing a project where I need to log temperatures into a file so that I can later make a model from it. This is my first time ever using Node Red/programming. Right now my flow produces the information I need a…

---

## [Google Assistant: get Home Graph traits for all devices](https://discourse.nodered.org/t/google-assistant-get-home-graph-traits-for-all-devices/26416)

<div class="topic-metadata">

**Author:** [@gertst](https://discourse.nodered.org/u/gertst)\
**Replies:** 0\
**Last updated:** [10 May 2020 11:02 UTC](https://discourse.nodered.org/t/google-assistant-get-home-graph-traits-for-all-devices/26416 "2020-05-10T11:02:01Z")

</div>

Hi, Is it possible to read out the Google Home Graph to get the state of connected devices? For example: Can I get the destination temperature of my Nest Thermostat? Can I get the remaining time of a running Timer on…

---

## [VCGENCMD node, funny output/](https://discourse.nodered.org/t/vcgencmd-node-funny-output/26400)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 14\
**Last updated:** [10 May 2020 10:39 UTC](https://discourse.nodered.org/t/vcgencmd-node-funny-output/26400 "2020-05-10T10:39:23Z")

</div>

I have the node-red-contrib-vcgencmd node installed. Now and then when working on/in the machine I am getting this: Previous vcgencmd command hasn't finished yet Two message when I get one input signal. Basic flow: c…

---

## [Unable to start node-red after installing modbus sample code](https://discourse.nodered.org/t/unable-to-start-node-red-after-installing-modbus-sample-code/26393)

<div class="topic-metadata">

**Author:** [@Zaza](https://discourse.nodered.org/u/Zaza)\
**Replies:** 9\
**Last updated:** [10 May 2020 09:58 UTC](https://discourse.nodered.org/t/unable-to-start-node-red-after-installing-modbus-sample-code/26393 "2020-05-10T09:58:39Z")

</div>

Hi all, I recently copied the codes below related to modebus master and slave. Node red is not starting, and I am getting the error below. How do I go about solving or clearing the error? 9 May 21:46:27 - \[info\] Starti…

---

## [Does it matter?](https://discourse.nodered.org/t/does-it-matter/26398)

<div class="topic-metadata">

**Author:** [@asdf123](https://discourse.nodered.org/u/asdf123)\
**Replies:** 4\
**Last updated:** [10 May 2020 08:47 UTC](https://discourse.nodered.org/t/does-it-matter/26398 "2020-05-10T08:47:00Z")

</div>

Hello, I have a function, which results string array. I want to insert it into sqlite database line by line. Each line is the following value. Do I have to somehow convert the function message in order to insert it into…

---

## [Loops inside a node](https://discourse.nodered.org/t/loops-inside-a-node/26402)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 7\
**Last updated:** [10 May 2020 08:07 UTC](https://discourse.nodered.org/t/loops-inside-a-node/26402 "2020-05-10T08:07:49Z")

</div>

I am delving into loops for some reason. I send a payload (number) and the node spits out that many messages. (Contents not important) So for now this is the code: let x = msg.payload; let y = 0; context.set("COUNT",…

---

## [Help with nube-logic nodes set](https://discourse.nodered.org/t/help-with-nube-logic-nodes-set/26399)

<div class="topic-metadata">

**Author:** [@ajaymccollum](https://discourse.nodered.org/u/ajaymccollum)\
**Replies:** 8\
**Last updated:** [10 May 2020 08:00 UTC](https://discourse.nodered.org/t/help-with-nube-logic-nodes-set/26399 "2020-05-10T08:00:09Z")

</div>

I'm trying to use some nodes out of node-red-contrib-nube-logic, but as there is no description at all on how to use any of them, combined with my general inexperience, I have no idea what these things want from me to fu…

---

## [How can I split a message?](https://discourse.nodered.org/t/how-can-i-split-a-message/26396)

<div class="topic-metadata">

**Author:** [@asdf123](https://discourse.nodered.org/u/asdf123)\
**Replies:** 5\
**Last updated:** [10 May 2020 05:59 UTC](https://discourse.nodered.org/t/how-can-i-split-a-message/26396 "2020-05-10T05:59:09Z")

</div>

Hello, I have a function node, which return an array as a message: var r = /\\W+/; msg.payload = msg.payload.split(r); var msg1 = { payload: msg.payload.length } msg1.payload = ""; for (var i = 0; i \< msg.payload.length…

---

## [Optimize the flow management panel](https://discourse.nodered.org/t/optimize-the-flow-management-panel/25066)

<div class="topic-metadata">

**Author:** [@cmdares](https://discourse.nodered.org/u/cmdares)\
**Replies:** 3\
**Last updated:** [10 May 2020 03:30 UTC](https://discourse.nodered.org/t/optimize-the-flow-management-panel/25066 "2020-05-10T03:30:00Z")

</div>

At present, the platform has 80 flow and needs to optimize the flow management panel Problem: 1、Slow opening speed 2、There is no hierarchy in management Hope for improvement: Add close button to each tab flow can b…

---

## [Instructions to deploy on Azure/Ubuntu LTS 18.04 fail](https://discourse.nodered.org/t/instructions-to-deploy-on-azure-ubuntu-lts-18-04-fail/26070)

<div class="topic-metadata">

**Author:** [@Eelco](https://discourse.nodered.org/u/Eelco)\
**Replies:** 7\
**Last updated:** [9 May 2020 22:45 UTC](https://discourse.nodered.org/t/instructions-to-deploy-on-azure-ubuntu-lts-18-04-fail/26070 "2020-05-09T22:45:33Z")

</div>

I did create new VM today on Azure and tried to deploy NodeRed per Running on Microsoft Azure : Node-RED The process broke on installation of node red with error in bcrypt. I did use work-around to install unsafe, i.e.…

---

## [Editor tab limits?](https://discourse.nodered.org/t/editor-tab-limits/26279)

<div class="topic-metadata">

**Author:** [@LosinIt](https://discourse.nodered.org/u/LosinIt)\
**Replies:** 9\
**Last updated:** [9 May 2020 20:12 UTC](https://discourse.nodered.org/t/editor-tab-limits/26279 "2020-05-09T20:12:10Z")

</div>

I'm trying to keep flows organized by control type and to keep the number of editor tabs to a minimum. I see that I have to use the full deploy to get edits activated as neither of the "modified" options has any effect. …

---

## [Onvif camera control](https://discourse.nodered.org/t/onvif-camera-control/6888)

<div class="topic-metadata">

**Author:** [@davidcgu](https://discourse.nodered.org/u/davidcgu)\
**Replies:** 114\
**Last updated:** [9 May 2020 17:34 UTC](https://discourse.nodered.org/t/onvif-camera-control/6888 "2020-05-09T17:34:41Z")

</div>

Good afternoon I know it was some work in progress from someone about this, managing a onvif camera... Does someone did already some on managing PTZ etc...? Thanks in advance

---

## [Rpi-gpio in node - always incorrect first read after boot](https://discourse.nodered.org/t/rpi-gpio-in-node-always-incorrect-first-read-after-boot/26339)

<div class="topic-metadata">

**Author:** [@davidwatty](https://discourse.nodered.org/u/davidwatty)\
**Replies:** 19\
**Last updated:** [9 May 2020 16:59 UTC](https://discourse.nodered.org/t/rpi-gpio-in-node-always-incorrect-first-read-after-boot/26339 "2020-05-09T16:59:51Z")

</div>

Hi All, First post on here so hopefully I'm in the right place. I am having a strange issue with rpi-gpio in... The box on the rpi-gpio in node that says "Read initial state of pin on deploy/restart?" is ticked on all…

---

## [Problem with location state & Actionable IOS mobile\_app](https://discourse.nodered.org/t/problem-with-location-state-actionable-ios-mobile-app/26387)

<div class="topic-metadata">

**Author:** [@CaptainSweatpants](https://discourse.nodered.org/u/CaptainSweatpants)\
**Replies:** 0\
**Last updated:** [9 May 2020 16:21 UTC](https://discourse.nodered.org/t/problem-with-location-state-actionable-ios-mobile-app/26387 "2020-05-09T16:21:07Z")

</div>

Heres what im trying to accomplish; I want an Actionable IOS notification sent when I leave home (tracked by life360). The choices on that IOS notification would be; "WALK" and "AWAY". If "WALK" selected do X if "AWAY"…

---

## [IFM Vibrations VSE150](https://discourse.nodered.org/t/ifm-vibrations-vse150/26356)

<div class="topic-metadata">

**Author:** [@DaveMou](https://discourse.nodered.org/u/DaveMou)\
**Replies:** 11\
**Last updated:** [9 May 2020 16:06 UTC](https://discourse.nodered.org/t/ifm-vibrations-vse150/26356 "2020-05-09T16:06:46Z")

</div>

Dear all, Does somebody has any experience with this sensors and node red? I have a project where I must use them. Thank you!

---

## [Using environment variable as password for "MQTT in" node](https://discourse.nodered.org/t/using-environment-variable-as-password-for-mqtt-in-node/26318)

<div class="topic-metadata">

**Author:** [@Myzhar](https://discourse.nodered.org/u/Myzhar)\
**Replies:** 4\
**Last updated:** [9 May 2020 15:40 UTC](https://discourse.nodered.org/t/using-environment-variable-as-password-for-mqtt-in-node/26318 "2020-05-09T15:40:47Z")

</div>

Hi all, I'm trying to use an environment variable for connect to a MQTT broker (node "MQTT in") without entering the credential each time I start my node-red server. I tried both $(ENV\_VAR) and ${ENV\_VAR} syntaxes, but…

---

## [Node-red-contrib-amazon-echo problem](https://discourse.nodered.org/t/node-red-contrib-amazon-echo-problem/26320)

<div class="topic-metadata">

**Author:** [@Pfanne98](https://discourse.nodered.org/u/Pfanne98)\
**Replies:** 3\
**Last updated:** [9 May 2020 12:23 UTC](https://discourse.nodered.org/t/node-red-contrib-amazon-echo-problem/26320 "2020-05-09T12:23:55Z")

</div>

Hi, i have a Raspberry Pi 4 with IOBroker and the Node-Red adapterand i like to control some lights with alexa, so i get the palette "node-red-contrib-amazon-echo". After that i insertet the amazon echo hub and a device…

---

## [Extract color from location on image](https://discourse.nodered.org/t/extract-color-from-location-on-image/26344)

<div class="topic-metadata">

**Author:** [@thebaldgeek](https://discourse.nodered.org/u/thebaldgeek)\
**Replies:** 4\
**Last updated:** [9 May 2020 12:01 UTC](https://discourse.nodered.org/t/extract-color-from-location-on-image/26344 "2020-05-09T12:01:35Z")

</div>

I would like to try and extract a color value (don't care what format) from a specific location on an image. Here is the image I am using; http://www.sws.bom.gov.au/Images/HF%20Systems/Global%20HF/HAP%20Charts/San%20Fra…

---

## [Help for sending a websocket command](https://discourse.nodered.org/t/help-for-sending-a-websocket-command/26373)

<div class="topic-metadata">

**Author:** [@Blupendo](https://discourse.nodered.org/u/Blupendo)\
**Replies:** 0\
**Last updated:** [9 May 2020 11:31 UTC](https://discourse.nodered.org/t/help-for-sending-a-websocket-command/26373 "2020-05-09T11:31:02Z")

</div>

Morning, everyone, To control my TV set-top box, it is possible to send it Websocket messages. I have intercepted messages in the Firefox console that are in the format : {"Params":{"Token": "LAN", "Action": "ButtonEve…

---

## [{{ ChatBOT}} Node red + MySQL + Viber](https://discourse.nodered.org/t/chatbot-node-red-mysql-viber/26259)

<div class="topic-metadata">

**Author:** [@Aklex1](https://discourse.nodered.org/u/Aklex1)\
**Replies:** 3\
**Last updated:** [9 May 2020 10:49 UTC](https://discourse.nodered.org/t/chatbot-node-red-mysql-viber/26259 "2020-05-09T10:49:16Z")

</div>

Eureka! Hello everyone, did anyone do a chatbot? Guys, share your impressions. Recently I launched a chatbot that records my wife’s clients to her for a manicure! Chatbot so far only works in Viber He can: Read the…

---

## [How to compare two msg.payload in a same flow](https://discourse.nodered.org/t/how-to-compare-two-msg-payload-in-a-same-flow/26174)

<div class="topic-metadata">

**Author:** [@lingzhongli](https://discourse.nodered.org/u/lingzhongli)\
**Replies:** 25\
**Last updated:** [9 May 2020 10:22 UTC](https://discourse.nodered.org/t/how-to-compare-two-msg-payload-in-a-same-flow/26174 "2020-05-09T10:22:47Z")

</div>

from this flow, i want to comapre output of speech to text and DB\_MYSQL. But both output show in msg.payload (although i have change the msg.payload of speech to text to transcription by using Transcription, it also wi…

---

## [Float to int bits](https://discourse.nodered.org/t/float-to-int-bits/26281)

<div class="topic-metadata">

**Author:** [@slogan87](https://discourse.nodered.org/u/slogan87)\
**Replies:** 2\
**Last updated:** [8 May 2020 22:38 UTC](https://discourse.nodered.org/t/float-to-int-bits/26281 "2020-05-08T22:38:56Z")

</div>

HI everyone, I was wondering if I could please get some help. I am trying to convert a floating value to individual bits so I can convert it to 2 16 bit registers to send through modbus to a plc. I have been trying to …

---

## [\[OPC UA\] iiot-opcua has been deprecated](https://discourse.nodered.org/t/opc-ua-iiot-opcua-has-been-deprecated/26300)

<div class="topic-metadata">

**Author:** [@Nxito](https://discourse.nodered.org/u/Nxito)\
**Replies:** 3\
**Last updated:** [8 May 2020 22:19 UTC](https://discourse.nodered.org/t/opc-ua-iiot-opcua-has-been-deprecated/26300 "2020-05-08T22:19:23Z")

</div>

This post is for those who have or are using node-red-contrib-iiot-opcua node-red-contrib-iiot-opcua has been deprecated and now the following versions are versions of payment. i have some questions because it is the…

---

## [Home automation light with button ( Raspberry GPIO )](https://discourse.nodered.org/t/home-automation-light-with-button-raspberry-gpio/26333)

<div class="topic-metadata">

**Author:** [@Golia20](https://discourse.nodered.org/u/Golia20)\
**Replies:** 0\
**Last updated:** [8 May 2020 21:00 UTC](https://discourse.nodered.org/t/home-automation-light-with-button-raspberry-gpio/26333 "2020-05-08T21:00:27Z")

</div>

hello i'm Leonardo i have a problem with this: i want to turn on light and turn off with Alexa and button. The part of Alexa in complete and now it's possible turn on and turn off relay. The part of button is incompl…

---

## [Deploy button stopped working suddenly](https://discourse.nodered.org/t/deploy-button-stopped-working-suddenly/26321)

<div class="topic-metadata">

**Author:** [@josekavunkal](https://discourse.nodered.org/u/josekavunkal)\
**Replies:** 2\
**Last updated:** [8 May 2020 17:26 UTC](https://discourse.nodered.org/t/deploy-button-stopped-working-suddenly/26321 "2020-05-08T17:26:31Z")

</div>

Getting following error DevTools failed to load SourceMap: Could not load content for http://ip:port/vendor/purify.min.js.map: HTTP error: status code 404, net::ERR\_HTTP\_RESPONSE\_CODE\_FAILURE red.min.js:16 Node-RED: 1.…

---

## [Listen to mqtt message and send out a new modify/trasformed one](https://discourse.nodered.org/t/listen-to-mqtt-message-and-send-out-a-new-modify-trasformed-one/26196)

<div class="topic-metadata">

**Author:** [@megamarco83](https://discourse.nodered.org/u/megamarco83)\
**Replies:** 15\
**Last updated:** [8 May 2020 17:22 UTC](https://discourse.nodered.org/t/listen-to-mqtt-message-and-send-out-a-new-modify-trasformed-one/26196 "2020-05-08T17:22:55Z")

</div>

hi, i need to listen to mqtt message from 5 different devices: stat/tasmota\_156/# stat/tasmota\_157/# stat/tasmota\_160/# stat/tasmota\_161/# stat/tasmota\_162/# on listening to this i want to filter messages like this, e…

---

## [Read vibration sensor data](https://discourse.nodered.org/t/read-vibration-sensor-data/26316)

<div class="topic-metadata">

**Author:** [@Back\_har](https://discourse.nodered.org/u/Back_har)\
**Replies:** 0\
**Last updated:** [8 May 2020 15:46 UTC](https://discourse.nodered.org/t/read-vibration-sensor-data/26316 "2020-05-08T15:46:57Z")

</div>

Dear all, Im beginner and start learning Node-Red. Im trying to read a vibration sensor data that comes according below: 1st (X) data string: “^008, 1256,Xpk, 2504,Xrms,2.99,V,028%” 2nd (Y) data string: “^008, 3456,Ypk…

---

## [If/else in JSONata expressions](https://discourse.nodered.org/t/if-else-in-jsonata-expressions/26194)

<div class="topic-metadata">

**Author:** [@iStitch07](https://discourse.nodered.org/u/iStitch07)\
**Replies:** 31\
**Last updated:** [8 May 2020 13:04 UTC](https://discourse.nodered.org/t/if-else-in-jsonata-expressions/26194 "2020-05-08T13:04:40Z")

</div>

Hello. Noob question, but... ) it's posible to use if/else in JSONata expressions? I have this expression. { "brightness\_pct" : payload.brightness, "hs\_color" : \[payload.hue, payload.saturation\] } In rare cas…

---

## [Output order dynamically](https://discourse.nodered.org/t/output-order-dynamically/26224)

<div class="topic-metadata">

**Author:** [@Assi](https://discourse.nodered.org/u/Assi)\
**Replies:** 5\
**Last updated:** [8 May 2020 11:51 UTC](https://discourse.nodered.org/t/output-order-dynamically/26224 "2020-05-08T11:51:27Z")

</div>

Hello, I have a flow with 2 outputs going out of Node RED which are set at the same time. The call order is important for the outer system. I can controll the order statically by changing positions. Maybe its also cont…

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

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