Skip to main content

Save SharePoint list attachments to a folder

Here is a powershell script to save SharePoint list attachments to a folder

Add-PsSnapin Microsoft.SharePoint.PowerShell

function downloadListAttachments ( ){


    $tempLocation = $Path      
    $w = Get-SPWeb $siteURL   
    $l = $w.Lists[$listName]    
    foreach ($listItem in $l.Items)
          Write-Host "    Content: " $listItem.ID 
           $destinationfolder = $tempLocation         
           if (!(Test-Path -path $destinationfolder))        
                 $dest = New-Item $destinationfolder -type directory          
           foreach ($attachment in $listItem.Attachments)    
               $file = $w.GetFile($listItem.Attachments.UrlPrefix + $attachment)        
               $bytes = $file.OpenBinary()                
               $path = $destinationfolder + "\" + $attachment 
               Write "Saving $path" 
               $fs = New-Object System.IO.FileStream($path, "OpenOrCreate") 
               $fs.Write($bytes, 0 , $bytes.Length)    
downloadListAttachments -siteURL "https://abc" -listName "ListName" -Path "C:\Temp"

Reference :


Popular posts from this blog

SharePoint 2013 workflow : The server was unable to process the request

Here, I received another SharePoint 2013 workflow error. This time the workflow was not able to send emails and the following error was being shown Retrying last request. Next attempt scheduled in less than one minute. Details of last request: HTTP Unauthorized to http://sitename/_vti_bin/client.svc/web/lists/getbyid(guid'guid') Correlation Id: id Instance Id: id Fortunately I came across this post which gave me the answer Solution 1: In InetMgr, go to advanced settings for Security Token Service Application Pool and change "Load User Profile" to true. Recycle application pool. Reason 2 and Solution 2 : There could be another reason for this error. The workflow authentication can fail if the user executing the workflow (this will be the user initiating the workflow) is given permission through active directory group and the co

OWA not working after security update

Office web apps for SharePoint 2013 not working after security updates / server patching. After installation of the following security patches, OWA stopped working there by causing issues with SharePoint 2013. Details of ULS logs are provided below. FarmStateReplicator.exe (0x0CD8) Office Web Apps Farm State Error when trying to connect to Farm State Manager service: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http:// /farmstatemanager/FarmStateManager.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal