CSV File Headers

Posted on 2005-05-05
Last Modified: 2007-12-19
Hi Experts

I have created a csv file and i can succesfully bulk import users into active directory using the csv file and csvde however the user password is always set to blank (no password) even though i have in the header the field password and havew specfied a password. also i have tried to use the memberOf field to add security groups to users and when i ry to import witht the memberOf field the import fails.

Question by:SandipDMehta
    LVL 33

    Expert Comment

    You probably can't modify users security rights, which explains why that part of your import fails.

    "Another utility called Csvde.exe performs the same export functions as the Ldifde.exe utility, but uses a comma-separated file format. Import operations with this utility are “add” only; it does not offer the ability to modify or delete objects. The comma-separated value (CSV) file format is supported by applications such as Microsoft Excel."

    Step-by-Step Guide to Active Directory Bulk Import and Export

    How to use Csvde to import contacts and user objects into Active Directory;en-us;327620
    LVL 20

    Expert Comment

    CSVDE does not allow you to import passwords. :-(  If you want to import accounts and have it use passwords you could try to use DSADD but it may require more work.

    When you do the memberOF value make sure you put in the DN of the group IE: CN=Guests,CN=Builtin,DC=nwtraders,DC=msft

    DSADD also works very well with adding users to groups.

    Hope this info helps


    Author Comment

    hi brian

    what if the security groups is not one of the builtin groups and its one that has been created e.g AllTeachers and also the CN=guests is that where the security group is in or is that where the destination container of the imported user?
    LVL 20

    Accepted Solution

    Not sure I understand your question but you can use this for custom groups as well, you just have to know what the DN is for the group.


    Author Comment

    sorry Brian

    one last question. would you know the header fields for the following:

    Live Communications
    a) SIP URI
    b) Home Server

    Exchange 2003 Server

    Under the exchange genral tab in active directory and in delivery restrictions:

    a) Accept message only from
    LVL 20

    Expert Comment


    I don't have Live Communications or Exchange 2003 installed on a server to see but if you look in the Schema snap-in you should be able to see the actual name of the attribute.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
    Learn about cloud computing and its benefits for small business owners.
    This video discusses moving either the default database or any database to a new volume.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now