# General

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

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

**Page:** 356

---

## [Multiple OPCUA Items into SQL Database](https://discourse.nodered.org/t/multiple-opcua-items-into-sql-database/64674)

<div class="topic-metadata">

**Author:** [@madlen21](https://discourse.nodered.org/u/madlen21)\
**Replies:** 1\
**Last updated:** [5 July 2022 06:20 UTC](https://discourse.nodered.org/t/multiple-opcua-items-into-sql-database/64674 "2022-07-05T06:20:46Z")

</div>

Hey, I created different OPCU-Items to read Values from my PLC and store them in an Microsoft SQL Database. If I use only one Item, read it with the OPCUA Client an write it to the Database with MSSQL-PLUS, everything i…

---

## [How do I extract values from a JSON string?](https://discourse.nodered.org/t/how-do-i-extract-values-from-a-json-string/64521)

<div class="topic-metadata">

**Author:** [@amit\_meld](https://discourse.nodered.org/u/amit_meld)\
**Replies:** 14\
**Last updated:** [5 July 2022 02:09 UTC](https://discourse.nodered.org/t/how-do-i-extract-values-from-a-json-string/64521 "2022-07-05T02:09:45Z")

</div>

Hello, I am trying to push data to a data platform from a people counting sensor. I am receiving below JSON response from the API. I want to push Incount and outcount seperately to the data platform pool. I have set na…

---

## [Node-Red can neither be installed, started, nor uninstalled](https://discourse.nodered.org/t/node-red-can-neither-be-installed-started-nor-uninstalled/64692)

<div class="topic-metadata">

**Author:** [@Gawan](https://discourse.nodered.org/u/Gawan)\
**Replies:** 1\
**Last updated:** [4 July 2022 20:26 UTC](https://discourse.nodered.org/t/node-red-can-neither-be-installed-started-nor-uninstalled/64692 "2022-07-04T20:26:37Z")

</div>

Hi there, I tried to install node-red on my Raspi 3+B (with an older version of raspian) using this link: https://nodered.org/docs/getting-started/raspberrypi First it looked fine, but when I tried to start it, I got …

---

## [Time series database](https://discourse.nodered.org/t/time-series-database/64680)

<div class="topic-metadata">

**Author:** [@cjrawlins](https://discourse.nodered.org/u/cjrawlins)\
**Replies:** 5\
**Last updated:** [4 July 2022 18:43 UTC](https://discourse.nodered.org/t/time-series-database/64680 "2022-07-04T18:43:16Z")

</div>

Hi All, I am looking for some suggestions. Have any of you set up a Node-red server and stored the incoming data in a time series database? If so, which db have you found works best and is easy to use? Thanks in adva…

---

## [How many Switch nodes are way too many?](https://discourse.nodered.org/t/how-many-switch-nodes-are-way-too-many/64597)

<div class="topic-metadata">

**Author:** [@carvi21](https://discourse.nodered.org/u/carvi21)\
**Replies:** 3\
**Last updated:** [2 July 2022 00:17 UTC](https://discourse.nodered.org/t/how-many-switch-nodes-are-way-too-many/64597 "2022-07-02T00:17:27Z")

</div>

hi guys I am new to using node red and am currently in a dilemma on how to proceed with the project. It is an alarm system focused on the activation of remote panic buttons, the alert system is intended to be used with…

---

## [Send Msg Once - Monitoring Grid](https://discourse.nodered.org/t/send-msg-once-monitoring-grid/64669)

<div class="topic-metadata">

**Author:** [@mynoderocks](https://discourse.nodered.org/u/mynoderocks)\
**Replies:** 4\
**Last updated:** [4 July 2022 14:42 UTC](https://discourse.nodered.org/t/send-msg-once-monitoring-grid/64669 "2022-07-04T14:42:18Z")

</div>

Hi all, I have the following use case: Monitor the Grid Voltage (in my country we busy going through Load reduction constantly). What I am trying to achieve is the following: Grid goes below 200V - Do a bunch of thin…

---

## [How to Click push button send value to mqtt](https://discourse.nodered.org/t/how-to-click-push-button-send-value-to-mqtt/64607)

<div class="topic-metadata">

**Author:** [@krowkong](https://discourse.nodered.org/u/krowkong)\
**Replies:** 2\
**Last updated:** [4 July 2022 17:06 UTC](https://discourse.nodered.org/t/how-to-click-push-button-send-value-to-mqtt/64607 "2022-07-04T17:06:02Z")

</div>

I have two problems 1.How to save temperature and humidity values ​​to a CSV file? by splitting into two files Each file provides temperature/humidity and time values. I get the values ​​from MQTT. Example CSV File n…

---

## [How to change string text to object](https://discourse.nodered.org/t/how-to-change-string-text-to-object/64681)

<div class="topic-metadata">

**Author:** [@ASMTB](https://discourse.nodered.org/u/ASMTB)\
**Replies:** 4\
**Last updated:** [4 July 2022 14:46 UTC](https://discourse.nodered.org/t/how-to-change-string-text-to-object/64681 "2022-07-04T14:46:36Z")

</div>

This is the output of my device ""timestamp":"2022-07-04T14:37:01.848Z","type":"iBeacon","mac":"AC233FAB83BA","bleName":"","ibeaconUuid":"E2C56DB5DFFB48D2B060D0F5A71096E0","ibeaconMajor":0,"ibeaconMinor":0,"rssi":-20,"i…

---

## [Read from modbus and convert 24bit to integer](https://discourse.nodered.org/t/read-from-modbus-and-convert-24bit-to-integer/64673)

<div class="topic-metadata">

**Author:** [@ketpa](https://discourse.nodered.org/u/ketpa)\
**Replies:** 0\
**Last updated:** [4 July 2022 11:31 UTC](https://discourse.nodered.org/t/read-from-modbus-and-convert-24bit-to-integer/64673 "2022-07-04T11:31:04Z")

</div>

I have ADFWeb interface and convert mbus to modbus. I have 2 variable Power and Flow as 24bit value I used buffer parser, but it have not 24bit conversion data from payload: {"data":\[4,1844,0,17352\],"buffer":\[0,4…

---

## [Node-RED setting httpNodeMiddleware question](https://discourse.nodered.org/t/node-red-setting-httpnodemiddleware-question/64668)

<div class="topic-metadata">

**Author:** [@LeungChunChiu](https://discourse.nodered.org/u/LeungChunChiu)\
**Replies:** 1\
**Last updated:** [4 July 2022 10:50 UTC](https://discourse.nodered.org/t/node-red-setting-httpnodemiddleware-question/64668 "2022-07-04T10:50:54Z")

</div>

When I have questions when using the httpNodeMiddleware , I want to reject the request and return the response when the conditions are met, how should i write! thinks!!

---

## [Using the world map in offline mode](https://discourse.nodered.org/t/using-the-world-map-in-offline-mode/64625)

<div class="topic-metadata">

**Author:** [@miladmrm](https://discourse.nodered.org/u/miladmrm)\
**Replies:** 5\
**Last updated:** [4 July 2022 08:42 UTC](https://discourse.nodered.org/t/using-the-world-map-in-offline-mode/64625 "2022-07-04T08:42:00Z")

</div>

I used node-red-contrib-web-worldmap and it's really a wonderful module, but I need to use it in offline mode. I read almost all the posts related to this topic (the main document doesn't explain it in detail either), bu…

---

## [No editor showing after 3.0.0-beta.4 upgrade](https://discourse.nodered.org/t/no-editor-showing-after-3-0-0-beta-4-upgrade/64605)

<div class="topic-metadata">

**Author:** [@podi62](https://discourse.nodered.org/u/podi62)\
**Replies:** 15\
**Last updated:** [4 July 2022 06:29 UTC](https://discourse.nodered.org/t/no-editor-showing-after-3-0-0-beta-4-upgrade/64605 "2022-07-04T06:29:28Z")

</div>

After upgrading to the latest 3.0.0-beta.4 the editor doesn't show. Just a blank page. Tried with chrome, chromium, Edge and Safari. Same result. Tried to clean the cache but nothing changed. See screenshot. Tried on OS…

---

## [Is supporting COAP?](https://discourse.nodered.org/t/is-supporting-coap/64660)

<div class="topic-metadata">

**Author:** [@silenthill](https://discourse.nodered.org/u/silenthill)\
**Replies:** 3\
**Last updated:** [4 July 2022 06:10 UTC](https://discourse.nodered.org/t/is-supporting-coap/64660 "2022-07-04T06:10:49Z")

</div>

is supporting COAP????

---

## [Anyone generating reports with NR?](https://discourse.nodered.org/t/anyone-generating-reports-with-nr/5659)

<div class="topic-metadata">

**Author:** [@seth350](https://discourse.nodered.org/u/seth350)\
**Replies:** 4\
**Last updated:** [4 July 2022 05:47 UTC](https://discourse.nodered.org/t/anyone-generating-reports-with-nr/5659 "2022-07-04T05:47:36Z")

</div>

Just recently given the request to email a report of values everyday saved in MSSQL. I feel as though Node-Red could be up to this task. They would like tables and line/bar charts to be included in the report. Has anyo…

---

## [Help with setTimeout and ClearTimeout](https://discourse.nodered.org/t/help-with-settimeout-and-cleartimeout/64651)

<div class="topic-metadata">

**Author:** [@amkochaki](https://discourse.nodered.org/u/amkochaki)\
**Replies:** 9\
**Last updated:** [4 July 2022 00:07 UTC](https://discourse.nodered.org/t/help-with-settimeout-and-cleartimeout/64651 "2022-07-04T00:07:07Z")

</div>

Hey guys. I’m learning node red, I’m pretty basic in programming, but I’ve already managed to do some cool things. I’m trying to do something with my occupancy sensors I have them all over the house. I created a subflo…

---

## [Cannot start server error loading context store unexpected token u in JSON](https://discourse.nodered.org/t/cannot-start-server-error-loading-context-store-unexpected-token-u-in-json/10346)

<div class="topic-metadata">

**Author:** [@cuxcrider](https://discourse.nodered.org/u/cuxcrider)\
**Replies:** 12\
**Last updated:** [3 July 2022 20:44 UTC](https://discourse.nodered.org/t/cannot-start-server-error-loading-context-store-unexpected-token-u-in-json/10346 "2022-07-03T20:44:51Z")

</div>

Hi all, I rebooted my pi and now cannot start node-red. In case it helps, two recent nodes I added were node-red-contrib-mytimeout and node-red-contrib-stoptimer, but only mytimeout is actually in my flow. Here is the…

---

## [Scraping the web with node-red?](https://discourse.nodered.org/t/scraping-the-web-with-node-red/64613)

<div class="topic-metadata">

**Author:** [@PateJS](https://discourse.nodered.org/u/PateJS)\
**Replies:** 5\
**Last updated:** [3 July 2022 20:27 UTC](https://discourse.nodered.org/t/scraping-the-web-with-node-red/64613 "2022-07-03T20:27:25Z")

</div>

Is it possible to do advanced scraping on webpages ? Requirements: click on -\> pagination" pages and also press enter for google search. Find field -\> add text to input field (google search) Enter -\> add keywords to…

---

## [Regex and numbers](https://discourse.nodered.org/t/regex-and-numbers/64641)

<div class="topic-metadata">

**Author:** [@Inoxx](https://discourse.nodered.org/u/Inoxx)\
**Replies:** 2\
**Last updated:** [3 July 2022 18:44 UTC](https://discourse.nodered.org/t/regex-and-numbers/64641 "2022-07-03T18:44:24Z")

</div>

Hey Node-Red forum, I'm new here even thou i have been using node-red for some time now, i have never come across a specific issue that didn't have a clear answer to in this forum. But now I'm facing an small issue I ha…

---

## [Customize Excel Report](https://discourse.nodered.org/t/customize-excel-report/64645)

<div class="topic-metadata">

**Author:** [@pranavthakkar](https://discourse.nodered.org/u/pranavthakkar)\
**Replies:** 0\
**Last updated:** [3 July 2022 18:14 UTC](https://discourse.nodered.org/t/customize-excel-report/64645 "2022-07-03T18:14:44Z")

</div>

Hi There! I'm using this library tabletoExcel for my report generation in excel. But it has some limitations like If I want to add a chart or any picture on it. which is not possible. Idea is to get data from the datab…

---

## [Export From Html Table or Database to Excel file](https://discourse.nodered.org/t/export-from-html-table-or-database-to-excel-file/1122)

<div class="topic-metadata">

**Author:** [@Cristiano](https://discourse.nodered.org/u/Cristiano)\
**Replies:** 12\
**Last updated:** [3 July 2022 17:57 UTC](https://discourse.nodered.org/t/export-from-html-table-or-database-to-excel-file/1122 "2022-07-03T17:57:25Z")

</div>

Hello, I need help solving a problem. I have a table with values ​​and I wanted to export it to an excel or csv file. the table I have is generated by a query the database and then it is shown by a table built in html…

---

## [ZWave problem in communication](https://discourse.nodered.org/t/zwave-problem-in-communication/64638)

<div class="topic-metadata">

**Author:** [@MaCane](https://discourse.nodered.org/u/MaCane)\
**Replies:** 1\
**Last updated:** [3 July 2022 17:04 UTC](https://discourse.nodered.org/t/zwave-problem-in-communication/64638 "2022-07-03T17:04:04Z")

</div>

Hello, I have a problem with sending a certain temperature to the Dansfossa heads of nodered. Can someone tell me what the problem is at the CMD factory or what I am doing wrong??

---

## [Node Red 1.3.4v substring](https://discourse.nodered.org/t/node-red-1-3-4v-substring/64635)

<div class="topic-metadata">

**Author:** [@sparkys](https://discourse.nodered.org/u/sparkys)\
**Replies:** 1\
**Last updated:** [3 July 2022 15:14 UTC](https://discourse.nodered.org/t/node-red-1-3-4v-substring/64635 "2022-07-03T15:14:28Z")

</div>

I am new to Node Red I want to display data from serial port on Dashboard. The in coming data example #!1234567890123456 split into 4 substrings Substring1 = 123 Substring2 = 456 Substring3 = 78901 Substring4 = 2345…

---

## [Use Homematic smoke detector as a siren under Nodered](https://discourse.nodered.org/t/use-homematic-smoke-detector-as-a-siren-under-nodered/64629)

<div class="topic-metadata">

**Author:** [@pinie\_pinie](https://discourse.nodered.org/u/pinie_pinie)\
**Replies:** 1\
**Last updated:** [3 July 2022 12:14 UTC](https://discourse.nodered.org/t/use-homematic-smoke-detector-as-a-siren-under-nodered/64629 "2022-07-03T12:14:35Z")

</div>

Hello, I would like to use a Homematic smoke detector under Nodered/Redmatic as a siren. The system runs on RaspberryMatic. I can trigger this function using a script on the Raspberrymatic interface:(datapoints.Get("HmI…

---

## [Read-Commands InfluxDB](https://discourse.nodered.org/t/read-commands-influxdb/63518)

<div class="topic-metadata">

**Author:** [@cyrillschuerch](https://discourse.nodered.org/u/cyrillschuerch)\
**Replies:** 3\
**Last updated:** [3 July 2022 11:41 UTC](https://discourse.nodered.org/t/read-commands-influxdb/63518 "2022-07-03T11:41:20Z")

</div>

Hello Node-Red Community I wanna read the influx database. I found the following command for this. "SELECT "value" FROM Zimmer\_Temp WHERE time \>= '2022-06-03' LIMIT 1" I can run this from the command line. It also work…

---

## [Syntax JSON Function](https://discourse.nodered.org/t/syntax-json-function/64360)

<div class="topic-metadata">

**Author:** [@cyrillschuerch](https://discourse.nodered.org/u/cyrillschuerch)\
**Replies:** 3\
**Last updated:** [3 July 2022 11:26 UTC](https://discourse.nodered.org/t/syntax-json-function/64360 "2022-07-03T11:26:19Z")

</div>

Hello Guys Once again I get some problems with the function-syntax. I would like to specify the options for the dropdown node with using variable. (See photo) Can you give me a tip? Thanks a lot!

---

## [Workspace contains some nodes that are not properly configured](https://discourse.nodered.org/t/workspace-contains-some-nodes-that-are-not-properly-configured/59238)

<div class="topic-metadata">

**Author:** [@juntiedt](https://discourse.nodered.org/u/juntiedt)\
**Replies:** 21\
**Last updated:** [3 July 2022 09:07 UTC](https://discourse.nodered.org/t/workspace-contains-some-nodes-that-are-not-properly-configured/59238 "2022-07-03T09:07:38Z")

</div>

I upgrade my flows to Node-Red 2.2.2 Now I get this attached message. I cannot see any problems in the application. How can I identify the problematic nodes?

---

## [How to import json file in the V3.0.0 beta4](https://discourse.nodered.org/t/how-to-import-json-file-in-the-v3-0-0-beta4/64622)

<div class="topic-metadata">

**Author:** [@jeremylancc](https://discourse.nodered.org/u/jeremylancc)\
**Replies:** 2\
**Last updated:** [3 July 2022 08:24 UTC](https://discourse.nodered.org/t/how-to-import-json-file-in-the-v3-0-0-beta4/64622 "2022-07-03T08:24:25Z")

</div>

Though I have been used to NR upgrade to V3.0.0 beta4.But I find a problem that the following message Error : TypeError: Cannot read properties of undefined (reading '5f797f91.341cb') I don't know what happened to in t…

---

## [Scrolling buttons with multiple tabs - what's supposed to happen](https://discourse.nodered.org/t/scrolling-buttons-with-multiple-tabs-whats-supposed-to-happen/64619)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [3 July 2022 07:38 UTC](https://discourse.nodered.org/t/scrolling-buttons-with-multiple-tabs-whats-supposed-to-happen/64619 "2022-07-03T07:38:13Z")

</div>

For unknown reasons Firefox is giving me grief the past few days. Question for NR: Say I have.... 20 tabs on a machine. I am at one end of the list and want to scroll. What is supposed to happen if I press and hold t…

---

## [How to use worldmap offline in node-red](https://discourse.nodered.org/t/how-to-use-worldmap-offline-in-node-red/64090)

<div class="topic-metadata">

**Author:** [@nobody12343](https://discourse.nodered.org/u/nobody12343)\
**Replies:** 6\
**Last updated:** [3 July 2022 05:18 UTC](https://discourse.nodered.org/t/how-to-use-worldmap-offline-in-node-red/64090 "2022-07-03T05:18:33Z")

</div>

Good day, i am setting up a worldmap on node-red. I want to track paths and delete these paths after i have clicked a button. Right now, it works fine. But the current state is with a internet connection. I want to use…

---

## [Variable payload keeps still displayed on the UI even when no there's no payload](https://discourse.nodered.org/t/variable-payload-keeps-still-displayed-on-the-ui-even-when-no-theres-no-payload/64610)

<div class="topic-metadata">

**Author:** [@omardmf](https://discourse.nodered.org/u/omardmf)\
**Replies:** 1\
**Last updated:** [2 July 2022 11:51 UTC](https://discourse.nodered.org/t/variable-payload-keeps-still-displayed-on-the-ui-even-when-no-theres-no-payload/64610 "2022-07-02T11:51:01Z")

</div>

I'm using python to detect two colors "red" and "green", and display them on the node red UI in the form of a text and a led, if i detect green a text green will be written and the led is lit green, but when i terminate …

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

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