Import and display a text/csv file in Node-RED dashboard

Dashboard
1

How do I import and display a text or csv file into the node red dashboard? Display as in columns would be great.

2

You have asked how to do two separate things. Which don't you know how to do and what have you tried so far?

1 Like
3

I'm trying to import csv file to dashboard (with columns if possible). How to do it? Thanks for the reply.

4

As I said, that is two tasks. First read the file, second display it.

5

okay. I read the file using csv file. I want to display it in the dashboard.

6

If you search the node red flows library for 'table' you will find there is node-red-contrib-ui-table which you may find useful.

1 Like
7

okay I added it. I will try to do it. thanks a lot in advance for the help.

8

image
image718Ă—78 4.54 KB

9 
[{"id":"67991373.45438c","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"4440c71e.f88f18","type":"ui_table","z":"67991373.45438c","group":"fe9b4de4.dcd72","name":"test","order":11,"width":"0","height":"0","columns":[{"field":"Person ID","title":"Person ID","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"Name","title":"Name","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}},{"field":"Department","title":"Department","width":"","align":"left","formatter":"plaintext","formatterParams":{"target":"_blank"}}],"outputs":0,"cts":false,"x":750,"y":160,"wires":[]},{"id":"6681b08b.4a688","type":"file in","z":"67991373.45438c","name":"Read File","filename":"C:\\Users\\user\\Documents\\Records_Report.csv","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":360,"y":160,"wires":[["e843fa29.885718"]]},{"id":"9a7a7971.dbc4b8","type":"inject","z":"67991373.45438c","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":140,"y":160,"wires":[["6681b08b.4a688"]]},{"id":"e843fa29.885718","type":"csv","z":"67991373.45438c","name":"","sep":",","hdrin":true,"hdrout":false,"multi":"mult","ret":"\\r\\n","temp":"","skip":"0","x":570,"y":160,"wires":[["4440c71e.f88f18"]]},{"id":"fe9b4de4.dcd72","type":"ui_group","z":"","name":"Name list","tab":"da612906.998368","disp":true,"width":"15","collapse":false},{"id":"da612906.998368","type":"ui_tab","z":"","name":"Main-PC","icon":"dashboard","disabled":false,"hidden":false}]
2 Likes