Using Database - Revision history

Tsala: /* See also */ removing out-of-date link

2019-10-22T14:25:47Z

Marycooch: changing school demo link

2019-09-02T10:48:22Z

changing school demo link

← Older revision		Revision as of 10:48, 2 September 2019
Line 131:		Line 131:
	== See also ==		== See also ==

	*[~~http~~://school.~~demo.moodle~~.net/course/view.php?id=57&section=3 Examples of databases in the School demo site] (available for download)		*[https://school.moodledemo.net/course/view.php?id=57&section=3 Examples of databases in the School demo site] (available for download)
	* [[Dataform module]], which is a major enhancement of the Database module with improved browsing, editing, searching and other features.		* [[Dataform module]], which is a major enhancement of the Database module with improved browsing, editing, searching and other features.
	* [[Glossary module]], which performs a similar though more specialised, text-based role		* [[Glossary module]], which performs a similar though more specialised, text-based role

Finns: /* Exporting entries */

2019-03-05T16:05:08Z

Exporting entries

← Older revision		Revision as of 16:05, 5 March 2019
Line 85:		Line 85:
	You can export entries either in CSV (comma separated values) or ODS (OpenOffice Calc) formats by clicking the tab at the top or by clicking the "Export entries" link under 'Database activity administration' in the Administration block in your course. (Both CSV and ODS formats can be opened with MS Excel.)		You can export entries either in CSV (comma separated values) or ODS (OpenOffice Calc) formats by clicking the tab at the top or by clicking the "Export entries" link under 'Database activity administration' in the Administration block in your course. (Both CSV and ODS formats can be opened with MS Excel.)

	[[File:Databasexport.png]]		[[File:Databasexport.png\|800px]]

	When using the CSV format, the user can select either the comma, semicolon, or tab to separate the fields. The selection of the proper character is important. If users select to use a comma to separate the fields and some of the fields contain data with commas then the number of columns is going to be misaligned and likely cause confusion.		When using the CSV format, the user can select either the comma, semicolon, or tab to separate the fields. The selection of the proper character is important. If users select to use a comma to separate the fields and some of the fields contain data with commas then the number of columns is going to be misaligned and likely cause confusion.

Finns: /* Importing many entries */

2019-03-05T14:21:06Z

Importing many entries

← Older revision		Revision as of 14:21, 5 March 2019
Line 55:		Line 55:
	You can import entries via a CSV file if you click the "Import entries" link under 'Database activity administration' in the Administration block of your course. CSV means Comma-Separated-Values and is a common format for text interchange.		You can import entries via a CSV file if you click the "Import entries" link under 'Database activity administration' in the Administration block of your course. CSV means Comma-Separated-Values and is a common format for text interchange.

	[[image:Databaseupload.png\|~~600px~~]]		[[image:Databaseupload.png\|800px]]

	The easiest way to determine the format of the text file is to manually add an entry to the database and then export it. The resulting export text file may then be edited and used for importing entries. Here's a sample of what a very simple file will look like.		The easiest way to determine the format of the text file is to manually add an entry to the database and then export it. The resulting export text file may then be edited and used for importing entries. Here's a sample of what a very simple file will look like.

Finns: /* Importing many entries */

2019-03-05T14:20:46Z

Importing many entries

← Older revision		Revision as of 14:20, 5 March 2019
Line 55:		Line 55:
	You can import entries via a CSV file if you click the "Import entries" link under 'Database activity administration' in the Administration block of your course. CSV means Comma-Separated-Values and is a common format for text interchange.		You can import entries via a CSV file if you click the "Import entries" link under 'Database activity administration' in the Administration block of your course. CSV means Comma-Separated-Values and is a common format for text interchange.

	[[image:Databaseupload.png]]		[[image:Databaseupload.png\|600px]]

	The easiest way to determine the format of the text file is to manually add an entry to the database and then export it. The resulting export text file may then be edited and used for importing entries. Here's a sample of what a very simple file will look like.		The easiest way to determine the format of the text file is to manually add an entry to the database and then export it. The resulting export text file may then be edited and used for importing entries. Here's a sample of what a very simple file will look like.

Marycooch: /* Approving and undoing approval of entries */

2017-12-14T06:56:34Z

Approving and undoing approval of entries

← Older revision		Revision as of 06:56, 14 December 2017
Line 44:		Line 44:
	Once an entry has been approved, it is possible to undo the approval by clicking the circle with a line through it icon.		Once an entry has been approved, it is possible to undo the approval by clicking the circle with a line through it icon.
	{\|		{\|
	\|[[File:~~26databaseunapprove~~.png\|thumb\|Entry approved]]		\|[[File:26databaseapprove.png\|thumb\|Entry approved]]
	\|[[File:~~26databaseapprove~~.png\|thumb\|Approval undone]]		\|[[File:26databaseunapprove.png\|thumb\|Approval undone]]
	\|}		\|}
	Entries waiting for approval may be highlighted for the teacher and the user who added the entry.		Entries waiting for approval may be highlighted for the teacher and the user who added the entry.

Moodle brent: /* Approving and undoing approval of entries */

2017-12-14T02:29:57Z

Approving and undoing approval of entries

← Older revision		Revision as of 02:29, 14 December 2017
Line 44:		Line 44:
	Once an entry has been approved, it is possible to undo the approval by clicking the circle with a line through it icon.		Once an entry has been approved, it is possible to undo the approval by clicking the circle with a line through it icon.
	{\|		{\|
	\|[[File:~~26databaseapprove~~.png\|thumb\|Entry approved]]		\|[[File:26databaseunapprove.png\|thumb\|Entry approved]]
	\|[[File:~~26databaseunapprove~~.png\|thumb\|Approval undone]]		\|[[File:26databaseapprove.png\|thumb\|Approval undone]]
	\|}		\|}
	Entries waiting for approval may be highlighted for the teacher and the user who added the entry.		Entries waiting for approval may be highlighted for the teacher and the user who added the entry.

Marycooch: new in 3.0 removed

2016-05-03T11:10:49Z

new in 3.0 removed

← Older revision		Revision as of 11:10, 3 May 2016
Line 47:		Line 47:
	\|[[File:26databaseunapprove.png\|thumb\|Approval undone]]		\|[[File:26databaseunapprove.png\|thumb\|Approval undone]]
	\|}		\|}
	~~{{New features}}~~Entries waiting for approval may be highlighted for the teacher and the user who added the entry.		Entries waiting for approval may be highlighted for the teacher and the user who added the entry.
	{\|		{\|
	\|[[File:database highlighting.png\|thumb\|Highlighted entry waiting for approval]]		\|[[File:database highlighting.png\|thumb\|Highlighted entry waiting for approval]]

Tsala: /* Exporting to an external portfolio */ ##export## tag

2016-01-27T19:27:56Z

Exporting to an external portfolio: ##export## tag

← Older revision		Revision as of 19:27, 27 January 2016
Line 108:		Line 108:
	==Exporting to an external portfolio==		==Exporting to an external portfolio==

	If an external [[Portfolios\|portfolio]] such as [[Mahara_portfolio\|Mahara]] has been enabled by the administrator then users have the option to export individual entries to that portfolio. They will see at the bottom of a database entry an "export" icon to click on and select the portfolio to export to:		If an external [[Portfolios\|portfolio]] such as [[Mahara_portfolio\|Mahara]] has been enabled by the administrator then users have the option to export individual entries to that portfolio if the ##export## tag is added to list and/or single templates. They will see at the bottom of a database entry an "export" icon to click on and select the portfolio to export to:

	[[File:Exportdatabasentry.png]]		[[File:Exportdatabasentry.png]]

Tsala: /* Approving and undoing approval of entries */ screenshot

2015-11-12T14:06:46Z

Approving and undoing approval of entries: screenshot

← Older revision		Revision as of 14:06, 12 November 2015
Line 43:		Line 43:

	Once an entry has been approved, it is possible to undo the approval by clicking the circle with a line through it icon.		Once an entry has been approved, it is possible to undo the approval by clicking the circle with a line through it icon.

	~~{{New features}}Entries waiting for approval are highlighted for the teacher and the user who added the entry.~~

	{\|		{\|
	\|[[File:26databaseapprove.png\|thumb\|Entry approved]]		\|[[File:26databaseapprove.png\|thumb\|Entry approved]]
	\|[[File:26databaseunapprove.png\|thumb\|Approval undone]]		\|[[File:26databaseunapprove.png\|thumb\|Approval undone]]
			\|}
			{{New features}}Entries waiting for approval may be highlighted for the teacher and the user who added the entry.
			{\|
			\|[[File:database highlighting.png\|thumb\|Highlighted entry waiting for approval]]
	\|}		\|}

← Older revision		Revision as of 14:25, 22 October 2019
Line 136:		Line 136:
	* [[Using Moodle book]] Chapter 12: Databases		* [[Using Moodle book]] Chapter 12: Databases
	* Moodle in English [http://moodle.org/mod/forum/view.php?id=3505 Database activity module forum]		* Moodle in English [http://moodle.org/mod/forum/view.php?id=3505 Database activity module forum]
	* [http://moodle.org/mod/data/view.php?rid=2424 Tracking Students' Reading with the Moodle Database Module] presentation

	[[de:Datenbank nutzen]]		[[de:Datenbank nutzen]]
	[[es:Usando BasedeDatos]]		[[es:Usando BasedeDatos]]