Sign in to follow this  
Followers 0

Import CSV file to Add users in AD

3 posts in this topic

Posted · Report post

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.

Share this post


Link to post
Share on other sites



Posted · Report post

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

Share this post


Link to post
Share on other sites

Posted (edited) · Report post

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0