Try these
For export
function Get-FolderPath {
<#
.SYNOPSIS
Returns the folderpath for a folder
.DESCRIPTION
The function will return the complete folderpath for
a given folder, optionally with the "hidden" folders
included. The function also indicats if it is a "blue"
or "yellow" folder.
.NOTES
Authors: Luc Dekens
.PARAMETER Folder
On or more folders
.PARAMETER ShowHidden
Switch to specify if "hidden" folders should be included
in the returned path. The default is $false.
.EXAMPLE
PS> Get-FolderPath -Folder (Get-Folder -Name "MyFolder")
.EXAMPLE
PS> Get-Folder | Get-FolderPath -ShowHidden:$true
#>
param(
[parameter(valuefrompipeline = $true,
position = 0,
HelpMessage = "Enter a folder")]
[VMware.VimAutomation.ViCore.Impl.V1.Inventory.FolderImpl[]]$Folder,
[switch]$ShowHidden = $true
)
begin {
$excludedNames = "Datacenters", "vm", "host"
}
process {
$Folder | ForEach-Object {
$fld = $_.Extensiondata
$fldType = "yellow"
if ($fld.ChildType -contains "Network") {
$fldType = "blue"
}
$path = $fld.Name
while ($fld.Parent) {
$fld = Get-View $fld.Parent
if ((!$ShowHidden -and $excludedNames -notcontains $fld.Name) -or $ShowHidden) {
$path = $fld.Name + "\" + $path
}
}
$row = "" | Select-Object Name, Path, Type
$row.Name = $_.Name
$row.Path = $path
$row.Type = $fldType
$row
}
}
}
$hidden = 'Datacenters','host','vm','network','datastore','vCLS'
Get-Folder | where{$_.Name -notin $hidden} |
Select @{N='Path';E={(Get-FolderPath -Folder $_).Path}} |
Export-Csv -Path .\export-folder.csv -NoTypeInformation -UseCulture
For import
Import-Csv -Path .\export-folder.csv -UseCulture -PipelineVariable row |
ForEach-Object -Process {
$root,$dcName,$path = $row.Path.Split('\',3)
$location = Get-Datacenter -Name $dcName
$path.Split('\') | ForEach-Object -Process {
$name = $_
try{
$location = Get-Folder -Name $_ -Location $location -ErrorAction Stop
}
catch{
New-Folder -Name $name -Location $location
}
}
}
