2 replies to this topic

[jslegers]

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]

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]

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 by water, 26 August 2010 - 03:27 PM.