Import Conditions

Dockit can update folder and list item metadata / properties in SharePoint based on certain conditions. The conditions can be created using SharePoint columns or metadata columns and values from the batch file.

1. The Import Conditions step appears as shown below:

2.

Select any one of the following options given below:

  1. Do not apply any conditions - No conditions will be used to filter folders / items.
  2. Apply the following conditions - The conditions specified will be used to filter folders / list items taken for update or delete in SharePoint
3. The wizard step appears as shown below:

 

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

4.

Click Add Fields button to add the SharePoint Columns in Field Name drop-down box. Using this dialog, you can also filter the list items using existing columns in SharePoint list. 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 field.

Click Add button to add the columns to the Field Name drop-down.

Click Remove button to remove the columns from the Field Name drop-down.

5.

Dockit can update the folders / list items that satisfy the conditions or update the folders / list items that do not satisfy the conditions specified in the step above. Use the appropriate action to follow using the options given below:

  1. Perform action against folder / list items if the above conditions are satisfied - Folders / List items that satisfy the condition will be marked for metadata update.
  2. Perform action against folder / file if the above conditions are not satisfied - Folders / List items that do not satisfy the condition will be marked for metadata update.

6.

Click Next to proceed.