Skip to main content

How to move/migrate SharePoint list items/documents and preserve metadata properties at the same time

I think it’s been pretty common knowledge that you can open up a Document Library in Windows Explorer view to move mass documents to other folders or libraries. But there’s a drawback to that method because the document’s properties get updated in the process – mainly the modified date/time as well as the user would take on the role of the person that ‘Last modified’ the document. This also applies to copying list data in data sheet view from one list to another.

Some have figured out a different way where you can save the current list or Document Library as a template with content included and redeploying that to other locations. Unfortunately this method will also overwrite the last modified timestamps and also the ‘Created by’ property with the time that the list was recreated and by the person that created it, respectively.

So if you want to move the contents of a SharePoint Document Library or List and be able to preserve the item’s metadata/property values at the same time you should use this method:

1. Create a blank destination List or Document Library. You don’t have to worry about recreating custom fields and whatnot. The move process will do this for you.

2. Go to the ‘Site Content and Structure’ page. You can access this site with either Site Actions > Site Settings or http://portal/_Layouts/sitemanager.aspx



3. Navigate to your source List or Document Library and mark all the items that you would like to have moved. Then click on Actions > Move…


4. You’ll then be prompted with a pop-up that will let you navigate to your destination List or Document Library. After you find that, just press the OK button and you’ll be good to go!

So by using this method, you’ll be able to preserve all of the document properties/metadata while moving list items or documents from one location to another!

Comments

  1. This comment has been removed by a blog administrator.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to get SPUser or SPGroup from Person or Group field

You have person or group field in SharePoint list and you want to programmatically get the user or person. The below code to gets SPUser from User or Group field in the list when multiple choice and Groups are not allowed in the field: //get SPUser SPFieldUser userField = (SPFieldUser)item.Fields.GetField("Users"); SPFieldUserValue userFieldValue = (SPFieldUserValue)userField.GetFieldValue(item["Users"].ToString()); SPUser user = userFieldValue.User; This part of code would help you to get SPUser when multiple choice is allowed and groups are not allowed: //Multiple choices are allowed SPFieldUser userField = (SPFieldUser)item.Fields.GetField("Users"); SPFieldUserValueCollection userFieldValueCollection = (SPFieldUserValueCollection)userField.GetFieldValue(item["Users"].ToString()); foreach (SPFieldUserValue userFieldValue in userFieldValueCollection) {     Console.WriteLine("     " + userFieldValue.User.LoginName); } And when group...

SharePoint publishing page scheduling

In SharePoint 2010 publishing enabled team site collection is not showing schedule button in publish ribbon. Solution: Here is how to enable it  though the UI: Locate the SharePoint Server Web site on which you want to enable content approval and item scheduling. Click  Site Actions , click  Site Settings , and then click  Modify Pages Library Settings . Under  General Settings , click  Versioning Settings . Click  Yes  next to  Content Approval , and then click  OK . Click  Manage item scheduling .   Click to enable the  Enable scheduling of items in this list  check box, and then click  OK .

Changing Content Type Hub URL

Change the Hub URL through powershell by using: Set-SPMetadataServiceApplication -Identity " " -HubURI " " For Ex: Set-SPMetadataServiceApplication -Identity "Managed Metadata Service" -HubURI "http://contenttype.Domain.Com" When you try to do this you get this rather scary message: This is SharePoint telling you that this is a major thing so be careful! Essentially all your content types that you have published out will be removed if they can, and you have to republish all of your content types out again which can cause some issue.