topic Re: Exporting to CSV issue in QlikView

Exporting to CSV issue

vinod_nallapaneni — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I'm facing issue with exporting data from table box to CSV.

I've almost 18 Lakh records in table box. While I'm trying to export, Qlikview was not responding. I'm seeing the popup like this.

Can anyone help me on this?

Re: Exporting to CSV issue

trdandamudi — Wed, 24 Aug 2016 12:30:50 GMT

Is it working when you have few rows ? Meaning select few filters and make sure you have few records in your table box and then export to csv and see if you can export. If you can export then it is not any code issue ( because I am not able to see any code in this posting). Might be you have less memory..

Re: Exporting to CSV issue

marcus_sommer — Wed, 24 Aug 2016 12:36:48 GMT

It could be that you haven't enough RAM and/or discspace for it and in general to export about 1.800.000 records will need some time especially if there are many columns with string-values. I think you need to slice down the amount of records or better to store these data from the script-side as csv.

- Marcus

Re: Exporting to CSV issue

avinashelite — Wed, 24 Aug 2016 12:42:06 GMT

As per I know Table Boxes are not very efficient when it comes to memory and CPU utilization and the amount of data export your trying is also bit high . We have limitations with the export to CSV/EXCEL from front end . If you have such have huge data export then why can't you push that to script ?? script handles that better

simple try like store tablename into required_name.txt (txt);

Re: Exporting to CSV issue

vinod_nallapaneni — Thu, 25 Aug 2016 04:29:04 GMT

Hi Avinash,

I Don't have access the script side to reload. So, While I've tried to send those Table box object to CSV. It takes longtime ( It seems 2 Hours). After that What i need to do. Can you please confirm me do we need to wait more time to get 18L records?

- VINOD

Re: Exporting to CSV issue

avinashelite — Thu, 25 Aug 2016 04:53:27 GMT

As Marcus told it depends on your RAM availability, I don't think it feasible to wait for more than 2 hours.

Try like this, instead of exporting 18 lk of records try to reduce the data by adding more filters in the dashboard so that the records get reduce and the export to CSV will be much faster , this is the only way we could do in the front end .

Hope this helps you

Re: Exporting to CSV issue

vinod_nallapaneni — Thu, 25 Aug 2016 07:16:00 GMT

Actually I'm doing like that only after creating the filter I've 18 lk records. Without that there are more than 50 lk records.

How to handle this?

-VINOD

Re: Exporting to CSV issue

qlikviewwizard — Thu, 25 Aug 2016 07:27:01 GMT

Did you try in server? What is the RAM size?

Try something like this:

Store yourcvs into csv.txt(txt);

Re: Exporting to CSV issue

vinod_nallapaneni — Thu, 25 Aug 2016 07:40:36 GMT

Currently I working on Live server. RAM-16GB.