Introduction

Graphs and Charts, Core Enhancements, Data Reports, Tables & Lists

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. Custom templates can be created to control the look 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. Add multiple visualizations on the same page to create cool, custom dashboards without the need for custom coding expertise!


Let's Tour Art Data

1. Visualizations

Data visualizations are defined as "the creation and study of the visual representation of data".

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.

Visualization Type - Tables

  • 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

Visualization Type - Charts

  • 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
  • Multi series custom SQL capability for charts
  • 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.
  • Insert dynamic variables from the currently logged in user or from session in your SQL Query to add advanced functionality
  • 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

Dynamic Variable Insertion for SQL queries

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.

  • {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:
https://www.artetics.com/view-article/116-art-data-dynamic-variable-insertion-into-sql-queries

2. Templates

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.

Template Type - Tables

  • 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

Template Type - Charts

  • 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

3. Data

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.

  • 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

4. Deploying a Visualization on your Joomla Site

Art Data consists of a component, module, and plugin so you can deploy a table or chart on your site in whatever way you prefer.

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.

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.

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.

Functionality
The component is very stringent: you are not allowed to manage much
Ease of use
This is not user friendly and I would not dare to grant access to it to a customer...
Support
There is a ticket system... where no-one cares to answer to you...
Value for money
If you do not need to replicate the very identical layout of their example, you are doomed to insuccess. Switch to something else
I used this to: I used this just to waste my money and look for another component

Just what I needed



Posted on 24 October 2019
Functionality
Plain and simple to use, easy to install. Delivered all searches correctly
Ease of use
Very easy to use, no gremlins and easy to configure. For users it gives easy search option
Support
Not needed yet as everything worked - will check out in the future if needed
Documentation
Explains everything I needed to configure the software. All in plain and simple language
Value for money
Excellent value for money on what it delivers - many other items sililair a much bigger cost
I used this to: Joomla website for dogs searching dog results by year and by breeder

Great Product!



Posted on 22 March 2019
Functionality
It has several options of results and all configurable in a practical and objective way, without confusion.
Ease of use

Unlike many where the user gets lost in the options, in this they are organized, practical and effective.
Support

Always kind and available to help.
Documentation

Written directly and clearly, it shows how to configure each extension option.
Value for money

Analyzing the results and possible applications for this extension, I understand that the price is very nice!
I used this to:
Show information generated by corporate system on volunteer projects website of Fluminense Federal University (Brazil).
I used this to: Nothing because I can't. It doesn't work.
Owner's reply: Hello Intelligencia, it's disappointing to learn that you had such a negative experience with Art Data. Reviews like this don't help either one of us get closer to achieving our goals and I'm afraid they don't help other users to make an informed decision about whether Art Data is suitable for their web software use cases. We've had hundreds of satisfied users and a zero rating calling the software useless just doesn't help us to improve and it doesn't tell anyone what you had an issue with. If you need help I'd encourage you to submit a support ticket or contact us directly at info@artetics.com so we can help you.
Functionality
If you're just after some basic charts then this component is OK, but their styling ability is very limited and it's layout is not flexible.
Ease of use
It's fairly easy to use for basic needs.
Support
Support is pretty poor. Their responses are slow (weeks) and they don't address all your questions. Promised updates we never delivered.
Documentation
Documentation is OK.
Value for money
Good for basic use, but not for any more than that.
I used this to: I was going to use this to add a couple of donut charts to a site. Because of issues they were not able to resolve I went to a different solution. I persisted with their support for 2 months before looking at another solution.

Great Extention!



Posted on 21 July 2016
Functionality
Provides an outstanding searchable table. We are using it to provide voters with 10,000 + listings
Ease of use
On the front end it works perfect, but don't leave blank columns and be sure your Column Headings are filled in.
Support
I did have a little trouble installing (see Ease of Use above) but I got prompt, courteous support. Very pleased with the support!!
Documentation
A little difficult for me to follow. Could be a little more detailed for Dummies like me ;-)
Value for money
Worth every cent it costs.
I used this to: Voters List

Hopeful, but not quite there



