Sign in to follow this  
Followers 0

Import CSV file to Add users in AD

3 posts in this topic

Posted

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

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)

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

  • Recently Browsing   0 members

    No registered users viewing this page.