Importing to Active Directory using CSVDE

[N.Rahman]

I am trying to use Csvde command to import to AD. But getting parameters error.
Domain Controller name: CTEST.com
Trying to import to Default users containers.
What I did so far.
Created a excell worksheet with following headings.
First Name Last Name Login ID Phone
and saved the file in CSV format.
Used the follwing command
CSVDE -i -f a:\input.csv

I check the help but explanation is not good enough.

Thanks in advanvce.

[Steve Judd]

Well, none of the column names are attribute names, and you have not
provided the objectClass or DN.

Your file must provide a distinguished name for every entry, in a column
called "DN"

The rest of the column headings must be valid attribute names for the object
class you are creating. In your case you will want columns for:

DN, CN, givenName, sn, telephoneNumber,samAccountName

Where these columns contain:

DN - the distinguished name of the object to create
CN - the common name (leftmost element of the DN)
givenName - person's first name
sn - person's last name
telephoneNumber - person's phone number
samAccountName - the "login ID".

-s

"N.Rahman" <Nusra...@netscape.net> wrote in message
news:dbf701c0d265$431ba930$9ae62ecf@tkmsftngxa02...

[Kerry Hoskin]

The best thing to do would be to do an output to a csv file using csvde this
will give you a list of correct headers. You can then delete the headers
that you don't want to use.

Kerry Hoskin
PC Analyst
Plymouth Marine Laboratory
kj...@pml.ac.uk

"N.Rahman" <Nusra...@netscape.net> wrote in message
news:dbf701c0d265$431ba930$9ae62ecf@tkmsftngxa02...

[NRahman]

I am still struggling.
My CSV file look like this

DN,CN,givenName,sn,telephoneNumber,samAccountName
"CN=Nusrat Rahman,CN=Users,DC=CTEST,DC=COM",TESTING,TESER,NO NMAE,888,TESTING

and I am getting follwong message.
Connecting to "<null>"
logging in as current user using SSPI
import directory from file "a:\input.csv"
objectclass attributes not defined
0 entries modified successfully
An error has occoured in the program

Where these columns contain:

-s

Thanks in advanvce.

.

[Steve Judd]

The error message tells you, you need "objectClass". Sorry if I missed this
first time around.

Also.the CN must be the one provided in the DN, and you must have the
objectClass also:

DN,CN,objectclass,givenName,sn,telephoneNumber,samAccountName
"CN=Nusrat Rahman,CN=Users,DC=CTEST,DC=COM","Nusrat
Rahman",user,TESTING,TESER,NO NMAE,888,TESTING

"NRahman" <Nusra...@netscape.net> wrote in message
news:24e501c0d3fc$617327d0$9be62ecf@tkmsftngxa03...

I am still struggling.
My CSV file look like this

DN,CN,givenName,sn,telephoneNumber,samAccountName
"CN=Nusrat Rahman,CN=Users,DC=CTEST,DC=COM",TESTING,TESER,NO
NMAE,888,TESTING

and I am getting follwong message.
Connecting to "<null>"
logging in as current user using SSPI
import directory from file "a:\input.csv"
objectclass attributes not defined
0 entries modified successfully
An error has occoured in the program

<snip>

[N. Rahman]

Thanks Steve
Things are working fine but minor problem.
When users are created, they are disabled and I have to manually enabled them.
Would you please help me on that. It must be one of the parameters I am missing.

Thanks

<snip>

.

[Steve Judd]

You must set the userAccountControl attribute. Setting it to 512 will set
the "normal user account" flag which should be adequate. The account will
still need to have a password set for it.

-s
--------------------------------------------------------

"N. Rahman" <Nusra...@Netscape.net> wrote in message
news:35b801c0d713$c251dff0$9be62ecf@tkmsftngxa03...

[N. Rahman]

Thanks Steve.

-s
--------------------------------------------------------

<snip>

..

.