MachForm Community Forums » MachForm 2

1. discosteve
   Member

   I have a form with about 14,000 entries in it that I am trying to export to excel. I've run an export on this form before without any problems, but there were only about 1200 entries in the form then. When I try to export to excel now, it downloads an excel file after 30 seconds. When I open that file, the top row of says "Fatal error: Maximum execution time of 30 seconds exceeded in /path_to_machforms_install/lib/pear/Spreadsheet/Excel/Writer/Worksheet.php on line 1547. I looked at line 1547 of the file referenced, but all it says is $str = iconv($this->_input_encoding, 'UTF-16LE', $str);

   Does anyone have an idea of how to fix this so it doesn't time out after 30 seconds? I'm just assuming it's having trouble with it because there are so many entries.

   Thanks!

   Posted 15 years ago #
2. 

   yuniar

   Actually, this is the execution time limit being set by your hosting company.
   By default, PHP has time limit of 30 seconds.

   I suggest to contact your hosting tech support and ask them to raise the limit.
   They can do it by modifying the PHP configuration file and set the value of "max_execution_time"

   Also, try to export using CSV format instead of Excel, it should be faster.

   ---

   MachForm Founder

   Posted 15 years ago #

3. discosteve
   Member

   Thanks for your help - exporting to a CSV file instead of Excel worked fine.

   Thanks!

   Posted 15 years ago #

RSS feed for this topic

Reply

You must log in to post.