- Data Reports

ARI Data Tables

ARI Data Tables

Paid download | Data Reports | ari-soft.com
3
Score:
100
46 reviews
ARI Data Tables module converts HTML tables into powerful and functional tables with possibilities to sort, filter and paging data. It can also create different charts based on data from tables. The extension can load data from SQL databases and CSV files. Main features * User friendly interface; * Can load data from Joomla! database or from external database. Many different database types is supported; * Can load data from CSV files (can load remote CSV files, provides ability to use "contains" and "equals" data filters); * Provides a variety of widgets to display data: ARI Data Table, ARI Table Sorter, ARI Data Visualiser, ARI MooTable, ARI GChart, ARI Tiny Table; * Can show loading icon until the data are loaded; * Can add vertical and/or horizontal scrolling to large table (This ability provides "ARI Data Tables" widget); * Provide possibility to render plain HTML table based on data from CSV file or database. Display of this table can be customized with help CSS; * Adds filter, sorting, paging functionality to table; * Can recognize links and converts them to HTML representation. Target attribute of a link can be specified; * Creates charts based on data from table; * Multiple instances of the module can be used on one page with different settings; * Provides possibility to configure different columns parameters; * "ARI Data Table" widget supports server side pagination for "SQL" source type; * Highly customizable; * Works in all modern browsers; * Can display module in Joomla! articles with help ARI Data Tables plugin.
m p
jDBexport

jDBexport

Paid download | Data Reports | Schultz IT Solutions
3
Score:
100
40 reviews
jDBexport allows you to deliver any data from your databases (JOOMLA and others) as Excel documents directly to your users. Write any valid SQL query in the administration of this component and combine such queries into multiple Excel worksheets/workbooks. The query is executed when a user clicks the downloadlink (frontend or backend) and the current result of the query is delivered to the user as a downloadable Excel file (or any other of the below listed document formats). With the on-the-fly ajax-driven SQL syntax checker, the multitude of available export dataformats, formatting options and a great number of database drivers to get your data from, jDBexport is very likely the most exhaustive reporting instrument and data mining tool available on the market. Main features create data reports in various formats (xlsx, xls, ods, csv, html, pdf, json) from your databases individualise these reports with variable substition (such as userid or current date) or parameters entered by the user embed graphical charts (bar, pie, area, line, etc.) based on the requested data into your worksheets format these reports with colors, fonts, backgrounds (also alternating backgrounds), images, headers and footers, borders and more use a wide varity of conditions (including the result of SQL queries) for conditional formatting add additional cells with text, images or results from additional SQL queries define autofilter areas within your worksheets add any additional files (e.g. Excel Makros in an *.xlmx file) along with your workbook when compressing is activated deliver these reports regularly and fully automatically to your users, utilising our sophisticated scheduler define SQL based rules whether to run the scheduled task or not or let the users request these reports online or in the background or through the GoogleDocViewer or let the users preview these reports in a HTML preview within your website or prepare these reports (without showing them) for post processing with individual programs include virtually any accessible database - local or remote - into your reports (MySQL, MariaDB, MS-SQL, ORACLE, SQLite3, DB2, INGRES, SAP MaxDB, PostgreSQL, Firebird and others) check the validity of your SQL query with our on-the-fly (AJAX-driven) SQL syntax checker, while preparing the worksheet get inline help on creating your SQL queries, or reference the SQL manual that corresponds to your environment and many, many other features... jDBexport is translated in many languages (you can help us here...) -jDBexport comes with a set of additional tools (frontend and backend module for easy access to your workbooks, datagrid and datafield plugin to embed worksheets or a single cell from a worksheet into any Joomla content, workbook link plugin to style jDBexport workbook links according to your template, support for additional Truetype fonts in PDF creation) ... If you are missing a specific feature, call us and we will find a solution... jDBexport was originally forked from the well known (Joomla 1.5 data reports) extension SQL2Excel (actually SQL 2 Excel Pro). For helping with the translation of jDBexport into your own language, please visit or translation project at TRANSIFEX.com https://www.transifex.com/schultzitsolutions/jDBexport/ For more details, please visit our website at http://it-solutions.schultz.ch/index.php/en/jdbexport
c m p
Art Table

