Excel Export Bulk Data

Excel Export Bulk Data

  

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

- extend the timeout

- export it via a timer

- don't use excel, but bulkexport via extension

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... 


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


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 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?


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...


How to do step 1? tq

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,

This is the code of download widget.

If you have any question please let us know.

Regards,

Rajat Agrawal

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.