Database activity FAQ - Revision history

Abgreeve: Remove how to make an email address clickable - please do not do, it causes problems with search highlighting.

2016-12-21T08:55:20Z

Remove how to make an email address clickable - please do not do, it causes problems with search highlighting.

← Older revision		Revision as of 08:55, 21 December 2016
Line 48:		Line 48:

	<nowiki><a href="##moreurl##">[[Title]]</a></nowiki>		<nowiki><a href="##moreurl##">[[Title]]</a></nowiki>

	~~==How can I make email addresses clickable?==~~

	~~To make email addresses clickable, add the following code to the single template:~~

	~~<nowiki><a href="mailto:[[Email]]">[[Email]]</a></nowiki>~~

	~~where 'Email' is the text field for inputting email addresses.~~

	==How can I hide a database entry which was previously approved?==		==How can I hide a database entry which was previously approved?==

Tsala: Any further questions?, see also link

2015-12-09T11:39:08Z

Any further questions?, see also link

← Older revision		Revision as of 11:39, 9 December 2015
Line 99:		Line 99:

	class="mod-data-default-template ##approvalstatus##"		class="mod-data-default-template ##approvalstatus##"

			==Any further questions?==

			Please post in the [https://moodle.org/mod/forum/view.php?id=3505 Database forum] on moodle.org

	==See also==		==See also==
	~~Using Moodle forum~~ discussions:		Forum discussions:

	*[http://moodle.org/mod/forum/discuss.php?d=87005 New preset, please review, and make suggestions!] including FAQ preset for download		*[http://moodle.org/mod/forum/discuss.php?d=87005 New preset, please review, and make suggestions!] including FAQ preset for download
Line 109:		Line 113:
	*[http://moodle.org/mod/forum/discuss.php?d=94854#p457252 Looking for some stellar examples of Moodle courses] including book reviews preset for download		*[http://moodle.org/mod/forum/discuss.php?d=94854#p457252 Looking for some stellar examples of Moodle courses] including book reviews preset for download
	*[https://moodle.org/mod/forum/discuss.php?d=268206 Database 2.7 List and Single View: Possible to view only entered fields?]		*[https://moodle.org/mod/forum/discuss.php?d=268206 Database 2.7 List and Single View: Possible to view only entered fields?]
			*[https://moodle.org/mod/forum/discuss.php?d=324452 Glossary autolink within a database activity]

	[[Category:FAQ]]		[[Category:FAQ]]

Tsala: /* How can I have entries waiting for approval highlighted? */

2015-11-12T12:44:00Z

How can I have entries waiting for approval highlighted?

← Older revision		Revision as of 12:44, 12 November 2015
Line 96:		Line 96:
	In Moodle 3.0 onwards, any newly created database activities show entries waiting for approval as highlighted for the teacher and the user who added the entry.		In Moodle 3.0 onwards, any newly created database activities show entries waiting for approval as highlighted for the teacher and the user who added the entry.

	For existing database activities, the highlighting can be added by editing the list and/or single template and resetting it, or adding some inline css ~~such as~~		For existing database activities, the highlighting can be added by editing the list and/or single template and resetting it, or adding some inline css:

	class="mod-data-default-template ##approvalstatus##"		class="mod-data-default-template ##approvalstatus##"

Tsala: How can I have entries waiting for approval highlighted?

2015-11-05T20:28:59Z

How can I have entries waiting for approval highlighted?

@@ Line 29: / Line 29: @@
 http://moodle.org/mod/data/view.php?d=13&sort=44&order=DESC
 ==How can I list database information horizontally instead of vertically?==
@@ Line 112: / Line 91: @@
 # Add a [[Remote RSS feeds block]] to the course page
 # Add the database activity RSS feed to it
 ==See also==

Tsala: /* How can I hide a database entry which was previously approved? */ update info

2015-11-05T20:02:57Z

How can I hide a database entry which was previously approved?: update info

← Older revision		Revision as of 20:02, 5 November 2015
Line 80:		Line 80:
	==How can I hide a database entry which was previously approved?==		==How can I hide a database entry which was previously approved?==

	There is currently no user interface for hiding a database entry which was previously approved i.e. setting it to require approval again. However, an entry can be hidden using [[MySQL Admin]] by editing it in the ~~''data_records'' table~~ and ~~changing~~ the ~~approved value from 1 to 0~~.		Edit the list and or single template and add the undo approval tag (##disapprove##).

	==How can I add a default sort order of entries?==		==How can I add a default sort order of entries?==

Germanvaleroelizondo: Added link to spanish translation of page

2015-06-16T15:01:17Z

Added link to spanish translation of page

← Older revision		Revision as of 15:01, 16 June 2015
Line 126:		Line 126:

	[[de:Datenbank FAQ]]		[[de:Datenbank FAQ]]
			[[es:Actividad BasedeDatos FAQ]]

Tsala: How can I show recently added entries in a block on the course page?

2015-06-16T13:44:08Z

How can I show recently added entries in a block on the course page?

← Older revision		Revision as of 13:44, 16 June 2015
Line 106:		Line 106:
	==How do I export/import picture fields from a database activity from one course to another?==		==How do I export/import picture fields from a database activity from one course to another?==
	You cannot export/import database entries with picture fields using the csv option, you will need to use Moodle's backup and restore functionality. Please note that you will need to backup and restore the database activity with user data in order for the entries to be carried over.		You cannot export/import database entries with picture fields using the csv option, you will need to use Moodle's backup and restore functionality. Please note that you will need to backup and restore the database activity with user data in order for the entries to be carried over.

			==How can I show recently added entries in a block on the course page?==

			# Enable an RSS feed of recently added entries as described in [[Using Database]]
			# Add a [[Remote RSS feeds block]] to the course page
			# Add the database activity RSS feed to it

	==See also==		==See also==

Rexlorenzo: /* How do I export/import picture fields from a database activity from one course to another */

2015-04-13T19:54:24Z

How do I export/import picture fields from a database activity from one course to another

← Older revision		Revision as of 19:54, 13 April 2015
Line 104:		Line 104:
	One thing to try is to open up the csv file in Excel and save it again as a csv file - with another name - and then try importing it agin. Sometimes this just works :)		One thing to try is to open up the csv file in Excel and save it again as a csv file - with another name - and then try importing it agin. Sometimes this just works :)

	==How do I export/import picture fields from a database activity from one course to another==		==How do I export/import picture fields from a database activity from one course to another?==
	You cannot export/import database entries with picture fields using the csv option, you will need to use Moodle's backup and restore functionality. Please note that you will need to backup and restore the database activity with user data in order for the entries to be carried over.		You cannot export/import database entries with picture fields using the csv option, you will need to use Moodle's backup and restore functionality. Please note that you will need to backup and restore the database activity with user data in order for the entries to be carried over.

Rexlorenzo: Importing picture fields

2015-04-13T19:54:08Z

Importing picture fields

← Older revision		Revision as of 19:54, 13 April 2015
Line 103:		Line 103:
	==I get an error message when importing a csv of entries==		==I get an error message when importing a csv of entries==
	One thing to try is to open up the csv file in Excel and save it again as a csv file - with another name - and then try importing it agin. Sometimes this just works :)		One thing to try is to open up the csv file in Excel and save it again as a csv file - with another name - and then try importing it agin. Sometimes this just works :)

			==How do I export/import picture fields from a database activity from one course to another==
			You cannot export/import database entries with picture fields using the csv option, you will need to use Moodle's backup and restore functionality. Please note that you will need to backup and restore the database activity with user data in order for the entries to be carried over.

	==See also==		==See also==

Tsala: /* See also */ forum discussion link

2014-10-03T08:24:23Z

← Older revision		Revision as of 08:24, 3 October 2014
Line 112:		Line 112:
	*[http://moodle.org/mod/forum/discuss.php?d=61179 For those who want the display of Moodle Site's Modules and plugins]		*[http://moodle.org/mod/forum/discuss.php?d=61179 For those who want the display of Moodle Site's Modules and plugins]
	*[http://moodle.org/mod/forum/discuss.php?d=94854#p457252 Looking for some stellar examples of Moodle courses] including book reviews preset for download		*[http://moodle.org/mod/forum/discuss.php?d=94854#p457252 Looking for some stellar examples of Moodle courses] including book reviews preset for download
			*[https://moodle.org/mod/forum/discuss.php?d=268206 Database 2.7 List and Single View: Possible to view only entered fields?]

	[[Category:FAQ]]		[[Category:FAQ]]

	[[de:Datenbank FAQ]]		[[de:Datenbank FAQ]]