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
39 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
vChart

vChart

Paid download | Data Reports | WDMtech
3
Score:
100
17 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
Comparison Chart

Comparison Chart

Paid download | Ratings & Reviews | JoomPlace
3
Score:
98
4 reviews
This Joomla! Comparison Chart makes it easy to build comparison charts both for e-Commerce and e-Learning. The comparison component allows adding description of products’ features in the form of comparison charts which help arrange simple and convenient purchasing process. We recommend using the chart component to help users easily comprehend difference between any object, item or product without having to analyze long descriptions. This Joomla! comparison extension makes the process of the chart building very easy! It will encourage you to focus on content rather than adjustingchart columns and rows. No designer skills needed to put together pieces of information in the form of visually appealing charts with this fully fledged chart component and 3 default chart templates. What you might want to do with Comparison Chart component: *Adjust font size, color and type as well as color of columns and rows of the chart *Make use of the hiding effect to collapse/expand chart columns and rows *Submit information retrieved from a CSV-file *Add optional chart component description below and above charts *Choose between any of the 3 default templates for the chart or create custom ones. *Insert pictures, links, or other information right into the comparison chart tables with the help of HTML tags *Let users contribute to your charts. They might want to select items to compare and create a new chart *Highlight best/worst chart component items related to selected parameters For more information about the Comparison Chart component features, please check the chart extension description page http://www.joomplace.com/comparison-chart/comparison-chart-description.html.
c m p
vData

vData

Paid download | Data Import & Export | WDMtech
3
Score:
97
43 reviews
vData allows you to import / export Joomla users, Menus, Modules, Categories, Articles, Tags etc and all available third party extensions you can think of e.g. Virtuemart, K2, JoomShopping, HikaShop, EShop, iJoomla Ad Agency, DJ Classified, PayPlans, MossetsTree, Easy Discuss, JomSocial, EasySocial, EasyBlog, SobiPro, ZOO, Kunena, JEvents, Event Booking, OS Property etc. vData is Powerful, Secure, Intuitive and Easy-to-use Data Management Tool that will save your time, ensure accuracy and reduce your costs of Data Migration by up to 95%. You can use it to import / export / migrate data from your old website to the New one. Compatible with Joomla! 2.5.x & 3.x vData is a crucial tool for importing / exporting a database with external source data and migrating data between Web Portals. It also offers you the ability to generate Widgets to give insight about the database and to let you monitor and analyze database and server performance. It provides you a very simple and flexible way to add / update / synchronize data to your Website in CSV, XML, JSON and directly from Database. You can get predefined profiles of Joomla Users, Menus, Modules, Categories, Articles etc and most of 3rd Party Joomla Extensions mentioned above to perform Import/Export Operation with just one click through our automated Profile Wizard. It provides a number of reports and charts to help you track progress and obtain insights about your agile practices and you can also monitor your database and server resources as well. You can set Email notification triggers on various events so that you can keep yourself up to date about important things on your Website. vData provides you the ability to set up Data Display Profiles which displays Your Data or Items List from the Local / Remote Database, You can also get this data from API Feeds. It's also capable enough to generate / import API Feeds in various data format like RSS2, RSS1, ATOM, XML, JSON and CSV. vData has comprehensive listing of unique features and benefits that stands it at top of all the other competitive tools. vData - Features & Benefits Connect with Any Data Source to Import / Export / Migrate your Website data vData takes data for Data Import / Export / Migration Process from different data sources – CSV, JSON, XML and Databases (Local or Remote Databases). You can also import multiple CSV files simultaneously. vData allows you to upload data source file straight from your computer or enter path to the file available on local / remote server to import in Database. Ability to automatically map your data fields with your importing Database table columns. You can also define whether to create new file or append the exported data to an existing file on the server to save exported data. vData allows you to only add / update data into the required columns, you can simply choose to skip remaining columns. You can use vData to add as well as update the records in your Database vData can also be used to keep the Data synchronized between two Database tables. Allows you apply filters to fetch the precise Data. Ability to join Database tables to extract the desired Data from multiple tables. You can also use vData to import / export data on your other Websites based on any CMS / Framework. Ability to automatically Import / Export your Data with the help of Cron Jobs / Schedule tasks on your server. Ability to directly send the exported file as an attachment to multiple email addresses. Ability to complete the process in small chunks in case of Bulk Data Migration. Allows you to define whatever separator you want to use in CSV file, such as pipes, tabs, space and semicolons; you are not constrained to using commas only. Feeds and Logs Allows you to create API Feeds of any Data available on your Website. It provides you the ability to execute the complex functions and queries to retrieve your desired data and generate API Feeds for your website. Allows you to generate / import feed in various data format like RSS2, RSS1, ATOM, XML, JSON and CSV. Ability to directly view the generated API for Feeds in the browser by clicking on generated API Link. Allows you to search, sort and apply filters on Feeds and Logs Records. vData allows you to view and manage the logs generated by the tool during the Data Migration process. You can get detailed information of all activities performed by the tool during the data migration (import / export / migrate ) process. Manage Database in a Quick and Efficient Manner Supports Multiple Database types: MySQL, MySQLi, PostgreSQL, SQLite, Oracle etc. Allows you to Add New Records, Edit and Delete the Records from a particular Table. Using vData Quick Mode View, you can also directly Create New Table, Repair Table and Optimize Table. Ability to direcly execute SQL command to display the table records or select a table from the available dropdown list. vData allows you to Export Table Structure and Data to SQL, CSV, JSON, PHP array, XML OR YAML file. Additional Features The Most Flexible Dashboard Ever Designed. Ability to divide dashboard in any no of rows and columns allowing you to create widgets with flexible width and height. It use a variety of graphs, charts and pivot tables to create interactive, interesting and insightful dashboard. Includes Line Chart, Area Chart, Stepped Area Chart, Column Chart, Geo Chart, Table Chart, Bar Chart and Pie Chart etc. It provides Drag-and-drop interface which makes it easy for you to quickly reach the crucial information and analyze the reports. It comes with few pre-built monitoring and visual analysis widgets that provide immediate productivity. It allows you to add more widgets based on users’ interactions and behaviors on your site that meets even the most custom requirements. It allows you to set up Notification alerts on meeting certain criteria. Notification Emails are sent to Admins or any particular person whom the record belongs to. Notification Email alerts can be reminding you of unpaid Invoices due today, Weekly Activity statistics or anything you can think of. vData provides you the ability to set up Custom Display Profiles which displays Data Records or Items List from the Local Database as well as Remote Database. Allows you to control user access to different sections/features of vData in both frontend and backend with Joomla ACL system. vData offers Admins / Frontend Users to create numerous Widgets or Graphs out of your desired content. These widgets then can be embedded on your website anywhere with a module. You can also set up Notifications to receive Data Migration Activity report on a daily / monthly / weekly basis or instantly when the data import / export / migration is processed. Where it can be used? If you are upgrading your Joomla website and want to migrate all the Data. If you are migrating some data from one Website to another. To automatically fetch data from an external CSV, JSON, XML Feed. To synchronize your data residing in two Database tables or in two separate Databases. To take a regular backup of some Important data on your Website. To automate regular data Import / Export / migration Process on your Website. To display the filtered data from database as per your very specific needs which you can not get to display with existing components. To keep the users or subscriptions or transactions or other two Database tables synchronized. To fetch data available on local server or coming from any external source ( e.g. Joomla, Wordpress, Magento, Core PHP etc) To fetch and display precise data from database by selecting a predefined Profile or by writing your own custom query. To generate / import API Feed of your Website Data in CSV, JSON, XML format. To keep an eye on the activities being performed on your Website. To quickly analyze visits, sales, subscriptions etc on your Website. To Import / Export Data in any core / third party extension e.g. - Import Articles, Export articles - Import Users, Export Users - Import Menus, Export Menus - Import Categories, Export Categories - Import Tags, Export Tags - Import K2 Items, Export K2 Items - Import Virtuemart Products, Export Virtuemart Products - Import JomSocial Users, Export JomSocial Users - Import EasySocial Data, Export EasySocial Data - Import EasyBlog Data, Export EasyBlog Data Or Any other extension you can think of, vData allows you to easily import / export data of any available Joomla extension. Still not sure if vData fits your requirements? Our live chat service would gladly answer any question!
c m p
Art Table

