Difference between revisions of "Database templates"

Jump to: navigation, search

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

(Tag usage)
 
(44 intermediate revisions by 15 users not shown)
Line 1: Line 1:
<div id="nolabel" style="overflow:auto;height:1px;">
+
{{Database}}
 +
{{Update}}
 +
Templates for the [[Database activity module]] allow you to control the visual layout of information when listing, viewing or editing database entries. It is a similar to the technique used to ''mail merge'' letters in word processors such as Open Office Writer or Microsoft Word.
  
  
[http://www.action-meds.com cheap butalbital]
+
== Tag usage ==
[http://www.5stardrugs.com buy tramadol]
 
[http://www.24-7pills.net tramadol online]
 
[http://www.american-meds.net butalbital discount]
 
[http://www.amazing-pills.com butalbital cheap]
 
buy tramadol online. online tramadol from our pharmacy, taking tramadol buy information tramadol, side effects tramadol, purchase tramadol online. cod online tramadol, tramadol india, cheap tramadol online, tramadol online, pharmacy online store
 
tramadol 50 mg. low price tramadol, tramadol pain treatment - tramadol hcl 50? - 120 tramadol. tramadol sales, buying cod tramado l, tramadol for humans, cheap tramadol online, overdose tramadol. order tramadol pictured tramadol pill tramadol seizure. cod tramadol cod, tramadol pdr, order pharmacy tramadol. buy prescription tramadol drug tramadol - tramadol side.
 
is tramadol a, order tramadol online, tramadol hcl, tramadol drug test .tramadol uses order tramadol overnight paypal tramadol
 
tramadol com tramadol tablets tramadol no perscription remove tramadol.
 
[http://20six.co.uk/cheaptramadol cheap tramadol]
 
[http://20six.co.uk/ordertramadol order tramadol]
 
[http://20six.co.uk/onlinetramadol1 online tramadol]
 
[http://20six.co.uk/tramadolonline tramadol online]
 
[http://20six.co.uk/tramadoldiscount tramadol discount]
 
[http://20six.co.uk/purchasetramadol purchase tramadol]
 
[http://20six.co.uk/ordersoma order soma]
 
[http://20six.co.uk/onlinesoma1 online soma]
 
[http://20six.co.uk/online-viagra online viagea]
 
[http://20six.co.uk/orderviagra order viagra]
 
[http://20six.co.uk/cheapviagraonline cheap viagra online]
 
[http://20six.co.uk/purchaseviagra purchase viagra]
 
[http://20six.co.uk/cheap-ultram cheap ultram]
 
  
[http://spaces.msn.com/cheap-tramadol/ cheap tramadol]
+
The content of each [[Database fields|field]] you create for your database and some special tags (listed below) can be inserted into the output template by the use of tags.
[http://spaces.msn.com/buy-viagra/ buy viagra]
 
  
SEO: UndoneHeaven
+
Fields have the format <code><nowiki>[[fieldname]]</nowiki></code>. All other tags have the format <code>##sometag##</code>.
  
[http://www.replicahours.com rolex replica]
+
To use the tags in the box on the left of the page, use the HTML viewer, place your cursor in the text area of your target edit and then click on the tag you want to place. Alternatively, you may simply type the appropriate name within the required symbols like <code>##this##</code> or <code><nowiki>[[this]]</nowiki></code>, respectively.
[http://www.replicahours.com/index.php?cPath=51_25 fake rolex daydate]
 
[http://www.replicahours.com/index.php?cPath=29 replica swiss]
 
[http://www.google.com/search?sourceid=navclient&gfns=1&ie=UTF-8&q=replicahours replicahours]
 
buy replica cheap best price rolex discounf fake. watches fake watch online store using paypal fedex rolex replicahours. order rolex replica now. cheap wholesale fake rolex online free shipping. 80% discount rolex replica and replicas watches. woman how to adjust a chronometer watch authorized rolex dealer, rolex watches rolex dial rolex oyster perpetual date reloj panerai replica en usa rolex watches serial numbers rolex woman daytona daytona watch replica panerai watch rolex 50th anniversary rolex daytona paul newman replica rolex buy rolex watches. ladies rolex yachtmaster white dial faux. rolex daytona manual cellini rolex for sale pictures of rolex oyster perpetual datejust rolex rolex gmt-master ii buying rolex on line fake rolex daytona gold on silver how to tell fake tag rolex oyster perpetual new tell. Replica rolex? Swiss made replica rolex watch! Cost does fake much rolex rolex presidential rolex. Rolex dials rolex sea dweller. Rolex  tudor fake rolex turkey datejust oyster perpetual rolex man rolex submariner cosmograph daytona oyster professional rolex? Datejust rolex rolex replica rolex fake rolexes for sale. Rolex submariner for sale, rolex yachtmaster! Explorer ii rolex preowned rolex watch? Cheap rolex watch, rolex daytona 116520 forum rolex. 18k gold replica ex part rolex daytona review rolex submariner 50 anniversary rolex cellini replica rolex watch fake rolex omega?
 
  
[http://www.customsoftwarenow.com custom software development]
+
* <code>##edit##</code> creates a clickable icon link that allows you to edit the current entry (only appears if you have the rights to do this)
Software Development, custom software development, offshore  software development, outsourcing software development
+
* <code>##delete##</code> creates a link that lets you delete the current entry (only appears if you have the rights to do this)
 +
* <code>##approve##</code> create a link that lets you approve the current database entry (only appears if you have the rights to do this)
 +
* <code>##more##</code> creates a link to the single view, which may contain more detailed info
 +
* <code>##moreurl##</code> creates just the URL for the above link, useful for creating your own links. You can click on the link icon and type <code>##moreurl##</code> into URL field or in source view type <pre><a href="##moreurl##">[[fieldname]]</a></pre>
 +
* <code>##comments##</code> creates a link to the view/edit comments page, the link text is the current number of comments (only appears if comments are turned on)
 +
* <code>##user##</code> creates a link to the user page of the user who submitted the entry, link text is their name
 +
* <code>##timeadded##</code>
 +
* <code>##timemodified##</code>
  
[http://www.thepublish.com press release]
+
== List template ==
press release, articles, business directory, ezines, classifieds, job search,business free  b2b search advertising aerospace defense agriculture airlines automotive chemicals computers electronics semiconductors energy utilities
 
  
[http://www.ez-agents.com wholesale atv]
+
This template allows you to control the fields used and their layout when viewing multiple entries at once (e.g. search results). It is possible that this view may simply provide an overview with more detailed information available by clicking on an entry to access the single view of the entry.
</div>
+
 
 +
See [http://tracker.moodle.org/secure/attachment/23333/moodle_databse_activity_list_formatting.pdf Designing a list view in Moodle database activity] for instructions on how to create a list template table.
 +
 
 +
The list template can also be used as a way to [[Database export|export your database]] as a CSV file.
 +
 
 +
== Single template ==
 +
This is used to display a single entry at a time and so has more space for display and can use, for example, larger versions of images or optionally provide more information than shown in the list view.
 +
 
 +
[[Image:Databasesingletemplate.png]]
 +
 
 +
== Advanced search template ==
 +
 
 +
An advanced search template is for creating the interface form used in the advanced search.
 +
 
 +
== Add template ==
 +
 
 +
This template creates the interface form used when adding or editing database entries.  
 +
 
 +
== RSS template ==
 +
 
 +
Lets you control the content of the [[RSS]] feed for database entries.
 +
 
 +
== CSS template ==
 +
 
 +
If any of the [[HTML in Moodle|HTML]] in your other templates requires [[CSS]] to provide visual style you can specify it here.
 +
 
 +
== Javascript template ==
 +
 
 +
You can use javascript to manipulate the way elements are displayed in either the List, Single or Add templates. Basically you need to enclose the part you want to manipulate in some named html element. The naming is essential as it allows you to identify the element for manipulation.
 +
 
 +
Let's say, for example, you have a field in your database that stores a person's name and when you display the names in the List View you want to count the times a name matches some criteria and display the result.
 +
 
 +
Your database will contain a field which we will call "name". In your List template you will be able to display the contents of that field by using the <nowiki>[[name]]</nowiki> construct at the place where you want that information displayed. For example in the ''Repeated entry'' on the list template you will have
 +
 
 +
<pre>
 +
<table>
 +
  <tr>
 +
    <td>Name: [[name]]</td>
 +
  </tr>
 +
<table> 
 +
</pre>
 +
 
 +
You now need to modify that entry to ensure that the part you want to manipulate is a named element.
 +
 
 +
<pre>
 +
<table>
 +
  <tr>
 +
    <td name="named">Name: [[name]]</td>
 +
  </tr>
 +
<table> 
 +
</pre>
 +
 
 +
The footer of your list view can then contain another named element to display the result.
 +
 
 +
<pre>
 +
  <div name="result"></div>
 +
</pre>
 +
 
 +
Your javascript template can now look as follows
 +
 
 +
<pre>
 +
var cnt = 0;
 +
var re = /foo|Foo/;
 +
 +
function init(){
 +
  var namedElements = document.getElementsByName("named");
 +
  for (i=0; i < namedElements.length; i++) {
 +
      if(re.test(namedElements[i].innerHTML)) cnt++;
 +
    }
 +
  var namedResult = document.getElementsByName("result");
 +
  namedResult[0].innerHTML = cnt;
 +
  }
 +
 +
window.onload = init;
 +
</pre>
 +
 
 +
This will display a table of names as is usual in the list view. Now at the bottom there will also be the count of the names that matched foo or Foo.
 +
 
 +
== Reset templates button ==
 +
 
 +
When you first create a database the templates will be pre-filled with appropriate HTML. If you later add fields then you can press the ''reset templates'' button and it will add HTML for the new fields in a similar fashion. If you have edited any of the templates in the meantime then your changes will be lost. It is recommended that you finalize the database fields before changing the template code.
 +
 
 +
==See also==
 +
*[[Database presets]]
 +
*[http://video.google.com/videoplay?docid=7026851446099005477 Video demonstrating tag usage]
 +
 
 +
Using Moodle forum discussions:
 +
*[http://moodle.org/mod/forum/discuss.php?d=55338 Look of the database module]
 +
*[http://moodle.org/mod/forum/discuss.php?d=74243 How can I list database information horizontally instead of vertically?]
 +
*[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=84050 Can't get columns to line up in list view]
 +
*[http://moodle.org/mod/forum/discuss.php?d=86927 Time stamp for database entries?]
 +
 
 +
[[de:Datenbank-Vorlagen]]
 +
[[fr:Modèles]]
 +
[[ru:Шаблоны]]
 +
[[ja:データベーステンプレート]]

Latest revision as of 02:59, 8 January 2012

This page requires updating for Moodle 2.2. Please do so and remove this template when finished.


Templates for the Database activity module allow you to control the visual layout of information when listing, viewing or editing database entries. It is a similar to the technique used to mail merge letters in word processors such as Open Office Writer or Microsoft Word.


Tag usage

The content of each field you create for your database and some special tags (listed below) can be inserted into the output template by the use of tags.

Fields have the format
[[fieldname]]
. All other tags have the format
##sometag##
. To use the tags in the box on the left of the page, use the HTML viewer, place your cursor in the text area of your target edit and then click on the tag you want to place. Alternatively, you may simply type the appropriate name within the required symbols like
##this##
or
[[this]]
, respectively.
  • ##edit##
    creates a clickable icon link that allows you to edit the current entry (only appears if you have the rights to do this)
  • ##delete##
    creates a link that lets you delete the current entry (only appears if you have the rights to do this)
  • ##approve##
    create a link that lets you approve the current database entry (only appears if you have the rights to do this)
  • ##more##
    creates a link to the single view, which may contain more detailed info
  • ##moreurl##
    creates just the URL for the above link, useful for creating your own links. You can click on the link icon and type
    ##moreurl##
    into URL field or in source view type
    <a href="##moreurl##">[[fieldname]]</a>
  • ##comments##
    creates a link to the view/edit comments page, the link text is the current number of comments (only appears if comments are turned on)
  • ##user##
    creates a link to the user page of the user who submitted the entry, link text is their name
  • ##timeadded##
  • ##timemodified##

List template

This template allows you to control the fields used and their layout when viewing multiple entries at once (e.g. search results). It is possible that this view may simply provide an overview with more detailed information available by clicking on an entry to access the single view of the entry.

See Designing a list view in Moodle database activity for instructions on how to create a list template table.

The list template can also be used as a way to export your database as a CSV file.

Single template

This is used to display a single entry at a time and so has more space for display and can use, for example, larger versions of images or optionally provide more information than shown in the list view.

Databasesingletemplate.png

Advanced search template

An advanced search template is for creating the interface form used in the advanced search.

Add template

This template creates the interface form used when adding or editing database entries.

RSS template

Lets you control the content of the RSS feed for database entries.

CSS template

If any of the HTML in your other templates requires CSS to provide visual style you can specify it here.

Javascript template

You can use javascript to manipulate the way elements are displayed in either the List, Single or Add templates. Basically you need to enclose the part you want to manipulate in some named html element. The naming is essential as it allows you to identify the element for manipulation.

Let's say, for example, you have a field in your database that stores a person's name and when you display the names in the List View you want to count the times a name matches some criteria and display the result.

Your database will contain a field which we will call "name". In your List template you will be able to display the contents of that field by using the [[name]] construct at the place where you want that information displayed. For example in the Repeated entry on the list template you will have

 <table>
   <tr>
     <td>Name: [[name]]</td>
   </tr>
 <table>  

You now need to modify that entry to ensure that the part you want to manipulate is a named element.

 <table>
   <tr>
     <td name="named">Name: [[name]]</td>
   </tr>
 <table>  

The footer of your list view can then contain another named element to display the result.

  <div name="result"></div>

Your javascript template can now look as follows

 var cnt = 0;
 var re = /foo|Foo/;
 
 function init(){
   var namedElements = document.getElementsByName("named");
   for (i=0; i < namedElements.length; i++) {
       if(re.test(namedElements[i].innerHTML)) cnt++;
     }
   var namedResult = document.getElementsByName("result");
   namedResult[0].innerHTML = cnt;
   }
 
 window.onload = init;

This will display a table of names as is usual in the list view. Now at the bottom there will also be the count of the names that matched foo or Foo.

Reset templates button

When you first create a database the templates will be pre-filled with appropriate HTML. If you later add fields then you can press the reset templates button and it will add HTML for the new fields in a similar fashion. If you have edited any of the templates in the meantime then your changes will be lost. It is recommended that you finalize the database fields before changing the template code.

See also

Using Moodle forum discussions: