Not able to read CSV

Dear All,

I am trying to read CSV file to store it in a InfluxDB. As of now InfluxDB node is not added as I am getting error "This node only handles CSV strings or js objects." while reading CSV file its self. Please help me to resolve this issue.

I tried lot of option but none of them are worked out for me :frowning:

[{"id":"39800f2c.b064a","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"5744607a.a8bd7","type":"csv","z":"39800f2c.b064a","name":"","sep":",","hdrin":true,"hdrout":"","multi":"one","ret":"\\n","temp":"S10","skip":"0","strings":false,"x":610,"y":160,"wires":[["bb441790.64b618"]]},{"id":"b31614a1.4b5db8","type":"inject","z":"39800f2c.b064a","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":100,"y":120,"wires":[["59c86baa.5ae5c4"]]},{"id":"59c86baa.5ae5c4","type":"file","z":"39800f2c.b064a","name":"","filename":"C:\\Varun\\Simplelern\\Youtube\\Validate\\outputS10.csv","appendNewline":false,"createDir":false,"overwriteFile":"false","encoding":"none","x":420,"y":80,"wires":[["5744607a.a8bd7"]]},{"id":"bb441790.64b618","type":"debug","z":"39800f2c.b064a","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":640,"y":320,"wires":[]}]

Thanks & Regards

The flow you have posted writes to the file, it does not read it. You are injecting a timestamp so that is getting appended to the file, then the node just passes on the timestamp and that is going to the CSV node. If you want to read a file then you have to use the file in node.
A hint for debugging flows is to use debug nodes. The CSV node is showing you an error so the first thing you could have done was to use a debug node to see what you are sending the CSV node, then you would have seen that it was not correct and known that the problem was in the File node.

Yes.. Thanks a lot it working fine now. I am very new to node red.'


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