Art Data

Art Data
$20.00 each
Premium Support
2.3.2
2020-06-23
CMP
3
1 Year
1 Year

Demo

Knowledgebase

Art Data v2.3.2 makes it easier than ever to visualize data on a Joomla 3.x website. Create 2 types of tables and 12 types of charts. Create custom templates to control the style of your tables and charts. Quickly populate a table or chart using our built in dataset spreadsheet or you can load a dataset from SQL Query, HTML or CSV file.

2 Table
Types

Use Static Table for a basic table and Dynamic Table for searching, sorting and pagination.

12 Chart
Types

Visualize data in a nearly endless variety of highly configurable and elegant charts.

Template
Builder

Create custom templates which can be used to style your tables or chart visualizations.

User
Friendly

Art Data admin interface was designed for easy use by joomla web developers of all skill levels!

Data
Nirvana

Load data from our easy data spreadsheet interface, database query, html code, csv file and more!

Timely
Support

Our support staff can help you be it a simple configuration issue, fixing a bug or a new feature request.

  • Table Visualizations

    • Create 'Static Table' - a basic table without sorting, filtering or pagination
    • Create 'Dynamic Table' - a table with sorting, filtering, and pagination
    • Populate table with custom dataset - SQL Query, HTML, CSV file
    • Populate table with SQL Query for the following databases: MySQL - Joomla Database, MySQL - Other Database, PostgreSQL, MSSQL (mssql extension), MSSQL (sqlsrv extension), Oracle, Access, SQLite, Firebird, Informix, Foxpro, ADO, Sybase, FrontBase, DB2, SAP DB, Netezza, LDAP, ODBC, ODBTP
    • Insert dynamic variables from the currently logged in user or from session in your SQL Query to add advanced functionality
    • Populate table with ArtData dataset - use the quick, easy 'data' view to create a dataset by entering your data into a convenient spreadsheet-like application.
    • Completely style your table with a custom theme using the 'templates' view
    • Restrict table access level
    • Show or hide table title
    • Convert links and images automatically or by pattern
    • Use rel="nofollow" on links
    • Open links in a new window
    • Control default pagination limit
    • Control pagination limit choices

    Custom Templates

    • Create, edit 'template' for a table - style everything about your table
    • Set table class modifiers - condensed, striped, hover
    • Customize table header styles - text align, padding, font size, font weight, text color, border
    • Customize table cell styles - text align, padding, border, striped background color
    • Customize search filter input - height, width, padding, background, border, border radius, text color as well as onfocus styles
    • Customize search filter button - padding, background, text color, border
    • Customize active pagination - background, text color
    • Customize non-active pagination - background, text color
    • Customize focus & hover pagination - background, text color
    • Create, edit 'template' for a chart - style everything about your chart
    • Control main chart background, opacity, width and height
    • Set axis lines color for charts
    • Toggle tick marks for charts
    • Set tick mark interval for charts
    • Set axis padding for charts
    • Control chart color palette

    Chart Visualizations

    • Create 'Bar Chart'
    • Create 'Line Chart'
    • Create 'Area Chart'
    • Create 'Stacked Bar Chart'
    • Create 'Stacked Area Chart'
    • Create 'Pie Chart'
    • Create 'Percent Bar Chart'
    • Create 'Percent Area Chart'
    • Create 'Donut Chart'
    • Create 'Step Up Bar Chart'
    • Create 'Polar Area Chart'
    • Create 'Waterfall Chart'
    • Charts load with cool data population animation
    • Populate chart with custom dataset - SQL Query, HTML, CSV file
    • Populate chart with SQL Query for the following databases: MySQL - Joomla Database, MySQL - Other Database, PostgreSQL, MSSQL (mssql extension), MSSQL (sqlsrv extension), Oracle, Access, SQLite, Firebird, Informix, Foxpro, ADO, Sybase, FrontBase, DB2, SAP DB, Netezza, LDAP, ODBC, ODBTP
    • Insert dynamic variables from the currently logged in user or from session in your SQL Query to add advanced functionality
    • Populate chart with ArtData dataset - use the quick, easy 'data' view to create a dataset by entering your data into a convenient spreadsheet-like application.
    • Completely style your chart with a custom theme using the 'templates' view
    • Restrict chart access level
    • Show or hide chart title
    • Control chart orientation - horizontal or vertical
    • Set chart title
    • Set chart sub-title
    • Set horizontal axis label
    • Set horizontal axis sub-label
    • Set vertical axis label
    • Set vertical axis sub-label
    • Toggle chart download
    • Set chart download label

    Data Sources

    • Create, edit 'dataset' for a table or chart
    • For chart datasets choose between single series data or multi series data
    • Enter your data into easy spreadsheet
    • Create spreadsheet rows, columns
    • Remove spreadsheet rows, columns
    • Preview how a dataset will look when it populates a visualization

    Dynamic Variable Insertion

    Below you'll see the variables that are available to use automatically from the currently logged in user. You don't have to do anything to set these values, they are built-in and available for use in your Art Data queries.

    Shortcode Description
    {JOOMLAUSER_ID} The currently logged in user's user id
    {JOOMLAUSER_NAME} The currently logged in user's name
    {JOOMLAUSER_USERNAME} The currently logged in user's username
    {JOOMLAUSER_EMAIL} The currently logged in user's email
    {JOOMLAUSER_REGISTERDATE} The currently logged in user's date of registration
    {JOOMLAUSER_LASTVISITDATE} The currently logged in user's last login date

    Custom set session variables can also be used. You can read more about this here.

  • version 2.3.0

    • Build out multi series custom SQL capability for charts
    • Several additional bug fixes, feature improvements around custom SQL charts

    version 2.2.9

    • Add feature to control default pagination limit for each ArtData dynamic table instance
    • Add feature to control pagination limit choices
    • Re-work dynamic table pagination to truncate when more than 10 pages are present
    • Modularize visualization layout code so that one layout is used everywhere
    • Fix bug in setting pagination template settings
    • Fixed bug that caused chart axis generation to act weird with large numbers
    • Fix bug with js search function searchUtil being replicated and conflicting with each other when multiple ArtData Dynamic Table instances exist on the same page
    • Make visualization administrator form validation work better - open accordion nodes where validation occurs

    version 2.2.8

    • Add feature for to allow for use of the string {JOOMLAUSERID} in your SQL Query to add the logged in user's user_id to your query.

    version 2.2.7

    • Joomla site search integration plugin created
    • Added dynamic pagination limit to Dynamic Table visualization

    version 2.2.6

    • Ability to add multiple visualizations on the same page. Add multiple charts, multiple static tables, multiple dynamic tables and all on one page.
    • Fixed bug which filtered some needed characters from custom SQL query content in the administrator and limited the length of the SQL query content
    • Fixed issue with StaticTable table headers displaying as a camelized string. Now all table headers are displayed in the same manner that they are input by the user.

    version 2.2.5

    • Patched critical security vulnerability which in some cases made custom SQL database credentials available (only occurring in visualizations using a custom SQL data source)

    version 2.2.4

    • Fixed issue with Dynamic Table not loading correctly for some Custom SQL types
    • Fixed issue with Charts not loading correctly for some Custom SQL types
    • Begin to integrate Art Data display code into single, modular class to be used everywhere that Visualizations are displayed. This increases stability as we continue our rapid development cycles of new versions every couple of weeks.

    version 2.2.3

    • Upgraded AdoDB to the latest version
    • Fixed bug that caused some of the more exotic database types to not load drivers properly
    • Fixed bug that caused issues with editing database name
    • Fixed bug which caused some custom sql query types not to populate dynamic table correctly

    version 2.2.1

    • Fixed issue causing slow page load time for Dynamic Table and Static Table
    • Added helpful tooltips to visualizations view
    • Added helpful tooltips to data view

    version 2.2.0

    • Entire extension re-imagined, re-designed
    • All configuration has moved to an administrator component UI
    • Module created, Plugin created with use like [artdata id=”1”]
    • Create 'Static Table' - a basic table without sorting, filtering or pagination
    • Create 'Dynamic Table' - a table with sorting, filtering, and pagination
    • Populate table with custom dataset - SQL Query, HTML, CSV file
    • Populate table with SQL Query for the following databases: MySQL - Joomla Database, MySQL - Other Database, PostgreSQL, MSSQL (mssql extension), MSSQL (sqlsrv extension), Oracle, Access, SQLite, Firebird, Informix, Foxpro, ADO, Sybase, FrontBase, DB2, SAP DB, Netezza, LDAP, ODBC, ODBTP
    • Populate table with ArtData dataset - use the quick, easy 'data' view to create a dataset by entering your data into a convenient spreadsheet-like application.
    • Completely style your table with a custom theme using the 'templates' view
    • Restrict table access level
    • Show or hide table title
    • Convert links and images automatically or by pattern
    • Use rel="nofollow" on links
    • Open links in a new window
    • Create 'Bar Chart'
    • Create 'Line Chart'
    • Create 'Area Chart'
    • Create 'Stacked Bar Chart'
    • Create 'Stacked Area Chart'
    • Create 'Pie Chart'
    • Create 'Percent Bar Chart'
    • Create 'Percent Area Chart'
    • Create 'Donut Chart'
    • Create 'Step Up Bar Chart'
    • Create 'Polar Area Chart'
    • Create 'Waterfall Chart'
    • Charts load with cool data population animation
    • Populate chart with custom dataset - SQL Query, HTML, CSV file
    • Populate chart with SQL Query for the following databases: MySQL - Joomla Database, MySQL - Other Database, PostgreSQL, MSSQL (mssql extension), MSSQL (sqlsrv extension), Oracle, Access, SQLite, Firebird, Informix, Foxpro, ADO, Sybase, FrontBase, DB2, SAP DB, Netezza, LDAP, ODBC, ODBTP
    • Populate chart with ArtData dataset - use the quick, easy 'data' view to create a dataset by entering your data into a convenient spreadsheet-like application.
    • Completely style your chart with a custom theme using the 'templates' view
    • Restrict chart access level
    • Show or hide chart title
    • Control chart orientation - horizontal or vertical
    • Set chart title
    • Set chart sub-title
    • Set horizontal axis label
    • Set horizontal axis sub-label
    • Set vertical axis label
    • Set vertical axis sub-label
    • Toggle chart download
    • Set chart download label
    • Create, edit 'template' for a table - style everything about your table
    • Set table class modifiers - condensed, striped, hover
    • Customize table header styles - text align, padding, font size, font weight, text color, border
    • Customize table cell styles - text align, padding, border, striped background color
    • Customize search filter input - height, width, padding, background, border, border radius, text color as well as onfocus styles
    • Customize search filter button - padding, background, text color, border
    • Customize active pagination - background, text color
    • Customize non-active pagination - background, text color
    • Customize focus & hover pagination - background, text color
    • Create, edit 'template' for a chart - style everything about your chart
    • Control main chart background, opacity, width and height
    • Set axis lines color
    • Toggle tick marks
    • Set tick mark interval
    • Set axis padding
    • Control chart color palette
    • Create, edit 'dataset' for a table or chart
    • For chart datasets choose between single series data or multi series data
    • Enter your data into easy spreadsheet
    • Create spreadsheet rows, columns
    • Remove spreadsheet rows, columns
    • Preview how a dataset will look when it populates a visualization

    version 1.7.6 and below

    • Old 33 plugin based component - ‘component of plugins’

