|
|
4 quick steps and ready to use Included since second minor release: Included since third minor release: Included since 4th minor release:
|
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.
* You can jump to the next step since this is done automatically with installation.
In this step we have to enable two plugins. These plugins are Editor Button - Insert Grid and Content - Display Grid. Select them both and in the toolbar hit button Enable. The end result is showing two green ticks.
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
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.
Don't forget to click Save or Apply.
4. 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.
Now we Save or Apply our content page and see the result on the page. Simple, isn't it?
Since second release:
Since third release:
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.
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).
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)
Different types DB grids on the same content page
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 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.
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 City 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.
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.
Sorry, we are only humans. Thanks to our customers we found several bugs and correct them.
- where section additional condition: in SQL brackets were missing
- order by bug
- small upgrade bug
Included since 6th minor release (version 1.5.7)
Bug fixes
- typing mistakes
- loading image path
- vulnerabilities fixes
If you find some bugs, please let us know, This email address is being protected from spambots. You need JavaScript enabled to view it.