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

Talk:Database activity module: Difference between revisions

From MoodleDocs
m (Reverted edits by Englishlanguage-a-long (talk); changed back to last version by Jose' Coelho)
 
(7 intermediate revisions by 5 users not shown)
Line 1: Line 1:
== 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:


== FAQ ==
* 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 [http://tracker.moodle.org/browse/MDL-26194| 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.
Updates for 1.7? Doesn't look like there's been any changes.


Importing templates?
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.
--[[User:Nick Freear|Nick Freear]] 16:00, 30 January 2011 (UTC).


Exporting templates?
===[[Database_activity_module|Database]]===


How to use tags?
Old template {{Database activity module}}
:Help file "tags.html" could not be found!
New template {{Database}}
Brief, general intro page (appx 100-300 words; 7 - 20 sentences), visuals most welcome.  
Point the user to items that can be found on the template menu (box on the right) and what they contain.
[[Database_activity_module]] - G, Sep 10, thorough, pic or link to a gallery of databases would be good


:The use of the tags in the template is vague...
===Time modified field===


Anyone come across any bugs with the database module once you have added blocks?
Needs a timemodified field in the db table to be consistent with other modules


How do I export databases created in moodle? I see a means for importing CSV files, but no means for exporting them.
This field is important for our recent activity feed.
 
See Sussex [http://blogs.sussex.ac.uk/elearningteam/2011/08/10/recent-activity-in-moodle/ blog_post]
:Please use the Using Moodle [http://moodle.org/mod/forum/view.php?id=3505 Database module forum] for discussions, the [http://moodle.org/bugs/ bug tracker] for browsing and/or adding bug reports and this page for comments about the documentation. Thanks! --[[User:Helen Foster|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".

Latest revision as of 14:12, 23 September 2011

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

Database

Old template Template:Database activity module 

New template

Brief, general intro page (appx 100-300 words; 7 - 20 sentences), visuals most welcome. 
Point the user to items that can be found on the template menu (box on the right) and what they contain.
Database_activity_module - G, Sep 10, thorough, pic or link to a gallery of databases would be good

Time modified field

Needs a timemodified field in the db table to be consistent with other modules

This field is important for our recent activity feed. See Sussex blog_post