Purchase of Art Data includes:

  • com_artdata_j3x.zip - Art Data Component for Joomla 3x
  • mod_artdata_j3x.zip - Art Data Module for Joomla 3x
  • plg_artdata_j3x.zip - Art Data Plugin for Joomla 3x
  • plg_artdatasearch_j3x.zip - Art Data Search Plugin for Joomla 3x site search
  • Exclusive access to free, timely, hands on support via our Support Ticketing system.
  • 1 year of software upgrades!
  • Free, lifetime forum access
C Component

The component administrator is for creating and managing your visualizations. One way to deploy a visualization on the front end is to create a new menu item of type 'Art Data Visualization'. This will use the component output to display your table or chart and using this method the visualization will be the main part of the webpage.

P Plugin

Another way to deploy a visualization is to use the content plugin. Using this method you can write [artdata id="1"] using the shortcode provided for you in the component administrator and you can put this shortcode anywhere on your site and it will be transformed into a visualization.

M Module

The last way to deploy a visualization is to use the module. Simply create a new module instance and select the visualization you'd like to display from the module administrator area, select a template position where you'd like the table or chart to show up and you're done. Three great ways to deploy an Art Data Visualization on your Joomla 3.x site.

Multiple chart and table visualizations can be displayed together on one page! Art Data is a great way to build interactive dashboards for your users.

