+ Post New Thread
Page 1 of 3 123 LastLast
Results 1 to 15 of 41
Windows Thread, AD Bulk User Creation Utility with extras? in Technical; I know this pops up quite a bit but might have a slight twist for us so here goes... Basically ...
  1. #1
    gshaw's Avatar
    Join Date
    Sep 2007
    Location
    Essex
    Posts
    2,709
    Thank Post
    175
    Thanked 226 Times in 208 Posts
    Rep Power
    68

    AD Bulk User Creation Utility with extras?

    I know this pops up quite a bit but might have a slight twist for us so here goes...

    Basically all our students are part-time and until now we've been OK with a shared area and machine-based logins. However time has caught up and getting some more "inquisitive " students means it's probably time to implement logins. Also with VLE finally making strides I'd like to be using the LDAP authentication to keep everything tidy.

    So basically what I need a bit of software to do is...

    - take a CSV-exported list from our MIS software that has the following info firstname, lastname, studentID

    - automatically create a username by combining the firstname and lastname e.g. joe.bloggs

    - automatically handle any duplicates e.g. adding a number on the end etc and notifying of these at the end

    - set the password as the student ID, never expire, cannot be changed

    - set group membership

    - set mandatory profile path

    Anyone know of such software that fits the bill? So far I've looked at the Wisesoft speadsheet (nice but CSV import seems to be a pain, PowerShell cmdlets (got 1/2 way there then got stuck with the duplicates and also profile path setting) and a few others that seemed to do 1/2 the job...

    Info much appreciated as always
    Last edited by gshaw; 9th June 2009 at 02:49 PM.

  2. #2


    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,274
    Thank Post
    123
    Thanked 345 Times in 284 Posts
    Blog Entries
    4
    Rep Power
    139
    VBScript can do all of this quite happily.

    Hey Scripting Guy! How Can I Create Users from a CSV File?

    A bit of string parsing, and adding some statements to assign variables to the right attributes on each user and you're done.

  3. #3

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,610
    Thank Post
    746
    Thanked 1,706 Times in 1,519 Posts
    Rep Power
    437
    We use ad bulk import from Active Directory Tools, Active Directory Software

    Ben

  4. #4
    gshaw's Avatar
    Join Date
    Sep 2007
    Location
    Essex
    Posts
    2,709
    Thank Post
    175
    Thanked 226 Times in 208 Posts
    Rep Power
    68
    Quote Originally Posted by jamesb View Post
    VBScript can do all of this quite happily.

    Hey Scripting Guy! How Can I Create Users from a CSV File?

    A bit of string parsing, and adding some statements to assign variables to the right attributes on each user and you're done.
    What about duplicates though? String parsing... sounds a bit too close to programming for me

  5. #5


    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,274
    Thank Post
    123
    Thanked 345 Times in 284 Posts
    Blog Entries
    4
    Rep Power
    139
    Its not that difficult. A few StrLeft commands, and for duplicates just throw in some error checking which adds a number after the username if the script kicks back with 'object already exists'.

    Edit: Having said that the bulk user creation tool that plexer recommends is probably going to be easier.
    Last edited by jamesb; 9th June 2009 at 04:08 PM.

  6. #6
    Cools's Avatar
    Join Date
    Jan 2009
    Location
    Bedfordshire
    Posts
    498
    Thank Post
    24
    Thanked 62 Times in 57 Posts
    Rep Power
    25
    Im with ben on this..
    Active Directory Tools, Active Directory Software
    so easy and no farting about..

  7. #7
    Hedghog's Avatar
    Join Date
    Jul 2006
    Location
    North Wales
    Posts
    194
    Thank Post
    35
    Thanked 17 Times in 16 Posts
    Rep Power
    38
    I agree with the others either a VBscript or AD import. Since SIMS tends to output in an excel CSV file I tend to juggle name etc in that (I've got a template that does it) then import the correct data.

    Cheers

    Peter

  8. #8

    Join Date
    Feb 2009
    Posts
    460
    Thank Post
    66
    Thanked 34 Times in 21 Posts
    Blog Entries
    1
    Rep Power
    19
    Quote Originally Posted by plexer View Post
    Is this program worth $99? also is it avalible in UK pricing and if not how do you buy it for the school?

  9. #9
    gshaw's Avatar
    Join Date
    Sep 2007
    Location
    Essex
    Posts
    2,709
    Thank Post
    175
    Thanked 226 Times in 208 Posts
    Rep Power
    68
    There's another one I've just been recommended called AD Infinitum, so far quickest and cleanest interface of the ones I've tested... just need to see if it can do the custom passwords now...

    Edit: none of these so far have been bright enough to auto generate the login or object names... no need for a program if I have to do the hard work in the CSV file... all I want to supply it with is a first name, last name and password then auto generate the rest... am I missing something here
    Last edited by gshaw; 9th June 2009 at 04:32 PM.

  10. #10

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,610
    Thank Post
    746
    Thanked 1,706 Times in 1,519 Posts
    Rep Power
    437
    Depends on your username format I suppose.

    Yes the programs should provide you with a customisable template I suppose for the username however stirng editing like that is so easy in excel anyway.

    Ben

  11. #11

    Join Date
    Feb 2009
    Posts
    460
    Thank Post
    66
    Thanked 34 Times in 21 Posts
    Blog Entries
    1
    Rep Power
    19
    Quote Originally Posted by gshaw View Post
    There's another one I've just been recommended called AD Infinitum, so far quickest and cleanest interface of the ones I've tested... just need to see if it can do the custom passwords now...

    Edit: none of these so far have been bright enough to auto generate the login or object names... no need for a program if I have to do the hard work in the CSV file... all I want to supply it with is a first name, last name and password then auto generate the rest... am I missing something here
    you can just do a concotonate in one cell and fill down - 2mins work if the file is otherwise prepared

  12. #12
    IrritableTech's Avatar
    Join Date
    Nov 2007
    Location
    West Yorkshire
    Posts
    926
    Thank Post
    116
    Thanked 215 Times in 175 Posts
    Rep Power
    73
    Active User Manager??

    Active User Manager

    Its free..

  13. #13

    Join Date
    Feb 2009
    Posts
    460
    Thank Post
    66
    Thanked 34 Times in 21 Posts
    Blog Entries
    1
    Rep Power
    19
    Quote Originally Posted by terrorvis View Post
    Active User Manager??

    Active User Manager

    Its free..
    I'm pretty sure this is what we have on our current domain but we don't use at the moment - am I being dopy or does this not create the user Dir?

  14. #14
    Cools's Avatar
    Join Date
    Jan 2009
    Location
    Bedfordshire
    Posts
    498
    Thank Post
    24
    Thanked 62 Times in 57 Posts
    Rep Power
    25
    have a look at ...
    JustLDAP Bulk Import Sample

  15. #15
    IrritableTech's Avatar
    Join Date
    Nov 2007
    Location
    West Yorkshire
    Posts
    926
    Thank Post
    116
    Thanked 215 Times in 175 Posts
    Rep Power
    73
    Quote Originally Posted by DAckroyd View Post
    I'm pretty sure this is what we have on our current domain but we don't use at the moment - am I being dopy or does this not create the user Dir?
    If you go into action and preferences, you can change the user defaults. This allows you to create home directories, set permissions, quotas, profile directories, and even create a file structure to set in place.

    Although I tend to just place \\server\share\%username% in the users home directory field in standard Users and Computers, then it creates the home directory anyway.

    I'm pretty sure AUM will do everything you want it to. Check the user guide for more clarification.

  16. Thanks to IrritableTech from:

    DAckroyd (9th June 2009)



SHARE:
+ Post New Thread
Page 1 of 3 123 LastLast

Similar Threads

  1. Windows Server 2008: Bulk User Creation
    By DAckroyd in forum Windows Server 2008
    Replies: 4
    Last Post: 3rd February 2009, 09:25 PM
  2. Bulk user Creation
    By Jamie_a in forum Windows
    Replies: 10
    Last Post: 14th January 2009, 07:30 PM
  3. bulk user creation
    By jonbones in forum Network and Classroom Management
    Replies: 1
    Last Post: 18th June 2008, 11:43 AM
  4. Bulk User Creation Tools
    By mark in forum Downloads
    Replies: 16
    Last Post: 10th July 2007, 05:24 PM
  5. Bulk user creation
    By Dos_Box in forum How do you do....it?
    Replies: 63
    Last Post: 13th November 2006, 08:02 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
  •