Import Query Results (Import Provider): Difference between revisions

From Grooper Wiki
Newer edit →
Created page with "== About == '''Import Query Results''' is an Import Provider used to search a repository for documents you want to import, given whatever set of criteria you define.  This..."
 
No edit summary
(11 intermediate revisions by 3 users not shown)
Line 1: Line 1:
This is a redirect page.
<blockquote>{{#lst:Glossary|Import Query Results}}</blockquote>
For information on '''''Import Query Results''''' visit the following resources:
* [[CMIS Import]] - This is an article covering imports using '''CMIS Connections''' in general.
* [[CMIS Import#About CMIS Import]] - This portion of the "CMIS Import" article briefly covers the differences between '''''Import Descendants''''' and '''''Import Query Results'''''.
* [[CMIS Import#Import Query Results]] - This portion of the "CMIS Import" article explains '''''Import Query Results'''''.
<!---
== About ==
== About ==


Line 31: Line 41:




[[image:001.PNG|center]]
[[image:001.png|center]]




Line 41: Line 51:
* Select the appropriate repository from the "Repository" property.  
* Select the appropriate repository from the "Repository" property.  


{|style="text-align:center" cellpadding="30"
{|style="text-align:center" cellpadding="15"
|-
|-
|Find the "Repository" property||Select your Repository
|Find the "Repository" property||Select your Repository
|-
|-valign="top"
|[[image:importQueryResults002.PNG|center]]||[[image:importQueryResults003.PNG|center]]
|[[image:importQueryResults002.png|center|500px]]||[[image:importQueryResults003.png|center|500px]]
|}
|}


Line 61: Line 71:
The settings for the "Basic Search" tab will alter the query in the "CMSQL" tab and vice versa. You can use these to get a feel for what's going on.  
The settings for the "Basic Search" tab will alter the query in the "CMSQL" tab and vice versa. You can use these to get a feel for what's going on.  


{|style="text-align:center" cellpadding="30"
{|style="text-align:center" cellpadding="15"
|-
|-
|colspan="2"|Find the **CMIS Query** property
|colspan="2"|Find the "CMIS Query" property
|-
|-
|colspan="2"|[[image:importQueryResults004.PNG]]
|colspan="2"|[[image:importQueryResults004.png|center|900px]]
|-
|-
|The "Basic Search" tab||The "CMISQL" tab
|The "Basic Search" tab||The "CMISQL" tab
|-
|-valign="top"
|[[image:importQueryResults005.PNG||[[image:importQueryResults006.PNG]]  
|[[image:importQueryResults005.png|center|500px]]||[[image:importQueryResults006.png|center|500px]]
 
</tab>
</tab>
<tab name="Step 4">
<tab name="Step 4">
Line 78: Line 90:
* Pressing "Import" will create a batch of documents that were imported using 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 these screenshots, the batch will be created at the "Image Review" step of a Batch Process. )))
Using the "Starting Step" property, you can choose from your published Batch Processes the step where your batch should be created. For example, in these screenshots, the batch will be created at the "Image Review" step of a Batch Process.  




Line 121: Line 133:
{|cellspacing="5" cellpadding="10"
{|cellspacing="5" cellpadding="10"
|'''Predicate'''||'''Description'''||'''Example'''
|'''Predicate'''||'''Description'''||'''Example'''
|-style="background-color:ddf5f5"
|-style="background-color:#ddf5f5"
|Comparison Predicate||Specifies a condition for an individual property using comparisons, such as "equals to" or "less than".  The <code>LIKE</code> and <code>IS</code> operators are also a comparison predicates.||<code>invoice_date<'12/31/2007'</code>
|Comparison Predicate||Specifies a condition for an individual property using comparisons, such as "equals to" or "less than".  The <code>LIKE</code> and <code>IS</code> operators are also a comparison predicates.||<code>invoice_date<'12/31/2007'</code>
|-style="background-color:ddf5f5"
|-style="background-color:#ddf5f5"
|<code>IN</code> Predicate||Specifies a list of allowed values for a property.  This list is separated by commas.||<code>FileExtension IN ('.pdf', '.docx', '.xlsx')</code>
|<code>IN</code> Predicate||Specifies a list of allowed values for a property.  This list is separated by commas.||<code>FileExtension IN ('.pdf', '.docx', '.xlsx')</code>
|-style="background-color:ddf5f5"
|-style="background-color:#ddf5f5"
|<code>CONTAINS</code> Predicate||Specifies a full-text query.  You can use AND, OR and NOT operators.||<code>CONTAINS('mortgage AND payment AND NOT vehicle')</code>
|<code>CONTAINS</code> Predicate||Specifies a full-text query.  You can use AND, OR and NOT operators.||<code>CONTAINS('mortgage AND payment AND NOT vehicle')</code>
|-style="background-color:ddf5f5"
|-style="background-color:#ddf5f5"
|Scope Predicate||Restricts the search scope to children or descendants of a folder||<code>IN_FOLDER(/Inbox)</code>
|Scope Predicate||Restricts the search scope to children or descendants of a folder||<code>IN_FOLDER(/Inbox)</code>
|}
|}
Line 157: Line 169:
{|cellspacing="5" cellpadding="10"
{|cellspacing="5" cellpadding="10"
|'''Filter'''||'''Description'''
|'''Filter'''||'''Description'''
|-style="background-color:ddf5f5"
|-style="background-color:#ddf5f5"
|<code>SELECT * FROM File</code>|Import all descendant files.  This will import all files in the repository without any foldering.
|<code>SELECT * FROM File</code>||Import all descendant files.  This will import all files in the repository without any foldering.
|-style="background-color:ddf5f5"
|-style="background-color:#ddf5f5"
|<code>SELECT * FROM File WHERE AT_LEVEL(1)</code>||Import files which are immediate children.  This will only import files at that level, not from subsequent levels.
|<code>SELECT * FROM File WHERE AT_LEVEL(1)</code>||Import files which are immediate children.  This will only import files at that level, not from subsequent levels.
|-style="background-color:ddf5f5"
|-style="background-color:#ddf5f5"
|<code>SELECT * FROM Folder</code>||Import folders which are immediate children.  This will import both files and their foldering.
|<code>SELECT * FROM Folder</code>||Import folders which are immediate children.  This will import both files and their foldering.
|-style="background-color:ddf5f5"
|-style="background-color:#ddf5f5"
|<code>SELECT * FROM File WHERE cmis:name MATCHES '^\d{4}-\d{2}-\d{2}'</code>||Import files with a specific naming pattern, using regular expression.
|<code>SELECT * FROM File WHERE cmis:name MATCHES '^\d{4}-\d{2}-\d{2}'</code>||Import files with a specific naming pattern, using regular expression.
|-style="background-color:ddf5f5"
|-style="background-color:#ddf5f5"
|<code>SELECT * FROM File WHERE cmis:name LIKE 'ca%'</code>||Import files with a name starting with ca.
|<code>SELECT * FROM File WHERE cmis:name LIKE 'ca%'</code>||Import files with a name starting with ca.
|-style="background-color:ddf5f5"
|-style="background-color:#ddf5f5"
|<code>SELECT * FROM File WHERE cmis:contentStreamLength > 10000</code>||Import files larger than 10,000 bytes.
|<code>SELECT * FROM File WHERE cmis:contentStreamLength > 10000</code>||Import files larger than 10,000 bytes.
|}

Revision as of 14:58, 21 November 2024

This is a redirect page.

Import Query Results is one of two Import Providers that use cloud CMIS Connections to import document content into Grooper. Import Query Results imports files from a settings_system_daydream CMIS Repository that match a "CMISQL query" (a specialized query language based on SQL database queries).

For information on Import Query Results visit the following resources:


Retrieved from "https://wiki.grooper.com/index.php?title=Import_Query_Results_(Import_Provider)&oldid=26815"