topic Re: Problem when Importing ACP file in Alfresco Archive

Problem when Importing ACP file

ediez — Wed, 29 Apr 2009 16:24:49 GMT

Hi,I've exported a space of aprox 7GB from my repository. I did that using the Export functionality provided by Alfresco (version 3.0) and obtained an Alfresco Content Package file (acp).When trying to import it on a different instance of Alfresco (same version -3.0-), I get the error shown below:IN

Re: Problem when Importing ACP file

mdutoo — Tue, 26 May 2009 17:53:11 GMT

Hi ediez

ACP files are techically limited in size (I've heard about 1gb). Reasons include that they can become big very fast since they contain document contents, and they are imported in a single transaction.

(shameless plug) The ETL Connector extension for Alfresco overcomes these limitations, besides having many other uses when coupled to a compatible ETL like Talend 3.1 .

Re: Problem when Importing ACP file

ediez — Wed, 27 May 2009 12:32:51 GMT

Hey mdutoo,

Thanks for your reply. I managed to correctly import all my files. ACP doesn't come like a good idea for huge files (+1GB).

Thanks again.

Re: Problem when Importing ACP file

mdutoo — Wed, 27 May 2009 15:12:07 GMT

You're welcome, anyway well done.

Note that other common import practices include scripted automated actions, or webscripts - though all this implies some coding.

Re: Problem when Importing ACP file

groutal — Mon, 15 Jun 2009 14:11:31 GMT

The ETL connector does overcome those limitations. You also get to use Talend Open Studio with the connector, which is an open source ETL tool for data integration experts with a user-friendly GUI. It is easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component which allows the user to get a graphical and functional view of integration processes. For more information: http://www.talend.com/

Re: Problem when Importing ACP file

groutal — Wed, 15 Jul 2009 14:56:24 GMT

Have any you used Talend for ongoing data synchronization between a legacy system and Alfresco? I essentially need to do daily extracts from one db and copy a subset of the data into the WCM and am trying to determine if Talend will do that easily or if I need to build something custom.

Hi Bajuk,

Actually Talend is the correct solution for your needs. It can perform data synchronization. The software has connectors with Alfresco making it possible to work with both. Making a daily extract is easily achievable with Talend once the "job" has been created: you "run the job" and the extraction begins.

And even if you need something customized, you can modify the software: it is open source.

Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes.

For more information: http://www.talend.com/