# General

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

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

**Page:** 587

---

## [MSSQL Node Parameter](https://discourse.nodered.org/t/mssql-node-parameter/42700)

<div class="topic-metadata">

**Author:** [@Eintracht00](https://discourse.nodered.org/u/Eintracht00)\
**Replies:** 6\
**Last updated:** [16 March 2021 09:11 UTC](https://discourse.nodered.org/t/mssql-node-parameter/42700 "2021-03-16T09:11:11Z")

</div>

I use the MSSQL Node to transfer Data to my SQL Server. I want to use the parameters like this: but there comes an error. Is it maybe not posible to have in the name of the parameter a "-" or "\_"?

---

## [Problem with exec node displaying log file](https://discourse.nodered.org/t/problem-with-exec-node-displaying-log-file/40963)

<div class="topic-metadata">

**Author:** [@AungKL](https://discourse.nodered.org/u/AungKL)\
**Replies:** 6\
**Last updated:** [16 March 2021 08:29 UTC](https://discourse.nodered.org/t/problem-with-exec-node-displaying-log-file/40963 "2021-03-16T08:29:38Z")

</div>

Hello, I want to display log file on dashboard by using template node from this reference. It's working well until the file containing with special char like ( β, µ). I'm using "cat" command with exec node. I've teste…

---

## [Postgrestor bug - multiple databases](https://discourse.nodered.org/t/postgrestor-bug-multiple-databases/42470)

<div class="topic-metadata">

**Author:** [@Damorck](https://discourse.nodered.org/u/Damorck)\
**Replies:** 2\
**Last updated:** [16 March 2021 07:15 UTC](https://discourse.nodered.org/t/postgrestor-bug-multiple-databases/42470 "2021-03-16T07:15:37Z")

</div>

Hi all This issue I can produce in my setup. Working with postgresql, this node is the best IMO. Has anyone found a fix/workaround this bug? My approach would be to create a new NodeRED instance so I can "spread" my f…

---

## [Cheap server options](https://discourse.nodered.org/t/cheap-server-options/10131)

<div class="topic-metadata">

**Author:** [@paulohlp](https://discourse.nodered.org/u/paulohlp)\
**Replies:** 9\
**Last updated:** [16 March 2021 03:32 UTC](https://discourse.nodered.org/t/cheap-server-options/10131 "2021-03-16T03:32:09Z")

</div>

Hi, guys. I´m pretty new to node-red and I´m loving it. So far I tested it on IBM Cloud, Fred and Heroku. IBM after a brief time stopped working twice, Fred I did not like it. Heroku is great and I think the price is f…

---

## [Node-Red v1.2.7 Crashing](https://discourse.nodered.org/t/node-red-v1-2-7-crashing/41649)

<div class="topic-metadata">

**Author:** [@Curious](https://discourse.nodered.org/u/Curious)\
**Replies:** 10\
**Last updated:** [15 March 2021 22:11 UTC](https://discourse.nodered.org/t/node-red-v1-2-7-crashing/41649 "2021-03-15T22:11:31Z")

</div>

Hi, I have been using node-red v1.X (don’t remember the exact version) for well over a year. Everything has been extremely stable – no crashes. About 1 one month ago, I upgraded to node-red v1.2.7. Shortly after, I als…

---

## [No Project in Node-RED](https://discourse.nodered.org/t/no-project-in-node-red/11203)

<div class="topic-metadata">

**Author:** [@sajidb](https://discourse.nodered.org/u/sajidb)\
**Replies:** 9\
**Last updated:** [15 March 2021 18:12 UTC](https://discourse.nodered.org/t/no-project-in-node-red/11203 "2021-03-15T18:12:12Z")

</div>

I have followed the steps mentioned in this link enabling the project in settings.js: https://nodered.org/docs/user-guide/projects/ But there is no dialogue box coming for project neither can I find the option in Node-…

---

## [Q: Insert images into body of email?](https://discourse.nodered.org/t/q-insert-images-into-body-of-email/42682)

<div class="topic-metadata">

**Author:** [@daxliniere](https://discourse.nodered.org/u/daxliniere)\
**Replies:** 2\
**Last updated:** [15 March 2021 19:25 UTC](https://discourse.nodered.org/t/q-insert-images-into-body-of-email/42682 "2021-03-15T19:25:05Z")

</div>

Hey team, I have a flow that attaches 3 jpg images to an email. I would much prefer those images were inserted into the message body. (code included below) How would I go about changing that, please? Thank you in adva…

---

## [Google, node-red-contrib-googlehome set level](https://discourse.nodered.org/t/google-node-red-contrib-googlehome-set-level/42620)

<div class="topic-metadata">

**Author:** [@bce](https://discourse.nodered.org/u/bce)\
**Replies:** 8\
**Last updated:** [15 March 2021 16:51 UTC](https://discourse.nodered.org/t/google-node-red-contrib-googlehome-set-level/42620 "2021-03-15T16:51:45Z")

</div>

Good afternoon. I try to create via node-red-contrib-googlehome, Level set function for domoticz. For this I created an account with \[Node-RED Google Assistant Bridge. I added it to my google home, and added a device. …

---

## [Split Payload object, Fixed length of 1 Array not working](https://discourse.nodered.org/t/split-payload-object-fixed-length-of-1-array-not-working/42669)

<div class="topic-metadata">

**Author:** [@tomstud](https://discourse.nodered.org/u/tomstud)\
**Replies:** 4\
**Last updated:** [15 March 2021 15:07 UTC](https://discourse.nodered.org/t/split-payload-object-fixed-length-of-1-array-not-working/42669 "2021-03-15T15:07:44Z")

</div>

Hey Guys, I'm using a split node which gets injected with an array with 3 objects in the array. When I try to use the split node to split the array into an individual array so 1 object. I set the Fixed length of 1 on th…

---

## [Catch node reporting node id](https://discourse.nodered.org/t/catch-node-reporting-node-id/42671)

<div class="topic-metadata">

**Author:** [@fmarzocca](https://discourse.nodered.org/u/fmarzocca)\
**Replies:** 2\
**Last updated:** [15 March 2021 14:42 UTC](https://discourse.nodered.org/t/catch-node-reporting-node-id/42671 "2021-03-15T14:42:40Z")

</div>

I have setup a catch node in a subflow, pointing it to a tcp request node and triggering an email. I have received this email: {"message":"connect failed 10.0.0.131:20000","source":{"id":"76efa99e.66f788","type":"tcp r…

---

## [Splitting array - from MySQL query](https://discourse.nodered.org/t/splitting-array-from-mysql-query/42279)

<div class="topic-metadata">

**Author:** [@ScheepersJohan](https://discourse.nodered.org/u/ScheepersJohan)\
**Replies:** 35\
**Last updated:** [15 March 2021 13:33 UTC](https://discourse.nodered.org/t/splitting-array-from-mysql-query/42279 "2021-03-15T13:33:01Z")

</div>

I run a query on MySQL db and I want split array into separate msg \[{"id":"29b47fe9.8b692","type":"mysql","z":"33901399.5a63bc","mydb":"37f92788.1e2638","name":"soiot 2","x":830,"y":580,"wires":\[\["f2e8ef67.77d44","aa3…

---

## [Unable to use Telnet on Raspberry Pi](https://discourse.nodered.org/t/unable-to-use-telnet-on-raspberry-pi/42224)

<div class="topic-metadata">

**Author:** [@steezywee](https://discourse.nodered.org/u/steezywee)\
**Replies:** 3\
**Last updated:** [15 March 2021 13:20 UTC](https://discourse.nodered.org/t/unable-to-use-telnet-on-raspberry-pi/42224 "2021-03-15T13:20:29Z")

</div>

Hi everyone, I've got node red fired up on my raspberry pi and for the life of me I cannot get Telnet to work through NodeRed. Here is what I'm trying to do with telnet: I have an audio DSP that I want to control throu…

---

## [Get and show timestamp of last flow saving](https://discourse.nodered.org/t/get-and-show-timestamp-of-last-flow-saving/42627)

<div class="topic-metadata">

**Author:** [@Moosbueffel](https://discourse.nodered.org/u/Moosbueffel)\
**Replies:** 7\
**Last updated:** [15 March 2021 12:49 UTC](https://discourse.nodered.org/t/get-and-show-timestamp-of-last-flow-saving/42627 "2021-03-15T12:49:20Z")

</div>

Perhaps a little bit unusal, but I want to show the timestamp of last saving in my flow. Currently I have a comment field like this: But it's not done automatically, so I often forget to actualize it. The version chan…

---

## [Switch on RowDataPacket contents](https://discourse.nodered.org/t/switch-on-rowdatapacket-contents/42663)

<div class="topic-metadata">

**Author:** [@jaguar](https://discourse.nodered.org/u/jaguar)\
**Replies:** 4\
**Last updated:** [15 March 2021 12:01 UTC](https://discourse.nodered.org/t/switch-on-rowdatapacket-contents/42663 "2021-03-15T12:01:44Z")

</div>

Struggling to understand how to use a switch node to switch based on the content of a RowDataPacket returned from a SQL Select in a Function Node. The output from the SQL Select is always a single name / value object \[…

---

## [Github automation](https://discourse.nodered.org/t/github-automation/42392)

<div class="topic-metadata">

**Author:** [@CuriousUser](https://discourse.nodered.org/u/CuriousUser)\
**Replies:** 4\
**Last updated:** [15 March 2021 10:11 UTC](https://discourse.nodered.org/t/github-automation/42392 "2021-03-15T10:11:43Z")

</div>

Hello, I know there is a "Projects" feature in Node-Red for linking and cloning repositories from Github. My question is: Is it possible to automate cloning process via standard commands used in terminal to do those ope…

---

## [Transfer of PDF file from node-red to some remote machine via API](https://discourse.nodered.org/t/transfer-of-pdf-file-from-node-red-to-some-remote-machine-via-api/42534)

<div class="topic-metadata">

**Author:** [@Sudthakur](https://discourse.nodered.org/u/Sudthakur)\
**Replies:** 4\
**Last updated:** [15 March 2021 09:09 UTC](https://discourse.nodered.org/t/transfer-of-pdf-file-from-node-red-to-some-remote-machine-via-api/42534 "2021-03-15T09:09:11Z")

</div>

Hi All, Can anyone help me how to start with the below two requirement. that how to transfer a pdf file to some remote server/machine via API. The customer can send Prepress PDF-Package File via API to a machine The c…

---

## [Node Red Connection Errors after safe start](https://discourse.nodered.org/t/node-red-connection-errors-after-safe-start/42651)

<div class="topic-metadata">

**Author:** [@Maxdingus](https://discourse.nodered.org/u/Maxdingus)\
**Replies:** 2\
**Last updated:** [15 March 2021 09:05 UTC](https://discourse.nodered.org/t/node-red-connection-errors-after-safe-start/42651 "2021-03-15T09:05:40Z")

</div>

I've been trying to troubleshoot this experience all day with my pi and node-red. I understand that the credential secret option is totally useless right now but I don't understand any of the other errors. Whenever I fir…

---

## [Value Decision per month based on battery SOC](https://discourse.nodered.org/t/value-decision-per-month-based-on-battery-soc/42593)

<div class="topic-metadata">

**Author:** [@Herbert](https://discourse.nodered.org/u/Herbert)\
**Replies:** 4\
**Last updated:** [15 March 2021 08:58 UTC](https://discourse.nodered.org/t/value-decision-per-month-based-on-battery-soc/42593 "2021-03-15T08:58:15Z")

</div>

Hello and thanks for the wonderful program. I´m good at SPS programming and very new in Nodered, so I need little help for my ToDo. My plan is: My photovoltaik system have a battery and the MQTT values comes and goes t…

---

## [Where do I find the html code of info tab and (+) icon in code base](https://discourse.nodered.org/t/where-do-i-find-the-html-code-of-info-tab-and-icon-in-code-base/42656)

<div class="topic-metadata">

**Author:** [@Syedabd](https://discourse.nodered.org/u/Syedabd)\
**Replies:** 0\
**Last updated:** [15 March 2021 08:10 UTC](https://discourse.nodered.org/t/where-do-i-find-the-html-code-of-info-tab-and-icon-in-code-base/42656 "2021-03-15T08:10:40Z")

</div>

Hi, Can anyone help me out with this? Where do I find the info tab and (+) icon in code base as attached in the screenshot below for reference

---

## [Get time matching ui\_date\_picker](https://discourse.nodered.org/t/get-time-matching-ui-date-picker/42601)

<div class="topic-metadata">

**Author:** [@Rufus](https://discourse.nodered.org/u/Rufus)\
**Replies:** 9\
**Last updated:** [14 March 2021 22:20 UTC](https://discourse.nodered.org/t/get-time-matching-ui-date-picker/42601 "2021-03-14T22:20:08Z")

</div>

Hi I am trying to store some data alongside the date without the hours (in milliseconds). I want just the date (without the hour) to match the value given by the ui\_date\_picker. I am a beginner, it can be just simple…

---

## [Using 'exec' node without sudo](https://discourse.nodered.org/t/using-exec-node-without-sudo/42595)

<div class="topic-metadata">

**Author:** [@WhatDoor](https://discourse.nodered.org/u/WhatDoor)\
**Replies:** 21\
**Last updated:** [14 March 2021 22:11 UTC](https://discourse.nodered.org/t/using-exec-node-without-sudo/42595 "2021-03-14T22:11:28Z")

</div>

Hi everyone, I am trying to use playerctl through the exec node, but the commands are returning an error: Command failed: playerctl pause Could not connect to players: Cannot autolaunch D-Bus without X11 $DISPLAY I su…

---

## [Use external value for BACnet write node?](https://discourse.nodered.org/t/use-external-value-for-bacnet-write-node/42469)

<div class="topic-metadata">

**Author:** [@Graves](https://discourse.nodered.org/u/Graves)\
**Replies:** 2\
**Last updated:** [14 March 2021 22:00 UTC](https://discourse.nodered.org/t/use-external-value-for-bacnet-write-node/42469 "2021-03-14T22:00:23Z")

</div>

I have been using the node-red-contrib-bacnet library and everything is working perfectly, I can read and write values to my BACnet controller without an issue. I do have one problem though, I cant figure out how to use …

---

## [Dashboard main menu (on dashboard page) is invisible and side menu too!](https://discourse.nodered.org/t/dashboard-main-menu-on-dashboard-page-is-invisible-and-side-menu-too/42637)

<div class="topic-metadata">

**Author:** [@TonyKybkalo](https://discourse.nodered.org/u/TonyKybkalo)\
**Replies:** 0\
**Last updated:** [14 March 2021 19:17 UTC](https://discourse.nodered.org/t/dashboard-main-menu-on-dashboard-page-is-invisible-and-side-menu-too/42637 "2021-03-14T19:17:12Z")

</div>

Hello everyone, I have Node-RED (version 1.2.9) and there is installed Node-RED Dashboard (node-red-dashboard - version 2.28.1). I want to see main dashboard menu (in the top left corner). I think I have set everythin…

---

## [Raspberry Pi3, GrovePi+ board, Grove - I2C Hub and two sensors](https://discourse.nodered.org/t/raspberry-pi3-grovepi-board-grove-i2c-hub-and-two-sensors/42633)

<div class="topic-metadata">

**Author:** [@TonyKybkalo](https://discourse.nodered.org/u/TonyKybkalo)\
**Replies:** 0\
**Last updated:** [14 March 2021 18:56 UTC](https://discourse.nodered.org/t/raspberry-pi3-grovepi-board-grove-i2c-hub-and-two-sensors/42633 "2021-03-14T18:56:07Z")

</div>

Hello everyone, I have (maybe stupid) question: I have Raspberry Pi3, GrovePi+ board, Grove - I2C Hub and two sensors. GrovePi+ board is connected to Raspberry Pi3. Grove - I2C Hub is connected to GrovePi+ board via …

---

## [How to store and fetch data from CouchDB with user password](https://discourse.nodered.org/t/how-to-store-and-fetch-data-from-couchdb-with-user-password/42611)

<div class="topic-metadata">

**Author:** [@riker65](https://discourse.nodered.org/u/riker65)\
**Replies:** 5\
**Last updated:** [14 March 2021 17:25 UTC](https://discourse.nodered.org/t/how-to-store-and-fetch-data-from-couchdb-with-user-password/42611 "2021-03-14T17:25:08Z")

</div>

Hi was looking into the forum but did not find a documentation fetching data from couchdb. Anyone having a goog example / tutorial ? Thanks T

---

## [TCP request node](https://discourse.nodered.org/t/tcp-request-node/42624)

<div class="topic-metadata">

**Author:** [@fmarzocca](https://discourse.nodered.org/u/fmarzocca)\
**Replies:** 4\
**Last updated:** [14 March 2021 17:22 UTC](https://discourse.nodered.org/t/tcp-request-node/42624 "2021-03-14T17:22:13Z")

</div>

I am using a TCP request node to keep connection open with one of my servers. This morning I had to perform maintenance on the network and I have switched off the server (so the IP was no more reachable). The TCP request…

---

## [HTTP endpoint for image payloads](https://discourse.nodered.org/t/http-endpoint-for-image-payloads/42598)

<div class="topic-metadata">

**Author:** [@thejollypop](https://discourse.nodered.org/u/thejollypop)\
**Replies:** 4\
**Last updated:** [14 March 2021 17:04 UTC](https://discourse.nodered.org/t/http-endpoint-for-image-payloads/42598 "2021-03-14T17:04:43Z")

</div>

Hi All, Sorry if this came up already, I've searched thoroughly :slight\_smile: I'm trying to get the image buffer payload in the debug node, from a template node ("image"). I'm using the "get (form)-\>post" method below…

---

## [Date of debug node in side bar](https://discourse.nodered.org/t/date-of-debug-node-in-side-bar/42560)

<div class="topic-metadata">

**Author:** [@FatPilot](https://discourse.nodered.org/u/FatPilot)\
**Replies:** 3\
**Last updated:** [14 March 2021 16:41 UTC](https://discourse.nodered.org/t/date-of-debug-node-in-side-bar/42560 "2021-03-14T16:41:54Z")

</div>

Hi everyone, Not ever so important but I've just noticed the date format of the debug message mm/dd/yyyy (3/12/2021). Can this be changed? I would like dd/mm/yyyy, can't find any settings to change. Asking for a frien…

---

## [Node red to mysql](https://discourse.nodered.org/t/node-red-to-mysql/42615)

<div class="topic-metadata">

**Author:** [@Automationman](https://discourse.nodered.org/u/Automationman)\
**Replies:** 2\
**Last updated:** [14 March 2021 15:52 UTC](https://discourse.nodered.org/t/node-red-to-mysql/42615 "2021-03-14T15:52:51Z")

</div>

Can any help as I am new to node red, I wish to send a numerical value(analog) from a adam6717 unit to be stored on mysql, I've got the mysql working and the analog output working so just need help with a function node t…

---

## [Can we send a Poll on Telegram using the node-red-contrib-telegrambot pallete?](https://discourse.nodered.org/t/can-we-send-a-poll-on-telegram-using-the-node-red-contrib-telegrambot-pallete/42621)

<div class="topic-metadata">

**Author:** [@Kushal](https://discourse.nodered.org/u/Kushal)\
**Replies:** 1\
**Last updated:** [14 March 2021 14:33 UTC](https://discourse.nodered.org/t/can-we-send-a-poll-on-telegram-using-the-node-red-contrib-telegrambot-pallete/42621 "2021-03-14T14:33:15Z")

</div>

For sending simple messages, I assign msg.payload.content ; type ; chatid properties. Now i am exploring whether we can send Polls using Node Red. Problem 1 - I tried to read the telegram bot documentation and I tried o…

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

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