148
Views
11
Comments
How Export the Large amount of records to excel file
Application Type
Traditional Web

I have an export action in my application, which throwing error when exporting excel with the large amount of records.

I don't want to run this process in backend, because user want to download that file in same screen.

Is any other options to export the records without getting error.

Any helps appreciated.

Thanks,

Vishnu Shankar

2024-03-22 09-17-23
Chandra Vikas Sharma
UserImage.jpg
Vishnu shankar

Hi Chandra Vikas, this component for reactive, But i working in Traditional Web application.

2023-10-21 19-42-11
Tousif Khan
Champion

Hello

You can refer to this post, it has similar kind of issue while exporting getting this error,

There are various links to the post and solution is also been marked here 

check on this post 

https://www.outsystems.com/forums/discussion/25500/an-exception-occurred-in-client-script-the-connection-to-server-was-reset/

I hope this will help

Best Regards
Tousif khan

UserImage.jpg
Vishnu shankar

Hi Tousif,

I read the post you suggested, all of which concluded with the solution of changing the button method from Ajax submit to submit.

I can't relate this solution to my problem.

2023-06-12 05-32-53
Ananya Ghosal

Hello Vishnu,

Greetings!

I have following questions related to your query:

1. How much is the data load approximately?

2. Do you have any constraint so that you won't be able to use forge component?

Best Regards,
Ananya

UserImage.jpg
Vishnu shankar

Hi Ananya,

I am exporting the workbook with the several sheets. Each sheets having more than ten thousand records, it's depending on the data in a table.

Yes, i having some restriction to use forge component in my environment.

2023-06-12 05-32-53
Ananya Ghosal

Okay, 10k records are not that much. You can easily extract that amount of data using built in functionalities.

Use a timer here and use wake up timer property. 10k records can be easily exported via record list to excel features. 

Best Regards,

Ananya

UserImage.jpg
Vishnu shankar

Yes, you are right but the problem is user wants to download that excel file instantly in their screen. If i use the timer then i need to maintain separate file list in table to download those files.

2022-05-01 03-47-53
Jun Mun Chan

Hi Vishnu,

Have you tried increasing the Server Request Timeout?


Thank you.

UserImage.jpg
Vishnu shankar

Hi Jun Mun Chan,

"Server Request Timeout " option is not available in traditional web application.

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