Question formats: CSV format

qformat_csv
Maintained by Picture of Gopal SharmaGopal 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.
285 sites
223 downloads
22 fans
Current versions available: 1

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

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

Comments RSS

Show comments
  • Picture of Dinis Medeiros
    Wed, Jan 9, 2019, 8:21 PM
    GREAT and THANKS
  • Picture of Dinis Medeiros
    Thu, Jan 24, 2019, 9:57 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
    smile
  • Picture of Gopal Sharma
    Thu, Jan 24, 2019, 10:05 PM
    You're welcome! smile
  • Picture of Dinis Medeiros
    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!
  • Picture of Fikri Nazir
    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 !
  • Picture of Fikri Nazir
    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
  • Picture of Gopal Sharma
    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.
  • Picture of Fikri Nazir
    Sun, Feb 10, 2019, 6:15 AM
    Thank you very much, Sir :D
  • Picture of jishnu m
    Sun, Mar 17, 2019, 2:13 PM
    Thank you very much, Sir :D...
  • Picture of jishnu m
    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
  • Picture of Una Ikić
    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!
  • Picture of Neha Sharma
    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
  • Picture of Gopal 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.
  • Picture of radiyanto dekaprasetya
    Mon, Mar 9, 2020, 8:34 PM
    what about the 5 choices
  • Picture of Gopal Sharma
    Tue, Apr 21, 2020, 2:06 PM
    you will have to tweak the code for 5 choices.
1 2
Please login to post comments