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.
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.
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:
* 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).
* 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)
* 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.
If you find some bugs, please let us know, customers@toolsjx.com
|
