# Batch data read from XLSDataReader

**URL:** <https://forum.cloverdx.com/t/batch-data-read-from-xlsdatareader/1646>\
**Category:** CloverDX Platform\
**Created:** [July 10, 2015, 12:00am UTC](https://forum.cloverdx.com/t/batch-data-read-from-xlsdatareader/1646 "2015-07-10T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kreddy](https://avatars.discourse-cdn.com/v4/letter/k/e56c9b/32.png) [@kreddy](https://forum.cloverdx.com/u/kreddy)\
**Post date:** [July 10, 2015, 12:00am UTC](https://forum.cloverdx.com/t/batch-data-read-from-xlsdatareader/1646/1 "2015-07-10T00:00:00Z")

</div>

Hi ,

I am just started working on CloverETL.Could any one help me the better approach for below requirement.

- From excel file(75000 records) data should read as batches(5000 records at time)  
- Transformer component to parse 5000 records to JSON list  
- above JSON list should pass to HTTPConnector  
- HTTP response success to CSV failure to CSV file

Appreciate your help.

Thanks,  
Kalpana.

---

<div class="post-metadata">

**Author:** ![slechtaj](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@slechtaj](https://forum.cloverdx.com/u/slechtaj)\
**Post date:** [July 15, 2015, 1:52pm UTC](https://forum.cloverdx.com/t/batch-data-read-from-xlsdatareader/1646/2 "2015-07-15T13:52:53Z")

</div>

Hi Kalpana,

There is no need to read data from the XLS file in batches (in fact nothing like that would solve your situation) - this can be simply done by using “Records per file” attribute (set to 5000 in your case) of JSONWriter, which tells the component to use that amount of incoming records to compose the output JSON structure.

For more information about JSONWriter please refer to our [documentation](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/jsonwriter.html).

Hope it helps.

---

<div class="post-metadata">

**Author:** ![kreddy](https://avatars.discourse-cdn.com/v4/letter/k/e56c9b/32.png) [@kreddy](https://forum.cloverdx.com/u/kreddy)\
**Post date:** [July 21, 2015, 5:40am UTC](https://forum.cloverdx.com/t/batch-data-read-from-xlsdatareader/1646/3 "2015-07-21T05:40:47Z")

</div>

Thank you so much for your reply.I will try the option you suggested.

Thanks,  
Kalpana.