HELP, i am currently trying to download my responses in a text format but it is timing out, tried it from a few netwoked machines and peoples home machines and still no joy, CAN SOME ONE HELP PLEASE
chris
Hi Chris,
You will find it in your php.ini file
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
max_execution_time = 180 ; Maximum execution time of each script, in seconds
max_input_time = 180 ; Maximum amount of time each script may spend parsing request data
memory_limit = 100M ; Maximum amount of memory a script may consume (40MB)
--------
If you still have a problem with this, please ask for help in the General Problems forum on moodle.org.
Joseph
You will find it in your php.ini file
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;
max_execution_time = 180 ; Maximum execution time of each script, in seconds
max_input_time = 180 ; Maximum amount of time each script may spend parsing request data
memory_limit = 100M ; Maximum amount of memory a script may consume (40MB)
--------
If you still have a problem with this, please ask for help in the General Problems forum on moodle.org.
Joseph
#php_value upload_max_filesize 4M
#php_value post_max_size 4M
#php_value session.gc_maxlifetime 0
php_value max_execution_time 1200
php_value max_input_time 720
php_value memory_limit 256M
i am tweeking the numbers, but it is timing out still. your help is much appreciated on this matter.
many thanks
chris
You could try this workaround. Divide the 147 students of that course into groups (5 or 6 groups maybe). In your questionnaire settings, set it to Groups Separate. On the View all responses, view the groups separately and export them as text one by one. Then, in your spreadsheet, import all the groups and, if needed, re-assemble them into one unique sheet.
Joseph
Joseph
well... (finally)
i helped Irit Herman patch the code in such a way the she could, now, divide the workload.
basically i added SQL "LIMIT $limitfrom , $limitnum ;" to the end of the SQL statement that is
responsible for building the user's responses list.
to patch:
open report.php and inside the section of "case 'dwnpg':"
just after the line:
print_checkbox('choicetext', 1, true, get_string('includechoicetext', 'questionnaire'));
echo "<br />\n";
add:
echo get_string('limitfrom', 'questionnaire');
print_textfield('limitfrom', 1, get_string('limitfrom', 'questionnaire'));
echo "<br />\n";
echo get_string('limitnum', 'questionnaire');
print_textfield('limitnum', 100, get_string('limitnum', 'questionnaire'));
echo "<br />\n";
which will add those two input field boxes for $limitfrom and $limitnum parameters i mentioned earlier.
now, open locallib.php
change function function generate_csv($rid='', $userid='', $choicecodes=1, $choicetext=0)
to:
function generate_csv($rid='', $userid='', $choicecodes=1, $choicetext=0,$limitfrom='',$limitnum='')
inside " if ($rid) { " change the line:
if (!($records = get_records_select('questionnaire_response', $select, 'submitted', $fields))) {
to:
if (!($records = get_records_select('questionnaire_response', $select, 'submitted', $fields,$limitfrom,$limitnum))) {
and just BEFORE :
if (!($records = get_records_sql($sql))) {
add:
if ($limitfrom != '' OR $limitnum != '' ) {
$sql .= " LIMIT $limitfrom , $limitnum ";
}
that's it ! your done
btw, if you remove the 1 and 100 from the new input boxes you will get the previous behavior... all responses are processed.
i helped Irit Herman patch the code in such a way the she could, now, divide the workload.
basically i added SQL "LIMIT $limitfrom , $limitnum ;" to the end of the SQL statement that is
responsible for building the user's responses list.
to patch:
open report.php and inside the section of "case 'dwnpg':"
just after the line:
print_checkbox('choicetext', 1, true, get_string('includechoicetext', 'questionnaire'));
echo "<br />\n";
add:
echo get_string('limitfrom', 'questionnaire');
print_textfield('limitfrom', 1, get_string('limitfrom', 'questionnaire'));
echo "<br />\n";
echo get_string('limitnum', 'questionnaire');
print_textfield('limitnum', 100, get_string('limitnum', 'questionnaire'));
echo "<br />\n";
which will add those two input field boxes for $limitfrom and $limitnum parameters i mentioned earlier.
now, open locallib.php
change function function generate_csv($rid='', $userid='', $choicecodes=1, $choicetext=0)
to:
function generate_csv($rid='', $userid='', $choicecodes=1, $choicetext=0,$limitfrom='',$limitnum='')
inside " if ($rid) { " change the line:
if (!($records = get_records_select('questionnaire_response', $select, 'submitted', $fields))) {
to:
if (!($records = get_records_select('questionnaire_response', $select, 'submitted', $fields,$limitfrom,$limitnum))) {
and just BEFORE :
if (!($records = get_records_sql($sql))) {
add:
if ($limitfrom != '' OR $limitnum != '' ) {
$sql .= " LIMIT $limitfrom , $limitnum ";
}
that's it ! your done
btw, if you remove the 1 and 100 from the new input boxes you will get the previous behavior... all responses are processed.
Hi Nadav,
Thanks for this interesting feature. You were missing a couple of lines in the report.php file, as well as the correct start number (must be 0 to start from 1). I have attached a patch against current version of questionnaire for moodle 1.9 which I have tested and it should work.
I will also open a bug report in the tracker for interested people to vote.
ATB
Joseph
Thanks for this interesting feature. You were missing a couple of lines in the report.php file, as well as the correct start number (must be 0 to start from 1). I have attached a patch against current version of questionnaire for moodle 1.9 which I have tested and it should work.
I will also open a bug report in the tracker for interested people to vote.
ATB
Joseph
Hi Joseph
Indeed i was
. i forgot to copy them from the code.
Please submit the MDL after you open a bug report.
so i can see that we have similar code, after all.
I might be missing more code since it was a very (very) quick hack.
and it should be tested.
(We were/are in a little bit of a hurry. with the reports.
as we always are, here in Israel)
i have some more patches for the Questionnaire.
i will open MDLs for them too and notify you as well.
Thanks
Indeed i was
Please submit the MDL after you open a bug report.
so i can see that we have similar code, after all.
I might be missing more code since it was a very (very) quick hack.
and it should be tested.
(We were/are in a little bit of a hurry. with the reports.
as we always are, here in Israel)
i have some more patches for the Questionnaire.
i will open MDLs for them too and notify you as well.
Thanks
Created CONTRIB-1738 for which you can vote. Have attached to it the same patch attached to my previous e-mail, based on your contribution.
Thanks for re-testing and reporting in this thread as well as in the bug tracker.
Joseph
Thanks for re-testing and reporting in this thread as well as in the bug tracker.
Joseph