Sorry, i'm still struggling with the OtherAttribues Hashtable....
When printing out the values, it has skipped the empty fields successfully.
Set-ADOrganizationalUnit does still deny the OtherAttributes Property with error "Invalid Type "System.Collection.Hashtable". Parameter OtherAttributes"
foreach($line in $global:SpreadSheet)
{
$collection = @{}
$otherAttributes = @{}
$adpath = $null
# filter empty other attributes
if($line.mail){
$otherAttributes.Add('mail',$line.mail)
}
if($line.lraIsBranchOffice){
$otherAttributes.Add('lraIsBranchOffice', $line.lraIsBranchOffice)
}
if($line.telephoneNumber){
$otherAttributes.Add('telephoneNumber',$line.telephoneNumber)
}
if($line.facsimileTelephoneNumber){
$otherAttributes.Add('facsimileTelephoneNumber',$line.facsimileTelephoneNumber)
}
if($line.info){
$otherAttributes.Add('info',$line.info)
}
# filter empty standard attribues
if($line.Description)
{
$collection.Add('Description',$line.Description)
}
if($line.street)
{
$collection.Add('StreetAddress',$line.street)
}
if($line.postalCode)
{
$collection.Add('PostalCode',$line.postalCode)
}
if($line.l)
{
$collection.Add('City',$line.l)
}
if($line.st)
{
$collection.Add('State',$line.st)
}
# add the other attribues hashtable to the collection
$collection.Add('OtherAttributes',$otherAttributes)
try
{
$adpath = "OU=$($line.Name),$($line.distinguishedName)"
Write-Log -Message "[Info] - Modifying Date for OU $($collection.Name) '$adpath'."
Set-ADOrganizationalUnit -Server $Server -Identity $adpath -Replace $collection
}
catch{
$ErrorMessage = $_.Exception.Message
$FailedItem = $_.Exception.ItemName
Write-Log -Message "[ERROR] - Failed writing changes to '$adpath': $ErrorMessage"
}
}
Another approach with more automatics also fails with the same error:
foreach($line in $global:SpreadSheet)
{
$collection = @{}
$otherAttributes = @{}
$adpath = $null
$tmp = @{}
$item = @{}
$otherAttributes = New-Object PSObject -Property @{ mail=$line.mail;lraIsBranchOffice=$line.lraIsBranchOffice;telephoneNumber=$line.telephoneNumber;facsimileTelephoneNumber=$line.facsimileTelephoneNumber;info=$line.info}
$collection = New-Object PSObject -Property `
@{
Description = $line.Description
StreetAddress=$line.street
PostalCode=$line.postalCode
City = $line.l
State=$line.st
}
#filter empty standard attributes
foreach ($object in $collection)
{
$object.PsObject.Properties | ?{ ($_.Value) } | %{
$item.Add($_.Name,$_.Value)
}
}
#filter empty other attributes
foreach($itm in $otherAttributes)
{
$itm.PsObject.Properties | ?{ ($_.Value) } | %{
$tmp.Add($_.Name,$_.Value)
}
}
# join the other attributes to the item hash table
$item.Add('OtherAttribues',$tmp)
try
{
$adpath = "OU=$($line.name),$($line.distinguishedName)"
Write-Log -Message "[Info] - Modifying Date for OU $($collection.Name) '$adpath'."
Set-ADOrganizationalUnit -Server $Server -Identity $adpath -Replace $item
}
catch{
$ErrorMessage = $_.Exception.Message
$FailedItem = $_.Exception.ItemName
Write-Log -Message "[ERROR] - Failed writing changes to '$adpath': $ErrorMessage"
}
}
