How does it function : node-red-node-ui-table?

oktober31 · 5 October 2020 15:05

Hello everybody,

I try to use node-red-node-ui-table since a few weeks.

But I don't understant how it function.

My Node-RED version is 1.1.3
My NodeJS is v.10.22.0
My dashboard module is 2.23.4.

My code is :

[{"id":"8e791778.81e3f8","type":"function","z":"7ca661a9.eef258","name":"","func":"var filepath = `/home/EUREKA/.node-red/Test/node_modules/node-red-node-ui-table/examples/1 Simple table.json`;\n//var filepath = `/home/EUREKA/.node-red/Test/static/data.json`;\nfilepath.replace(\"/\",\"\\ \");\nmsg.filename = filepath;\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":740,"y":260,"wires":[["bda98565.e559e8"]]},{"id":"a19e98ac.8ba54","type":"inject","z":"7ca661a9.eef258","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":580,"y":260,"wires":[["8e791778.81e3f8"]]},{"id":"96d9159b.d914b8","type":"ui_table","z":"7ca661a9.eef258","group":"80c8c9d6.b15c6","name":"","order":0,"width":"20","height":"11","columns":[],"outputs":0,"cts":false,"x":1290,"y":260,"wires":[]},{"id":"bda98565.e559e8","type":"file in","z":"7ca661a9.eef258","name":"Read data.json","filename":"","format":"utf8","chunk":false,"sendError":true,"encoding":"binary","x":920,"y":260,"wires":[["df758942.b7511"]]},{"id":"df758942.b7511","type":"json","z":"7ca661a9.eef258","name":"","property":"payload","action":"","pretty":false,"x":1110,"y":260,"wires":[["3dfe34cd.9887f4","96d9159b.d914b8"]]},{"id":"3dfe34cd.9887f4","type":"debug","z":"7ca661a9.eef258","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":1250,"y":340,"wires":[]},{"id":"80c8c9d6.b15c6","type":"ui_group","z":"","name":"Default","tab":"b13b5d9b.f1092","order":1,"disp":true,"width":"30","collapse":false},{"id":"b13b5d9b.f1092","type":"ui_tab","z":"","name":"Home","icon":"dashboard","disabled":false,"hidden":false}]

And the result is :

I don't understand what I must do to have a good array with the parameters from Tabulator.

Can anybody help me ?

Please.

Thank you.

Oliver

TotallyInformation · 5 October 2020 19:45

Hi, and welcome to the forum. Couple of things here, please wrap your code in back-ticks as per the help information otherwise it cannot be used as a test.

Secondly, without an extract of the JSON data, it is hard to know what other problems you may have.

Speaking generally, table components generally want an array of objects:

[
    { .... },
    ...
    { .... },
]

Where each object has properties that match the column names:

[
    { "id": ..., "type": ..., ... },
    ...
    { "id": ..., "type": ..., ... },
]

I think that you may also need to defined the column names in the ui_table node as well though I'm not entirely sure whether that is really needed in this case.

oktober31 · 6 October 2020 06:56

Hi and thank you for your precision.

So my code is :

[{"id":"7ca661a9.eef258","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"8e791778.81e3f8","type":"function","z":"7ca661a9.eef258","name":"","func":"var filepath = `/home/EUREKA/.node-red/Test/node_modules/node-red-node-ui-table/examples/1 Simple table.json`;\nfilepath.replace(\"/\",\"\\ \");\nmsg.filename = filepath;\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":740,"y":260,"wires":[["bda98565.e559e8"]]},{"id":"a19e98ac.8ba54","type":"inject","z":"7ca661a9.eef258","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":580,"y":260,"wires":[["8e791778.81e3f8"]]},{"id":"96d9159b.d914b8","type":"ui_table","z":"7ca661a9.eef258","group":"80c8c9d6.b15c6","name":"","order":0,"width":"20","height":"11","columns":[],"outputs":0,"cts":false,"x":1290,"y":260,"wires":[]},{"id":"bda98565.e559e8","type":"file in","z":"7ca661a9.eef258","name":"Read data.json","filename":"","format":"utf8","chunk":false,"sendError":true,"encoding":"binary","x":920,"y":260,"wires":[["df758942.b7511"]]},{"id":"df758942.b7511","type":"json","z":"7ca661a9.eef258","name":"","property":"payload","action":"","pretty":false,"x":1110,"y":260,"wires":[["96d9159b.d914b8"]]},{"id":"80c8c9d6.b15c6","type":"ui_group","z":"","name":"Default","tab":"b13b5d9b.f1092","order":1,"disp":true,"width":"30","collapse":false},{"id":"b13b5d9b.f1092","type":"ui_tab","z":"","name":"Home","icon":"dashboard","disabled":false,"hidden":false}]

And I use the json file example from the node-red-node-ui-table :

    {
        "id": "bc380b4b.e2d668",
        "type": "inject",
        "z": "9663b812.93cc28",
        "name": "",
        "topic": "",
        "payload": "[{\"Name\":\"Kazuhito Yokoi\",\"Age\":\"35\",\"Favourite Color\":\"red\",\"Date Of Birth\":\"12/09/1983\"},{\"Name\":\"Oli Bob\",\"Age\":\"12\",\"Favourite Color\":\"red\",\"Date Of Birth\":\"12/08/2017\"}]",
        "payloadType": "json",
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "x": 150,
        "y": 220,
        "wires": [
            [
                "2460c057.cfbc4"
            ]
        ]
   },
    {
        "id": "2460c057.cfbc4",
        "type": "ui_table",
        "z": "9663b812.93cc28",
        "group": "625872f.40b1e8c",
        "name": "",
        "width": 0,
        "height": 4,
        "columns": [],
        "x": 350,
        "y": 220,
        "wires": []
    },
    {
        "id": "9e33f566.8c9098",
        "type": "comment",
        "z": "9663b812.93cc28",
        "name": "Normal table",
        "info": "",
        "x": 150,
        "y": 180,
        "wires": []
    },
    {
        "id": "625872f.40b1e8c",
        "type": "ui_group",
        "z": "",
        "name": "Default",
        "tab": "58c2aa06.ef46e4",
        "disp": true,
        "width": "6",
        "collapse": false
    },
    {
        "id": "58c2aa06.ef46e4",
        "type": "ui_tab",
        "z": "",
        "name": "Home",
        "icon": "dashboard",
        "disabled": false,
        "hidden": false
    }
]```

And I don’t understand how to use this json file.

I understand that I can insert the data in the msg.payload and that’s ok. But I want to personalize the array.

Thank you for your help.

oktober31 · 12 October 2020 13:15

I found alone.

system · 26 October 2020 13:15

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Examples for node-red-node-ui-table Dashboard	93	46843	17 July 2020
Node-red-ui-table don't refresh automatically General	3	73	18 July 2024
Ui-table ui_control example does not work Dashboard	4	440	25 May 2021
Node-red-node-ui-table Row Background Color Dashboard node-red-dashboard	4	227	29 December 2023
Using UI-Table handler Dashboard node-red-dashboard , docker , mqtt	1	203	21 April 2023

How does it function : node-red-node-ui-table?

Related topics