CSV Export

CSV Export

Paid download | Data Import & Export | joocode
3
Score:
74
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
Art Data

Art Data

Paid download | Data Reports | Artetics
3
Score:
67
57 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
SQL Reports

SQL Reports

Paid download | Data Reports | Jockham
3
Score:
44
4 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
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
Super Monitoring

Super Monitoring

Free | Analytics | SITEIMPULSE
3
Score:
0
0 reviews
Monitor your website uptime with www.supermonitoring.com services - and have the reports displayed in your Joomla panel. The extension integrates Super Monitoring responsive interface into Joomla admin panel, enabling you to view reports and configure services without the need to leave your CMS and log in manually to the external application. Super Monitoring service main features: - tests every minute (1440 checks per day!) - worldwide monitoring network (servers on 4 continents) - detecting & reporting various outage types - content checking (keyword search) - form testing (filling in and submitting) - performance monitoring (measuring server response times) - page loading time measuring - scenario-based transaction monitoring - file integrity checking (checksum validation) - instant alerts (email & SMS) - downtime history (PDF reports, data export). Available in English, Spanish, German and Polish.
c

Advance Report For Virtuemart

Paid download | Admin Reports | WebKul
3
Score:
0
0 reviews
** Advance Report :** VirtueMart Advance Report generate report on the basis of category, orders, status direct. Virtuemart Advance Report for Virtuemart is the newest of our extremely popular Virtuemart Advance Report component. Create detailed reports for many aspects of your store. Component have countless features, accurate results and very easily configurable makes it the best component for virtuemart report. Features : - Additional reports, fields and filters - Geo map for highest number of selling - View product attributes as distinct columns in the report according to the selected parameters - Select time spans such as "Last Month", "This Weeks" and "Per Day" to avoid manually selecting dates every time you run the report. - The powerful and popular VirtueMart Simple Orders Report - Category report - slice your orders by product category and top selling products - Very easy to configure and use . - No flash only javascript used . - View product attributes as distinct columns in the report . - Save your frequently used report settings for one-click access! You can save multiple settings per report . - Almost all the features are admin configurable .
p
EU Sales Reports for VirtueMart

EU Sales Reports for VirtueMart

Free | VirtueMart extensions | Open Tools
3
Score:
0
0 reviews
EU-based businesses selling to other businesses providing a valid EU VAT ID do not have to charge VAT for these sales ("reverse charge"). However, merchants regularly have to report those untaxed sales by submitting a list of VAT IDs and the total order amount for each VAT ID in the so-called EU Sales report or EU Recapitulative Statement. This component helps extracting and exporting this list. After installation, it is available in the VirtueMart Backend under the menu "Orders & Shoppers" => "EU Sales Report". All sales in the selected period (month/quarter/year) to a customer who submitted a EU VAT ID are listed, together with the order totals and links to the customer and the orders. Some tax authorities have dedicated file formats for submitting those EU Sales reports electronically. Currently available export formats in the extension are the Austrian XML, the German CSV and a generic CSV format containing all information. By default, only untaxed orders are shown and exported, because the report regards only orders with reverse charge. You can, however, also include orders with a given VAT ID, where tax was charged (probably by mistake) to identify possible misconfigurations. Additionally, orders where the VAT ID does not match the billing country are marked, too. It is your responsibility to cross-check the generated file for correctness. We are not tax advisors and cannot take any responsibility for wrong submissions.
p e
Aimy Charts PRO

Aimy Charts PRO

Paid download | Education & Culture | Aimy Extensions
3 4 Alpha
Score:
0
0 reviews
Create beautiful charts to visualize your data using pie, doughnut, bar and line charts. Set colors individually to fit your website's layout. Each chart can define its colors separately. You can give the charts a custom style with CSS. An initial animation can be turned on in the plugin's configuration. Aimy Charts is easy to use and customize. The plugin comes along with a detailed documentation with "copy and paste" examples for a comfortable start. All charts are realized with plain HTML5 and JavaScript using Chart.js. This extension is compatible with Aimy Charts Data Importer, which allows you to import your CSV files and turn them to charts with just a few clicks. The PRO version additionally supports: setting options per chart individual sizes per chart responsive/mobile friendly layout additional chart type for uncontinuous lines
p
Enhanced SQL Portal Bridge

Enhanced SQL Portal Bridge

