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.
139 sites
286 downloads
13 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 may aldaenee
    Tue, Sep 4, 2018, 5:57 PM
    please i put the questions in excel file as you explain and save it as csv file, but it didn't work .. it give me the error when i imported it to moodle
    Parsing questions from import file.
    Upload failed. New Line found in Question 1 . Make sure that entire question with choices and answers are in one line itself.
    Please correct this question and try importing again.
    No Question has been improted.
    × There are no questions in the import file
  • Picture of Gopal Sharma
    Tue, Sep 4, 2018, 6:37 PM
    may,
    Following are a few options which you can try out
    1. Are you able to download a sample CSV file? if yes, then replace your question's text and options and answer in the same file itself.
    2. Open your CSV files and see if the structure is same as found in the sample csv file.
    3. Headers and Questions along with options and answer should be on the different line.
  • Picture of Dinis Medeiros
    Sun, Jan 6, 2019, 3:03 AM
    Is it possible add a name to question NOT 1 , 2 ...?
    Is it possible have a chance to choose NOT NUMBERING choices?
    GREAT plugin.
  • Picture of Gopal Sharma
    Wed, Jan 9, 2019, 3:33 PM
    @Dinis
    1. As of now, you can not add a name to a question.
    2. NUMBERING choices are set to default "abc" ---> a., b., c., ...

    But in the upcoming update, I will put up 2 sample CSV files.
    One sample CSV with very few columns, similar to what we have now.
    And second, will have extended columns with many other columns including NUMBERING Choices,
    For example, a user can put up the values in "answernumbering" Columns in CSV file as follows for NUMBERING Choices,
    "abc" for-> a., b., c., ...
    "ABCD" for-> A., B., C., ...
    "123" for-> 1., 2., 3., ...
    "iii" for-> i., ii., iii., ...
    "IIII" for-> I., II., III., ...
    "none" for->No numbering
    I hope this is what you are expecting.
    Cheers.
  • 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!
1 2
Please login to post comments