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

Database export: Difference between revisions

From MoodleDocs
No edit summary
No edit summary
Line 1: Line 1:
The [[Database_templates#List_template|list template]] can be used to export your database in the following way. It is assumed that you have a database with N fields, and that in this example the fields are named field1, field2 ... until fieldN.
The [[Database_templates#List_template|list template]] can be used to export your database as a CSV file in the following way. It is assumed that you have a database with N fields, and that in this example the fields are named field1, field2 ... until fieldN.


== Header ==
== Header ==

Revision as of 13:31, 25 October 2007

The list template can be used to export your database as a CSV file in the following way. It is assumed that you have a database with N fields, and that in this example the fields are named field1, field2 ... until fieldN.

Header

In the header create a comma separated list of the field names

field1,field2,...,fieldN

Repeated entry

In the repeated entry create a comma separated list of the field tags

[[field1]],[[field2]],...,[[fieldN]]

Save the template!

Export

To export, simply select the View List tab and all your data will be in the CSV format. By default only 10 records are displayed, but this can be increased. Copy and paste to your required tool.