Import Query Results (Import Provider): Difference between revisions
Configadmin (talk | contribs) No edit summary |
No edit summary |
||
| (9 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 41: | Line 51: | ||
* Select the appropriate repository from the "Repository" property. | * Select the appropriate repository from the "Repository" property. | ||
{|style="text-align:center" cellpadding=" | {|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=" | {|style="text-align:center" cellpadding="15" | ||
|- | |- | ||
|colspan="2"|Find the | |colspan="2"|Find the "CMIS Query" property | ||
|- | |- | ||
|colspan="2"|[[image:importQueryResults004.png|center]] | |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|center]] | |[[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 158: | Line 170: | ||
|'''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. | ||
| Line 169: | Line 181: | ||
|-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:
- 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.