What’s New In Transact 4.5?


Export | Export of Values into “Multiple” Fields via CMIS Export Function

In previous versions of Transact, the CMIS Export function did not support the export of index field values into CMIS fields with the “Multiple” attribute set to True. In such cases, batches used to go into error state at the Export module and the following error was mentioned in the Transact log files:

3034_SP0++ 2013-06-13 14:22:24,107 ERROR pool-1-thread-1 com.ephesoft.dcma.cmis.CMISExporter – Error while uploading document with identifier: DOC1 for batch instance: BI5
java.lang.IllegalArgumentException: Property ‘bf:documentProperty’ is not a single value property!

In Ephesoft Transact v4.5.0.0, the CMIS Export function has been enhanced to include multi-property support. Now, the batches are successfully processed and values are exported to the fields with the “Multiple” property set to True on the CMIS side. Support for a multiple value configuration is provided only for DLF-Attribute-mapping (document level field mapping).

Ephesoft and Alfresco Data Types that support multi-property:

Ephesoft Data Type Alfresco Data Type Multi-property support
STRING d:text YES
INTEGER d:int YES
FLOAT d:float YES
DOUBLE d:double YES
BOOLEAN d:boolean YES
LONG d:long YES
DATE d:datetime NO

 

To export the document with multi-value fields into external repositories:

1. Open or create a Batch Class.

2. Create a new Document type.

3. Add the Index fields. Make sure to specify the correct Data Type.

C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\cmis6.png

4. Configure the Index fields:

  • Place Key and Value overlays as required
  • Click on the overlay and select existing or create a new regex using the Suggest Regex dialogue window
  • Validate regex
  • Click on the Test KV button to test extraction
  • Click on the Apply KV button to save the configuration

C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\cmis11.png

C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\cmis12.png

5. Navigate to the Export module and add the CMIS_Export plugin.

C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\cmis1.png

6. Navigate to the CMIS_Export plugin screen and configure CMIS Export settings.

C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\cmis2.png

Configurable property Description
CMIS Root Folder Name This is the name of the destination folder in the external repository to which the document will be exported. If this field is left empty the document will be exported directly into the Root Folder.
CMIS Upload File Extension This setting controls whether the documents are exported into CMIS as PDF or TIF images.
CMIS Server URL The URL of the CMIS repository server. This URL varies for different repositories like Alfresco, SharePoint, Nuxeo, and others.
CMIS Server User Name The username for the CMIS repository server login.
CMIS Server User Password The password for the CMIS repository server login.
CMIS Server Repository ID The ID of the CMIS repository used for uploading files.
CMIS Server Switch ON/OFF Switch to enable or disable export to CMIS.
Aspect Switch This switch enables support for Aspects – dynamically assignable groups of properties. This is specific to the Alfresco repository.
CMIS Export File Name Naming convention for exported documents.
CMIS Export Client Key, Secret Key, Refresh Token, Redirect URL and Export Network Properties used to implement OAuth authentication, if required.
CMIS Version Version of CMIS used by the plugin for the connection to the repository.

Note: For more information on the CMIS Export plugin, refer here.

7. Click Test CMIS to test the CMIS connection.

C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\cmis4.png

8. On the CMIS server, define a content model, setting the “Multiple” property for required fields to True. In Alfresco, this is the ephesoftModel.xml file in the Extension folder:

C:\alfresco-community-new\tomcat\shared\classes\alfresco\extension

C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\cmis5.png

9. On the Ephesoft server, open the DLF-Attribute-mapping.properties file located in the Ephesoft_Installation_Directory\SharedFolders\{BatchClass}\cmis-plugin-mapping folder created for each Batch Class.

10. In the DLF-Attribute-mapping.properties file, map the Ephesoft document type and index fields with type and properties in the CMIS model file according to the following format:

documentName(ephesoft)=D:(name in CMIS in <Type>)

documentName.FieldName=property name

Ephesoft Transact Content model in CMIS (ephesoftModel.xml file)
C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\table.png C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\table1.png
C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\table2.png C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\table6.png

 

The mapping in the DLF-Attribute-mapping.properties file will look like the following:

C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\cmis7.png

Note: Make sure to use “D:” for document type mapping.

11. Now, navigate to the Upload Batch screen in Ephesoft Transact, upload a batch, select the Batch Class and click on the Start Batch button.

C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\cmis9.png

12. The batch is processed and the document is successfully exported to a specified location in the external repository along with the values where the “Multiple” property is set to True.

C:\Users\Ephesoft\AppData\Local\Microsoft\Windows\INetCache\Content.Word\cmis10.png