Using Database - Versionshistorik

Marycooch: /* See also */

2021-09-07T17:08:40Z

Marycooch: /* Example databases */

2021-09-07T17:08:10Z

Example databases

← Äldre version		Versionen från 7 september 2021 kl. 17.08
Rad 80:		Rad 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:
Rad 94:		Rad 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]]

Marycooch: /* Example databases */ removed old link

2021-09-07T17:05:54Z

Example databases: removed old link

Marycooch: WIP updating this page as part of docs improvement project

2020-09-01T07:37:18Z

WIP updating this page as part of docs improvement project

← Äldre version		Versionen från 1 september 2020 kl. 07.37
Rad 1:		Rad 1:
	{{Database}}		{{Database}}
			This page explores ways the [[Database activity]] may be used in your Moodle course.
	==Views==		==Views==

Rad 14:		Rad 15:
	[[Image:26databaseview.png]]		[[Image:26databaseview.png]]

	~~=== View single ===~~

	~~Alternatively, you may view only one entry at a time. This might allow you to view more detailed information than the list view.~~

	~~=== Add comment ===~~

	~~If comments have been enabled, you may add a comment.~~

	~~=== Rate entries ===~~

	~~If ratings have been enabled, and made viewable, by the database editor, you may [[Grades\|grade]] other database entries, and view these ratings.~~

	~~==Adding an entry==~~

	~~Go to the "Add entry" tab and fill in the form.~~
	===Deleting multiple entries===		===Deleting multiple entries===

Rad 132:		Rad 119:

	*[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.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.
	* [[Glossary module]], which performs a similar though more specialised, text-based role		* [[Glossary module]], which performs a similar though more specialised, text-based role
	* [[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]

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

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

← Äldre version		Versionen från 2 september 2019 kl. 10.48
Rad 131:		Rad 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

← Äldre version		Versionen från 5 mars 2019 kl. 16.05
Rad 85:		Rad 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

← Äldre version		Versionen från 5 mars 2019 kl. 14.21
Rad 55:		Rad 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

← Äldre version		Versionen från 5 mars 2019 kl. 14.20
Rad 55:		Rad 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

← Äldre version		Versionen från 14 december 2017 kl. 06.56
Rad 44:		Rad 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.

← Äldre version		Versionen från 7 september 2021 kl. 17.08
Rad 88:		Rad 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]

← Äldre version		Versionen från 7 september 2021 kl. 17.05
Rad 2:		Rad 2:
	This page explores ways the [[Database activity]] may be used in your Moodle course.		This page explores ways the [[Database activity]] may be used in your Moodle course.
	==Views==		==Views==

	===View list===		===View list===

	The list view shows multiple entries, possibly in a more abbreviated form to ensure all the information fits. You may use the controls at the bottom of the screen to search and sort the contents.		The list view shows multiple entries, possibly in a more abbreviated form to ensure all the information fits. You may use the controls at the bottom of the screen to search and sort the contents.

	* ''View single'': one item at a time		* ''View single'': one item at a time
	* ''View list'' : several items at a time (number is user defined)		* ''View list'' : several items at a time (number is user defined)
	* ''Add entry'' : add an item to the database		* ''Add entry'' : add an item to the database
	* ''Search'' : search the entries		* ''Search'' : search the entries


Rad 17:		Rad 14:

	===Deleting multiple entries===		===Deleting multiple entries===

	In List view, a checkbox will appear next to each entry. Select the entries you wish to delete and click the 'Delete selected' button. Alternatively, click the 'Select all' and the 'Delete all' buttons to delete all entries. A warning message will appear asking you to verify what you wish to delete.		In List view, a checkbox will appear next to each entry. Select the entries you wish to delete and click the 'Delete selected' button. Alternatively, click the 'Select all' and the 'Delete all' buttons to delete all entries. A warning message will appear asking you to verify what you wish to delete.

	==Automatically linking database entries==		==Automatically linking database entries==

	If the [[Database auto-linking filter]] is enabled, any entries in a database will be automatically linked to where the concept words and/or phrases appear within the same course. This includes forum postings, internal resources, week summaries etc.		If the [[Database auto-linking filter]] is enabled, any entries in a database will be automatically linked to where the concept words and/or phrases appear within the same course. This includes forum postings, internal resources, week summaries etc.

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

Rad 38:		Rad 31:
	\|[[File:database highlighting.png\|thumb\|Highlighted entry waiting for approval]]		\|[[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.
Rad 55:		Rad 47:

	Sample file:		Sample file:

	name,height,weight		name,height,weight
	Kai,180cm,80kg		Kai,180cm,80kg
	Kim,170cm,60kg		Kim,170cm,60kg
	Koo,190cm,20kg		Koo,190cm,20kg

	Note: Certain field types may not be supported.		Note: Certain field types may not be supported.

	Do not put spaces after your commas or upload will fail!		Do not put spaces after your commas or upload will fail!

	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.)

Rad 81:		Rad 69:

	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.

	# Edit the database activity settings and set the number of entries in the RSS feed e.g. 5.		# Edit the database activity settings and set the number of entries in the RSS feed e.g. 5.
	# Check that the RSS template includes the required fields.		# Check that the RSS template includes the required fields.
	# Log out and then access the database activity as a guest.		# Log out and then access the database activity as a guest.
	# Copy the 'RSS feed for this activity' link in the administration block.		# Copy the 'RSS feed for this activity' link in the administration block.

	The RSS feed may then be displayed in an [[Remote RSS feeds block]] or elsewhere.		The RSS feed may then be displayed in an [[Remote RSS feeds block]] or elsewhere.

	==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 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:		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]]

	== Example databases ==		== Example databases ==

	Moodle.org has two good examples of the database module in action:		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		* [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
	* [http://moodle.org/mod/data/view.php?d=26 Themes], a database with screenshots, download links and user comments about Moodle [[Themes\|themes]]

	== Creative uses ==		== Creative uses ==

	You could use the database module to:		You could use the database module to:

	* allow collaboration on building a collection of web links/books/journal references related to a particular subject		* allow collaboration on building a collection of web links/books/journal references related to a particular subject
	* display student created photos/posters/websites/poems for peer comment and review		* display student created photos/posters/websites/poems for peer comment and review
	* gather comments and votes on a shortlist of potential logos/mascot names/project ideas		* gather comments and votes on a shortlist of potential logos/mascot names/project ideas
	* 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]

	== 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.net/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]

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

← Äldre version		Versionen från 22 oktober 2019 kl. 14.25
Rad 136:		Rad 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]]