Art Table

Paid download | Data Reports | Artetics
3
Score:
98
38 reviews
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 Joomla Community. If you have any questions please contact us at Artetics.com, post in our support forum, or submit a support ticket to our team. We're here to help. Features: Supports 4 table types, each with its own functions and styles Tables are sortable, resizable, filterable. Pagination support Can show sortable grid from HTML table, CSV file, SQL query Multiple databases are supported: you can easy get any data from various database types and show it in a nice grid: MySQL, MS SQL, Sqlite, Postgres and may others Create and display line charts, area charts, bar charts, column charts and pie charts from HTML table, CSV file or database query. Charts are cross-browser compatible and are generated using the Google Charts API. Can generate Excel/XLS files from SQL query, working as SQL 2 Excel Module comes with dozens of themes for Data Table Can recognize links and images and show them in a table Easy to apply external and internal styles Supports predefined parameters to passed to SQL query: USERID - currently user ID; ARTICLEID - current article ID
m
vChart

vChart

Paid download | Data Reports | WDMtech
3
Score:
98
18 reviews
vChart offers you the possibilities to convert your data from Local / Remote Database tables, CSV files / Feeds, Inputted manually into Powerful charts or tables. vChart is an advanced charting Joomla component that fulfills any data visualization need. It contains a lot of customizing options and a very simple and intuitive data input option in back end. You don't need to worry about data format to input. It eases the inclusion of charts within your articles and various module positions. It is based upon the Google API. vChart can generate all major types of chart like Line Chart, Area Chart, Stepped Area Chart, Timeline Chart, Column Charts, Combo Charts, Annotation chart, Geo Charts, Maps Charts, Candlestick Charts, Table, Scatter Chart, Gauge, Bubble Chart, Pie Charts, Slice Pie Charts. With vChart, you never have to start from scratch as it has a collection of 20+ live examples in the package which makes it easy to get started with vChart. vChart Scope: This tool is of best use to people from various Business areas. Few of them are listed below. Corporate purposes: - Make online Charts for your staff training and other corporate sections example. Growth, Loss, Income and expenses etc. Stock Market or Equity Market: - It plays a vital role in Stock Market for Live trading statistics, Currency fluctuation, Sell stocks, Prices conversion rate etc. Financial System: - Reporting and tracking the market targets of companies is best managed by creating graphs and charts to visualize data and comprehend statistics. E-Learning: - Charts have the power to enhance the interactivity of eLearning courses. Brand promotion: - Increase popularity of your brand entertaining your site visitors. To do that, just create the engaging online Charts for Joomla! And launch a challenging competition. Web Applications: - Nothing beats visualization to show us what we need to know at a glance. vCharts makes it easy to show data visually and beautifully (with pie charts, bar graphs, or area charts etc.) in many ways like which users have the best reputation, which products sell best, or which topics are most active. Project Management: - Project management is not an easy job as a single project can involve multiple companies and teams so managing different people and tasks can be a tedious task. For completion of a successful project vChart is the best choice which can be used to gives a visual picture of the whole project in an easy to understand format. Strategic Planning: - Charts plays a vital role in the Strategic planning which can be used to determine mission, vision, values, goals, objectives, roles and responsibilities, timelines, etc. Infographics and Demographic: - Charts are great tool to make impactful infographics and demographic and easily bring life to a data statistics in a few clicks. Survey Results Report: - Charts are very useful in Surveys where it can be used for communicate your survey results. vChart package contains 1 Component, 1 Module & 1 Plugin: vChart Component:- This is the main extension. Other extensions are dependent on this. vChart Module:- Allows you to display ‘n’ no of Charts on a single page with different modules. vChart Search Module:- It's an AJAX based chart search module which allows you to search and plot the charts based on the Search Keywords. vChart Content Plugin:- You can also embed Charts in Articles, K2 Items and other Content Items using Keyword {vchartmodule,ChartId}. Most Sparkling Features: vChart is built using HTML5, to provide cross-browser compatibility and cross platform portability to all mobile devices example. iPhones, iPads, and Android etc. Allows you to create several types of charts with different data set combination. Allows you to select any existing database table where you can select any column for creating different Charts. Allows you to write custom MySql queries to fetch data in order to generate charts. Allows bulk import of charts data into any existing Chart from CSV File, stored on your local computer. Allows to import charts data from "CSV-File-URL", stored on remote server. Can quickly copy an existing Chart to make a new Chart with some modifications. Allows you to connect any external database and there you can select any column for different Charts parameters from that table. Provides you an option for Chart preview at backend before publishing at front end. Main Features List: RTL compatible. Very flexible and fully responsive. User friendly UI (User interface) and very easy data input methods. Different advance formatting parameters based on Chart Types. Ability to add various control parameters on Chart Title example Hide, Show, Bold, Italic, Fonts, Font Size etc. Modes of input for Chart Width and Height a) Pixel and b) Percentage. Ability to add various control parameters on Chart Background example Fill Color, Stroke Color, Stroke Width and Transparent. It allows you to upload Chart background image. This uploaded image can then be used in background of a Chart Div or Chart area by selecting the respective buttons. Support various charts type example. ine Chart, Area Chart, Stepped Area Chart, Timeline Chart, Column Charts, Combo Charts, Annotation chart, Geo Charts, Maps Charts, Candlestick Charts, Table, Scatter Chart, Gauge, Bubble Chart, Pie Charts, Slice Pie Charts etc. It allows you to input Charts data in various ways- Chart Data Manually,Chart Data from CSV, Chart Data Existing Database and Chart Data Other Database. Settings options for Padding, position, tool tip style, point value styles etc are available so as to make the input more streamlined. Ability to add various controls on Chart Axis Parameters example Label Title, Value Title, Series Name, Apply color to each Series Name value etc. It allows you to show your data from existing database table on the Live Chart and Chart Data will be automatically refresh and update after a given specific time interval. Option to show / hide download or print chart at front end. Option to show / hide social sharing buttons example. Twitter, Linkedin or Facebook etc. Picks data continuously from dynamic csv getting data from external source. Allows you to use dynamic variables ( GET / POST & logged-in User ID) in your custom MySql queries. The vChart component can be easily translated into any language. French, Russian, Spanish, Polish, Italian, etc. Note: Please post on our support forum or email us if you need some help in setting up vChart on your site. You'll get a reply within 24 hours.
c m p
Art Table Lite Edition

