# General

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

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

**Page:** 575

---

## [Updating mysql values](https://discourse.nodered.org/t/updating-mysql-values/43778)

<div class="topic-metadata">

**Author:** [@Newbie01](https://discourse.nodered.org/u/Newbie01)\
**Replies:** 3\
**Last updated:** [6 April 2021 19:37 UTC](https://discourse.nodered.org/t/updating-mysql-values/43778 "2021-04-06T19:37:32Z")

</div>

This works but should be a better way. Kinda new to node red but I have tried a Function node, a change node, and a Template node. Probably wrong but couldn't get any of them to work. Any help is greatly appreciated. \[{…

---

## [Closing file after use of node-red : file](https://discourse.nodered.org/t/closing-file-after-use-of-node-red-file/43763)

<div class="topic-metadata">

**Author:** [@Dirk\_L](https://discourse.nodered.org/u/Dirk_L)\
**Replies:** 9\
**Last updated:** [6 April 2021 14:26 UTC](https://discourse.nodered.org/t/closing-file-after-use-of-node-red-file/43763 "2021-04-06T14:26:41Z")

</div>

Hi @all out there! I am nearly new on red-node. Or it seems to me as if... I am using node-red : file to write data in a file. Fine and it works. But (There will allways be a but..). The file seems not to be updated …

---

## [Converting UNIX format to normal human format](https://discourse.nodered.org/t/converting-unix-format-to-normal-human-format/43510)

<div class="topic-metadata">

**Author:** [@Nikolay](https://discourse.nodered.org/u/Nikolay)\
**Replies:** 2\
**Last updated:** [6 April 2021 14:14 UTC](https://discourse.nodered.org/t/converting-unix-format-to-normal-human-format/43510 "2021-04-06T14:14:55Z")

</div>

Hello to All, I dad issues when trying to display information from sqlite to a ui template as a table and one of the columns needed to be a readable timestamp. Because I saved the date with a timestamp inject or Date.no…

---

## [Node-red Serial not showing data, but can see in putty or moserial](https://discourse.nodered.org/t/node-red-serial-not-showing-data-but-can-see-in-putty-or-moserial/43760)

<div class="topic-metadata">

**Author:** [@vikingsraven](https://discourse.nodered.org/u/vikingsraven)\
**Replies:** 2\
**Last updated:** [6 April 2021 13:41 UTC](https://discourse.nodered.org/t/node-red-serial-not-showing-data-but-can-see-in-putty-or-moserial/43760 "2021-04-06T13:41:41Z")

</div>

HI all, found an interesting issue (possibly), my friend purchased some Atlas Scientific modules and i was setting up a datalogger for him, but i couldnt get any data from the units over serial, this was remote so had p…

---

## [Use of fs as a global module (best practice )](https://discourse.nodered.org/t/use-of-fs-as-a-global-module-best-practice/43663)

<div class="topic-metadata">

**Author:** [@chrisn-au](https://discourse.nodered.org/u/chrisn-au)\
**Replies:** 6\
**Last updated:** [6 April 2021 11:24 UTC](https://discourse.nodered.org/t/use-of-fs-as-a-global-module-best-practice/43663 "2021-04-06T11:24:48Z")

</div>

I am after some advice on best/appropriate practice. I am using the fantastic node-red-contrib-google-oauth2 node to connect to the google APIs to upload files to google drive. The v3 of the drive API requires that a Re…

---

## [Fetch image and send to email](https://discourse.nodered.org/t/fetch-image-and-send-to-email/43738)

<div class="topic-metadata">

**Author:** [@jcarreira](https://discourse.nodered.org/u/jcarreira)\
**Replies:** 7\
**Last updated:** [6 April 2021 11:11 UTC](https://discourse.nodered.org/t/fetch-image-and-send-to-email/43738 "2021-04-06T11:11:54Z")

</div>

I'm trying to fetch a camera shot via the Fully Kiosk Browser REST API and send it via email. I can get it to send the email, but the attachment doesn't come through as a valid image. If I call the endpoint directly from…

---

## [Cancel inputs for a period of time](https://discourse.nodered.org/t/cancel-inputs-for-a-period-of-time/43749)

<div class="topic-metadata">

**Author:** [@luis](https://discourse.nodered.org/u/luis)\
**Replies:** 7\
**Last updated:** [6 April 2021 10:45 UTC](https://discourse.nodered.org/t/cancel-inputs-for-a-period-of-time/43749 "2021-04-06T10:45:50Z")

</div>

Is there a way I can cancel inputs from other nods using a button until I press it again?

---

## [How to get node id from syslog on crash](https://discourse.nodered.org/t/how-to-get-node-id-from-syslog-on-crash/43754)

<div class="topic-metadata">

**Author:** [@r0ller](https://discourse.nodered.org/u/r0ller)\
**Replies:** 2\
**Last updated:** [6 April 2021 09:39 UTC](https://discourse.nodered.org/t/how-to-get-node-id-from-syslog-on-crash/43754 "2021-04-06T09:39:15Z")

</div>

Hi All, I'd like to identify the node where my app crashes but I cannot really identify anything that could be used as a node id I could search for in the editor. Does anyone have any hint how to find the node responsi…

---

## [ui\_Switch not working on iOS devices](https://discourse.nodered.org/t/ui-switch-not-working-on-ios-devices/43730)

<div class="topic-metadata">

**Author:** [@wimphot](https://discourse.nodered.org/u/wimphot)\
**Replies:** 1\
**Last updated:** [6 April 2021 09:37 UTC](https://discourse.nodered.org/t/ui-switch-not-working-on-ios-devices/43730 "2021-04-06T09:37:27Z")

</div>

OK time to take the plunge and ask my first question. I have Node-RED -vers 10.23.1 - I think, that's what I see under Node version in the Container Stack. I am tinkering with a Sonoff+MQTT, I have a ui\_switch which us…

---

## [Processor architectire for node-red](https://discourse.nodered.org/t/processor-architectire-for-node-red/43741)

<div class="topic-metadata">

**Author:** [@addi](https://discourse.nodered.org/u/addi)\
**Replies:** 2\
**Last updated:** [6 April 2021 09:29 UTC](https://discourse.nodered.org/t/processor-architectire-for-node-red/43741 "2021-04-06T09:29:58Z")

</div>

Hello! Can somebody explain what kind of processor architectures node-red supports? It seems that only ARM Cortex Thaks in advance

---

## [DWD Weather Node and variables](https://discourse.nodered.org/t/dwd-weather-node-and-variables/43589)

<div class="topic-metadata">

**Author:** [@Nocoderactually](https://discourse.nodered.org/u/Nocoderactually)\
**Replies:** 1\
**Last updated:** [6 April 2021 08:18 UTC](https://discourse.nodered.org/t/dwd-weather-node-and-variables/43589 "2021-04-06T08:18:44Z")

</div>

The DWD Weather node is a very usefull thing. However the mosixStation ID has to be entered statically. If I want to make a selection with a drop down menü to select between a couple of stations, I would like to use a v…

---

## [Running python in virtual environment](https://discourse.nodered.org/t/running-python-in-virtual-environment/43744)

<div class="topic-metadata">

**Author:** [@anguslou](https://discourse.nodered.org/u/anguslou)\
**Replies:** 0\
**Last updated:** [6 April 2021 07:38 UTC](https://discourse.nodered.org/t/running-python-in-virtual-environment/43744 "2021-04-06T07:38:42Z")

</div>

I have some python scripts that want to run by Node-Red with a few questions: From Node-Red, how to pass A, B, C or D to specific functions in a Class? Python script (eg) Class math def multiply(A, B): print (A \* B…

---

## [Node.status using multiple variables](https://discourse.nodered.org/t/node-status-using-multiple-variables/43734)

<div class="topic-metadata">

**Author:** [@Mick](https://discourse.nodered.org/u/Mick)\
**Replies:** 1\
**Last updated:** [6 April 2021 06:30 UTC](https://discourse.nodered.org/t/node-status-using-multiple-variables/43734 "2021-04-06T06:30:29Z")

</div>

I would like to be able to use the status node to show the status of multiple variables in my function. I can easily show one variable and have looked for examples but have not found any yet. The function: node.stat…

---

## [Node Red into Telegram Bot into Telegram Chanel](https://discourse.nodered.org/t/node-red-into-telegram-bot-into-telegram-chanel/41826)

<div class="topic-metadata">

**Author:** [@vikozo](https://discourse.nodered.org/u/vikozo)\
**Replies:** 14\
**Last updated:** [6 April 2021 06:26 UTC](https://discourse.nodered.org/t/node-red-into-telegram-bot-into-telegram-chanel/41826 "2021-04-06T06:26:41Z")

</div>

Hello i have a Node Red script sending Information to my Telegram Bot! This Part works fine. to be able for more reader of the Bot information i had to create a Chanel. I did so and also added my Bot as Admin into th…

---

## [Mqtt conection refused sometimes](https://discourse.nodered.org/t/mqtt-conection-refused-sometimes/40927)

<div class="topic-metadata">

**Author:** [@tazinblack](https://discourse.nodered.org/u/tazinblack)\
**Replies:** 12\
**Last updated:** [6 April 2021 05:35 UTC](https://discourse.nodered.org/t/mqtt-conection-refused-sometimes/40927 "2021-04-06T05:35:29Z")

</div>

Hello together, I'm tinkering a camera device with a pir motion sensor for the door. Looks good so far. There's only one problem. I use a script that reads the signal from the pir sensor and when motion is detected it…

---

## [Email Node with Attachements does not work](https://discourse.nodered.org/t/email-node-with-attachements-does-not-work/43402)

<div class="topic-metadata">

**Author:** [@khelper](https://discourse.nodered.org/u/khelper)\
**Replies:** 14\
**Last updated:** [5 April 2021 22:20 UTC](https://discourse.nodered.org/t/email-node-with-attachements-does-not-work/43402 "2021-04-05T22:20:26Z")

</div>

Hi all, I want to send an email with attachment. Up until last week my flow worked, but it suddenly stopped and I just cannot find out why. This is how I prepare my email. And this is how my flow works: It worked …

---

## [Only send msg when some input data has had value for amount of time](https://discourse.nodered.org/t/only-send-msg-when-some-input-data-has-had-value-for-amount-of-time/43727)

<div class="topic-metadata">

**Author:** [@menloperk](https://discourse.nodered.org/u/menloperk)\
**Replies:** 3\
**Last updated:** [5 April 2021 21:34 UTC](https://discourse.nodered.org/t/only-send-msg-when-some-input-data-has-had-value-for-amount-of-time/43727 "2021-04-05T21:34:51Z")

</div>

I am quite a newbie to Node-Red but until now have extremely enjoyed working with it. So my apologies if I am not using the right terminology... My flow is involving reading/writing Modbus registers but the question is …

---

## [Forcing a Deploy from inside Flow](https://discourse.nodered.org/t/forcing-a-deploy-from-inside-flow/43720)

<div class="topic-metadata">

**Author:** [@psalibe](https://discourse.nodered.org/u/psalibe)\
**Replies:** 1\
**Last updated:** [5 April 2021 19:11 UTC](https://discourse.nodered.org/t/forcing-a-deploy-from-inside-flow/43720 "2021-04-05T19:11:24Z")

</div>

Hello, I am wondering if there is a way to force a deploy from inside the flow of Node-Red. For example, if my OPCUA Server isn't reading for 30 seconds, I would like for the flow to redeploy itself (As this usually rec…

---

## [Emoncms node installed but not showing on nodes menu](https://discourse.nodered.org/t/emoncms-node-installed-but-not-showing-on-nodes-menu/43670)

<div class="topic-metadata">

**Author:** [@LuisB](https://discourse.nodered.org/u/LuisB)\
**Replies:** 3\
**Last updated:** [5 April 2021 16:08 UTC](https://discourse.nodered.org/t/emoncms-node-installed-but-not-showing-on-nodes-menu/43670 "2021-04-05T16:08:05Z")

</div>

I have some knowledge but not an expert. I followed the installation for emoncms per node-red-node-emoncms (node) - Node-RED . When I go to " /usr/src/node-red/node\_modules" I see the directory "node-red-node-emoncms…

---

## [Pop Up Message a la "WinPop"](https://discourse.nodered.org/t/pop-up-message-a-la-winpop/43704)

<div class="topic-metadata">

**Author:** [@eddee54455](https://discourse.nodered.org/u/eddee54455)\
**Replies:** 6\
**Last updated:** [5 April 2021 16:03 UTC](https://discourse.nodered.org/t/pop-up-message-a-la-winpop/43704 "2021-04-05T16:03:43Z")

</div>

G'day Professors! As a relative newbie but learning as I go, I am looking for a SIMPLE message pop up method.... I would like to direct a one liner to a specific ip address - (A bit like the WinPop command)... Prefera…

---

## [Help with msg.payload from object from db](https://discourse.nodered.org/t/help-with-msg-payload-from-object-from-db/43580)

<div class="topic-metadata">

**Author:** [@Broutech](https://discourse.nodered.org/u/Broutech)\
**Replies:** 6\
**Last updated:** [5 April 2021 14:33 UTC](https://discourse.nodered.org/t/help-with-msg-payload-from-object-from-db/43580 "2021-04-05T14:33:56Z")

</div>

Hi All, Looking for some assistance on how to formulate or prep an object that i retrieved from a db query and post to Telegram

---

## [Code explanation about applied filter](https://discourse.nodered.org/t/code-explanation-about-applied-filter/43709)

<div class="topic-metadata">

**Author:** [@Auke](https://discourse.nodered.org/u/Auke)\
**Replies:** 2\
**Last updated:** [5 April 2021 14:22 UTC](https://discourse.nodered.org/t/code-explanation-about-applied-filter/43709 "2021-04-05T14:22:24Z")

</div>

Hi, I have NR-node-MongoDB that feeds a function "Wrapper" with msg.payload. Since i am new to NR i am not sure what the first part of the function "Wrapper" does: it uses some filter logic but i cannot find the exact …

---

## [Multiply and add (manually entered) numbers](https://discourse.nodered.org/t/multiply-and-add-manually-entered-numbers/43692)

<div class="topic-metadata">

**Author:** [@PinPat](https://discourse.nodered.org/u/PinPat)\
**Replies:** 12\
**Last updated:** [5 April 2021 12:48 UTC](https://discourse.nodered.org/t/multiply-and-add-manually-entered-numbers/43692 "2021-04-05T12:48:52Z")

</div>

I have three manually entered numbers. I want to multiply two numbers and then add third numbers. Can someone please assist in choosing right palette and flow.

---

## [Modbus write back delay](https://discourse.nodered.org/t/modbus-write-back-delay/43575)

<div class="topic-metadata">

**Author:** [@vaughan.mcd](https://discourse.nodered.org/u/vaughan.mcd)\
**Replies:** 9\
**Last updated:** [5 April 2021 12:35 UTC](https://discourse.nodered.org/t/modbus-write-back-delay/43575 "2021-04-05T12:35:01Z")

</div>

Hi all, I have had this flow implemented for a while for my air condition integration and thought it was working but found that under some situations it gets in to a re write loop some how, I think it might be because Mo…

---

## [Select Data from SQLite and insert into Azure SQL Server](https://discourse.nodered.org/t/select-data-from-sqlite-and-insert-into-azure-sql-server/11127)

<div class="topic-metadata">

**Author:** [@thagan](https://discourse.nodered.org/u/thagan)\
**Replies:** 11\
**Last updated:** [5 April 2021 12:24 UTC](https://discourse.nodered.org/t/select-data-from-sqlite-and-insert-into-azure-sql-server/11127 "2021-04-05T12:24:16Z")

</div>

Hello, I have a Raspberry Pi that is pulling data from a SMA Solar inverter and storing it in a SQLite database every (1) minute. I want to use Node-Red to copy/sync that data up to a SQL Server I have in Azure. I have…

---

## [Extend a trigger without triggering it](https://discourse.nodered.org/t/extend-a-trigger-without-triggering-it/43699)

<div class="topic-metadata">

**Author:** [@hazymat](https://discourse.nodered.org/u/hazymat)\
**Replies:** 4\
**Last updated:** [5 April 2021 11:36 UTC](https://discourse.nodered.org/t/extend-a-trigger-without-triggering-it/43699 "2021-04-05T11:36:37Z")

</div>

In the bedroom I have two presence sensors: PIR and Audio. Both are wired directly into a Trigger node used in "wait for" and "extend delay" mode. The lights turn on if there is movement or noise, and they stay on for a …

---

## [Set Output for specified time high](https://discourse.nodered.org/t/set-output-for-specified-time-high/43697)

<div class="topic-metadata">

**Author:** [@malaxy](https://discourse.nodered.org/u/malaxy)\
**Replies:** 2\
**Last updated:** [5 April 2021 10:32 UTC](https://discourse.nodered.org/t/set-output-for-specified-time-high/43697 "2021-04-05T10:32:13Z")

</div>

Hello If my function node returns "1" then I need to turn on a GPIO Pin for 10 seconds on. After this then seconds it should be turned off. First I tried it with a while loop. But the delay function is somethin JS didn…

---

## [How to create time-based dimmer rules only if light is on](https://discourse.nodered.org/t/how-to-create-time-based-dimmer-rules-only-if-light-is-on/43656)

<div class="topic-metadata">

**Author:** [@reverendalc](https://discourse.nodered.org/u/reverendalc)\
**Replies:** 3\
**Last updated:** [5 April 2021 07:52 UTC](https://discourse.nodered.org/t/how-to-create-time-based-dimmer-rules-only-if-light-is-on/43656 "2021-04-05T07:52:15Z")

</div>

I have several dimmers in my home (tasmota mqtt). the lights live at 100% unless it's night time, in which case they're dimmed significantly to offer nighttime visibility without being disruptively bright. both dimmers…

---

## [Alexa-local no device discovery](https://discourse.nodered.org/t/alexa-local-no-device-discovery/43658)

<div class="topic-metadata">

**Author:** [@knaxman](https://discourse.nodered.org/u/knaxman)\
**Replies:** 1\
**Last updated:** [5 April 2021 05:51 UTC](https://discourse.nodered.org/t/alexa-local-no-device-discovery/43658 "2021-04-05T05:51:38Z")

</div>

Hi guys, I'd like to trigger some nodes based on voice commands from alexa. I have seen pretty good examples using alexa local, but also found in the forum some issues since September 19. Does anybody has the "alexa-lo…

---

## [Unable to install Node-sqlite](https://discourse.nodered.org/t/unable-to-install-node-sqlite/43671)

<div class="topic-metadata">

**Author:** [@TriAtma-D](https://discourse.nodered.org/u/TriAtma-D)\
**Replies:** 1\
**Last updated:** [5 April 2021 05:27 UTC](https://discourse.nodered.org/t/unable-to-install-node-sqlite/43671 "2021-04-05T05:27:28Z")

</div>

can you help me to solve my installation issue. here the log shown to me, thank youu 2021-04-05T01:21:01.854Z Install : node-red-node-sqlite 0.6.0 2021-04-05T01:21:02.199Z npm.cmd install --no-audit --no-update-notifi…

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

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