CSVDE importing users into groups

I am trying to set up a spreadsheet to bulk import our schools users onto our new server, I can get it to import username etc and into the correct OU but I can't get it to accept groups. Any ideas? Also can you add password?

I don't fancy imputting 1200 users.

CSVDE will not set passwords, you need dsadd.

What I do is setup my csv file on a Unix box, and run it through an awk script to produce a couple of .bat files, which I then transfer to the M$ box and run. Samples lines from each file (there will be one per user).

mkuser.bat (the user will logon with gorag07 and password kleys47)

dsadd user "CN=Gora George,OU=07,OU=Students,DC=dt,DC=local" -samid gorag07 -ln Gora -fn George -pwd kleys47 -hmdir \\dt-server\gorag07$ -hmdrv H: -loscr student.bat

mkhome.bat

cd \StudentHomeDirs

mkdir gorag07

cacls gorag07 /e /c /g gorag07:f