3 quick steps and ready to use

Included since second minor release:

Included since third minor release:

Included since 4th minor release:

Included since 5th minor release:

Included since 6th minor release (version 1.5.6):

Included since 7th minor release (version 1.5.7):

Included since 8th minor release (version 1.5.8):

Included since 9th minor release (version 1.5.9):

  • Multilanguage support
  • New settings

Included since 10th minor release (version 1.5.10):

  • Bug fixes

NEW!!! Included since 11th minor release (version 1.5.11):

  • Advanced filters

Tutorials



1. Installation
 

In the Administration page click Extensions and then under Install hit button Browse and select com_grid.zip (this is the file you have already downloaded via Download button).  After the successful installation go to the next step.

 

Install

 

2. Creating grid

 

In this step we are creating one grid that will be later shown in the content page. So, go to the Components and hit the Grid. The mask is shown below.

  • Table Title - the name of the grid in the content page. The name can be whatever you want or just the name of the table in the database.
  • Select connection - you have two options, Same as Joomla's or Other. If you select the first option, you will be using connection for the database that Joomla is using. Tipiclly that is MySql database. In the second option, Other, you specify connection with your own database.
  • Database Type - You can use mysql, mysqli, oracle, mssql
  • Database Host - enter localhost for local network or IP address or domain name for remote database
  • Database User - enter the database user that can read from the database
  • Password - this is the password that coresponds to already entered user
  • Database Name - the name of the database, e.g. Northwind

Conn

 

Hit the button Check and List Tables. You can se if the connection with the database is established. If not, you have to check above parameters again.

  • Table name in Database - in the drop-down box select the table
  • Columns - in this section are the columns of the selected table automatically displayed. Select the columns you want to display. If you enter new name of the column in the Column Caption fields, the column will be renamed, otherwise will be used default name from the table in the database.

Columns

 

Don't forget to click Save or Apply.

 

3. Using grid in the content page

 

Now when we already have configured the grid, we can put it in our content page. We can do that with the button Insert Grid, which is highlited in the picture below. If we know the grid's ID, we can just write text in curly braces with that ID.

 

Using

Now we Save or Apply our content page and see the result on the page. Simple, isn't it?

 

Since second release:

 

Table Settings

Table Settings

Column Order

Column Order

 

Since third release:

 

Color picker

Advanced

 

Advanced section

Advanced

 

Since 4th release:

 

User specific data - create filter to show user's specific data to currently logged in user

 

You can create content page with access level Registered. Create grid - in advanced section under WHERE id=@user_id. Id is the name of the column where joomla ID's are stored.

 

navodila

 

New external DB handling (supported MySQL, MySQLi, Oracle, MS-SQL)

 

You can now test connection and list tables (if everything goes ok) with Check and List Tables button. It is possible to fetch data from localhost or even remotely if your database exists on  different location (e.g. other part of the world).

 

 

shema

 

Some specifics for some DB' types:

 

  • for MySQL

* everything works by default

 

Other DBs:

 

Get correct libraries and copy/paste them to apache/bin folder.

Be sure that you have proper php.ini (uncomment right extensions in php.ini file).

 

  • for MS-SQL

* Database host: is the same as Server name in Microsoft SQL Server Management Studio (if you are connecting remotely write also port number)

e.g. Database host: yourdomain.com:1433

 

PHP manuals for MS-SQL (linux or windows)

 

  • for Oracle

* if standard port is used (e.g. 1521) do not need to specify the port in Database host

e.g. Database host: yourdomain.com

 

else (non-standard port 1522)

e.g. Database host: yourdomain.com:1522

 

PHP manuals for Oracle (linux or windows)

 

Measure time with 'Query took' (enable/disable in admin)

 

Query

 

Different types DB grids on the same content page

 

Content page

 

New settings

 

new settings

 

Since 5th release:

Search engine friendly (SEO)

On TableJX was made a great effort to be as much search engine friendly as possible. This functionality enables that records in a grid are indexed by search engines, like Google, Yahoo, Bing, etc... If you have some, let's say, products in a grid, search engine finds them easily. This could be a great benefit for your business. If you put a grid inside of the registered area, then it will be safe, if you don't want to show  to the rest of  the world what is inside of your grid.

 

Linkable content

Linkable content enables that you just click on a value in a grid and this action opens specific URL or specific joomla Article, Category or even Section. You can very easily show content that is specific for this value in a grid. If you are more creative, you can put even another grid in an article and show some specifics. Example: You have grid full with products. If you click on a specific product, this can open another article with pics of this product or even detailed specifications in the another TableJX grid. Further, you can create again links on specifications grid and show another article with even more detailed information. At the end you can have the whole chain of linkable grids.

 

 

Second order by

If you are not familiar with SQL or you just don't have time to create an sql view an show it in TableJX grid, you can in admin section with few clicks create a grid with data as you wish. See documentation above. In the 5th minor release, you can find new functionality, so called Second order by. In the demo, in Customers grid, you can see first order by on Customers Titel column and second order by on the Surname column.

 

 

Adjustable row height and column width

Well, really nothing specific to say here. If your data doesn't fit in your page you can adjust these two settings.

 

 

Encoding support

Doesn't matter if your language has β, Č, Ð, Ë, Õ or other letters or specific signs, TableJX will show them without any problem. If you have some specific rule to order these letters or signs, we can provide instructions how to set up databases correctly.

 

New layout option - Table or Card

Since version 1.5 you can find in admin area also layout option Table or Card. When you purchase and install Table JX only Table can be checked If you purchase and install Card View JX, you can choose then between Table or Card display in front-end.

 

Displaying sql view also for external databases

Since version 1.5 is also available to display besides SQL Tables also SQL views for other (external) databases. This brings you the ability to display any SQL query (table joins, filters, calculations, groupings, ...) or in other words, whatever you can do with SQL.

 

New personal file download page in Customer Area - using Table JX

We have changed file download page to more user friendlier as one before. The download page is using Table JX and it presents user specific data or files that can be downloaded or purchased.

 

Bug fixes

- typing mistakes

- loading image path

- vulnerabilities fixes

 

You can find Customer Area here.

 

Contact Us

Contact us on Facebook