Topic: LDAP export to CSV file

[ryan]

Anyone know how to create a CSV file from the LDAP directory on SME 5.1.2.?  Is there a "dump" or "export" process with the command line?

[Andy Parkinson]

There is probably an easier way of doing it than this but what I have done to create a csv file is as follows. Installed Mozilla web browser and mail client www.mozilla.org. Set up the mail client to use the ldap server and when all is set up do a wildcard name search using the ldap server ie *  . copy all of the results to the personal address book and then use the export function to create your csv file. Mozilla is the only mail client I have seen to allow wildcard ldap searches hence the reason for using it.


ryan wrote:
>
> Anyone know how to create a CSV file from the LDAP directory
> on SME 5.1.2.?  Is there a "dump" or "export" process with
> the command line?

[ryan]

Thanks for your reply Andy,

I ended up using Outlook Express to capture the LDAP users and then created a CSV file.  My problem was the wild card issue.  I found that under the advanced search, you can search for "@" in email addresses.  This produced the entire list of email addresses from the SME server.

RS