+ Post New Thread
Results 1 to 6 of 6
Windows Server 2008 R2 Thread, csvde error in Technical; Hello! I am in the process of building a new domain for my district and I'm trying to import bulk ...
  1. #1

    Join Date
    Jan 2013
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    csvde error

    Hello! I am in the process of building a new domain for my district and I'm trying to import bulk users using csvde (which is new to me). I keep getting a DN syntax error but I can't find what's wrong. I did a dsquery to look up the DN of users I've created manually and followed that. Below is the csv I'm trying to use, the csvde error log, and a line from dsquery. I'm about to pull my hair out! Thanks in advance!

    csv:
    DN,gn,sn,sAMAcount,displayName,password,userPrinci palName,homeFolder,description,objectclass
    "CN=Bulk Test,OU=Test,DC=eastguernsey,DC=eguernsey,DC=k12,D C=oh,DC=us",Bulk,Test,bulk.test,Bulk Test,12345,bulk.test@eastguernsey.eguernsey.k12.oh .us,\\eg2008dc1\bulk.test\;h:,test,user

    error log:

    Connecting to "(null)"
    Logging in as current user using SSPI
    Importing directory from file "testuploadbulk.csv"
    Loading entries
    2: "CN=Bulk Test,OU=Test,DC=eastguernsey,DC=eguernsey,DC=k12,D C=oh,DC=us"
    Attribute 0) gn: Bulk
    Attribute 1) sn: Test
    Attribute 2) sAMAcount: bulk.test
    Attribute 3) displayName: Bulk Test
    Attribute 4) password: 12345
    Attribute 5) userPrincipalName: bulk.test@eastguernsey.eguernsey.k12.oh.us
    Attribute 6) homeFolder: \eg2008dc1bulk.test;h:
    Attribute 7) description: test
    Attribute 8) objectclass: user

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


    dsquery line:

    "CN=test,OU=Test,DC=eastguernsey,DC=eguernsey,DC=k1 2,DC=oh,DC=us"

  2. #2
    Gaz
    Gaz is offline

    Join Date
    Feb 2011
    Location
    Preston
    Posts
    799
    Thank Post
    138
    Thanked 67 Times in 59 Posts
    Rep Power
    20
    You have a space here (see red text) it may cause a problem.
    2: "CN=Bulk Test,OU=Test,DC=eastguernsey,DC=eguernsey,DC=k12,D C=oh,DC=us"

  3. #3

    Join Date
    Jan 2013
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I double checked the file. The space isn't there. I must have accidently entered that when during the post.

  4. #4

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,756
    Thank Post
    3,265
    Thanked 1,052 Times in 973 Posts
    Rep Power
    365
    On a client to confirm LDAP Path you could install and use : Softerra LDAP Administrator & Browser: Directory Management Tool Download

    Follow instructions up to about page 5 of this pdf guide ( originally created for scan to email on Ricoh Copiers using the LDAP Server to populate the users email addresses )

    That should allow you to confirm the full path is correct.
    Attached Files Attached Files

  5. #5
    Gaz
    Gaz is offline

    Join Date
    Feb 2011
    Location
    Preston
    Posts
    799
    Thank Post
    138
    Thanked 67 Times in 59 Posts
    Rep Power
    20
    Its saying Invalid Syntax and that to me means there is a character out of place or being miss-used but I cant see where. :-/

    Again on the 3rd line there is a space, I'm not sure if that makes a difference ether.
    Test,12345,bulk.test@eastguernsey.eguernsey.k12.oh .us,\\eg2008dc1\bulk.test\;h:,test,user
    Last edited by Gaz; 10th January 2013 at 05:03 PM.

  6. #6

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,756
    Thank Post
    3,265
    Thanked 1,052 Times in 973 Posts
    Rep Power
    365
    Quote Originally Posted by Gaz View Post
    Its saying Invalid Syntax and that to me means there is a character out of place or being miss-used but I cant see where. :-/

    Again on the 3rd line there is a space, I'm not sure if that makes a difference ether.
    Test,12345,bulk.test@eastguernsey.eguernsey.k12.oh .us,\\eg2008dc1\bulk.test\;h:,test,user
    The last part of that, shouldn't it be enclosed in quotes for the unc path or something along those lines ie :

    Test,12345,bulk.test@eastguernsey.eguernsey.k12.oh .us,"\\eg2008dc1\bulk.test\",h:,test,user

    Changed the ; to a , at the end after the end quote mark

    Just guessing btw - normally whenever I do unc type paths I have to enclose it in quotes
    Last edited by mac_shinobi; 10th January 2013 at 05:17 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. Administrators Nasty File Search errors.
    By Kyle in forum How do you do....it?
    Replies: 5
    Last Post: 24th January 2006, 09:53 PM
  2. Google Spyware error
    By ChrisH in forum Windows
    Replies: 10
    Last Post: 14th December 2005, 08:35 PM
  3. liberum and asp error message
    By russdev in forum Windows
    Replies: 2
    Last Post: 25th November 2005, 01:46 PM
  4. Adduser.conf parse errors
    By ChrisH in forum *nix
    Replies: 4
    Last Post: 18th November 2005, 11:10 AM
  5. Kerberos error - All policies disappeared
    By ajbritton in forum Windows
    Replies: 13
    Last Post: 2nd November 2005, 02:13 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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