Activities: Questionnaire

mod_questionnaire
Maintained by Picture of Mike Churchward Mike Churchward
Custom Survey Creation
10002 sites
6k downloads
117 fans
Build passing

Create your own surveys using this tool.

SUPPORT DISCUSSION: http://moodle.org/mod/forum/view.php?id=2642

NOTE: If you are upgrading to Moodle 2.3 or greater, make sure you have upgraded the questionnaire module to the latest version of Moodle 2.2, in your Moodle 2.2 codebase before upgrading to Moodle 2.3 or greater.

DEVELOPERS NOTE - Questionnaire is tracked in Github at https://github.com/remotelearner/moodle-mod_questionnaire. Contact Mike Churchward if you want "push" access.

(originally based on phpESP)

/plugins/mod

Screenshots

Screenshot #0

Contributors

Picture of Mike Churchward
Mike Churchward (Lead maintainer)
Picture of Joseph Rézeau
Joseph Rézeau: Former co-maintainer
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of Yackelyn Ayapan
    Wed, 2 May 2018, 11:03 PM
    I'm developing an Ajax function that works on each question. But I need to use a session variable to obtain the response selected for the question by the user. Where I can find this kind of documentation? or How can I obtain this session variables? Thank you.
  • Picture of Mike Churchward
    Thu, 3 May 2018, 11:41 PM
    @Yegor - Please repost your question in the questionnare forum - https://moodle.org/mod/forum/view.php?id=2642
  • Picture of Mike Churchward
    Thu, 3 May 2018, 11:41 PM
    @Yackelyn - Please repost your question in the questionnare forum - https://moodle.org/mod/forum/view.php?id=2642
  • Picture of Mimi Rothschild
    Mon, 4 Jun 2018, 5:29 AM
    I am looking to create a playlist or Learning Plan consisting of specific content WHEN a student answers a question in a Quiz or Questionnaire. Is this possible with your plug?
  • Picture of Meir Kirshner
    Tue, 17 Jul 2018, 10:44 AM
    Hi mike. is there a way to export to csv the summary results ?
  • Picture of Mike Churchward
    Tue, 17 Jul 2018, 8:42 PM
    Hi Meir. Yes, that is part of the standard function - https://docs.moodle.org/35/en/Questionnaire_module#Export_text_file.
    It is a tab when you are looking at the results.
  • Picture of Raymond Frangie
    Wed, 1 Aug 2018, 11:47 PM
    Hi Mike,

    There's a bug with this plugin in that it doesn't work with MySQL 8.0.12... Given that MySQL 8.0.x is now GA, any chance you can get this fixed? I'm using this on a live server now, the semester has started and we've only just picked up on this issue.

    One problem I found is that "rank" is now a reserved word, but got around that using backticks, however couldn't get the rest of it to work.

    Here's the debugging info...

    Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
    FROM wsu_moodle_cybersec_questionnaire_response qr
    ' at line 3
    SELECT CONCAT_WS('_', qr.id, 'checkboxes', qrm.id) AS id,
    qr.submitted, qr.complete, qr.grade, qr.userid, u.firstnamephonetic, u.lastnamephonetic, u.middlename, u.alternatename, u.firstname, u.lastname, u.username, u.department, u.institution, u.id as usrid, qr.id AS rid, qrm.question_id,
    qrm.choice_id, qro.response AS response, 0 AS rank
    FROM wsu_moodle_cybersec_questionnaire_response qr
    JOIN wsu_moodle_cybersec_questionnaire_resp_multiple qrm ON qrm.response_id = qr.id
    AND qr.survey_id = ? AND qr.complete = ?
    LEFT JOIN wsu_moodle_cybersec_questionnaire_response_other qro ON qro.response_id = qr.id AND qro.choice_id = qrm.choice_id
    LEFT JOIN wsu_moodle_cybersec_user u ON u.id = qr.userid
    WHERE qr.id = ? UNION ALL
    SELECT CONCAT_WS('_', qr.id, 'textbox', qrt.id) AS id,
    qr.submitted, qr.complete, qr.grade, qr.userid, u.firstnamephonetic, u.lastnamephonetic, u.middlename, u.alternatename, u.firstname, u.lastname, u.username, u.department, u.institution, u.id as usrid, qr.id AS rid, qrt.question_id,
    0 AS choice_id, qrt.response AS response, 0 AS rank
    FROM wsu_moodle_cybersec_questionnaire_response qr
    JOIN wsu_moodle_cybersec_questionnaire_response_text qrt
    ON qrt.response_id = qr.id
    AND qr.survey_id = ? AND qr.complete = ?
    LEFT JOIN wsu_moodle_cybersec_user u ON u.id = qr.userid
    WHERE qr.id = ? ORDER BY usrid, id
    [array (
    0 => '2',
    1 => 'y',
    2 => 3,
    3 => '2',
    4 => 'y',
    5 => 3,
    )]
    Error code: dmlreadexception
    Stack trace:
    line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
    line 1184 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
    line 2597 of /mod/questionnaire/questionnaire.class.php: call to mysqli_native_moodle_database->get_recordset_sql()
    line 2782 of /mod/questionnaire/questionnaire.class.php: call to questionnaire->get_survey_all_responses()
    line 1902 of /mod/questionnaire/questionnaire.class.php: call to questionnaire->generate_csv()
    line 1599 of /mod/questionnaire/questionnaire.class.php: call to questionnaire->response_send_email()
    line 277 of /mod/questionnaire/questionnaire.class.php: call to questionnaire->submission_notify()
    line 75 of /mod/questionnaire/complete.php: call to questionnaire->view()

    This server is

    Moodle 3.5.1+ (Build: 20180720)
    MySQL 8.0.12
    PHP 7.2.8.1.16.04.1.1

    Much appreciated!

    Cheers,
    Ray
  • Picture of Raymond Frangie
    Wed, 1 Aug 2018, 11:54 PM
    Mike - Never mind the "the rest of it" comment, it's only the backticks around the reserved word `rank` that i can tell is the issue. Adding those ticks there processes the command.

    Cheers,
    Ray
  • Picture of Mike Churchward
    Thu, 2 Aug 2018, 12:01 AM
    Hi Ray. Any chance you could post that as an issue either in the Moodle Tracker, or as a Github issue?
  • You either love it or you hate it
    Mon, 13 Aug 2018, 6:24 PM
    Did we get over this, my error

    Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
    FROM mdl_questionnaire_response qr
    JOIN mdl_que' at line 3

    SELECT CONCAT_WS('_', qr.id, 'checkboxes', qrm.id) AS id,
    qr.submitted, qr.complete, qr.grade, qr.userid, u.firstnamephonetic, u.lastnamephonetic, u.middlename, u.alternatename, u.firstname, u.lastname, u.username, u.department, u.institution, u.id as usrid, qr.id AS rid, qrm.question_id,
    qrm.choice_id, qro.response AS response, 0 AS rank
    FROM mdl_questionnaire_response qr
    JOIN mdl_questionnaire_resp_multiple qrm ON qrm.response_id = qr.id

    AND qr.survey_id = ? AND qr.complete = ?
    LEFT JOIN mdl_questionnaire_response_other qro ON qro.response_id = qr.id AND qro.choice_id = qrm.choice_id
    LEFT JOIN mdl_user u ON u.id = qr.userid

    ORDER BY usrid, id
    [array (
    0 => '18034',
    1 => 'y',
    )]
    Error code: dmlreadexception

    Cheers
  • Picture of Mike Churchward
    Tue, 14 Aug 2018, 3:46 AM
    I believe this is the reported issue - https://tracker.moodle.org/browse/CONTRIB-7420
  • Picture of Mike Churchward
    Wed, 29 Aug 2018, 9:05 PM
    Regarding the "rank" reserved word issue:
    The latest versions in the MOODLE_35_STABLE and MOODLE_34_STABLE branches have fix for this. You can get them from Github.

    https://github.com/PoetOS/moodle-mod_questionnaire/tree/MOODLE_35_STABLE
    https://github.com/PoetOS/moodle-mod_questionnaire/tree/MOODLE_34_STABLE
  • Picture of alain kerv
    Mon, 3 Sep 2018, 10:58 PM
    Hello,
    I made a questionnaire (Two sorts of questions : text and single response) which is deployed on a lot of courses (approximately 100). I must download every results on csv files. Is it possible to use an SQL request to recover all results ? If yes, have you a model ?
    Thanks,
    Alain
  • Picture of Yannick Vrolant
    Tue, 18 Sep 2018, 8:50 PM
    Hi,

    Thank you for this very useful plugin !

    I have noticed the possibility to save a draft and resume answering to the questionnaire, though I wonder if it would be possible to add a functionnality that would allow users who have already saved a draft to make a whole new submission (while keeping their previous answers as a separate draft). As of now, the only choice that is left when one has already saved a draft is to "resume participation" (and it is impossible to start a new one).

    However, the questionnaire model I have created will be filled by student advisors who will gather information from various students willing to apply for a program in our school. It may well happen that some students won't be able to provide full information to complete the questionnaire in one shot. Thus, I would like advisors to be able to start filling the information for student A (submission 1), save it as a draft, then fill in the full form for student B (submission 2) before resuming and completing the submission for student A (submission 1). I know this might sound quite challenging but nothing ventured, nothing gained ! smile

    Thanks for helping anyway !
    Best,

    Yannick
  • Picture of Yannick Vrolant
    Wed, 19 Sep 2018, 3:47 PM
    Hello again,

    I also wonder if it would be possible to add an "upload file" question type / field within questionnaires ? As a matter of fact, I would like users to be able to send a few PDF attachments while answering the questionnaire.

    Thanks for reading and helping !
    Best,

    Yannick
1 2 3 4 5 6 7 8 9
Please login to post comments