Import CSV file to Add users in AD

[jslegers 0]

Hello,

I want to create a script that can read a csv file and use this data to create users in Active Directory with the tool dsadd.

CSV file looks like this :

ABeerens;Ans Beerens;Ans;Beerens;Welkom01

ABos;Annemiek Bos;Annemiek;Bos;Welkom01

ABraat;Ans Braat;Ans;Braat;Welkom01

Is it possible to create variables from the different pieces in the file.

For example

$Var1=ABeerens

$Var2=Ans Beerens

$Var3=Ans

$Var4=Beerens

$Var5=Welkom01

dsadd $Var1,Var2 ....

Loop

And so on.

I want to create a loop until the end of the file is reached.

[kaotkbliss 138]

You could read the file to an array (_FileReadToArray)

then loop through that array, splitting each record into smaller arrays with StringSplit

In your example, you would have an array set up like

_FileReadToArray("Whatever\file.csv",$csv)

;0=3

;1=ABeerens;Ans Beerens;Ans;Beerens;Welkom01

;2=ABos;Annemiek Bos;Annemiek;Bos;Welkom01

;3=ABraat;Ans Braat;Ans;Braat;Welkom01

For $i=1 to Ubound($csv)-1

$record=StringSplit($csv[$i],";")

;0=5

;1=ABeerens

;2=Ans Beerens

;3=Ans

;4=Beerens

;5=Welkom01

;Then you can dsadd $csv[1], $csv[2]

Next

[water 1,347]

May I suggest to use the Active Directory UDF - function _AD_CreateUser - to add users? You can create a user in a different OU in one go and have better error handling.

You can find the download link in my signature below.

Edited August 26, 2010 by water