Posted on 21 January 2016
Functionality
It has promise, but lacking documentation on their website to fully utilize this
Ease of use
Using plugins are pretty simple, but again lacking documentation on the authors website it makes it difficult to troubleshoot
Value for money
If you are lucky enough to get past the plethora of javascript errors on the backend and get the plugins to work
I used this to: attempted to use this for data reports generated from CSV files
Functionality
Did exactly what I needed.
Ease of use
Very easy. Sample codes on the site is a great start, adding the samples to the plugin page in the component would be my only recommendation
Support
Didn't realize it came with support in the beginning but a quick email to the publisher got quick support and had me up and running same day.
Documentation
Could use more, but is a really good start. Could use more troubleshooting such as what could be wrong if you're seeing 'this'.
Value for money
Worth every penny. One of the best investments I've made.
I used this to: Pull field data from the latest form entry to update the name of the winners and the date of the win in a sentence on a contest page. Ability to update page information via simple form entry, w/o opening and update each one manually. Huge time saver.
I needed a plugin in order to build a gallery with a magnifier on the enlarged image. Te Artdata component was the one that was close to what I wanted. I bought te component an implemented te code into another plugin.

When I didn't get it completely right the team responded on my questions swiftly. When it was finished it seemed that in certain browsers the loading had some hickups. After sending my question the team updated the component and it worked perfectly afterwards. In addition, they even sended the updated files as a zipped component, ready for install. brilliant.
We have been using this set of plugins for 3 years now and it has been great. Very clean, efficient and easy to install and use.



We just had a jQuery conflict and the support team has been extremely responsive. They spent 2 days with us to try to figure out the issue and resolve it. We got it done. Very awesome and probs to the team.



Low cost, high quality. Thank you guys.
Art Sexy Lightbox
Paid download

Art Sexy Lightbox

By Artetics
Multimedia Display
Art Sexy Lightbox v2.1.85 is a Joomla! plugin and module for photos, galleries, articles, Imgur albums, Instagram albums, Instagram tags, Picasa albums, Google Photos, Flickr photos, Photobucket albums, VirtueMart, Amazon S3, external pages, Youtube, Vimeo, and inline content in a beautiful and customizable lightbox. Art Sexy Lightbox comes with module and plugin which allows you the flexibility...
Art Frontpage Slideshow
Paid download

Art Frontpage Slideshow

By Artetics
Slideshow
Art Frontpage Slideshow is a slideshow module that adds front end animation that attracts visitors and allows to show images of featured products and news in a nice eye-catching way. Features: 54 transition effects Highly customizable NO flash, pure javascript. This means better performance and NO requirement to have flash plugin installed Does NOT use mootools or jquery library to avoid confli...
Art Table
Paid download

Art Table

By Artetics
Data Reports
Art Table full version extension is a module that can be used to show sortable, filterable, customizable tables or charts via the Google Charts API from SQL query, CSV file or HTML table. This is the perfect module for anyone who has ever needed a way to display tabular data or graphical data on your site. At Artetics.com we take great pride in our extensions and our support and service to the J...
Art Image View
Paid download

Art Image View

By Artetics
Slideshow
Art Image View is fancy and customizable image viewer with multi-language support, slideshow functionality and keyboard access. Features: Ever wanted to display local images or Flickr photos in a firm way with ability to run a slideshow? Then this extension is for you- Multi-language support. Supported languages: Arabic, Czech, German, English, Spanish, French, Hebrew, Interlingue, Italian, Dut...
Art Calendar
Paid download

Art Calendar

By Artetics
Events
Art Calendar is a Joomla! component that is used to create visually rich, interactive, modern calendars that can be quickly deployed on the front end of your Joomla site. Easily populate calendar with events from the Art Calendar administrator area or from Google Calendar API, or both! Add Google Maps API locations to your events, create recurring events and attach documents and files. Between t...
Art ZoomIn
Paid download

Art ZoomIn

By Artetics
Images
Art ZoomIn - Tool for zooming images and creating image galleries in Joomla! Features: Easy way to zoom images Can display series of images to zoom, galleries Pure javascript, no flash Zoom window can be shown on the left, right, top, bottom, inside original image Several customizable properties like opacity, position, width, height, etc. Can display image descriptions Thumbnails can be places...
Art Gallery
Paid download

Art Gallery

By Artetics
Galleries
Art Gallery is responsive image gallery component with nice zoom feature. Features: Create gallery, indicate image folder and you are all set 2 layouts: random image positions (responsive) and rows/columns Rotates images within a defined angle Several settings Lightbox (zoom) feature when image is clicked Can go through the images in a lightbox Images can be dragged and dropped on the page Thum...
Art Book
Paid download

Art Book

By Artetics
Articles Display
Art Book is a book styled content display module for Joomla 2.5 and Joomla 3.x. Display many types of content in a book with pages that actually turn like the pages in a real book! Features: Can show articles in a fancy flip book format Indicate category (and section) and you should be all set Can show K2 items as book pages Javascript/CSS only. No flash Fully customizable with CSS Can show num...
Art Responsive Menu
Free

Art Responsive Menu

