Bulk AD Import

[Skiver Veteran]

Hi Guys,

 

I am going round in circles here and I know this is some stupid issue with what I am trying to import but I am far too blind to see it.

 

so I am running "C:\Users\Administrator>csvde -b administrator dev-mettoni3 Mett0n1# -i -f "C:\AD stuff\import.csv" -j C:\

 

I get the following error;

 

Loading entries.

Invalid number of attributes in input file.

Syntax error on line 2

0 entries modified successfully.

An error has occurred in the program

 

Output from my error file;

 

Attribute 0) path: CN=ADUsers,DC=dev-mettoni3,DC=COM

Attribute 1) givenName: ADUser1

Attribute 2) sn: ADUser1

Attribute 3) title: Title

Attribute 4) descrption: Description

Attribute 5) department: RD

Attribute 6) company: Enghouse

Attribute 7) telephoneNumber: 2000

Attribute 8) sAMAccountName: ADUser1

Attribute 9) userPrincipalName: ADUser1@dev-mettoni3.com

Attribute 10) displayName: ADUser1

Attribute 11) objectClass: user

 

Add error on line 2: No Such Attribute

The server side error is "The parameter is incorrect."

An error has occurred in the program

 

 

CSV file contents;

 

path,givenName,sn,title,descrption,department,company,telephoneNumber,sAMAccountName,userPrincipalName,displayName,dn,objectClass

"CN=ADUsers,DC=dev-mettoni3,DC=COM",ADUser1,ADUser1,Title,Description,RD,Enghouse,2000,ADUser1,ADUser1@dev-mettoni3.com,ADUser1,"cn=ADUser1,CN=ADUsers,DC=dev-mettoni3,DC=COM",user

 

I know this will be something simple :(

 

[XorpiZ]

Could it be this typo in "description"?

 

"descrption"

[Skiver Veteran]

Good spot, hadn't noticed that one but unfortunately no cigar!

 

I also noticed another mistake, I had CN=ADUsers but it should have been OU

 

 

path,givenName,sn,title,description,department,company,telephoneNumber,sAMAccountName,userPrincipalName,displayName,dn,objectClass

"OU=ADUsers,DC=dev-mettoni3,DC=COM",ADUser1,ADUser1,Title,Description,RD,Enghouse,2000,ADUser1,"ADUser1@dev-mettoni3.com",ADUser1,"cn=ADUser1,OU=ADUSERS,DC=dev-mettoni3,DC=COM",user

 

 

Attribute 0) path: OU=ADUsers,DC=dev-mettoni3,DC=COM

Attribute 1) givenName: ADUser1

Attribute 2) sn: ADUser1

Attribute 3) title: Title

Attribute 4) description: Description

Attribute 5) department: RD

Attribute 6) company: Enghouse

Attribute 7) telephoneNumber: 2000

Attribute 8) sAMAccountName: ADUser1

Attribute 9) userPrincipalName: ADUser1@dev-mettoni3.com

Attribute 10) displayName: ADUser1

Attribute 11) objectClass: user

 

Add error on line 2: No Such Attribute

The server side error is "The parameter is incorrect."

An error has occurred in the program

 

[XorpiZ]

I would try removing any non-necessary attributes to see if I could track down the faulting attribute.

 

IE. only have username, shortname and a few others and see if it works then.

[Skiver Veteran]

Got it working with;

 

sAMAccountName,dn,objectClass,givenName,sn

ADUser1,"CN=ADUser1,OU=ADUsers,DC=dev-mettoni3,DC=COM",user,ADUser1,ADUser1

 

I think it was the path attribute that did it, I'm not sure where I got it from and I could have sworn I had tried removing it but it's going in now. 90K users so it's going to take a while to complete :)

 

Little concerned that they aren't showing in AD Users and Computers yet but I can only assume that will appea correctly once the import is finished.