Parse ldif data to CSV format using PowerShell

Question

Parse ldif data to CSV format using PowerShell

EspnHaj15 1

Hello, I am attempting to parse ldif data to CSV format. I have tried my hand at this for sometime but haven’t came up with anything remotely close.

I have also tried solution below which does not work for my situation.
https://learn.microsoft.com/en-us/answers/questions/245854/convert-ldif-to-csv-with-powershell.html

My scenario is I have ldif file formatted like below:

dn: cn=groupName,ou=subOuName,ou=ParentOu,o=org .net
uniquemember: uid=logonName1
uniquemember: uid=logonName2
uniquemember: uid=logonName3

dn: cn=OthergroupName,ou=subOuName,ou=ParentOu,o=org .net
uniquemember: uid=logonName1
uniquemember: uid=logonName2
uniquemember: uid=logonName3

How can I convert the above ldif data to csv format like below?

UID,GNAME  #headers
logonName1,groupName
 logonName2,groupName 
logonName3,groupName
 logonName1,OthergroupName 
logonName2,OthergroupName 
logonName3,OthergroupName

Please note I am not querying AD, so I cannot use AD commands from the ActiveDirectory module.

2 answers

Your answer

Answer 1

Rich Matheisen 47,901

Try this:

$ldiffile = 'c:\junk\xx.ldf'  
$destination = 'c:\junk\xx.csv'  
  
$regex1 = 'CN=(.*?(?<!\\)),(.*)'  
$regex2 = 'UID=(.*?(?<!\\)),(.*)'  
$gname = ""  
Get-Content $ldiffile |  
    ForEach-Object {  
        [array]$p = $_ -split ": ", 2  
        if ($p[0] -eq 'dn'){  
            $gname = $p[1] -replace $regex1,'$1'  
        }  
        elseif($p[0] -eq 'uniquemember'){  
            [PSCustomObject]@{  
                UID = $p[1] -replace $regex2,'$1'  
                GNAME = $gname  
            }  
        }  
    } | Export-Csv $destination -NoTypeInformation

EspnHaj15 1 Reputation point

2022-11-22T00:51:27.987+00:00

Thank you RichMatheisen8856!

This is working. Can you breakdown lines 9-13 in detail?
Rich Matheisen 47,901 Reputation points

2022-11-22T02:34:52.187+00:00

Line 9 splits the line into two parts: the property name and the property value. It uses the ": " that separates the two to accomplish that.

Line 11 extracts the name of the group from the distinguished name, Line15 does the same thing, but for the 'uniquemember' lines. It extracts the "uid" value.

Answer 2

Satyajit Rout 0

Hi Rich Matheisan,

Will this script work vice-versa.

My requirement is to prepare a script to convert csv data into ldif format.

Please help me with the PowerShell script.

Best Regards,

Satyajit

Rich Matheisen 47,901 Reputation points

2023-01-31T16:05:22.6633333+00:00

The code will not take the contents of a CSV and convert it to LDIF format. It was written to handle only the data in the original question.

If you have a different problem you should create a new question and provide sufficient information about the data you have to work with. LDIF represents the information in a directory object. A simple CSV probably isn't going to be able to represent that information unless it has only data from a small subset of object types.
Satyajit Rout 0 Reputation points

2023-02-02T10:19:47.91+00:00

Hi Rich,

Thanks You so much for replying!

As asked, I have created a separate question for my requirement, below is my question link:

https://learn.microsoft.com/en-us/answers/questions/1166546/create-excel-data-to-ldif-format-using-powershell

I would be so much grateful if you could help me with the script.

Best Regards,

Satyajit

Share via

Parse ldif data to CSV format using PowerShell

2 answers

Your answer