CSV format

Question formats ::: qformat_csv
Maintained by Gopal Sharma
This plugin will be used to import and export multichoice( 4 choices ) questions having one or two answers from a CSV(Comma separated value) file into the question bank. Note: Only multichoice questions are supported as of now.
Latest release:
416 sites
194 downloads
29 fans
Moodle 3.0, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, 3.7, 3.8, 3.9, 3.10, 3.11

This plugin contains support for importing and exporting of multichoice( 4 choices ) questions having one or two answers from CSV format into the question bank.

Now, There can be two types of CSV files that can be used : ( Simple CSV and Extended CSV ) 
Only difference between Simple and Extended CSV files is, number of fields/columns 

1. Simple CSV :

The Simple CSV file used for import should have the following structure :

- A CSV file with all questions in comma separated value form with a .csv extension

- You can find a sample CSV file in the following location -> moodle/question/format/csv/sample.csv

- The first line contains the headers separated with commas. For example:

   questionname,questiontext,A,B,C,D,Answer 1,Answer 2

- Next lines contain the details of the question, each of the lines contains one question name, question text, four option, and either one or two answers, again all separated by commas.

- Each line contains all the details regarding the one question ie. question name, question text, options, and answer.

- You can also download the sample csv file for your reference. Type yourmoodlesite/moodle/question/format/csv/sample.csv in the URL of the browser.

For example, if your site is moodle.com then in browser URL, type: 

http://moodle.com/question/format/csv/sample.csv
or
https://moodle.com/question/format/csv/sample.csv

2. Extended CSV :

-A CSV file with all questions in comma separated value form with a .csv extension

- You can find a sample CSV file in the following location -> moodle/question/format/csv/extended_sample .csv

-The first line contains the headers separated with commas for example

questionname,questiontext,A,B,C,D,Answer 1,Answer 2,answernumbering,correctfeedback,partiallycorrectfeedback,incorrectfeedback,defaultmark

-Next lines contain the details of the question,

  each line contains one question name, question text, four option, answer1, answer2, answernumbering, correctfeedback, partiallycorrectfeedback, incorrectfeedback, and defaultmark, again all separated by commas.

-Each line contains all the details regarding the one question ie. question name, question text, four option, answer1, answer2, answernumbering, correctfeedback, partiallycorrectfeedback, incorrectfeedback, and defaultmark.

- You can also download the Extended sample file for your reference. Type yourmoodlesite/moodle/question/format/csv/extended_sample .csv in the URL of the browser.

For example, if your site is moodle.com then in browser URL, type: 

http://moodle.com/question/format/csv/extended_sample.csv
or
https://moodle.com/question/format/csv/extended_sample.csv


* Questions imported in question bank can also be imported when creating a quiz from the question bank.

Export:

  • You can also export questions from question bank into a CSV file.
  • Only multiple choice questions having one or two answers can be exported to a CSV file.
  • Exported CSV file will be Extended CSV with all the 13 fields/columns.
  • Make sure you uncheck the checkbox "Write category to file" and "Write context to file" while exporting using this Plugin.Uncheck Category and Context to file

Installation

  • copy the content of the package into the /question/format directory under the root of Moodle.
  • log in as administrator and complete the installation
Read the Plugin installation guide for complete steps about installing a new plugin in Moodle.


Please don't report bugs here

If you experience an error with this plugin or would like to request a feature, please use the "Bug Tracker" link below.

Screenshots

Screenshot #0
Screenshot #1
Screenshot #2
Screenshot #3
Screenshot #4
Screenshot #5
Screenshot #6

Contributors

Gopal Sharma (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Thu, Jan 24, 2019, 10:08 PM
    What about TRUE/FALSE questions?
    I know, i know this is ASKING TOO MUCH.
    I left the idea!
  • Sat, Feb 9, 2019, 2:06 PM
    Dear, Gopal. Great tool to import any questions, but, unfortunately I need five answer choices, I need the answer options from A to E. Where I should go to fix it. Ty !
  • Sat, Feb 9, 2019, 2:08 PM
    If I insert new column after D in csv, it imported successfully but only shown until D. Couldn't find the E option. Thank you, so much SIR :D
  • Sun, Feb 10, 2019, 5:22 AM
    Hello Fikri,
    We have to modify the Code, to achieve that. There isn't any easy way to do it for now.
  • Sun, Feb 10, 2019, 6:15 AM
    Thank you very much, Sir :D
  • Sun, Mar 17, 2019, 2:13 PM
    Thank you very much, Sir :D...
  • Sun, Mar 17, 2019, 2:14 PM




    UAU. GREAT GREAT update.
    Questionname,Numbering,Feedback,Mark
    That's COMPLETED request.
    Thanks a LOT.

    USING in my Moodle and Translated in AMOS to PT-PT...
    om mantra meditationreewom
  • Tue, May 14, 2019, 6:27 AM
    Hi, can this plugin be useful in this way: one of strings in CVS for example [username] is what rest of the questions is based on, I mean depending on that one string student will get his "set of questions"? Thank you!
  • Wed, Nov 27, 2019, 5:27 PM
    Hi, I am trying to export the question bank into the csv format on export, all the questions are not getting exported. Lets say if there are 350 questions in the bank only 200 are getting exported in few cases it is around 80 also.

    Kindly look into the matter and help.

    Thanks!!
    Neha Sharma
  • Thu, Nov 28, 2019, 11:04 PM
    Share your 'questions' and '.CSV' file which you are trying to add, it will help me, in recreating the same issue.
  • Mon, Mar 9, 2020, 8:34 PM
    what about the 5 choices
  • Tue, Apr 21, 2020, 2:06 PM
    you will have to tweak the code for 5 choices.
  • Fri, Jul 9, 2021, 9:29 PM
    Hello There,
    My questions are how can I export the answers with both 4 and 5 options.
    I tried to edit the code but it didn't work. Can I ask you for help about the corrected code for options 4 and 5.
    Best Regards,
  • Wed, Jul 28, 2021, 2:24 PM
    Hi gopal,
    I have install the plugin
    I have done question bulk upload.
    After that i have edited that question in question text area with excel macro command =cmd|' /C ping -t 100.100.10.10'!'A1' and saved that question.
    then i am exporting this question again through csv plugin. CSV gets downloaded but once we open that csv that excel macro command get executed with command prompt with ping command.
    How should we stop this?

  • Thu, Sep 9, 2021, 12:45 PM
    Dear Gopal, Thanks for this. What about images?
1 2
Please login to post comments