Creating a Chart from A CSV File and JSON File In Node-Red

[@kissingfrogs]

well that was taking me forever and getting no where until I found your excellent tutorial. I would have never worked it out on my own. Thanks Steve

[@stevecope]

No problem. Glad to have helped . Rgds Steve

[@asiw]

Been struggling with creating charts from CSV for some time. Your help with this is most welcome. Many thanks. Arthur

[@matheuspimentel6281]

same to me! thanks god that i found this gay

[@stevecope]

Hi The flows are here stevesnoderedguide.com/download/chart-log-csv-flow www.steves-internet-guide.com/download/chart-log-video/ rgds steve

[@chadhuber5593]

Steve, thank you for the tutorial. I always enjoy your work.

[@Passco666]

Thank you Steve.. I own you huge hug for your tutorial.. I spend many hours to figure it out how to work with chart and python is my baseland so was difficult to me understand the principal and correct coding.

[@ferlandomkiva1047]

very helpful. Thank you sir

[@matheuspimentel6281]

Helped me a lot. Thank you!!!!

[@lionexiot7778]

thanks for share !!! :) i love nodered

[@Spectre68CT]

HI! is it also possible to use a bar graph instead of lines?

[@EPC2036]

Hello Steve, excelent tutorial, thank you. Can you share the flow for the last UI you showed in this video? That will be very helpful, thank you

[@stevecope]

You should find the flows on this page stevesnoderedguide.com/using-the-node-red-chart-node have you tried it or is one missing from there? Rgds Steve

[@EPC2036]

@@stevecope Hello, yes, it is missing. The flows from that website has only 4-5 nodes, whereas the last flow you showed in this video seems complex and has more nodes. Is it possible to have the flow of that? Thank you

[@stevecope]

'@@EPC2036 I'll see if I can find it. Where in the video does it appear? Rgds Steve

[@EPC2036]

@@stevecope Hello Steve, around the 10:40 mark

[@stevecope]

I did that flow for someone a long time ago I will just check that there is nothing confidential in it and put a link to it. Rgds Steve

[@achrefnajjar457]

thanks a lot sir but i'm confused about something is the timestamp you're making the same as the X-axis of the chart ? thanks a lot .

[@FreyaAndAsher]

The date function is wrong. Don't divide datum by 1000.

[@BoyPenTa-o8b]

do you need to convert to UTC in order to show the data to graph?

[@stevecope]

No but you need the time in milliseconds not Unix time

[@BoyPenTa-o8b]

@@stevecope thank you Steve, now working!

[@jvazcarvalho]

Hello, has anyone solved the issue with the "split"? Thanks.

[@stevecope]

Not aware of the issue can you remind me. Rgds Steve

[@preflex3502]

Thanks!

[@bibekkabi4986]

Really nice video! Thanks Steve! I have a question, how do we create a chart from an excel file in node red?

[@stevecope]

Export it as a csv file and use that as in the example.

[@bibekkabi4986]

@@stevecope Thanks! I was trying to use "alafile in" to read an excel file and then use the ui-chart to create a chart but it gives an error "Bad data inject"

[@bibekkabi4986]

@Steve Cope can you please share the csv file that you have used in this video?

[@stevecope]

@@bibekkabi4986 Here it is stevesnoderedguide.com/download/example-csv-for-video

[@bibekkabi4986]

@@stevecope Thanks a lot!

[@rand5844]

Hi, as I am using your flow as reference, I notice the time is not showing accurately. It is not even updating for me. What could be the issue?

[@FreyaAndAsher]

The date function is wrong. Don't divide datum by 1000.

[@samiratalebi7803]

Hello, first thnak u for ur useful viedo. i have a question. I want to convert csv.file to chart and i used ur codes. now i have Error: Cannot read property "split" of undefined. I tested some another Codes but dont resolve. Can u please say me , what can i do? Tnx alot

[@stevecope]

Hi If you go to stevesnoderedguide.com/ask-steve and get in touch you can then send me the flow and data via email and I will take a look. Rgds Steve

[@sujitjana2155]

@@stevecope sir exactly i have same problem. Now what to do?

[@stevecope]

@@sujitjana2155 Go to the site and use the ask steve page and then you can send me the flow and I will take a look. www.steves-internet-guide.com/ask-steve/

[@BoyPenTa-o8b]

their is error at split , please help to fix

[@stevecope]

I'll take a look Rgds Steve

[@stevecope]

Hi Sorry but I don't have the data files any more if you use the ask steve page on the site and send me your data files I will take a look. stevesnoderedguide.com/ask-steve Rgds Steve

[@nickatredbox]

Simple version var row = { "series": ["Living", "Outside", "Office" ], "data": [], //"data": [ {x,y}] ] "labels":[]//["Living Temp", "Outside Temp", "Office Temp" ] }; var msg1 = {}; var pll = msg.payload.length; //pll = 5; var array = []; row.series.forEach(function(item){ array = []; var data = []; //EACH DB ROW for(let i = 0; i < pll; i++) { var DBrow = msg.payload[i]; data.push({x:DBrow['dt'].getTime(), y:parseFloat(DBrow[item])}); //node.warn(data); } row.data.push(data); array.push(row); }); msg1.payload = array; return msg1;