Art Table Lite Edition

Free | Data Reports | Artetics
3
Score:
97
14 reviews
Art Table Lite Edition - Free module for creating and displaying tablular data from SQL query on your Joomla site. At Artetics.com we take great pride in our extensions and our support and service to the Joomla Community. If you have any questions please contact us at Artetics.com, post in our support forum, or submit a support ticket to our team. We're here to help. Features: Free Simply indicate SQL query - and you are all set! Table is sortable, filterable and has pagination. Has functionality to detect current user ID and use it in SQL query. For when you need to display some data that is unique to the logged in user. Does not include Google Charts API integration or ability to generate tables from CSV or HTML. See full version for this functionality: http://extensions.joomla.org/extensions/core-enhancements/data-reports/12771
m
Alter Reports

Alter Reports

Paid download | Data Reports | AlterBrains
3
Score:
97
13 reviews
Complete full-featured tool for preview and download of SQL reports in your Joomla site. AlterReports was designed as a native Joomla reporting extension which covers all needs and aspects of reports for your website. Using SQL queries with rich filters and conditional statements allows you to view and download reports of your database data in most convenient way. Advanced customization settings allow to adjust visual presentation of your reports. Access permissions help to control which reports and which report columns to display for certain usergroups, allow/disallow download formats etc. Features: View and download reports in both frontend and backend. Nested categories for reports. Frontend views of categories (list of categories), category (reports from category) and single report. Using different databases for loading reports data. Standard Joomla database drivers are supported including MSSQL via 'Microsoft SQL Server Driver for PHP'. Creating of reports by entering SQL query, editing of query with SQL profile and explain results, easy inserting of tags and database tables into query. Configurable filters for reports of few types (text field, text area, drop-down lists, checkboxes, radio inputs with either manually entered options or options loaded via SQL query), filter's values can be used in query as via tags. Conditional statements for query: certain parts of SQL can be executed only if filter's value was entered. Search in report and download selected rows only. Ordering of report by column. Report can be downloaded in configurable CSV, XLS, XLSX, PDF, HTML and XML formats. PDF documents can be customized via custom HTML templates. Rich customization of report views, HTML, XLS and XLSX formats (borders, colors, backgrounds etc., separate styles for headings, subheadings, data rows and footer row). Subheadings with ability to span above few heading columns. Footer row: each column can have custom footer value or auto-calculated values (minimum, maximum, average and sum). XLS reports can have footer values either pre-calculated or have formulas (built-in AVERAGE(), SUM(), MIN(), MAX() or you can use own formula with replaceable tags of column data rows coordinates). Each report column can have own style applied for report views, HTML, PDF, XLS and XLSX formats. 3-levels of style settings: global settings, individual report settings, column settings: you can easily change styles for all reports. Count of report views and downloads. Access levels for categories of reports, reports, available formats and columns. HTML and PHP pre-processors for columns values: you can wrap a value into HTML code or change it via PHP. Current Joomla user-related and GET variables tags with conditional elements in query (query can be different for user with different usergroups). Ability to delete selected report rows in backend and frontend. Ability to embed reports into articles via special {reportid=x} tag (Joomla content plugin is included). Ability to group report rows by column. Ability to email reports via special link (great feature to receive reports scheduled by a cronjob). Import/Export of reports in XML - helps to transfer your reports between local and live servers. Custom .ttf fonts support for HTML-based reports including PDF (fonts are embedded into .pdf documents). to be continued...
c p
Reportico

