CSV Bulk Import?!

[TheMisio]

Fellow Techies,

I’m trying to bulk import users into AD using CSV. However, every time I runt the import it fails with the “Invalid number of attributes in input file”

I’ve been trying to import it using examples from the net, sometimes using only three attributes (example below):

DN,objectClass,userAccountControl,sAMAccountName,userPrincipalName
"CN=User1\, Example1,OU=ACCOUNTS,DC=childdomain,DC=mydomain,DC=net",user,512,user1e,user1.example1@mydomain.co.uk
"CN=User2\, Example2,OU=ACCOUNTS,DC=childdomain,DC=mydomain,DC=net",user,512,user2e,user2.example2@mydomain.co.uk
"CN=User3\, Example3,OU=ACCOUNTS,DC=childdomain,DC=mydomain,DC=net",user,512,user3e,user3.example3@mydomain.co.uk

I’ve tried leaving only the DN, objectClass and sAMAccountName attributes but it fails with the same error message.

Does anyone know what the problem might be?

Regards,

Michael

 

[acl03]

How are you trying to do this import? VBScript? Something else?

Thanks,
Andrew

Hard work often pays off over time, but procrastination pays off right now!

 

[TheMisio]

acl03,

Just a standard csvde -i command and supply the data in the text file.

Regards,