powershell script to move files from doc lib to doc set witin the same lib

Question

Need to find out the document set name from a field name called "Region". I need to set the doc set name to be whatever Region is (NW, SW, NE, SE, etc.) and move files from root of the document library to it's respected doc set. I dont mind hard coding the site or web url and doc lib url.

#Setup default variables
$webUrl = Get-SPWeb -Identity "http://CiscoIntranet/sites/VOIP"
$list = $webUrl.GetList("http://CiscoIntranet/sites/VOIP/ForwardTech")
[System.Reflection.Assembly]::LoadWithPartialName(”Microsoft.SharePoint”) 

function ProcessMove {
   param($folderUrl)
   $folder = $web.GetFolder($folderUrl)
        foreach ($file in $folder.Files)
            {   
                $docset=$($file.Title);
                $destinationFolderUrl = "http://http://CiscoIntranet/sites/VOIP/ForwardTech/" + $docset;
                $list.Items.MoveTo($destinationFolderUrl, true);
                $webUrl.Update();
            }
}

Answer 1

The entirety of the SharePoint object model is available in Powershell so if you can do it in C# then you can almost certainly do it in Powershell. The question is simply the syntax to get there. I can get you started but you will have to flesh out the logic on your own based on what you are using as data sources.

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
[Microsoft.SharePoint.SPSite]$site = [Microsoft.SharePoint.SPSite]("http://SiteUrl/")

function MoveFile([Microsoft.SharePoint.SPWeb]$web, [string]$sourceUrl, [Microsoft.Office.DocumentManagement.DocumentSets.DocumentSet]$docSet, [Microsoft.SharePoint.SPFile]$results)
{  
    [Microsoft.SharePoint.SPFile]$file = $web.GetFile($sourceUrl);
    [string]$destinationFolderUrl = $docSet.Folder.Url;
    if ($destinationFolderUrl.EndsWith("/") -eq $false) { $destinationFolderUrl += "/" }
    $file.MoveTo($destinationFolderUrl + $file.Name, $true); 
    $web.Update();    
    $results = $web.GetFile($web.Url + "/" + $destinationFolderUrl + $file.Name);
}

#get a handle to the parentweb
[Microsoft.SharePoint.SPWeb]$parentWeb = $site.OpenWeb("webUrl")

# put logic here to iterate through files, csv or array - whatever the source is... 

[Microsoft.Office.DocumentManagement.DocumentSets.DocumentSet]$destDocSet
#open the document set from the source

[Microsoft.SharePoint.SPFile] $movedFile

MoveFile $parentWeb, $url, $destDocSet, $moveFile

# do something with $moveFile...

#finish looping

#clean up the objects opened
$parentWeb.Dispose()
$site.Dispose()

Answer 2

This is the working code...

$siteURL="http://CiscoIntranet/sites/VOIP"
$docLib = "ForwardTech"
$site=Get-SPSite $siteURL
$web=$site.RootWeb
$collFiles=$web.GetFolder($docLib).Files
$count=$collFiles.Count
while($count -ne 0)
{
$item = $collFiles[$count-1].Item
$DocSet = $item["Region"]
Write-Host "$DocSet is the doc set. $collFiles[$count-1].Name is name"
$collFiles[$count-1].MoveTo($siteURL + "/" + $docLib + "/" + $DocSet + "/"  + $collFiles[$count-1].Name, $true)                       
$count--
}