# General

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

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

**Page:** 681

---

## [How to convert an array to a text - NodeRED read from MySQL to be sent to Telegram](https://discourse.nodered.org/t/how-to-convert-an-array-to-a-text-nodered-read-from-mysql-to-be-sent-to-telegram/33102)

<div class="topic-metadata">

**Author:** [@CesarLeiton](https://discourse.nodered.org/u/CesarLeiton)\
**Replies:** 22\
**Last updated:** [22 September 2020 18:38 UTC](https://discourse.nodered.org/t/how-to-convert-an-array-to-a-text-nodered-read-from-mysql-to-be-sent-to-telegram/33102 "2020-09-22T18:38:43Z")

</div>

Hello, I am trying to send information read from MySQL tables to telegram. For doing that I want to convert an array (or part of the array) to text in order to be able to send it to a Telegram chat. This is the flow …

---

## [Unifi node getting object Object error](https://discourse.nodered.org/t/unifi-node-getting-object-object-error/33185)

<div class="topic-metadata">

**Author:** [@eibyer\_nr](https://discourse.nodered.org/u/eibyer_nr)\
**Replies:** 2\
**Last updated:** [22 September 2020 17:43 UTC](https://discourse.nodered.org/t/unifi-node-getting-object-object-error/33185 "2020-09-22T17:43:10Z")

</div>

I'm trying to use the Unifi node on a simple flow for now but I'm getting the object Object message. I have a very old version of the node on another machine and it works. Newest version 0.1.15 This is from the old…

---

## [How to create enum global](https://discourse.nodered.org/t/how-to-create-enum-global/33186)

<div class="topic-metadata">

**Author:** [@minhhn0205](https://discourse.nodered.org/u/minhhn0205)\
**Replies:** 1\
**Last updated:** [22 September 2020 17:21 UTC](https://discourse.nodered.org/t/how-to-create-enum-global/33186 "2020-09-22T17:21:19Z")

</div>

Hi, I am new to node-Red so I do not know if there is an enum in Node-Red? If has, can I set it to enum global so that multiple nodes can use it? or how does Node-Red use enum type, please suggest for me! Thanks in a…

---

## [Issues with selenium node](https://discourse.nodered.org/t/issues-with-selenium-node/32929)

<div class="topic-metadata">

**Author:** [@RaiRoo](https://discourse.nodered.org/u/RaiRoo)\
**Replies:** 7\
**Last updated:** [22 September 2020 17:01 UTC](https://discourse.nodered.org/t/issues-with-selenium-node/32929 "2020-09-22T17:01:35Z")

</div>

Hi everybody, I am just doing my first step with selenium and the respective node. So I installed Selenium-hub and selenium-standalone-chrome in a docker container on my Synology. Installation was without any problem an…

---

## [Read large JSON file (to insert to MySQL) causes Node-RED crash due to JavaScript heap out of memory](https://discourse.nodered.org/t/read-large-json-file-to-insert-to-mysql-causes-node-red-crash-due-to-javascript-heap-out-of-memory/33149)

<div class="topic-metadata">

**Author:** [@thebaldgeek](https://discourse.nodered.org/u/thebaldgeek)\
**Replies:** 10\
**Last updated:** [21 September 2020 17:34 UTC](https://discourse.nodered.org/t/read-large-json-file-to-insert-to-mysql-causes-node-red-crash-due-to-javascript-heap-out-of-memory/33149 "2020-09-21T17:34:03Z")

</div>

I have been at this for a solid 7-9 hours, so will try and keep it brief.... The big picture. I have a 27.3 Mb JSON formatted file that I need to take each key and its data and insert into a MySQL database. The data r…

---

## [How to use firebase node?](https://discourse.nodered.org/t/how-to-use-firebase-node/33187)

<div class="topic-metadata">

**Author:** [@alex1](https://discourse.nodered.org/u/alex1)\
**Replies:** 0\
**Last updated:** [22 September 2020 15:53 UTC](https://discourse.nodered.org/t/how-to-use-firebase-node/33187 "2020-09-22T15:53:59Z")

</div>

Anyone have any idea on how shall i fill up the blank?

---

## [Fs in settings.js](https://discourse.nodered.org/t/fs-in-settings-js/33183)

<div class="topic-metadata">

**Author:** [@Trocergian](https://discourse.nodered.org/u/Trocergian)\
**Replies:** 4\
**Last updated:** [22 September 2020 15:50 UTC](https://discourse.nodered.org/t/fs-in-settings-js/33183 "2020-09-22T15:50:32Z")

</div>

I am following along with a "How to.." book for a project and it is instructing me to uncomment the following line: // var fs = require("fs"); I am unable to locate this line in the file. Is this an older reference th…

---

## [Pi Hat for Thermocouple measurement](https://discourse.nodered.org/t/pi-hat-for-thermocouple-measurement/33037)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 3\
**Last updated:** [22 September 2020 10:04 UTC](https://discourse.nodered.org/t/pi-hat-for-thermocouple-measurement/33037 "2020-09-22T10:04:40Z")

</div>

I wish to use a Raspberry Pi for monitoring Type K thermocouples. One device I found for this is a Pi Hat made by Measurement Computing. I asked them about support for Node-RED and they said they never heard of that. …

---

## [To control neopixels with only Arduino](https://discourse.nodered.org/t/to-control-neopixels-with-only-arduino/33168)

<div class="topic-metadata">

**Author:** [@seyeon](https://discourse.nodered.org/u/seyeon)\
**Replies:** 4\
**Last updated:** [22 September 2020 09:46 UTC](https://discourse.nodered.org/t/to-control-neopixels-with-only-arduino/33168 "2020-09-22T09:46:06Z")

</div>

Dear node-red masters, I want to sort only the object values of the msg.payload. ( like screen shot ) I don't know how to do it. Do I have to write a json code? \[{"id":"a52d7073.b50de","type":"inject","z":"7a686238…

---

## [Persistence after crashing](https://discourse.nodered.org/t/persistence-after-crashing/10279)

<div class="topic-metadata">

**Author:** [@georgehanson](https://discourse.nodered.org/u/georgehanson)\
**Replies:** 15\
**Last updated:** [22 September 2020 07:35 UTC](https://discourse.nodered.org/t/persistence-after-crashing/10279 "2020-09-22T07:35:09Z")

</div>

Hi there, I have been looking around but unable to find an answer to this. Is there a way for the state of a flow to be persisted? For example, I have created a flow that accepts an HTTP request and returns a response.…

---

## [Npm fails to install new node](https://discourse.nodered.org/t/npm-fails-to-install-new-node/33158)

<div class="topic-metadata">

**Author:** [@thePLCguy](https://discourse.nodered.org/u/thePLCguy)\
**Replies:** 4\
**Last updated:** [22 September 2020 06:40 UTC](https://discourse.nodered.org/t/npm-fails-to-install-new-node/33158 "2020-09-22T06:40:29Z")

</div>

Hi guys, relatively new to Node Red. Actually I am using it as a teaching aid for my automation class here in New Zealand. We have enjoyed the limited time using Node Red thus far, but I have a small problem I hope you …

---

## [Sir ,I want to copy 2 msg.id in my sql DB](https://discourse.nodered.org/t/sir-i-want-to-copy-2-msg-id-in-my-sql-db/32912)

<div class="topic-metadata">

**Author:** [@shipra](https://discourse.nodered.org/u/shipra)\
**Replies:** 107\
**Last updated:** [22 September 2020 05:49 UTC](https://discourse.nodered.org/t/sir-i-want-to-copy-2-msg-id-in-my-sql-db/32912 "2020-09-22T05:49:29Z")

</div>

Sir I want payload and payload 1 (which are 04222436 and 2814 respectively.) check screenshots But i am getting output something like this check DB please help

---

## [How to catch error of Zip node](https://discourse.nodered.org/t/how-to-catch-error-of-zip-node/33098)

<div class="topic-metadata">

**Author:** [@minhhn0205](https://discourse.nodered.org/u/minhhn0205)\
**Replies:** 8\
**Last updated:** [22 September 2020 01:45 UTC](https://discourse.nodered.org/t/how-to-catch-error-of-zip-node/33098 "2020-09-22T01:45:48Z")

</div>

I use a zip node to extract the zip file, in case the decompression fails, zip node will output an error "Error parsing zip file: Error: Can't find end of central directory : is this a zip file ? If it is, see https://st…

---

## [Send Failure for email node](https://discourse.nodered.org/t/send-failure-for-email-node/33156)

<div class="topic-metadata">

**Author:** [@jnbest00](https://discourse.nodered.org/u/jnbest00)\
**Replies:** 0\
**Last updated:** [21 September 2020 21:59 UTC](https://discourse.nodered.org/t/send-failure-for-email-node/33156 "2020-09-21T21:59:23Z")

</div>

I'm trying to send LoRa data collected to myself via the node-red-email node but I keep getting a send failure message, I tried turning on "allow less secure apps" in my google security settings as a solution but was met…

---

## [Alexa-remote2 and device groups](https://discourse.nodered.org/t/alexa-remote2-and-device-groups/33155)

<div class="topic-metadata">

**Author:** [@mterry63](https://discourse.nodered.org/u/mterry63)\
**Replies:** 0\
**Last updated:** [21 September 2020 21:39 UTC](https://discourse.nodered.org/t/alexa-remote2-and-device-groups/33155 "2020-09-21T21:39:50Z")

</div>

I've been using remote2 for my home automation announcements for some time, but now starting to look into using alexa to trigger events. My initial debug testing provides debug output when I send TTS to a single device, …

---

## [Import of multiple flows, causes MQTT to oscillate between connected and disconnected state](https://discourse.nodered.org/t/import-of-multiple-flows-causes-mqtt-to-oscillate-between-connected-and-disconnected-state/33130)

<div class="topic-metadata">

**Author:** [@freds](https://discourse.nodered.org/u/freds)\
**Replies:** 6\
**Last updated:** [21 September 2020 20:47 UTC](https://discourse.nodered.org/t/import-of-multiple-flows-causes-mqtt-to-oscillate-between-connected-and-disconnected-state/33130 "2020-09-21T20:47:49Z")

</div>

I was developing a solution with multiple flows (eleven) on a Raspberry Pi 4 and reached a point with the visual editor was going out to lunch for extended periods of time. So I restarted node red in safe mode and export…

---

## [Multiple outputs](https://discourse.nodered.org/t/multiple-outputs/33153)

<div class="topic-metadata">

**Author:** [@bmoel](https://discourse.nodered.org/u/bmoel)\
**Replies:** 4\
**Last updated:** [21 September 2020 20:33 UTC](https://discourse.nodered.org/t/multiple-outputs/33153 "2020-09-21T20:33:07Z")

</div>

I'm trying to get the ModBus flexwriter to work, but I am getting unreliable results using multiple function nodes as input the Flexwriter node. Seems I cant trust in which order the different node sends to the flexwrite…

---

## [Node-red V1.1.3 Windows10](https://discourse.nodered.org/t/node-red-v1-1-3-windows10/33151)

<div class="topic-metadata">

**Author:** [@ShanmugaCA](https://discourse.nodered.org/u/ShanmugaCA)\
**Replies:** 1\
**Last updated:** [21 September 2020 20:13 UTC](https://discourse.nodered.org/t/node-red-v1-1-3-windows10/33151 "2020-09-21T20:13:38Z")

</div>

Hello! Have installed the node-red-contrib-firebase and the node-red version 1.1.3 exits automatically. I tried the safe mode node-red --safe and that too exists, and no errors displayed. Any help? thanks much best …

---

## [Well, that odd npm issue is back!](https://discourse.nodered.org/t/well-that-odd-npm-issue-is-back/30569)

<div class="topic-metadata">

**Author:** [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)\
**Replies:** 23\
**Last updated:** [21 September 2020 20:06 UTC](https://discourse.nodered.org/t/well-that-odd-npm-issue-is-back/30569 "2020-09-21T20:06:33Z")

</div>

Well, that odd npm issue is back! I just tried to mass load modules via the npm cli via the script I wrote, that has been working fine for a while, until that it. On a refresh NR install, after removing NR, node.js, an…

---

## [NR Grafana API keys](https://discourse.nodered.org/t/nr-grafana-api-keys/33045)

<div class="topic-metadata">

**Author:** [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Replies:** 7\
**Last updated:** [21 September 2020 18:00 UTC](https://discourse.nodered.org/t/nr-grafana-api-keys/33045 "2020-09-21T18:00:07Z")

</div>

Hi. I Was wondering can we use Grafana API keys, to secure the InfluxDB using NR? Is it possible to do something like this, but with NR?

---

## [Change Time Format string value](https://discourse.nodered.org/t/change-time-format-string-value/33146)

<div class="topic-metadata">

**Author:** [@Ward](https://discourse.nodered.org/u/Ward)\
**Replies:** 10\
**Last updated:** [21 September 2020 17:05 UTC](https://discourse.nodered.org/t/change-time-format-string-value/33146 "2020-09-21T17:05:38Z")

</div>

Hi, Little background. I wrote a flow where i store all the alarms in a csv file. And every time the csv file is updated i read the new alarms and write only those to InfluxDB. Everything works except, i want to use the…

---

## [How to refresh my sqlite 3 database through node red](https://discourse.nodered.org/t/how-to-refresh-my-sqlite-3-database-through-node-red/33133)

<div class="topic-metadata">

**Author:** [@shipra](https://discourse.nodered.org/u/shipra)\
**Replies:** 40\
**Last updated:** [21 September 2020 14:51 UTC](https://discourse.nodered.org/t/how-to-refresh-my-sqlite-3-database-through-node-red/33133 "2020-09-21T14:51:49Z")

</div>

Sir, I am doing a code in which user choice I am taking ,So if user wants to refresh it Database just by entering any input that input I am taking on MQTT pub node and then that pub node should trigger my Refresh Functio…

---

## [Converting SQLite Query to a CSV File](https://discourse.nodered.org/t/converting-sqlite-query-to-a-csv-file/1937)

<div class="topic-metadata">

**Author:** [@zacharyalan09](https://discourse.nodered.org/u/zacharyalan09)\
**Replies:** 7\
**Last updated:** [21 September 2020 14:13 UTC](https://discourse.nodered.org/t/converting-sqlite-query-to-a-csv-file/1937 "2020-09-21T14:13:45Z")

</div>

Hello! Quick question, I'm hoping you folks can help me out with. I've created an SQLite database to store time-based data about my system and want to create and export a .csv file of specific queries on demand. So far…

---

## [Use FFmpeg to convert RSTP stream to MP4](https://discourse.nodered.org/t/use-ffmpeg-to-convert-rstp-stream-to-mp4/32883)

<div class="topic-metadata">

**Author:** [@nygma2004](https://discourse.nodered.org/u/nygma2004)\
**Replies:** 45\
**Last updated:** [21 September 2020 11:54 UTC](https://discourse.nodered.org/t/use-ffmpeg-to-convert-rstp-stream-to-mp4/32883 "2020-09-21T11:54:24Z")

</div>

Hi All, There has been some discussion on the forum how to use FFmpeg to convert the RSTP IP Camera feed to MP4. Recently, I tried doing the same with my Reolink cameras and I used the same command that has worked fine…

---

## [Inject or Triggers at specific time](https://discourse.nodered.org/t/inject-or-triggers-at-specific-time/33135)

<div class="topic-metadata">

**Author:** [@Henjoe](https://discourse.nodered.org/u/Henjoe)\
**Replies:** 4\
**Last updated:** [21 September 2020 10:40 UTC](https://discourse.nodered.org/t/inject-or-triggers-at-specific-time/33135 "2020-09-21T10:40:01Z")

</div>

Dear Node-red experts, I want to trigger my functions or node at specific time, to be exactly, I need to computer something at every HOUR and every DAY. If time is at \[00:00:00, 01:00:00,02:00:00 and so on and so forth…

---

## [Parsing array of objects](https://discourse.nodered.org/t/parsing-array-of-objects/33126)

<div class="topic-metadata">

**Author:** [@Paul-Reed](https://discourse.nodered.org/u/Paul-Reed)\
**Replies:** 6\
**Last updated:** [21 September 2020 09:56 UTC](https://discourse.nodered.org/t/parsing-array-of-objects/33126 "2020-09-21T09:56:41Z")

</div>

Anyone help with extracting data from an array of objects. { "length":6792, "data":\[ { "fruit":"Apples", "id":32827, "sales":\[ { "week":5, …

---

## [Tips on streamlining this function](https://discourse.nodered.org/t/tips-on-streamlining-this-function/33092)

<div class="topic-metadata">

**Author:** [@877](https://discourse.nodered.org/u/877)\
**Replies:** 21\
**Last updated:** [21 September 2020 09:47 UTC](https://discourse.nodered.org/t/tips-on-streamlining-this-function/33092 "2020-09-21T09:47:44Z")

</div>

Hello all, I have written a function node which works, but I think there must be a clever way of doing it, rather than individual IF/ELSE statements. Here is the flow, simply mqtt json data going through the function n…

---

## [Send an email and include the current IP address](https://discourse.nodered.org/t/send-an-email-and-include-the-current-ip-address/33091)

<div class="topic-metadata">

**Author:** [@volker1078](https://discourse.nodered.org/u/volker1078)\
**Replies:** 12\
**Last updated:** [21 September 2020 09:01 UTC](https://discourse.nodered.org/t/send-an-email-and-include-the-current-ip-address/33091 "2020-09-21T09:01:57Z")

</div>

Hello, I have built in an email alert in Node Red that if a certain value is exceeded I get a mial. Now I would like to transfer my IP address so that when the mail arrives I just have to click on a link with the IP and…

---

## [Ascii string to hex](https://discourse.nodered.org/t/ascii-string-to-hex/33138)

<div class="topic-metadata">

**Author:** [@goc333](https://discourse.nodered.org/u/goc333)\
**Replies:** 1\
**Last updated:** [21 September 2020 08:44 UTC](https://discourse.nodered.org/t/ascii-string-to-hex/33138 "2020-09-21T08:44:19Z")

</div>

Hello everyone, I have some data in database that I need to sand on mqtt. My data looks like this : 50C0E54373C3B68 First thing I need to do is converting this string to hex to look like this: 0x50 0xC0 0xE0... I tr…

---

## [Searching an audio player (+flow) for streams / local files](https://discourse.nodered.org/t/searching-an-audio-player-flow-for-streams-local-files/18714)

<div class="topic-metadata">

**Author:** [@WhiteLion](https://discourse.nodered.org/u/WhiteLion)\
**Replies:** 7\
**Last updated:** [3 December 2019 15:03 UTC](https://discourse.nodered.org/t/searching-an-audio-player-flow-for-streams-local-files/18714 "2019-12-03T15:03:41Z")

</div>

Hiho, I ve a view audio related questions: Is there a way to fast-foward / rewind a mp3 song while playing with PlaySound node? How to play .m3u playlists / streams ? I could manage to extract the steam url from .m3u…

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

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