Creating files in Document library in SharePoint 2010 using Powershell

Question

I am using below script to copy files from one library to another:

$SourceWebURL = "http://sitecollection/sites/site" 
$SourceLibraryTitle = "doclib" 
$DestinationWebURL = "http://sitecollection/sites/site" 
$DestinationLibraryTitle = "doclib" 
$ssite = Get-SPSite $SourceWebURL
$sweb = $ssite.OpenWeb("subsite")
$dsite = Get-SPSite $DestinationWebURL 
$dweb = $dsite.OpenWeb("Archivesubsite")
$sList = $sWeb.Lists | ? {$_.Title -eq $SourceLibraryTitle} 
$dList = $dWeb.Lists | ? {$_.title -like $DestinationLibraryTitle} 
$AllFolders = $sList.Folders 
$RootFolder = $sList.RootFolder 
$RootItems = $RootFolder.files 

foreach($Folder in $AllFolders)
{
echo $Folder.url
    foreach($Item in $Folder)
    {
        $sBytes = $RootItem.OpenBinary() 
            $dFile  = $dList.RootFolder.Files.Add($Item.Name, $sBytes, $true) 
        $dFile.Update() 
    }
}

I want to loop in each folder in doclib and create the files in folders in destination library. Error I am getting is : You cannot called a method on null valued expression.

UPDATED after Nadeem's comment:

$AllFolders = $sList.Folders foreach($Folder in $AllFolders) { foreach($file in $Folder.Folder.Files) { write-Host "Hello" $sBytes = $file.OpenBinary() $dFolder = $dlist.ParentWeb.GetFolder($dWeb.Url + "/" + $dList.RootFolder.Url + "/" + $Folder.Name) $dFile = $dFolder.Files.Add($dFolder.Url + "/" + $file.Name, $sBytes, $true)
} } $dList.Update()

Answer 1

There are few things to consider here. As is clear, you want to copy the documents from Source library to destination library and also preserve the folder structure. Documents can reside directly inside the source library at the root location. This folder is called Root Folder in SharePoint and it can be retrieved using $RootFolder = $sList.RootFolder. Documents can also reside inside actual folders. These folders can be retrieved using $AllFolders = $sList.Folders. Here is a way to copy the documents from all the folders except root folder of the source library to the root folder in destination library. Note that, ideally you will need to create a folder structure first before adding the file in it. However, I have already answered that question

$web = Get-SPWeb -Identity http://aissp2013/sites/Team          
$sList = $web.Lists["Doc1"]
$dList = $web.Lists["DOC2"]
$AllFolders = $sList.Folders 
foreach($Folder in $AllFolders)
{
    foreach($file in $Folder.Folder.Files)
    {
        write-Host "Hello"
        $sBytes = $file.OpenBinary() 
        $dFile  = $dList.RootFolder.Files.Add($dList.RootFolder.Url + "/" + $file.Name, $sBytes, $true)         
    }
}
$dList.Update()