Discover the documents stored into your Alfresco sites… interactively!

Thank to the requests of some A.A.A.R. users, a brand new report showing the documents stored in every Alfresco site, has been developed. The report is interactive in the way you see below.

Report12_menu

Below a preview of the report for a test case.

Report12

The report will be part of the incoming AAAR v2.2 but if you want to use it or customize it, you can download from github in the PostgreSql version or the MySql version.

Enjoy your analytics.

Francesco Corti

Advertisements

Alfresco 5.0.b CE – Something to fix with Solr4 using CMIS 1.1

bugThanking some of you, during the use of A.A.A.R. some problems appeared using Alfresco 5.0.b Community Edition. Below is described a simple use case using the recent release of the CMIS Input plugin for Pentaho Data Integration v5.2. Waiting for the solution and bugfix, thank you again for the submissions and contributions.

Starting from a vanilla installation of Ubuntu 14.04 LTS with Pentaho Data Integration v5.2 on board, the most recent release of the CMIS Input plugin v1.3 has been installed.

After this easy step, a simple transformation is developed to enquiry Alfresco 5.0.b Community Edition installed from scratch with Solr4. Below the screenshot representing the CMIS query and connection.

CMIS query

Executing the query, this is message we receive.

CMIS query error

And this is the catalina.out log.

Error log

Removing the ‘order by’ from the query, or the ‘or’ operator, the query runs correctly.  Unfortunately, trying to install Alfresco 5.0.b Community Edition with Solr1, the first startup fails and we are locked. Let’s wait for some good news from the next release.

Francesco Corti

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