Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

ART / News: Recent posts

ART 2.5.2 released

ART 2.5.2 has been released. This release contains minor updates.

Highlighted changes:

  • Fix for error when drill down column has a null value
  • Updated French translation (thanks to Eric Lemesre)
  • Minor html tag corrections (thanks to Eric Lemesre)
  • Left align text in htmlDataTable and htmlPlain view modes
  • Added DataTable translations for Spanish and Portuguese
  • Allow display of 0 for numbers when value is null
  • Allow chained parameter lov to use dynamic datasource filter
  • Left align first column text in crosstab queries... read more
Posted by Timothy Anyona 2013-05-12

ART 2.5.1 released

ART 2.5.1 has been released. This release contains bug fixes, new translations and a few minor enhancements.

Highlighted changes:

  • Added Portuguese translation (thanks to Edson Richter)
  • Added Spanish translation (thanks to Carlos Narvaez)
  • Updated French translation (thanks to Eric Lemesre)
  • Allow custom path for export files (thanks to ckb)
  • Enable display of blank space instead of "null" for null fields (thanks to ckb)
  • Fix for query name truncated to 25 characters
  • Fix for start query not displaying
  • Fix for invalid drill down queries link
  • Fix for not being able to define email jobs in Italian and Portuguese locales
  • Added some 2D charts
  • Allow use of jndi datasources
  • Allow rename and move of queries from the query management console
  • Allow xy chart to have multiple series
  • Made graph x-axis label rotate and remove options configurable per query
  • Updated jasperreports to 5.0.1... read more
Posted by Timothy Anyona 2013-04-07

ART 2.5 released

ART 2.5 has been released. This release contains some minor feature updates.

Highlighted changes:

  • Fix for invalid publish job link on linux when reminder email specified
  • Support for running DDL/DML statements before query's select statement
  • Support for displaying a query in the start page
  • Fix for non-ascii values not being saved properly in some admin pages (Thanks to Edson Richter)
  • Renamed "Objects" to "Queries" and "Object Groups" to "Query Groups"
  • Support for archiving publish job results
  • Removed published files retention period setting
  • Moved some application settings from the web.xml file to the settings page... read more
Posted by Timothy Anyona 2013-01-18

ART 2.4.1 released

ART 2.4.1 has been released. This release contains several bug fixes.

Highlighted changes:

  • Support for bubble charts
  • Support for heat map charts (experimental)
  • Fix for chart tooltips not displaying when charts displayed inline
  • Fix for issue preventing creation/modification of parameters in IE
  • Fix for charts not displaying in IE8 when charts displayed inline
  • Fix for charts not displaying when y axis range is specified
  • Have admin pages use the same header and footer contents as user pages
  • Modified syntax for speedometer chart ranges
  • Allow use of percentage values in speedometer chart ranges... read more
Posted by Timothy Anyona 2012-12-02

ART 2.4 released

ART 2.4 has been released. This release contains a few useful features.

Highlighted changes:

  • Added cc and bcc fields for email jobs
  • Enable viewing of application logs from within the application
  • Enable choosing of query datasource at runtime
  • Display query results in the show parameters page
  • Enable display of final sql generated for a query
  • Enable setting of the format to be used for dates in query output
  • Sort numeric columns correctly in datatable view mode
  • Made DataTable the default view mode
  • Enable jobs to be emailed to a dynamic list of people
  • Allow rule values to be defined for user groups... read more
Posted by Timothy Anyona 2012-11-12

ART 2.3.1 released

ART 2.3.1 has been released. This release contains a few bug fixes.

Highlighted changes:
Fix NullPointerException on pdf output with null strings
Fix to enable error free charts with java 1.7
Increased axis labels remove_at value for charts
Fix to enable display of friendly parameter values for chained parameters
Modified string for chained multi parameter, all values, from ":: All items" to "All"
Fix for error on selecting all values option for chained multi parameter
* Removed check enforcing presence of parameter label in the sql source... read more

Posted by Timothy Anyona 2012-08-31

ART 2.3 released

ART 2.3 has been released. The main purpose of this release is to move ART to the Quartz 2.x code base, instead of the 1.8.x one. It also has a few minor functional enhancements.