Reportico

Paid download | Data Reports | Peter Deed
3
Score:
97
3 reviews
Powerful SQL-based designer creates and runs reports against your Joomla! or other database from the backend and then makes them available within your Joomla! web pages. Packed with display and filter options! Reports are generated using a powerful report designer which allows you to enter SQL queries to fetch data and then design a front end criteria page for allowing users to filter by selecting from database-driven list boxes, checkboxes, radio buttons and other controls. Use the designer to create groups, group headers, group sums and trailers, charts and complex custom expressions by including PHP code within report definitions. As well as HTML web reports, Reportico can generate data in PDF and CSV formats as well a sortable, searchable grid. The reports you create can be embedded into your Joomla! website pages. Reportico allows you to control user access to an individual report or to a menu for a complete set of reports. It's also a great way to just publish a table of data within a page just by embedding the output of a report. If you allow your users login then reports can be configured to only return data based on their login id. With knowledge of SQL, it is a quick job to produce a set of simple tabular reports. But with knowledge of a few features we believe it is possible produce your data in almost any way using Reportico. We at Reportico know many of these tricks and only too happy to share them. Once you need Reportico to do just that little bit more, you can drop us a line on the support forum or email us, details are on the web site. **New in Reportico 4.6 ** - New look with new controls and new graphics - New Portuguese and Spanish translations of Reportico - Complete set of tutorials and sample data to get you going - Help tooltips for criteria filters - Related filters can be collapse down to increase the real estate - Ability to make a criteria entry mandatory - New searchable list boxes for easy filter creation - Compatibility with PHP7.0 - More flexible report styling for HTML and PDF using reportico_defaults.php
c m
SQL Reports

SQL Reports

