jslegers 0 Posted August 25, 2010 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
kaotkbliss 146 Posted August 25, 2010 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 010101000110100001101001011100110010000001101001011100110010000001101101011110010010000001110011011010010110011100100001My Android cat and mouse gamehttps://play.google.com/store/apps/details?id=com.KaosVisions.WhiskersNSqueekWe're gonna need another Timmy! Share this post Link to post Share on other sites
water 2,391 Posted August 26, 2010 (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 August 26, 2010 by water My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites