Results 1 to 4 of 4

Thread: importing user list from Microsoft active directory into Zimbra

  1. #1
    Join Date
    Feb 2006
    Rep Power

    Question importing user list from Microsoft active directory into Zimbra

    I have finished a setup with zimbra OS and this version:

    I have read the forums, specially this thread

    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,


  2. #2
    Join Date
    May 2006
    Rep Power


    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...

    Quote Originally Posted by mmorse View Post
    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.


    while (<>) {

    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

  3. #3
    Join Date
    May 2006
    Rep Power


    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. - 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

  4. #4
    Join Date
    Jun 2007
    Rep Power


    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.


Similar Threads

  1. /tmp filling
    By Nutz in forum Administrators
    Replies: 8
    Last Post: 02-22-2008, 01:00 AM
  2. [SOLVED] Clamav problem ? What's happening ?
    By aNt1X in forum Installation
    Replies: 23
    Last Post: 02-14-2008, 04:43 AM
  3. Big Fubar on 5 FOSS GA Upgrade
    By uxbod in forum Administrators
    Replies: 24
    Last Post: 01-21-2008, 02:37 AM
  4. Fedora Core 3, Clean Install - Not working!
    By pcjackson in forum Installation
    Replies: 17
    Last Post: 03-05-2006, 06:38 PM
  5. Network edition - strange behavior
    By goetzi in forum Installation
    Replies: 6
    Last Post: 11-16-2005, 02:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts