Examples

XPlica migrates folders & files / list items along with metadata to the destination SharePoint location based on migration conditions defined in the migration task. Migration conditions can be constructed using metadata columns and their values.

A few examples of list conditions are as follows:

Migration Condition

Description

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

Migrates 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'

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

[List Type] = 'Document Library'

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

[Base Type] <> 'Document Library'

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

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

Migration Condition

Description

[Modified Date] > '09/09/2009' 

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

[Created By] = 'John Doe'

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

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

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

[Content Type] = 'Document'

Migrates list items that have content type as 'Document'

[Modified By] = 'John Doe'

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

[Item Relative Base URL] = '/My Folder'

Migrates list items that has relative URL as 'My Folder'


 

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

SharePoint Data Type

Example

Description

Yes/No

[Document Verified] = 'Yes'

XPlica migrates list items that have the 'Document Verified' value set to 'Yes'.

Text

[Title] <> 'Research'

XPlica migrates only list items that do not have 'Research' as value for 'Title' field.

Date and Time

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

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

Number

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

XPlica migrates list items that have 'Product ID' value lies in between 10 to 100.

Currency

[Product Cost] = 100

XPlica migrates 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 ';'.

XPlica migrates 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 ';'.

XPlica migrates 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 ';'.

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

A Handy Operator

Apart from relational operators, XPlica allows you to construct flexible migration conditions by using the Changed operator for periodic migration of the date fields, namely, '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 Update in SharePoint, Since Last Migrate in XPlica, 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 migration condition as stated below:

[Modified Date] Changed [Today]

 

Operator & Value

Description

An Example

Result / Remarks

Changed Today

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

[Modified Date] Changed [Today]

XPlica compares the source list item's modified date value with the current day (at the time of migration) and migrates the list items which are modified on the current day.

Changed Yesterday

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

[Created Date]
Changed [Yesterday]

XPlica compares the source list item's created date value with yesterday (day before at the time of migration) and migrates the matching list items.

Changed This Week

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

[Modified Date] Changed [This Week]

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

Changed This Month

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

[Modified Date] Changed [This Month]

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

Changed Last Week

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

[Created Date] Changed [Last Week]

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

Changed Last Month

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

[Modified Date] Changed [Last Month]

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

Changed Since Last Update in SharePoint

Migrates list items that are modified in the source folder, since the last migration, based on 'Last Modified Date' field value of the list item in SharePoint.

[Modified Date] Changed [Since Last Update in SharePoint]

XPlica compares the source list item's modified date value with list item's modified date value in SharePoint and proceeds with the migration accordingly.

Changed Since Last Migrated in XPlica

Migrates list items that are modified in the source folder, since the last migration using XPlica. It is based on the last 'Import date and time' value internally maintained for the list item in XPlica.

[Modified Date] Changed [Since Last Migrate in XPlica]

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

Changed Last 7 days

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

[Modified Date] Changed [Last 7 days]

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

Changed Last 14 days

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

[Modified Date] Changed [Last 14 days]

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