importing user list from Microsoft active directory into Zimbra

[eaperezh]

Hi,
I have finished a setup with zimbra OS and this version:
zcs-5.0.9_GA_2533.RHEL5.20080815132719.tgz

I have read the forums, specially this thread
Why can't Zimbra get users from AD

And it says in the wiki there is a document that states how to export AD users into a file, and then importing that file to Zimbra to bulk provisioning the users, but i cannot seem to find it.

Will someone be kind to point me to the mentioned document? or maybe a new procedure since the above url is for a post dated 2007?

My AD has 1800 users in several OUs. and many group email memberships.
I would like to export these lists into a .csv file and then bulk import into zimbra so i can provision the accounts.
i have done a correct auth against the AD for validation purposes so all im missing is the importing of users.
Maybe am opensource script or commercial software that can help me with this?

Many thanks to all in advance,

Erick.

[mmorse]

I haven't played with AD in a long time so can't help much with finding that 'export to csv' option, but an example provisioning script was linked - so not quite sure what you're asking on that front...

Originally Posted by mmorse

In AD can you right click the tree of the users you want to export>csv file.

(the below is shortened from this: Bulk Provisioning - ZimbraWiki )

-remove extraneous columns

The following is a simple perl script to take a CSV file and turn it into the correct zmprov commands-obviously change the variables to the actual fields you use in your CSV file.

#!/usr/bin/perl

while (<>) {
chomp;

my ($email, $password, $first, $last) = split(/\,/, $_, 4);
print qq{ca $email $password\n};
print qq{ma $email givenName "$first"\n};
print qq{ma $email sn "$last"\n};
print qq{ma $email displayName "$first $last"\n};
print qq{\n};
}

I would use ‘’ for the passwords so that it would use the external auth. (Seeing as passwords probably won't be in this csv list & you said earlier that your auth is working properly.)

This would assign everyone to the default COS (class of service), if you wanted to organize it during import, put the cos names in the csv file, then lookup the valid COS ID ahead of time or like this:
my $cosid = `su - zimbra -c 'zmprov gc Default |grep zimbraId:'`;
$cosid =~ s/zimbraId:\s*|\s*$//g;
Then add:
print qq{ma $email zimbraCOSid "$cosid"\n};

Bug 7235 – Auto Provision New Accounts with External LDAP

[mmorse]

Ran across this:

CSVDE imports and exports data from the active directory to a CSV file.
Here is an example of what I did. To get a selected OU group into a csv file.
CSVE -f adexport.csv -n
The above will give you all active directory accounts. I used the -n filter to remove any binary values. I then used Excel to direct a list of all OU’s.
Jimiz.net - Jim Becher on the web » Blog Archive » Microsoft Active Directory user Export - Home of IIS Reporter

Another link on it: CSVDE -f Export examples : user accounts from Active Directory to spreadheet

[enterprisetoday]

This thread may not be as dead as first though... many are coming to terms AD Interaction and zimbra.

I exported my userlist with the following

H:>csvde.exe -f ADexport.csv -r objectClass=person -l "userPrincipleName, name, objectSid"

I edited this file in calc to remove the DN, which is included whether requested or not. Switching the userPrincipleName to the first column gives a CSV file that will be read by zimbra's bulk provision function.

Dallas