Using Database - Revision history

Tishkirkland: added another creative use for Database

2024-04-18T01:35:42Z

added another creative use for Database

← Older revision		Revision as of 01:35, 18 April 2024
Line 82:		Line 82:
	* provide a [http://moodle.org/mod/forum/discuss.php?d=52699 student file storage area]		* provide a [http://moodle.org/mod/forum/discuss.php?d=52699 student file storage area]
	* maintain a log of what was done in a face-to-face class each day, so that absent students can get caught up themselves. [http://moodle.org/mod/forum/discuss.php?d=115047 Example]		* maintain a log of what was done in a face-to-face class each day, so that absent students can get caught up themselves. [http://moodle.org/mod/forum/discuss.php?d=115047 Example]
			* add, track, and award points for CPD (or other external activity). [https://www.youtube.com/watch?v=LocVdShyErU Video demo]. [https://moodle.org/mod/forum/discuss.php?d=457599 Details].
	== See also ==		== See also ==
	*[https://school.moodledemo.net/course/view.php?id=57&section=1 Examples of databases in the School demo site] (available for download)		*[https://school.moodledemo.net/course/view.php?id=57&section=1 Examples of databases in the School demo site] (available for download)

Marcusgreen: /* See also */

2024-01-26T16:50:34Z

Marcusgreen: /* Fixed link to demo site showing database activities */

2024-01-26T16:48:27Z

Fixed link to demo site showing database activities

← Older revision		Revision as of 16:48, 26 January 2024
Line 85:		Line 85:
	*[https://school.moodledemo.org/course/view.php?id=57&section=3 Examples of databases in the School demo site] (available for download)		*[https://school.moodledemo.org/course/view.php?id=57&section=3 Examples of databases in the School demo site] (available for download)
	* [[Glossary module]], which performs a similar though more specialised, text-based role		* [[Glossary module]], which performs a similar though more specialised, text-based role
	* Moodle in English [~~http~~://~~moodle~~.~~org~~/~~mod/forum~~/view.php?id=~~3505~~ Database activity module forum]		* Moodle in English [https://school.moodledemo.net/course/view.php?id=57&section=1 Database activity module forum]
	* [https://moodle.org/mod/data/view.php?d=54 Moodle.org jobs database] - example of a database activity on Moodle.org.		* [https://moodle.org/mod/data/view.php?d=54 Moodle.org jobs database] - example of a database activity on Moodle.org.
	[[de:Datenbank nutzen]]		[[de:Datenbank nutzen]]
	[[es:Usando BasedeDatos]]		[[es:Usando BasedeDatos]]

Marycooch: include files when exporting

2023-11-10T12:45:02Z

include files when exporting

← Older revision		Revision as of 12:45, 10 November 2023
Line 53:		Line 53:

	[[File:DatabaseExportImport.png\|DatabaseExportImport.png]]		[[File:DatabaseExportImport.png\|DatabaseExportImport.png]]

			'''New in 4.3:''' When exporting entries, it is possible to include files.

	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.

Marycooch: /* Exporting entries */

2023-10-02T14:32:29Z

Exporting entries

← Older revision		Revision as of 14:32, 2 October 2023
Line 50:		Line 50:

	==Exporting entries==		==Exporting entries==
	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 "Export entries" link from the Actions menu when clicking on the 'Database activity.

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

	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.
Line 61:		Line 61:

	For information on converting the date export (and import) format, see the discussion [https://moodle.org/mod/forum/discuss.php?d=220505 Standard Database Module - Dates].		For information on converting the date export (and import) format, see the discussion [https://moodle.org/mod/forum/discuss.php?d=220505 Standard Database Module - Dates].

	==Enabling an RSS feed of recently added entries==		==Enabling an RSS feed of recently added entries==
	To enable an RSS feed from a database activity, an administrator must first enable RSS feeds for database activities across the whole site as described in [[RSS feeds settings]]. A section called 'RSS' will then appear on the edit settings page of the database activity.		To enable an RSS feed from a database activity, an administrator must first enable RSS feeds for database activities across the whole site as described in [[RSS feeds settings]]. A section called 'RSS' will then appear on the edit settings page of the database activity.

Marycooch: /* Importing many entries */

2023-10-02T14:30:51Z

Importing many entries

← Older revision		Revision as of 14:30, 2 October 2023
Line 25:		Line 25:

	==Importing many entries==		==Importing many entries==
	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 from the Actions menu when clicking on a Database activity.

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

	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.

	~~[[Image:Upload_csv_sample.png]]~~

	The expected file format is a plain text file with a list of field names as the first record. The data then follows, one record per line.		The expected file format is a plain text file with a list of field names as the first record. The data then follows, one record per line.
Line 50:		Line 48:
	After upload page import.php comes back blank if it failed.		After upload page import.php comes back blank if it failed.
	If successful you'll read a message like, "1 entries saved".		If successful you'll read a message like, "1 entries saved".

	==Exporting entries==		==Exporting entries==
	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.)

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

2023-04-03T06:41:55Z

Approving and undoing approval of entries

← Older revision		Revision as of 06:41, 3 April 2023
Line 20:		Line 20:
	Note: If you do not want particular text to be linked (in a forum posting, say) then you should add <nolink> and </nolink> tags around the text. Alternatively the filter can be disabled for a particular activity.		Note: If you do not want particular text to be linked (in a forum posting, say) then you should add <nolink> and </nolink> tags around the text. Alternatively the filter can be disabled for a particular activity.
	==Approving and undoing approval of entries==		==Approving and undoing approval of entries==
	~~{{New features}}~~
	If, during database set up, 'Approval required' was set to 'Yes' then a teacher can view entries pending approval and click the three dots to the right in order to approve them.		If, during database set up, 'Approval required' was set to 'Yes' then a teacher can view entries pending approval and click the three dots to the right in order to approve them.
	[[File:docsentryapproval.png\|600px\|center]]		[[File:docsentryapproval.png\|600px\|center]]

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

2022-11-21T11:55:12Z

Approving and undoing approval of entries

← Older revision		Revision as of 11:55, 21 November 2022
Line 20:		Line 20:
	Note: If you do not want particular text to be linked (in a forum posting, say) then you should add <nolink> and </nolink> tags around the text. Alternatively the filter can be disabled for a particular activity.		Note: If you do not want particular text to be linked (in a forum posting, say) then you should add <nolink> and </nolink> tags around the text. Alternatively the filter can be disabled for a particular activity.
	==Approving and undoing approval of entries==		==Approving and undoing approval of entries==
	If, during database set up, 'Approval required' was set to 'Yes' then a teacher can approve ~~an entry by clicking on the tick/checkmark icon~~.		{{New features}}
			If, during database set up, 'Approval required' was set to 'Yes' then a teacher can view entries pending approval and click the three dots to the right in order to approve them.
			[[File:docsentryapproval.png\|600px\|center]]

	~~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\|Approval undone]]~~
	\|}
	~~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]]~~
	\|}
	==Importing many entries==		==Importing many entries==
	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.

Marycooch: /* See also */

2021-09-07T17:08:40Z

Marycooch: /* Example databases */

2021-09-07T17:08:10Z

Example databases

← Older revision		Revision as of 17:08, 7 September 2021
Line 80:		Line 80:

	[[File:Exportdatabasentry.png]]		[[File:Exportdatabasentry.png]]
	~~== Example databases ==~~
	~~Moodle.org has two good examples of the database module in action:~~
	* [http://moodle.org/mod/data/view.php?id=6140 Moodle Buzz], a database of the titles, authors and web links to news articles mentioning Moodle
	== Creative uses ==		== Creative uses ==
	You could use the database module to:		You could use the database module to:
Line 94:		Line 91:
	* [[Glossary module]], which performs a similar though more specialised, text-based role		* [[Glossary module]], which performs a similar though more specialised, text-based role
	* 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]
			* [https://moodle.org/mod/data/view.php?d=54 Moodle.org jobs database] - example of a database activity on Moodle.org.
	[[de:Datenbank nutzen]]		[[de:Datenbank nutzen]]
	[[es:Usando BasedeDatos]]		[[es:Usando BasedeDatos]]

← Older revision		Revision as of 16:50, 26 January 2024
Line 83:		Line 83:
	* maintain a log of what was done in a face-to-face class each day, so that absent students can get caught up themselves. [http://moodle.org/mod/forum/discuss.php?d=115047 Example]		* maintain a log of what was done in a face-to-face class each day, so that absent students can get caught up themselves. [http://moodle.org/mod/forum/discuss.php?d=115047 Example]
	== See also ==		== See also ==
	*[https://school.moodledemo.~~org~~/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=1 Examples of databases in the School demo site] (available for download)
	* [[Glossary module]], which performs a similar though more specialised, text-based role		* [[Glossary module]], which performs a similar though more specialised, text-based role
	* Moodle in English [https://school.moodledemo.net/course/view.php?id=57&section=1 Database activity module forum]		* Moodle in English [https://school.moodledemo.net/course/view.php?id=57&section=1 Database activity module forum]

← Older revision		Revision as of 17:08, 7 September 2021
Line 88:		Line 88:
	* maintain a log of what was done in a face-to-face class each day, so that absent students can get caught up themselves. [http://moodle.org/mod/forum/discuss.php?d=115047 Example]		* maintain a log of what was done in a face-to-face class each day, so that absent students can get caught up themselves. [http://moodle.org/mod/forum/discuss.php?d=115047 Example]
	== See also ==		== See also ==
	*[https://school.moodledemo.~~net~~/course/view.php?id=57&section=3 Examples of databases in the School demo site] (available for download)		*[https://school.moodledemo.org/course/view.php?id=57&section=3 Examples of databases in the School demo site] (available for download)
	* [[Glossary module]], which performs a similar though more specialised, text-based role		* [[Glossary module]], which performs a similar though more specialised, text-based role
	* 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]