How to retrive items path in CSV file using powershell

Question

I have Following PowerShell Script which downloads documents from document library with folders to a local drive. it also downloads metadata of each document in CSV file. How do I copy the folder path of each document in same CSV file?

if((Get-PSSnapin "Microsoft.SharePoint.PowerShell") -eq $null) { Add-PSSnapin Microsoft.SharePoint.PowerShell } $destination = "C:\\FolderName\\" $web = Get-SPWeb -Identity "http://XYZ:2010/" $list = $web.GetList("http://XYZ:2010/Shared Documents/") function ProcessFolder { param($folderUrl) $folder = $web.GetFolder($folderUrl) foreach ($file in $folder.Files) { #Ensure destination directory $destinationfolder = $destination + "/" + $folder.Url if (!(Test-Path -path $destinationfolder)) { $dest = New-Item $destinationfolder -type directory } #Download file $binary = $file.OpenBinary() $stream = New-Object System.IO.FileStream($destinationfolder + "/" + $file.Name), Create $writer = New-Object System.IO.BinaryWriter($stream) $writer.write($binary) $writer.Close() } } $exportlist = @() $list.Items | foreach { $obj = New-Object PSObject -Property @{ "Title" = $_["Title"] "Name" = $_["Name"] "Modified Date" = $_["Modified"] "Modified By" =$_["Modified By"] "Size"= $_["File Size"] } $exportlist += $obj $exportlist | Export-Csv -path 'C:\FolderName\MyList.csv' -noType } #Download root files ProcessFolder($list.RootFolder.Url) #Download files in folders foreach ($folder in $list.Folders) { ProcessFolder($folder.Url) } #DownloadMetadata ($list.RootFolder.Url) 

Answer 1

Try SPListItem.File.Url to get the the relative url of the file. And SPWeb.Url to get the url of the web and combine them together. In your code use:

"Path" = $web.Url + "/" + $_.File.Url 

The code may look something like this. Note: I have not tested it. But it will give you an idea how to go with your scenario:

if((Get-PSSnapin "Microsoft.SharePoint.PowerShell") -eq $null) { Add-PSSnapin Microsoft.SharePoint.PowerShell } $destination = "C:\\FolderName\\" $web = Get-SPWeb -Identity "http://XYZ:2010/" $list = $web.GetList("http://XYZ:2010/Shared Documents/") $exportlist = @() function ProcessFolder { param($folderUrl) $folder = $web.GetFolder($folderUrl) foreach ($file in $folder.Files) { $item = $file.ListItem #Ensure destination directory $destinationfolder = $destination + "/" + $folder.Url if (!(Test-Path -path $destinationfolder)) { $dest = New-Item $destinationfolder -type directory } #Download file $binary = $file.OpenBinary() $stream = New-Object System.IO.FileStream($destinationfolder + "/" + $file.Name), Create $writer = New-Object System.IO.BinaryWriter($stream) $writer.write($binary) $writer.Close() $obj = New-Object PSObject -Property @{ "Title" = $item["Title"] "Name" = $item["Name"] "Modified Date" = $item["Modified"] "Modified By" =$item["Modified By"] "Size"= $item["File Size"] } } $exportlist += $obj $exportlist | Export-Csv -path 'C:\FolderName\MyList.csv' -noType } #Download root files ProcessFolder($list.RootFolder.Url) #Download files in folders foreach ($folder in $list.Folders) { ProcessFolder($folder.Url) } #DownloadMetadata ($list.RootFolder.Url)