cancel
Showing results for 
Search instead for 
Did you mean: 

Where is the configuration setting for the CSV export (save) on limiting lines?

Pix_R
Level 5

When exporting using the save option in the DI console there seems a limitation of 50,000 lines (+header) no matter how much data is avaialble in the console view. Where is the configuration setting  property to allow for raising the limit?

 

DO you know @CraigeH?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

CraigeH
Level 3
Employee

Hey Rod!

It is not an exposed setting but can be added as follows:

Edit <INSTALLDIR>\Program Files\DataInsight\bin\WebServerService.vmoptions

Add the following line to the end of the file:

      -Dmatrix.export.maxrecords=<VALUE>

Example:

      -Dmatrix.export.maxrecords=200000

Restart the DataInsightWeb service

 

A couple of notes to keep in mind:

1. This will increase load on resources for the webserver on the MS when exporting to CSV

2. Excel (most common program used to open CSV files) has a row limit of 1048576

View solution in original post

2 REPLIES 2

CraigeH
Level 3
Employee

Hey Rod!

It is not an exposed setting but can be added as follows:

Edit <INSTALLDIR>\Program Files\DataInsight\bin\WebServerService.vmoptions

Add the following line to the end of the file:

      -Dmatrix.export.maxrecords=<VALUE>

Example:

      -Dmatrix.export.maxrecords=200000

Restart the DataInsightWeb service

 

A couple of notes to keep in mind:

1. This will increase load on resources for the webserver on the MS when exporting to CSV

2. Excel (most common program used to open CSV files) has a row limit of 1048576

Thank you @CraigeH  successfully confirmed solution.