CSVDE and LDIFDE command problems.

KPLCKPLC Posts: 72Member ■■□□□□□□□□
Hey TE,

I've recent started studying for the 70-640 and purchased the Self-paced training kit for it. While running through the labs in the book, I've run into a problem. I've been trying to get the csvde and ldifde commands to work but they both don't seem to take. Using the dsadd command works for adding individual users.

Currently using a trial W2K8R2 Enterprise for my studies.

Here's what I get when I input the commands:

C:\Users\Administrator\Documents>csvde -i -f newusers.txt -k
Connecting to "(null)"
Logging in as current user using SSPI
Importing directory from file "newusers.txt"
Loading entries.
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
No log files were written. In order to generate a log file, please
specify the log file path via the -j option.


C:\Users\Administrator\Documents>ldifde -i -f newusers.ldf -k
Connecting to "SERVER01.contoso.com"
Logging in as current user using SSPI
Importing directory from file "newusers.ldf"
Loading entries.
Add error on entry starting on line 1: No Such Attribute
The server side error is: 0x57 The parameter is incorrect.
The extended server error is:
00000057: LdapErr: DSID-0C090C3E, comment: Error in attribute conversion operati
on, data 0, v1db1
0 entries modified successfully.
An error has occurred in the program
No log files were written. In order to generate a log file, please
specify the log file path via the -j option.

This is my "newusers.txt" file:

DN,objectClass,sAMAccountName,sn,givenName,userPrincipleName
"cn=Lisa Andrews,ou=People,dc=contoso,dc=com",user,lisa.andrews,Lisa,Andrews,[email protected]
"cn=David Jones,ou=People,dc=contoso,dc=com",user,david.jones,David,Jones,[email protected]


I've looked at the book and have gone through the and checked the syntax, spelling, spacing, etc on the .txt and .ldf files and they both look like they do in the book.

Can anybody give me some insight on what I'm doing wrong?

Comments

  • method115method115 Posts: 85Member ■■□□□□□□□□
    Did you check the errata web link in the beginning of the book? The syntax in the books might not be right. I can't remember because I haven't studied that in a while I'm reviewing other subjects right now. I remember having issues with those commands as well and I'm pretty sure I had to go online to find the correct syntax.
  • KPLCKPLC Posts: 72Member ■■□□□□□□□□
    method115 wrote: »
    Did you check the errata web link in the beginning of the book? The syntax in the books might not be right. I can't remember because I haven't studied that in a while I'm reviewing other subjects right now. I remember having issues with those commands as well and I'm pretty sure I had to go online to find the correct syntax.

    Thanks for the reply. I went to the website given in the book. But it just defaults to the learning network.

    Tried this Technet Article, but still got the same result.
  • mrahmrah Posts: 3Member ■□□□□□□□□□
    KPLC wrote: »
    DN,objectClass,sAMAccountName,sn,givenName,userPrincipleName
    "cn=Lisa Andrews,ou=People,dc=contoso,dc=com",user,lisa.andrews,Lisa,Andrews,[email protected]
    "cn=David Jones,ou=People,dc=contoso,dc=com",user,david.jones,David,Jones,[email protected]
    you had the UPN misspelled, it should be: userPrincipalName
  • Mohamed SyalahMohamed Syalah Posts: 1Registered Users ■□□□□□□□□□
    I don't know WHY all noise about this question, Simply the answer is:

    DON'T USE SPACE BEFORE OR AFTER THE COLON just like this .... DN:CN=April....

    and this is the famous example below:

    DN:CN= April Stewart,OU=People,DC=contoso,DC=com
    changeType:add
    CN:April Stewart
    objectClass:user
    sAMAccountName:april.stewart
    userPrincipalName:[email protected]
    givenName:April
    sn:Stewart
    displayName:Stewart,April
    mail:[email protected]
    description:Sales Representative in the USA
    title:Sales Representative
    department:Sales
    company:Contoso, Ltd.
    DN:CN= Tony Krijnen,OU=People,DC=contoso,DC=com
    changeType:add
    CN:Tony Krijnen
    objectClass:user
    sAMAccountName:tony.krijnen
    userPrincipalName:[email protected]
    givenName:Tony
    sn:Krijnen
    displayName:Krijnen,Tony
    mail:[email protected]
    description:Sales Representative in the NetherLands
    title:Sales Representative
    department:Sales
    company:Contoso, Ltd.


    JUST LIKE THAT.
  • deepindeepin Posts: 1Registered Users ■□□□□□□□□□
    i have tried it all no space after colon 1 line gap between two entries but still getting error
    unable to read the import file newusers.ldf
    no log files were written. in order to generate a log file , please specify the log file path via the -j option.
    i have tried copying and carefully watching the spaces and spelling and lines and spaces but still couldnt get the result
    help required please
  • LunchbocksLunchbocks Senior Member Posts: 257Member ■■■■□□□□□□
    The errata for this book is on O'Reilly's web site:

    hxxp://oreilly dot com/catalog/errata dot csp?isbn=0790145314413

    I had the same problem with these labs and some of it was typos in the book.

    Good luck with your exam!
    Degree: Liberty University - B.S Computer Science (In Progress)
    Current Certs: MCTS | Network+
    Currently Working On: CCNA
    2019 Goals: CCNA R&S, CCNA Security, Security+, Linux+


  • unlimitedgeekunlimitedgeek Posts: 3Registered Users ■□□□□□□□□□
    I am also having this issue. Yes I checked the errata and nothing is mentioned in the confirmed or unconfirmed. I have tried everything I could think. So I am wondering what is wrong. I feel really disappointed that these books have so many issues that are not even resolved in the errata, especially when they cost so much. Any help would be appreciated.
  • BGravesBGraves Posts: 339Member
    I am also having this issue. Yes I checked the errata and nothing is mentioned in the confirmed or unconfirmed. I have tried everything I could think. So I am wondering what is wrong. I feel really disappointed that these books have so many issues that are not even resolved in the errata, especially when they cost so much. Any help would be appreciated.
    https://www.google.com/search?q=Add+error+on+entry+starting+on+line+1%3A+No+Such+Attribute&oq=Add+error+on+entry+starting+on+line+1%3A+No+Such+Attribute&aqs=chrome..69i57.177j0j7&sourceid=chrome&espv=210&es_sm=122&ie=UTF-8
  • unlimitedgeekunlimitedgeek Posts: 3Registered Users ■□□□□□□□□□
    Wow, thank you. It still to me 30 minutes to resolve this. There are a few keys I found,
    Check the spacing and follow it exactly
    make sure you do not have an extra space after the last line at the bottom
    everything is so sensitive this seems to be a difficult way to import users.
    Thanks for the help.
Sign In or Register to comment.