1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Import Users with CSVDE

Discussion in 'Active Directory Exams' started by jvanassen, Feb 8, 2013.

  1. jvanassen

    jvanassen Kilobyte Poster

    322
    2
    47
    Hi Guys,

    I am following the Microsft Self Paced training guide for the 70-640 and as per usual im noticing little errors here and there, however if anything its probably helping me as then i have to try and solve it or workout what the correct command is.

    However i have come across one which i am really stuck on and have seen a few people around forums that are stumped on this same example. Ive spent quite a bit of time racking my brains and trying to figure it out but ive finally gave up but i dont want to skip it.

    Im up to Chapter 3 and on exercise 3 theres the task of creating a file and then importing it into AD with the CSVDE command. However i keep getting an error and cant workout what it is ive mispelt or perhaps theres a space somewhere which shouldnt be there.

    my example:

    DN,objectClass,sn,givenName,sAMAccountName,userPrincipalName

    "CN=David Jones,OU=Users,DC=vanassen,DC=local",users,Jones,David,davidj,davidj@vanassen.local


    This is in a txt file. Then i open a command prompt and try to import it using the following command:

    csvde -i -f users.txt -k

    the error i see in the log file is:

    Connecting to "(null)"
    Logging in as current user using SSPI
    Importing directory from file "users.txt"
    Loading entries
    2: CN=David Jones,OU=Users,DC=vanassen,DC=local
    Attribute 0) objectClass: users
    Attribute 1) sn: Jones
    Attribute 2) givenName: David
    Attribute 3) sAMAccountName: davidj
    Attribute 4) userPrincipalName: davidj@vanassen.local

    Add error on line 2: No Such Attribute
    The server side error is "The parameter is incorrect."
    0 entries modified successfully.
    An error has occurred in the program



    Any ideas? What the hell am i missing out lol
     
    Last edited: Feb 8, 2013
    Certifications: CompTIA A+, Network+, CCENT
    WIP: ICND2 200-101
  2. mojorisin

    mojorisin Kilobyte Poster

    395
    14
    41
    csvde -i -f users.txt -k

    users.txt needs to be users.csv as far as I have read before

    csvde can only import csv files

    also see this How to use Csvde to import contacts and user objects into Active Directory
     
    Last edited: Feb 8, 2013
    WIP: 70-685 http://www.speedtest.net/result/3377759783.png
  3. jvanassen

    jvanassen Kilobyte Poster

    322
    2
    47
    Thanks for your input but i had tried changing the format of the file to a .CSV already but had no luck.
     
    Certifications: CompTIA A+, Network+, CCENT
    WIP: ICND2 200-101
  4. mojorisin

    mojorisin Kilobyte Poster

    395
    14
    41
    saw this

    Hi, i battled also with this one till I tried it this way.
    objectClass,sAMAccountName,DN,Member
    Group,Accounting,"cn=Accounting,OU=Groups,DC=contoso,DC=com","cn=Linda.Mitchell,OU=People,DC=contoso,DC=com;cn=Scott.Mitchell,OU=People,DC=contoso,DC=com"
    Then save it as an .csv file and it should work

    on this site CSVDE
     
    WIP: 70-685 http://www.speedtest.net/result/3377759783.png

Share This Page

Loading...