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

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

Review of the Alfresco CMIS book by Martin Bergljung

Alfresco CMISAs you probably know (or you read it now for the first time) CMIS is an open standard that allows different ECMs to inter-operate over the Internet through the definition of a collection of services and a powerful query language (CMIS-QL), modeled along a subset of SQL.

The goal of this book is to share and explain all the basics of the CMIS, using a practical and technical approach that starts from the history (why the CMIS was born), going through the definition of the (several) services and the query language, and ending with a collection of examples describing how to use CMIS in practice.

CMISOk, CMIS is thought to make different ECMs interoperate, but the amount of different languages and examples described in this book is interesting and well done. Starting from Java (with Apache Chemistry libraries), Javascript + JQuery, Groovy and (bascis of) PHP. Yes, I’m agree with you if you are thinking that the CMIS libraries are more and more than this but the description (and explanation) of the CMIS services (and examples) is all you need to understand how to approach the development using all the different languages supported (.NET, Python, ecc.).

As you can read from the title, Martin Bergljung focuses his description on Alfresco. And this is true because all the examples are developed using an Alfresco repository as referred architecture. But inside the book you can find something more about Alfresco. Personally I have found very interesting the description of the Alfresco Surf together with CMIS standard. Probably this topic is less useful for the most part of the readers (and practical cases) but is an interesting example related to the basics of the Alfresco Share application. Quite interesting also the example on how to make Alfresco and Drupal interact, using CMIS.

packt-publishingLast but not least, I read the book very easily in the first part (the more descriptive) and in the last (full of practical examples in the different languages). I think I will use the book also as manual of the several CMIS services when I will develop something because I suggest you to remember that…

Standard is good!

😉

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

PDI CMIS Input plugin is now compliant to Java6 and Java7

PDI CMIS Input plugin

CMIS Input plugin for Pentaho Data Integration is now compliant to Java6 and Java7. The v1.1 release, downloadable from the Pentaho Marketplace, is ready to be used with Pentaho Data Integration v4.3, v4.4 and v5.0.

Many thanks to Adrián Cadena (fugu.ec) for the contribution with the compilation of the sources and testing with Alfresco Enterprise and Community Edition.

Download CMIS Input plugin