+ Post New Thread
Page 4 of 5 FirstFirst 12345 LastLast
Results 46 to 60 of 64
How do you do....it? Thread, Bulk user creation in Technical; that's far too scarey for me to understand PS - Limbo - I assume that's you Neil?...
  1. #46

    Join Date
    Aug 2005
    Location
    Aldridge, Walsall
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Bulk user creation

    that's far too scarey for me to understand

    PS - Limbo - I assume that's you Neil?

  2. #47
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,938
    Thank Post
    114
    Thanked 272 Times in 250 Posts
    Rep Power
    104

    Re: Bulk user creation

    Quote Originally Posted by SpuffMonkey
    Quote Originally Posted by ChrisH
    We have been talking about us all doing such a program between is Here . We have yet to decide on a language but maybe you could get in on this as well.
    Found this after some long winded Googling

    http://www.tech-geeks.org/geeklog/ar...896&mode=print

    Might be a good starting place - am going to have a play with it shortly

    Cheers
    I have coded a very similar script myself and I'm going to put a GUI on it this afternoon if I get the chance.
    For the project we are looking at using vb.net so the code will be different. We may be adding other stuff by the look of it as well like the program the ICTNUT has written to deal with finding certain file types in home directories and dealing with them etc.

  3. #48

    Join Date
    Jul 2005
    Location
    Wolverhampton
    Posts
    100
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Bulk user creation

    Guys, I have a Q - seen as how the majority of skills "seems" to be in VB6, why r u thinking of doing it in VB.NET (which is vastly different from VB6) ? Y not just use VB6 as this would stop people from having to get new software and transfer skills.
    Before anyone says it, VB6 will still work nicely on XP (and Vista I hope) and it terms of running the apps created by either there is not a big difference for the type of things being discussed here.

  4. #49
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,938
    Thank Post
    114
    Thanked 272 Times in 250 Posts
    Rep Power
    104

    Re: Bulk user creation

    Just moving with the times. The entire scope for what we are going to do isnt final yet so who knows... I know what your saying about VB6 and the current scope of what were doing but it's good to have the option of some more functionality. I'm sure most would like to update their skills anyway

  5. #50

    russdev's Avatar
    Join Date
    Jun 2005
    Location
    Leicestershire
    Posts
    6,873
    Thank Post
    650
    Thanked 534 Times in 353 Posts
    Blog Entries
    3
    Rep Power
    200

    Re: Bulk user creation

    Yes i think that is the main reason we want to improve our skill set...

    The other thing is making sure that program remains accesably at moment vb 6 runs on vista 2 years down line it may not... where as .net is going to...

    Also vb6 has lots of failings and when you are working with controling windows and servers these failings become obvious....

    Anyway go add your views and two pences worth...

    Russ

  6. #51
    eduabncs's Avatar
    Join Date
    Aug 2005
    Location
    somewhere in the midlands
    Posts
    394
    Thank Post
    31
    Thanked 21 Times in 19 Posts
    Rep Power
    27

    Re: Bulk user creation

    Paul....I think we can safely assume it's Neil!

    Who else can actually get something like that to work!

  7. #52
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    24

    Re: Bulk user creation

    Ah - my cover is blown, and with such a cunning user name too!

    We are still using vb6 here to do all our coding (although a great deal of what we do is then converted into asp so that it can be done through the web - taking away the need to be at a particular machine - or even at a particular site!)

    We have got full site licenses for vb.net through our Microsoft Schools agreement but, as it appears many of you have also found, the motivation to relearn all over again in a new interface is very difficult to find.

  8. #53
    OverWorked's Avatar
    Join Date
    Jul 2005
    Location
    N. Yorks
    Posts
    1,003
    Thank Post
    195
    Thanked 42 Times in 34 Posts
    Rep Power
    29

    Re: Bulk user creation

    I mentioned that I use CSVDE a while ago, and only one other person also uses it. I don't understand why it's so unpopular. I've found it quite easy to use.

    All the hard work is done in creating the Excel spreadsheet, which isn't that hard. Just use formulas to generate the usernames and distinguished names from the pupils real names. Then export as a CSV.

    All you need is one simple command:-

    CSVDE -i -f filename.csv


    Open up AD Users and computers. Check they're in the correct OU, and that the home folders and profile paths are correct. If not, it's easy to change them en masse in Server 2003. (It is much harder to do this in 2000 Server though, better to delete them, edit the spreadsheet, and do it again).

    The hard part was the first time I used it, working out the columns needed for the CSV.

    There, that's my 2p worth.

  9. #54

    Dos_Box's Avatar
    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    9,464
    Thank Post
    524
    Thanked 1,993 Times in 932 Posts
    Blog Entries
    23
    Rep Power
    575

    Re: Bulk user creation

    Yes, but compared to exporting a list of new pupils from <insert schools management DB software here) in csv format and then pointing your user creation software at it it gets ugly (hense the formulas etc) With a dedicated piece of software we can also create other options to be created\imported at the same time such as extra user details, adresses etc. All quicker and easier than piddling around in Excel and command lines.
    Please also remember that some of our members are not techies but ictco-ords and don't have the time to do things like that.

  10. #55
    OverWorked's Avatar
    Join Date
    Jul 2005
    Location
    N. Yorks
    Posts
    1,003
    Thank Post
    195
    Thanked 42 Times in 34 Posts
    Rep Power
    29

    Re: Bulk user creation

    OK, point taken.

    I probably have it fairly easy as the usernames are given to me as a spreadsheet (created manually by a teacher). I'm also quite comfortable with Excel, which I admit, a lot of people aren't. (Comes from boring office jobs I had before entering IT properly).

    ...

    I can't believe I'm doing this. I don't work summer holidays. I'm sat at home supposedly studying for my MCSA whilst my family are out shopping. And all I'm doing is talking about work-related stuff. Ir's time to sign off.

  11. #56

    Dos_Box's Avatar
    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    9,464
    Thank Post
    524
    Thanked 1,993 Times in 932 Posts
    Blog Entries
    23
    Rep Power
    575

    Re: Bulk user creation

    You can't be that overworked if you don't work the holidays

  12. #57

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    12,963
    Thank Post
    586
    Thanked 1,494 Times in 1,340 Posts
    Rep Power
    397

    Re: Bulk user creation

    I think I will have to look into the edu price of vb.net as I am also used to vb6.

    Ben

  13. #58

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,582
    Thank Post
    107
    Thanked 761 Times in 592 Posts
    Rep Power
    179

    Re: Bulk user creation

    Quote Originally Posted by plexer
    I think I will have to look into the edu price of vb.net as I am also used to vb6.

    Ben
    You could take a look at the 'Express' version.

  14. #59

    Join Date
    Jun 2006
    Posts
    38
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Bulk user creation

    This may help some with a bit of modification to suit your setup.

    Reads from a excel workbook. I had the user names/passwords etc given to me so it doesnt do that, only adds them to an ou in AD. You will have to change paths/domains/ etc but its a start

    Code:
    'User names etc must be on sheet1 of the workbook.  The columns can be in any order - adjust the Cells value below to suite. 
    'An OU must be created on the server - the script wont do it!!
    
    'Usage
    'Copy the this script and the user Excel workbook to the server and double click to run.
    
    
    ' Possible Edits 
    '---------------------------------------------------------------------------------------------------
    'objExcel.Cells(intRow, 5)    =    5 is the column number to read. 
    '("C:\Scripts\New_users.xls")   =   Path to the Excel workbook
    'ou=NewUser,  =  choose an OU to suite, I addthem to "NewUsers" then moved them later.
    '---------------------------------------------------------------------------------------------------
    
    
    'open workbook
    Set objExcel = CreateObject("Excel.Application")
    Set objWorkbook = objExcel.Workbooks.Open ("C:\Scripts\New_users.xls")
    
    'int to count rows
    intRow = 1
    
    'loop until end of sheet1 adding the users to AD
    Do Until objExcel.Cells(intRow,1).Value = ""
    	'set up the user
        Set objOU = GetObject("LDAP:// ou=NewUsers, dc=elginacad, dc=edu, dc=uk")
        Set objUser = objOU.Create("User", "cn=" & objExcel.Cells(intRow, 5).Value)
      	objUser.Put "sAMAccountName", objExcel.Cells(intRow, 5).Value 'samaccount name eg LawsoE
      	objUser.Put "userPrincipalName", objExcel.Cells(intRow, 5).Value ' account name eg LawsoE
    	objUser.sn = objExcel.Cells(intRow, 4).Value ' users Surname
    	objUser.givenname = objExcel.Cells(intRow, 3).Value 'users Forename
    	objUser.displayname = objExcel.Cells(intRow, 3).Value & " " & objExcel.Cells(intRow, 4).Value ' Forename and Surname
    	objUser.SetInfo
    	'set users password properties
    	objUser.ChangePassword "",objExcel.Cells(intRow, 7).Value ' users Password		
    	objUser.userAccountControl = 65536 
    	objUser.AccountDisabled = FALSE
    	objUser.SetInfo
    	'set users profile properties
    	objUser.Put "homeDirectory", "\\primergy\users\%username%"
    	objUser.Put "homeDrive", "U:"
    	objUser.Put "profilePath", "\\primergy\Profile\%username%"
    	objUser.Put "scriptPath", "login.bat"
    	objUser.SetInfo
        intRow = intRow + 1
    Loop
    
    'display msg box when finished
    MsgBox "Done"
    'quit Excel
    objExcel.Quit

  15. #60
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,938
    Thank Post
    114
    Thanked 272 Times in 250 Posts
    Rep Power
    104

    Re: Bulk user creation

    Thanks i will add that to the scripts section later.

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

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
  •