Note: You are currently viewing documentation for Moodle 3.8. Up-to-date documentation for the latest stable version of Moodle may be available here: Import and export FAQ.

Import and export FAQ: Difference between revisions

From MoodleDocs
(→‎How do I export a list of users?: ref to bulk user actions)
(→‎Other links: deleted out of date links)
Line 10: Line 10:
*Another way is is to export a list from the gradebook in a course. The fields you seem to get are:
*Another way is is to export a list from the gradebook in a course. The fields you seem to get are:
First name, Surname, ID number, Institution, Department, Email address, Course total
First name, Surname, ID number, Institution, Department, Email address, Course total
=== Other links ===
* 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? ==
== How do I import course data? ==

Revision as of 14:49, 5 March 2012

How do I import users?

How do I export a list of users?

  • Go to Settings>Site administration>Users>Accounts>Bulk user actions and select the users you wish to export. From the dropdown "With selected users", choose "download" and choose the type of file you wish to download from text, ODS or Excel.
  • Another way is is to export a list from the gradebook in a course. The fields you seem to get are:

First name, Surname, ID number, Institution, Department, Email address, Course total

How do I 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.
  • Yasu Imao's Moodle glossaryXMLconverter_html 4 A JavaScript based converter, works directly in your browser.

How do I import and export database entries?

See Building Database

How can I enable Excel export for students?

With the Database activity you have the ability to allow students to export all the data in the following formats: CSV, Excel and ODS (OpenDocument Spreadsheet from OpenOffice). ExportTab.png

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'. EnableExportView.png

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?

  • MoodleXMLBuilder converts commonly-used test generator output into Moodle XML. MoodleXMLBuilder currently supports converting tests and question banks created in Blackboard, ExamView, TestGen, and EZTest. Images are fully supported within all question fields where images are allowed within the Moodle quiz module.
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.
See GIFT format.
Here is a 2-column GIFT format reference sheet: GIFT Reference Sheet
  • Moodle XML - Moodle 'proprietary' xml format for import and export. Very comprehensive.


You find the complete list of supported formats under Import questions.

Which file formats can I use?

[TODO]

What encodings should I use?

The recommended standard encoding for all Moodle files is UTF-8.

Some of this information is collected at UTF-8 and BOM.

See also:

See also

Contributed modules and plugins