My favorites | Sign in
Project Logo
                
New issue | Search
for
| Advanced search | Search tips
Issue 54: Design a simple, dictionary-style database preset
7 people starred this issue and may be notified of changes. Back to list
Status:  Completed
Owner:  fosterh
Closed:  Dec 2007
UserInterface
Priority-Medium
ClaimedBy-arthus.erea


Sign in to add a comment
 
Reported by fosterh, Nov 26, 2007
Design a database preset for dictionary definitions.

You may find it helpful to create a Moodle glossary activity with a simple,
dictionary-style display format, add a few entries, and see how it looks.

You may also find it helpful to examine the image gallery preset which is
included in the standard Moodle download.

Useful links:

* Documentation: http://docs.moodle.org/en/Database_module
* Database module forum: http://moodle.org/mod/forum/view.php?id=3505
* Forum discussion including moodle.org presets for download:
http://moodle.org/mod/forum/discuss.php?d=84050Design an FAQ database preset
Comment 1 by arthus.erea, Nov 29, 2007
I claim this Task
Comment 2 by fosterh, Nov 29, 2007
Thanks arthus.erea - the task is yours :-)

The time limit is 5 days.
Status: Claimed
Comment 3 by fosterh, Nov 29, 2007
(No comment was entered for this change.)
Labels: ClaimedBy-arthus.erea
Comment 4 by arthus.erea, Dec 01, 2007
Here's what I've got. Any changes needed?
2007.12.01-preset.zip
2.8 KB Download
Comment 5 by fosterh, Dec 03, 2007
Thanks arthus.erea,

You've created appropriate database fields - good so far :-)

Now you need to design the add, single and list templates (and optionally RSS, CSS
and JavaScript templates) so that the pages for adding and viewing database entries
look good. Please see http://docs.moodle.org/en/Database_templates for more information.

Helen
Comment 6 by arthus.erea, Dec 03, 2007
I actually have defined templates for add, single, list, and CSS.

Try unzipping the preset locally and taking a look in the files - you'll see my
templates (and can open them).

I made a new database and imported the preset - everything worked fine. Here it is
again, if you want.
2007.12.02-preset.zip
2.8 KB Download
Comment 7 by fosterh, Dec 03, 2007
Oh sorry, I thought you hadn't designed any templates, because when I tried your
preset  I obtained the message "Single template is not yet defined".

Then, when I unzipped your preset locally, I found the templates with the default
layout of tags i.e. with no design changes. The default layout of tags on the list
template is  virtually the same as the default layout of tags on the single template.

Can you use HTML (and optionally CSS) to improve the appearance of the pages for
adding and viewing database entries? Also, note that it's not necessary for each
field to appear in the view list page.

Helen
Comment 8 by arthus.erea, Dec 04, 2007
I did design a full database preset and template system. I used CSS, tables, and
semantic dictionary lists.

Perhaps there is an error with the import on your end? I tested it on a completely
new database and it worked fine. Here's the screencast of it:
http://screencast.com/t/a7DqtS6V3 (sorry about background noise)

I want to work out any problems with this... maybe you need to try it on a clean
database or server? I've attached another copy of the zip (the same one used to
create the screencast)
2007.12.02-preset.zip
2.8 KB Download
Comment 9 by penelope.leach, Dec 04, 2007
I'm having the same problem as Helen - I watched your screen cast and I can see that
you've changed the css, but when I import the preset the css doesn't make it into the
database.  If you look in mdl_data, all the template data is stored in that table,
the csstemplate column is empty.  When  moodle HQ come online (timezones beating me
currently), I'll ask to see if one of the Database module experts knows of any import
bugs.  

FWIW, I'm testing on the latest MOODLE_19_STABLE from cvs, on linux, in a vserver,
against postgres.
Comment 10 by arthus.erea, Dec 04, 2007
Right, I decided to test this and tried making a database in the demo moodle
(http://demo.moodle.org) with this preset.

Unfortunately, it didn't work - just as you had said. I think it may be a
compatibility issue, since I am running 1.8.2 on my server. I'll upgrade to 1.9 &
rebuild the preset - maybe that'll fix the problem.

Also, I understand the "time limit" is up but would like to seek an extension, since
unforeseen issues have arisen. If not, I can understand completely.
Comment 11 by arthus.erea, Dec 04, 2007
Okay, I redid the preset on the demo server, then imported it again after the
databases had been reset - still no fix. This really is inexplicable to me -
everything works fine when I do it.
Comment 12 by fosterh, Dec 05, 2007
Hi arthus.erea,

I've reported the problem we've come across in the Moodle tracker - see
http://tracker.moodle.org/browse/MDL-12439 It looks like Moodle HQ developer Yu has
fixed it already; I just need to test things.

Don't worry about the time limit for this task - you've submitted an entry within the
time limit. Please feel free to claim another task if you wish.

Helen
Comment 13 by fosterh, Dec 05, 2007
Hi Arthus,

As you'll see from the bug report, the problem is fixed in the latest Moodle 1.9.
Thus, I was able to import your database preset including templates.

Your preset is really good - great work :-) It's sure to be a help for teachers
wanting to create a dictionary activity in their courses.

You have successfully completed this task - well done! 
Status: Completed
Comment 14 by arthus.erea, Dec 05, 2007
Glad to hear the problem's been fixed.

Thanks! :)
Comment 15 by penelope.leach, Dec 06, 2007
Sorry to add comments after the task has closed but I just wanted to say that this is
a great example of how with enough eyes all bugs are shallow :)
Sign in to add a comment

Hosted by Google Code