Visualizations - Administrator Component

Data visualizations are defined as "the creation and study of the visual representation of data, meaning 'information that has been abstracted in some schematic form, including attributes or variables for the units of information'".

The 'visualizations' view is where you will configure your chart or table's basic options such as 'What type of visualization is this going to be? Table or Chart?', 'What type of Table or Chart?,' 'What template would you like to use with this visualization?', 'What dataset would you like to use to populate the visualization?'. You get the picture. The visualization is what ties everything together.

Templates - Administrator Component

The 'templates' view is where you can customize nearly everything about the way a table or chart looks including color palette, responsive width %, class modifiers, text alignment, padding, border and more. Art Data allows you to customize pretty much everything about the look of the data visualization. Templates you create can be added to a visualization to easily apply a certain style.

You don't need to have any CSS knowledge whatsoever to use our template builder to style a table or chart template.

Data - Administrator Component

The 'data' view is where you can create a dataset by entering your data into a web spreadsheet application that is built right into Art Data. The data view was specifically created for the purpose of easy data population because not everyone knows how to write an SQL Query. Create datasets specifically for tables or if you're using a chart then you can select either single series data or multiple series data. Formatting data for populating a visualization has never been easier.

Chart Examples - Site

Table Examples - Site

If you use Art Data, please post a rating and a review at the Joomla! Extensions Directory.

Related Products

Results 1 - 3 of 3