Downloading all items in a SharePoint On-Prem Document Library using PowerShell

 

Use this PowerShell script to download all items in a SharePoint document library. This only works for on-prem SharePoint.

Source: https://docs.microsoft.com/en-us/answers/questions/306049/download-complete-folders-and-subfolders-in-sharep.html

1. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
2. #Runtime-Variables
3. $SiteURL = "siteurl"
4. $LibraryName ="libraryname"
5. $DownloadPath ="C:\temp"
7. #Function to Download All Files from a SharePoint Folder
8. Function Download-SPFolder($SPFolderURL, $DownloadPath)
9. {
10. Try {
11. #Get the Source SharePoint Folder
12. $SPFolder = $web.GetFolder($SPFolderURL)
13. Write-host $SPFolder
14. $DownloadPath = Join-Path $DownloadPath $SPFolder.Name
16. #Ensure the destination local folder exists!
17. If (!(Test-Path -path $DownloadPath))
18. {
19. #If it doesn't exists, Create
20. $LocalFolder = New-Item $DownloadPath -type directory
21. }
23. #Loop through each file in the folder and download it to Destination
24. ForEach ($File in $SPFolder.Files)
25. {
26. #Download the file
27. $Data = $File.OpenBinary()
28. $FilePath= Join-Path $DownloadPath $File.Name
29. [System.IO.File]::WriteAllBytes($FilePath, $data)
30. Write-host -f Green "`tDownloaded the File:"$File.ServerRelativeURL
31. }
33. #Process the Sub Folders & Recursively call the function
34. ForEach ($SubFolder in $SPFolder.SubFolders)
35. {
36. If($SubFolder.Name -ne "Forms") #Leave "Forms" Folder
37. {
38. #Call the function Recursively
39. Download-SPFolder $SubFolder $DownloadPath
40. }
41. }
42. }
43. Catch {
44. Write-host -f Red "Error Downloading Document Library:" $_.Exception.Message
45. }
46. }
48. #Main Function
49. Function Download-SPDocumentLibrary($SiteURL, $LibraryName, $DownloadPath)
50. {
51. Try {
52. #Get the Web
53. $Web = Get-SPWeb $SiteURL
55. #Delete any existing files and folders in the download location
56. If (Test-Path $DownloadPath) {Get-ChildItem -Path $DownloadPath -Recurse| ForEach-object {Remove-item -Recurse -path $_.FullName }}
58. #Get the document Library to Download
59. $Library = $Web.Lists[$LibraryName]
60. Write-host -f magenta "Downloading Document Library:" $Library.Title
62. #Call the function to download the document library
63. Download-SPFolder -SPFolderURL $Library.RootFolder.Url -DownloadPath $DownloadPath
64. Write-host -f Green "*** Download Completed ***"
65. }
66. Catch {
67. Write-host -f Red "Error Downloading Document Library:" $_.Exception.Message
68. }
69. }
71. #Call the Function to export all document libraries from a site
72. Download-SPDocumentLibrary $SiteURL $LibraryName $DownloadPath

Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.