Secure collaboration with anyone, anywhere, on any device, now connected to Grooper.
A completed Content Model and accompanying Batch used for this setup can be found here. It is not required to download to understand this article, but can be helpful because it can be used to follow along with the content of this article. This file was exported from and meant for use in Grooper 2.9
Following is an example of how to configure a CMIS Connection object for Box and achieve an export of data.
Some of the tabs in this tutorial are longer than the others. Please scroll to the bottom of each step's tab before going to the step.
Understanding the Source
Perhaps the most challenging aspect of explaining how to leverage this functionality is the fact that it requires access to a Box environment. One was created for the sake of this article, but unfortunately cannot be shared externally. The scope of this article also does not allow explaining setting up Box, as that's an exhaustive topic on its own.
Given that, it will be assumed you have access to a Box environment that Grooper can connect to via a CMIS Connection.
The image on the right is showing the Metadata Template being used for this folder in this Box environment. As you can see it's very simple, just three fields of information.
Understanding the Content Model
The purpose of this Content Model is to simply extract three fields of information from the document in its accompanying Batch.
Extraction is being accomplished via simple Data Types with their Collation property set to Key-Value Pair and the Horizontal LayoutEnabled.
It should be noted that the document in the accompanying Batch had its Document Type assigned manually. The Content Model is not performing any classification.
Before the Document Export activity can send data, it must have data. It's easy to get in the habit of testing extraction on a Data Field or a Data Model and feel good about the results, but it must be understood that the information displayed when doing so is in memory, or temporary. When the Extract activity is successfully run against a properly classified document (you can at the very least manually assign a Document Type) it creates Index Data and marries it to the document via a JSON file called Grooper.DocumentData.json. A couple of ways to verify its existence are as follows.
First, navigate to the Document (or Folder) object in the node tree; not the Batch, not the Batch Folder, not the Page, but specifically the Document object. This is where the information lives.
From there, click on the Index Data tab.
After doing so you can see data displayed. Were the document classified, but not successfully extracted, the data structure would be present, but the fields empty.
Another means of verifying is to again, click on the Document object in the node tree.
Click the Advanced tab.
Click the Files tab.
In the List View you should see the Grooper.DocumentData.json file.
When you click on that file, you should see the stored JSON information of the indexed data displayed in the viewer below.
In order to connect to Box in Grooper you'll need and enterprise account, and what Box refers to as an Account ID.
When logged into Box, click the icon for your account to expose a drop-down menu.
Click on Account Settings.
Scroll to the bottom of this page and take note of the Account ID.
Configuring a Box CMIS Connection for Export
This configuration is specific to this article. While aspects of it can apply to any configuration, it's worth noting that your environment may require slightly different settings (especially considering proprietary pieces of information like the Account ID). Note that the URLs in the image cannot be connected to externally, so attempting to copy this configuration verbatim will give you errors. This is meant as a guide, and will require an actual Box environment on your end to be established, and real information from it supplied.
Set the Box User ID property to the Account ID you retrieved from you Box Account Settings.
Set the Use Metadata property to True so Grooper can create CMIS Content Types from your Box Metadata Templates.
With the previous settings saved, you can now click the List Repositories button.
Having clicked the previous button, there should be a repository (there may be multiple in your environment) in the Repository List view. Clicking on it ...
... will allow the Import Repository button to be clicked. This will change the red dot on the icon to green, meaning there's an active connection to this repository.
It will also create several objects in the Grooper node tree: CMIS Repository ojbect, Content Types folder object, and two CMIS Content Type objects - Document and Folder.
Select the CMIS Repository ojbect.
Expand the tree of the DocumentContent Type object within the Content Types view, and select the CMIS Content Type for the child object representing the Box Metadata Template you wish to connect to (it will have a red dot initially.)
These child CMIS Content Types, or Box Metadata Templates, would not be available if the Use Metadata property were not set to True.
This will be different for your environment, but notice the Content Type Properties list view below. This lists the Writable Properties and also gives other important information about thier configuring like the data type of the columns.
With the desired Content Type imported, a new object representing it will exist in the node tree.
Select the newly created CMIS Content Type representing your chosen Box Metadata Template.
Set the Export Enabled property to True.
Select the Export Content Type property and click the drop-down arrow to get a mini node tree view, and select the Content Type that contains the scope of information you wish to export.
Select the Export Field Mappings property and click its ellipsis button. This will open a Field Mappings window.
The left column represents the columns of information in your Box Medatdata Template, the column on the right represents the Data Elements or expressions in Grooper you will map to those columns.
For the Name column, I'm choosing to populate it with a simple expression that will pass the classified Document Type of the current folder.
The expression used is:
For the remaining fields, simply select their corrensponding Data Fields from the model you're wishing to export from.
CMIS Content Type fields can be mapped to GrooperData Fields. However, Data Fields that exist within Data Sections with the Scope property set to MultiInstance cannot be mapped.
Note: Data contained in Data Tables and Data Sections with the Scope property set to MultiInstance can only be exported from Grooper using Database Export, or a custom activity.
The Name and Object Type ID fields are considered required by Box, and Grooper will pass an error if they're not mapped. I'm choosing to not map Object Type ID and deal with the error later.
This is the error passed, but I will Save Anyway.
Performing Mapped Export for Box CMIS Connection
The approach taken below is via the object command interface. These same settings can be applied to a Step in a Batch Process to achieve the same results, albeit in a slightly different area of the Grooper UI.