+ Post New Thread
Page 5 of 5 FirstFirst 12345
Results 61 to 64 of 64
How do you do....it? Thread, Bulk user creation in Technical; generate csv file from sims.net import through CC3 MMC 2mins done, all folders, shares, e-mail, printer quotas, disk quotas etc ...
  1. #61

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,942
    Thank Post
    1,199
    Thanked 1,069 Times in 760 Posts
    Rep Power
    330

    Re: Bulk user creation

    generate csv file from sims.net import through CC3 MMC 2mins done, all folders, shares, e-mail, printer quotas, disk quotas etc created automatically in AD ready to use immediately thanks RMCC3.

  2. #62
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,966
    Thank Post
    248
    Thanked 49 Times in 45 Posts
    Blog Entries
    2
    Rep Power
    46

    Re: Bulk user creation

    Quote Originally Posted by bossman
    ...thanks RMCC3.
    ...Our lowly paid extra tech!

    :P

  3. #63

    Join Date
    Jul 2006
    Location
    Birmingham
    Posts
    12
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Bulk user creation

    hi all,

    csvde.exe is the easy part its the setting up a correct excel spreadsheet.

    http://www.excel-vba.com/microsoft-e...t-formulas.htm

    helped me out no end..

    hth.

  4. #64
    alonebfg's Avatar
    Join Date
    Aug 2006
    Location
    south west some of the time
    Posts
    834
    Thank Post
    12
    Thanked 34 Times in 21 Posts
    Blog Entries
    5
    Rep Power
    24

    Re: Bulk user creation

    i have found a really good script here exel bulk add user script
    i have modofied it to this
    ' UserSpreadsheet .vbs
    ' Sample VBScript to create User accounts from a spreadsheet
    ' Author Guy Thomas http://computerperformance.co.uk/
    ' Version 4.6 - June 2005
    ' ------------------------------------------------------'
    Option Explicit
    Dim objRootLDAP, objContainer, objUser, objShell
    Dim objExcel, objSpread, intRow
    Dim strUser, strOU, strSheet
    Dim strCN, strSam, strFirst, strLast, strPri, strPro, strPWD, strDin

    ' -------------------------------------------------------------'
    ' Important change OU= and strSheet to reflect your domain
    ' -------------------------------------------------------------'

    strOU = "OU=Class Two,OU=Students Class, " ' Note the comma
    strSheet = "C:\vbstest.xls"

    ' Bind to Active Directory, Users container.
    Set objRootLDAP = GetObject("LDAP://rootDSE")
    Set objContainer = GetObject("LDAP://" & strOU & _
    objRootLDAP.Get("defaultNamingContext"))

    ' Open the Excel spreadsheet
    Set objExcel = CreateObject("Excel.Application")
    Set objSpread = objExcel.Workbooks.Open(strSheet)
    intRow = 3 'Row 1 often contains headings

    ' Here is the 'DO...Loop' that cycles through the cells
    ' Note intRow, x must correspond to the column in strSheet
    Do Until objExcel.Cells(intRow,1).Value = ""
    strSam = Trim(objExcel.Cells(intRow, 1).Value)
    strCN = Trim(objExcel.Cells(intRow, 2).Value)
    strFirst = Trim(objExcel.Cells(intRow, 3).Value)
    strLast = Trim(objExcel.Cells(intRow, 4).Value)
    strPri = Trim(objExcel.cells(intRow, 5).Value)
    strPro = Trim(objExcel.cells(intRow, 6).Value)
    strPWD = Trim(objExcel.Cells(intRow, 7).Value)
    strDin = Trim(objExcel.Cells(intRow, 8).Value)

    ' Build the actual User from data in strSheet.
    Set objUser = objContainer.Create("User", "cn=" & strCN)
    objUser.sAMAccountName = strSam
    objUser.givenName = strFirst
    objUser.sn = strLast
    objUser.userPrincipalName = strPri
    objuser.profilePath = strPro
    objuser.displayName = strDin
    objUser.SetInfo

    ' Separate section to enable account with its password
    objUser.userAccountControl = 512
    objUser.pwdLastSet = 0
    objUser.SetPassword strPWD
    objUser.SetInfo

    intRow = intRow + 1
    Loop
    objExcel.Quit

    WScript.Quit

    ' End of free example UserSpreadsheet VBScript.
    have added userPrincipalName profilePath and displayName have also done one with the user home path as well and it all works really well it is not mine so i cant take no credit but it is a free sample and i have left the creater name in there but it works really well as i get a csv from sims copy and paste forename and sername use exel to create the rest and its done all i donow is copy and paste from csv to exel.

SHARE:
+ Post New Thread
Page 5 of 5 FirstFirst 12345

Similar Threads

  1. Active Directory - Single and Bulk User creation and FREE!!
    By siuko in forum How do you do....it?
    Replies: 39
    Last Post: 20th June 2012, 11:29 AM
  2. Bulk user Creation
    By Jamie_a in forum Windows
    Replies: 10
    Last Post: 14th January 2009, 06:30 PM
  3. Bulk folder creation
    By richard in forum How do you do....it?
    Replies: 3
    Last Post: 5th November 2007, 02:04 PM
  4. Bulk User Creation Tools
    By mark in forum Downloads
    Replies: 16
    Last Post: 10th July 2007, 04:24 PM
  5. Bulk folder Creation in Windows
    By scgf in forum How do you do....it?
    Replies: 21
    Last Post: 26th April 2007, 04:05 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •