# General

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

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

**Page:** 820

---

## [Select Array from MSSQL and insert into postgresql](https://discourse.nodered.org/t/select-array-from-mssql-and-insert-into-postgresql/18820)

<div class="topic-metadata">

**Author:** [@nameegal](https://discourse.nodered.org/u/nameegal)\
**Replies:** 0\
**Last updated:** [5 December 2019 10:01 UTC](https://discourse.nodered.org/t/select-array-from-mssql-and-insert-into-postgresql/18820 "2019-12-05T10:01:24Z")

</div>

Hi. I try to read an array from MSSQL database and insert the Array data into a postgresql database. From the postgres node I get the "Error: msg.payload must be an array of queries". The Output from mssql is an Array …

---

## [Convert csv format to JSON format](https://discourse.nodered.org/t/convert-csv-format-to-json-format/18810)

<div class="topic-metadata">

**Author:** [@rajendran20](https://discourse.nodered.org/u/rajendran20)\
**Replies:** 6\
**Last updated:** [5 December 2019 09:14 UTC](https://discourse.nodered.org/t/convert-csv-format-to-json-format/18810 "2019-12-05T09:14:21Z")

</div>

Hi I am getting a MQTT data in csv data format 1,1.4439263,103.7842,1575539820. Basically its a GPS data in the following format (#, lat, lng, timestamp) I need to create a JSON file in this manner. \[ 1, { "lat" : 1.44…

---

## [Flows Starting without login](https://discourse.nodered.org/t/flows-starting-without-login/18806)

<div class="topic-metadata">

**Author:** [@Devbrat](https://discourse.nodered.org/u/Devbrat)\
**Replies:** 5\
**Last updated:** [5 December 2019 08:35 UTC](https://discourse.nodered.org/t/flows-starting-without-login/18806 "2019-12-05T08:35:51Z")

</div>

I have enabled authentication in node-red, But I assume according to development, flows are getting started before login and keeps running after logout. Is this correct behavior? If yes then is there any way to stop th…

---

## [NodeRed doesn’t start](https://discourse.nodered.org/t/nodered-doesn-t-start/18542)

<div class="topic-metadata">

**Author:** [@rajendran20](https://discourse.nodered.org/u/rajendran20)\
**Replies:** 4\
**Last updated:** [5 December 2019 05:11 UTC](https://discourse.nodered.org/t/nodered-doesn-t-start/18542 "2019-12-05T05:11:26Z")

</div>

I had installed node red and started the dashboard. Installed some Firebase modes and did some testing. When deploy, the server prompts connection has been lost. Now my node-red can’t startup from the terminal. It exits…

---

## [Node-red stops when i quit Kodi](https://discourse.nodered.org/t/node-red-stops-when-i-quit-kodi/18706)

<div class="topic-metadata">

**Author:** [@Pipo1nsano](https://discourse.nodered.org/u/Pipo1nsano)\
**Replies:** 2\
**Last updated:** [4 December 2019 20:46 UTC](https://discourse.nodered.org/t/node-red-stops-when-i-quit-kodi/18706 "2019-12-04T20:46:00Z")

</div>

I use " node-red-contrib-kodi" to control my light when watching movies but when i quit kodi node-red crashes.. I cannot understand why.. Does anyone have a clue? 2 Dec 19:38:06 - \[red\] Uncaught Exception: 2 Dec 19:38:…

---

## [Convert datetime - template](https://discourse.nodered.org/t/convert-datetime-template/18606)

<div class="topic-metadata">

**Author:** [@EL\_tech](https://discourse.nodered.org/u/EL_tech)\
**Replies:** 17\
**Last updated:** [4 December 2019 18:27 UTC](https://discourse.nodered.org/t/convert-datetime-template/18606 "2019-12-04T18:27:20Z")

</div>

Hay! I try to convert a datetime (format: YYYY-MM-DDT00:00:00) from a json format and put it in a cell of a table to display it on the dashboard. It doesn't work and I don´t know how I get it. Sorry, I'm a beginner wi…

---

## [ Not too sure what I've messed up here. I'm trying to send a command to an API to control my aircon system](https://discourse.nodered.org/t/not-too-sure-what-ive-messed-up-here-im-trying-to-send-a-command-to-an-api-to-control-my-aircon-system/10213)

<div class="topic-metadata">

**Author:** [@simonk83](https://discourse.nodered.org/u/simonk83)\
**Replies:** 17\
**Last updated:** [4 December 2019 17:20 UTC](https://discourse.nodered.org/t/not-too-sure-what-ive-messed-up-here-im-trying-to-send-a-command-to-an-api-to-control-my-aircon-system/10213 "2019-12-04T17:20:12Z")

</div>

Hi all, So If I send the following command via curl in a terminal, it does work fine: curl \\ -H 'Host: que.actronair.com.au' \\ -H 'Accept: application/json' \\ -H 'Accept-Language: en-AU;q=1' \\ -H 'User-Agent: nxgen-ios…

---

## [Try to install mysensors Palette](https://discourse.nodered.org/t/try-to-install-mysensors-palette/17071)

<div class="topic-metadata">

**Author:** [@github6043](https://discourse.nodered.org/u/github6043)\
**Replies:** 6\
**Last updated:** [4 December 2019 15:14 UTC](https://discourse.nodered.org/t/try-to-install-mysensors-palette/17071 "2019-12-04T15:14:25Z")

</div>

Hi all I run a NodeRed VM based on Ubuntu 18.04 LTS. All works fine so far. Now I'd like to use mysensors Extension. Trying to install results in the followin error, (NodeRed Dashboard is installed in the Version 2.17.1…

---

## [Write to an external tag from node red](https://discourse.nodered.org/t/write-to-an-external-tag-from-node-red/18738)

<div class="topic-metadata">

**Author:** [@mohammedtaha](https://discourse.nodered.org/u/mohammedtaha)\
**Replies:** 7\
**Last updated:** [4 December 2019 14:59 UTC](https://discourse.nodered.org/t/write-to-an-external-tag-from-node-red/18738 "2019-12-04T14:59:43Z")

</div>

hello i need to write to ana external tag, i want to use a slider and assigne it to the output on the kepserverx

---

## [MQTT node - can't use domain name](https://discourse.nodered.org/t/mqtt-node-cant-use-domain-name/18759)

<div class="topic-metadata">

**Author:** [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Replies:** 10\
**Last updated:** [4 December 2019 11:56 UTC](https://discourse.nodered.org/t/mqtt-node-cant-use-domain-name/18759 "2019-12-04T11:56:30Z")

</div>

I'm still struggling with setting up TLS with the node-RED MQTT node..... Broker My broker is a Mosquitto server running on a Raspberry Pi at home. I've added a Mosquitto config file linking to the broker's Letsencrypt…

---

## [Editing the code of a node](https://discourse.nodered.org/t/editing-the-code-of-a-node/18739)

<div class="topic-metadata">

**Author:** [@bmeester](https://discourse.nodered.org/u/bmeester)\
**Replies:** 4\
**Last updated:** [4 December 2019 11:36 UTC](https://discourse.nodered.org/t/editing-the-code-of-a-node/18739 "2019-12-04T11:36:47Z")

</div>

Is it possible to edit the code of a node? If yes, where are these files stored?

---

## [In windows how to log only tcp recived data in file with data recieved time](https://discourse.nodered.org/t/in-windows-how-to-log-only-tcp-recived-data-in-file-with-data-recieved-time/18722)

<div class="topic-metadata">

**Author:** [@VIKRAMAS](https://discourse.nodered.org/u/VIKRAMAS)\
**Replies:** 2\
**Last updated:** [4 December 2019 11:31 UTC](https://discourse.nodered.org/t/in-windows-how-to-log-only-tcp-recived-data-in-file-with-data-recieved-time/18722 "2019-12-04T11:31:48Z")

</div>

In Node-red I am recieving node-red data from TCP. I wanted to log the data recieved and the time. How can I log this in windows.

---

## [iOS 13 - Shortcuts](https://discourse.nodered.org/t/ios-13-shortcuts/18758)

<div class="topic-metadata">

**Author:** [@nicedevil](https://discourse.nodered.org/u/nicedevil)\
**Replies:** 1\
**Last updated:** [4 December 2019 11:25 UTC](https://discourse.nodered.org/t/ios-13-shortcuts/18758 "2019-12-04T11:25:06Z")

</div>

Hey guys, I was watching a video from a german guy that used NFC tags to trigger events with iOS Shortcuts on ioBroker. https://www.youtube.com/watch?v=AUdZgZinHzo Now I'm looking for a simple solution to achieve the s…

---

## [Check Battery Level using Node Red](https://discourse.nodered.org/t/check-battery-level-using-node-red/18768)

<div class="topic-metadata">

**Author:** [@gbos3415](https://discourse.nodered.org/u/gbos3415)\
**Replies:** 3\
**Last updated:** [4 December 2019 11:11 UTC](https://discourse.nodered.org/t/check-battery-level-using-node-red/18768 "2019-12-04T11:11:52Z")

</div>

Hello, I am new in-home automation especially using Node-Red. I have about 5 Zigbee door sensors that I would like to set up notification using Node-Red so if the battery level drops to 10% I will get ios notification i…

---

## [Invalid properties: output](https://discourse.nodered.org/t/invalid-properties-output/18780)

<div class="topic-metadata">

**Author:** [@Mikha123](https://discourse.nodered.org/u/Mikha123)\
**Replies:** 1\
**Last updated:** [4 December 2019 10:52 UTC](https://discourse.nodered.org/t/invalid-properties-output/18780 "2019-12-04T10:52:27Z")

</div>

I make program to control ac with nodered, using IR Transmit. I had follow this video https://youtu.be/ZiCPfNIP5p8 but stack in this step when i tried run in terminal followed this tutorial http://www.piddlerintheroot…

---

## [Flow/global variables](https://discourse.nodered.org/t/flow-global-variables/18777)

<div class="topic-metadata">

**Author:** [@iotkismec](https://discourse.nodered.org/u/iotkismec)\
**Replies:** 1\
**Last updated:** [4 December 2019 07:27 UTC](https://discourse.nodered.org/t/flow-global-variables/18777 "2019-12-04T07:27:19Z")

</div>

How to refresh flow/global variables value? For my project, need two times of inject to get the latest value inside flow/global variables.

---

## [Can I wire up nodes without the editor](https://discourse.nodered.org/t/can-i-wire-up-nodes-without-the-editor/18755)

<div class="topic-metadata">

**Author:** [@whimsica](https://discourse.nodered.org/u/whimsica)\
**Replies:** 4\
**Last updated:** [3 December 2019 21:52 UTC](https://discourse.nodered.org/t/can-i-wire-up-nodes-without-the-editor/18755 "2019-12-03T21:52:02Z")

</div>

Is it possible to create and wire together nodes and flows without the editor. I'd imagine something like create flow add node connect node add node connect node run flow using just a script that uses the node re…

---

## [Knx - velux dashboard](https://discourse.nodered.org/t/knx-velux-dashboard/18757)

<div class="topic-metadata">

**Author:** [@tge](https://discourse.nodered.org/u/tge)\
**Replies:** 0\
**Last updated:** [3 December 2019 20:54 UTC](https://discourse.nodered.org/t/knx-velux-dashboard/18757 "2019-12-03T20:54:56Z")

</div>

Hi, i try to connect my Velux KLF200 into my KNX Installation. In my testing Environment i can run Velux Scenes from my Node Red Dasboard - very good :wink: Now i want to trigger this Scene when a KNX Message arrives. …

---

## [Brain stopped working! (heater failsafe)](https://discourse.nodered.org/t/brain-stopped-working-heater-failsafe/18656)

<div class="topic-metadata">

**Author:** [@877](https://discourse.nodered.org/u/877)\
**Replies:** 13\
**Last updated:** [3 December 2019 18:33 UTC](https://discourse.nodered.org/t/brain-stopped-working-heater-failsafe/18656 "2019-12-03T18:33:54Z")

</div>

I'm having brainblock with this: The timeout node sends "false" when it doesn''t hear from the temperature sensor for 1minute. I want this to override the "true" output of the thermostat node, so that the heater goes…

---

## [Screenshot a webpage and send email using nodered](https://discourse.nodered.org/t/screenshot-a-webpage-and-send-email-using-nodered/8973)

<div class="topic-metadata">

**Author:** [@alex1](https://discourse.nodered.org/u/alex1)\
**Replies:** 6\
**Last updated:** [3 December 2019 18:04 UTC](https://discourse.nodered.org/t/screenshot-a-webpage-and-send-email-using-nodered/8973 "2019-12-03T18:04:17Z")

</div>

can i actually take webshot of a webpage then email it using nodered? i did try to use the webshot palette...but it keep on crashing whenever i trigger it. Crashing means.....i will be logout from my Node-RED

---

## [Rpi camera live stream and shoot photo](https://discourse.nodered.org/t/rpi-camera-live-stream-and-shoot-photo/18749)

<div class="topic-metadata">

**Author:** [@RogierQ](https://discourse.nodered.org/u/RogierQ)\
**Replies:** 2\
**Last updated:** [3 December 2019 17:59 UTC](https://discourse.nodered.org/t/rpi-camera-live-stream-and-shoot-photo/18749 "2019-12-03T17:59:57Z")

</div>

I guess that i am not the first playing around with it but cannot find any solution on google. What i can find is how to create a livestream https://randomnerdtutorials.com/video-streaming-with-raspberry-pi-camera/?unap…

---

## [How to build a custom docker image with a login and password as envrionment variables](https://discourse.nodered.org/t/how-to-build-a-custom-docker-image-with-a-login-and-password-as-envrionment-variables/18747)

<div class="topic-metadata">

**Author:** [@miled](https://discourse.nodered.org/u/miled)\
**Replies:** 0\
**Last updated:** [3 December 2019 15:57 UTC](https://discourse.nodered.org/t/how-to-build-a-custom-docker-image-with-a-login-and-password-as-envrionment-variables/18747 "2019-12-03T15:57:18Z")

</div>

I'm using a custom docker image. How can I build a docker image with a login and password as envrionment variables ? Thanks

---

## [Homekit-bridged + mDNS issue](https://discourse.nodered.org/t/homekit-bridged-mdns-issue/17594)

<div class="topic-metadata">

**Author:** [@sapster77](https://discourse.nodered.org/u/sapster77)\
**Replies:** 33\
**Last updated:** [2 December 2019 09:23 UTC](https://discourse.nodered.org/t/homekit-bridged-mdns-issue/17594 "2019-12-02T09:23:25Z")

</div>

Hi, I have run out of ideas and places to search, so I'm hoping someone may have an idea on what to try with regards to the following: I have migrated my system to a Raspberry Pi 4 from a 3 and are now facing issues wi…

---

## [Need help with FTP](https://discourse.nodered.org/t/need-help-with-ftp/18718)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [3 December 2019 09:26 UTC](https://discourse.nodered.org/t/need-help-with-ftp/18718 "2019-12-03T09:26:18Z")

</div>

I have a couple of FTP nodes installed: node-red-contrib-ftp-server on the receiving device and: node-red-contrib-ftp on the sending machine. Alas I am not really getting much done. One wants msg.filename for the r…

---

## [Anfänger Fragen](https://discourse.nodered.org/t/anfanger-fragen/18684)

<div class="topic-metadata">

**Author:** [@Botschafter](https://discourse.nodered.org/u/Botschafter)\
**Replies:** 9\
**Last updated:** [3 December 2019 07:40 UTC](https://discourse.nodered.org/t/anfanger-fragen/18684 "2019-12-03T07:40:30Z")

</div>

Hallo zusammen, leider werde ich gerade erschlagen von den vielen bund gemischten Beiträgen hier. Einfache Frage: wie und wo bitte am Besten als absoluter Laie einsteigen ? Herzlichen Dank im Voraus und schöne Grüße …

---

## [How to use COAP over DTLS](https://discourse.nodered.org/t/how-to-use-coap-over-dtls/15141)

<div class="topic-metadata">

**Author:** [@Sanjaycoder-r](https://discourse.nodered.org/u/Sanjaycoder-r)\
**Replies:** 4\
**Last updated:** [3 December 2019 07:24 UTC](https://discourse.nodered.org/t/how-to-use-coap-over-dtls/15141 "2019-12-03T07:24:21Z")

</div>

In nodered COAP (node-red-contrib-coap node) it uses UDP by default but if I want to use COAP over DTLS how to configure as there is not options available or is there any alternate available for using COAP over DTLS.

---

## [Numeric Item with string Value](https://discourse.nodered.org/t/numeric-item-with-string-value/18694)

<div class="topic-metadata">

**Author:** [@hermann1514](https://discourse.nodered.org/u/hermann1514)\
**Replies:** 3\
**Last updated:** [3 December 2019 06:27 UTC](https://discourse.nodered.org/t/numeric-item-with-string-value/18694 "2019-12-03T06:27:46Z")

</div>

Hello, I would like to have the label of the Numeric Items displayed in color depending on a status. The heating can be controlled via the dashboard. For this I have created a numeric item. If the window in the room is…

---

## [Looking Up Data from One Array to a Second Array](https://discourse.nodered.org/t/looking-up-data-from-one-array-to-a-second-array/18696)

<div class="topic-metadata">

**Author:** [@CHR1ST00](https://discourse.nodered.org/u/CHR1ST00)\
**Replies:** 2\
**Last updated:** [3 December 2019 00:25 UTC](https://discourse.nodered.org/t/looking-up-data-from-one-array-to-a-second-array/18696 "2019-12-03T00:25:12Z")

</div>

Hello all, thank you for the great resource that this forum is. I am looking for some assistance in looking up variables. For example, if I have an "Array1" that returns: \[ {"id":1,"name":"abc,"label\_ids":1}, {"id":2,…

---

## ["Installation" version control together with "Project" version control](https://discourse.nodered.org/t/installation-version-control-together-with-project-version-control/18716)

<div class="topic-metadata">

**Author:** [@amodelbello](https://discourse.nodered.org/u/amodelbello)\
**Replies:** 0\
**Last updated:** [2 December 2019 23:29 UTC](https://discourse.nodered.org/t/installation-version-control-together-with-project-version-control/18716 "2019-12-02T23:29:43Z")

</div>

The multi-project feature with version control is super awesome but I haven't been able to figure out how to get it to work inside a Node-Red installation that is itself in a git repository. I have a git repo with custo…

---

## [Updated NR and have a \*funny\* error](https://discourse.nodered.org/t/updated-nr-and-have-a-funny-error/18710)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 10\
**Last updated:** [2 December 2019 23:13 UTC](https://discourse.nodered.org/t/updated-nr-and-have-a-funny-error/18710 "2019-12-02T23:13:02Z")

</div>

I just updated a couple of my RPIs to the latest NR. Via the command cd .node-red bash \<(curl -sL https://raw.githubusercontent.com/node-red/raspbian-deb-package/master/resources/update-nodejs-and-nodered) All good. …

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

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