+ Post New Thread
Results 1 to 9 of 9
How do you do....it? Thread, Rename Users in bulk? in Technical; Morning all, The current school I work in has it's user names setup using a yeargroup prefix, i.e Year7 is ...
  1. #1

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,067
    Thank Post
    209
    Thanked 430 Times in 310 Posts
    Rep Power
    144

    Rename Users in bulk?

    Morning all,

    The current school I work in has it's user names setup using a yeargroup prefix, i.e Year7 is 07, Year8 is 08, year9 is 09 etc. They have been renaming the accounts every year

    I want to standardise this to the more commonly used year of entry prefix that I think most schools use, (all the ones I've worked in anyway) Is there anyway of doing this in bulk through RM CC3 or Active directory, or is it really a case of renaming each account seperately? If I were to do this in active directory, would RM CC3 pick up on the change, or does any account modification have to be done in CC3 its self?

    Many thanks,

    Mike.

  2. #2
    cromertech's Avatar
    Join Date
    Dec 2007
    Location
    Cromer by the coast
    Posts
    731
    Thank Post
    177
    Thanked 109 Times in 97 Posts
    Rep Power
    54
    Quote Originally Posted by maniac View Post

    I want to standardise this to the more commonly used year of entry prefix that I think most schools use,
    Just as an aside or maybe a suggestion we use the students admission no. for their logon prefixed with a q (eg q1234 etc).

    I find this works quite well as this number moves with them through each year and I just have to put them in a corresponding OU thats reflects year of entry.

    Other than that I'm not sure if it's possible to batch change the users although I batch import them with a script so it may be possible. I'll look into it and return later

  3. #3

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,804
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    The VBS script discussed in this thread should be able to do what you want.

    Update Active Directory User Attributes from a CSV File

  4. #4
    cromertech's Avatar
    Join Date
    Dec 2007
    Location
    Cromer by the coast
    Posts
    731
    Thank Post
    177
    Thanked 109 Times in 97 Posts
    Rep Power
    54

    Lightbulb VBscript to rename users

    I think it can be done using things from here
    VBScript Tutorial create a user account. Example from Excel spreadsheet
    and here Bulk rename of user accounts in Active Directory - Active Directory. I'm going to see if I can get something to work just for fun

  5. #5
    Heebeejeebee's Avatar
    Join Date
    Nov 2006
    Location
    Intergalactic Cruise
    Posts
    1,056
    Thank Post
    69
    Thanked 77 Times in 61 Posts
    Rep Power
    35
    Does ADModify fit the bill?

    HBJB

  6. #6

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,067
    Thank Post
    209
    Thanked 430 Times in 310 Posts
    Rep Power
    144
    Quote Originally Posted by cromertech View Post
    Just as an aside or maybe a suggestion we use the students admission no. for their logon prefixed with a q (eg q1234 etc).

    I find this works quite well as this number moves with them through each year and I just have to put them in a corresponding OU thats reflects year of entry.
    I think 'YearOfEntry,Surname,Firstname' is easier for this school, as I bet no students know their admission number, and getting this information out to all students at the beginning of next year would be difficult without annoying the staff too much, and as I've only been here 2 weeks, I don't want to start annoying them quite yet! I also know students will forget it too easily as well.

    I don't think the change I want to make is going to go down well anyway, as apparently they've been doing it the same way for years so staff are accustomed to the way things are so the smaller the change is, the better really. Good suggestion thou.

    Thanks for the options that people have suggested, ADmodify looks like it might just do the job, but anyone know if it will mess up CC3? I know I'm going to have to re-create all the profiles in their new names, and do a lot of messing around with home areas, but will CC3 complain about the username changing? I'm just aboout to try it anyway.

    Cheers,

    Mike.

  7. #7
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    You could also use admodify or Wisesoft Bulk Modify

  8. #8
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    728
    Thank Post
    53
    Thanked 188 Times in 124 Posts
    Rep Power
    101
    I know CC4 maintains it's own database, so changing usernames in AD would break it. I'm not sure if the same would hold true for CC3. You could try creating a test account and change the username in AD and then test to ensure CC3 throws up no errors before changing anything in bulk.
    How were the usernames changed annually previously?

  9. #9
    FishCustard's Avatar
    Join Date
    Feb 2013
    Location
    Croydon
    Posts
    425
    Thank Post
    74
    Thanked 42 Times in 38 Posts
    Rep Power
    19
    Quote Originally Posted by clareq View Post
    I know CC4 maintains it's own database, so changing usernames in AD would break it. I'm not sure if the same would hold true for CC3. You could try creating a test account and change the username in AD and then test to ensure CC3 throws up no errors before changing anything in bulk.
    How were the usernames changed annually previously?
    It does indeed hold true for CC3 - making pretty much any change in AD save for resetting passwords runs a high risk of borking the CCx DB entry for that user.

SHARE:
+ Post New Thread

Similar Threads

  1. Active Directory-Script for Creating Bulk Users
    By calapso in forum How do you do....it?
    Replies: 8
    Last Post: 14th January 2009, 06:32 PM
  2. bulk adding users into open dir
    By goodhead in forum Mac
    Replies: 1
    Last Post: 16th May 2008, 02:34 PM
  3. Replies: 3
    Last Post: 11th January 2008, 07:02 PM
  4. Bulk Remove Users from OU?
    By indiegirl in forum How do you do....it?
    Replies: 11
    Last Post: 17th August 2006, 03:23 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
  •