SPDocVersion-Exporter.ps1
|
<#PSScriptInfo .VERSION 1.6 .GUID f47abff3-8d54-4a9d-bac5-a558ae0fb43a .AUTHOR Mohamed El-Qassas .COMPANYNAME debug.to .COPYRIGHT This project is licensed under the terms of the MIT license. .TAGS SharePoint,Document Library,export .LICENSEURI https://spgeeks.devoworx.com .PROJECTURI https://spgeeks.devoworx.com/export-sharepoint-version-history-to-excel/ .ICONURI .EXTERNALMODULEDEPENDENCIES Microsoft.SharePoint.PowerShell .REQUIREDSCRIPTS .EXTERNALSCRIPTDEPENDENCIES .RELEASENOTES Add export option for a particular document .PRIVATEDATA #> <# .DESCRIPTION The "SPDocVersion-Exporter" is a well-written and tested PowerShell script that helps you to easily export all document versions details for a specific SharePoint document library to Excel/CSV file. For more details about the script features and how this script works, Please check https://spgeeks.devoworx.com/export-sharepoint-version-history-to-excel/ #> Param() # Author: Mohamed El-Qassas # Blog : https://devoworx.com # Date : 04/01/2021 # Read instrcutions at https://spgeeks.devoworx.com/export-sharepoint-version-history-to-excel/ # Description: PowerShell Script to Get the Version Comments for each Document and other Version Details in SharePoint Document Library # Have a quiestion, Please ask it at https://debug.to #Add Add-PSSnapin Microsoft.SharePoint.PowerShell Set-ExecutionPolicy "Unrestricted" Add-PSSnapin "Microsoft.SharePoint.PowerShell" #Variables function Export-DocLibVersions () { param([Parameter(Mandatory=$true)][string]$siteURL,[Parameter(Mandatory=$true)][string]$DocLibName) try { #################################################################### $WebSite = $null $DocLib = $null #perfrom validation Write-Host "#####################################`n SharePoint Doc Library Versions Exporter`n#####################################" -ForegroundColor Green if((Get-SPWeb $siteURL -ErrorAction SilentlyContinue) -eq $null) { Write-Host "The provided SharePoint Site URL ($siteURL) is not found, Please, provide a valid SharePoint URL!" -ForegroundColor Red Export-DocLibVersions } else { $WebSite = Get-SPWeb $siteURL #Check if the doc lib is found $DocLib = $WebSite.Lists.TryGetList($DocLibName) if($DocLib -eq $null) { Write-host "The document library ($DocLibName) is not found! please prvoide a correct Document Library Name located at ($siteURL)" -ForegroundColor Red Export-DocLibVersions } else { #Check if the version settings is enabled to proceed If ($DocLib.EnableVersioning -eq $TRUE) { Write-host ">> The version settings is enabled for $DocLibName" -ForegroundColor Cyan #Get all documents $DocsCollection = $DocLib.Items $DocCount = $DocsCollection.Count Write-host ">> The total number of documents in ($DocLibName) is ($DocCount)" -ForegroundColor Cyan #Prepare the file Path $ReportFolderPath = "C:\SPVersions\$DocLibName\LibVersions-$((Get-Date).ToString('yyyy-MM-dd-hh-mm-ss-tt'))" $ReportFilePath = "$ReportFolderPath\versions.csv" #check the folder path if(!(Test-path $ReportFolderPath)) { New-Item -ItemType Directory -Path $ReportFolderPath } #check the Report path if(!(Test-path $ReportFilePath -PathType leaf)) { New-Item -ItemType file -Path $ReportFilePath } if($DocsCollection -ne $null) { $reply = $(write-host "Would you like to export all documents versiosn or specic document?`n[Type All to export versions for alldocument/or type the full document URL]" -ForegroundColor yellow ; Read-Host) Write-host "Start Exporting process ......." -ForegroundColor cyan if($reply -eq "All") { Write-host "The total number of documents in ($DocLibName) is ($DocCount)." -ForegroundColor Cyan #iterate for each doc in document library foreach ($Doc in $DocsCollection) { $DocName = $Doc.Name Write-host "Exporting versions for ($DocName) ......." -ForegroundColor green $Vcount = ($Doc.Versions).Count #Get the Version Count for the current document Write-host ">> Number of versions for ($DocName) is ($Vcount)" -ForegroundColor cyan $totalVersions=$Vcount #Total Versions for all documents $count= $Vcount #Set the decremental count to the Version Count #Iterate for each version in each document $docURL = $siteURL+$Doc.URL # get full document URL Add-Content -Path $ReportFilePath -Value "Doc ID,Document Name,Doc URL, Total Versions, Created By, Created Date, Modified By, Modified Date ,Size (KB)" Add-Content -Path $ReportFilePath -Value "$($Doc.id),$($DocName),$($docURL),$($Vcount),$($Doc['Author']),$($Doc['Created']),$($Doc['Editor']),$($Doc['Modified']),$($Doc.File.Length)" Add-Content -Path $ReportFilePath -Value "Version ID,Version Title, Modified By, Modified at ,Size (KB), CheckInComments" foreach($version in $Doc.Versions) { if([int]$count -eq $Vcount) { $VersionDetails = "$($version.VersionLabel),$($version['Title']), $($version.CreatedBy.User.DisplayName), $($version.Created),$($Doc.File.Versions.GetVersionFromLabel($version.VersionLabel).Size),$($version['Check In Comment'])" } else { $VersionDetails = "$($version.VersionLabel),$($version['Title']), $($version.CreatedBy.User.DisplayName), $($version.Created),$($Doc.File.Versions.GetVersionFromLabel($version.VersionLabel).Size),$($Doc.File.Versions.GetVersionFromLabel($version.VersionLabel).CheckInComment)" } # add the version details to the exported file Add-Content -Path $ReportFilePath -Value $VersionDetails $count = $count -1 #decrease version count } #Add Item Sperator Add-Content -Path $ReportFilePath -Value "---------------------------------------------------" $totalVersion = $totalVersion + $Vcount } Write-host "The versions of $DocLibName have been exported successfuly at $ReportFilePath" -ForegroundColor Green Start-Process $ReportFilePath Write-host "------------------------------------------------------" -ForegroundColor Cyan Write-host "Export Operation Summary" Write-host "------------------------------------------------------" -ForegroundColor Cyan Write-host "Site URL: $siteURL" -ForegroundColor Cyan Write-host "Site Title: $WebSite" -ForegroundColor Cyan Write-host "Document Library Name: $DocLib" -ForegroundColor Cyan Write-host "Number of Documents: $DocCount" -ForegroundColor Cyan Write-host "Number of Versions: $totalVersion" -ForegroundColor Cyan } else { $DocURL = $reply try { $Doc = $WebSite.GetListItem($DocURL) if($Doc -ne $null) { $DocName = $Doc.Name Write-host "Exporting versions for ($DocName) ......." -ForegroundColor green $Vcount = ($Doc.Versions).Count #Get the Version Count for the current document Write-host ">> Number of versions for ($DocName) is ($Vcount)" -ForegroundColor cyan $count= $Vcount #Set the decremental count to the Version Count #Iterate for each version in each document Add-Content -Path $ReportFilePath -Value "Doc ID,Document Name,Doc URL, Total Versions, Created By, Created Date, Modified By, Modified Date ,Size (KB)" Add-Content -Path $ReportFilePath -Value "$($Doc.id),$($DocName),$($DocURL),$($Vcount),$($Doc['Author']),$($Doc['Created']),$($Doc['Editor']),$($Doc['Modified']),$($Doc.File.Length)" Add-Content -Path $ReportFilePath -Value "Version ID,Version Title, Modified By, Modified at ,Size (KB), CheckInComments" foreach($version in $Doc.Versions) { if([int]$count -eq $Vcount) { $VersionDetails = "$($version.VersionLabel),$($version['Title']), $($version.CreatedBy.User.DisplayName), $($version.Created),$($Doc.File.Versions.GetVersionFromLabel($version.VersionLabel).Size),$($version['Check In Comment'])" } else { $VersionDetails = "$($version.VersionLabel),$($version['Title']), $($version.CreatedBy.User.DisplayName), $($version.Created),$($Doc.File.Versions.GetVersionFromLabel($version.VersionLabel).Size),$($Doc.File.Versions.GetVersionFromLabel($version.VersionLabel).CheckInComment)" } # add the version details to the exported file Add-Content -Path $ReportFilePath -Value $VersionDetails $count = $count -1 #decrease version count } Write-host "The versions of $DocName have been exported successfuly at $ReportFilePath" -ForegroundColor Green Start-Process $ReportFilePath Write-host "------------------------------------------------------" -ForegroundColor Cyan Write-host "Export Operation Summary" Write-host "------------------------------------------------------" -ForegroundColor Cyan Write-host "Site URL: $siteURL" -ForegroundColor Cyan Write-host "Site Title: $WebSite" -ForegroundColor Cyan Write-host "Document Library Name: $DocLib" -ForegroundColor Cyan Write-host "Document Name: $DocName" -ForegroundColor Cyan Write-host "Number of Versions: $Vcount" -ForegroundColor Cyan } } catch { Write-host "The Document URl ($reply) is not found, Please type valid document URL" -ForegroundColor Red Export-DocLibVersions } } } else { Write-host "No Documents in $DocLibName" -ForegroundColor Red } } else { Write-host "The version settings is not enabled, please enabel it first" -ForegroundColor Red Start-Sleep 5 $EnableVersioning = $siteURL+"_layouts/15/LstSetng.aspx?List="+$DocLib.ID [system.Diagnostics.Process]::Start("iexplore", $EnableVersioning) } } } } catch { Write-host $_.Exception.Message -ForegroundColor Red } } # Provide the SharePoint Site URL, and the Document Library Name Export-DocLibVersions #-siteURL "http://epm:19812/pmo/" -DocLibName "Doc Lib Get Versions Details" -Document URL http://epm:19812/pmo/Doc%20Lib%20Get%20Versions%20Details/Doc%20Lib%20Get%20Versions%20Details.txt |