Convert LDIF to CSV with powershell

Question

Hi,

I try to convert my sogo LDIF to CSV, but i have an issue, my LDIF content :

dn:
objectClass:
mail:
givenname:
sn:
displayname:
vcardcategories:

I want to exclude dn, objectclass, sn and vcardcategories

I use this script :

Get-Content $ldiffile |Foreach{
  $parts = $_.Split(":")
  switch($parts[0].Trim())
        {
            "dn" {
        if($obj -ne $null)
        {
            $objlist+=$obj
        }
        $obj=""| select mail,givenname,sn,dn,displayname
        $obj.dn=$parts[1].Trim()
    }
    "" {
      # Do nothing if it's blank
    }
    default {
      $obj."$($parts[0].Trim())"=$parts[1].Trim()
    }
  }


}
if ($obj -ne $null)
        {
            $objlist+=$obj
        }
$objlist| Export-Csv $destination

Do you know how can i only have these information in my CSV? (actually, my CSV is blank)

Thanks in davance

Answer 1

Try this:

$ldiffile = 'c:\junk\x.ldf'
$destination = 'c:\junk\x.csv'
$omit = 'dn','objectclass','sn','vcardcategories'
$a = @{}                # initialize the temporary hash
$x = @()                # results
Get-Content $ldiffile |
    ForEach-Object {
        if ($_ -match "^\s*$") { # blank line - dump the hash and reinitialize the hash
            $x += [PSCustomObject]$a
            $a = @{ }
        }
        else {      # add the not-omitted key/value to the hash
            $key, $value = $_ -split ": "
            if ($omit -notcontains $key){
                $a[$key] = $value
        }
    }
}
if ($a.keys.length -gt 0){  # emit last LDIF entry if LDIF didn't end w/blank line
    $x += [PSCustomObject]$a
}
$x | Export-Csv $destination -NoTypeInformation