Paid download | Data Reports | Jockham
3
Score:
96
3 reviews
Do you want to execute/create SQL queries and make the results visible in your Joomla? hehe... So easy that you don't believe it. Write the query and the extension does the rest! You'll get a nice report with an Excel export button too. Why this extension and no other? - Responsive design that works in all screens (see live demos). - Manage your own SQL queries and make the results visible in seconds. - No hard configuration that makes you crazy, just create queries and view a very nice and useful reports. - You can hide/show title, excel export button, pagination, sort, etc. - Multiple reports in the same page with no conflict at all (others do!) - It works on any version - Special tags available to use inside queries to allow queries like ... SELECT * FROM #__users WHERE id={loggeduserid} - Component and module There are some suggestions about possible use: - List of users - Last users comments in your web - Make visible information about your own tables - Get administrative reports to your clients in a menu - ... anything you want! Our philosophy is clear... Responsive, simple, useful and good looking in all our extensions. Visit us on www.jockham.com to see live demos! NEW in v1.2 Added tags {loggeduserid},{loggedusername} and {loggeduseremail} to use inside queries
c m
Live Graph JX

Live Graph JX

Paid download | Data Reports | Tools JX
3
Score:
96
2 reviews
With Live Graph JX you can get your data moving. Set up a graph and display it directly from the data stored in your database and insert it into an atricle. You can select multiple datasets to be displayed on the same chart. You can display graph dinamically, which means that in each step another part of your data is displayed. This results in the graph line that moves across the graph area as you can see on the example below. Key features: Simple and Intuitive User Interface Simple database table and column selection and renaming Dynamic representation of your data Line and Bar charts supported Dimension and color adjustment Legend position adjustment Remote Database connection ... The admin interface is very similar to other Tools JX products. It allows you to select a database table from the list of all tables. Further more you can select and rename data sets from the selected table, set the color of the graph lines and more. There is also a simple preview is included within the admin interface. This product is suitable for any kind of data reports. For example to generate an online report of your web store, webpage statistics or any other kind of dynamic report that you want to represent graphically to yourself or to your users. You are invited to take a look at demo and documentation pages for more information.
c p
JGrid

JGrid

Paid download | Data Reports | Sealogix Corp.
3
Score:
93
8 reviews
Display & Edit Data & Images In Grid (spreadsheet) with Granular (Row and Cell Level) User Access Control. Custom SQL Queries. Query any data in Joomla or MYSQL database to show on your grids. DATA GRID Component built on the popular EXTJS Framework. Features spreadsheet like DATA GRIDS to DISPLAY and EDIT tabulated data including Images for Joomla Websites in a TAB PANEL Layout. The free version allows the Administrator to add and edit data in the front end grids. The club(commericial version) includes a complete user ACCESS CONTROL system to control what individual "USERS" or "ROLES" (groups) can do to specific grids, sheets in grids, or columns. The free version has no cost ever and provides full access to our regular updates. The Club Commercial Version has yearly or unlimited lisences) Full Joomla backend capability to create custom datagrids with text, number, date, boolean and list box columns. A. Data Grid Frontend Features: ------ Spreadsheet like user interface for viewing tabulated data. See our SCROLLABLE TAB PANEL User interface ------ Edit Row Data (Admin only in Free Version) ------ Sorting by Row ------ Grouping Rows ------ Row Color Change based on user selection ------ Paging Rows from Server ------ Filtering from Server ------ Access Controlled data editing (Club Version) ------ Column re-ordering and Hiding ------ Custom Popup Tips for Each of your columns to describe data ------ Ability to Create, Rename, Delete new Sheets. A "Sheet" is similar to an excel sheet.Grids can have multiple sheets(A good way to provide user specific data). B. Data Grid Backend Features ------ Create Grids selecting various styles including columns, striped rows, row numbering, grid framing, etc. ------ Create Custom Columns ------ Manage Various Grid display Settings C. Grid ACCESS CONTROL (club Version) - A complete user access control system to control what individual "users" or group "roles" can do to specific grids, sheets in grids, or columns. o Control access by: ------ Grid ------ Sheet ------ Grid/Column ------ Sheet/Column ------ Sheet/Column/Row o Progressive Access Assignments: ------ No Access ------ Viewer ------ Viewer / Download Images ------ Cell Editor ------ Row Editor ------ Add/Delete Rows ------ Sheet Manager, ------ Access Manager o Full control from administrator backend, limited control for "Access Managers" in front end for specified Sheets o Create Roles for Access Management or Manage Access by individual User D. LANGUAGE SUPPORT - Designed to Support Joomla Language Packs (English Provided - Language Files available for easily translation to your local language for both front end and backend) E. FREE & CLUB MEMBERSHIPS - Joomla component (Public) and a module (DATACLUB Members only) are provided to allow full integration into your Joomla Website. Club Membership also allows Access Control Configurations
c m
Table JX

