Log in to AnswerLog in to Follow
2021-02-15 13-40-57
Shashank Diwan
483Views
12Comments
Excel Export Bulk Data
Question

Hello,

We are facing performance challenges while export the screen data into Excel, the data volume is high is it is taking longer time and get timeout. Is there any alternate solution to fix this.

Shashank

0
0
04 Sep 2017
2016-04-21 20-09-55
J.
 
MVP

- extend the timeout

- export it via a timer

- don't use excel, but bulkexport via extension

2
0
04 Sep 2017

Hi J.

Thanks for the reply.

The first 2 options are not working for us. What we are trying now is to create an extension, we are exporting the data into CSV and converting it to Excel. Still need to see the results.

Do you think of any other option, because even by creating an extension for bulkexport into excel will take time.

Shashank... 


0
0
05 Sep 2017

Hi Shashank, 

Can you please provide the oml? We are facing the same challenge. 

Thanks, Ananya

0
0
02 Apr 2022

Shashank Diwan wrote:

Hello,

We are facing performance challenges while export the screen data into Excel, the data volume is high is it is taking longer time and get timeout. Is there any alternate solution to fix this.

Shashank

Read this link to anticipate timeout: https://www.outsystems.com/learn/courses/43/master-class-on-best-practices-and-timers/

regards, bb


0
0
20 Sep 2017

Hi Barong,


Even if i updated the timeout, due to heavy volume of data it was taking very long time. We have created a component which export the data into csv and then convert the csv into Excel. Now it is export 30k records within seconds.


Shashank...

1
0
20 Sep 2017

Shashank Diwan wrote:

Hi Barong,


Even if i updated the timeout, due to heavy volume of data it was taking very long time. We have created a component which export the data into csv and then convert the csv into Excel. Now it is export 30k records within seconds.


Shashank...

Shashank, I'm having the same issue. Could you tell me please what's the solution you've used to solve the problem? Is your component available on forge?


0
0
26 Sep 2017

Beatriz Silva wrote:

Shashank Diwan wrote:

Hi Barong,


Even if i updated the timeout, due to heavy volume of data it was taking very long time. We have created a component which export the data into csv and then convert the csv into Excel. Now it is export 30k records within seconds.


Shashank...

Shashank, I'm having the same issue. Could you tell me please what's the solution you've used to solve the problem? Is your component available on forge?


Hi Beatriz,

What we have done to solve the problem is

1. Export the data from the Query to CSV.

2. Convert the CSV into XLS.

3. Download the XLS.

Please use the below component to convert the CSV into XLS.

https://www.outsystems.com/forge/component/2518/convert-csv-file-to-excel-file/

If you need any further help, please let me know.


Shashank...


1
0
26 Sep 2017

How to do step 1? tq

0
0
27 Sep 2017

Barong Bali wrote:

How to do step 1? tq


Hi Barong, 

This is the code to make csv. Bind your record list to For Each and append the value in the text format using string builder.

0
0
06 Nov 2017

Barong Bali wrote:

How to do step 1? tq

Hi Barong,

You can do explicit formatting of a CSV like Rajat suggested, or you can use something generic like the CSVUtil forge component. It roughly works like the Record List to Excel tool available out of the box in OutSystems, so you'll need to define the Structure that you want to translate to/from CSV. 


0
0
07 Nov 2017

Rajat Agrawal wrote:

Barong Bali wrote:

How to do step 1? tq


Hi Barong, 

This is the code to make csv. Bind your record list to For Each and append the value in the text format using string builder.

Hi Rajal, how do you get the filepath of the csv that you built to pass on to the ConvertCsvToExcel action?


0
0
24 Apr 2019

Hi,

This is the code of download widget.

If you have any question please let us know.

Regards,

Rajat Agrawal

0
0
06 Nov 2017
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.