# Reading from CSV file

**URL:** <https://discourse.nodered.org/t/reading-from-csv-file/58326>\
**Category:** General\
**Created:** [14 February 2022 17:11 UTC](https://discourse.nodered.org/t/reading-from-csv-file/58326 "2022-02-14T17:11:20Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kalo](https://avatars.discourse-cdn.com/v4/letter/k/6bbea6/32.png) [@Kalo](https://discourse.nodered.org/u/Kalo)\
**Post date:** [14 February 2022 17:11 UTC](https://discourse.nodered.org/t/reading-from-csv-file/58326/1 "2022-02-14T17:11:20Z")

</div>

Hello, I'm new to using NodeRed. I'm reading data from a CSV file. The file I'm reading from has 300+ records. In the debugger, it only shows the LAST 30 records as output.  
How can I show all the records and start from the beginning of the file?

 ![nodered](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/8/282b2df1376767f003d481c3a479b611e1a622b2.png)

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [14 February 2022 17:58 UTC](https://discourse.nodered.org/t/reading-from-csv-file/58326/2 "2022-02-14T17:58:41Z")

</div>

You haven't shown where you are taking the debug from nor have you shared the output of the debug - is it showing text or an array?

---

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [14 February 2022 18:06 UTC](https://discourse.nodered.org/t/reading-from-csv-file/58326/3 "2022-02-14T18:06:12Z")

</div>

If you mean the standard 'debug' node - then there is a (default) limit of showing 1000chars.  
However, this can be increased by altering this option in your settings.js file (inside the .node-red folder).

`debugMaxLength: 1000,`

Please note... you will need to stop and restart Node-RED to pick-up the new settings.

---

<div class="post-metadata">

**Author:** ![Kalo](https://avatars.discourse-cdn.com/v4/letter/k/6bbea6/32.png) [@Kalo](https://discourse.nodered.org/u/Kalo)\
**Post date:** [14 February 2022 18:16 UTC](https://discourse.nodered.org/t/reading-from-csv-file/58326/4 "2022-02-14T18:16:36Z")

</div>

![nodered2](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/5/554f15b19a991ca677802b0b32133976c48ea4ae.png)  
 ![nodered3](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/f/0f312c79ab54e7d4e2ce4ff7de2de39baa7bf467.png)

Thanks for replying. The output on the left shows only the LAST 30 rows from the CSV file I have. I want it to start from the top of the file and show me one by one

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [14 February 2022 18:24 UTC](https://discourse.nodered.org/t/reading-from-csv-file/58326/5 "2022-02-14T18:24:57Z")

</div>

You have two nodes upstream of the Humidity output. One of those will be filtering out some of the messages. I would suggest that it is probably how you've got the rate limited set but it could be the one marked as a filter. Impossible for me to say as I can't see the settings.

Way are you rate limiting your MQTT output anyway? MQTT can generally handle hundreds if not thousands or more messages per second even on limited hardware - well it can if you are using a good broker such as Mosquitto.

---

<div class="post-metadata">

**Author:** ![Kalo](https://avatars.discourse-cdn.com/v4/letter/k/6bbea6/32.png) [@Kalo](https://discourse.nodered.org/u/Kalo)\
**Post date:** [14 February 2022 18:38 UTC](https://discourse.nodered.org/t/reading-from-csv-file/58326/6 "2022-02-14T18:38:44Z")

</div>

Sorry for the inconvenience, the problem was in the CSV node. It was skipping the first 300. Thanks for the info on MQTT, I use it to show the output slowly that is all.

---

<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:** [15 April 2022 18:39 UTC](https://discourse.nodered.org/t/reading-from-csv-file/58326/7 "2022-04-15T18:39:53Z")

</div>

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