Moodle plugins directory: Microsoft Word File Import/Export (Question Format) | Moodle.org
Microsoft Word File Import/Export (Question Format)
This plugin allows quiz questions to be imported from a Word file into Moodle. You can quickly write lots of questions in structured Word tables far more easily than in Moodle directly. The plugin also imports tables, images, and equations (when created using the Microsoft Office Equation Editor, not MathType/Wiris or the old Equation 3.0 editor). Equations are converted into MathML on import and displayed using the MathJax filter. You can also export questions from the Moodle question bank into structured tables in Word.
The table structure for each question supports all the question components (stem, answer options, option-specific and general feedback, hints, tags and question meta-data such as penalties, grades and other options). All the main question types except Numerical and Calculated questions are fully supported. Numerical and Calculated questions are exported, but cannot be imported.
The Cloze question syntax is particularly useful, as it does not require any knowledge of the arcane Moodle syntax; instead, use bold for drop-down menu items, and italic for fill-in text fields. See attached screenshot for an example.
Language support
Exported questions are labelled in the language of the current Moodle user interface, and the spell-check language is also set to the correct language. Similarly, questions can be imported in the same language, not just English. Both left-to-right and right-to-left languages (such as Arabic and Hebrew) are supported.
Equation support (import only)
Equations written using the Microsoft Equation Editor in Word can be imported into Moodle as MathML. This MathML is rendered within Moodle using the MathJax filter. Note that MathML equations in questions are not exported in a usable way.
Supporting Word templates
Word templates to go with the plugin can be downloaded from the demonstration website www.Moodle2Word.net, and are available for Word 2007 and 2010 (Windows), and Word 2011 (MacOSX).
Installation
The plugin can be installed by a Moodle Administrator using the standard Moodle plugin installation process.
Pre-requisites
- Check that your Moodle installation supports XSLT, and ideally HTMLTidy too. Log in as Administrator, go to Site Administration -> Server -> PHP info, and view the PHP configuration. Look for the package details for 'xsl'. If they are not present, then you will need to re-configure PHP and re-start the server.
- To enable XSLT and HTMLTidy on a Windows Moodle server, open your PHP configuration file (e.g. d:\winmoodle2\server\php\php.ini on Windows) and uncomment the lines containing "extension=php_xsl.dll". and "extension=php_tidy.dll" by removing the semi-colon before them, if present.
- On Linux platforms, you may need to create a symbolic link from the file , /etc/php5/apache2/mods-available/xsl.ini to , or /etc/php5/apache2/conf.d/20-xsl.ini. Change directory to /etc/php5/apache2/conf.d/, and use the command 'sudo ln -s ../../mods-available/xsl.ini 20-xsl.ini'. Alternatively, create a file /etc/php5/apache2/conf.d/xsl.ini containing the line
extension=xsl.so
Configuration instructions
- Go to any course question bank that contains at least 1 question, and choose the Export option.
- The File format list should contain the new option 'Microsoft Word table format'. Select this item, and choose any question category containing some questions.
- You will be prompted to save or open a Word file. Save it. By default it should have a .doc suffix. If no suffix is provided, you must add it in yourself to ensure Word recognises the file format.
- If you see the error message "You need the XSLT library installed in PHP to save this Word file" (xsltunavailable in non-English installations), then your Moodle installation is not configured to support exporting to Word format, and you will need to update it. See this forum thread.
- To import questions from a Word file, open the file you just exported, and save it to Word 2010 (.docx) format. Then go to the Question Import form, and you should see a new item in the File format list, 'Microsoft Word table format'. Select this item, choose the Word file you saved, and import it.
- If all goes well, your questions in the file should be imported into your course. If not, send me an email at help@moodle2word.net and I will try to help you out.
Limitations
- The number of questions you can import in a single Word file is limited by the amount of memory allocated for processes on your Moodle server, but should be at least 1,000 questions or more.
- When you export questions they are saved in an intermediate Word-compatible format in a file with a .doc suffix. You must then save the file to the standard Word format (with a .docx suffix).
Using a Word template to create and edit questions
To edit existing questions using Word, first export them into Word. If you want to create new questions, you should install a custom Word template on your PC to assist you. You can download this template from the test website www.Moodle2Word.net. This template contains commands to create new questions by means of inserting a specific structured table for each type.
Useful links
Screenshots
Thanks for this useful plugin
Thanks to rapid responsiveness to support us
Yifat Shaked
the plugin is great ,but when i am importing questions having images it is showing the following error :
Can not create file "5/user/draft/181962214/Picture1.dataimage;base64,AQAAAFgAAAAAAAAAAQAAAFMAAABcAAAAAAAAAAAAAADJCAAAnQkAACBFTUYAAAEAcBIAAF8AAAAGAAAAAAAAAAAAAAAAAAAAAAQAAAADAAAOAQAAywAAAEYAAAD8BgAA7gYAAEdESUMBAACAAAMAABwv2L8AAAAA1gYAAAEACQAAA2sDAAAIABwAAAAAABQAAAAmBg8AHgDBAAUAAAAV29yZA4ATWljcm9zb2Z0IFdvcmQFAAAACwIAAAAABQAAAAwCIwEKAQ0AAAD7AgAAAAAAAAAAAAAAAAAAAAAAAQAMBAAAAC0BAAAEAAAAAgEBABUAAAD7AtbAAAAAAAAkAEAAAAABEAAElRpbWVzIE5ldyBSb21hbgAAAAQAAAAtAQEABQAAAAkCAAAAAAQAAAACAQEAEAAAACYGDwAWAP8AACkAAADQAAAABgEAAOoAAAAJAAAA+gIAAAMAAAAAAAAAIgAEAAAALQECAAcAAAD8AgEAAAAAAAAABAAAAC0BAwAIAAAAJQMCACsA3AADAdwACQAAAPoCAAADAAAAAAAAACIABAAAAC0BBAAEAAAA8AECAAoAAAAlAwMA7gDnAAMB3ADuANIACQAAAPoCAAAAAAAAAAAAACIABAAAAC0BAgAEAAAA8AEEAAcAAAD8AgAAAAAABAAAAC0BBAAIAAAAJgYPAAYAwEAEAAAACYGDwAWAP8AAB8AAAACAAAAOAAAAN8AAAAJAAAA+gIAAAMAAAAAAAAAIgAEAAAALQEFAAQAAAAtAQMACAAAACUDAgArANwAKwAEAAkAAAD6AgAAAwAAAAAAAAAiAAQAAAAtAQYABAAAAPABBQAKAAAAJQMDADYAGQArAAQAIQAZAAQAAAAtAQIABAAAAPABBgAEAAAALQEEAAgAAAAmBg8ABgDAQAQAAAAJgYPABYAwAAUgAAADQAAADdAAAAOQAAAAkAAAD6AgAAAwAAAAAAAAAiAAQAAAAtAQUABAAAAC0BAwAIAAAAJQMCAFQANgDaADYABAAAAC0BAgAEAAAA8AEFAAQAAAAtAQQACAAAACYGDwAGAP8BABAAAAAmBg8AFgDAABSAAAANAAAANgAAAC6AAAACQAAAPoCBQAAAAAAACIABAAAAC0BBQAHAAAAAIAAAAAAAAAAAQAAAAtAQYABAAAAAYBAgAYAAAAJAMKANUAuADVALYA1QC2ANQAtQDUALUAyAC0AMcAtQDHALYAyAC3AMkAtwAcAAAAJAMMAL8AtgDAALYAwQC1AMEAtADAALMAuwCyALQAsACzALAAsgCxALIAsgCzALMAugC1ABwAAAAkAwwAqgCxAKsAsQCsALAArACvAKsArgCjAKsAoACpAJ8AqQCeAKoAngCrAJ8ArACiAK4AHAAAACQDDACXAKgAmACoAJkApwCZAKYAmAClAJcApQCOAJ8AjQCfAIwAoACMAKEAjQCiAJYAqAAYAAAAJAMKAIYAnQCHAJ0AiACcAIgAmwCHAJoAfQCSAHwAkgB7AJMAewCUAHwAlQAYAAAAJAMKAHUAjgB2AI8AdwCPAHgAjgB4AI0AcACDAG8AggBuAIIAbQCDAG0AhAAcAAAAJAMMAGgAfQBpAH4AagB+AGsAfQBrAHwAZQBzAGUAcgBkAHEAYwBxAGIAcgBiAHMAYgB0ABwAAAAkAwwAXgBrAF8AbABgAGwAYQBrAGEAagBgAGcAXABfAFsAXgBaAF4AWQBfAFkAYABdAGgAHAAAACQDDABXAFcAWABYAFkAWABaAFcAWgBWAFgATwBXAEoAVgBJAFUASQBUAEoAVABLAFUAUAAYAAAAJAMKAFMAQwBUAEQAVQBEAFYAQwBWAEIAVgA2AFUANQBUADUAUwA2AFMANwAEAAAABgEBAAQAAAAtAQIABAAAAC0BBAAIAAAAJgYPAAYAwEABAAAAC0BAwAEAAAALQEFAAcAAAAbBGEALAAfAPBAAAAC0BBAAEAAAALQECAAMAAAAeAAcAAAAWBGAALAAfAPBAAAAAIBAQAVAAAA+wLWwAAAAAAAJABAQAAAARAABJUaW1lcyBOZXcgUm9tYW4AOQAEAAAALQEHAAUAAAAUAiAACwAEAAAALgEBAA0AAAAyCiAACwABAAQAAAAAAAoBIwFwABUABAAAAC4BAAAFAAAAFAIAAAAABAAAAAIBAQAEAAAAJwHwQAAAAtAQMABAAAAC0BBQAHAAAAGwQjAdkA4QCrAAQAAAAtAQQABAAAAC0BAgADAAAAHgAHAAAAFgQiAdkA4QCrAAQAAAACAQEABAAAAC0BBwAFAAAACQIAAAAABQAAABQC4gC1AAQAAAAuAQEADQAAADIK4gC1AAEABAAAAAAACgEjAVYAGQAEAAAALgEAAAUAAAAUApRsKIEAAAAAgEBAAQAAAAnAfBAAAAC0BAAADAAAAAAAAABEAAAAMAAAACAAAAAsAAAAQAAAAVQAAAF0AAAAJAAAAEAAAAFUAAABdAAAACgAAABAAAAAAAAAAAAAAAAkAAAAQAAAACgEAACMBAAASAAAADAAAAAEAAAAmAAAAHAAAAAEAAAAAAAAAAwAAAAAAAAAAAAAAJQAAAAwAAAABAAAAJwAAABgAAAACAAAAAQAAAAAAAAAAAAAAJQAAAAwAAAACAAAAVwAAACQAAAAOAAAARgAAAFMAAABGAAAAAgAAACsA3AADAdwAJgAAABwAAAADAAAAAAAAAAMAAAAAAAAAAAAAACUAAAAMAAAAAwAAACgAAAAMAAAAAQAAACUAAAAMAAAAAwAAAFcAAAAoAAAATAAAAEMAAABTAAAASgAAAAMAAADuAOcAAwHcAO4A0gAmAAAAHAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAJQAAAAwAAAABAAAAKAAAAAwAAAADAAAAJgAAABwAAAADAAAAAAAAAAMAAAAAAAAAAAAAACUAAAAMAAAAAwAAACUAAAAMAAAAAgAAAFcAAAAkAAAADgAAAAEAAAAOAAAARgAAAAIAAAArANwAKwAEACYAAAAcAAAABAAAAAAAAAADAAAAAAAAAAAAAAAlAAAADAAAAAQAAAAoAAAADAAAAAMAAAAlAAAADAAAAAQAAABXAAAAKAAAAAsAAAABAAAAEQAAAAgAAAADAAAANgAZACsABAAhABkAJQAAAAwAAAABAAAAKAAAAAwAAAAEAAAAJgAAABwAAAAEAAAAAAAAAAMAAAAAAAAAAAAAACUAAAAMAAAABAAAACUAAAAMAAAAAgAAAFcAAAAkAAAAGwAAABEAAABGAAAAEQAAAAIAAABUADYA2gA2ACUAAAAMAAAAAQAAACgAAAAMAAAABAAAABMAAAAMAAAAAgAAACYAAAAcAAAABAAAAAUAAAAAAAAAAAAAAPwAlAAAADAAAAAQAAAAlAAAADAAAAAQAAIBWAAAARAAAAEAAAAA6AAAARAAAADsAAAAKAAAA1QC4ANUAtgDVALYA1AC1ANQAtQDIALQAxwC1AMcAtgDIALcAyQC3AFYAAABMAAAAOQAAADgAAAA+AAAAOgAAAAwAAACALYAwAC2AMEAtQDBALQAwACzALsAsgC0ALAAswCwALIAsQCyALIAswCzALoAtQBWAAAATAAAADIAAAA2AAAANwAAADkAAAAMAAAAqgCxAKsAsQCsALAArACvAKsArgCjAKsAoACpAJ8AqQCeAKoAngCrAJ8ArACiAK4AVgAAAEwAAAAtAAAAMwAAADEAAAA2AAAADAAAAJcAqACYAKgAmQCnAJkApgCYAKUAlwClAI4AnwCNAJ8AjACgAIwAoQCNAKIAlgCoAFYAAABEAAAAJwAAAC8AAAArAAAAMgAAAAoAAACGAJ0AhwCdAIgAnACIAJsAhwCaAH0AkgB8AJIAewCTAHsAlAB8AJUAVgAAAEQAAAAjAAAAKgAAACYAAAAuAAAACgAAAHUAjgB2AI8AdwCPAHgAjgB4AI0AcACDAG8AggBuAIIAbQCDAG0AhABWAAAATAAAAB8AAAAkAAAAIgAAACgAAAAMAAAAaAB9AGkAfgBqAH4AawB9AGsAfABlAHMAZQByAGQAcQBjAHEAYgByAGIAcwBiAHQAVgAAAEwAAAAcAAAAHgAAAB8AAAAjAAAADAAAAF4AawBfAGwAYABsAGEAawBhAGoAYABnAFwAXwBbAF4AWgBeAFkAXwBZAGAAXQBoAFYAAABMAAAAGwAAABcAAAAdAAAAHAAAAAwAAABXAFcAWABYAFkAWABaAFcAWgBWAFgATwBXAEoAVgBJAFUASQBUAEoAVABLAFUAUABWAAAARAAAABsAAAARAAAAGwAAABYAAAAKAAAAUwBDAFQARABVAEQAVgBDAFYAQgBWADYAVQA1AFQANQBTADYAUwA3ABMAAAAMAAAAAQAAACUAAAAMAAAABAAAACUAAAAMAAAAAgAAACsAAAAYAAAAAAAAAB8AAAApAAAAXgAAACUAAAAMAAAAAQAAACUAAAAMAAAAAAAAgFIAAABMAQAAAwAAANb8AAAAAAAAAAAAAAACQAQAAAAAAAARAABJUAGkAbQBlAHMAIABOAGUAdwAgAFIAbwBtAGEAbgAAAFma738hm+9xp7vfwCb8H8AAAAAAJvwfwEBAADwAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAgAAAP8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQEBAQEBAQEBAQAAJQAAAAwAAAADAAAAIQAAAAgAAAAeAAAAGAAAAP8fAAAALAAAAGAAAAAWAAAADAAAAAEAAAAbAAAAEAAAAAsAAAAgAAAAUgAAAEwBAAAFAAAA1vwAAAAAAAAAAAAAAAJABAAABAAAABEAAElQAaQBtAGUAcwAgAE4AZQB3ACAAUgBvAG0AYQBuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAQEBAQEBAQEBAAAlAAAADAAAAAUAAABUAAAAVAAAAAQAAAAKAAAACgAAABgAAAABAAAAR88GQbAoB0ELAAAAIAAAAAEAAABMAAAABAAAAAAAAAAAAAAACgEAACMBAABQAAAAcAAAABYAAAAWAAAADAAAAAAAAAAbAAAAEAAAAAAAAAAAAAAAIgAAAAwAAADJQAAAAwAAAAEAAAAJQAAAAwAAAACAAAAKwAAABgAAACsAAAA4QAAANUAAAAgAQAAJQAAAAwAAAABAAAAJQAAAAwAAAAAAACAIQAAAAgAAAAeAAAAGAAAAKsAAADhAAAA2QAAACIBAAAWAAAADAAAAAEAAAAbAAAAEAAAALUAAADiAAAAJQAAAAwAAAAFAAAAVAAAAFQAAAA6AAAASAAAAEEAAABWAAAAAQAAAEfPBkGwKAdBtQAAAOIAAAABAAAATAAAAAQAAAAAAAAAAAAAAAoBAAAjAQAAUAAAAFYAAAAZAAAAFgAAAAwAAAAAAAAAGwAAABAAAACwovlH8AACIAAAAMAAAA0sAAAAQAAAAAAAAAAUAAAAlAAAADAAAAA0AAIAoAAAADAAAAAMAAAAlAAAADAAAAAcAAIAoAAAADAAAAAEAAAAoAAAADAAAAAIAAAAlAAAADAAAAAcAAIAoAAAADAAAAAQAAAAlAAAADAAAAA0AAIAoAAAADAAAAAUAAAAOAAAAFAAAAAAAAAAQAAAAFAAAAA=="
Any Suggestion ?
Regards,
Mohseen Khan
I have facing this error.
The type of the file you selected (application/msword) does not match the type expected by this import format (application/vnd.openxmlformats-officedocument.wordprocessingml.document).
Am I missing something at the setting?
Thanks.
If you have an image in every question, then I suspect the exported file will be too large for Word to process. You would need to break up the output by exporting smaller numbers of questions. If all your questions are in 1 category, you'll need to split them into multiple categories and export each one separately.
Finally, if you export the questions OK, then you still need to post-process the Word file after saving it as .docx format in order to convert the image data back into images. You can download a Word template to do this from http://www.moodle2word.net/mod/resource/view.php?id=12. Unfortunately, Windows Defender believes this template contains a virus, as the code to convert base64 image data into a real image is incorrectly considered to be a virus. If running Windows 10, you would need to turn off virus-checking to download and run it.
Well, yes. The questions have images. Not all of them but many of them (360 questions). These are the errors I am getting: http://prntscr.com/epwvk7
http://prntscr.com/epwvy6
I sent you an email. Thanks!
I am getting this error "unable to upload file, no repository identified"
I uploaded the current version of the "moodle2WordInstaller_v3_4wd.docm" to Virustotal. 16 out of 58 antivirus-engines showed an alert (mostly for W97M.Bendis.BI, but also for Doc.Dropper.Agent-1669370 and a few others). Since Word-macros are now frequently used to distribute malware, I'm very much wondering whether it is safe to use the document...
Best,
Samuel
this is a fair point. If it is any help, the file is digitally signed by the company I work for. Unfortunately, I don't have the time or knowledge to keep all the anti-virus programmes happy with these Word templates. However, I have now added the 2 individual Word templates contained inside the Zip file, so that you can download and copy them to the correct folders. As far as I can tell, these files do not trigger virus warnings (yet, at least). Instructions on where to place them are also included (cf. www.moodle2word.net). Hope this helps.
Eoin Campbell