{"id":348,"date":"2016-01-26T07:16:55","date_gmt":"2016-01-26T07:16:55","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=348"},"modified":"2024-05-07T07:04:32","modified_gmt":"2024-05-07T07:04:32","slug":"how-to-migrate-documents-into-sharepoint","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/how-to-migrate-documents-into-sharepoint\/","title":{"rendered":"How To Migrate Documents Into SharePoint"},"content":{"rendered":"<p>Getting documents into SharePoint<\/p>\n<p>There are many ways to get documents into SharePoint. This article covers a range of approaches aside from basic file<br \/>\nupload. Let\u2019s first take a quick review of SharePoint&#8217;s general file upload limitations:<\/p>\n<ul>\n<li><strong>Zero-length files<\/strong>\u00a0Files such as shortcuts cannot be imported<\/li>\n<li><strong>Too large files:<\/strong>\u00a0Depending on the configured limit, files that are larger than the limit will<br \/>\nnot be uploaded<\/li>\n<li><strong>Filetypes<\/strong>\u00a0Some filetypes are blocked by default. This can be for good reasoning. Executables<br \/>\nand scripts are dangerous to upload, either easily running on user desks or containing malware.<\/li>\n<li><strong>Invalid filename characters<\/strong>\u00a0Unsupported characters include: ~, #, %, &amp; , *, {, }, \\, :,<br \/>\n&lt;, &gt;, ?, \/, |<\/li>\n<li><strong>Trailing periods:<\/strong>\u00a0A filename cannot have a trailing period<\/li>\n<li><strong>Leading or trailing spaces:<\/strong> A filename cannot start or end with a blank. Often, the upload will<br \/>\nwork with trailing blanks, but the blank may be truncated<\/li>\n<li><strong>Long filenames:<\/strong>\u00a0The full URL cannot exceed somewhere around 230 characters. Adding in the web<br \/>\napplication, site, library, and any number of folders, it\u2019s not too hard to hit this limit.<\/li>\n<\/ul>\n<div style=\"display: flex; flex-wrap: wrap;\">\n<div style=\"width: 50%; border-bottom: 1px solid #000; height: fit-content;\">\n<div style=\"display: flex; align-items: center;\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-371\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Document-Compliance-svg.png\" alt=\"img\" width=\"70\" height=\"70\" \/><img \/><\/p>\n<h4><\/h4>\n<p><img \/><\/p>\n<h4>\u00a0 Drag and Drop<\/h4>\n<p>&nbsp;<\/p>\n<\/div>\n<div>\n<p class=\"elementor-image-box-description\">SharePoint 2013 supports drag-and-drop into SharePoint. Some<br \/>\nlimitations to consider<\/p>\n<ul class=\"cus--ul\">\n<li>Only 100 documents at a time<\/li>\n<li>Filenames can only contain valid characters<\/li>\n<li>Unless default metadata is configured, this approach does not support tagging.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div style=\"width: 50%; border-bottom: 1px solid #000; height: fit-content;\">\n<div style=\"display: flex; align-items: center;\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-409\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Document-Generation-svg.png\" alt=\"Explorer Mode Icon\" width=\"70\" height=\"70\" \/><img \/><\/p>\n<h4><\/h4>\n<p><img \/><\/p>\n<h4>\u00a0 Explorer Mode<\/h4>\n<p>&nbsp;<\/p>\n<\/div>\n<div>\n<p>This is also known as WebDav. In the ribbon under the \u201cLibrary\u201d tab, there should be an \u201cOpen with Explorer\u201d option. This supports folders and many documents. Limitations include poor handling for errors on upload.<\/p>\n<\/div>\n<\/div>\n<div style=\"width: 50%; border-bottom: 1px solid #000; height: fit-content;\">\n<div style=\"display: flex; align-items: center;\">\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-402\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/MS-Project-Server-svg-150x150.jpg\" alt=\"OneDrive Icon\" width=\"70\" height=\"70\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/MS-Project-Server-svg-150x150.jpg 150w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/MS-Project-Server-svg.jpg 300w\" sizes=\"auto, (max-width: 70px) 100vw, 70px\" \/><img \/><\/p>\n<h4><\/h4>\n<p><img \/><\/p>\n<h4>\u00a0 Onedrive for Business<\/h4>\n<\/div>\n<div class=\"elementor-element elementor-element-affb70a elementor-position-left cus--box elementor-vertical-align-top elementor-widget elementor-widget-image-box\" data-id=\"affb70a\" data-element_type=\"widget\" data-widget_type=\"image-box.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-image-box-wrapper\">\n<div class=\"elementor-image-box-content\">\n<p class=\"elementor-image-box-description\">If Sync is selected in the library, documents uploaded to OneDrive can be easily synced with a library.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"elementor-element elementor-element-35e7453 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"35e7453\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n<div class=\"elementor-widget-container\">\n<div class=\"elementor-divider\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"width: 50%; border-bottom: 1px solid #000; height: fit-content;\">\n<div style=\"display: flex; align-items: center;\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-406\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Migration-from-Documentum-svg-1.jpg\" alt=\"Scripting Icon\" width=\"70\" height=\"70\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Migration-from-Documentum-svg-1.jpg 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Migration-from-Documentum-svg-1-150x150.jpg 150w\" sizes=\"auto, (max-width: 70px) 100vw, 70px\" \/><img \/><\/p>\n<h4><\/h4>\n<p><img \/><\/p>\n<h4>\u00a0 Scripting<\/h4>\n<p>&nbsp;<\/p>\n<\/div>\n<div>\n<p class=\"elementor-image-box-description\">Using PowerShell, file migration can be scripted. I\u2019ve created scripts that:<\/p>\n<ul class=\"cus--ul\">\n<li>Consolidate multiple versions into a single document with versions<\/li>\n<li>Preserving of authorship and timestamp<\/li>\n<li>Detailed output looking as a CSV<\/li>\n<li>Delta migration of only files meeting specific date or other criteria<\/li>\n<li>Using custom business logic to map to Sites, libraries, content types, folders, and document sets<\/li>\n<li>Fixing of filenames to avoid illegal filename errors<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div style=\"width: 50%; border-bottom: 1px solid #000; height: fit-content;\">\n<div style=\"display: flex; align-items: center;\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-396\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Tools-svg.jpg\" alt=\"Tool Icon\" width=\"70\" height=\"70\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Tools-svg.jpg 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Tools-svg-150x150.jpg 150w\" sizes=\"auto, (max-width: 70px) 100vw, 70px\" \/><img \/><\/p>\n<h4><\/h4>\n<p><img \/><\/p>\n<h4>Migration Tools<\/h4>\n<\/div>\n<p>A range of document migration tools are available, such as\u00a0<a class=\"title--links\" href=\"http:\/\/www.metalogix.com\/Products\/Content-Matrix.aspx\" target=\"_blank\" rel=\"noopener\" aria-label=\"Metalogix Content Matrix, - open in a new tab\" data-uw-rm-ext-link=\"\">Metalogix Content Matrix,<\/a><a class=\"title--links\" href=\"http:\/\/en.share-gate.com\/\" target=\"_blank\" rel=\"noopener\" aria-label=\"Share-Gate, - open in a new tab\" data-uw-rm-ext-link=\"\">\u00a0Share-Gate,\u00a0<\/a><a class=\"title--links\" href=\"http:\/\/www.avepoint.com\/products\/sharepoint-infrastructure-management\/sharepoint-migration\/\" target=\"_blank\" rel=\"noopener\" aria-label=\"AvePoint DocAve, - open in a new tab\" data-uw-rm-ext-link=\"\">AvePoint DocAve,\u00a0<\/a><a class=\"title--links\" href=\"https:\/\/tzunami.com\/\" target=\"_blank\" rel=\"noopener\" aria-label=\"Tzunami - open in a new tab\" data-uw-rm-ext-link=\"\">Tzunami, <\/a>and Lightning Tools.<\/p>\n<div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Getting documents into SharePoint There are many ways to get documents into SharePoint. This article covers a range of approaches aside from basic file upload. Let\u2019s first take a quick review of SharePoint&#8217;s general file upload limitations: Zero-length files\u00a0Files such as shortcuts cannot be imported Too large files:\u00a0Depending on the configured limit, files that are [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":353,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[25],"tags":[],"class_list":["post-348","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-architecture"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=348"}],"version-history":[{"count":22,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/348\/revisions"}],"predecessor-version":[{"id":3766,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/348\/revisions\/3766"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/353"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}