# Latest **URL:** https://discourse.nodered.org/latest.md?page=557 [Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md) **Page:** 558 --- ## [How to export / import MSSQL username and password](https://discourse.nodered.org/t/how-to-export-import-mssql-username-and-password/63561)
**Author:** [@HoussemLajili](https://discourse.nodered.org/u/HoussemLajili)\ **Replies:** 3\ **Last updated:** [7 June 2022 12:45 UTC](https://discourse.nodered.org/t/how-to-export-import-mssql-username-and-password/63561 "2022-06-07T12:45:19Z")
MSSQL username and password ( variable env) but when export / import, these are lost --- ## [OPC UA to SQL Problem](https://discourse.nodered.org/t/opc-ua-to-sql-problem/63550)
**Author:** [@DiveDeepNorway](https://discourse.nodered.org/u/DiveDeepNorway)\ **Replies:** 5\ **Last updated:** [7 June 2022 08:18 UTC](https://discourse.nodered.org/t/opc-ua-to-sql-problem/63550 "2022-06-07T08:18:55Z")
I have problem sending data from OPC UA to MS SQL database. I have 3 tags that i read from my PLC (seconds, minutes and houre). This works find. But when I try to extract the value and put it into my SQL database, I get… --- ## [SOLVED: Node Red running on a device with 2 IP connections](https://discourse.nodered.org/t/solved-node-red-running-on-a-device-with-2-ip-connections/62740)
**Author:** [@kvramji](https://discourse.nodered.org/u/kvramji)\ **Replies:** 21\ **Last updated:** [7 June 2022 07:30 UTC](https://discourse.nodered.org/t/solved-node-red-running-on-a-device-with-2-ip-connections/62740 "2022-06-07T07:30:50Z")
Can someone who has worked with this please tell me if there is something which can be configured in the settings.js file where i can have node red work on the 2 IP addresses which are connected to my pi? I have a custo… --- ## [Track with “worldmap” node including the owntracks app](https://discourse.nodered.org/t/track-with-worldmap-node-including-the-owntracks-app/63530)
**Author:** [@anairamy](https://discourse.nodered.org/u/anairamy)\ **Replies:** 1\ **Last updated:** [7 June 2022 06:33 UTC](https://discourse.nodered.org/t/track-with-worldmap-node-including-the-owntracks-app/63530 "2022-06-07T06:33:07Z")
Hi there, Does anyone know how to track an transport, ensuring the product makes the necessary journey from farm to restaurant with “worldmap” node including the owntracks app? P.S.: I know this question is broad but i… --- ## [Auto forwarding of bot messages](https://discourse.nodered.org/t/auto-forwarding-of-bot-messages/63503)
**Author:** [@GorkaUrzelai](https://discourse.nodered.org/u/GorkaUrzelai)\ **Replies:** 4\ **Last updated:** [7 June 2022 06:18 UTC](https://discourse.nodered.org/t/auto-forwarding-of-bot-messages/63503 "2022-06-07T06:18:36Z")
Hello, I created a new bot that only sends one menssage after client sends something. After sent that message I want the client (not bot) to have the forwarding to the bots message. I can not do this and I need help. I … --- ## [Payload + URL (msg.url) on Button press for POST request](https://discourse.nodered.org/t/payload-url-msg-url-on-button-press-for-post-request/63540)
**Author:** [@DanielEcheverri](https://discourse.nodered.org/u/DanielEcheverri)\ **Replies:** 4\ **Last updated:** [7 June 2022 02:47 UTC](https://discourse.nodered.org/t/payload-url-msg-url-on-button-press-for-post-request/63540 "2022-06-07T02:47:09Z")
Hi everyone. I have two variables entered by the user using text input. Let's call them variables A and B. Based on the value entered in Variable A, I have a function that sets a specific IP address as msg.url for HTTP r… --- ## [UK (Met Office) Pollen forecast](https://discourse.nodered.org/t/uk-met-office-pollen-forecast/61507)
**Author:** [@Sean-McG](https://discourse.nodered.org/u/Sean-McG)\ **Replies:** 12\ **Last updated:** [7 June 2022 02:29 UTC](https://discourse.nodered.org/t/uk-met-office-pollen-forecast/61507 "2022-06-07T02:29:52Z")
I have just posted this in the flows section https://flows.nodered.org/flow/c14fb7c020a0243a742d987defea85d5 --- ## [Open Port RS485](https://discourse.nodered.org/t/open-port-rs485/63429)
**Author:** [@Michell\_Iron\_Man](https://discourse.nodered.org/u/Michell_Iron_Man)\ **Replies:** 1\ **Last updated:** [7 June 2022 01:53 UTC](https://discourse.nodered.org/t/open-port-rs485/63429 "2022-06-07T01:53:14Z")
I have a CM4-IO-POE-4G-box gateway based on raspberry, I want to know how to activate the RS485 port to be able to carry out serial communication in Node-RED --- ## [How do I use serialport node to write to a RS485](https://discourse.nodered.org/t/how-do-i-use-serialport-node-to-write-to-a-rs485/63484)
**Author:** [@SP-Mushrooms](https://discourse.nodered.org/u/SP-Mushrooms)\ **Replies:** 6\ **Last updated:** [7 June 2022 01:48 UTC](https://discourse.nodered.org/t/how-do-i-use-serialport-node-to-write-to-a-rs485/63484 "2022-06-07T01:48:50Z")
Sorry for this qn but I cant find a solution for my problem my problemis how to I write to a RS485 device using simple serial communication. I am trying to google search and look through the forum but I keep on finding … --- ## [Web page data mining](https://discourse.nodered.org/t/web-page-data-mining/63394)
**Author:** [@Xenos](https://discourse.nodered.org/u/Xenos)\ **Replies:** 2\ **Last updated:** [7 June 2022 00:19 UTC](https://discourse.nodered.org/t/web-page-data-mining/63394 "2022-06-07T00:19:12Z")
Nube here with a nube question.. The section of webpage code I’m trying to capture is as follows. rem. \
rem. \$22.86 I'm using the edit HTML node with “div.co… --- ## [Dynamic min max artless gauge dont work](https://discourse.nodered.org/t/dynamic-min-max-artless-gauge-dont-work/63515)
**Author:** [@Kundepuu](https://discourse.nodered.org/u/Kundepuu)\ **Replies:** 2\ **Last updated:** [6 June 2022 23:50 UTC](https://discourse.nodered.org/t/dynamic-min-max-artless-gauge-dont-work/63515 "2022-06-06T23:50:12Z")
I need to set min and max dynamically. In my flow this works Ok with normal gauge but dont work with artless linear gauge. How to solve? flows (11).json (5.4 KB) --- ## [Pass an html template to pdf, any ideas?](https://discourse.nodered.org/t/pass-an-html-template-to-pdf-any-ideas/63536)
**Author:** [@LilGrundy](https://discourse.nodered.org/u/LilGrundy)\ **Replies:** 0\ **Last updated:** [6 June 2022 22:21 UTC](https://discourse.nodered.org/t/pass-an-html-template-to-pdf-any-ideas/63536 "2022-06-06T22:21:33Z")
Good morning to the entire node red community, I am new to this, as you will see I am learning from node red, and of course I have a question, I have a template of an html table that I use to view some data from my mysql… --- ## [Ui-level node without min/max values?](https://discourse.nodered.org/t/ui-level-node-without-min-max-values/63510)
**Author:** [@stefan24](https://discourse.nodered.org/u/stefan24)\ **Replies:** 2\ **Last updated:** [6 June 2022 21:42 UTC](https://discourse.nodered.org/t/ui-level-node-without-min-max-values/63510 "2022-06-06T21:42:31Z")
@hotNipi, (how) can I disable the min and max values? I want to use ui\_level for the current position of my roller shutter and do not need these values. --- ## [Code Linting for nodes](https://discourse.nodered.org/t/code-linting-for-nodes/63517)
**Author:** [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\ **Replies:** 1\ **Last updated:** [6 June 2022 21:03 UTC](https://discourse.nodered.org/t/code-linting-for-nodes/63517 "2022-06-06T21:03:57Z")
Hi all, just a quick hint for anyone writing custom nodes. I use the ESLINT tool which integrates with VSCode in order to dynamically spot loads of coding issues as well as to help enforce a particular coding style (whi… --- ## [How to send a message when time is expired](https://discourse.nodered.org/t/how-to-send-a-message-when-time-is-expired/63497)
**Author:** [@jmicks8](https://discourse.nodered.org/u/jmicks8)\ **Replies:** 2\ **Last updated:** [6 June 2022 20:50 UTC](https://discourse.nodered.org/t/how-to-send-a-message-when-time-is-expired/63497 "2022-06-06T20:50:44Z")
Hi, I am still pretty new with NodeRed and could use some help getting a message to send at the right time. I have a garage door sensor connected to Hubitat and get status using the Hubitat device node. I only want to s… --- ## [Multi-site MQTT Topic](https://discourse.nodered.org/t/multi-site-mqtt-topic/63532)
**Author:** [@LinkView\_Maze](https://discourse.nodered.org/u/LinkView_Maze)\ **Replies:** 1\ **Last updated:** [6 June 2022 20:03 UTC](https://discourse.nodered.org/t/multi-site-mqtt-topic/63532 "2022-06-06T20:03:14Z")
hello I plan to deploy several raspberries with node red and an MQTT broker to monitor in a "PCVUE" hypervisor. Each site has a 4-digit number in a text file in /home/pi/Documents/sitenumber.txt . My node-red has a lo… --- ## [Alerts/Notification](https://discourse.nodered.org/t/alerts-notification/63525)
**Author:** [@anairamy](https://discourse.nodered.org/u/anairamy)\ **Replies:** 9\ **Last updated:** [6 June 2022 19:09 UTC](https://discourse.nodered.org/t/alerts-notification/63525 "2022-06-06T19:09:34Z")
Hi everyone! I've some difficult to use "notification" on node-red. When i use this method, i get nonstop notifications and as I use two mqtt's, the notifications end up on top of each other. In this function (next … --- ## [Rate Limits for HTTP requests](https://discourse.nodered.org/t/rate-limits-for-http-requests/63490)
**Author:** [@lizzardguki](https://discourse.nodered.org/u/lizzardguki)\ **Replies:** 2\ **Last updated:** [6 June 2022 17:57 UTC](https://discourse.nodered.org/t/rate-limits-for-http-requests/63490 "2022-06-06T17:57:25Z")
So the problem I had in the previous post was caused by the API rate limit. so string to figure out a design for rate limit, after each message I receive back headers X-RateLimit-Reset & X-RateLimit-Limit (Airthings fo… --- ## [PermissionError: \[Errno 13\] Permission denied: '/home/user/ - PythonScript](https://discourse.nodered.org/t/permissionerror-errno-13-permission-denied-home-user-pythonscript/63182)
**Author:** [@cyrillschuerch](https://discourse.nodered.org/u/cyrillschuerch)\ **Replies:** 8\ **Last updated:** [6 June 2022 14:43 UTC](https://discourse.nodered.org/t/permissionerror-errno-13-permission-denied-home-user-pythonscript/63182 "2022-06-06T14:43:03Z")
Hello Node-Red Community I am a beginner. I would like to start a python script with Node-red. A PDF should be generated and saved. I installed the "node-red-contrib-pythonshell" adapter and installed a corresponding V… --- ## [Get Windows Services list from Ubuntu Installation?](https://discourse.nodered.org/t/get-windows-services-list-from-ubuntu-installation/63512)
**Author:** [@MyRandomThoughts](https://discourse.nodered.org/u/MyRandomThoughts)\ **Replies:** 1\ **Last updated:** [6 June 2022 14:10 UTC](https://discourse.nodered.org/t/get-windows-services-list-from-ubuntu-installation/63512 "2022-06-06T14:10:33Z")
I am running Node-RED on ubuntu and want to be able to check on a couple of Windows services. Does anyone know how I can do this? I was thinking maybe WMIC or such, but finding working tool is proving hard. Thanks --- ## [Cleaning up monaco models left behind](https://discourse.nodered.org/t/cleaning-up-monaco-models-left-behind/63500)
**Author:** [@nileio](https://discourse.nodered.org/u/nileio)\ **Replies:** 3\ **Last updated:** [6 June 2022 09:52 UTC](https://discourse.nodered.org/t/cleaning-up-monaco-models-left-behind/63500 "2022-06-06T09:52:37Z")
Hi Team, I have a custom node and the following note is constantly printed on the console Cleaning up monaco models left behind. Any node that calls createEditor() should call .destroy(). seems to be coming from red… --- ## [Missing ";" before statement in if statement](https://discourse.nodered.org/t/missing-before-statement-in-if-statement/63504)
**Author:** [@Nice\_to\_have](https://discourse.nodered.org/u/Nice_to_have)\ **Replies:** 2\ **Last updated:** [6 June 2022 07:25 UTC](https://discourse.nodered.org/t/missing-before-statement-in-if-statement/63504 "2022-06-06T07:25:58Z")
Hi everyone, I have been reading the forum on how to write an if statement. I thought I was doing okay, but right at the end it gives me a 'Missing ";" before statement'. Not sure what to do here. var wave = msg.payl… --- ## [How can i get web-cookie in my running flow?](https://discourse.nodered.org/t/how-can-i-get-web-cookie-in-my-running-flow/63380)
**Author:** [@weber\_j](https://discourse.nodered.org/u/weber_j)\ **Replies:** 4\ **Last updated:** [6 June 2022 03:04 UTC](https://discourse.nodered.org/t/how-can-i-get-web-cookie-in-my-running-flow/63380 "2022-06-06T03:04:01Z")
i want to get web cookie when i use function-node, i want to use dynamic cookie to send request thanks for help --- ## [Run multiple instances of node-red within a jupyterhub](https://discourse.nodered.org/t/run-multiple-instances-of-node-red-within-a-jupyterhub/63403)
**Author:** [@aschiffler](https://discourse.nodered.org/u/aschiffler)\ **Replies:** 5\ **Last updated:** [5 June 2022 23:43 UTC](https://discourse.nodered.org/t/run-multiple-instances-of-node-red-within-a-jupyterhub/63403 "2022-06-05T23:43:03Z")
Hi, my actual architecture is this: picture Therefore a single user node-red instance is started (spawned) by the jupyterhub. To secure the routes the node-red instance has to do oauth2 against the jupyterhub. This ca… --- ## [Trigger CLI command on user's PC](https://discourse.nodered.org/t/trigger-cli-command-on-users-pc/63491)
**Author:** [@CBianca](https://discourse.nodered.org/u/CBianca)\ **Replies:** 1\ **Last updated:** [5 June 2022 21:38 UTC](https://discourse.nodered.org/t/trigger-cli-command-on-users-pc/63491 "2022-06-05T21:38:33Z")
Hello guys! I have a question about the possibility of an implementation, I just want a direction so I can dig more into that. I have my node-red server on my laptop. Let's say another user from another laptop connects… --- ## [Set environment variable node MSSQL username ,password](https://discourse.nodered.org/t/set-environment-variable-node-mssql-username-password/63486)
**Author:** [@HoussemLajili](https://discourse.nodered.org/u/HoussemLajili)\ **Replies:** 7\ **Last updated:** [5 June 2022 18:11 UTC](https://discourse.nodered.org/t/set-environment-variable-node-mssql-username-password/63486 "2022-06-05T18:11:38Z")
is impossible to set an environment variable username, password in node-red-contrib-mssql-plus ?? I tried {{username}} and {{{username}}} but it didn't work --- ## [Node-red payload](https://discourse.nodered.org/t/node-red-payload/63482)
**Author:** [@a45293](https://discourse.nodered.org/u/a45293)\ **Replies:** 17\ **Last updated:** [5 June 2022 16:37 UTC](https://discourse.nodered.org/t/node-red-payload/63482 "2022-06-05T16:37:59Z")
Boa tarde, alguem me consegue ajudar, eu quero imprimir do meu payload todos os elementos que estão em \_value mas quando faço msg.payload.\_value ele da me "undefined" mas qunado eu faço msg.pauload\[0\].\_value ele imprime … --- ## [Technique to use a matrix keypad from GPIO](https://discourse.nodered.org/t/technique-to-use-a-matrix-keypad-from-gpio/63439)
**Author:** [@aduroch](https://discourse.nodered.org/u/aduroch)\ **Replies:** 6\ **Last updated:** [5 June 2022 16:09 UTC](https://discourse.nodered.org/t/technique-to-use-a-matrix-keypad-from-gpio/63439 "2022-06-05T16:09:25Z")
Hello, I'm having a hardtime configuring an hardware matrix keypad 4x4 within Node Red, using GPIO on a raspberry PI 3B+ All the hardware is set and works good. I use Gpio Input pull-down for rows and Gpio Output for Co… --- ## [Call Node-RED flow from Node.js](https://discourse.nodered.org/t/call-node-red-flow-from-node-js/63480)
**Author:** [@vitaliimarushko](https://discourse.nodered.org/u/vitaliimarushko)\ **Replies:** 9\ **Last updated:** [5 June 2022 14:38 UTC](https://discourse.nodered.org/t/call-node-red-flow-from-node-js/63480 "2022-06-05T14:38:51Z")
Hi! I built a flow in Node-RED where I make an HTTP request and get some response. Now I need to call this already built flow from Express (Node.js) application and get the calling result inside my server. If I underst… --- ## [Multiple device data to table](https://discourse.nodered.org/t/multiple-device-data-to-table/63476)
**Author:** [@lovenodered](https://discourse.nodered.org/u/lovenodered)\ **Replies:** 2\ **Last updated:** [5 June 2022 13:27 UTC](https://discourse.nodered.org/t/multiple-device-data-to-table/63476 "2022-06-05T13:27:23Z")
Hello , im trying to put multiple modbus device data into one table,, the result is weird.. its show only first column and sometimes disapear due to different timing of device transmit. how to get this work? THANK… [Previous page](https://discourse.nodered.org/latest.md?page=556) [Next page](https://discourse.nodered.org/latest.md?page=558)