Table JX

Paid download | Data Reports | Tools JX
3
Score:
86
8 reviews
Table JX is powerful tool for Joomla! users who want to show database table on their Joomla page. Table JX can quickly fetch the data and display data in a form of sortable and searchable grid or table right on your article page. You can display data from Oracle, Microsoft SQL, MySQL or MySQLi database. The grid or table was designed to be fully customizable, so you can select which table columns you want to show, you change the display names of table columns or even create a filter to show only filtered data in a table. The displayed table is searchable and sortable. Many search options are included and can be set up easily. In a very simple way you can display data page by page, you can quickly access the last or the first page in a table. In the header of the grid or table you can sort data just by clicking on the table column header. There is no limit how many grids or tables you can show on the content page, as far you have enough space. It is very easy to display a grid or table in the content page. You just click on the editor button select prepared table (grid) that you want to display. Table JX is very useful tool if you want to show your business partners real-time data on your joomla's page from your database. Be far ahead of your business competitors and offer immediate access of your prepared data to specific business partners. Excelent tool if you want to display sortable table with data from your database on your web page! Search engine friendly (SEO) On Table JX was made a great effort to be as much "search engine friendly" as possible. This functionality enables that records in a grid or table are indexed by search engines, like Google, Yahoo, Bing, etc... If you have some, let's say, products in a grid or table , search engine finds them easily. This could be a great benefit for your business. Linkable content Linkable content enables that you just click on a value in a grid or table and this action opens specific URL or specific joomla Article, Category or even Section. Second order by If you are not familiar with SQL or you just don't have time to create a sql view and show it in Table JX grid, you can in admin section with few clicks create a grid or table with data as you wish. 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. User's specific data Create filter to show user's specific data to the currently logged in user. Multilanguage support Ideal for CRM, e-commerce, scientific data, real-time data, competition results, weather reports, database comparison, timetables etc.
c p
Art Data

Art Data

Paid download | Data Reports | Artetics
3
Score:
81
56 reviews
Art Data v2.2.9 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 Use the string {JOOMLAUSERID} in your SQL Query to add the logged in user's user_id to your query. 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 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. Use the string {JOOMLAUSERID} in your SQL Query to add the logged in user's user_id to your query. 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 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.
c m p
Price Chart Plugin for Hikashop

Price Chart Plugin for Hikashop

Free | Data Reports | Trangell
3
Score:
39
2 reviews
One of the Joomla powers over other content management systems is Online Store components.This features let users to make powerful online store in Compared with other content management systems. In the meantime a very popular component is Hikashop . A simplified version of Hikashop price chart for Hikashop component. This system using chart.js, this plugin is integrated with popular Joomla framework components and plugins. Note: The next version will be prepared with useful features of The extension, which will soon be released. github : https://github.com/shahryarjb/hikashop-Price-chart-plugin
p
VJ Basic Table

VJ Basic Table

