29 Dec

Learning Alfresco Web Scripts

Learning Alfresco WebscriptsIn this post I would like to submit to you the brand new book from Packt Publishing called Learning Alfresco Web Scripts by Ramesh Chauhan. The book is easy to read with its 182 pages, full of practical examples and portion of source code.

Alfresco web scripts are fundamentals to develop a real enterprise solution for the Customers. For this reason, having a complete (and updated) guide on how to understand and properly develop them, is the core of the success of a project.

Read More

08 Dec

CMIS queries on Alfresco CE 5.0.c

CMIS

CMIS is the most important standard for ECM interoperability. Alfresco is compliance with CMIS 1.1 with Apache Chemistry and CMIS queries are one of the most powerful way to use this ECM. In this post is shared some tests on CMIS queries on the brand new Alfresco Community Edition v5.0.c.

Description of the test environment

I have already shared the test environment I prefer to test Alfresco and CMIS. This is composed by:

  • An Alfresco v5.0.c installation. In this case I use a vanilla installation with uploaded 10K documents.
  • A Pentaho Data Integration (Kettle) v5.2 installation.
  • CMIS Input plugin for PDI to develop queries on Alfresco.

To understand how the CMIS Input plugin works, take a look at the demonstration page here.

Read More

01 Dec

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.

Read More

24 Nov

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.

11 Nov

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.

Read More

10 Nov

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!

13 Oct

How to install Alfresco 5.0.a Community Edition on Ubuntu 14.04 LTS

alfresco logoAfter the development of my most viewed post sharing how to install Alfresco 4.2.c on Ubuntu 10.04 LTS (more than 35.000 views) and Windows Server 2008 R2 (more that 13.000 views), it’s time to update the tutorial to the newest major version of Alfresco: Alfresco Community Edition 5.0.a. Even if the 5-th version is quite different from the 4-th version, the installation process is more or less the same… but let’s describe exactly the differences. The operating system choosen for the tutorial is Ubuntu 14.04.01 LTS.

Differently from the other post, the tutorial is separated in two parts: the installation of the dependencies and the Alfresco installation. As we like and prefer, the installation is a step by step list of commands and tasks: simpler to understand, to do and to test. Hope you’ll be agree.

Read More

23 Sep

A.A.A.R. not showing buttons (SOLVED)

After the installation, if your AAAR is not showing Configure/Install/Use buttons, please update Pentaho with the latest “Community Graphics Generator” and “Community Dashboards Framework”. The solution is described here.

aaar_not_showing_buttons

AAAR_for_marketplaceI have received few contacts on that problem so I think would be useful to share the solution one time for all. Thank you to jservajean and kossel for sharing the experience.

18 Sep

The order of the Bee. Something is happening in the Alfresco community.

Order of the BeeSomething interesting is happening in the Alfresco’s community.

I’m not talking about the Alfresco Community (Edition) of the software but the Alfresco’s community composed by people and skilled professionals.

Few weeks ago a brand new organization has been created and is called Order of the Bee. Why that name? Everything was born in the past Alfresco Summit with a Community Keynote by Jeff Potts (here the complete speech).

In my opinion, and not only in my opinion, this is a good news for the (pure) open source developers and professionals. I personally decided to join the organization together with the AAAR solution but I feel like something more interesting will happen in the nearest future. 🙂

Below I would like to submit to your attention some key concepts to better understand this organization.

23 Jul

Solr doesn’t return more than 1,000 objects in Alfresco.

lucene_apacheOnce upon a time Alfresco used Apache Lucene as search engine….

This was great until you had particular needs like, for example, a long duration query or a query that retrieves a huge amount of objects. It was more than a year ago when I wrote a post talking how Alfresco retrieves 1,000 results maximum or query for a couple of minutes.

solrAs you can read in the post, the most suggested solution to the problem was to migrate the indexing engine to Apache Solr. At that time, Alfresco supported both the engines and considered Solr as its future.

Today Lucene and Solr are always supported and Solr is probably the most used, but regarding the same issue, probably something is coming back again.

>> https://issues.alfresco.com/jira/browse/ALF-20567(*) <<

As you can read from the JIRA issue, in Alfresco 4.2.e SOLR also returns a maximum of 1,000 results and to solve the issue is suggested to set the parameters below in the alfresco-global.properties file.

solr.query.maximumResultsFromUnlimitedQuery=10000
system.acl.maxPermissionChecks=10000

This could have a high impact on “big” queries or “long” queries so I would like to share this information with all of you to prevent problems or nights spent on the debugger. 😉

I hope this will help you.

Francesco Corti

(*) Thanks to Francesco Fornasari and Christian Tiralosi for the hint.