MoodleDocs - User contributions [en]

Import and export FAQ

2009-10-28T20:31:38Z

Mpretorius: /* How can I enable Excel export for students? */

== How do I import users? ==

* See [[Upload users]].

== How do I import course data? ==

* See [[Import course data]].

==How do I import and export grades?==

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

== How do I import glossary entries? ==

For details see [[Import glossary entries]].

Two very useful tools are:
* [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.

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

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

=== 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).
[[Image: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'.
[[Image:EnableExportView.png]]

This will result in the 'Export' tab being visible to students in the Database activity.

Also see [http://moodle.org/mod/forum/discuss.php?d=133712 this thread] for a discussion on this.

==How do I import and export questions?==

* See [[Import questions]] and [[Export questions]].

* '''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
* 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://software.cristianoleoni.com/freebies/glossaryconv.php ATutor to Moodle converter] - see http://moodle.org/mod/forum/discuss.php?d=115338.

==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: [http://buypct.com/gift_reference.pdf 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? ==

== What encodings should I use? ==

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

* 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 also:
* [http://morgretdesigns.wordpress.com/2008/03/07/changing-file-encoding-on-a-csv-with-openoffice-calc/ Changing File Encoding on a CSV with OpenOffice Calc]
* [http://www.internet-business-solutions.gr/lang-en/e-commerce/44-strategies/65-utf-8-csv UTF-8 CSV]
* [[:Category:UTF-8]]

== See also ==
* 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].

*[[XML FAQ]]

* There's an interesting project on [http://groups.drupal.org/node/21559 integrating Drupal and Moodle quizzes] in the Drupal in Education User Group.

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

Import and export FAQ

2009-10-28T20:30:30Z

Mpretorius: /* How can I enable Excel export for students? */

== How do I import users? ==

* See [[Upload users]].

== How do I import course data? ==

* See [[Import course data]].

==How do I import and export grades?==

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

== How do I import glossary entries? ==

For details see [[Import glossary entries]].

Two very useful tools are:
* [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.

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

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

=== 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).
[[Image: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 overide the student permissions for the Database activity and choose 'Allow' for the permission to 'View presets from all users'.
[[Image:EnableExportView.png]]

This will result in the 'Export' tab being visible to students in the Database activity.

Also see [http://moodle.org/mod/forum/discuss.php?d=133712 this thread] for a discussion on this.

==How do I import and export questions?==

* See [[Import questions]] and [[Export questions]].

* '''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
* 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://software.cristianoleoni.com/freebies/glossaryconv.php ATutor to Moodle converter] - see http://moodle.org/mod/forum/discuss.php?d=115338.

==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: [http://buypct.com/gift_reference.pdf 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? ==

== What encodings should I use? ==

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

* 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 also:
* [http://morgretdesigns.wordpress.com/2008/03/07/changing-file-encoding-on-a-csv-with-openoffice-calc/ Changing File Encoding on a CSV with OpenOffice Calc]
* [http://www.internet-business-solutions.gr/lang-en/e-commerce/44-strategies/65-utf-8-csv UTF-8 CSV]
* [[:Category:UTF-8]]

== See also ==
* 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].

*[[XML FAQ]]

* There's an interesting project on [http://groups.drupal.org/node/21559 integrating Drupal and Moodle quizzes] in the Drupal in Education User Group.

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

Import and export FAQ

2009-10-28T20:27:50Z

Mpretorius: /* How can I enable Excel export for students? */

== How do I import users? ==

* See [[Upload users]].

== How do I import course data? ==

* See [[Import course data]].

==How do I import and export grades?==

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

== How do I import glossary entries? ==

For details see [[Import glossary entries]].

Two very useful tools are:
* [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.

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

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

=== 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).
[[Image:ExportTab.png]]

With this functionality students can choose to export the data of all fields or only selected fields. (Picture fields cannot be exported.)

However, this feature is not enabled by default for students. You need to overide the student permissions for the Database activity and choose 'Allow' for the permission to 'View presets from all users'.
[[Image:EnableExportView.png]]

This will result in the 'Export' tab being visible to students in the Database activity.

Also see [http://moodle.org/mod/forum/discuss.php?d=133712 this thread] for a discussion on this.

==How do I import and export questions?==

* See [[Import questions]] and [[Export questions]].

* '''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
* 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://software.cristianoleoni.com/freebies/glossaryconv.php ATutor to Moodle converter] - see http://moodle.org/mod/forum/discuss.php?d=115338.

==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: [http://buypct.com/gift_reference.pdf 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? ==

== What encodings should I use? ==

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

* 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 also:
* [http://morgretdesigns.wordpress.com/2008/03/07/changing-file-encoding-on-a-csv-with-openoffice-calc/ Changing File Encoding on a CSV with OpenOffice Calc]
* [http://www.internet-business-solutions.gr/lang-en/e-commerce/44-strategies/65-utf-8-csv UTF-8 CSV]
* [[:Category:UTF-8]]

== See also ==
* 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].

*[[XML FAQ]]

* There's an interesting project on [http://groups.drupal.org/node/21559 integrating Drupal and Moodle quizzes] in the Drupal in Education User Group.

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

File:ExportTab.png

2009-10-28T20:25:51Z

Mpretorius: Showing the 'Export' tab for the Database activity

Showing the 'Export' tab for the Database activity

Import and export FAQ

2009-10-28T20:23:42Z

Mpretorius: /* How can I enable Excel export for students? */

== How do I import users? ==

* See [[Upload users]].

== How do I import course data? ==

* See [[Import course data]].

==How do I import and export grades?==

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

== How do I import glossary entries? ==

For details see [[Import glossary entries]].

Two very useful tools are:
* [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.

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

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

=== 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 this functionality students can choose to export the data of all fields or only selected fields. (Picture fields cannot be exported.)

However, this feature is not enabled by default for students. You need to overide the student permissions for the Database activity and choose 'Allow' for the permission to 'View presets from all users'.
[[Image:EnableExportView.png]]

This will result in the 'Export' tab being visible to students in the Database activity.

Also see [http://moodle.org/mod/forum/discuss.php?d=133712 this thread] for a discussion on this.

==How do I import and export questions?==

* See [[Import questions]] and [[Export questions]].

* '''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
* 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://software.cristianoleoni.com/freebies/glossaryconv.php ATutor to Moodle converter] - see http://moodle.org/mod/forum/discuss.php?d=115338.

==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: [http://buypct.com/gift_reference.pdf 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? ==

== What encodings should I use? ==

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

* 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 also:
* [http://morgretdesigns.wordpress.com/2008/03/07/changing-file-encoding-on-a-csv-with-openoffice-calc/ Changing File Encoding on a CSV with OpenOffice Calc]
* [http://www.internet-business-solutions.gr/lang-en/e-commerce/44-strategies/65-utf-8-csv UTF-8 CSV]
* [[:Category:UTF-8]]

== See also ==
* 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].

*[[XML FAQ]]

* There's an interesting project on [http://groups.drupal.org/node/21559 integrating Drupal and Moodle quizzes] in the Drupal in Education User Group.

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

File:EnableExportView.png

2009-10-28T20:15:55Z

Mpretorius: uploaded a new version of "Image:EnableExportView.png"

Screenshot of the 'View presets from all users'permission field

File:EnableExportView.png

2009-10-28T20:13:13Z

Mpretorius: Screenshot of the 'View presets from all users'permission field

Screenshot of the 'View presets from all users'permission field