Posts Tagged 'JasperReports'

Reporting at the Alfresco Summit 2013

Alfresco Summit 2013

A week ago, at the Barcelona edition of the Alfresco Summit, there was a “Alfresco Reporting” session. Francesco Corti, Matthew Patin an myself presented their solution. We had a great audience with among others John Newton, Jeff Potts and John Iball. Alfresco is considering how to implement any kind of reporting themselves, so it became an interesting discussion. Continue reading ‘Reporting at the Alfresco Summit 2013’

Alfresco Business Reporting released

alfresco business reporting logoA while ago I wanted insight in how our Alfresco Share repository was used. ‘Ad-hoc reporting’ and ‘(always changing) management reporting’ is not Alfresco’s strongest feature. There is a need for reporting in a way a business user understands, using their tools of choice. The Alfresco Business Reporting project delivers the missing link. It extracts Alfresco business objects (like documents, folders, datalists, links, discussions) into plain SQL tables. The total set of properties for each object, including your custom aspects, show up as columns in your table. And you, the business, can use your reporting tool of choice, to generate fancy reports. No need for IT consultants to configure Alfresco for every change or additional report. Once the synchronization is configured, you can define as much reports as you like, answering your (or your management’s) questions immediately. Continue reading ‘Alfresco Business Reporting released’

(How) Is your Alfresco repository being used?

In a recent post I just discovered this “Alfresco generate reports with JasperReports” project. It seemed to fit my needs for reporting against Alfresco and Share, and I was very happy and exited. However… It appeared to be too complex to use.

I try to be as little indispensible as possible. If someone from ‘the business’ is in need of reporting, I try to give access to a tool that suits his/her needs. If they need to create or modify a report, they should not be dependent of me, or anyone else capable of doing Alfresco Magic. Being build op Open Standards and proven technologies does not mean everybody is capable of doing everything with it

My view on reporting is:

  1. ‘The business’ should be able to create/maintain reports.
  2. The reporting environment should support Aspects. If one adds a type with some additional properties, the reporting environment should be able to deal with it, without manual reconfiguring.

Continue reading ‘(How) Is your Alfresco repository being used?’

Know the usage of your Alfresco repository

it happens now and then an organization puts a DMS in place, and starts working. Usually they don’t have a clear view on how their system is used. I work for just such an organization; lets start working and formalize afterwards. Therefore I got this idea to create a reporting add-on. The main idea is to use an existing easy-to-use reporting tool to configure the reports, based on Alfresco data. the resulting reports should be stored in Alfresco. There is of course the Birt extension in the Alfresco Forge, but lets face it, I cannot give Eclipse to the report-maintaining guys.

Yesterday night I found this “Alfresco generate reports with JasperReports” project on Google Code (with a pointer in the Alfresco Forge). This does exactly what I initially had in mind. One can create XML feeds in Alfresco. Use the XML feed, combined with  a JasperReports report definition, and store the output in Alfresco again. And all this using Alfresco server-side scripting, which means you can easily schedule the reports to be generated at night, and that you can include logic like sequentially execute all reports existing in a given Space. (Think of adding a report-definition aspect to the JasperReport definition  object in Alfresco containing the name/link to the xml data feed…) All I have to do is come up with a clever set of XML feeds to source the reports! I am working on this idea to frequently update my XML feed (stored as a document in Alfresco). Continue reading ‘Know the usage of your Alfresco repository’