# Only 84 rows read in bug CSV

**URL:** <https://discourse.nodered.org/t/only-84-rows-read-in-bug-csv/27414>\
**Category:** General\
**Created:** [28 May 2020 06:30 UTC](https://discourse.nodered.org/t/only-84-rows-read-in-bug-csv/27414 "2020-05-28T06:30:35Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mikeh](https://avatars.discourse-cdn.com/v4/letter/m/258eb7/32.png) [@mikeh](https://discourse.nodered.org/u/mikeh)\
**Post date:** [28 May 2020 06:30 UTC](https://discourse.nodered.org/t/only-84-rows-read-in-bug-csv/27414/1 "2020-05-28T06:30:36Z")

</div>

I have a large csv file with more than 20 thousand rows.  
I was able to read the CSV file but only got 84 rows?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/9/990f15161f4eb1b4beacc8e181a7538350f28c58.png)

---

<div class="post-metadata">

**Author:** ![edje11](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/edje11/32/572_2.png) [@edje11](https://discourse.nodered.org/u/edje11)\
**Post date:** [28 May 2020 07:24 UTC](https://discourse.nodered.org/t/only-84-rows-read-in-bug-csv/27414/2 "2020-05-28T07:24:31Z")

</div>

There is a section in `settings.js` that will allow you to show longer data fields in the debug sidebar:

```auto
// The maximum length, in characters, of any message sent to the debug sidebar tab
debugMaxLength: 1000,

```

---

<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:** [28 May 2020 08:30 UTC](https://discourse.nodered.org/t/only-84-rows-read-in-bug-csv/27414/3 "2020-05-28T08:30:45Z")

</div>

Would it not still show the correct length at the start of the debug output even if it didn't show all of it?

@mikeh if @edje11's suggestion does not help post that portion of the flow here so we can see how everything is configured.

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [28 May 2020 09:19 UTC](https://discourse.nodered.org/t/only-84-rows-read-in-bug-csv/27414/4 "2020-05-28T09:19:47Z")

</div>

How have you set the file read node ? that can happily return one line at a time and the csv node knows how to cope with that.

---

<div class="post-metadata">

**Author:** ![mikeh](https://avatars.discourse-cdn.com/v4/letter/m/258eb7/32.png) [@mikeh](https://discourse.nodered.org/u/mikeh)\
**Post date:** [29 May 2020 06:25 UTC](https://discourse.nodered.org/t/only-84-rows-read-in-bug-csv/27414/5 "2020-05-29T06:25:49Z")

</div>

Yeah I figured this one out by setting the file in to per line.  
I only set the CSV node to per line but failed to also set file in to per line.

---

<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:** [12 June 2020 06:25 UTC](https://discourse.nodered.org/t/only-84-rows-read-in-bug-csv/27414/6 "2020-06-12T06:25:51Z")

</div>

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