# Latest

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

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

**Page:** 1371

---

## [SQLite3 import from CSV](https://discourse.nodered.org/t/sqlite3-import-from-csv/2604)

<div class="topic-metadata">

**Author:** [@mpxd](https://discourse.nodered.org/u/mpxd)\
**Replies:** 7\
**Last updated:** [27 August 2018 19:30 UTC](https://discourse.nodered.org/t/sqlite3-import-from-csv/2604 "2018-08-27T19:30:09Z")

</div>

Does someone here have experience with importing data from a CSV file into SQLite with node-red-node-sqlite ? I tried so far: COPY syslog FROM 'E:\\Path\\to\\syslog.csv' DELIMITER ',' CSV HEADER; and IMPORT 'E:\\Path\\to\\…

---

## [How to find what npm did?](https://discourse.nodered.org/t/how-to-find-what-npm-did/2607)

<div class="topic-metadata">

**Author:** [@Colin](https://discourse.nodered.org/u/Colin)\
**Replies:** 2\
**Last updated:** [27 August 2018 19:17 UTC](https://discourse.nodered.org/t/how-to-find-what-npm-did/2607 "2018-08-27T19:17:21Z")

</div>

I ran npm remove \<package\> and npm said it had removed one package and updated one package. How can I find which package it updated? I can't find a log and google hasn't helped much. There is a folder ~/.npm/\_logs b…

---

## [Node-red-contrib-pid update released](https://discourse.nodered.org/t/node-red-contrib-pid-update-released/2609)

<div class="topic-metadata">

**Author:** [@Colin](https://discourse.nodered.org/u/Colin)\
**Replies:** 0\
**Last updated:** [27 August 2018 16:22 UTC](https://discourse.nodered.org/t/node-red-contrib-pid-update-released/2609 "2018-08-27T16:22:26Z")

</div>

node-red-contrib-pid has been updated to version 1.1.4. This fixes a couple of minor bugs, improving the behaviour when given invalid data or parameters. Setting the proportional band to 0 now correctly provides On/Off…

---

## [Node output from bottom](https://discourse.nodered.org/t/node-output-from-bottom/2602)

<div class="topic-metadata">

**Author:** [@CatalinFetoiu](https://discourse.nodered.org/u/CatalinFetoiu)\
**Replies:** 2\
**Last updated:** [27 August 2018 13:31 UTC](https://discourse.nodered.org/t/node-output-from-bottom/2602 "2018-08-27T13:31:08Z")

</div>

Hello, It may be a stupid question but is there a way to place the output of a node on the bottom? More precisely, if we see the node as a rectangle, the output should start from the bottom side. Thank you! Catalin

---

## [Using node-red ui from asp.net web app](https://discourse.nodered.org/t/using-node-red-ui-from-asp-net-web-app/2534)

<div class="topic-metadata">

**Author:** [@dipak](https://discourse.nodered.org/u/dipak)\
**Replies:** 4\
**Last updated:** [27 August 2018 09:11 UTC](https://discourse.nodered.org/t/using-node-red-ui-from-asp-net-web-app/2534 "2018-08-27T09:11:15Z")

</div>

I have an asp.net web app, where I need to develop just a UI similar to node-red drag and drop, and import/export the JSON flow, basically just a client-side functionality (HTML/CSS/Javascript) is what I need, is there a…

---

## [IoT Scale and Conversion](https://discourse.nodered.org/t/iot-scale-and-conversion/2586)

<div class="topic-metadata">

**Author:** [@achalaggarwal](https://discourse.nodered.org/u/achalaggarwal)\
**Replies:** 2\
**Last updated:** [27 August 2018 06:49 UTC](https://discourse.nodered.org/t/iot-scale-and-conversion/2586 "2018-08-27T06:49:56Z")

</div>

Hello, I'm new to Node Red and need some assistance. I have been working with scale that is connected to cloud and i'm getting the weight readings from the scale. What i'm trying to achieve is convert the weight obtain…

---

## [Map needs less transparency?](https://discourse.nodered.org/t/map-needs-less-transparency/2580)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 4\
**Last updated:** [27 August 2018 06:30 UTC](https://discourse.nodered.org/t/map-needs-less-transparency/2580 "2018-08-27T06:30:16Z")

</div>

Hi, just got round to upgrading my "live" HA system so this is the first time that the map overview has been useful. I note that the background is a little too transparent which makes it hard to read: It might be bet…

---

## [String length limit on context view?](https://discourse.nodered.org/t/string-length-limit-on-context-view/2582)

<div class="topic-metadata">

**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Replies:** 0\
**Last updated:** [26 August 2018 19:04 UTC](https://discourse.nodered.org/t/string-length-limit-on-context-view/2582 "2018-08-26T19:04:55Z")

</div>

Hi, having upgraded my live HA system to 0.19.2 and starting to look at some enhancements made possible due to newer features, I've discovered a slight oddity in the context sidebar. The following flow shows details abo…

---

## [Hyperlink Query - (Sorry if its a dumb question)](https://discourse.nodered.org/t/hyperlink-query-sorry-if-its-a-dumb-question/2579)

<div class="topic-metadata">

**Author:** [@grumpywhale](https://discourse.nodered.org/u/grumpywhale)\
**Replies:** 1\
**Last updated:** [26 August 2018 14:54 UTC](https://discourse.nodered.org/t/hyperlink-query-sorry-if-its-a-dumb-question/2579 "2018-08-26T14:54:00Z")

</div>

Extremely new to dashboard if this doesnt seem obvious, i have it working well for showing readings but i also want it to have hyperlink buttons to open url's despite a good old google i simply can tell how you add a but…

---

## [Raspberry pi3 USB camera](https://discourse.nodered.org/t/raspberry-pi3-usb-camera/2563)

<div class="topic-metadata">

**Author:** [@mustafa](https://discourse.nodered.org/u/mustafa)\
**Replies:** 2\
**Last updated:** [26 August 2018 13:57 UTC](https://discourse.nodered.org/t/raspberry-pi3-usb-camera/2563 "2018-08-26T13:57:31Z")

</div>

Hi Is there any idea for connecting USB camera to Raspberry pi3 and view video streaming on the ui?? Please provide with link if there is

---

## [Google Calendar returning "trying to refresh token due to expiry"](https://discourse.nodered.org/t/google-calendar-returning-trying-to-refresh-token-due-to-expiry/2571)

<div class="topic-metadata">

**Author:** [@michaelblight](https://discourse.nodered.org/u/michaelblight)\
**Replies:** 2\
**Last updated:** [26 August 2018 12:05 UTC](https://discourse.nodered.org/t/google-calendar-returning-trying-to-refresh-token-due-to-expiry/2571 "2018-08-26T12:05:03Z")

</div>

I'm using the Calendar In node from node-red-node-google, and maybe once or twice a day I get multiple "trying to refresh token due to expiry" messages. I'm guessing it's one message for each node. Should I expect this, …

---

## [Persistent context](https://discourse.nodered.org/t/persistent-context/2573)

<div class="topic-metadata">

**Author:** [@mtoko](https://discourse.nodered.org/u/mtoko)\
**Replies:** 1\
**Last updated:** [26 August 2018 10:14 UTC](https://discourse.nodered.org/t/persistent-context/2573 "2018-08-26T10:14:25Z")

</div>

I am trying to implement persistent context on a IBM Cloud NR and have just created a new app to implement NR 0.19. I have added contextStorage: { default: { module: "localfilesystem" } } to module.exports…

---

## [Get events in google calendar](https://discourse.nodered.org/t/get-events-in-google-calendar/2520)

<div class="topic-metadata">

**Author:** [@leomozzer](https://discourse.nodered.org/u/leomozzer)\
**Replies:** 8\
**Last updated:** [26 August 2018 08:48 UTC](https://discourse.nodered.org/t/get-events-in-google-calendar/2520 "2018-08-26T08:48:23Z")

</div>

How can I get events in my google calendar? It's the same way when I add events to the calendar? msg.payload = { description: "Great picnic with friends",//descricao\_evento start: {dateTime: "2018-08-15T15:00:00-03:0…

---

## [Node Red video player issues](https://discourse.nodered.org/t/node-red-video-player-issues/2543)

<div class="topic-metadata">

**Author:** [@Rich](https://discourse.nodered.org/u/Rich)\
**Replies:** 16\
**Last updated:** [26 August 2018 08:41 UTC](https://discourse.nodered.org/t/node-red-video-player-issues/2543 "2018-08-26T08:41:31Z")

</div>

Hi, I have a python script running on a Raspberry Pi which works as a triggered video player. I'm using Node Red to trigger the GPIOs to play the videos from the NR UI. I'm able to manually trigger the videos using the G…

---

## [Node-red-contrib-dmxusbpro](https://discourse.nodered.org/t/node-red-contrib-dmxusbpro/2569)

<div class="topic-metadata">

**Author:** [@blechdom](https://discourse.nodered.org/u/blechdom)\
**Replies:** 0\
**Last updated:** [25 August 2018 21:24 UTC](https://discourse.nodered.org/t/node-red-contrib-dmxusbpro/2569 "2018-08-25T21:24:17Z")

</div>

https://www.npmjs.com/package/node-red-contrib-dmxusbpro A simple Node-Red driver for Enntec DMX USB PRO.

---

## [How to display Tree diagram at dashboard](https://discourse.nodered.org/t/how-to-display-tree-diagram-at-dashboard/2511)

<div class="topic-metadata">

**Author:** [@natanel](https://discourse.nodered.org/u/natanel)\
**Replies:** 24\
**Last updated:** [25 August 2018 13:36 UTC](https://discourse.nodered.org/t/how-to-display-tree-diagram-at-dashboard/2511 "2018-08-25T13:36:38Z")

</div>

Hi is there any package there for display Tree diagram at dashboard some thing like this each node get : color, name, parents thanks

---

## [\[ANNOUNCE\] Visual programming a function node with Blockly - Feedback request](https://discourse.nodered.org/t/announce-visual-programming-a-function-node-with-blockly-feedback-request/1566)

<div class="topic-metadata">

**Author:** [@BartButenaers](https://discourse.nodered.org/u/BartButenaers)\
**Replies:** 206\
**Last updated:** [25 August 2018 12:48 UTC](https://discourse.nodered.org/t/announce-visual-programming-a-function-node-with-blockly-feedback-request/1566 "2018-08-25T12:48:07Z")

</div>

Hi folks, A few weeks ago this discussion got my attention, especially since I had never heard about Google's Blockly framework before. So I tried to integrate Blockly into Node-Red, to allow users to create function n…

---

## [Examples using TP-Link IoT Smart Home devices](https://discourse.nodered.org/t/examples-using-tp-link-iot-smart-home-devices/2439)

<div class="topic-metadata">

**Author:** [@whatsupskip](https://discourse.nodered.org/u/whatsupskip)\
**Replies:** 12\
**Last updated:** [25 August 2018 09:34 UTC](https://discourse.nodered.org/t/examples-using-tp-link-iot-smart-home-devices/2439 "2018-08-25T09:34:50Z")

</div>

I am wondering if anyone using one of the Nodes for controlling the TP-Link Smart Home devices such as the HS100 or HS110 could provide some example flows or codes to help head me in the right direction. I have managed …

---

## [MQTT node connecting to Thingspeak?](https://discourse.nodered.org/t/mqtt-node-connecting-to-thingspeak/2424)

<div class="topic-metadata">

**Author:** [@CaptClaude](https://discourse.nodered.org/u/CaptClaude)\
**Replies:** 18\
**Last updated:** [25 August 2018 07:02 UTC](https://discourse.nodered.org/t/mqtt-node-connecting-to-thingspeak/2424 "2018-08-25T07:02:07Z")

</div>

I am struggling to do something simple with the MQTT node: Get the cheerlights feed directly from Thingspeak. I can get it without problem from iot.eclipse.org but cannot seem to find the correct setup of the Thingspeak…

---

## [Github and a flow I uploaded](https://discourse.nodered.org/t/github-and-a-flow-i-uploaded/2537)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 6\
**Last updated:** [24 August 2018 22:49 UTC](https://discourse.nodered.org/t/github-and-a-flow-i-uploaded/2537 "2018-08-24T22:49:05Z")

</div>

A while ago I went though the motions of making a calculator. Nothing too fancy, but to play with buttons and be a bit of help for people. Out of curiosity I was looking in the library for Node-Red and I can't find it. …

---

## [Function status - a plea likely to be treated with scorn](https://discourse.nodered.org/t/function-status-a-plea-likely-to-be-treated-with-scorn/2259)

<div class="topic-metadata">

**Author:** [@scargill](https://discourse.nodered.org/u/scargill)\
**Replies:** 9\
**Last updated:** [24 August 2018 16:05 UTC](https://discourse.nodered.org/t/function-status-a-plea-likely-to-be-treated-with-scorn/2259 "2018-08-24T16:05:47Z")

</div>

Increasingly I find myself using the status display in the function node to display info when developing - mainly because I want the info on one screen and the debug tab is busy with bugs and other items. The "text" item…

---

## [Series Colors on Pie Chart](https://discourse.nodered.org/t/series-colors-on-pie-chart/2519)

<div class="topic-metadata">

**Author:** [@arneym](https://discourse.nodered.org/u/arneym)\
**Replies:** 16\
**Last updated:** [24 August 2018 13:16 UTC](https://discourse.nodered.org/t/series-colors-on-pie-chart/2519 "2018-08-24T13:16:33Z")

</div>

How can I set the series color on my pie chart? I have changed the colors in the chart node configuration. I am getting a chart that does not reflect my changes. I even restarted node-red. Thanks, Mike

---

## [Connection error when start dashboard after upgrade to 0.19.1](https://discourse.nodered.org/t/connection-error-when-start-dashboard-after-upgrade-to-0-19-1/2493)

<div class="topic-metadata">

**Author:** [@petrho](https://discourse.nodered.org/u/petrho)\
**Replies:** 3\
**Last updated:** [24 August 2018 09:37 UTC](https://discourse.nodered.org/t/connection-error-when-start-dashboard-after-upgrade-to-0-19-1/2493 "2018-08-24T09:37:06Z")

</div>

After upgrade to 0.19.1 (windows) I often get connection lost error flashing in red when start the ui. When closing the browser and test again it works.

---

## [How to read debug console line?](https://discourse.nodered.org/t/how-to-read-debug-console-line/2530)

<div class="topic-metadata">

**Author:** [@nsp](https://discourse.nodered.org/u/nsp)\
**Replies:** 5\
**Last updated:** [24 August 2018 09:14 UTC](https://discourse.nodered.org/t/how-to-read-debug-console-line/2530 "2018-08-24T09:14:16Z")

</div>

I'm using node-red-contrib-ab for reading plc data. When PLC is disconnected it shows "Failure (Bad values)" in debug field as msg: String\[20\], i want to read this message so than i can know the plc is offline. I have…

---

## [How to inject a payload using a PLC](https://discourse.nodered.org/t/how-to-inject-a-payload-using-a-plc/2160)

<div class="topic-metadata">

**Author:** [@AlxOndahidr](https://discourse.nodered.org/u/AlxOndahidr)\
**Replies:** 30\
**Last updated:** [24 August 2018 08:32 UTC](https://discourse.nodered.org/t/how-to-inject-a-payload-using-a-plc/2160 "2018-08-24T08:32:07Z")

</div>

Hello, I would like to inject a payload to put it on the queue DL of my Conduit Multitech using my PLC (that PLC is working with TCP) Now I am injecting those payloads using timestamps in NodeRed or using external plat…

---

## [Counter node with gpio](https://discourse.nodered.org/t/counter-node-with-gpio/2456)

<div class="topic-metadata">

**Author:** [@Ghbisson](https://discourse.nodered.org/u/Ghbisson)\
**Replies:** 11\
**Last updated:** [24 August 2018 08:31 UTC](https://discourse.nodered.org/t/counter-node-with-gpio/2456 "2018-08-24T08:31:36Z")

</div>

I use a counter node to measure rain fall at my home. It sends a pulse every 0.2 mm but the node reads the value twice. Is there anyone who knows how this block counts i.e. on a rising edge falling edge both ?

---

## [Node Red programming language](https://discourse.nodered.org/t/node-red-programming-language/2526)

<div class="topic-metadata">

**Author:** [@Ghbisson](https://discourse.nodered.org/u/Ghbisson)\
**Replies:** 2\
**Last updated:** [24 August 2018 00:15 UTC](https://discourse.nodered.org/t/node-red-programming-language/2526 "2018-08-24T00:15:43Z")

</div>

In a Raspberry pi node red what is the programming language ? Question from a begeneer?

---

## [Updating node-red](https://discourse.nodered.org/t/updating-node-red/1740)

<div class="topic-metadata">

**Author:** [@scargill](https://discourse.nodered.org/u/scargill)\
**Replies:** 3\
**Last updated:** [23 August 2018 22:50 UTC](https://discourse.nodered.org/t/updating-node-red/1740 "2018-08-23T22:50:58Z")

</div>

Not for the first time recently with Node-Red (Raspberry Pi 3) - even using Dave's node/nr update script, and despite having a working setup before then doing updates in the palette manager, I find myself having to resor…

---

## [File In Node Error Deprecated](https://discourse.nodered.org/t/file-in-node-error-deprecated/2524)

<div class="topic-metadata">

**Author:** [@jmorris644](https://discourse.nodered.org/u/jmorris644)\
**Replies:** 1\
**Last updated:** [23 August 2018 22:20 UTC](https://discourse.nodered.org/t/file-in-node-error-deprecated/2524 "2018-08-23T22:20:21Z")

</div>

For the first time I am adding some file manipulation capabilities to one of my flows. I noticed that error notification for the File In node has been deprecated. The information about the node states to use the Catch no…

---

## [Unable to connect to arduino from serial](https://discourse.nodered.org/t/unable-to-connect-to-arduino-from-serial/2007)

<div class="topic-metadata">

**Author:** [@hary](https://discourse.nodered.org/u/hary)\
**Replies:** 9\
**Last updated:** [18 August 2018 14:04 UTC](https://discourse.nodered.org/t/unable-to-connect-to-arduino-from-serial/2007 "2018-08-18T14:04:13Z")

</div>

Hi. I made a flow to get some data from an Arduino from serial communication (USB) but I can't get it working on my RPi Stretch. pi@raspberrypi:~ $ node-red 2 Aug 16:37:29 - \[info\] Welcome to Node-RED ===============…

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

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