Paid download | Data Reports | VJ Tools
3
Score:
0
0 reviews
VJ Basic Table - Simple and responsive Joomla! table module. Table can be constructed from HTML, SQL or CSV. VJ Basic Table Joomla! module displays tables from various data sources using a mobile layout on small screens. TOP FEATURES CSV, SQL, HTML Create powerful and dynamic responsive tables from CSV files, SQL queries or HTML tables. Static and dynamic tables You can create either static or dynamic tables depending on your data source. Customizable CSS You can easily customize the table through CSS and achive the look of the table that perfectly blends with your website. Other Notable Features Static tables. Tables created with VJ Basic Table are easy to edit Dynamic tables. Tables can be created from SQL query, CSV file, HTML table The following database types are supported: fbsql, gladius, maxdb, msql, mssql, mssqlpro, mysql, mysqli, mysqlt, odbc, postgres, postgres64, postgres7, postgres8, sqlite, sqlitepro, sybase, sybase_ace. To work with some databases, an appropriate php extension may need to be installed and enabled Responsive. Changes to a beautiful mobile view layout on small screens You can use dynamic variables in SQL query, like currently logged in user ID, name, etc. Javascript powered, fast and smooth This is open-source software under GPL license
m
DB Embed Pro

DB Embed Pro

Paid download | Data Reports | Factory.DocWriter.Ru
3
Score:
0
0 reviews
Embed any information from your site’s database directly into an article text. Any updates to database are instantly shown in all of your articles. Typical usage scenarios include: Include prices from your online store software or price list stored in database. The price information in your content is always up-to-date Make cross-references between articles and other content types on your site. Titles are updated automatically whenever you rename the referenced content, so you never worry about cross-referencing consistancy Please leave your usage scenarios in comments.
p
VJ 3D Chart

VJ 3D Chart

Paid download | Data Reports | VJ Tools
3
Score:
0
0 reviews
VJ 3D Chart - 3D charts and graphs for Joomla! TOP FEATURES Rotate and view Rotate and view a 3D chart from different angles. Use simple text files The extension reads data from simple text files and converts them into beautiful 3D charts. Various types of charts Choose between various chart types: area, line, bar, scatter. Other Notable Features Data comes from simple text files Pure Javascript, no Flash Several customizable properties like width, height, colors, font size, etc. Module comes with example text files for each type of chart/graph This is open-source software under GPL license
m
POWr Graph

POWr Graph

Free | Data Reports | POWr
3
Score:
0
0 reviews
Create charts and graphs for any data set. Just copy paste data from Excel or any spreadsheet, and instantly generate a beautiful, responsive display. Choose from pie charts, line plots, bar graphs, and scatter plots. POWr Graph is a great way to tell a convincing story with real numbers and statistics. Show your growth, make predictions, or compare your brand to the competition. Free Features: - Pie charts, line plots, bar graphs, & scatter plots. - Interactive controls to remove/show data. - Copy and paste any data set. - Supports up to 10x10 data fields. - Customizable colors, borders, and backgrounds. - Adjustable sizing and style. Upgrade for even more options! And check out more great plugins at POWr.io!
m p
VJ SQL to File

VJ SQL to File

Paid download | Data Reports | VJ Tools
3
Score:
0
0 reviews
VJ SQL to File: Generate Excel, Word, PDF, CSV files from SQL queries . File types can be: Excel/XLS, Word/DOC, PDF, CSV. TOP FEATURES PDF, XLS, DOC, CSV files Generate PDF, Excel/XLS, Word/DOC, CSV files from SQL queries with a single click. All kinds of SQL queries Create as simple or as complex SQL queries as you want. Supports different database types The following database types are supported: fbsql, gladius, maxdb, msql, mssql, mssqlpro, mysql, mysqli, mysqlt, odbc, postgres, postgres64, postgres7, postgres8, sqlite, sqlitepro, sybase, sybase_ace. To work with some databases, an appropriate php extension may need to be installed and enabled. Save and reuse Save and reuse SQL queries for different file types. Other Notable Features Comes as a component and module When a user clicks a link to download the file, the file is generated dynamically by running appropriate SQL query You can post links to generated files anywhere: on the front-end and back-end, in articles and modules Extension can retrieve data from Joomla! database or other databases Can accept and use parameters passed to query by user Can handle large data sets and avoid memory leaks by consistently appending files Auto-size for Excel columns to fit text Easy-to-use SQL to Excel tool Easy-to-use SQL to PDF tool Easy-to-use SQL to DOC tool Easy-to-use SQL to CSV tool This is open-source software under GPL license
c m