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

Database activity FAQ: Difference between revisions

From MoodleDocs
m (template edit)
No edit summary
 
(33 intermediate revisions by 9 users not shown)
Line 1: Line 1:
{{Database activity module}}
{{Database}}
==Where can I download additional database presets?==
==Where can I download additional database presets?==


See [[Database presets]] for discussion links with presets for download.
See the Presets and See also sections in [[Building Database]] for various places with presets for download.
 
==How can I add to the list of database presets available for users to choose from?==
 
[[File:databasepresetsnew.png|thumb|Database presets]]
 
There is one default preset, Image Gallery. It is possible to create your own presets.
 
When you have created your database that you desire to set as a preset; go to the "Presets" tab of the database and choose "Save as preset". Give the preset a name and the database fields and templates will now be available as a preset for the rest of the site. You will need site admin rights to do this.
 
Please see the [[Database presets]] for other available presets you can import into your system.


==How can I create a database in which students can only view their own entries?==
==How can I create a database in which students can only view their own entries?==
Line 19: Line 29:


http://moodle.org/mod/data/view.php?d=13&sort=44&order=DESC
http://moodle.org/mod/data/view.php?d=13&sort=44&order=DESC
==How can I add highlighting like on the Module and plugins page?==
In the repeated part of the template (note onmouseover and onmouseout to change the classes):
<pre><tr onmouseover="this.className='trhighlight'" onmouseout="this.className='trnormal'">
<td class="c0"><b><a href="##MoreURL##">[[Name]]</a></b></td>
<td class="c1">[[Type]]</td>
<td class="c2">[[Requirement]]</td>
<td class="c3">[[Status]]</td>
<td class="c4">[[Summary]]</td>
<td align="center" class="c5">##Edit##&nbsp;##Delete##&nbsp;##More##&nbsp;##Approve## </td>
</tr></pre>
In the CSS template there are two styles:
<pre>.trnormal td {
  background-color: #FFFFFF;
}
.trhighlight td {
  background-color: #EEEEEE;
}</pre>


==How can I list database information horizontally instead of vertically?==
==How can I list database information horizontally instead of vertically?==
Line 51: Line 40:


==Is there a Time stamp for database entries?==
==Is there a Time stamp for database entries?==
*[http://moodle.org/mod/forum/discuss.php?d=86927 Time stamp for database entries forum discussion]
 
<nowiki>##timeadded##</nowiki>


==How can I make the title of an entry into a link?==
==How can I make the title of an entry into a link?==
Line 59: Line 49:
  <nowiki><a href="##moreurl##">[[Title]]</a></nowiki>
  <nowiki><a href="##moreurl##">[[Title]]</a></nowiki>


==How can I delete a file attached to a database entry?==
==How can I hide a database entry which was previously approved?==
 
Edit the list and or single template and add the undo approval tag (##disapprove##).
 
==How can I add a default sort order of entries?==
 
In the Fields tab, select a default sort field, choose ascending or descending then click the Save button.
 
==Why is my database so slow to show each page?==
 
Try to go to "Administration > Miscellaneous > XMLDB editor" and choose "Check Indexes". If you have any missing indexes found; upgrade your Moodle to the latest weekly build of your version; re-run the test; backup your site database and then run the suggested SQL from the test on your site database. This should speed up your database activity load times.
 
==How can I prevent students from adding entries?==
 
An override may be used to close/archive a database activity, or have a database in which only teachers can add entries, but students can view the entries.
 
# Follow the Permissions link in the settings block under Database activity administration
# Remove Student from the capability [[Capabilities/mod/data:writeentry|mod/data:writeentry]] by clicking the 'X' next to it.
# Click the continue button to confirm.
 
==How can I empty a database / remove records from a database en masse?==
In List view, there is a checkbox next to each entry. Click to select the ones you wish to delete and then click the 'Delete selected' button. Alternatively, click the 'Select all' and 'Delete all' buttons. A warning message will appear asking you to confirm what you wish to delete.
 
==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 :)
 
==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.
 
==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


There is currently no user interface for deleting a file attached to a database entry, however a workaround would be to delete the entry completely and then create a new entry without the file attached.
==How can I have entries waiting for approval highlighted?==


==How can I hide a database entry which was previously approved?==
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:
 
class="mod-data-default-template ##approvalstatus##"
 
==Any further questions?==


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.
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 75: Line 104:
*[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?]
*[https://moodle.org/mod/forum/discuss.php?d=324452 Glossary autolink within a database activity]


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


[[de:Datenbank FAQ]]
[[de:Datenbank FAQ]]
[[es:Actividad BasedeDatos FAQ]]
[[fr:FAQ sur la base de données]]

Latest revision as of 13:18, 24 April 2019

Where can I download additional database presets?

See the Presets and See also sections in Building Database for various places with presets for download.

How can I add to the list of database presets available for users to choose from?

Database presets

There is one default preset, Image Gallery. It is possible to create your own presets.

When you have created your database that you desire to set as a preset; go to the "Presets" tab of the database and choose "Save as preset". Give the preset a name and the database fields and templates will now be available as a preset for the rest of the site. You will need site admin rights to do this.

Please see the Database presets for other available presets you can import into your system.

How can I create a database in which students can only view their own entries?

Either:

  • Set up the database so that entries require approval. If the entries are never approved, then only the student that added a particular entry and the teachers can view it.

Or:

  • Set the group mode of the database to "Separate groups" and assign each student to a separate group.

How can I enable a sort function by clicking on the field headings?

For sorting, you need to manually create the link in the template around that heading. To find the URL you need, you can do a sort using the menus and then look in the URLs. Take out everything but the d, sort and order parameters. For example,

http://moodle.org/mod/data/view.php?d=13&sort=44&order=ASC

http://moodle.org/mod/data/view.php?d=13&sort=44&order=DESC

How can I list database information horizontally instead of vertically?

Can't get columns to line up in list view

How can I make an Encyclopedia database preset?

Is there a Time stamp for database entries?

##timeadded##

How can I make the title of an entry into a link?

To make the title of an entry in list view link to the single view, add the following code to the list template:

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

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

Edit the list and or single template and add the undo approval tag (##disapprove##).

How can I add a default sort order of entries?

In the Fields tab, select a default sort field, choose ascending or descending then click the Save button.

Why is my database so slow to show each page?

Try to go to "Administration > Miscellaneous > XMLDB editor" and choose "Check Indexes". If you have any missing indexes found; upgrade your Moodle to the latest weekly build of your version; re-run the test; backup your site database and then run the suggested SQL from the test on your site database. This should speed up your database activity load times.

How can I prevent students from adding entries?

An override may be used to close/archive a database activity, or have a database in which only teachers can add entries, but students can view the entries.

  1. Follow the Permissions link in the settings block under Database activity administration
  2. Remove Student from the capability mod/data:writeentry by clicking the 'X' next to it.
  3. Click the continue button to confirm.

How can I empty a database / remove records from a database en masse?

In List view, there is a checkbox next to each entry. Click to select the ones you wish to delete and then click the 'Delete selected' button. Alternatively, click the 'Select all' and 'Delete all' buttons. A warning message will appear asking you to confirm what you wish to delete.

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

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.

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

  1. Enable an RSS feed of recently added entries as described in Using Database
  2. Add a Remote RSS feeds block to the course page
  3. Add the database activity RSS feed to it

How can I have entries waiting for approval highlighted?

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:

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

Any further questions?

Please post in the Database forum on moodle.org

See also

Forum discussions: