View source for Plugin: Alfresco AttachmentProvider

* '''Maintainer:''' [[User:a42niem|Dirk Niemeyer]], action42 GmbH, Germany
* '''Origin:''' [http://www.adempiere.com/index.php?title=User:Kittiu kittiu] from ecosoft, Thailand developed the basic functionality for ADempiere
* '''Current Version:''' 3.1
* '''Status:''' Beta
* '''License:''' [http://www.gnu.org/licenses/gpl-2.0.html GPLv2]
* '''Source:''' [https://bitbucket.org/a42niem/idempiereattachmentalfresco BitBucket repository]
* '''Download binary:''' [https://bitbucket.org/a42niem/idempiereattachmentalfresco/downloads bitbucket]
* '''Sponsor:''' [http://www.integratio.com Integratio, Switzerland]

__FORCETOC__
== Description ==
*Provides capability to use [https://www.alfresco.com/community Alfresco&reg;] as Attachment [[NF1.0_Storage_Providers|StorageProvider]]
*Builds on [http://www.adempiere.com/index.php?title=ADempiere_Integration_With_Alfresco ADempiere Integration With Alfresco]
*New functionality
**Generates a md5 message digest for each file and stores this as additional attachment property
**Uses versioning capabilty of Alfresco&reg; to store updated attachment files as new version of the same object when the message digest is different

If you want to provide additional comments, please use the [[Talk:Plugin:_Alfresco_AttachmentProvider|Discussion page]].

== Details ==

In ADempiere two different storage providers were implemented. You could choose between database (the default) or filesystem (this you had to configure). New functionality has been developed as described in [http://www.adempiere.com/index.php?title=ADempiere_Integration_With_Alfresco ADempiere Integration With Alfresco] to connect to an external system using [https://en.wikipedia.org/wiki/Content_Management_Interoperability_Services CMIS].

Now in iDempiere - thanks to the [[NF1.0_Storage_Providers|StorageProvider]] functionality - the storage provider is easier to configure and "OSGI-pluggable".

This plugin provides the capability to use Alfresco&reg; as storage for attachments.

Of course a working Alfresco&reg; installation is a prerequisite. The development has been done against community version 5.0.d. The current 5.1 versions should work ok. Previous versions may or may not be working - the [https://wiki.alfresco.com/wiki/CMIS Alfresco wiki] provides information. Feedback is welcome.

Follow these steps
* Install Alfresco
* Create a user
* Create a folder in the repository
* Use [http://chemistry.apache.org/java/download.html OpenCMIS Workbench] to validate access 
** Use CMIS-URL http://server:port/alfresco/api/-default-/public/cmis/versions/1.0/atom [[File:Alfatt_00_cmisworkbench_connection.png|450px]]
** Update access rights if necessary
* Download the jarfile from [https://bitbucket.org/a42niem/idempiereattachmentalfresco/downloads bitbucket] 
* Use the Felix console to load the plugin
* In iDempiere in the relevant client create a new "Storage Provider" 
** You should find "Alfresco" as selectable method
* In the "Client" config on "Client Info" select you new created "Storage Provider" as AttachmentStore
* Prepare Alfresco so that it know about our new type
** The two ''xml'' files from [https://bitbucket.org/a42niem/idempiereattachmentalfresco/src stuff/iDModel] have to be put into ''tomcat/shared/classes/alfresco/extension'' of your Alfresco&reg; installation
** Restart Alfresco&reg;
* Login to Alfresco&reg; and open the relevant folder in the repository
* Create an attachment in iDempiere and "find" it in the Alfresco&reg; folder

If you want to use the auto-creation of subfolders as described in [http://www.adempiere.com/index.php?title=ADempiere_Integration_With_Alfresco#Let.27s_do_some_more_fancy_stuff Let's do some more fancy stuff] follow these steps
* Put the file ''idempiere.js'' from [https://bitbucket.org/a42niem/idempiereattachmentalfresco/src stuff/rule_script] into the folder ''dataDictionary/Scripts'' in the repository
* Create a rule for your iDempiere folder to apply this script when objects are moved to this folder or are updated (!) 
* Create a new attachment and find out, that Alfresco&reg; has created the relevant table and tableID related subfolders and moved the object there

== What is new? ==

This plugin is generating a md5 message digest for each file to be attached. The digest ist stored within the ''id:checksum'' property of the attachment. If a diferent checksum is detected at a later save then in the repository a new version of this object is created and stored. You can then use Alfrescos functionality to work on the different versions of your attachment. 

In iDempiere you will always see the latest version - without a hint whether there are more, this may be future functionality.

[[User:A42niem|A42niem]] ([[User talk:A42niem|talk]]) 14:32, 25 June 2016 (CEST)

[[Category:Available_Plugins]]