Art Table

Paid download | Data Reports | Artetics
3
Score:
97
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
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:
83
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
JSON Export

JSON Export

Paid download | Data Import & Export | joocode
3
Score:
82
3 reviews
Export any table to JSON: transform your Joomla Database into a JSON API Export any table to JSON: transform your Joomla Database into a JSON API! Pick one or more tables you want to expose, and enable them in the admin interface That's it! Then just call index.php?option=comjsonexport&table=yourtable Export any custom SQL query How? Create a MySQL View and execute any SQL query you want The result will be exportable like a normal table. Major advantages provided choose which tables you want optionally add a password to protect your data select all fields (*), or just a few set LIMIT and OFFSET parameters to the query URL to paginate the results The results are sent using JSON to the requester. Examples of what can it be used for Integration with other sites Create an API Integrations with ecommerce tools: extract your orders! Create email lists Backup and export data Sync with other software or websites Basically any custom integration you might think of.
c
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
CSV Export

CSV Export

Paid download | Data Import & Export | joocode
3
Score:
73
1 review
Get your data in CSV format Export any table to CSV: transform your Joomla Database into a Excel file or Google Spreadsheet! How? Pick one or more tables you want to expose, and enable them in the admin interface That's it! Then just call index.php?option=comcsvexport&table=yourtable Export any custom SQL query How? Create a MySQL View and execute any SQL query you want The result will be exportable like a normal table. Major advantages provided choose which tables you want optionally add a password to protect your data select all fields (*), or just a few set LIMIT and OFFSET parameters to the query URL to paginate the results The results are sent using JSON to the requester. Examples of what can it be used for Integration with other sites Integrations with ecommerce tools: extract your orders! Create email lists Backup and export data Sync with other software or websites Basically any custom integration you might think of.
c
Stetic

Stetic

Free | Analytics | Stetic
3
Score:
73
1 review
This plugin allows you to integrate the Stetic Tracking code into your Joomla! webpage. All you have to do is enable the plugin and enter your Stetic project token. With Stetic you can analyze your web page traffic in real time. To use this plugin, you have to be registered with Stetic: https://www.stetic.com
p
DW Anything

DW Anything

Free | Modules Styling | Factory.DocWriter.Ru
3
Score:
72
1 review
DW Anything is a versatile tool to build custom Jooma! modules to display any information stored in Joomla! database without programming. Enter SQL query to get results from database and output template to display query results in your very own custom layout. DW Direct Support feature helps you to get technicall assistance for DW Anyting module. Warning! SQL and HTML knowledge is required to use this module. Use at your own risk! New in version 3.04 Fixed Isue with {loadposition} plugin Fixed compatibility issues
m