# Latest

**URL:** https://discourse.nodered.org/latest.md?page=839

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

**Page:** 840

---

## [Storing msg.payload in select tag](https://discourse.nodered.org/t/storing-msg-payload-in-select-tag/44097)

<div class="topic-metadata">

**Author:** [@jake123](https://discourse.nodered.org/u/jake123)\
**Replies:** 1\
**Last updated:** [13 April 2021 13:46 UTC](https://discourse.nodered.org/t/storing-msg-payload-in-select-tag/44097 "2021-04-13T13:46:17Z")

</div>

This is my custom websocket node. As you see the msg it outputs is an object { name: datapointname, value: data } Could i somehow create Select tag that has options based on how many msg.payload it recives. Options tex…

---

## [SQLite Error: UNIQUE constraint failed](https://discourse.nodered.org/t/sqlite-error-unique-constraint-failed/43758)

<div class="topic-metadata">

**Author:** [@Samira05](https://discourse.nodered.org/u/Samira05)\
**Replies:** 33\
**Last updated:** [13 April 2021 12:23 UTC](https://discourse.nodered.org/t/sqlite-error-unique-constraint-failed/43758 "2021-04-13T12:23:34Z")

</div>

Good day everyone, i dont know where is false that i cannot show infos in DB in my tempelate. (i explain that i want to insert my csv.file to DB and then show Infos from DB) \[{"id":"68a0a347.56efbc","type":"tab","labe…

---

## [Displaying the value above the node](https://discourse.nodered.org/t/displaying-the-value-above-the-node/44088)

<div class="topic-metadata">

**Author:** [@jake123](https://discourse.nodered.org/u/jake123)\
**Replies:** 4\
**Last updated:** [13 April 2021 11:18 UTC](https://discourse.nodered.org/t/displaying-the-value-above-the-node/44088 "2021-04-13T11:18:47Z")

</div>

Is there a way to display the value of the node above the node itself. Lets say u have inject node set to boolean(true). Is there a way or a node that will display the msg.payload above the node. Something like thi…

---

## [I think, this question is beyond NR, but asking anyway?](https://discourse.nodered.org/t/i-think-this-question-is-beyond-nr-but-asking-anyway/44074)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 5\
**Last updated:** [13 April 2021 11:03 UTC](https://discourse.nodered.org/t/i-think-this-question-is-beyond-nr-but-asking-anyway/44074 "2021-04-13T11:03:53Z")

</div>

I think, this question is beyond NR, but asking anyway? So, trying to web page scrap dynamic content is just possible within NR? At least I don't see how a GET via http request/response can invoke dynamic content. Jus…

---

## [Convert InfluxDB v2 data to ui\_chart](https://discourse.nodered.org/t/convert-influxdb-v2-data-to-ui-chart/42088)

<div class="topic-metadata">

**Author:** [@Simon01011](https://discourse.nodered.org/u/Simon01011)\
**Replies:** 27\
**Last updated:** [13 April 2021 10:45 UTC](https://discourse.nodered.org/t/convert-influxdb-v2-data-to-ui-chart/42088 "2021-04-13T10:45:19Z")

</div>

Hi everybody! Since I didn't find anything here I wrote a small function to display Influx data on a chart: The function for the query prepares the query string: msg.query = 'from(bucket: "testbucket")'+ ' |\> range(…

---

## [Fix worldmap marker location from the field device realtime data](https://discourse.nodered.org/t/fix-worldmap-marker-location-from-the-field-device-realtime-data/44031)

<div class="topic-metadata">

**Author:** [@djar](https://discourse.nodered.org/u/djar)\
**Replies:** 4\
**Last updated:** [13 April 2021 10:02 UTC](https://discourse.nodered.org/t/fix-worldmap-marker-location-from-the-field-device-realtime-data/44031 "2021-04-13T10:02:24Z")

</div>

Hello, I am new using Node-RED, I have a problem with fixing marker in Worldmap node with using a realtime data. I can solve it if I directly write the number of lat and lon and feed them to worldmap-UI through a funct…

---

## [Node-RED projects + uibuilder: How to include installation of vue, bootstrap, bootstrap-vue?](https://discourse.nodered.org/t/node-red-projects-uibuilder-how-to-include-installation-of-vue-bootstrap-bootstrap-vue/43898)

<div class="topic-metadata">

**Author:** [@NoMercyMike](https://discourse.nodered.org/u/NoMercyMike)\
**Replies:** 2\
**Last updated:** [13 April 2021 09:52 UTC](https://discourse.nodered.org/t/node-red-projects-uibuilder-how-to-include-installation-of-vue-bootstrap-bootstrap-vue/43898 "2021-04-13T09:52:53Z")

</div>

Hi, I've build a very simply CI/CD pipeline (Jira, Gitlab, Node-RED) for developing my flows and dashboards. In my dev stage (local docker container) I'm using Node-RED projects to keep everything under version control…

---

## [Node Red logging](https://discourse.nodered.org/t/node-red-logging/44090)

<div class="topic-metadata">

**Author:** [@mich3000](https://discourse.nodered.org/u/mich3000)\
**Replies:** 0\
**Last updated:** [13 April 2021 09:20 UTC](https://discourse.nodered.org/t/node-red-logging/44090 "2021-04-13T09:20:39Z")

</div>

Is there any setting i can set to get msgId also for standard logging not only in metric? Thanks {"level":99,"nodeid":"14e2db35.664b55","event":"node.debug.receive","msgid":"d9c14011.84d75","timestamp":1618304414264} i…

---

## [Add column headers to CSV file](https://discourse.nodered.org/t/add-column-headers-to-csv-file/15062)

<div class="topic-metadata">

**Author:** [@hathemi](https://discourse.nodered.org/u/hathemi)\
**Replies:** 12\
**Last updated:** [13 April 2021 08:21 UTC](https://discourse.nodered.org/t/add-column-headers-to-csv-file/15062 "2021-04-13T08:21:14Z")

</div>

i want t create a csv file with header i follow this example but doesn't work. i always find the header's names in one cell ? \[{"id":"1993503b.2a2d88","type":"fs-ops-access","z":"456ce3eb.038f9c","name":"","path":"meas…

---

## [Convert Date Time to Unix time](https://discourse.nodered.org/t/convert-date-time-to-unix-time/19787)

<div class="topic-metadata">

**Author:** [@mitchdennis](https://discourse.nodered.org/u/mitchdennis)\
**Replies:** 4\
**Last updated:** [13 April 2021 08:10 UTC](https://discourse.nodered.org/t/convert-date-time-to-unix-time/19787 "2021-04-13T08:10:23Z")

</div>

Hi all I have a message output being read from a CSV file that is in this format "GPS Time: "Sun Dec 01 08:50:14 PST 2019".Does anybody know how to convert it to a Unix time. Thanks Dennis Mitchell

---

## [How do you convert a 10 digit unix time](https://discourse.nodered.org/t/how-do-you-convert-a-10-digit-unix-time/12474)

<div class="topic-metadata">

**Author:** [@nodecentral](https://discourse.nodered.org/u/nodecentral)\
**Replies:** 2\
**Last updated:** [13 April 2021 08:09 UTC](https://discourse.nodered.org/t/how-do-you-convert-a-10-digit-unix-time/12474 "2021-04-13T08:09:01Z")

</div>

Hi, I’m trying to pull content from an online EPG, and the Start and Stop times of programmes look to only be 10 digits long, and I can’t seem to use a date time converter node e.g. Moment to convert them ? When I do …

---

## [Node RED activating different elements/diodes with Dashboard slider](https://discourse.nodered.org/t/node-red-activating-different-elements-diodes-with-dashboard-slider/44082)

<div class="topic-metadata">

**Author:** [@Nikolay](https://discourse.nodered.org/u/Nikolay)\
**Replies:** 1\
**Last updated:** [13 April 2021 08:08 UTC](https://discourse.nodered.org/t/node-red-activating-different-elements-diodes-with-dashboard-slider/44082 "2021-04-13T08:08:53Z")

</div>

Hello to All, I used the Dashoboard slider to activate different elements, in my case raspberry pi 4 GPIO connected to diodes. The idea is that the slider has 4 steps 0, 1, 2 and. When the slider is on 0 no diode shine…

---

## [HELP : IBM cloud lite : Node red app not available in "cloud foundry apps" after Deployed](https://discourse.nodered.org/t/help-ibm-cloud-lite-node-red-app-not-available-in-cloud-foundry-apps-after-deployed/44078)

<div class="topic-metadata">

**Author:** [@moezmtk](https://discourse.nodered.org/u/moezmtk)\
**Replies:** 0\
**Last updated:** [13 April 2021 06:28 UTC](https://discourse.nodered.org/t/help-ibm-cloud-lite-node-red-app-not-available-in-cloud-foundry-apps-after-deployed/44078 "2021-04-13T06:28:07Z")

</div>

Help, I 'm using IBM Cloud lite to deploy node red but after i deployed it ,it didn't appear in "cloud foundry apps " in " Resource List " after long time of waiting.

---

## [How to calculate future time](https://discourse.nodered.org/t/how-to-calculate-future-time/44035)

<div class="topic-metadata">

**Author:** [@PinPat](https://discourse.nodered.org/u/PinPat)\
**Replies:** 6\
**Last updated:** [13 April 2021 06:26 UTC](https://discourse.nodered.org/t/how-to-calculate-future-time/44035 "2021-04-13T06:26:50Z")

</div>

I have a manual target temperature calculator, where operator enters minute as number. I would like to calculate future time (yellow highlighted) by adding minutes (manual entry on left) to the current time.

---

## [Display data from csv table to a chart](https://discourse.nodered.org/t/display-data-from-csv-table-to-a-chart/44024)

<div class="topic-metadata">

**Author:** [@SaidJADA](https://discourse.nodered.org/u/SaidJADA)\
**Replies:** 4\
**Last updated:** [13 April 2021 00:51 UTC](https://discourse.nodered.org/t/display-data-from-csv-table-to-a-chart/44024 "2021-04-13T00:51:40Z")

</div>

Hello everyone, I a beginner in NodeRed and would like to get some support please. I have a csv file that contains 18 columns with data and would like to display some of the series on a chart and display in the Dashboa…

---

## [How to generate report from TEXT INPUT NODES](https://discourse.nodered.org/t/how-to-generate-report-from-text-input-nodes/44034)

<div class="topic-metadata">

**Author:** [@PinPat](https://discourse.nodered.org/u/PinPat)\
**Replies:** 1\
**Last updated:** [13 April 2021 00:16 UTC](https://discourse.nodered.org/t/how-to-generate-report-from-text-input-nodes/44034 "2021-04-13T00:16:02Z")

</div>

I have various TEXT INPUT NODES, where operator enters a date , time and Notes. I would like to save these entries as pdf file, by clicking a button manually. Can someone please guide me how can i do it?

---

## [Email getting rejected with 550 Messages should have one or no Content-Type headers, not 2](https://discourse.nodered.org/t/email-getting-rejected-with-550-messages-should-have-one-or-no-content-type-headers-not-2/44067)

<div class="topic-metadata">

**Author:** [@chrisn-au](https://discourse.nodered.org/u/chrisn-au)\
**Replies:** 5\
**Last updated:** [12 April 2021 23:27 UTC](https://discourse.nodered.org/t/email-getting-rejected-with-550-messages-should-have-one-or-no-content-type-headers-not-2/44067 "2021-04-12T23:27:38Z")

</div>

Hi, Over the last week or so I have been getting an error for some emails sent with the email node to an outlook server. I am getting a bounce on the email with The response from the remote server was: 550 Messages sh…

---

## [USB RFID Reader and Pi keyboard Node](https://discourse.nodered.org/t/usb-rfid-reader-and-pi-keyboard-node/44063)

<div class="topic-metadata">

**Author:** [@ttavlis](https://discourse.nodered.org/u/ttavlis)\
**Replies:** 3\
**Last updated:** [12 April 2021 21:48 UTC](https://discourse.nodered.org/t/usb-rfid-reader-and-pi-keyboard-node/44063 "2021-04-12T21:48:09Z")

</div>

Dear all, I have a simple setup where I use a generic USB RFID Reader (as this ) one) to read a RFID card and "do stuff" (yes, play some music in sonos). The PI Keyboard Node gets the ID of the card, which is 10 charac…

---

## [Toggle lights with different states](https://discourse.nodered.org/t/toggle-lights-with-different-states/44062)

<div class="topic-metadata">

**Author:** [@mr.B](https://discourse.nodered.org/u/mr.B)\
**Replies:** 1\
**Last updated:** [12 April 2021 20:37 UTC](https://discourse.nodered.org/t/toggle-lights-with-different-states/44062 "2021-04-12T20:37:32Z")

</div>

Hi, I'm looking for an easy way to know whether at least one light in a light group has the state 'on'. This is because I want to toggle multiple lights with one single button, but without using a toggle function. (beca…

---

## [Node-Red 1.3.1 and sqlite3 again](https://discourse.nodered.org/t/node-red-1-3-1-and-sqlite3-again/43933)

<div class="topic-metadata">

**Author:** [@scargill](https://discourse.nodered.org/u/scargill)\
**Replies:** 27\
**Last updated:** [12 April 2021 20:00 UTC](https://discourse.nodered.org/t/node-red-1-3-1-and-sqlite3-again/43933 "2021-04-12T20:00:18Z")

</div>

Up to NR 1.2.9 I had everything installing and updating perfectly.... but here we go again - the Pi NR upgrade script - upgraded to NR 1.3.1 - the update reported issues with the serial port, i2c and sqlite3. I reinstall…

---

## [Bitwise operator issue](https://discourse.nodered.org/t/bitwise-operator-issue/44006)

<div class="topic-metadata">

**Author:** [@vlturner](https://discourse.nodered.org/u/vlturner)\
**Replies:** 7\
**Last updated:** [12 April 2021 18:53 UTC](https://discourse.nodered.org/t/bitwise-operator-issue/44006 "2021-04-12T18:53:52Z")

</div>

I am having a meltdown on something simple. I am trying to route the odd and even numbers through two paths of a function. I seem to have my code not operating as expected. \[{"id":"f8ce0fa1.b745e8","type":"inject",…

---

## [Injecting basic object in template node with little landing page retrieve \[object Object\] and I don't understand why](https://discourse.nodered.org/t/injecting-basic-object-in-template-node-with-little-landing-page-retrieve-object-object-and-i-dont-understand-why/44052)

<div class="topic-metadata">

**Author:** [@vongomben](https://discourse.nodered.org/u/vongomben)\
**Replies:** 1\
**Last updated:** [12 April 2021 17:41 UTC](https://discourse.nodered.org/t/injecting-basic-object-in-template-node-with-little-landing-page-retrieve-object-object-and-i-dont-understand-why/44052 "2021-04-12T17:41:30Z")

</div>

Hi. I don't understand why, if I inject an object in a template node, I cannot seem to access its payload from the node itself, I just see \[object Object\] How can I have the contet of this html page more dynamic and in…

---

## [Mqtts instead of mqtt on PubSubClient library](https://discourse.nodered.org/t/mqtts-instead-of-mqtt-on-pubsubclient-library/44039)

<div class="topic-metadata">

**Author:** [@saeed1](https://discourse.nodered.org/u/saeed1)\
**Replies:** 1\
**Last updated:** [12 April 2021 17:16 UTC](https://discourse.nodered.org/t/mqtts-instead-of-mqtt-on-pubsubclient-library/44039 "2021-04-12T17:16:20Z")

</div>

Hello Guys, i am afraid mybe its not completely relevant for this forum but i am posting it here, as its the most helpful forum. I was sending data from my raspberry pi (client) to my remote server via mqtts (8883). On…

---

## [Fun with Svelte and uibuilder](https://discourse.nodered.org/t/fun-with-svelte-and-uibuilder/41370)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 3\
**Last updated:** [12 April 2021 17:04 UTC](https://discourse.nodered.org/t/fun-with-svelte-and-uibuilder/41370 "2021-04-12T17:04:43Z")

</div>

After a recent announcement about the use of Svelte, it looked interesting enough to see how easy it might be to use with uibuilder. As it happens - pretty easy :grin: Create a new uibuilder instance and change the u…

---

## [TypeError: Cannot read property 'log' of undefined](https://discourse.nodered.org/t/typeerror-cannot-read-property-log-of-undefined/43959)

<div class="topic-metadata">

**Author:** [@cope](https://discourse.nodered.org/u/cope)\
**Replies:** 11\
**Last updated:** [12 April 2021 16:39 UTC](https://discourse.nodered.org/t/typeerror-cannot-read-property-log-of-undefined/43959 "2021-04-12T16:39:31Z")

</div>

I upgraded to 1.3.1 and now I cannot read my homeseer devices any more. The server is declared all right and the Device and Feature are found by the node. The Device is in a red box??? Any idea how to solve this pr…

---

## [Energycounter with Context](https://discourse.nodered.org/t/energycounter-with-context/44045)

<div class="topic-metadata">

**Author:** [@Abrechen2](https://discourse.nodered.org/u/Abrechen2)\
**Replies:** 5\
**Last updated:** [12 April 2021 16:22 UTC](https://discourse.nodered.org/t/energycounter-with-context/44045 "2021-04-12T16:22:31Z")

</div>

hey guys have a look at my Website:

---

## [Update last row of InfluxDB database](https://discourse.nodered.org/t/update-last-row-of-influxdb-database/44030)

<div class="topic-metadata">

**Author:** [@MrWolff](https://discourse.nodered.org/u/MrWolff)\
**Replies:** 7\
**Last updated:** [12 April 2021 15:35 UTC](https://discourse.nodered.org/t/update-last-row-of-influxdb-database/44030 "2021-04-12T15:35:09Z")

</div>

Hi everybody, I have made flow where I store data into a InfluxDB database. I have the following problem: When the machine stops running, the downtime starts. I insert the start time to the database. (see picture) Wh…

---

## [Change node in v1.3.0 not working](https://discourse.nodered.org/t/change-node-in-v1-3-0-not-working/44011)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 7\
**Last updated:** [12 April 2021 15:28 UTC](https://discourse.nodered.org/t/change-node-in-v1-3-0-not-working/44011 "2021-04-12T15:28:23Z")

</div>

Last week I was running v1.2.9 (I think) and my flow worked great. I updated to 1.3 now and for some reason the Change nodes used in my flow have the red triangle, which I understand means an error in the config. When …

---

## [Input type checkbox](https://discourse.nodered.org/t/input-type-checkbox/43511)

<div class="topic-metadata">

**Author:** [@ivexy24](https://discourse.nodered.org/u/ivexy24)\
**Replies:** 28\
**Last updated:** [12 April 2021 14:49 UTC](https://discourse.nodered.org/t/input-type-checkbox/43511 "2021-04-12T14:49:06Z")

</div>

I've created a custom node that handles get request oneditprepare.Does anyone maybe know how to append the results to html file as a \<div class="form-row\>\</div\> .then((data) =\> { data.forEach((item) =\> …

---

## [When deploy ibm watson iot platform, could successfully receive send data, but can not receive data and cause node-red restarting indefinitely /mqtt/ibm iot node](https://discourse.nodered.org/t/when-deploy-ibm-watson-iot-platform-could-successfully-receive-send-data-but-can-not-receive-data-and-cause-node-red-restarting-indefinitely-mqtt-ibm-iot-node/44040)

<div class="topic-metadata">

**Author:** [@pirbobo](https://discourse.nodered.org/u/pirbobo)\
**Replies:** 3\
**Last updated:** [12 April 2021 14:45 UTC](https://discourse.nodered.org/t/when-deploy-ibm-watson-iot-platform-could-successfully-receive-send-data-but-can-not-receive-data-and-cause-node-red-restarting-indefinitely-mqtt-ibm-iot-node/44040 "2021-04-12T14:45:51Z")

</div>

Apr 5 19:36:27 raspberrypi systemd\[1\]: nodered.service: Main process exited, code=exited, status=1/FAILURE Apr 5 19:36:27 raspberrypi systemd\[1\]: nodered.service: Failed with result 'exit-code'. nodered.service: Main pr…

[Previous page](https://discourse.nodered.org/latest.md?page=838)

[Next page](https://discourse.nodered.org/latest.md?page=840)