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,userPrincipalName,homeFolder,description,objectclass

"CN=Bulk Test,OU=Test,DC=eastguernsey,DC=eguernsey,DC=k12,DC=oh,DC=us",Bulk,Test,bulk.test,Bulk Test,12345,[email protected],\\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,DC=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: [email protected]

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=k12,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.

Setting up LDAP V2.pdf

[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,[email protected].oh .us,\\eg2008dc1\bulk.test\;h:,test,user

Edited January 10, 2013 by Gaz

[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,[email protected].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,[email protected].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

Edited January 10, 2013 by mac_shinobi