Sign in to follow this  
Followers 0

Import CSV file to Add users in AD

3 posts in this topic

#1 ·  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



#2 ·  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


010101000110100001101001011100110010000001101001011100110010000

001101101011110010010000001110011011010010110011100100001

My Android cat and mouse game
https://play.google.com/store/apps/details?id=com.KaosVisions.WhiskersNSqueek

We're gonna need another Timmy!

Share this post


Link to post
Share on other sites

#3 ·  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

My UDFs and Tutorials:

UDFs:
Active Directory (2014-07-21 - Version 1.4.1.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2014-07-27 - Version 1.0.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (NEW 2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

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