Art Table

Art Table is a module allowing you to insert sortable, searchable tables, multiple types of data charts for easy data presentation from data sources such as HTML tables, SQL queries and CSV files.


Installation

Install the extension using standard Joomla! installation procedure (Extensions -> Install/Uninstall).

Setup

Create new module from your module manager of type Art Table. The parameters to set up Art Table are explained below.

Module Params
ParameterTypeNotes
Load jQuery libraryselect (yes or no)Load jQuery javascript library in your page. Choose no to not load jQuery from Art Table.
Table TypeselectThe type of table to create. This refers to the feature set of the table. There are 4 types of tables that can be used and one Chart type which can be used to create charts such as line graphs, bar charts and more. The most popular choice for table creation seems to be the Table Sorter. Other choices here include Table Sorter, Sortable, Data Table, HTML Table and Chart.
Data Table ThemeselectChoose from one of many themes to change the look of your table. The most popular choice amongst users is ui-lightness theme. Other choices include black-tie, blitzer, cupertino, dark-hive, dot-luv, eggplant, excite-bike, flick, hot-sneaks, humanity, le-frog, mint-choc, overcast, pepper-grinder, redmond, smoothness, south-street, start, sunny, swanky-purse, trontastic, ui-darkness, ui-lightness and vader.
Table SourceselectThis is the data source type for the data you want to load into a table or chart. Choices here include HTML Table, SQL Query and CSV File.
TitlestringGive your table a title.
CSS class namestringGive your table a CSS class name for more control of styling.
HTML TablestringOnly use this if you have set your Table Source to HTML Table. Enter your raw html and Art Table will transform your plain, basic HTML table into a sortable and searchable table.
SQL QuerystringOnly use this if you have set your Table Source to SQL Query. Enter an SQL Query here and Art Table will run your query and transform your data into a sortable and searchable table.
Connection StringstringOnly use this if you have set your Table Source to SQL Query and you want to connect to databases other than the Joomla default database. Example: mysqli,localhost,db_name,root,pass
CSV FilestringFile path to your CSV file in your server file system.
CSV DelimiterstringThe character you used to delimit your CSV file. This is most commonly the comma and the comma is set by default. If you wish to use a different delimiter you can change it here.
Convert Links and ImagesselectToggle between automatically (standard link and image conversion), by pattern (follows the pattern set in Link Conversion Pattern parameter) and no which doesn't convert links and images. The way this works is if your data contains a path to an image or a URL then Art Table will make the image display using HTML img tag or in the case of a URL it will transform the URL into a clickable link.
Link Conversion Patternstring
Nofollow Linksselect (yes or no)Set your converted links to nofollow easily by setting this to yes.
Open Links in a New Windowselect (yes or no)Set your converted links to open in a new window easily by setting this to yes.
Show First Linkselect (yes or no)If true clicking first link will limit table view only to current row
Search TextstringSet the text to show inside the search input box.
Search Input SizestringSet the size of the search input box.
Excel File NamestringIndicate excel file name only if you need to generate an Excel file from your SQL query.
Chart TypeselectOnly use if your Table Type is set to Chart. Chart types include LineChart, AreaChart, BarChart, ColumnChart and PieChart.
Chart X Axis TitleselectSet a title on the x axis of your chart.
Chart Y Axis TitleselectSet a title on the y axis of your chart.
Chart WidthselectSet the width of your chart.
Chart HeightselectSet the height of your chart.