Highlighted changes:
Allow username and password field values to be used for CUBRID database
Allow "not equals" operator for dynamic queries
Support display of unicode characters in pdf output and charts
When using show parameters option, for lov parameters, display actual parameter value and friendly display value
Allow selection of parameters for drill down queries
Updated quartz to 2.1.5
* Updated jasperreports to 4.6... read more

Posted by Timothy Anyona 2012-08-14

CUBRID bug bash

The CUBRID folks have released a new tool - CUBRID Web Manager. It's currently in beta and any testers are welcome to bug bash. http://www.cubrid.org/cwm_bug_bash

Posted by Timothy Anyona 2012-08-03

CUBRID support coming to Quartz

The work done to include have the Quartz scheduler work with the CUBRID database will be included in the next Quartz version - 2.1.6. https://jira.terracotta.org/jira/browse/QTZ-303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Yay!

Posted by Timothy Anyona 2012-08-03

ART becomes a CUBRID partner

Some time recently we got approached by the CUBRID database team encouraging us to add support for the CUBRID database to ART. Reporting off a CUBRID database was straight forward and didn't need any special code/configuration. Just add the JDBC driver to the classpath and create a datasource like with any other database.

Enabling CUBRID to be used as the ART repository did require some work. It turned out that version 2.2.1 of ART that fixed a few important bugs was about to be released and adding CUBRID support went quite well, so this feature made it into that release. With this participation in the CUBRID Affiliates Program, http://www.cubrid.org/affiliates, ART has become the 5th CUBRID partner.... read more

Posted by Timothy Anyona 2012-06-08

ART 2.2.1 released

