Examples


SPListX exports folders & files / attachments along with metadata to the file system location based on export conditions defined in the export task. Export conditions can be constructed using metadata columns and its values.

A few examples of site and list conditions are as follows:

Export Condition

Description

[Server Relative URL] = '/site name/subsite name/lists/list name'

Exports list items that have server relative URL as
'/site name/subsite name/lists/list name'
For example: [Server Relative URL] = '/vyapin/sharepoint/lists/Product List'

[List Name] = 'Cities'

Exports list item and attachments of lists named as 'Cities'

[List Type] = 'Document Library'

Exports documents from all document libraries in the entire web application.

[Base Type] <> 'Document Library'

Exports list items and attachments of all custom lists (other than document libraries) that are present in the entire web application.

[Site Name] = 'Team'

Exports all the lists, libraries that are present under the specified site name.

A few examples of item and folder export conditions are as follows:

Export Condition

Description

[Modified] > '09/09/2010' 

Assuming the date specified by the user is in MM/DD/YYYY format and with this condition, SPListX exports list items that have been modified after 9th September 2009.

[Created By] = 'John Doe'

Exports list items that have been created by 'John Doe'

[Created] >= #09/01/2010# AND [Created] <= #09/30/2010# 

Assuming the date specified by the user is in MM/DD/YYYY format, SPListX exports list items created in the month of September 2010.

[Content Type] = 'Document'

Exports list items that have content type as 'Document'

[Modified By] = 'John Doe'

Exports list items that have been modified by 'John Doe'

  

The following section describes the data types supported by SharePoint and an example of how to state the export condition.

SharePoint Data Type

Example

Description

Yes/No

[Document Verified] = 'Yes'

SPListX exports list items that have the 'Document Verified' value set to 'Yes'.

Text

[Title] <> 'Research'

SPListX exports only list items that do not have 'Research' as value for 'Title' field.

Date and Time

[Created] >= #09/01/2010# AND [Created] <= #09/30/2010#

Assuming date specified by the user is in MM/DD/YYYY format, SPListX exports list items created in the month of September 2010.

Number

[Product ID] > 10 OR
[Product ID] <=100

SPListX exports list items that have 'Product ID' value lies in between 10 to 100.

Currency

[Product Cost] = 100

SPListX exports list items that have 'Product Cost' value equal to 100.

Choice

[City] = 'New York'

[City] = 'London;Paris;Singapore'

Text or Number values can be given for this field. The values can be single or multiple. Multiple values should be separated by ';'.

SPListX exports the list items that have 'City' column value set as 'London’, ‘Paris’ and 'Singapore’.

Lookup

[Product Code] = 100

[Product Code] = 123ABC;154XYZ

The values can be single or multiple. Multiple values should be separated by ';'.

SPListX exports the list items that have '123ABC' and '154XYZ' as value for 'Product Code' field.

People or Group

[Document Reviewed by] ='John Doe'

[Document Reviewed by] ='John Doe; Jane Doe'

User or group values can be given for this field. The values can be single or multiple. Multiple values should be separated by ';'.

SPListX exports the list items that have 'Document Reviewed by' value set to 'John Doe' and 'Jane Doe'.

Incremental export in SPListX

Apart from relational operators, SPListX allows you to construct flexible export conditions by using the Changed operator for periodic import for the fields 'Created Date (SharePoint)' and 'Modified Date (SharePoint)'. The following built-in values can be used for this operator:

Today, Yesterday, This Week, This Month, Last Week, Last Month, Since Last Export in SPListX, Last 7 days and Last 14 days.

By using Changed operator, you can filter the list items based on the above mentioned values from SharePoint list.

For example, if you need to migrate list items that are modified in SharePoint today, you can specify a export condition as stated below:

[Modified] Changed [Today]

  

Operator & Value

Description

An Example

Result / Remarks

Changed Today

Exports list items that are created or modified in the present day (at the time of export) in SharePoint.

[Modified] Changed [Today]

SPListX compares the source list item modified date value with the current day (at the time of export) and exports the list items which are modified on the current day.

Changed Yesterday

Exports list items that are created or modified yesterday (at the time of export) in SharePoint.

[Created]
Changed [Yesterday]

SPListX compares the source list item created date value with yesterday (day before at the time of export) and migrates the matching list items.

Changed This Week

Exports list items that are created or modified in the current week.

[Modified] Changed [This Week]

SPListX checks the source list item's modified date value and exports the items that are changed in the current week.

Changed This Month

Exports list items that are created or modified in the current month.

[Modified] Changed [This Month]

SPListX checks the source list item's modified date value and exports the items that are changed in the current month.

Changed Last Week

Exports list items that are created or modified in the last week.

[Created] Changed [Last Week]

SPListX checks the source list item's created date value and exports those items that are changed in last (previous) week.

Changed Last Month

Exports the list items that are created or modified in the last month.

[Modified] Changed [Last Month]

SPListX checks the source list item's modified date value and exports those items that are changed in last (previous) month.

Changed Since Last Export in SPListX

Exports list items that are modified in the source folder, since the last export using SPListX. It is based on the last 'Export date and time' value internally maintained for the list item in SPListX.

[Modified] Changed [Since Last Export in SPListX]

SPListX compares the source list item's modified date value with list item's last export date and time maintained by the application and proceeds with the export accordingly.

Changed Last 7 days

Exports list items that are created or modified in the last 7 days.

[Modified] Changed [Last 7 days]

SPListX checks the source list item's modified date value and exports the items that are changed in the last 7 days.

Changed Last 14 days

Exports list items that are created or modified in the last 14 days.

[Modified] Changed [Last 14 days]

SPListX checks the source list item's modified date value and exports the items that are changed in the last 14 days.