By Artetics
Menu Systems
Art Responsive Menu is free responsive menu module with different themes. Features: Free Behaves smart on large and small screens 4 different types of menus Navbar menu type List menu type Nav menu type SubNav menu type Comes with three themes Can show child items Can show logo Can show branding Many browsers supported Control Menu Item ordering Sort Column: id, ordering, title Sort Direction:...
Art Timeline
Paid download

Art Timeline

By Artetics
Events
Art Timeline enables anyone to build visually rich, interactive timelines on their Joomla website. Load events from Art Timeline Administrator, Google Drive, Google Calendar or SQL Query. Timelines Create highly-customizable timelines from the Art Timeline administrator Google Calendar API Integration Google Drive API Integration Add template to timeline to control look and feel Start timeline...
Art Org Chart
Paid download

Art Org Chart

By Artetics
Education & Culture
Art Org Chart is Joomla! component to build and show organization charts. Features: Create multiple organization charts for Joomla! Single or multiple parent items possible Items can have description, links, images Easily customizable via CSS Nodes can be collapsed/expanded Access rights support Supports Joomla! 1.5, 1.6, 1.7, 2.5, 3.x...
Art Store Locator
Paid download

Art Store Locator

By Artetics
Maps & Locations
Art Store Locator module allows to show stores on map...
Art QR Code
Free

Art QR Code

By Artetics
QR Code
Art QR code is free Joomla! module that allows to show QR codes of different sizes in Joomla! articles and module positions. Features: Free module Easy to use Can convert text, links, images to QR code Different QR code sizes supported...
Art Flip
Free

Art Flip

By Artetics
Portfolio
Art Flip allows to display image sets using nice flip effect. Features: Nice flip effect - image transition clicking images corners Reads images from indicated folder and displays them with flip effect Customizable settings: width, height, background color, corners position, scale method No flash. Pure javascript Images can be organized as a flipping book...
Art Easy Accordion
Free

Art Easy Accordion

By Artetics
Articles Display
Art Easy Accordion is fancy accordion for Joomla! content with slideshow. Features: Place any HTML/image/text to attract visitors Show multiple accordions on single page 2 predefined styles Slideshow/autoslide support Fully customizable with CSS Name slides as you need Can show numbers for slides Several customizable settings...
Art Modern Zoom
Free

Art Modern Zoom

By Artetics
Images
Art Modern Zoom is a plugin that can add a zoom in effect to your content. This is the perfect way to get a better look at an image or any other type of inline content on your Joomla site. Use with image content or inline content Easy to use and very flexible plugin shortcode Control the zoom effect with precision using the following plugin parameters: - targetsize - zoomed size relative to...
Art IDComLog API
Paid download

Art IDComLog API

By Artetics
HikaShop extensions
Art IDComLog API is a component and plugin that facilitates the API integration between Joomla's Hikashop shopping cart and ID Commerce + Logistics. Send your shopping cart order data to ID Commerce + Logistics so that they can fulfill/dropship your orders for you. * Integrate your Joomla Hikashop shopping cart with a premiere drop shipper. * Hikashop Plugin for sending order data at time of orde...
Art Feature Tour
Paid download

Art Feature Tour

By Artetics
Tutorials
Art Feature Tour is a step by step guide and feature introduction tool for Joomla to give your users a 'tour' of areas of importance to your site or web app. Highlight navigation, action buttons and other parts of your site for increased user understanding of your product. - Create 4 types of feature tours - Basic Box, Artsy Circle, Illumination, Technical - Control when Art Feature Tour display&...
Art Fast Youtube
Paid download

Art Fast Youtube

By Artetics
Social Media
Reduce YouTube video load time and make your YouTube videos responsive at the same time! When YouTube videos are embedded on your website using standard IFRAME tags, the web page has to download around 0.5 MB of Images, CSS and Javascript for rendering the YouTube video player in the IFRAME and the files are downloaded even if a visitor on your website hasn't watched the embedded YouTube video. N...
Art Notify Bar
Free

Art Notify Bar

By Artetics
Notes
Art Notify Bar is a highly configurable Joomla module for showing a notification bar across the top or bottom of your webpage. Art Notify Bar has a wide array of possible including displaying important information to site visitors or showcasing a product or service in a place where users are guaranteed to notice without being overly intrusive to visitors browsing your site. Set notification bar...

Art Data

Version:
2.3.2
Developer:
Artetics
Last updated:
Jun 23 2020
3 years ago
Date added:
Sep 02 2009
License:
GPLv2 or later
Type:
Paid download
Related extension :
Art Table
Includes:
c m p
Compatibility:
J3
Download

Uses Joomla! Update System

Score:


Write a review