ART 2.2.1 has been released. It mainly contains bug fixes and support for the CUBRID database (http://www.cubrid.org/).

Highlighted changes:
Added support for the CUBRID database (www.cubrid.org)
Fix for dashboard description not showing on start page
Fix for dashboards not working on chrome (thanks to yidong123)
Fix for rule value ALL_ITEMS not working properly (thanks to yidong123)
* Improved handling of numeric multi parameter values... read more

Posted by Timothy Anyona 2012-04-29

ART 2.2 released

ART 2.2 has been released. It contains a few minor enhancements and bug fixes.

Highlighted changes:
Fixed graph tooltips not showing up on Firefox 9
Allow deleting of multiple queries
Allow query security to be based on both groups and queries
Allow show parameters option for graphs
Order parameters displayed in a report according to field position when show parameters is used
Support for display of parameters in job output
* Allow query to show parameters by default... read more

Posted by Timothy Anyona 2012-03-04

ART 1.8 released!

ART is a lightweight web-based query tool and reporting environment.

There is no need to read tons of documents or edit huge xml files: end-users can start using Art with no training, while just standard SQL is needed for a developer to be productive and deliver. Installation is performed by deploying a .war file in a Java Servlet engine (i.e. Tomcat/Jetty/Oracle oc4j etc) and creating some tables in a database (embedded hsqldb is availabe). ART focuses on simplicity, do not expect a state-of-the-art look&feel, but a simple&robust tool!

Supports crosstabs, charts, scheduling, email alerts. Results can be viewed within the browser, exported to a file or delivered (via a scheduler) as email attachments - pdf, xls, xml. Queries can be grouped in a portal-like page to create a simple but effective Business Intelligence dashboards.

ART 1.8 contains various bug fixes and a few enhancements, some are listed below - THANKS to all the folks who contributed with ideas through the SourceForge forum and by testing beta versions!... read more

Posted by Enrico 2008-01-30

ART 1.8 beta1 released!

ART 1.8 beta1 has been released. It contains various small fixes and some minor enhancements - the main one is a preliminary support to deliver information to mobile device (tested with OperaMini 3.1, BlackBerry browser 4.1 and others mobile phone integrated browser - Motorola&Nokia).

enhancement: editable subject and html body on scheduled jobs email
enhancement: preliminary mobile device support (http://.../art/mobile)
enhancement: logs on ART_LOGS table
enhancement: can edit html code in html text area
enhancement: new urls for public_user that do not redirect (previous are compatible)
enhancement: code clean up/various changes in objects
enhancement: can send query result as inline html in job email
bug fix: hyperlinks in Categories and Pie charts (by desand)
bug fix: art date line chart now works (by desand)
bug fix: upgrade to jfreechart 1.0.5 to solve thread issues
bug fix: in reportize output, number of line reported was always 0
bug fix: fonts size error on reportize output
bug fix: (in IE only) when executing graphs, IE spinning icon stops
bug fix: text objects are now non editable as textarea by admin
change: direct access to /user/QueryExecute by appending _public_user
to be able to direct access pages producing files
change: default view mode is now html grid

Posted by Enrico 2007-08-05

Summary: ART 1.7 released!

ART is a lightweight web based reporting environment created to share database content with a minumum effort and short learning curve.

Administrators defines SQL queries and parameters while authorized users can quickly get the result via a web browser.

It supports crosstabs, charts, scheduling, email alerts. Results can be viewed within the browser, exported to a file or delivered (via a scheduler) as email attachments - pdf, xls, xml.
Queries can be grouped in a portal-like page to create a simple but effective Business Intelligence solution.

Release 1.7 focuses on:
- Portlets Containers usability improvement (parameters, user feedback during load etc)
- PDF output for tabular results and graphs
- Chained parameters
- Additional graphs types (stacked bar, dynamic multiple series)
- UTF-8 support... read more

Posted by Enrico 2006-09-16

ART 1.6 Released!

ART is a lightweight web based query tool and reporting environment.
SQL queries can be created in a few minutes by an administrator. Users can execute queries via a web browser - supports tabular&crosstab layout, graphs, export to spreadsheet, scheduling with email delivery etc.

Release 1.6 contains some major new features:
Portlets Containers
Queries/Graphs can act as portlets and be grouped in a single portal-like page
Text objects
Text fragments can be edited in a WYSIWYG html editor and shown in a standalone web page or in a portlet.
* External Authentication support (LDAP, Win Domain, DB)... read more

Posted by Enrico 2006-02-27

ART 1.5 released!

ART is a simple, lightweight web based query tool and reporting environment. Using ART, SQL queries can be created and published in a few minutes by an administrator. Users can execute/schedule queries via a web browser (supports tabular&crosstab layout, graphs - data is exportable to spreadsheet).

ART uses other open source projects to deliver key features like charts (cewolf), Excel output (poi) etc.

Release 1.5 contains fixes for small bugs (detected by the Open Source community thanks to the Sourceforge forum) and various new features:

  • Support for Dynamic SQL
  • Inline Parameters
  • i18n (only english available now, but ready to host more languages)
  • Fix to work on Resin AS
  • Fix on crosstab cast exception
  • Fix memory leak on class loading... read more
Posted by Enrico 2005-03-13

ART 1.4 released!

ART is a lightweight, multiplatform web based query tool and reporting environment. Using ART, SQL queries can be created and published in a few minutes. End-Users access the tool via a web browser and can execute queries (tabular, crosstab, charts) - data is exportable to spreadsheet.

To install&use, you need a database where to create some tables (ART repository) and a working J2EE application server (like Tomcat) where to deploy the war archive.

Release 1.4 contains fixes for small bugs (detected and solved by the open source community thanks to the Sourceforge forum) and some new features (see News on project home page):... read more

Posted by Enrico 2005-01-23

ART 1.3 released!

ART is a lightweight, multiplatform, highly scalable web based query tool and reporting environment.

Using ART, SQL queries can be created and published in a few minutes. Live or scheduled results are available via browser (tabular, crosstab, charts), data is exportable to spreadsheet.

To install it, you need a database where to create some tables (ART repository) and a working J2EE application server (for example Tomcat) where to deploy the war archive.

Release 1.3 contains some fixes to work using OC4J, various improvements and small bug fixes.

For more information visit: http://art.sf.net

Posted by Enrico 2004-12-12

ART 1.2 released!

ART is a lightweight, multiplatform, highly scalable web based query tool and reporting environment.

Almost anywhare are databases and people who execute queries against them to retrieve data. Data is then manipulated to create information.
Using ART, SQL queries can be stored in a robust repository and published in a few minutes. Live or scheduled results are available via browser (tabular, crosstab, charts), data is exportable to spreadsheet.... read more

Posted by Enrico 2004-11-01