csvde error

[kokojoe99]

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=k 12,DC=oh,DC=us"

[Gaz]

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"

[kokojoe99]

I double checked the file. The space isn't there. I must have accidently entered that when during the post.

[mac_shinobi]

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.

[Gaz]

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

[mac_shinobi]

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