Free | Database Management | David Flammer
3
Score:
0
0 reviews
This plugin serves as a bridge between Joomla! and an Enhanced SQL Portal for MySQL database management. It simply allows for single-signon capability: when logged in as a Joomla! admin, a user clicks on a link, and can access and manipulate the database using the Enhanced SQL Portal without needing a database password.
c
DW Anything Pro

DW Anything Pro

Paid download | Modules Styling | Factory.DocWriter.Ru
3
Score:
0
0 reviews
Backlink-free version of DW Anything—a versatile tool to build custom Jooma! modules to display any information from 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
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
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
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 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
Search Database Tables

Search Database Tables

Paid download | Site Search |
3
Score:
0
0 reviews
Search Database Tables is a plugin to search any columns and tables in Joomla! database Features: - Choose any tables to search in - Indicate one or many columns to search in - Plugin easily integrates in Joomla! search system to return results - Configurable URLs to use for search results - Open source
p
DW Anything Studio Pro

DW Anything Studio Pro

Paid download | Content Construction | Factory.DocWriter.Ru
3
Score:
0
0 reviews
Use DW Anything Studio Pro to build custom database-driven applications for you site without any PHP programming. Create custom page layouts, build data reports, and create pages to display data of any kind. Enter SQL queries to get results from database and define an output Smarty template to display your data. Use Cases Design custom applications from scratch without PHP programming Create custom layout for any component installed on your site Build sophisticated data reports retrieving data from multiple tables Create services to process HTTP request parameters and return structured text responses (XML, JSON, CSV, etc.) in a matter of minutes. Example usage: Update server on DW Anything Studio download site is powered by DW Anything Studio component Features One-click installation process Full power and simplicity of the Smarty templating engine makes the process of creating layouts fast and flexible Unilmited nested queries to fetch data from database to prepare comprehensive and well-structured data Detailed documentation including online help and printable manual makes DW Anything Studio easy to master Update server notifies when new versions are available for download to stay up to date Warning! SQL and HTML knowledge is required to use this component.
c
User Registrations Daily Report

User Registrations Daily Report

Paid download | Access & Security | SUDesign
3
Score:
0
0 reviews
Receive a daily summary of your new members and a statistical chart showing the evolution of the registration name in the last few days. Settings: Email(s) to be notified: one or more email addresses receive the report Frequency of emails: once per day, per week or per month Mail time: Select the time you receive the report Receive the report even if there are no new users: yes / no During the installation this plugin actives itself and is set by default, a real plug & play. Created : March 2017 Update : March 2017 Joomla : 1.7.x - 3.x Auto active : yes
p
Alphascramble

Alphascramble

Free | Security Tools | BeforeSunrise
3
Score:
0
0 reviews
ALPHASCRAMBLE 2.0 - nothing remains undetected With ALPHASCRAMBLE, you can create a snapshot (current state) of your website. Every change to this structure triggers an alarm. Additionally, potential malicious files are placed in quarantine and new registries are deleted. Problem: Once your website is online, you will not immediately notice when a hacker attack has taken place. Especially if you are using a shop system or CMS with a highly branched folder structure. The hacker infiltrates and transfers files, sends spam, and enters people’s accounts through TANs from phishing sites that run on your website. As a consequence, the provider or public prosecutor’s office ends up closing your website. This is one scenario. Another is that parts of or even your entire website displays content that differs from what you intend to show. And it would be unfortunate if your visitors are the ones to inform you of this. If this state has prevailed for a longer period of time, this could be problematic: a) because of search engines and b) because of automatic backups, which may no longer be able to restore the original state. Particularly suitable for Wordpress, Joomla, Typo3, Drupal, phpBB, osCommerce, Moodle, XOOPS, MediaWiki, and other open source solutions. Only few providers carry out regular security updates, which can have devastating effects. Solution: ALPHASCRAMBLE is integrated into your internet presence. It immediately "remembers" all of your data – through structure, name, size, owner, date… If any attribute changes or if new files and/or folders are added or something is deleted, you will receive an email straight away to inform you of this. Additionally, potential malicious files are directly placed in quarantine and newly discovered registries are deleted recursively. This means that you can act immediately. Restore backups, close gaps… Simpler than an antivirus software: The software consists of two parts. A small administration in which you will see a list of all data and can exclude data from the control*, for example to turn off the alarm triggered by a "visitor counter". The other part is the control script, which scans your website when activated. To automate this, simply have a cronjob execute the script.
c