# General

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

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

**Page:** 569

---

## [Openweathermap with GPS](https://discourse.nodered.org/t/openweathermap-with-gps/44410)

<div class="topic-metadata">

**Author:** [@Roadrunny](https://discourse.nodered.org/u/Roadrunny)\
**Replies:** 5\
**Last updated:** [20 April 2021 07:08 UTC](https://discourse.nodered.org/t/openweathermap-with-gps/44410 "2021-04-20T07:08:08Z")

</div>

Hello. I want to use my GPS data for latitude and longitude, because its a RV installation. Could someone help me please?

---

## [Standard flows that could be overwritten with project specific changes](https://discourse.nodered.org/t/standard-flows-that-could-be-overwritten-with-project-specific-changes/44434)

<div class="topic-metadata">

**Author:** [@eastling](https://discourse.nodered.org/u/eastling)\
**Replies:** 0\
**Last updated:** [20 April 2021 05:49 UTC](https://discourse.nodered.org/t/standard-flows-that-could-be-overwritten-with-project-specific-changes/44434 "2021-04-20T05:49:10Z")

</div>

Hi guys, We are developing a set of flows that are meant to be re-used on several deployments (lets call this our "standard" code). However each deployment could have its own little tweak (lets call this part the "cust…

---

## [Node-red-contrib-oled issue - "type error"](https://discourse.nodered.org/t/node-red-contrib-oled-issue-type-error/43718)

<div class="topic-metadata">

**Author:** [@Steve\_Cotton](https://discourse.nodered.org/u/Steve_Cotton)\
**Replies:** 3\
**Last updated:** [20 April 2021 03:34 UTC](https://discourse.nodered.org/t/node-red-contrib-oled-issue-type-error/43718 "2021-04-20T03:34:31Z")

</div>

Hi @ all i´ve set up a very simple function to test my oled display. msg.payload = { size:2, x:1, y:20, text:"Hello!" } I connected the function directely to the String-Node. When i deploy, I get this message: "Type…

---

## [Function o some node](https://discourse.nodered.org/t/function-o-some-node/44366)

<div class="topic-metadata">

**Author:** [@Marty1982](https://discourse.nodered.org/u/Marty1982)\
**Replies:** 8\
**Last updated:** [20 April 2021 02:47 UTC](https://discourse.nodered.org/t/function-o-some-node/44366 "2021-04-20T02:47:28Z")

</div>

Hi all! I'm working with some devices obtaining one object for many of my Sonoff devices, using the api and getting the PowerStatus key. This i do for knowing which device is ON or OFF. So, if a device is ON i need to t…

---

## [Function definition in \`on start\` works but I'm not sure](https://discourse.nodered.org/t/function-definition-in-on-start-works-but-im-not-sure/44401)

<div class="topic-metadata">

**Author:** [@cflurin](https://discourse.nodered.org/u/cflurin)\
**Replies:** 6\
**Last updated:** [19 April 2021 20:23 UTC](https://discourse.nodered.org/t/function-definition-in-on-start-works-but-im-not-sure/44401 "2021-04-19T20:23:05Z")

</div>

I defined some sub functions I use in a function node in the tab on start, it works but I'm not sure wheather ii's allowed. on start: pad = function (number) { if (number \< 10) { return '0' + number; } return…

---

## [Fs file lister with synology](https://discourse.nodered.org/t/fs-file-lister-with-synology/44388)

<div class="topic-metadata">

**Author:** [@alexander77](https://discourse.nodered.org/u/alexander77)\
**Replies:** 8\
**Last updated:** [19 April 2021 20:13 UTC](https://discourse.nodered.org/t/fs-file-lister-with-synology/44388 "2021-04-19T20:13:26Z")

</div>

Hi, i would like to use a media player on my raspi (running node red) playing files from my synology drive. I used hard coding of the path (not via msg) in the form afp://mysynology.local/video mysynology is a placefo…

---

## [Jsonata + moment troubles](https://discourse.nodered.org/t/jsonata-moment-troubles/44405)

<div class="topic-metadata">

**Author:** [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Replies:** 7\
**Last updated:** [19 April 2021 18:57 UTC](https://discourse.nodered.org/t/jsonata-moment-troubles/44405 "2021-04-19T18:57:33Z")

</div>

I am a bit lost with jsonata and moment. Input data example: \[ \[1618243200000, 5.45, 5.45, 5.2, 5.2\], \[1618257600000, 4.98, 4.99, 4.96, 4.96\], \[1618272000000, 4.88, 4.88, 4.67, 4.69\], \[1618286400000, 4.…

---

## [Different results running command manually or in exec node](https://discourse.nodered.org/t/different-results-running-command-manually-or-in-exec-node/44234)

<div class="topic-metadata">

**Author:** [@hobbes1069](https://discourse.nodered.org/u/hobbes1069)\
**Replies:** 20\
**Last updated:** [19 April 2021 19:40 UTC](https://discourse.nodered.org/t/different-results-running-command-manually-or-in-exec-node/44234 "2021-04-19T19:40:34Z")

</div>

I'm trying to run a program with command line parameters put together by node red. When executed from node red I always get "File Not Found" (exit code 4) but if I run the exact same command from cmd.exe it works (exit c…

---

## [Listen to chanel for keyword publish to own bot](https://discourse.nodered.org/t/listen-to-chanel-for-keyword-publish-to-own-bot/44406)

<div class="topic-metadata">

**Author:** [@vikozo](https://discourse.nodered.org/u/vikozo)\
**Replies:** 3\
**Last updated:** [19 April 2021 15:26 UTC](https://discourse.nodered.org/t/listen-to-chanel-for-keyword-publish-to-own-bot/44406 "2021-04-19T15:26:25Z")

</div>

Hello i would like to listen to a chanel with my Node Red Telegram Node as soon a keyword is found it will send it to my own Telegram bot. is this possible and how to listen to a chanel? have a nice day vinc

---

## [Split a value into two values](https://discourse.nodered.org/t/split-a-value-into-two-values/43864)

<div class="topic-metadata">

**Author:** [@Becker](https://discourse.nodered.org/u/Becker)\
**Replies:** 22\
**Last updated:** [19 April 2021 12:22 UTC](https://discourse.nodered.org/t/split-a-value-into-two-values/43864 "2021-04-19T12:22:43Z")

</div>

Hi guys, today I have a very simple question for you: I´ve a value that varies between +2600 and -2500. I would like to distinguish this into two new values: if \<0 than var "Unloading", if\> 0 than var "Loading". but …

---

## [Ultrasonic Sensor and node-red-node-pisrf](https://discourse.nodered.org/t/ultrasonic-sensor-and-node-red-node-pisrf/44194)

<div class="topic-metadata">

**Author:** [@mzsolnay](https://discourse.nodered.org/u/mzsolnay)\
**Replies:** 13\
**Last updated:** [19 April 2021 13:54 UTC](https://discourse.nodered.org/t/ultrasonic-sensor-and-node-red-node-pisrf/44194 "2021-04-19T13:54:49Z")

</div>

Hi ! Built a project with ultrasonic sensor to check water level. Works fine. pisrf gives distance to water level in cm. Is there a way to change it to mm, or give the cm value a decimal? Thanks for any advice.

---

## [Sending HTML table as CSV via E-Mail event based](https://discourse.nodered.org/t/sending-html-table-as-csv-via-e-mail-event-based/44403)

<div class="topic-metadata">

**Author:** [@Georg25](https://discourse.nodered.org/u/Georg25)\
**Replies:** 0\
**Last updated:** [19 April 2021 12:49 UTC](https://discourse.nodered.org/t/sending-html-table-as-csv-via-e-mail-event-based/44403 "2021-04-19T12:49:44Z")

</div>

Hi guys, I have a new project. In this project, I collect the error messages of my system. I collect these with date, time, error level and description in a html-table to visualisate it on the dashboard. \[{"id":"dee16…

---

## [CSV skips boolean false values](https://discourse.nodered.org/t/csv-skips-boolean-false-values/44346)

<div class="topic-metadata">

**Author:** [@nrnoob](https://discourse.nodered.org/u/nrnoob)\
**Replies:** 3\
**Last updated:** [19 April 2021 09:05 UTC](https://discourse.nodered.org/t/csv-skips-boolean-false-values/44346 "2021-04-19T09:05:51Z")

</div>

I am using the CSV node to convert a JSON object containing an array to CSV. However, when the array contains boolean values (false, true), the node's output skips the false values. This is my test flow \` \[{"id":"d5dfd…

---

## [Separate timestamp](https://discourse.nodered.org/t/separate-timestamp/44377)

<div class="topic-metadata">

**Author:** [@lehoangtrung](https://discourse.nodered.org/u/lehoangtrung)\
**Replies:** 2\
**Last updated:** [19 April 2021 07:14 UTC](https://discourse.nodered.org/t/separate-timestamp/44377 "2021-04-19T07:14:10Z")

</div>

Hello, I am building an IoT project. I need timing query from Timestamp. Ex: Timestamp -\> 1618809944697 So, how can i separate this Timestamp into year, month, day, hour, ... help me please.

---

## [Node-red-contrib-epi-bluetooth.. How?](https://discourse.nodered.org/t/node-red-contrib-epi-bluetooth-how/44376)

<div class="topic-metadata">

**Author:** [@JereLehtonen](https://discourse.nodered.org/u/JereLehtonen)\
**Replies:** 0\
**Last updated:** [19 April 2021 05:32 UTC](https://discourse.nodered.org/t/node-red-contrib-epi-bluetooth-how/44376 "2021-04-19T05:32:23Z")

</div>

Hello all! Could someone demonstrate how do you receive and subscribe Bluetooth messages with this node? In the documentations there's saying that the writable data should be JSON strings that needs to be 20 byte packet…

---

## [Synchronizing multiple data on Google Spreadsheet Node RED](https://discourse.nodered.org/t/synchronizing-multiple-data-on-google-spreadsheet-node-red/44261)

<div class="topic-metadata">

**Author:** [@lehoangtrung](https://discourse.nodered.org/u/lehoangtrung)\
**Replies:** 2\
**Last updated:** [19 April 2021 05:29 UTC](https://discourse.nodered.org/t/synchronizing-multiple-data-on-google-spreadsheet-node-red/44261 "2021-04-19T05:29:56Z")

</div>

Hello, I am working on an IoT project for temperature data collection using Node RED. My data is uploaded to Gsheet. I have 2 temperature sensors. So, how can I synchronize that data? It means the same timestamp maybe…

---

## [How to display data from Mysql database in dashboard with text input](https://discourse.nodered.org/t/how-to-display-data-from-mysql-database-in-dashboard-with-text-input/44256)

<div class="topic-metadata">

**Author:** [@omarjalel](https://discourse.nodered.org/u/omarjalel)\
**Replies:** 4\
**Last updated:** [19 April 2021 03:21 UTC](https://discourse.nodered.org/t/how-to-display-data-from-mysql-database-in-dashboard-with-text-input/44256 "2021-04-19T03:21:50Z")

</div>

Hi all, I have a flow where I want to display a specific data from my database after submitting the form with a number (named NBT) which is the first column in the table in my database. I do the select query and the t…

---

## [Problem Connecting to Tuya Device](https://discourse.nodered.org/t/problem-connecting-to-tuya-device/44248)

<div class="topic-metadata">

**Author:** [@Buckskin](https://discourse.nodered.org/u/Buckskin)\
**Replies:** 6\
**Last updated:** [17 April 2021 22:41 UTC](https://discourse.nodered.org/t/problem-connecting-to-tuya-device/44248 "2021-04-17T22:41:52Z")

</div>

I use the node-red-contrib-tuya-smart-device node to connect to my Tuya devices and up until a few days ago everything was fine. However, the node now no longer connects to the devices. I do not think that it is either …

---

## [Node red and docker and mount](https://discourse.nodered.org/t/node-red-and-docker-and-mount/44227)

<div class="topic-metadata">

**Author:** [@pvklink](https://discourse.nodered.org/u/pvklink)\
**Replies:** 3\
**Last updated:** [18 April 2021 20:38 UTC](https://discourse.nodered.org/t/node-red-and-docker-and-mount/44227 "2021-04-18T20:38:14Z")

</div>

I am busy with dockering my domotica environment. I use the following compose-file and dockerfile to docker nodered and some dependencies Questions i have: i like to mount a usb drive to node-red to store camera-dat…

---

## [Mysql data in OPC-UA server](https://discourse.nodered.org/t/mysql-data-in-opc-ua-server/44104)

<div class="topic-metadata">

**Author:** [@usmanEmder](https://discourse.nodered.org/u/usmanEmder)\
**Replies:** 0\
**Last updated:** [13 April 2021 12:56 UTC](https://discourse.nodered.org/t/mysql-data-in-opc-ua-server/44104 "2021-04-13T12:56:05Z")

</div>

Hi, I am using "mysql" node and get data in node-red. While I have a "UPC-UA" server node and it shows the node and values. My question is how can i transfer the "mysql" data to "OPC-UA" server.

---

## [Simple push button](https://discourse.nodered.org/t/simple-push-button/44357)

<div class="topic-metadata">

**Author:** [@ebolisa](https://discourse.nodered.org/u/ebolisa)\
**Replies:** 1\
**Last updated:** [18 April 2021 18:22 UTC](https://discourse.nodered.org/t/simple-push-button/44357 "2021-04-18T18:22:55Z")

</div>

Hi, when I start the web page, the button´s label is not shown. It's only shown if the button is pressed and then the it stays on. How do I fix it? TIA \[ { "id": "315df55e.e5e2da", "type": "functio…

---

## [Subflow - Automatic Naming of Subflow Node](https://discourse.nodered.org/t/subflow-automatic-naming-of-subflow-node/44363)

<div class="topic-metadata">

**Author:** [@eddee54455](https://discourse.nodered.org/u/eddee54455)\
**Replies:** 0\
**Last updated:** [18 April 2021 16:51 UTC](https://discourse.nodered.org/t/subflow-automatic-naming-of-subflow-node/44363 "2021-04-18T16:51:01Z")

</div>

Good Day Wise Oracles! I am playing with a subflow, mainly to learn, and have come up with something that has me a bit stumped... The example I am using is a "Math Thingy" ... it is very basic, simply define the 2 topi…

---

## [Display Data from MySQL without uibuilder](https://discourse.nodered.org/t/display-data-from-mysql-without-uibuilder/44107)

<div class="topic-metadata">

**Author:** [@ChZeman](https://discourse.nodered.org/u/ChZeman)\
**Replies:** 26\
**Last updated:** [18 April 2021 16:21 UTC](https://discourse.nodered.org/t/display-data-from-mysql-without-uibuilder/44107 "2021-04-18T16:21:22Z")

</div>

I've been playing with uibuilder as time allows for the past couple months. Giving up on it... unfortunately. I like it but I can't get anywhere with it. The most I can get it to display is "Object object" or the entire …

---

## [functionExternalModules and module versions](https://discourse.nodered.org/t/functionexternalmodules-and-module-versions/44353)

<div class="topic-metadata">

**Author:** [@Colin](https://discourse.nodered.org/u/Colin)\
**Replies:** 4\
**Last updated:** [18 April 2021 14:50 UTC](https://discourse.nodered.org/t/functionexternalmodules-and-module-versions/44353 "2021-04-18T14:50:44Z")

</div>

Having moved to node-red 1.3 I decided to move some external modules I use across to use the functionExternalModules feature. One of these is js-yaml. Looking in package.json I see that I have previously installed manu…

---

## [Node-red-contrib-azure-iot-device & Duplicate Messages published in IoT Hub](https://discourse.nodered.org/t/node-red-contrib-azure-iot-device-duplicate-messages-published-in-iot-hub/44358)

<div class="topic-metadata">

**Author:** [@mgkeekrog](https://discourse.nodered.org/u/mgkeekrog)\
**Replies:** 0\
**Last updated:** [18 April 2021 14:23 UTC](https://discourse.nodered.org/t/node-red-contrib-azure-iot-device-duplicate-messages-published-in-iot-hub/44358 "2021-04-18T14:23:53Z")

</div>

Background: My project has 24 flows and between 2 and 8 "Direct" nodes being used per flow. I recently changed my entire project from using the "node-red-contrib-azure-iot-hub" palette to the "node-red-contrib-azure-iot…

---

## [Reading the box number, writing to the box of components](https://discourse.nodered.org/t/reading-the-box-number-writing-to-the-box-of-components/44319)

<div class="topic-metadata">

**Author:** [@cysoz](https://discourse.nodered.org/u/cysoz)\
**Replies:** 2\
**Last updated:** [18 April 2021 14:02 UTC](https://discourse.nodered.org/t/reading-the-box-number-writing-to-the-box-of-components/44319 "2021-04-18T14:02:14Z")

</div>

I have issue, but I am looking for help in solving. I put the box on the line I read number this box I am reading and writes a elements value box into the object (may be different amount) when box is full, I send this …

---

## [Node Red Mail Node not storing log in credentials](https://discourse.nodered.org/t/node-red-mail-node-not-storing-log-in-credentials/16318)

<div class="topic-metadata">

**Author:** [@Avipur](https://discourse.nodered.org/u/Avipur)\
**Replies:** 13\
**Last updated:** [18 April 2021 10:03 UTC](https://discourse.nodered.org/t/node-red-mail-node-not-storing-log-in-credentials/16318 "2021-04-18T10:03:37Z")

</div>

Hello , I am beginner in Node Red. I am trying to set mail from mail node. I am using gmail credentials. The node settings are as follows To xyz@gmail.com Server smtp:gmail.com Port 465 Secure connection ticked U…

---

## [object array to file](https://discourse.nodered.org/t/object-array-to-file/44332)

<div class="topic-metadata">

**Author:** [@madmax](https://discourse.nodered.org/u/madmax)\
**Replies:** 4\
**Last updated:** [18 April 2021 08:58 UTC](https://discourse.nodered.org/t/object-array-to-file/44332 "2021-04-18T08:58:05Z")

</div>

Hello! I have multiple objects in an array. I would like to save this in the txt file. Unfortunately we haven't found a solution yet. Maybe someone can help me there. This is what the array looks like \[0… 9\] 0: obje…

---

## [Email Node Crash on Reading Email with Large Attachment](https://discourse.nodered.org/t/email-node-crash-on-reading-email-with-large-attachment/44344)

<div class="topic-metadata">

**Author:** [@nred](https://discourse.nodered.org/u/nred)\
**Replies:** 5\
**Last updated:** [18 April 2021 07:58 UTC](https://discourse.nodered.org/t/email-node-crash-on-reading-email-with-large-attachment/44344 "2021-04-18T07:58:50Z")

</div>

I am using the Email Node to receive emails via IMAP. It works great but notice's it keeps crashing on a few emails that have large attachments 7-15mb. Does anyone have any ideas to work around this? Thanks.

---

## [Jsonate in change-node to set root (msg.) possible?](https://discourse.nodered.org/t/jsonate-in-change-node-to-set-root-msg-possible/44314)

<div class="topic-metadata">

**Author:** [@ozett](https://discourse.nodered.org/u/ozett)\
**Replies:** 8\
**Last updated:** [17 April 2021 17:50 UTC](https://discourse.nodered.org/t/jsonate-in-change-node-to-set-root-msg-possible/44314 "2021-04-17T17:50:17Z")

</div>

fiddling for hours with jsonata, but not sure if its possible to create a whole new message? how can i create a complete new .msg with jsonata (with additional new keys) ? \[{"id":"16a63eb5.2de521","type":"change","z…

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

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