Jump to content

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here. X
X


Photo

Import CSV file to Add users in AD


  • Please log in to reply
2 replies to this topic

#1 jslegers

jslegers

    Wayfarer

  • Active Members
  • Pip
  • 58 posts

Posted 25 August 2010 - 01:29 PM

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.







#2 kaotkbliss

kaotkbliss

    Universalist

  • Active Members
  • PipPipPipPipPipPip
  • 2,465 posts

Posted 25 August 2010 - 02:00 PM

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

8yyxkx.jpg010101000110100001101001011100110010000001101001011100110010000

001101101011110010010000001110011011010010110011100100001

My first project  Allin1 Program launcher

Bill Calculator

Got <Insert problem here>? There's an AutoIt script for that!


#3 water

water

    ?

  • MVPs
  • 15,728 posts

Posted 26 August 2010 - 03:26 PM

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.

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users