Trying download 7000 questionnaire data(6 fields each), server timeout is too low. Is there other way to download data?

Comments

quicksketch’s picture

You can try increasing the memory and timeout limits on your PHP installation. You can define these settings in settings.php (in sites/all/default), in the .htaccess file, or in php.ini

max_execution_time = 60     ; Maximum execution time of each script, in seconds
max_input_time = 60            ; Maximum amount of time each script may spend parsing request data
memory_limit = 128M      ; Maximum amount of memory a script may consume (8MB)
quicksketch’s picture

Title: Downloads break(to many records) » Downloads break (too many records)
Assigned: TAPAKAH » Unassigned
Category: bug » support
Priority: Critical » Normal
Status: Active » Fixed

Closing after lack of response.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

q0rban’s picture

Version: 6.x-2.0-beta6 » 6.x-2.x-dev
Category: support » feature
Status: Closed (fixed) » Active

Is there a way we can have this export in batches? I have over 36,000 submissions I need to download, and it makes sense that it shouldn't be trying to do this all in one go.

q0rban’s picture

Two other possible solutions would be to have a textfield to specify which records to download say records 0-999, 1000-1999 or a drush command for exporting.

robbertnl’s picture

Subscribing, same issues. 120 sec and 200mb memory is not enough for over 4000 subscriptions

Iowagirl’s picture

Subscribing, same issue.

quicksketch’s picture

Status: Active » Closed (duplicate)

This should be merged with #381068: Start and End Dates Needed for Submissions Export. I should also note the threshold for downloading in the 3.x version should be higher, after we added #423350: Improve efficiency of options in select.inc and other caching to the token replacement.