Export Conditions


SPListX can export folders, files and list items (including file attachments) from a SharePoint list or library based on certain export conditions. The conditions can be created by using SharePoint columns in the source list or library.

1.

The Export Conditions step appears as shown below:

2.

You can specify one of the following methods of exporting conditions:

  • BASIC
  • ADVANCED

3.

BASIC

You can specify export conditions at four levels:

  • Site Level Filter
  • List Level Filter
  • Folder Level Filter
  • File or Item Level Filter

   a.

Site Level Filters

Click Site level filter to specify the filter conditions. The Site Level Filter dialog appears as below:

 

   b.

You can specify the export filters by selecting the site name and by specifying a value with necessary operator.
You can use mathematical operators such as =, <> to define your query. Complex queries can be constructed using logical operators 'AND' and 'OR'.

Click
 to add multiple filters.
Click
 to remove the filter from the filter list.

Click Clear to remove all the filters specified.



SPListX will export the sites that satisfy the export conditions depending on the option selected by the user.

 

   c.

List Level Filters

Click List level filter to specify the filter conditions. The List Level Filter dialog appears as below:

 

   d.

You can specify the export filters by selecting the field name and by specifying a value with necessary operator.
You can use mathematical operators such as =, <> to define your query. Complex queries can be constructed using logical operators 'AND' and 'OR'.

Click
 to add multiple filters.
Click
 to remove the filter from the filter list.

Click Clear to remove all the filters specified.



SPListX will export the lists that satisfy the export conditions depending on the option selected by the user.

 

   e.

Folder Level Filters

Click Folder level filter to specify the filters. The Folder Level Filter dialog appears as below:

   f.

You can enter the SharePoint Column Name in the Property drop down. Select the data type of the specified SharePoint Column in Field Type drop down.

   g.

You can specify the export filters by selecting the field name and by specifying a value with necessary operator.
You can use mathematical operators such as =, <> to define your query. Complex queries can be constructed with the use of logical operators 'AND' and 'OR'.

Click
 to add multiple filters.
Click
Description: Description: Description: C:\Users\karthikeyan\Desktop\Help\remove-button.png to remove the filter from the filter list.

Click Clear to remove all the filters specified.



SPListX will export the folders that satisfy the export condition depending on the option selected by the user.

   h.

File or Item Level Filters

Click File or Item Level to specify the filters. The File or Item Level Filter dialog appears as below:

   i.

You can specify the export filters by selecting the field name and by specifying a value with necessary operator.
You can use mathematical operators such as =, <> to define your query. Complex queries can be constructed with the use of logical operators 'AND' and 'OR'.

Click
 to add multiple filters.
Click
Description: Description: Description: C:\Users\karthikeyan\Desktop\Help\remove-button.png to remove the filter from the filter list.

Click Clear to remove all the filters specified.



SPListX will export the folders that satisfy the export condition depending on the option selected by the user.

4.

ADVANCED

You can specify export conditions at four levels:

  • Site Level Filter
  • List Level Filter
  • Folder Level Filter
  • File or Item Level Filter

   a.

Site Level Conditions

Click Site level filter to specify the conditions

The Site Export Conditions Dialog appears as shown below:




   b.

You can specify the export conditions by selecting the field name and by specifying a value with necessary operator.
You can use mathematical operators such =,<> to define your query. Complex queries can be constructed with the use of left-right parenthesis '(' and ')' and logical operators 'AND' and 'OR'.




   c.

SPListX will export the sites that satisfy the export condition or export the sites that do not satisfy the export condition depending on the option selected by the user:

  • Export sites if the above conditions are satisfied - Sites that satisfy the condition will be marked for export.

  • Export sites if the above conditions are not satisfied - Sites that do not satisfy the condition will be marked for export.

   d.

List Level Conditions

Click List level filter to specify the conditions

The List Export Conditions Dialog appears as shown below:




   e.

You can specify the export conditions by selecting the field name and by specifying a value with necessary operator.
You can use mathematical operators such =,<> to define your query. Complex queries can be constructed with the use of left-right parenthesis '(' and ')' and logical operators 'AND' and 'OR'.




   f.

SPListX will export the lists that satisfy the export condition or export the lists that do not satisfy the export condition depending on the option selected by the user:

  • Export list if the above conditions are satisfied - Lists that satisfy the condition will be marked for export.

  • Export list if the above conditions are not satisfied - Lists that do not satisfy the condition will be marked for export.

   g.

Folder Level Conditions

Click Folder level filter to specify the conditions

The Folder Export Conditions Dialog appears as shown below:




   h.

Click  (...) button to add the SharePoint columns in Field Name dropdown. The Add Fields dialog appears as shown below:



Specify the column name in Name textbox and select the data type of the column in SharePoint from Type drop-down.

Click Add button to add the columns to the fieldname dropdown list.

Click Remove button to remove the columns from the fieldname dropdown list.

   i.

You can specify the export conditions by selecting the field name and by specifying a value with necessary operator.
You can use mathematical operators such =,<> to define your query. Complex queries can be constructed with the use of left-right parenthesis '(' and ')' and logical operators 'AND' and 'OR'.




   j.

SPListX will export the folders that satisfy the export condition or export the folders that do not satisfy the export condition depending on the option selected by the user:

  • Export folder if the above conditions are satisfied - Folders that satisfy the condition will be marked for export.

  • Export folder if the above conditions are not satisfied - Folders that do not satisfy the condition will be marked for export.

   k.

File or Item Level Conditions

Click File or Item level filter to specify the conditions

The File Export Conditions Dialog appears as shown below:




   l.

Click  (...) button to add the SharePoint columns in Field Name dropdown. The Add Fields dialog appears as shown below:



Specify the column name in Name textbox and select the data type of the column in SharePoint from Type drop-down.

Click Add button to add the columns to the fieldname dropdown list.

Click Remove button to remove the columns from the fieldname dropdown list.

   m.

You can specify the export conditions by selecting the field name and by specifying a value with necessary operator.
You can use mathematical operators such =,<> to define your query. Complex queries can be constructed with the use of left-right parenthesis '(' and ')' and logical operators 'AND' and 'OR'.




   n.

SPListX will export the folders that satisfy the export condition or export the folders that do not satisfy the export condition depending on the option selected by the user:

  • Export list items if the above conditions are satisfied - Files or listitems that satisfy the condition will be marked for export.

  • Export list items if the above conditions are not satisfied - Files or listitems that do not satisfy the condition will be marked for export.

5.

Click Next to proceed.

Also See:

Examples of Export Conditions