# General

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

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

**Page:** 294

---

## [How to read/write in ODBC by using node red](https://discourse.nodered.org/t/how-to-read-write-in-odbc-by-using-node-red/70648)

<div class="topic-metadata">

**Author:** [@haladriel](https://discourse.nodered.org/u/haladriel)\
**Replies:** 0\
**Last updated:** [15 November 2022 13:11 UTC](https://discourse.nodered.org/t/how-to-read-write-in-odbc-by-using-node-red/70648 "2022-11-15T13:11:33Z")

</div>

Hello everyone. I have an application where i need to log the data in MS Access and later from other table i need to read other data. I already created the ODBC source and can write/ read on it with MS Access. My Pr…

---

## [How to use OPC UA Client =\> Register](https://discourse.nodered.org/t/how-to-use-opc-ua-client-register/70629)

<div class="topic-metadata">

**Author:** [@shmiFesto](https://discourse.nodered.org/u/shmiFesto)\
**Replies:** 1\
**Last updated:** [15 November 2022 12:26 UTC](https://discourse.nodered.org/t/how-to-use-opc-ua-client-register/70629 "2022-11-15T12:26:06Z")

</div>

Hi all, we are wondering how to use the action REGISTER in the OPC UA Client node: How is the syntax to register a NodeID (as payload or topic or how does it work)? An example would be highly appreciated …

---

## [Nodered API authentication using keycloak auth](https://discourse.nodered.org/t/nodered-api-authentication-using-keycloak-auth/70616)

<div class="topic-metadata">

**Author:** [@Chinmai](https://discourse.nodered.org/u/Chinmai)\
**Replies:** 3\
**Last updated:** [15 November 2022 12:14 UTC](https://discourse.nodered.org/t/nodered-api-authentication-using-keycloak-auth/70616 "2022-11-15T12:14:12Z")

</div>

Hi, I am trying to achieve a GET operation on http://localhost/nodered/admin/flows and getting 401 error. Curl Command for GET /flows operation curl --request GET 'http://localhost/nodered/admin/flows' --header 'Autho…

---

## [Serial Port Management Features?](https://discourse.nodered.org/t/serial-port-management-features/5587)

<div class="topic-metadata">

**Author:** [@dano3829](https://discourse.nodered.org/u/dano3829)\
**Replies:** 22\
**Last updated:** [15 November 2022 12:04 UTC](https://discourse.nodered.org/t/serial-port-management-features/5587 "2022-11-15T12:04:06Z")

</div>

Just throwing a few ideas out there about Serial Ports. Do you think it will ever be possible to Open, Close, or Configure a Serial Port from inside a Running Flow? I am thinking I should be able to Modify that "Configu…

---

## [After hours of google still cant create a CSV?](https://discourse.nodered.org/t/after-hours-of-google-still-cant-create-a-csv/70626)

<div class="topic-metadata">

**Author:** [@Duncan](https://discourse.nodered.org/u/Duncan)\
**Replies:** 4\
**Last updated:** [15 November 2022 11:33 UTC](https://discourse.nodered.org/t/after-hours-of-google-still-cant-create-a-csv/70626 "2022-11-15T11:33:55Z")

</div>

I have looked at examples but cant seem te get this CSV node. Please help. test.json (6.9 KB) I hope I can post this correctly. Anyway, I have an object that looks like this: 15-11-2022 08:46:31node: 95a25ac4a18fb7…

---

## [Function node not working after update](https://discourse.nodered.org/t/function-node-not-working-after-update/70601)

<div class="topic-metadata">

**Author:** [@Pinky](https://discourse.nodered.org/u/Pinky)\
**Replies:** 16\
**Last updated:** [15 November 2022 11:22 UTC](https://discourse.nodered.org/t/function-node-not-working-after-update/70601 "2022-11-15T11:22:35Z")

</div>

Hello everybody, after I upgraded my instance I noticed that my function-nodes aren't working anymore. When I try to edit them I do not even see the function. Now they have several Tabs (setup, start, function, stop) b…

---

## [Exporting nodes - extra stuff included and not wanted](https://discourse.nodered.org/t/exporting-nodes-extra-stuff-included-and-not-wanted/70632)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [15 November 2022 10:07 UTC](https://discourse.nodered.org/t/exporting-nodes-extra-stuff-included-and-not-wanted/70632 "2022-11-15T10:07:28Z")

</div>

Recently I helped someone and wrote some code to do what they wanted. But when I exported the nodes I took a few configuration nodes as well. But there weren't any of them used in the code. It was simple nodes. I hop…

---

## [Infrared heating and photovoltaic](https://discourse.nodered.org/t/infrared-heating-and-photovoltaic/70529)

<div class="topic-metadata">

**Author:** [@kamcio](https://discourse.nodered.org/u/kamcio)\
**Replies:** 1\
**Last updated:** [15 November 2022 02:04 UTC](https://discourse.nodered.org/t/infrared-heating-and-photovoltaic/70529 "2022-11-15T02:04:57Z")

</div>

Good morning together, I have at home some infrared heatings. I use it only when I make electricity with my photovoltaic. To do it, I have two sockets. 1st socket is controlled with node-red (if the temperature is in r…

---

## [Close only the doors which are open](https://discourse.nodered.org/t/close-only-the-doors-which-are-open/70501)

<div class="topic-metadata">

**Author:** [@sevenmp](https://discourse.nodered.org/u/sevenmp)\
**Replies:** 11\
**Last updated:** [15 November 2022 01:27 UTC](https://discourse.nodered.org/t/close-only-the-doors-which-are-open/70501 "2022-11-15T01:27:09Z")

</div>

Hi all, I am pretty new to nodered or programming in general and need your help for a flow. I have an outside gate and a garage door which I have wired to shellies as such I can open or close them from home assistant. …

---

## [Puzzling JSONATA problem in Change Node](https://discourse.nodered.org/t/puzzling-jsonata-problem-in-change-node/70606)

<div class="topic-metadata">

**Author:** [@null](https://discourse.nodered.org/u/null)\
**Replies:** 1\
**Last updated:** [14 November 2022 23:58 UTC](https://discourse.nodered.org/t/puzzling-jsonata-problem-in-change-node/70606 "2022-11-14T23:58:02Z")

</div>

I am trying to change values in an array, inside a JSON-object acquired from an API. The JSON is formatted like so: { "records": \[ { "HourUTC": "2022-11-14T20:00:00", "SpotPriceDKK": 1039.25 }, …

---

## [Return data from context.get](https://discourse.nodered.org/t/return-data-from-context-get/70544)

<div class="topic-metadata">

**Author:** [@vrabi-cv](https://discourse.nodered.org/u/vrabi-cv)\
**Replies:** 8\
**Last updated:** [14 November 2022 21:10 UTC](https://discourse.nodered.org/t/return-data-from-context-get/70544 "2022-11-14T21:10:29Z")

</div>

Hello, I am newbie into the homeassistant as well as programming, but I have made some simple thing in my home automation and now I want to check if temperature sensor is not "Stucked" at same value. I try to use countin…

---

## [Installation corruption](https://discourse.nodered.org/t/installation-corruption/70542)

<div class="topic-metadata">

**Author:** [@interscope101](https://discourse.nodered.org/u/interscope101)\
**Replies:** 24\
**Last updated:** [14 November 2022 20:37 UTC](https://discourse.nodered.org/t/installation-corruption/70542 "2022-11-14T20:37:29Z")

</div>

Been using node-red for a year without issues. In the last week have had 2 incidents where the installation had become corrupted (seemingly after trying to run some new node configuration) - application and dashboard l…

---

## [OPC UA ExtensionObject Simatic S7-1500](https://discourse.nodered.org/t/opc-ua-extensionobject-simatic-s7-1500/70375)

<div class="topic-metadata">

**Author:** [@uwe81nt](https://discourse.nodered.org/u/uwe81nt)\
**Replies:** 2\
**Last updated:** [14 November 2022 19:05 UTC](https://discourse.nodered.org/t/opc-ua-extensionobject-simatic-s7-1500/70375 "2022-11-14T19:05:26Z")

</div>

Hallo I have a problem and hope you can help me. I took the example of writing ExtensionObjects. After I deploy my flows I get following errors if I start the flow: Maybe someone can help to fix my problem. Please …

---

## [Help with directory locations in templates](https://discourse.nodered.org/t/help-with-directory-locations-in-templates/70528)

<div class="topic-metadata">

**Author:** [@andro](https://discourse.nodered.org/u/andro)\
**Replies:** 3\
**Last updated:** [14 November 2022 17:51 UTC](https://discourse.nodered.org/t/help-with-directory-locations-in-templates/70528 "2022-11-14T17:51:57Z")

</div>

Complete newbie to uibuilder here. I've followed the user installation guildeines and first steps. All I get are blank pages, with errors showing in this case vue.js not found. Looking at the generated index.html created…

---

## [Authentication with GIT](https://discourse.nodered.org/t/authentication-with-git/70454)

<div class="topic-metadata">

**Author:** [@Pinky](https://discourse.nodered.org/u/Pinky)\
**Replies:** 5\
**Last updated:** [14 November 2022 17:32 UTC](https://discourse.nodered.org/t/authentication-with-git/70454 "2022-11-14T17:32:49Z")

</div>

Hello everybody, I found alot of topics like this but still can't figure out where my exact Problem is. I already had git set up and running fine but for a while now pushing to my repo is not possible anymore. The Cred…

---

## [How to set dynamic filepath of database in sqlite node?](https://discourse.nodered.org/t/how-to-set-dynamic-filepath-of-database-in-sqlite-node/70593)

<div class="topic-metadata">

**Author:** [@Josh](https://discourse.nodered.org/u/Josh)\
**Replies:** 1\
**Last updated:** [14 November 2022 17:22 UTC](https://discourse.nodered.org/t/how-to-set-dynamic-filepath-of-database-in-sqlite-node/70593 "2022-11-14T17:22:16Z")

</div>

Hi forum, I am looking for a way to set the file path of database in node-red-node-sqlite node something like via a msg parameter or set via a global context from settings.js. Is this feature supported in sqlite node? …

---

## [PLC -\> Buffer -\> TCP Connection w/ Laptop -\>Buffer Parser -\> CSV](https://discourse.nodered.org/t/plc-buffer-tcp-connection-w-laptop-buffer-parser-csv/70585)

<div class="topic-metadata">

**Author:** [@DashAway](https://discourse.nodered.org/u/DashAway)\
**Replies:** 4\
**Last updated:** [14 November 2022 16:08 UTC](https://discourse.nodered.org/t/plc-buffer-tcp-connection-w-laptop-buffer-parser-csv/70585 "2022-11-14T16:08:22Z")

</div>

We are working on creating a csv file from flow sensor data for a project. The flow sensor data will be coming from a s7 PLC (we have the node for that set up). I then plan to turn that data into a buffer and use a TCP c…

---

## [AT Commands how to check and respond on return messages from modem](https://discourse.nodered.org/t/at-commands-how-to-check-and-respond-on-return-messages-from-modem/70569)

<div class="topic-metadata">

**Author:** [@SplitSecComp](https://discourse.nodered.org/u/SplitSecComp)\
**Replies:** 6\
**Last updated:** [14 November 2022 16:03 UTC](https://discourse.nodered.org/t/at-commands-how-to-check-and-respond-on-return-messages-from-modem/70569 "2022-11-14T16:03:01Z")

</div>

I have a SIM7000E hat connected to my Raspberry. I want to connect the Raspberry to the internet using the SIM7000E hat. I have manged to get everything working and get responses from the modem when i send the AT comman…

---

## [Set value alexa crackable](https://discourse.nodered.org/t/set-value-alexa-crackable/69822)

<div class="topic-metadata">

**Author:** [@Giacomo23](https://discourse.nodered.org/u/Giacomo23)\
**Replies:** 5\
**Last updated:** [14 November 2022 15:14 UTC](https://discourse.nodered.org/t/set-value-alexa-crackable/69822 "2022-11-14T15:14:39Z")

</div>

Hi everyone, I want to set the values such as ip, port, cookie etc .. through a block "edit change node" thanks to all.

---

## [Switch Node | Beginner Question](https://discourse.nodered.org/t/switch-node-beginner-question/70573)

<div class="topic-metadata">

**Author:** [@dokwon](https://discourse.nodered.org/u/dokwon)\
**Replies:** 2\
**Last updated:** [14 November 2022 14:34 UTC](https://discourse.nodered.org/t/switch-node-beginner-question/70573 "2022-11-14T14:34:34Z")

</div>

Hey guys, starting to learn Node-RED and hence running into some 'beginner-friendly' questions :smiley: screenshot 1 screenshot 2 The screenshots are taken from a switch node that I have attached to an 'mqtt in' …

---

## [Xml node string to boolean conversion](https://discourse.nodered.org/t/xml-node-string-to-boolean-conversion/70590)

<div class="topic-metadata">

**Author:** [@psmtvdw](https://discourse.nodered.org/u/psmtvdw)\
**Replies:** 0\
**Last updated:** [14 November 2022 14:26 UTC](https://discourse.nodered.org/t/xml-node-string-to-boolean-conversion/70590 "2022-11-14T14:26:49Z")

</div>

Hi, I am using the XML node to convert an XML formatted string to js object. How can I convert an element value formatted as string ("true", "false") to a boolean datatype in the js object? in the xml2js docs there se…

---

## [Connection from 2 ethernet card](https://discourse.nodered.org/t/connection-from-2-ethernet-card/70312)

<div class="topic-metadata">

**Author:** [@ketpa](https://discourse.nodered.org/u/ketpa)\
**Replies:** 6\
**Last updated:** [14 November 2022 14:26 UTC](https://discourse.nodered.org/t/connection-from-2-ethernet-card/70312 "2022-11-14T14:26:24Z")

</div>

I have 2 ethernet card 1: eno1 IP1: 192.168.0.30 IP2: 10.0.1.30/local network 2: eno2 IP1: 192.168.1.2 and IP2: 192.168.0.252 gateway 192.168.1.1 (internet) I read devices from eno1. How to read devices from eno2 192…

---

## [Create function node to send msg.payload.variableValue from existing msg.payload](https://discourse.nodered.org/t/create-function-node-to-send-msg-payload-variablevalue-from-existing-msg-payload/70210)

<div class="topic-metadata">

**Author:** [@faulehenne](https://discourse.nodered.org/u/faulehenne)\
**Replies:** 8\
**Last updated:** [14 November 2022 12:01 UTC](https://discourse.nodered.org/t/create-function-node-to-send-msg-payload-variablevalue-from-existing-msg-payload/70210 "2022-11-14T12:01:06Z")

</div>

Hey, i'm building a connection between an MQTT Input and an OPC-UA Server (node-red-contrib-opcua). To give the opc-ua server node a value i need to send my value from the MQTT input as "msg.payload.variableValue". I'…

---

## [Node-RED not installing on Raspberry Pi 4](https://discourse.nodered.org/t/node-red-not-installing-on-raspberry-pi-4/70548)

<div class="topic-metadata">

**Author:** [@TiagoGuilherme](https://discourse.nodered.org/u/TiagoGuilherme)\
**Replies:** 3\
**Last updated:** [14 November 2022 11:33 UTC](https://discourse.nodered.org/t/node-red-not-installing-on-raspberry-pi-4/70548 "2022-11-14T11:33:04Z")

</div>

Hey, so basically im new with all this, im using the Raspberry Pi 4 and im trying to install node red, and I can't install it in the terminal of the Pi 4 just appears the imagem down below and nothing else.

---

## [Connect SIM7000E to the Internet](https://discourse.nodered.org/t/connect-sim7000e-to-the-internet/70489)

<div class="topic-metadata">

**Author:** [@SplitSecComp](https://discourse.nodered.org/u/SplitSecComp)\
**Replies:** 10\
**Last updated:** [13 November 2022 07:22 UTC](https://discourse.nodered.org/t/connect-sim7000e-to-the-internet/70489 "2022-11-13T07:22:52Z")

</div>

Hi. I want to connect my SIM7000E to the internet. When i send the following form a python file i get an "OK" responce from the modem. send\_at('AT+CGDCONT=1,\\"IP\\",\\"'+APN+'\\",\\"0.0.0.0\\",0,0','OK',1) But when i sen…

---

## [Snappy Compression Issues with Kafka Consumer](https://discourse.nodered.org/t/snappy-compression-issues-with-kafka-consumer/70078)

<div class="topic-metadata">

**Author:** [@elfinbird](https://discourse.nodered.org/u/elfinbird)\
**Replies:** 4\
**Last updated:** [14 November 2022 09:04 UTC](https://discourse.nodered.org/t/snappy-compression-issues-with-kafka-consumer/70078 "2022-11-14T09:04:51Z")

</div>

Use case: I am writing a Kafka consumer for my node-red project. Libraries used: node-red-contrib-kafkajs, node-red-contrib-kafka-manager Error: "Snappy compression not implemented" / "Snappy codec is not available" Q…

---

## [How to add key in open api client?](https://discourse.nodered.org/t/how-to-add-key-in-open-api-client/70486)

<div class="topic-metadata">

**Author:** [@himanshiiii](https://discourse.nodered.org/u/himanshiiii)\
**Replies:** 5\
**Last updated:** [14 November 2022 08:43 UTC](https://discourse.nodered.org/t/how-to-add-key-in-open-api-client/70486 "2022-11-14T08:43:34Z")

</div>

My question is related to node red openapi client i have used "npm install openapi-red" to install openapi red. I am using openapi client to show my result but it shows an error of { "error\_message" : "You must us…

---

## [Dynamically changing debug node's name](https://discourse.nodered.org/t/dynamically-changing-debug-nodes-name/70539)

<div class="topic-metadata">

**Author:** [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Replies:** 10\
**Last updated:** [14 November 2022 01:01 UTC](https://discourse.nodered.org/t/dynamically-changing-debug-nodes-name/70539 "2022-11-14T01:01:13Z")

</div>

This was discussed here https://discourse.nodered.org/t/auto-name-debug-node-with-some-serialization-with-an-option-to-override-the-name/53926 I know debug nodes are now given a name "Debug n" but was the ability to cha…

---

## [Asking for help with IP nodes (getting network IP information)](https://discourse.nodered.org/t/asking-for-help-with-ip-nodes-getting-network-ip-information/70550)

<div class="topic-metadata">

**Author:** [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Replies:** 2\
**Last updated:** [14 November 2022 00:18 UTC](https://discourse.nodered.org/t/asking-for-help-with-ip-nodes-getting-network-ip-information/70550 "2022-11-14T00:18:18Z")

</div>

Although I don't really need it, a problem has happened and I am wanting to use NR to help me with things. I know I can use the host\_IP node to get the IP of that machine, but I am wanting to get more information than j…

---

## [Any method to slowdown gpsd report interval?](https://discourse.nodered.org/t/any-method-to-slowdown-gpsd-report-interval/70493)

<div class="topic-metadata">

**Author:** [@rxunique](https://discourse.nodered.org/u/rxunique)\
**Replies:** 2\
**Last updated:** [13 November 2022 21:01 UTC](https://discourse.nodered.org/t/any-method-to-slowdown-gpsd-report-interval/70493 "2022-11-13T21:01:18Z")

</div>

Hi Everyone. I'm using a 4G modem's built-in GPS and GPSD for geofencing. currently the serial port outputs gps info on 1s interval or less, hence gpsd would output and trigger the flow on the same interval. In my ap…

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

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