# Not able to read CSV

**URL:** <https://discourse.nodered.org/t/not-able-to-read-csv/35253>\
**Category:** General\
**Created:** [3 November 2020 04:13 UTC](https://discourse.nodered.org/t/not-able-to-read-csv/35253 "2020-11-03T04:13:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![varunyc](https://avatars.discourse-cdn.com/v4/letter/v/8dc957/32.png) [@varunyc](https://discourse.nodered.org/u/varunyc)\
**Post date:** [3 November 2020 04:13 UTC](https://discourse.nodered.org/t/not-able-to-read-csv/35253/1 "2020-11-03T04:13:10Z")

</div>

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 ☹

```auto
[{"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":[]}]

```

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/c/1c4a6a5642c9f0bc905c7e4c5cdac550a2459e95.png)

Thanks & Regards  
Varun

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [3 November 2020 09:02 UTC](https://discourse.nodered.org/t/not-able-to-read-csv/35253/2 "2020-11-03T09:02:22Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![varunyc](https://avatars.discourse-cdn.com/v4/letter/v/8dc957/32.png) [@varunyc](https://discourse.nodered.org/u/varunyc)\
**Post date:** [3 November 2020 10:17 UTC](https://discourse.nodered.org/t/not-able-to-read-csv/35253/3 "2020-11-03T10:17:48Z")

</div>

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

Thanks  
Varun

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [17 November 2020 10:17 UTC](https://discourse.nodered.org/t/not-able-to-read-csv/35253/4 "2020-11-17T10:17:55Z")

</div>

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