# General

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

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

**Page:** 510

---

## [JSON on exec nodes](https://discourse.nodered.org/t/json-on-exec-nodes/49551)

<div class="topic-metadata">

**Author:** [@mafify](https://discourse.nodered.org/u/mafify)\
**Replies:** 3\
**Last updated:** [11 August 2021 21:26 UTC](https://discourse.nodered.org/t/json-on-exec-nodes/49551 "2021-08-11T21:26:02Z")

</div>

Hello, everyone I am parsing python output that is in JSON format, it is received by the exec node as string so I added a JSON node on the output. It's working fine on slow data rate, when it goes above 500Hz, The exec n…

---

## [2 Formatting node dont give the same result](https://discourse.nodered.org/t/2-formatting-node-dont-give-the-same-result/49609)

<div class="topic-metadata">

**Author:** [@funhall](https://discourse.nodered.org/u/funhall)\
**Replies:** 1\
**Last updated:** [11 August 2021 17:39 UTC](https://discourse.nodered.org/t/2-formatting-node-dont-give-the-same-result/49609 "2021-08-11T17:39:49Z")

</div>

Can someone tell me why I cant get the Hour out of this time formatting node. It is like there is a set var. that is "2" I have the same settings as the one below. \[{"id":"f94f3a76a143067f","type":"debug","z":"9ef76…

---

## [Data from xml in link](https://discourse.nodered.org/t/data-from-xml-in-link/49616)

<div class="topic-metadata">

**Author:** [@Dregi56](https://discourse.nodered.org/u/Dregi56)\
**Replies:** 1\
**Last updated:** [11 August 2021 14:26 UTC](https://discourse.nodered.org/t/data-from-xml-in-link/49616 "2021-08-11T14:26:58Z")

</div>

What node to use to connect a link that exposes me an xml (eg http://www.pippo.it/pluto.xml) and then "capture" the content of the xml in a payload?

---

## [Convert script python to .json file](https://discourse.nodered.org/t/convert-script-python-to-json-file/49443)

<div class="topic-metadata">

**Author:** [@wejdene.guedri](https://discourse.nodered.org/u/wejdene.guedri)\
**Replies:** 51\
**Last updated:** [11 August 2021 14:17 UTC](https://discourse.nodered.org/t/convert-script-python-to-json-file/49443 "2021-08-11T14:17:43Z")

</div>

Hello I wrote a scipt in python to detect distance between camera and object, i want to send the distance to an appli node red. Is it possible to convert this script into a .json file and import it into node red to get…

---

## [Function node Javascript editor - Need a list of keyboard shortcuts](https://discourse.nodered.org/t/function-node-javascript-editor-need-a-list-of-keyboard-shortcuts/49532)

<div class="topic-metadata">

**Author:** [@Boja](https://discourse.nodered.org/u/Boja)\
**Replies:** 2\
**Last updated:** [11 August 2021 12:55 UTC](https://discourse.nodered.org/t/function-node-javascript-editor-need-a-list-of-keyboard-shortcuts/49532 "2021-08-11T12:55:03Z")

</div>

Hi, have tried to get a list of all keyboard shortcuts available in the editor. Does anyone know where a updated list can be found ? /Bo

---

## [Build Nodered codebase into a container](https://discourse.nodered.org/t/build-nodered-codebase-into-a-container/49594)

<div class="topic-metadata">

**Author:** [@server-master](https://discourse.nodered.org/u/server-master)\
**Replies:** 4\
**Last updated:** [11 August 2021 08:18 UTC](https://discourse.nodered.org/t/build-nodered-codebase-into-a-container/49594 "2021-08-11T08:18:18Z")

</div>

Hi guys, our team has a nodered GIT repo and i'm trying to dockerize it to push between environments but im just not able to make progress. When i followed the steps on the Nodered documentation(Running under Docker : No…

---

## [Issue with setting up projects](https://discourse.nodered.org/t/issue-with-setting-up-projects/49599)

<div class="topic-metadata">

**Author:** [@ruk-shan](https://discourse.nodered.org/u/ruk-shan)\
**Replies:** 1\
**Last updated:** [11 August 2021 08:01 UTC](https://discourse.nodered.org/t/issue-with-setting-up-projects/49599 "2021-08-11T08:01:42Z")

</div>

I'm running node-red in a docker. I was trying to setup node-red projects. Please help. Thanks.

---

## [Docker compose, mount a volume](https://discourse.nodered.org/t/docker-compose-mount-a-volume/49600)

<div class="topic-metadata">

**Author:** [@ruk-shan](https://discourse.nodered.org/u/ruk-shan)\
**Replies:** 0\
**Last updated:** [11 August 2021 07:07 UTC](https://discourse.nodered.org/t/docker-compose-mount-a-volume/49600 "2021-08-11T07:07:17Z")

</div>

Hi, I'm trying to to mount a volume with docker compose this compose file. But it doesn't work. Please help. Thank u. version: "3.7" services: node-red: image: nodered/node-red:latest environment: - T…

---

## [Create CSV file from MSSQL-Plus stored procedure?](https://discourse.nodered.org/t/create-csv-file-from-mssql-plus-stored-procedure/49516)

<div class="topic-metadata">

**Author:** [@grant1](https://discourse.nodered.org/u/grant1)\
**Replies:** 7\
**Last updated:** [11 August 2021 00:30 UTC](https://discourse.nodered.org/t/create-csv-file-from-mssql-plus-stored-procedure/49516 "2021-08-11T00:30:13Z")

</div>

Is there a way to create a csv file from an array that is being returned by a MSSQL stored procedure? I would like for this .csv file to be created & placed on a network share or other convenient location.

---

## [Cannot stop node-red after update](https://discourse.nodered.org/t/cannot-stop-node-red-after-update/49546)

<div class="topic-metadata">

**Author:** [@myWa](https://discourse.nodered.org/u/myWa)\
**Replies:** 3\
**Last updated:** [10 August 2021 20:20 UTC](https://discourse.nodered.org/t/cannot-stop-node-red-after-update/49546 "2021-08-10T20:20:16Z")

</div>

Dear node-red forum, With very little experience, I successfully performed the Node-Red update to version v2.0.5 on my Debian. I am happy. The instructions helped me a lot: https://nodered.org/docs/getting-started/ras…

---

## [Better way to parse JSON?](https://discourse.nodered.org/t/better-way-to-parse-json/49579)

<div class="topic-metadata">

**Author:** [@Xeniluom](https://discourse.nodered.org/u/Xeniluom)\
**Replies:** 2\
**Last updated:** [10 August 2021 20:19 UTC](https://discourse.nodered.org/t/better-way-to-parse-json/49579 "2021-08-10T20:19:03Z")

</div>

Hi, in a previous post I ask how to find all global variable and it's works perfectly. (List of all global) the JSON i receive is like this : { "payload": \[ { "maison/bureau/temperature": "26.3…

---

## [Get data from barcode](https://discourse.nodered.org/t/get-data-from-barcode/49550)

<div class="topic-metadata">

**Author:** [@JesusGr](https://discourse.nodered.org/u/JesusGr)\
**Replies:** 6\
**Last updated:** [10 August 2021 19:01 UTC](https://discourse.nodered.org/t/get-data-from-barcode/49550 "2021-08-10T19:01:03Z")

</div>

Hi everyone! I've been trying to read data from a barcode and print it on a debug node, but it just doesn't print anything. I've the barcode reader connected by USB port to a raspberry pi 4. The reader is configured fo…

---

## [Admin portal / node-red-contrib-users: How to expire session?](https://discourse.nodered.org/t/admin-portal-node-red-contrib-users-how-to-expire-session/49384)

<div class="topic-metadata">

**Author:** [@JDN](https://discourse.nodered.org/u/JDN)\
**Replies:** 1\
**Last updated:** [10 August 2021 18:48 UTC](https://discourse.nodered.org/t/admin-portal-node-red-contrib-users-how-to-expire-session/49384 "2021-08-10T18:48:58Z")

</div>

Does anyone have an idea how the sessions of a user being logged in via the admin portal or via the contrib-users node could be limited to a certain period, i.e. how to realize an "auto-logout", maybe via setting an expi…

---

## [List of all global](https://discourse.nodered.org/t/list-of-all-global/49567)

<div class="topic-metadata">

**Author:** [@Xeniluom](https://discourse.nodered.org/u/Xeniluom)\
**Replies:** 7\
**Last updated:** [10 August 2021 15:53 UTC](https://discourse.nodered.org/t/list-of-all-global/49567 "2021-08-10T15:53:59Z")

</div>

Hi, I am looking for a method to retrieve the name of the global variables as well as their value. For the moment, I only manage to have an array with the values: global.get (global.keys ()) I can't get the name of t…

---

## [Count Messages - Reset externally](https://discourse.nodered.org/t/count-messages-reset-externally/49560)

<div class="topic-metadata">

**Author:** [@smanjunath211](https://discourse.nodered.org/u/smanjunath211)\
**Replies:** 3\
**Last updated:** [10 August 2021 10:24 UTC](https://discourse.nodered.org/t/count-messages-reset-externally/49560 "2021-08-10T10:24:00Z")

</div>

@Steve-Mcl Hi, is there a way to reset the function code externally, for example, by clicking inject 0, the count should reset

---

## [Address unreachable](https://discourse.nodered.org/t/address-unreachable/49205)

<div class="topic-metadata">

**Author:** [@fredshortlv129bis](https://discourse.nodered.org/u/fredshortlv129bis)\
**Replies:** 6\
**Last updated:** [10 August 2021 09:30 UTC](https://discourse.nodered.org/t/address-unreachable/49205 "2021-08-10T09:30:44Z")

</div>

What can i do with these message? http://192.168.0.129:1880/#flow/cb6f77f6.8fa118 is niet bereikbaar. ERR\_ADDRESS\_UNREACHABLE Do I lost my flow? Jack

---

## [Read data from a table](https://discourse.nodered.org/t/read-data-from-a-table/49518)

<div class="topic-metadata">

**Author:** [@anguslou](https://discourse.nodered.org/u/anguslou)\
**Replies:** 5\
**Last updated:** [10 August 2021 09:08 UTC](https://discourse.nodered.org/t/read-data-from-a-table/49518 "2021-08-10T09:08:41Z")

</div>

I want to make a table on dashboard and allow user to input simple data such as dimension of boxes, eg, Length Width Height Box 1 20 12 7 Box 2 23 …

---

## [MsSQL unique data Dropdown](https://discourse.nodered.org/t/mssql-unique-data-dropdown/49545)

<div class="topic-metadata">

**Author:** [@sefaguntepe](https://discourse.nodered.org/u/sefaguntepe)\
**Replies:** 11\
**Last updated:** [10 August 2021 09:07 UTC](https://discourse.nodered.org/t/mssql-unique-data-dropdown/49545 "2021-08-10T09:07:50Z")

</div>

I want to filter on date column in database. Then I want to show the sensor names that will come from here in the dropdown. (uniquely). Here's what I can do f1 start='2021-08-01' end='2021-08-05' msg.payload ="SELECT…

---

## [Broken Node-red after update](https://discourse.nodered.org/t/broken-node-red-after-update/49499)

<div class="topic-metadata">

**Author:** [@win7viena](https://discourse.nodered.org/u/win7viena)\
**Replies:** 10\
**Last updated:** [10 August 2021 07:02 UTC](https://discourse.nodered.org/t/broken-node-red-after-update/49499 "2021-08-10T07:02:14Z")

</div>

Hello I ask you to please help with the problem, I have very old-ubuntu machine with node-red, node-red dashboard and other plugins. First of all my pc running on Ubuntu 17.10 (GNU/Linux 4.13.0-46-generic x86\_64) nod…

---

## [How to push Node-Red to GitHub without revealing sensitive information?](https://discourse.nodered.org/t/how-to-push-node-red-to-github-without-revealing-sensitive-information/49505)

<div class="topic-metadata">

**Author:** [@portfedh](https://discourse.nodered.org/u/portfedh)\
**Replies:** 6\
**Last updated:** [10 August 2021 02:51 UTC](https://discourse.nodered.org/t/how-to-push-node-red-to-github-without-revealing-sensitive-information/49505 "2021-08-10T02:51:40Z")

</div>

I would like to share my NodeRed Code in Github as part of an IOT project, however I would like to keep some of my data private (MQTT password, InfluxDB password, etc). I could manually erase this information, but this …

---

## [Select from Mysql](https://discourse.nodered.org/t/select-from-mysql/49446)

<div class="topic-metadata">

**Author:** [@zamzon](https://discourse.nodered.org/u/zamzon)\
**Replies:** 15\
**Last updated:** [9 August 2021 21:07 UTC](https://discourse.nodered.org/t/select-from-mysql/49446 "2021-08-09T21:07:45Z")

</div>

Hi I need to get data from my sql database, but i can't see how to get the newest values. my database looks like this I need all the newest ballast state based on an Area

---

## [Create Chart from mySQL Data](https://discourse.nodered.org/t/create-chart-from-mysql-data/3296)

<div class="topic-metadata">

**Author:** [@neophilipp](https://discourse.nodered.org/u/neophilipp)\
**Replies:** 36\
**Last updated:** [9 August 2021 19:07 UTC](https://discourse.nodered.org/t/create-chart-from-mysql-data/3296 "2021-08-09T19:07:57Z")

</div>

Hello Pro's, need to create a chart with the following data from mySQL table: db name: sensors table name: temperature | 1\_OWD | 2493 | 2018-09-20 09:17:32 | | 1\_OWD | 2493 | 2018-09-20 09:19:02 | | 1\_OWD | 25…

---

## [Context Question](https://discourse.nodered.org/t/context-question/49542)

<div class="topic-metadata">

**Author:** [@nacartwright](https://discourse.nodered.org/u/nacartwright)\
**Replies:** 1\
**Last updated:** [9 August 2021 18:11 UTC](https://discourse.nodered.org/t/context-question/49542 "2021-08-09T18:11:38Z")

</div>

We're working on making an API for chatbots. When you set the flow context I understand that is stored in memory. Does that means if you set the flow context on one http post it can be read on the next?

---

## [How to combine date and time picker get data mysql](https://discourse.nodered.org/t/how-to-combine-date-and-time-picker-get-data-mysql/49524)

<div class="topic-metadata">

**Author:** [@Apoki21](https://discourse.nodered.org/u/Apoki21)\
**Replies:** 4\
**Last updated:** [9 August 2021 17:27 UTC](https://discourse.nodered.org/t/how-to-combine-date-and-time-picker-get-data-mysql/49524 "2021-08-09T17:27:53Z")

</div>

Hello Guys I Need help, i have promblem generate csv file get mysql this my flow: and this my function combine: This my dashboard grab: This my format datetime on mysql Thanks All

---

## [How to detect a 0-1-0 and then a 1-0-1 sequence](https://discourse.nodered.org/t/how-to-detect-a-0-1-0-and-then-a-1-0-1-sequence/49534)

<div class="topic-metadata">

**Author:** [@Charry2014](https://discourse.nodered.org/u/Charry2014)\
**Replies:** 4\
**Last updated:** [9 August 2021 17:12 UTC](https://discourse.nodered.org/t/how-to-detect-a-0-1-0-and-then-a-1-0-1-sequence/49534 "2021-08-09T17:12:34Z")

</div>

Hello everyone, I have a garage door sensor that when the door opens is emits a 1-0-1 sequence of events in about 2 seconds, then when it closes the inverse 0-1-0. A steady 0 means the door is closed, a steady 1 means th…

---

## [InfluxDB update issue](https://discourse.nodered.org/t/influxdb-update-issue/49539)

<div class="topic-metadata">

**Author:** [@davidz](https://discourse.nodered.org/u/davidz)\
**Replies:** 3\
**Last updated:** [9 August 2021 16:47 UTC](https://discourse.nodered.org/t/influxdb-update-issue/49539 "2021-08-09T16:47:30Z")

</div>

This post is a friendly reminder that InfluxDB 1.8.7-1.8.9 release has start issue. We recently updated a few devices running Node-RED and InfluxDB and there are data review error. It turned out that InfluxDB did not st…

---

## [UI Button Colour from Global variable](https://discourse.nodered.org/t/ui-button-colour-from-global-variable/49538)

<div class="topic-metadata">

**Author:** [@MyRandomThoughts](https://discourse.nodered.org/u/MyRandomThoughts)\
**Replies:** 0\
**Last updated:** [9 August 2021 15:24 UTC](https://discourse.nodered.org/t/ui-button-colour-from-global-variable/49538 "2021-08-09T15:24:15Z")

</div>

I currently set a global variable with all the colours required for my buttons. I set this at startup and have a LinkIn node attached to the buttons with {{colour.xxxx}} as the text and background colours. This mostly …

---

## [OPC UA Alarams can be generated using node-red interface!](https://discourse.nodered.org/t/opc-ua-alarams-can-be-generated-using-node-red-interface/49537)

<div class="topic-metadata">

**Author:** [@oualid](https://discourse.nodered.org/u/oualid)\
**Replies:** 0\
**Last updated:** [9 August 2021 14:56 UTC](https://discourse.nodered.org/t/opc-ua-alarams-can-be-generated-using-node-red-interface/49537 "2021-08-09T14:56:22Z")

</div>

hi node-red community, i want to know if it's possible to generate a fake opc ua alarm using node-red node. i already succeeded to create manually, with java Script, an opcua server and generate alarms but i want to do…

---

## [Getting value of DOCUMENT\_ROOT from PHP](https://discourse.nodered.org/t/getting-value-of-document-root-from-php/49504)

<div class="topic-metadata">

**Author:** [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Replies:** 9\
**Last updated:** [9 August 2021 10:41 UTC](https://discourse.nodered.org/t/getting-value-of-document-root-from-php/49504 "2021-08-09T10:41:58Z")

</div>

I'm running PHP on nginx (on a RPi-4B) that is also running Node-RED. Is there a way to get hold of... $\_SERVER\['DOCUMENT\_ROOT'\] and use it within Node-RED ?? e.g. like executing \<?php echo $\_SERVER\['DOCUMENT\_ROOT'\]; ?\>…

---

## [Csv with ibm cloud](https://discourse.nodered.org/t/csv-with-ibm-cloud/49528)

<div class="topic-metadata">

**Author:** [@erki338](https://discourse.nodered.org/u/erki338)\
**Replies:** 0\
**Last updated:** [9 August 2021 11:50 UTC](https://discourse.nodered.org/t/csv-with-ibm-cloud/49528 "2021-08-09T11:50:42Z")

</div>

Hello, im running my node red on ibm cloud and i would like download csv file from mysql but the problem right now is with ibm im not able to save csv file. Is there another way i can upload csv file and download it eas…

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

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