2021:Behaviors (Property): Difference between revisions

From Grooper Wiki
No edit summary
No edit summary
Line 158: Line 158:
{|cellpadding=10 cellspacing=5
{|cellpadding=10 cellspacing=5
|valign=top style="width:35%"|
|valign=top style="width:35%"|
# <li value=8>Select '''''Read Mappings''''' property and click the ellipsis button.</li>
# <li value=8></li>
# In the '''CMIS Import Map''' window you can set which fields you want to map. Here we set the '''''Employee ID''''' field to match the ''Employee_ID'' column from SharePoint.
#  
|
|
[[Image:behaviours_13.png]]
[[Image:behaviours_13.png]]
Line 167: Line 167:
{|cellpadding=10 cellspacing=5
{|cellpadding=10 cellspacing=5
|valign=top style="width:35%"|
|valign=top style="width:35%"|
# <li value=10>Here we are setting the '''''Document Type Name''''' field to match the ''DocType'' column from SharePoint.</li>  
# <li value=10></li>  
|
|
[[Image:behaviours_14.png]]
[[Image:behaviours_14.png]]
|}
|}
====Write Mappings====
====Write Mappings====
We will be looking for documents from the SharePoint that have the '''''Imported''''' value of ''No''. This lets us know the documents have not been processed by '''Grooper''' yet. Immediately upon import we will use the Import '''''Write Mappings''''' property to change the values of the '''''Imported''''' column from ''No'' to ''InProcess''.
We will be looking for documents from the SharePoint that have the '''''Imported''''' value of ''No''. This lets us know the documents have not been processed by '''Grooper''' yet. Immediately upon import we will use the Import '''''Write Mapping''''' property to change the values of the '''''Imported''''' column from ''No'' to ''InProcess''.
{|cellpadding=10 cellspacing=5
{|cellpadding=10 cellspacing=5
|valign=top style="width:35%"|
|valign=top style="width:35%"|
# <li value=11>Select the '''''Write Mappings''''' property and click the ellipsis button to bring up the '''CMIS Update Map''' window. Here we are setting the '''''Imported''''' field to the expression <code>"InProgress"</code> which will insert it as a string in SharePoint.</li>
# <li value=11></li>
|
|
[[Image:behaviours_15.png]]
[[Image:behaviours_15.png]]
Line 181: Line 181:
===Export Behaviors Setup===
===Export Behaviors Setup===
In this section we will cover how to configure an '''Export Behaviors''' for both a '''Content Type''' and a '''Batch Process Step''' configured for ''Export''. While all the '''Export Mappings''' in this sample use case ''could'' be set on the '''Content Model''', this walkthrough includes an '''Export Mapping''' in the '''Batch Process''' to show how both can be leveraged.
In this section we will cover how to configure an '''Export Behaviors''' for both a '''Content Type''' and a '''Batch Process Step''' configured for ''Export''. While all the '''Export Mappings''' in this sample use case ''could'' be set on the '''Content Model''', this walkthrough includes an '''Export Mapping''' in the '''Batch Process''' to show how both can be leveraged.
Not all types of '''Export Behaviors''' are covered (File, SFTP, FTP, and IMAP are not included.) If you feel, after reading this article, that one of the other types should be covered because it is complex enough to warrant a walkthrough, please contact the Training and Education team.
====Content Model Export Behavior====
====Content Model Export Behavior====
The '''Export Behavior''' used here is concerned with exporting the document to the '''CMIS Repository'''.
The '''Export Behavior''' used here is concerned with exporting the document to the '''CMIS Repository'''.
Line 235: Line 233:
# <li value=15></li>
# <li value=15></li>
|
|
[[Image:behaviours_22.png]]
[[Image:behaviours_21.png]]
|}
|}
{|cellpadding=10 cellspacing=5
{|cellpadding=10 cellspacing=5

Revision as of 10:42, 29 March 2021

2021

This article is in development for the upcoming version of Grooper, Grooper 2021. Behaviors are a new set of data control functionalities in 2021. This information is incomplete and/or may change by the time of release.
Behaviors are like telling the mind what to let in and out.

Behaviors are properties set on Content Types and Export activities that control the flow of documents into and out of Grooper .

About

Behaviors are new to Grooper 2021 and are born of the idea that consolidating the control of the flow of data to the objects most relevant to its collection and delivery (Content Types{Content Model, Content Category, Document Type} and the Export activity) creates a more streamlined and effective Grooper experience. If the Content Type controls all the relevant information about how documents are organized and what is to be collected from them, it is logical that controlling how those documents come into Grooper, and how they get out, should also be defined by the same object. It is also a much cleaner experience to no longer have multiple steps in a Batch Process to cover the types of Export activities (Legacy Export, Mapped Export, Database Export), but instead a single Export activity that leverages the Behaviors of the Content Type, Behaviors defined on the Export activity, or both.

If you take CMIS Connections, for example, Grooper previously created an unnecessary amount of objects to get to the CMIS Content Type. The mappings for importing and exporting were also set here, which made for more places which a person need to go to configure the flow of data into and out of Grooper. It also created a bottle neck of control because if you wanted to have disparate Content Types use a similar CMIS connection, but the import/export mappings inherently needed to be different, you would have had to create a separate CMIS Content Type. Now, one CMIS Repository object can exist, and the import/export mechanisms are controlled via Behaviors (again, defined on Content Types or Export activities.)

Types of Behaviors

There are four types of Behaviors that can be added to a Content Type or Export activity.

Import

Import Behaviors control the flow of documents into Grooper by establishing communication, an Import Definition (of which multiple can exist), between a CMIS Repository object and a Grooper Content Type.

CMIS Content Type objects no longer exist in Grooper 2021, therefore Import mappings are no longer set there. They are instead set on an Import Behavior of a Content Type. This elminates the need for multiple CMIS Conent Type objects to exist for the individual needs of discrete Content Types, and instead consolidates the control to the object most pertinent to the import functionality.

Export

Export Behaviors control the flow of documents out of Grooper by defining export connectivity to external systems such as file systems (directly through a File Export definition, or a CMIS Repository object), content management systems (via CMIS Repository objects), Database Tables, mail servers (directly through an IMAP Export definition, or a CMIS Repository object), or FTP/SFTP servers (directly through FTP/SFTP Export definitions, or a CMIS Repository object).

CMIS Content Type objects no longer exist in Grooper 2021, therefore Export mappings are no longer set there. They are instead set on the Export Behavior of a Content Type , or a Batch Process Step set to Export on its Activity Type property. This elminates the need for multiple CMIS Conent Type objects to exist for the individual needs of discrete Content Types, and instead consolidates the control to the object most pertinent to the export functionality.

Labeling

The Labeling Behavior is a Content Type Behavior designed to collect and utilize a document's field labels in a variety of ways. This includes functionality for classification and data extraction.

The Labeling Behavior functionality allows Grooper users to quickly onboard new Document Types for structured and semi-structured forms, utilizing labels as a thumbprint for classification and data extraction purposes. Once the Labeling Behavior is enabled, labels are identified and collected using the "Labels" tab of Document Types. These "Label Sets" can then be used for the following purposes:

  • Document classification - Using the Labelset-Based Classification Method
  • Field based data extraction - Using the Labeled Value Extractor Type
  • Tabular data extraction - Using a Data Table object's Tabular Layout Extract Method
  • Sectional data extraction - Using a Data Section object's Transaction Detection Extract Method

Understanding the full functionality of the Labeling Behavior is worthy of it’s own article, which can be found here.

PDF Generate

The PDF Generate Behavior is a Content Type Behavior designed to create an exportable PDF file with additional native PDF elements, using the classification and extraction content of a Batch Folder. This includes capabilities to export extracted data as PDF metadata, inserting bookmarks, and creating PDF annotations, such as highlighting, checkbox and signature widgets.

Understanding the full functionality of the PDF Generate Behavior is worthy of it’s own article, which can be found here.

How To

Following is a walkthrough demonstrating the setup of Behaviors using a simplified use-case utilizing SharePoint and a database table. It is important to understand that due to the self-contained nature of the aforementioned utilities that this walkthrough will require some translation on the reader's part.

Foundations

Understanding the infrastructure of what's being used for the following walkthrough will help the example make sense.

SharePoint

This test Sharepoint enviornment has three documents it in. The First Name and Last Name fields are left intentionally blank. The Employee ID fields are filled with the intention of reading those values into Grooper upon import. Two of the documents have the DocType fields filled, while the third does not. This will be used to demonstrate how documents can be classified with results from the CMIS repository, while also showing the default behavior otherwise. The Imported fields are set to No. The query used to import the documents will look for the No result to know what to import. Upon importing into Grooper this value will be read and simultaneously changed to InProcess to prevent further pickup. Finally, on export the fields will be written to with Yes to signify they’ve been processed.

Document Understanding

The documents are populated with the first and last names of the employee, which will be extracted and later exported back to the SharePoint to populate the First Name and Last Name columns. The Earnings table will be extracted by Grooper and sent to a database table. The information will be flattened out with the Employee ID read from the SharePoint and sent with the table information so that the SharePoint and database information can be related.

CMIS Repository

  1. Here the imported CMIS Repository is selected in Grooper Design Studio.
  2. On the Type Definitions tab...
  3. ...you can see that because this particular subsite of the SharePoint environment is referenced by a Behavior that the icon has a green dot and...
  4. ...with it selected you can see the stucture of the SharePoint subsite like the column names and their properties.

Database

  1. An imported database table is selected here in Grooper Design Studio.
  2. You can view the structure of the table and see that it includes what we saw from the Earnings table from the document, along with the Employee ID to marry rows from this table back to the SharePoint. In the Data Preview below, you’ll notice there is no data yet.

Data Model & Extraction

  1. Here is the sample Data Model selected with three Data Fields and the accompanying Data Table.
  2. It is configured properly as you can see the successfully extracted information displayed in the Data Model Test Results area.
  3. You can also see the document structure of the extracted information displayed in the Document Viewer.

Batch Process

  1. The Batch Process highlighted is a very simple model for this example setup.
  2. The main thing about this setup is to demonstrate the Export Activity.
  3. We&rsqo;ll cover the particulars later, but the idea here is to show that Behaviors can be setup on both a Content Type, as well as a Batch Process Step configured as an Export activity, and share the results.

Import Behavior Setup

In this section we will cover how to configure an Import Behavior with both read and write properties.

Behaviors

  1. Here we have selected a Content Type, specifically the Content Model.
  2. Select the Behaviors property and click the ellipsis button.
  3. This will bring up the Behaviors - List of Behaviors menu from which you can click the Add dropdown and select Import Behavior.

Import Definitions

  1. Select the Import Definitions property and click the ellipsis button.
  2. This will bring up the Import Definitions - List of Import Defintion menu from which you can click the Add dropdown and select CMIS Import Definition.

  1. With the CMIS Import Definition added you can select the CMIS Repository property and choose an imported CMIS Repository object.

  1. After selecting a CMIS Repository you can select the CMIS Content Type property and choose, in this case of SharePoint, a subsite document library.

Read Mappings

A critical aspect to understand here is document classification upon import. By setting the Read Mappings property you are telling Grooper to populate a Data Element with information. In doing so, you are forcing Grooper to associate the incoming document with the Contnet Type related to the Data Model that owns that Data Element. In short, the incoming documents will be classified as BehavioursContentModel by default.

The Document Type Name property allows us to read a value from the CMIS Repository and classify documents as a result. This is very useful, and something completely new to this version of Grooper. If you recall, there are two documents in the SharePoint with the DocType column populated: one test, the other test2. There are two Document Types in the sample Content Model called test and test2. As a result, this read mapping will allow those two documents to come in classified as those Document Types. The third document, having no DocType value from SharePoint, will come in classified as BehavioursContentModel.

Write Mappings

We will be looking for documents from the SharePoint that have the Imported value of No. This lets us know the documents have not been processed by Grooper yet. Immediately upon import we will use the Import Write Mapping property to change the values of the Imported column from No to InProcess.

Export Behaviors Setup

In this section we will cover how to configure an Export Behaviors for both a Content Type and a Batch Process Step configured for Export. While all the Export Mappings in this sample use case could be set on the Content Model, this walkthrough includes an Export Mapping in the Batch Process to show how both can be leveraged.

Content Model Export Behavior

The Export Behavior used here is concerned with exporting the document to the CMIS Repository.

Batch Process Export Behavior

The Export Behavior used here is concerned with exporting tabular information to a Database Table.

The following property is important because it determines priority of Behaviors when sharing between a Content Type and Batch Process Step. Shared refers to the Behaviors of the Content Type, while Local refers to the Behaviors of the Batch Process Step.

Execution and Results

In this section we'll take a look at the results by running a manual import with a CMIS Query and associating it with the sample Batch Process.

Import Query

Reviewing Classification

Viewing Results

File:Behaviours 34.png

File:Behaviours 35.png

File:Behaviours 36.png