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

Import and export FAQ: Difference between revisions

From MoodleDocs
(→‎Which file formats can I use?: removed unanswered question :))
 
(33 intermediate revisions by 6 users not shown)
Line 1: Line 1:
{{Main page}}
== How do I import users? ==
== How do I import users? ==


* See [[Upload users]].
* See [[Upload 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 course data? ==
Line 9: Line 17:
==How do I import and export grades?==
==How do I import and export grades?==


*[[Grade import]] (for Moodle 1.9 onwards).
*[[Grade import]]  
*[[Grade export]]
*[[Grade export]]


Line 16: Line 24:
For details see [[Import glossary entries]].
For details see [[Import glossary entries]].


Two very useful tools are:
A useful tool is
* [http://www.irpens.co.uk/moodle/MoodleExcelToGlossary.xls David Fountain's Excel macro] An Excel workbook with macros to create an XML file.
* [http://moodle.org/mod/forum/discuss.php?d=91224&parent=489666 Yasu Imao's Moodle glossaryXMLconverter_html 4] A JavaScript based converter, works directly in your browser.
* [http://moodle.org/mod/forum/discuss.php?d=91224&parent=489666 Yasu Imao's Moodle glossaryXMLconverter_html 4] A JavaScript based converter, works directly in your browser.


== How do I import and export database entries? ==
== How do I import and export database entries? ==


See
See [[Building Database]]
* [[Database export]]
* [[Adding a database entry]]


=== How can I enable Excel export for students? ===
=== 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).
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.
[[Image:ExportTab.png]]
 
[[Image:studentdatabasexport.png]]


With this functionality students can choose to export the data of all fields or only of selected fields. (Picture fields cannot be exported.)
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'.
 
[[Image:EnableExportView.png]]
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''.
 
[[Image:studentdatabasepermissions.png]]


This will result in the 'Export' tab being visible to students in the Database activity.
This will result in the 'Export' tab being visible to students in the Database activity.
Line 43: Line 51:


* See [[Import questions]] and [[Export questions]].
* See [[Import questions]] and [[Export questions]].
* [http://vletools.com Moodle XML converter] Free online service to create quizzes and glossaries from existing files.


* '''OpenOffice''' template for creating questions in [[GIFT|GIFT format]]: http://moodle.org/mod/forum/discuss.php?d=20705&parent=168385
* '''OpenOffice''' template for creating questions in [[GIFT|GIFT format]]: http://moodle.org/mod/forum/discuss.php?d=20705&parent=168385


* '''MS Word''' template for creating questions in [[GIFT|GIFT format]]: http://www.soberit.hut.fi/sprg/resources/moodle/GiftConverter.html
* '''Excel''' to [[GIFT|GIFT format]] export tool: http://moodle.org/mod/forum/discuss.php?d=66660
* '''Excel''' to [[GIFT|GIFT format]] export tool: http://moodle.org/mod/forum/discuss.php?d=66660
* The complete list: [[GIFT#Word_processors_and_Spreadsheets_tools_that_create_GIFTs|Word processors and Spreadsheets tools that create GIFTs]]
* The complete list: [[GIFT#Word_processors_and_Spreadsheets_tools_that_create_GIFTs|Word processors and Spreadsheets tools that create GIFTs]]


* Importing "GIFT" format files: https://www.acquin.org/moodle/help.php?file=formatgift.html&module=quiz
* [http://moodle.org/mod/forum/user.php?id=726938&course=5 Eoin Campbell is working on a XSLT based import/export module for Word] - stay tuned!  
 
: See also his [http://www.moodle2word.net website for converting Moodle Questions into tables in a Microsoft Word file, and vice versa].
* [http://software.cristianoleoni.com/freebies/glossaryconv.php ATutor to Moodle converter] - see http://moodle.org/mod/forum/discuss.php?d=115338.
 
* [http://moodle.org/mod/forum/user.php?id=726938&course=5 Eoin Campbell is working on a XSLT based import/export module for Word] - stay tuned! See also his [http://www.moodle2word.net website for converting Moodle Questions into tables in a Microsoft Word file, and vice versa].


==Which formats are used for importing questions?==
=== 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:
If you want to create questions outside of Moodle these two text based formats might be the most important:
Line 68: Line 74:


You find the complete list of supported formats under [[Import questions]].
You find the complete list of supported formats under [[Import questions]].
== Which file formats can I use? ==


== What encodings should I use? ==
== What encodings should I use? ==
Line 76: Line 80:


* See [http://moodle.org/mod/forum/discuss.php?d=62251 Importing Entries Using a Text File] for an example where a UTF-8 file with [http://en.wikipedia.org/wiki/Byte-order_mark BOM] caused Database Activity entries not being imported. See also MDL-9075 ("User Upload Failure when file contains UTF-8 BOM").
* See [http://moodle.org/mod/forum/discuss.php?d=62251 Importing Entries Using a Text File] for an example where a UTF-8 file with [http://en.wikipedia.org/wiki/Byte-order_mark 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]].


See also:  
See also:  
Line 83: Line 88:


== See also ==
== See also ==
* Code to do database query: http://moodlever.blogspot.com/2011/01/how-to-get-student-list-of-course.html
* Search Moodle Forums [http://moodle.org/mod/forum/search.php?search=subject%3Aimport+&id=5 subject:import].
* Search Moodle Forums [http://moodle.org/mod/forum/search.php?search=subject%3Aimport+&id=5 subject:import].
* Search Moodle Forums [http://moodle.org/mod/forum/search.php?search=subject%3Aexport+&id=5 subject:export].
* Search Moodle Forums [http://moodle.org/mod/forum/search.php?search=subject%3Aexport+&id=5 subject:export].


*[[XML FAQ]]
*[[XML FAQ]]
*[[IMS Common Cartridge import]]


* There's an interesting project on [http://groups.drupal.org/node/21559 integrating Drupal and Moodle quizzes] in the Drupal in Education User Group.
* There's an interesting project on [http://groups.drupal.org/node/21559 integrating Drupal and Moodle quizzes] in the Drupal in Education User Group.
; Contributed modules and plugins
* [http://moodle.org/mod/forum/discuss.php?d=161367 DocBook Module to Parse DocBook XML]


[[Category:FAQ]]
[[Category:FAQ]]
[[de:Import und Export FAQ]]
[[de:Import und Export FAQ]]

Latest revision as of 15:43, 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.

A useful tool is

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 the data in CSV or ODS (OpenDocument Spreadsheet from OpenOffice) format, both of which will open up in MS Excel.

studentdatabasexport.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' from Settings>Database administration>Permissions.

studentdatabasepermissions.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?

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.

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