Talk:Database activity module

Jump to: navigation, search

Note: You are currently viewing documentation for Moodle 1.9. Up-to-date documentation for the latest stable version is available here: Database activity module.


FAQ

Updates for 1.7? Doesn't look like there's been any changes.

Importing templates?

Exporting templates?

How to use tags?

Help file "tags.html" could not be found!
The use of the tags in the template is vague...

Anyone come across any bugs with the database module once you have added blocks?

How do I export databases created in moodle? I see a means for importing CSV files, but no means for exporting them.

Please use the Using Moodle Database module forum for discussions, the bug tracker for browsing and/or adding bug reports and this page for comments about the documentation. Thanks! --Helen Foster 14:15, 21 July 2006 (WST)

Introduction to Database module

I propose somethink like this (I am not a native english speacker):

Unchange: The Database module activity allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.

Remove: You may be familiar with similar technology from building Microsoft Access or Filemaker databases.

Remove: Note: Please don't confuse this activity type with Moodle's underlying SQL database, which stores all of the information used in Moodle courses and is only of interest to Moodle Administrators.

This module will create one table for instance, but you may create as many instances you need. The records can be linked to other tables and all resources in the course, if you allowing autolink in a name field.

These tables are "virtual", they are not created in the SQL database, they are just stored there (in tables mdl_data*).



I think this clarify the missleading name "database".

SONGS

Example.jpg

I went to the animal fair the birds and the beasts were there by the light of the moon the big baboon

Moodle 2.0 changes

I've found a significant change (regression some might say) in the Moodle 2 database activity. I suggest we need to document, and perhaps link from the Moodle 2 release/ upgrade notes:

  • In Moodle 1.9 etc. the comment form for the database activity used the full rich-editor. In Moodle 2, this was deliberately changed to a simple text-area (see related bug). This reduces the potential for structuring and formatting a comment. More seriously with the new files API, it prevents you from embedding an image or other multimedia (eg. audio) in a database comment - I think.

I think there is a wider issue - we as a community need to document all these gotchas and upgrade issues in the hidden corners of Moodle 2. --Nick Freear 16:00, 30 January 2011 (UTC).