Import Descendants (Import Provider)

About

Import Descendants is an Import Provider used to import objects from a CMIS Repository that are "children" or "descendants" of a base CMIS Folder. This is done using a SQL-style "filter" to select the items that will be imported.

AT_LEVEL selects items at a specific level
MATCHES allows RegEx against property values

Example

Step 1Step 2Step 3

Create a Batch

The easiest way to use Import Descendants is by creating a new batch.

In Grooper Design Studio or Grooper Dashboard, create a new batch by pressing "Batch > CMIS Import > Import Descendants...".

Choose the Repository

If you have multiple CMIS repositories available, you'll need to choose the one from which you wish to import.

Select the appropriate repository from the "Repository" property.

Analyze and Import

Now we can test it out.

Pressing "Analyze" will run a search against your repository with your configured settings.
Pressing "Import" will create a batch of documents that were imported using your configured settings.

Using the "Starting Step" property, you can choose from your published Batch Processes the step where your batch should be created. For example, in the screenshot below, the batch will be created at the **Image Review** step of a Batch Process.

Example Queries

These are samples of what you could type into the "Import Filter" to narrow which objects are imported. They take the following general form.

SELECT * FROM <ContentType> WHERE <Criteria>

Below are a few examples of this syntax in action.

Filter	Description
`SELECT * FROM File`	Import all descendant files. This will import all files in the repository without any foldering.
`SELECT * FROM File WHERE AT_LEVEL(1)`	Import files which are immediate children. This will only import files at that level, not from subsequent levels.
`SELECT * FROM Folder`	Import folders which are immediate children. This will import both files and their foldering.
`SELECT * FROM File WHERE cmis:name MATCHES '^\d{4}-\d{2}-\d{2}'`	Import files with a specific naming pattern, using regular expressions.
`SELECT * FROM File WHERE cmis:name LIKE 'ca%'`	Import files with a name starting with ca.
`SELECT * FROM File WHERE cmis:contentStreamLength > 10000`	Import files larger than 10,000 bytes.