A.A.A.R. v2.2 with interactive dashboards and free analysis

Finally the date came!

Starting from the requests and the collaboration of some of you, the brand new A.A.A.R. v2.2 has been released. I would like to explicitly thank strategicfunctions.com for the contribution. As usual it has been an interesting experience.

The main new feature is obviously the interactive dashboard on audit trail.

But also the two brand new free analysis on audit trail and repository.

Last but not least, a brand new report on documents in sites (strongly requested from the community).

I have lots of new ideas to develop but what would you like to see more in the A.A.A.R.?

A.A.A.R.

Advertisements

CMIS Input plugin v1.3 for PDI v5.2… extract your data from your ECM.

PDI CMIS Input plugin

The change log page describes some more details but the most important feature is about the used of the Apache Chemistry libraries updated at the v0.12. This version is useful to support the CMIS 1.1 for Alfresco and more.

During the next hours the new version will be available in the Pentaho marketplace… stay tuned!

Francesco Corti

A.A.A.R. bugfix: Invalid column for cmis:document cmis:objectid

AAAR_for_marketplace

While getting the parent path of the Alfresco nodes, the CMIS query could contain a bug in the ‘cmis:objectid’ field. Instead of ‘cmis:objectid’ should be used ‘cmis:objectId’ (pay attention to the camel case). A new FAQ has been added to the A.A.A.R. FAQ page.

I’m investigating the context because not all the environments requests that camel case format. Until than, if you have a message below:

Failed to execute script 'classpath*:alfresco/template/webscripts/org/alfresco/cmis/queries.post.cmisquery.js’:
Invalid column for cmis:document cmis:objectid

Please modify the query under ‘/Alfresco/Staging/Utility/Set folder’s children’ as described below:

select
cmis:objectId as cmis_objectid,
cmis:name as cmis_name
from
cmis:document
where
in_folder(”${cmis_parentid}”)
and cmis:lastModificationDate >= TIMESTAMP ”${cmis_last_update}”
and cmis:contentStreamLength >= 0′);

Many thanks to Micheal Fraser and Hu Ting Ung for the investigation and correction. Please, don’t stop contact me making suggestions, improvement and corrections to the solution.

Francesco Corti

Pentaho Sparkl tutorial

pentaho-logoAfter the (very interesting) experience in developing the A.A.A.R. v2.0 in Pentaho marketplace, I had the opportunity to dive deep in the brand new tool of the Pentaho Suite family: Sparkl Application Builder.

I’m very impressed by the power of this module and working together with the Pentaho team (in particular with Webdetails) I learnt many technical things could be interesting to share. For that reason this tutorial is born.

Sparkl Application Builder tutorial

I hope to receive lot of feedback to make it grow but until then… kudos webdetails! (like Pentaho guys always says) 🙂

How to install Pentaho Data Integration 5 (aka Kettle)

In this tutorial we are going to see how to install Pentaho Data Integration 5. PDI 5 (called Kettle) is one of the most powerful tool of the Pentaho Suite that develop a pure (and complete) ETL tool. This tutorial is an extraction of the complete wiki section dedicated to this amazing tool.

If you have a Linux based operating system or a Windows based platform, the tutorial should work in any case because, you will see, the steps are very simple and easy and not related on the platform.

Prerequisites

Before start to install the PDI 5 (aka Kettle) you have to check to have Java installed in you system. To check it, you have simply to execute the command below from a terminal.

java -version

If you don’t have it, below you can find a tutorial on how to install it. Please, remember that PDI 5 requests Java7.

Download and install PDI 5 Community Edition

After Java7 is available into your system, you have to download the PDI 5 package from the official website or the sourceforge web page. In our case we are going to install the Pentaho Data Integration 5 Community Edition.

Once the ‘pdi-ce-5.0.1-stable.zip’ file will be downloaded in the system, unzip it on the desktop or everywhere else you will like. All the PDI 5 tool is available in a folder described below:

data-integration

Probably you cannot believe me but this is enough to install PDI 5 into your system. 😉

First run

PDI 5 tool is composed by different executables and services (Spoon, Kitchen, Pan) everyone designed for a specific purpose. To create all the configuration folders and files, you have to run the Spoon tool for the first time. Spoon is a graphical user interface that allows you to design transformations and jobs that can be run with the other Kettle tools (Pan and Kitchen). To run the spoon tool, follow the instructions described here.

After the first run you are ready to use it.. for example with the A.A.A.R. solution. 😉