USE OF CSVDE COMMAND

WHAT IS USE OF CSVDE COMMAND ?

The CSVDE command is used to import and export data from and export data from and a.csv file .

You can use the CSVDE command to create a new Group and then finally import the file in to AD.

The Syntax of Using the CSVDE command is :

CSVDE -i -f "filename" [-k]

In the Preceding Syntax :

• -i : Specifies the Import mode . The Default mode of the .csv file is export mode .
• -f : Precedes the file Name .
• -k : Ensure that the process of importing contonues even of erors are encountered .

USING THE CSVDE COMMAND

Lets Perform Following Steps , And Create a Newgroup by the Using CSVDE Command

1--- Open the Notepad
2--- Type the Following Lines In Notepad .

objectclass,SAMAccountName,DN,member
group,writers, "CN=writers , DC=dreamtechpress,DC=net"

Save the Notepad File as "Newgroup.csv" . You Should Remember to Enclose the the Filename Within Quotes , otherwise ,notepad will add a .txt extension .

After the open Command Prompt "CMD" and move to the location where you have saved the .csv file .

Execute the script by typing following command in the command prompt :

CSVDE  -i -f Newgroup.csv

Open the Active Directory Users and Computer snap-in.You can See that a new group writers is created .

in this way , you can create more groups in AD by Using the CSVDE Command .