Please help us help you and fill where relevant:
Your LimeSurvey version: 6.4.2+240115 
Own server or LimeSurvey hosting: Own Server (AWS Linux)
Survey theme/template: default
==================
I have some survey result with over 30 fields and 2000+ response.  My manager would like to export it in Excel format.

Yet the time exporting that file is beyond 1 min, which is the maximum timeout period from AWS cloudfront.

Other than increasing the timeout of PHP, may I ask if Limesurvey can export result on the background, so that it can bypass the timeout issue?

Thank you in advance for your help.

I think the only way is to create a plugin for this (but i don't know how to start).

Else : export 200 by 200 with api.limesurvey.org/classes/remotecontrol...hod_export_responses

Check if exporting to CSV is maybe quicker. If so, convert the downloaded CSV to Excel later.

holch wrote:

Check if exporting to CSV is maybe quicker. If so, convert the downloaded CSV to Excel later.

Yeah, and maybe export using codes only.

Thanks for your reference.

Thank you, yet if the number of responses is over 20,000 or larger, it will still have timeout issue.

alucard001 wrote:

Thank you, yet if the number of responses is over 20,000 or larger, it will still have timeout issue.
 

Then seems you need to export 5000 by 5000

Thank you, yet if the number of responses is over 20,000 or larger, it will still have timeout issue.

The initial discussion was about 2000+ responses. While 20000 is of course within "2000+" I assumed that the responses might be between 2000-3000 max. Not 20000 or more.

It is not overly surprising that you might run into some issues when exporting 20000+ responses and the maximum execution time is 1 minute. If you can't adapt the max execution time, you need to speed up the process. Either by exporting in batches or trying to get a quicker processer that can run the script in less time. But there might be also other factors that impact (the way how you connect to the database, etc). And you might also run into max_vars limits with this amount of responses.