Import and export FAQ
Note: You are currently viewing documentation for Moodle 2.1. Up-to-date documentation for the latest stable version is available here: Import and export FAQ.
- 1 How do I import users?
- 2 How do I export a list of users?
- 3 How do I import course data?
- 4 How do I import and export grades?
- 5 How do I import glossary entries?
- 6 How do I import and export database entries?
- 7 How do I import and export questions?
- 8 What encodings should I use?
- 9 See also
How do I import users?
- See Upload users.
How do I export a list of users?
One way is to export a list from gradebook. The fields you seem to get are: First name, Surname, ID number, Institution, Department, Email address, Course total
- Tracker item, download list of users: http://tracker.moodle.org/browse/MDL-5669
- Tracker item, exporting username: http://tracker.moodle.org/browse/MDL-16593
- Discussion: http://moodle.org/mod/forum/discuss.php?d=75200
- Discussion: http://moodle.org/mod/forum/discuss.php?d=105370
- Hack to export PDF list: http://moodle.org/mod/forum/discuss.php?d=34222
- Code to do database query: http://moodlever.blogspot.com/2011/01/how-to-get-student-list-of-course.html
How do I import course data?
- See Import course data.
How do I import and export grades?
How do I import glossary entries?
For details see Import glossary entries.
Very useful tools are:
- Moodle XML converter Convert your glossary online just uploading your text and get Moodle XML file to import entries. Supports all glossary options, different types of input entries - Excel, concept - definition, Concept <break> definition, and some others. Also can convert from Moodle XML to text.
- David Fountain's Excel macro An Excel workbook with macros to create an XML file.
How do I import and export database entries?
How can I enable Excel export for students?
With the Database activity you have the ability to allow students to export the data in CSV or ODS (OpenDocument Spreadsheet from OpenOffice) format, both of which will open up in MS Excel.
With this functionality students can choose to export the data of all fields or only of selected fields. (Picture fields cannot be exported.)
However, this feature is not enabled by default for students. You need to override the student permissions for the Database activity and choose 'Allow' for the permission to 'View presets from all users' from Settings>Database administration>Permissions.
This will result in the 'Export' tab being visible to students in the Database activity.
Also see this thread for a discussion on this.
How do I import and export questions?
- Moodle XML converter Free online service to create quizzes and glossaries from existing files.
- OpenOffice template for creating questions in GIFT format: http://moodle.org/mod/forum/discuss.php?d=20705&parent=168385
- Excel to GIFT format export tool: http://moodle.org/mod/forum/discuss.php?d=66660
- The complete list: Word processors and Spreadsheets tools that create GIFTs
- See also his website for converting Moodle Questions into tables in a Microsoft Word file, and vice versa.
Which formats are used for importing questions?
If you want to create questions outside of Moodle these two text based formats might be the most important:
- GIFT - Moodle 'proprietary' text format for import and export. Reasonably comprehensive.
- Moodle XML - Moodle 'proprietary' xml format for import and export. Very comprehensive.
You find the complete list of supported formats under Import questions.
What encodings should I use?
The recommended standard encoding for all Moodle files is UTF-8.
- See Importing Entries Using a Text File for an example where a UTF-8 file with BOM caused Database Activity entries not being imported. See also MDL-9075 ("User Upload Failure when file contains UTF-8 BOM").
- Some of this information is collected at UTF-8 and BOM.
- There's an interesting project on integrating Drupal and Moodle quizzes in the Drupal in Education User Group.
- Contributed modules and plugins