使用 PowerShell 将 SharePoint 库文件存档到子文件夹中

要求：我们有一个大型库，其中存储了超过 20,000 个文件，文档库的根目录中没有任何子文件夹。必须将文件移动到子文件夹中以提高性能。

解决方案：我们分析了库内容，并决定根据文件的创建日期将文件移动到子文件夹中。

使用 PowerShell 将文件存档到 SharePoint 中的子文件夹

用于将文件移动到 SharePoint 文档库中的子文件夹的 PowerShell 脚本：

#Import PowerShell Snap-in
Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue

#Create a custom function to archive files
Function Archive-Files($WebURL, $ListName)
{
 #Get the web and List
 $Web = Get-SPWeb $WebURL
 $List= $web.Lists[$ListName]

 $RootItems = $List.RootFolder.files 
 Write-host "Total number of files found in the Root: "$RootItems.count

 #Move each file in the root folder to archive folder
 foreach($item in $RootItems)
 {
   #Get the File
   $file = $Web.GetFile($item.URL)

   #Get the Month & Year values from the File's crated date
   $MonthYearValue = $file.TimeCreated.ToString('MMM-yyyy')
   
   # Try to Get the Archive Sub-Folder in the target Library
   $TargetFolder = $List.ParentWeb.GetFolder($List.RootFolder.Url + "/" +$MonthYearValue);
   
   #If the Archive folder doesn't exist, Create it!
   if ($TargetFolder.Exists -eq $false)
    {
       $TargetFolder = $List.Folders.Add("", [Microsoft.SharePoint.SPFileSystemObjectType]::Folder, $MonthYearValue)
       $TargetFolder.Update() 
    }
    #Move the File
    $file.MoveTo($TargetFolder.Url + "/" + $File.name)  
  }
}

#Call the function to Archive Files
Archive-Files "https://sharepoint.crescent.com/sites/marketing/" "Invocies"

顺便说一句，这个脚本保留了元数据！您还可以将文件移动到另一个 SharePoint 库的子文件夹中进行存档。

使用 PowerShell 将列表项移动到子文件夹：

在另一种情况下，我必须将列表项移至子文件夹。这是脚本：

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue 

#Variables
$WebURL = "https://portal.crescent.com/News/"
$ListName ="News List"

#Get site object
$Web = Get-SPWeb $WebURL
$List = $Web.Lists[$ListName]
$TargetFolder = $Web.ServerRelativeUrl + "/" + $List.RootFolder.Url + "/"+ "2014/Jan"

#Get all Files Created specific time frame
$Query = '<Where><And><Geq><FieldRef Name="Date" /><Value Type="DateTime">2014-01-01T00:00:00Z</Value></Geq><Leq><FieldRef Name="Date" /><Value Type="DateTime">2014-01-31T00:00:00Z</Value> </Leq> </And> </Where>'
$SPQuery = new-object Microsoft.SharePoint.SPQuery
$SPQuery.ViewAttributes = "Scope='Recursive'" #To include Sub-folders in the library
$SPQuery.Query = $Query
$ItemCollection =$List.GetItems($SPQuery)

Foreach($Item in $ItemCollection)
{
    $File=$Web.GetFile($Item.URL)
    $TargetPath=$TargetFolder+"/"+$Item.ID.ToString()+"_.000"
    $File.MoveTo($TargetPath)
    write-host "Moved Item:"$Item.ID
}

Write-host "Total Items Moved:"$ItemCollection.count