# General

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

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

**Page:** 282

---

## [Connect the DWH](https://discourse.nodered.org/t/connect-the-dwh/71860)

<div class="topic-metadata">

**Author:** [@Jen](https://discourse.nodered.org/u/Jen)\
**Replies:** 4\
**Last updated:** [8 December 2022 16:55 UTC](https://discourse.nodered.org/t/connect-the-dwh/71860 "2022-12-08T16:55:22Z")

</div>

Hello I am trying to connect the DWH to the red node. But I can't find flowes for it. Maybe someone already did this?

---

## [Managing PoE Switch with Node-RED](https://discourse.nodered.org/t/managing-poe-switch-with-node-red/71796)

<div class="topic-metadata">

**Author:** [@barnius](https://discourse.nodered.org/u/barnius)\
**Replies:** 5\
**Last updated:** [8 December 2022 16:50 UTC](https://discourse.nodered.org/t/managing-poe-switch-with-node-red/71796 "2022-12-08T16:50:58Z")

</div>

Hey all! I am pretty new to this whole Dashboard thing and want to know if its possible to manage a PoE-Switch, in particular the ports of it, through Node-RED. So as an example simply turning on and off the PoE-Supply …

---

## [Injecting data into ui template for use with Chartjs](https://discourse.nodered.org/t/injecting-data-into-ui-template-for-use-with-chartjs/71840)

<div class="topic-metadata">

**Author:** [@Mick](https://discourse.nodered.org/u/Mick)\
**Replies:** 3\
**Last updated:** [8 December 2022 14:26 UTC](https://discourse.nodered.org/t/injecting-data-into-ui-template-for-use-with-chartjs/71840 "2022-12-08T14:26:33Z")

</div>

I have been trying to get a simple ui chart to work with chartjs. Here is the flow view: If I hard code the data values, I can generate the chart. However when I try to inject the data I can not get the chart to r…

---

## [Creating a function with a loop with input from Dashboard](https://discourse.nodered.org/t/creating-a-function-with-a-loop-with-input-from-dashboard/71756)

<div class="topic-metadata">

**Author:** [@Driss](https://discourse.nodered.org/u/Driss)\
**Replies:** 8\
**Last updated:** [8 December 2022 12:24 UTC](https://discourse.nodered.org/t/creating-a-function-with-a-loop-with-input-from-dashboard/71756 "2022-12-08T12:24:14Z")

</div>

Hello everyone, at the moment I'm trying to build a loop function which will allow me to do the following: Input of 2 variables via dashboard (ON and Off time in minutes) a permanent loop which first outputs a payload…

---

## [MQTT Connection lost no further connection possible](https://discourse.nodered.org/t/mqtt-connection-lost-no-further-connection-possible/71817)

<div class="topic-metadata">

**Author:** [@at-bh](https://discourse.nodered.org/u/at-bh)\
**Replies:** 16\
**Last updated:** [8 December 2022 11:53 UTC](https://discourse.nodered.org/t/mqtt-connection-lost-no-further-connection-possible/71817 "2022-12-08T11:53:56Z")

</div>

Don't know what happen in detail, while changing layout of dashboard my connections to the running mqtt server inside iobroker get lost. I find no way to reestablish the connection. Inside ioBroker the mqtt service is ru…

---

## [Save Chart as picture to attach to mail](https://discourse.nodered.org/t/save-chart-as-picture-to-attach-to-mail/68915)

<div class="topic-metadata">

**Author:** [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Replies:** 28\
**Last updated:** [8 December 2022 11:38 UTC](https://discourse.nodered.org/t/save-chart-as-picture-to-attach-to-mail/68915 "2022-12-08T11:38:37Z")

</div>

How do I save a ui\_chart as a picture so that I can attach the same in a Mail or PDF ?

---

## [Concatenete text and payload](https://discourse.nodered.org/t/concatenete-text-and-payload/71135)

<div class="topic-metadata">

**Author:** [@Loasca](https://discourse.nodered.org/u/Loasca)\
**Replies:** 6\
**Last updated:** [8 December 2022 11:19 UTC](https://discourse.nodered.org/t/concatenete-text-and-payload/71135 "2022-12-08T11:19:19Z")

</div>

Hi i am a beginner in nodered, I would like to combine a text and a payload in a message to create an webos lgtv alert notification, i want to change "message":"Just Testing" with "message":"Just Testing & {{payload}}", …

---

## [Automatically import a flow](https://discourse.nodered.org/t/automatically-import-a-flow/6168)

<div class="topic-metadata">

**Author:** [@TPPZ](https://discourse.nodered.org/u/TPPZ)\
**Replies:** 6\
**Last updated:** [8 December 2022 09:51 UTC](https://discourse.nodered.org/t/automatically-import-a-flow/6168 "2022-12-08T09:51:34Z")

</div>

I've created a very minimal flow that subscribes to an MQTT broker (mosquitto) with topic "readings" and stores whatever it receives into a file "readings.json". The content of the file storage (the messages) is not rea…

---

## [Not connecting to a usb port](https://discourse.nodered.org/t/not-connecting-to-a-usb-port/71741)

<div class="topic-metadata">

**Author:** [@shantamcbain](https://discourse.nodered.org/u/shantamcbain)\
**Replies:** 31\
**Last updated:** [8 December 2022 07:16 UTC](https://discourse.nodered.org/t/not-connecting-to-a-usb-port/71741 "2022-12-08T07:16:57Z")

</div>

I am attempting to connect to my Ham radio Yaesu FT-891 with node read. I have several programs that are able to connect to the radio. I setup a serial node that reports connected. I used the same settings as flrig uses …

---

## [Four InfluxDB node (data is very confusing and not unique)](https://discourse.nodered.org/t/four-influxdb-node-data-is-very-confusing-and-not-unique/71466)

<div class="topic-metadata">

**Author:** [@lihao](https://discourse.nodered.org/u/lihao)\
**Replies:** 31\
**Last updated:** [8 December 2022 02:38 UTC](https://discourse.nodered.org/t/four-influxdb-node-data-is-very-confusing-and-not-unique/71466 "2022-12-08T02:38:14Z")

</div>

When I use four influxDB nodes to send four measurements, these four measurements are the data of four channels of an adc. I added tags and timestamps, and the data visualization is very confusing. As shown below（The…

---

## [Logical And Function](https://discourse.nodered.org/t/logical-and-function/70093)

<div class="topic-metadata">

**Author:** [@HansZnarf](https://discourse.nodered.org/u/HansZnarf)\
**Replies:** 64\
**Last updated:** [8 December 2022 00:54 UTC](https://discourse.nodered.org/t/logical-and-function/70093 "2022-12-08T00:54:38Z")

</div>

Have two block that create True and False Output. Want a True output when Both are True and a False output when one or the other is false. This is typically a simple AND command in most programming. Have be tripping o…

---

## [How can check the null or undefined values](https://discourse.nodered.org/t/how-can-check-the-null-or-undefined-values/25598)

<div class="topic-metadata">

**Author:** [@Ahd](https://discourse.nodered.org/u/Ahd)\
**Replies:** 6\
**Last updated:** [7 December 2022 23:15 UTC](https://discourse.nodered.org/t/how-can-check-the-null-or-undefined-values/25598 "2022-12-07T23:15:50Z")

</div>

How to determine if one variable of the payload is undefined or null in JavaScript then must not send it to DB.

---

## [How to display an array as graph/chart](https://discourse.nodered.org/t/how-to-display-an-array-as-graph-chart/71808)

<div class="topic-metadata">

**Author:** [@Becker](https://discourse.nodered.org/u/Becker)\
**Replies:** 12\
**Last updated:** [7 December 2022 20:34 UTC](https://discourse.nodered.org/t/how-to-display-an-array-as-graph-chart/71808 "2022-12-07T20:34:29Z")

</div>

Hi, I get different forecast: Tibber and Solecast. example: \[{"total":0.3723,"energy":0.2646,"tax":0.1077,"startsAt":"2022-12-07T00:00:00.000+01:00","currency":"EUR","level":"CHEAP"},{"total":0.3379,"energy":0.2357,"t…

---

## [How to process any messaging queues synchronously in node-red](https://discourse.nodered.org/t/how-to-process-any-messaging-queues-synchronously-in-node-red/71805)

<div class="topic-metadata">

**Author:** [@shubham-credence](https://discourse.nodered.org/u/shubham-credence)\
**Replies:** 11\
**Last updated:** [7 December 2022 16:41 UTC](https://discourse.nodered.org/t/how-to-process-any-messaging-queues-synchronously-in-node-red/71805 "2022-12-07T16:41:36Z")

</div>

Hi, I'm using Node-RED version: v1.3.7 and Node.js version: v14.17.5 . Is their any packages or node-red core nodes exists in node-red which process AQMP messages synchronously. Because i am facing issues, while proce…

---

## [Noob - Reading serial - splitting correctly](https://discourse.nodered.org/t/noob-reading-serial-splitting-correctly/71803)

<div class="topic-metadata">

**Author:** [@boydo](https://discourse.nodered.org/u/boydo)\
**Replies:** 6\
**Last updated:** [7 December 2022 16:36 UTC](https://discourse.nodered.org/t/noob-reading-serial-splitting-correctly/71803 "2022-12-07T16:36:30Z")

</div>

New to node read so go easy!! I am trying to read serial connection. When I output to debug, I get the following. The message payload I am after is the 225 chars starting ts1 etc.. How do I setup the serial connecti…

---

## [Terminate library connection from httpAdminMiddleware](https://discourse.nodered.org/t/terminate-library-connection-from-httpadminmiddleware/71825)

<div class="topic-metadata">

**Author:** [@mw75](https://discourse.nodered.org/u/mw75)\
**Replies:** 0\
**Last updated:** [7 December 2022 15:16 UTC](https://discourse.nodered.org/t/terminate-library-connection-from-httpadminmiddleware/71825 "2022-12-07T15:16:24Z")

</div>

Hi community, i've connected node-red to an OIDC provider and assign permissions by mapping roles to the username. I have two roles: flow-admin and flow-designer. They only differ in the capability of reading and writin…

---

## [Trying to get 'require' to work but no result](https://discourse.nodered.org/t/trying-to-get-require-to-work-but-no-result/71819)

<div class="topic-metadata">

**Author:** [@henkkas](https://discourse.nodered.org/u/henkkas)\
**Replies:** 5\
**Last updated:** [7 December 2022 14:46 UTC](https://discourse.nodered.org/t/trying-to-get-require-to-work-but-no-result/71819 "2022-12-07T14:46:33Z")

</div>

I am trying to get a third-party package to work. I first tried the example 'os', and I got it functional. Now I am trying to get the package 'node-dsmr' to function in a similar way. I installed the package in ~/.node…

---

## [Variable in HTTP GET URL makes the response wrong](https://discourse.nodered.org/t/variable-in-http-get-url-makes-the-response-wrong/71770)

<div class="topic-metadata">

**Author:** [@network\_potato](https://discourse.nodered.org/u/network_potato)\
**Replies:** 7\
**Last updated:** [7 December 2022 14:12 UTC](https://discourse.nodered.org/t/variable-in-http-get-url-makes-the-response-wrong/71770 "2022-12-07T14:12:37Z")

</div>

Really bad title of the post but I don't know how else to explain it :sweat\_smile: I have been using variables in the URL field of my HTTP Request nodes for months without issue, but today I tried something new. I am p…

---

## [Node-red-node-serialport, can't get data, only connected](https://discourse.nodered.org/t/node-red-node-serialport-cant-get-data-only-connected/71779)

<div class="topic-metadata">

**Author:** [@henkkas](https://discourse.nodered.org/u/henkkas)\
**Replies:** 11\
**Last updated:** [7 December 2022 12:51 UTC](https://discourse.nodered.org/t/node-red-node-serialport-cant-get-data-only-connected/71779 "2022-12-07T12:51:20Z")

</div>

I have a Raspbery pi3+ with debian 11. I want to connect with the P1 port of the smartmeter over USB port, so I tried with node-red-contrib-smartmeter package to connect with smartmeter. But it didn't work what so ever. …

---

## [Query via Modbus TCP -\> MSSQL - zero values](https://discourse.nodered.org/t/query-via-modbus-tcp-mssql-zero-values/71785)

<div class="topic-metadata">

**Author:** [@MaaAR](https://discourse.nodered.org/u/MaaAR)\
**Replies:** 10\
**Last updated:** [7 December 2022 11:09 UTC](https://discourse.nodered.org/t/query-via-modbus-tcp-mssql-zero-values/71785 "2022-12-07T11:09:14Z")

</div>

Hello all, I have the following problem. I query my heat pump every 5 minutes via Modbus TCP. Then I take the values and make a join. After that I write them per INSERT command into a MSSQL database. For some time this…

---

## [How to get Https certificate to nodered with ip address](https://discourse.nodered.org/t/how-to-get-https-certificate-to-nodered-with-ip-address/71806)

<div class="topic-metadata">

**Author:** [@Swetha](https://discourse.nodered.org/u/Swetha)\
**Replies:** 1\
**Last updated:** [7 December 2022 11:05 UTC](https://discourse.nodered.org/t/how-to-get-https-certificate-to-nodered-with-ip-address/71806 "2022-12-07T11:05:52Z")

</div>

Hey, I’m trying secure the nodered version 3.0 and change http to https with the help of self signed certificates since its running in ip address. Issue: I’m able to access the https site with self signed x509 certifi…

---

## [Watch Node isnt watching outside when Nodered runs on docker](https://discourse.nodered.org/t/watch-node-isnt-watching-outside-when-nodered-runs-on-docker/71606)

<div class="topic-metadata">

**Author:** [@Josh](https://discourse.nodered.org/u/Josh)\
**Replies:** 3\
**Last updated:** [7 December 2022 07:04 UTC](https://discourse.nodered.org/t/watch-node-isnt-watching-outside-when-nodered-runs-on-docker/71606 "2022-12-07T07:04:49Z")

</div>

Hi Forum, I have a minimal watch node flow running on my nodered docker. I want the watch my local directory D:\\ for any change in file. But unfortunately my watch node isnt watching for any changes. Can anyone provide …

---

## [Notification Margin](https://discourse.nodered.org/t/notification-margin/71743)

<div class="topic-metadata">

**Author:** [@afafirmansyah](https://discourse.nodered.org/u/afafirmansyah)\
**Replies:** 2\
**Last updated:** [7 December 2022 00:53 UTC](https://discourse.nodered.org/t/notification-margin/71743 "2022-12-07T00:53:24Z")

</div>

How to give left and right margin? this happened after I updated ui-dashboard to version 3.2.3

---

## [Observation & Question about MQTT Node Timing](https://discourse.nodered.org/t/observation-question-about-mqtt-node-timing/71791)

<div class="topic-metadata">

**Author:** [@Buckskin](https://discourse.nodered.org/u/Buckskin)\
**Replies:** 6\
**Last updated:** [6 December 2022 23:10 UTC](https://discourse.nodered.org/t/observation-question-about-mqtt-node-timing/71791 "2022-12-06T23:10:56Z")

</div>

Before you all roll on the floor laughing I know that this observation has little impact in real life, but I wondered why it was happening. I was re-doing a small flow using a watt2kwhr node attached to an MQTT node and…

---

## [Settings.js Termux in android](https://discourse.nodered.org/t/settings-js-termux-in-android/8165)

<div class="topic-metadata">

**Author:** [@manueldiasmanuel](https://discourse.nodered.org/u/manueldiasmanuel)\
**Replies:** 5\
**Last updated:** [6 December 2022 21:47 UTC](https://discourse.nodered.org/t/settings-js-termux-in-android/8165 "2022-12-06T21:47:06Z")

</div>

Hi, I am using a script to start up node-red when the android systems boots up. I am trying to change the setting.js file but a don´t what is the path for the the right one. How to change the node-red setting.js file…

---

## [Updating multiple SQL records at once](https://discourse.nodered.org/t/updating-multiple-sql-records-at-once/71716)

<div class="topic-metadata">

**Author:** [@rbmgf7](https://discourse.nodered.org/u/rbmgf7)\
**Replies:** 5\
**Last updated:** [6 December 2022 19:28 UTC](https://discourse.nodered.org/t/updating-multiple-sql-records-at-once/71716 "2022-12-06T19:28:50Z")

</div>

Novice to NR and SQL. I'm doing a query where I pull columns of records (one unique) from a database. Then I do some simple math to the non-unique records and then return all of it to their respective record in SQL bas…

---

## [Export node red stored data to excel](https://discourse.nodered.org/t/export-node-red-stored-data-to-excel/71724)

<div class="topic-metadata">

**Author:** [@Johnson](https://discourse.nodered.org/u/Johnson)\
**Replies:** 12\
**Last updated:** [6 December 2022 19:06 UTC](https://discourse.nodered.org/t/export-node-red-stored-data-to-excel/71724 "2022-12-06T19:06:03Z")

</div>

I have a question regarding storing of data. I want to export the data stored in global context into an excel .I did some research and found a node called csv .But is it possible to get the start, stop and duration val…

---

## [Pdf or picture slideshow](https://discourse.nodered.org/t/pdf-or-picture-slideshow/71662)

<div class="topic-metadata">

**Author:** [@denissanga](https://discourse.nodered.org/u/denissanga)\
**Replies:** 5\
**Last updated:** [6 December 2022 19:01 UTC](https://discourse.nodered.org/t/pdf-or-picture-slideshow/71662 "2022-12-06T19:01:11Z")

</div>

Hi all I would create a slides how popup in node red to open pdf files or images? This is possible?

---

## [Node-Red instance suddenly not starting on boot](https://discourse.nodered.org/t/node-red-instance-suddenly-not-starting-on-boot/71722)

<div class="topic-metadata">

**Author:** [@aams](https://discourse.nodered.org/u/aams)\
**Replies:** 23\
**Last updated:** [6 December 2022 16:42 UTC](https://discourse.nodered.org/t/node-red-instance-suddenly-not-starting-on-boot/71722 "2022-12-06T16:42:36Z")

</div>

I have a device that I am working on remotely, and do not have physical access to. I do have ability to interact with it via ip address. All has been working fine for the past several weeks, but today after a reboot, I a…

---

## [Central Heating/Home Control schedule. Suggestions please](https://discourse.nodered.org/t/central-heating-home-control-schedule-suggestions-please/71552)

<div class="topic-metadata">

**Author:** [@mudwalker](https://discourse.nodered.org/u/mudwalker)\
**Replies:** 20\
**Last updated:** [6 December 2022 15:39 UTC](https://discourse.nodered.org/t/central-heating-home-control-schedule-suggestions-please/71552 "2022-12-06T15:39:36Z")

</div>

I have been thinking about this for (quite) a while, and getting nowhere fast. I am trying to move away from using a file with a temperature for each hour of the week (basically a .csv file) to a more readable format, i…

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

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