{"id":854,"date":"2018-07-17T11:08:52","date_gmt":"2018-07-17T11:08:52","guid":{"rendered":"https:\/\/www.mozesoft.com\/blog\/?p=854"},"modified":"2019-05-21T11:38:15","modified_gmt":"2019-05-21T11:38:15","slug":"migrate-sharepoint-list-items-documents-with-metadata-and-version-history","status":"publish","type":"post","link":"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/","title":{"rendered":"Migrate SharePoint list items\/documents with metadata and version history"},"content":{"rendered":"\n

In this blog we discuss how to move\/migrate document\/files from one location to another whilst preserving its metadata properties and version history<\/strong>.<\/p>\n\n\n\n

Follow the below methods to move files while maintaining all metadata properties and version history:<\/p>\n\n\n\n

Method 1: Using Content and Structure to move files with version<\/strong>s and Metadata<\/strong><\/p>\n\n\n\n

  1. First select the documents you want to move\/migrate.<\/li>
  2. Then Go to Site Actions -> Site settings -> click on \u201cContent and structure\u201d under the Site Administration.<\/li>
  3. After that open the SharePoint data library and then select the items that you want to move.<\/li>
  4. Then you see the Move dialog box to specify the destination, you \nneed to select the destination document library and then click OK.<\/li>
  5. After this, you can see the documents in the destination document library.<\/li><\/ol>\n\n\n\n

    Method 2: Programmatically \u2013 move document with version history<\/strong><\/p>\n\n\n\n

    Using PowerShell to maintain file version history when moving\/copying files between SharePoint sites<\/strong><\/p>\n\n\n\n

    SPFile fileSource = itmSource.File;<\/em>
    \n\/*Here we\u2019ll get the created by and created on values from the source document.*\/<\/em>
    \nSPUser userCreatedBy = fileSource.Author;<\/em>
    \n\/*Note we need to convert the \u201cTimeCreated\u201d property to local time as it\u2019s stored in the database as GMT.*\/
    \nDateTime dateCreatedOn = fileSource.TimeCreated.ToLocalTime();<\/em>
    \n\/\/Get the versions<\/em>
    \nint countVersions = itmSource.File.Versions.Count;<\/em>
    \n\/*This is a zero based array and so normally you\u2019d use the < not \n<= but we need to get the current version too which is not in the \nSPFileVersionCollection so we\u2019re going to count one higher to accomplish\n that.*\/<\/em>
    \nfor (int i = 0; i <= countVersions; i++)<\/em>
    \n{<\/em>
    \n     Hashtable hashSourceProp;<\/em>
    \n     Stream streamFile;<\/em>
    \n     SPUser userModifiedBy;<\/em>
    \n     DateTime dateModifiedOn;<\/em>
    \n     string strVerComment = \u201c\u201d;<\/em>
    \n     bool bolMajorVer = false;<\/em>
    \n     if (i < countVersions)<\/em>
    \n     {<\/em>
    \n\/*This section captures all the versions of the document and gathers\n the properties we need to add to the SPFileCollection.  Note we\u2019re \ngetting the modified information and the comments <\/em>seperately as\n well as checking if the version is a major version (more on that \nlater).  I\u2019m also getting a stream object to the file which is more \nefficient than getting a byte array for large files but you could \nobviously do that as well.  Again note I\u2019m converting the created time \nto local time.*\/<\/em>
    \n          SPFileVersion fileSourceVer = itmSource.File.Versions[i];<\/em>
    \n          hashSourceProp = fileSourceVer.Properties;<\/em>
    \n          userModifiedBy = (i == 0) ? userCreatedBy: fileSourceVer.CreatedBy;<\/em>
    \n          dateModifiedOn = fileSourceVer.Created.ToLocalTime();<\/em>
    \n          strVerComment = fileSourceVer.CheckInComment;<\/em>
    \n          bolMajorVer = fileSourceVer.VersionLabel.EndsWith(\u201c0\u201d) ? true : false;<\/em>
    \n          streamFile = fileSourceVer.OpenBinaryStream();<\/em>
    \n     }<\/em>
    \n     else<\/em>
    \n     {<\/em>
    \n\/*Here I\u2019m getting the information for the current version.  Unlike \nin SPFileVersion when I get the modified date from SPFile it\u2019s already \nin local time.*\/<\/em>
    \n          userModifiedBy = fileSource.ModifiedBy;<\/em>
    \n          dateModifiedOn = fileSource.TimeLastModified;<\/em>
    \n          hashSourceProp = fileSource.Properties;<\/em>
    \n          strVerComment = fileSource.CheckInComment;<\/em>
    \n          bolMajorVer = fileSource.MinorVersion == 0 ? true : false;<\/em>
    \n          streamFile = fileSource.OpenBinaryStream();<\/em>
    \n     }<\/em>
    \n     string urlDestFile = libDest.RootFolder.Url + \u201c\/\u201d + fileSource.Name;<\/em>
    \n\/*Here I\u2019m using the overloaded Add method to add the file to the \nSPFileCollection.  Even though this overload takes the created and \nmodified dates for some reason they aren\u2019t visible in the SharePoint UI \nversion history which shows the date\/time the file was added instead, \nhowever if this were a Microsoft Word document and I opened it in Word \n2010 and looked at the version history it would all be reflective of the\n values passed to this Add method.  I\u2019m voting for defect but there \ncould just be something I\u2019m missing.*\/<\/em>
    \n     SPFile fileDest = libDest.RootFolder.Files.Add(<\/em>
    \n                 urlDestFile, <\/em>
    \n                 streamFile, <\/em>
    \n                 hashSourceProp, <\/em>
    \n                 userCreatedBy, <\/em>
    \n                 userModifiedBy, <\/em>
    \n                 dateCreatedOn, <\/em>
    \n                 dateModifiedOn, <\/em>
    \n                 strVerComment, <\/em>
    \n                 true);<\/em>
    \n     if (bolMajorVer)<\/em>
    \n\/*Here we\u2019re checking if this is a major version and calling the \npublish method, passing in the check-in comments.  Oddly when the \npublish method is called the passed created and modified dates are \ndisplayed in the SharePoint UI properly without further adjustment.*\/<\/em>
    \n          fileDest.Publish(strVerComment);<\/em>
    \n     else<\/em>
    \n     {<\/em>
    \n\/*Setting the created and modified dates in the SPListItem which \ncorrects the display in the SharePoint UI version history for the draft \nversions.*\/<\/em>
    \n          SPListItem itmNewVersion = fileDest.Item;<\/em>
    \n          itmNewVersion[\u201cCreated\u201d] = dateCreatedOn;<\/em>
    \n          itmNewVersion[\u201cModified\u201d] = dateModifiedOn;<\/em>
    \n          itmNewVersion.UpdateOverwriteVersion();<\/em>
    \n     }<\/em>
    \n}<\/em><\/p>\n\n\n\n

    Source: http:\/\/julieturner.net\/2011\/06\/maintain-file-version-history-when-movingcopying-files-between-sharepoint-sites\/
    <\/p>\n","protected":false},"excerpt":{"rendered":"

    In this blog we discuss how to move\/migrate document\/files from one location to another whilst preserving its metadata properties and version history. Follow the below methods to move files while maintaining all metadata properties and version history: Method 1: Using Content and Structure to move files with versions and Metadata First select the documents you […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-854","post","type-post","status-publish","format-standard","hentry","category-sharepoint-server"],"yoast_head":"\nMigrate SharePoint list items\/documents with metadata and version history - Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrate SharePoint list items\/documents with metadata and version history - Blog\" \/>\n<meta property=\"og:description\" content=\"In this blog we discuss how to move\/migrate document\/files from one location to another whilst preserving its metadata properties and version history. Follow the below methods to move files while maintaining all metadata properties and version history: Method 1: Using Content and Structure to move files with versions and Metadata First select the documents you […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-17T11:08:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-21T11:38:15+00:00\" \/>\n<meta name=\"author\" content=\"Adsank\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Adsank\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/\"},\"author\":{\"name\":\"Adsank\",\"@id\":\"https:\/\/www.mozesoft.com\/blog\/#\/schema\/person\/79fc1ff8cfa9fe3f16bedffefc53359c\"},\"headline\":\"Migrate SharePoint list items\/documents with metadata and version history\",\"datePublished\":\"2018-07-17T11:08:52+00:00\",\"dateModified\":\"2019-05-21T11:38:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/\"},\"wordCount\":1050,\"articleSection\":[\"SharePoint Server\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/\",\"url\":\"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/\",\"name\":\"Migrate SharePoint list items\/documents with metadata and version history - Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.mozesoft.com\/blog\/#website\"},\"datePublished\":\"2018-07-17T11:08:52+00:00\",\"dateModified\":\"2019-05-21T11:38:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.mozesoft.com\/blog\/#\/schema\/person\/79fc1ff8cfa9fe3f16bedffefc53359c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mozesoft.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrate SharePoint list items\/documents with metadata and version history\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.mozesoft.com\/blog\/#website\",\"url\":\"https:\/\/www.mozesoft.com\/blog\/\",\"name\":\"Blog\",\"description\":\"IT Knowledgebase\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.mozesoft.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.mozesoft.com\/blog\/#\/schema\/person\/79fc1ff8cfa9fe3f16bedffefc53359c\",\"name\":\"Adsank\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mozesoft.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/16e1b860aa1c6c11b188d686f734c33318307888d91fee8cd1550025f1c788a0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/16e1b860aa1c6c11b188d686f734c33318307888d91fee8cd1550025f1c788a0?s=96&d=mm&r=g\",\"caption\":\"Adsank\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migrate SharePoint list items\/documents with metadata and version history - Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/","og_locale":"en_US","og_type":"article","og_title":"Migrate SharePoint list items\/documents with metadata and version history - Blog","og_description":"In this blog we discuss how to move\/migrate document\/files from one location to another whilst preserving its metadata properties and version history. Follow the below methods to move files while maintaining all metadata properties and version history: Method 1: Using Content and Structure to move files with versions and Metadata First select the documents you […]","og_url":"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/","og_site_name":"Blog","article_published_time":"2018-07-17T11:08:52+00:00","article_modified_time":"2019-05-21T11:38:15+00:00","author":"Adsank","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Adsank","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/#article","isPartOf":{"@id":"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/"},"author":{"name":"Adsank","@id":"https:\/\/www.mozesoft.com\/blog\/#\/schema\/person\/79fc1ff8cfa9fe3f16bedffefc53359c"},"headline":"Migrate SharePoint list items\/documents with metadata and version history","datePublished":"2018-07-17T11:08:52+00:00","dateModified":"2019-05-21T11:38:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/"},"wordCount":1050,"articleSection":["SharePoint Server"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/","url":"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/","name":"Migrate SharePoint list items\/documents with metadata and version history - Blog","isPartOf":{"@id":"https:\/\/www.mozesoft.com\/blog\/#website"},"datePublished":"2018-07-17T11:08:52+00:00","dateModified":"2019-05-21T11:38:15+00:00","author":{"@id":"https:\/\/www.mozesoft.com\/blog\/#\/schema\/person\/79fc1ff8cfa9fe3f16bedffefc53359c"},"breadcrumb":{"@id":"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.mozesoft.com\/blog\/migrate-sharepoint-list-items-documents-with-metadata-and-version-history\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mozesoft.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Migrate SharePoint list items\/documents with metadata and version history"}]},{"@type":"WebSite","@id":"https:\/\/www.mozesoft.com\/blog\/#website","url":"https:\/\/www.mozesoft.com\/blog\/","name":"Blog","description":"IT Knowledgebase","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mozesoft.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.mozesoft.com\/blog\/#\/schema\/person\/79fc1ff8cfa9fe3f16bedffefc53359c","name":"Adsank","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mozesoft.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/16e1b860aa1c6c11b188d686f734c33318307888d91fee8cd1550025f1c788a0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/16e1b860aa1c6c11b188d686f734c33318307888d91fee8cd1550025f1c788a0?s=96&d=mm&r=g","caption":"Adsank"}}]}},"_links":{"self":[{"href":"https:\/\/www.mozesoft.com\/blog\/wp-json\/wp\/v2\/posts\/854","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mozesoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mozesoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mozesoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mozesoft.com\/blog\/wp-json\/wp\/v2\/comments?post=854"}],"version-history":[{"count":1,"href":"https:\/\/www.mozesoft.com\/blog\/wp-json\/wp\/v2\/posts\/854\/revisions"}],"predecessor-version":[{"id":855,"href":"https:\/\/www.mozesoft.com\/blog\/wp-json\/wp\/v2\/posts\/854\/revisions\/855"}],"wp:attachment":[{"href":"https:\/\/www.mozesoft.com\/blog\/wp-json\/wp\/v2\/media?parent=854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mozesoft.com\/blog\/wp-json\/wp\/v2\/categories?post=854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mozesoft.com\/blog\/wp-json\/wp\/v2\/tags?post=854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}