South Downs Railway

Modern Image N gauge, with DCC & computer control

  • Increase font size
  • Default font size
  • Decrease font size
Home SDR Website
website

Using JR Sortable Tables

E-mail Print PDF

There are tables in the website that I wanted to be sortable. Look at the "loco roster", for example.  It wasn't obvious how to do that with Joomla!; a thorough review of the "extensions" directory didn't really reveal an obvious candidate. There were extensions that would render a table from data in the database - but how do you get that data therein the first place? Eventually I found JR Sortable Tables: a simple plug-in that makes a "normal" table within an article sortable. Click on the column headings, and it sorts by that column.

The instructions for the plug-in don't tell you how to create the table. But you can do it all with "JCE": you don't need to write the HTML code. There are three steps:

  • Install the plug-in and enable it.
  • Create the basic table
  • Change the header properties
  • Add the plug-in reference

Installing a plug-in is a standard Joomla administration activity. It needs to be enabled.

Creating the table is simple. Simply use your editor to create a table in the text, and add into it all of the rows of information. This is absolutely standard text editing.

The table needs to have some properties set. Firstly it needs an "id" field. Right click in the table, choose "table properties" then click the "advanced" tab. Enter a unique name under the "Id" field: mine is "Roster_Table".

Each cell in the header row needs its "class" field to be set to "sort_header". Put the cursor in the cell; right click and select "table cell properties"; then open the drop down list box for the  "Class" field and select "(Add Value)" at the bottom. Then enter "sort_header". You will need to do this for each cell in the header!

Finally, after the table, you simply need a line of code to make the table sortable. Using the text editor, simply add " " in the row of text under the table.

Last Updated on Tuesday, 08 June 2010 18:59
 

Architecture

E-mail Print PDF
For those that are interested, this site has been constructed using Joomla!  Joomla! is an open source, free-to-use Content Management System. Joomla! stores its content in a database at the web host. None of this make a difference to readers of the site, but for content creators it does allow a large site easily to be managed.

Joomla! provides the basic functionality to get started with a content managed website. However, there are some common needs that are not fully addressed by the standard package. But that's not a problem - there is a wide variety of "add ons" available. On top of the "standard" Joomla install we have selected a number of extensions to provide specific functionality:

JCE An enhanced text editor for content creation. JCE allows links to other content to be added "inline"
mod_vvisit_counter A module to show the number of visitors to the site
Xmap A site map component
Akeeba Backup A site archiving and backup component; covers the full site not just the database, and uses a script to re-install the site from scratch. This is EXCELLENT for moving from one web host to another!
Phoca Gallery Photo gallery component. Manages creation of thumbnails when pictures are uploaded.
Phoca Download This component allows any file to be stored so that users can download it. There is also a plug-in to insert links in documents to stored files.
JR Sortable Tables This is a small plug-in that makes an HTML table in an article become sortable simply by clicking on its header row to sort by each column.
 SWFContent 3 Pro This is a component at plug-in that allows FLASH format files to ve shown in articles. Useful for "live" presentation pages etc.
Last Updated on Saturday, 12 June 2010 16:06
 

Hosting

E-mail Print PDF

This site is hosted by T.H.E softnet based in Northampton. This hosting provider fully supports Joomla 1.5

As with any Joomla website, there are aspects of the server configuration that need to be determined by trial and error. The PHP code apparently has no run-time memory size limit imposed, which will avoid problems for some image manipulation components.

Uploading a website to T.H.E softnet

It's generally recommended to create a site initially on a local host, then copy to the live hosting server when it's ready. This is sound advice: but the task of getting it there isn't as simple as is described. Enter Akeeba Backup: it creates a single-file archive of the entire site, and an install script that manages the whole process of installing the site at the new host. The process involved is something like the following;

  • Create the site archive from the localhost using Akeeba Backup
  • Upload “kickstart.php” and the English .ini file to the new server
  • Upload the archive to unpack from to the new server
  • Run “kickstart.php” using a web browser
  • Select “FTP” as the upload method.
  • Select “localhost” as the ftp server, username and password as given for FTP, directory “/” port 21
  • Press “start”
  • Answer questions as they arise; mostly the FTP and database permissions.
  • At the end I had to manually delete the installation directory, kickstart.php and the archive. This should have been done by the script: I don't know why it failed. The site then worked. (I needed a special option in the FTP program to allow deleting non-empty directories).

Email

The Email configuration appears to need to be set to "PHP Mail function" with a port number 25 and "normal" SMTP server configuration and login. Site email then works OK.

FTP

The Joomla "FTP layer" avoids problems with file permissions on linux hosts. The FTP layer should be turned "on"; FTP host should be set to "localhost", username and password as you would use for FTP login, and FTProot should be set to "/".

 

Last Updated on Tuesday, 08 June 2010 18:59
 



mod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_counter
mod_vvisit_counterToday27
mod_vvisit_counterYesterday72
mod_vvisit_counterThis week385
mod_vvisit_counterThis month935

We have: 2 guests online
Your IP: 38.107.191.118
 , 
Today: Sep 08, 2010

Photograph browser

Using this Site

Searching

The web site can be searched: type a search term (e.g. "DAC10") into the search box on the right hand side of the header, and hit enter. the search engine will find words matching the search string in the main body of the site, but it won't search attached documents (e.g. the product manuals).

Font Size

This website offers some help for accessibility. There are three symbols on the top right of the header that allow the font size to be increased or decreased. Choose a size that you find comfortable. "A+" increases the size; "A" sets the default size, and "A-" chooses a smaller size.

"Read More"

Many articles are displayed one after the other. some are quite short, and say "read more" at the bottom. Click that to read the remainder of the article.