Flexmonster pivotgrid freeze navigator when load a large CSV file

I’m working with the pivotgrid, i pass a CSV file about 300Mb, with a 500.000 Rows aprox, but when i Load the CSV in the pivotgrid the navigator Freeze and make a Error.
How i do to load the CSV, i test GZip the content but the navigator gave me the same error.

5 answers

Iryna Kulchytska Staff February 17, 2016

Hi Raul,
Could you please provide us with the text of the error you get?
The component supports GZip.
I would recommend you checking our CSV Compressor. It is available for .NET, Java and PHP and its newest version can be downloaded together with the front-end component from http://www.flexmonster.com/download-page/?edition=advanced
Also, I would recommend you reading the blog post OLAP vs CSV: What to Choose to Boost Your Pivot’s Performance
Kind regards,

rcastrop February 17, 2016

Hi Irina,
I try the CSV Compressor, i convert the csv in ocsv file and pass it to the pivot grid but the navigator gave me an error and close all the pages with the same error.
The ocsv file is about 42Mb.
The error is:
IMG of Error

Iryna Kulchytska Staff February 18, 2016

Hi Raul,
It looks like your file is too large to store in the browser’s memory. In this case, I can recommend you to prefilter your data and split it to smaller chunks.

rcastrop February 18, 2016

Hi Irina,
But the description of the grid Says that support 100Mb of CSV data, i think that can do.
How i split in parts the ocsv data and how i pass it to the grid?
Thanks for your help.

Iryna Kulchytska Staff February 18, 2016


Yes, you are right, the description says 100Mb of CSV but it doesn’t say the same about compressed data. I suggest using the server-side prefiltering tool. It will help you to reduce the amount of loading data.

Best regards

Please login or Register to Submit Answer