Using Powershell to add a file from a shared drive to a SharePoint Document Library

One of our older systems was outputting reports to a shared folder on our network, we needed an automated way to grab the file and add it to a SharePoint Document Library. So time to break out the Powershell ISE and see if we can do this with out breaking a sweat. First make sure the service account has access to both the network share and the SharePoint Document Library, otherwise you will spend a bit of time trying to troubleshoot your script. The script is pretty well commented so no need to further explain.

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } CLS #defines the site where the document library resides $url = "http://sp2010/sites/reports" ## The name of the Document Library we want to work with $lib = "System Reports Library" ## Here we define the directory where the file is located $source = "\\networkshare\folder\folder" ## Load the site $web = Get-SPWeb $url ## Load the Document Library $doclib = $web.Lists[$lib] ## Define the folder's name into a variable $folder = $doclib.RootFolder ## Select the file using a filter that gets the last item added to the source direcotry $files = ([System.IO.DirectoryInfo](Get-Item $source)).GetFiles() | Select-Object -last 1 ## Using the .NET framework we get the file from the source location $fs = ([System.IO.FileInfo] (Get-Item $file.FullName)).OpenRead() ## Set the File To Move name $ftm = $file.name write-host "Copying file " $file.name " to " $folder ## Add the file we just picked up from the source to our Document Library $spFile = $folder.Files.Add($ftm, [System.IO.Stream]$fs, $true) write-host "Success" ## Close the file stream we used to get the file $fs.Close() $web.Dispose()