Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: ryan on July 17, 2002, 03:49:09 AM

Title: LDAP export to CSV file
Post by: ryan on July 17, 2002, 03:49:09 AM

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?

Title: Re: LDAP export to CSV file
Post by: Andy Parkinson on July 17, 2002, 11:58:22 PM

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?

Title: Re: LDAP export to CSV file
Post by: ryan on July 18, 2002, 10:40:47 AM

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