How to sort data in HTML

#1

Hello,
I m trying to Display some data on a html request with the http in-node. My Problem now is that i take the data from a csv file and can t sort them at the html request..
All i got is shown in the first Picture

Picture 1

in the csv file every string is in a own line.

can anyone help me?

[{"id":"c57a160e.f2b478","type":"http response","z":"d1d10813.9c6158","name":"","statusCode":"","headers":{},"x":710,"y":1060,"wires":[]},{"id":"f5f42089.75484","type":"function","z":"d1d10813.9c6158","name":"Set Content-Type header","func":"msg.headers = { \"Content-Type\":\"text/html\"};\nreturn msg;","outputs":1,"noerr":0,"x":635,"y":1175.150001525879,"wires":[["c57a160e.f2b478"]]},{"id":"38e46517.d80caa","type":"http in","z":"d1d10813.9c6158","name":"","url":"/test","method":"get","upload":false,"swaggerDoc":"","x":245,"y":1055.150001525879,"wires":[["fbaee8df.02a418"]]},{"id":"8915fd40.bbdc68","type":"function","z":"d1d10813.9c6158","name":"Adding File Name","func":"msg.payload=Number(msg.payload)\nif(msg.payload===0){\n    msg.filename=\"/home/pi/gesamtcount.csv\";\n    return msg;\n}\nreturn msg.filename;","outputs":1,"noerr":0,"x":515,"y":1115.150001525879,"wires":[[]]},{"id":"daa9cc38.bf06","type":"file in","z":"d1d10813.9c6158","name":"Picture Selector","filename":"/home/pi/gesamtcount.csv","format":"","sendError":true,"x":405,"y":1175.150001525879,"wires":[["f5f42089.75484"]]},{"id":"31f4bede.a8b7ba","type":"inject","z":"d1d10813.9c6158","name":"","topic":"","payload":"0","payloadType":"num","repeat":"","crontab":"","once":false,"x":235,"y":1115.150001525879,"wires":[["8915fd40.bbdc68","fbaee8df.02a418"]]},{"id":"fbaee8df.02a418","type":"function","z":"d1d10813.9c6158","name":"","func":"msg.filename=\"/home/pi/gesamtcount.csv\";\nreturn msg;","outputs":1,"noerr":0,"x":255,"y":1175.150001525879,"wires":[["daa9cc38.bf06"]]},{"id":"5d3b7fdc.a32e8","type":"comment","z":"d1d10813.9c6158","name":"Bild upload","info":"Flow stellt bild als HTML bereit, ist intern erreichbar unter:\n192.168.1.44:1880/metz-connect_image\n\nVon dort aus kann dann das Image in das Dashboard geladen werden.\nDas passiert mit dem template \"Metz-Connect\"","x":475,"y":1015.1500015258789,"wires":[]}]
#2

Check your settings in the csv node. You probably want "Output a msg per line" not "Output a single Buffer object"

Its always worth checking the settings in a node if you get a result you are not expecting.

#3

yes, u re right but if i Change the Setting to "Output a msg per line" the HTML page is loading but doesn t catch my data

#4

So try the other options...
I'm not sure what you are expecting the output to look like.

#5

If you are expecting a list of data.

You are setting the headers to say you are returning HTML, but theres no HTML tags in your input file, so theres no "newline" html character for your browser to interpret

#6

I tried every of them 4 but it just works with "a singe utf8 string" and with "a single Buffer" and both look the same..

I want sth like a table with one column

#7

okay now I understand why it doesn t work like i want it to work :see_no_evil:

what do i have to do that the browser Interpret?

Do I have to implement <br> into my file?

#8

I got it! I implement the <br> every time when I write a new file..