Moodle Plugins directory: CSV format | Moodle.org
CSV format
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.
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
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.
I know, i know this is ASKING TOO MUCH.
I left the idea!
We have to modify the Code, to achieve that. There isn't any easy way to do it for now.
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
Kindly look into the matter and help.
Thanks!!
Neha Sharma
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,
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?