+ 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,081
    Thank Post
    210
    Thanked 431 Times in 311 Posts
    Rep Power
    145

    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
    55
    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,850
    Thank Post
    110
    Thanked 598 Times in 514 Posts
    Blog Entries
    1
    Rep Power
    227
    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
    55

    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,061
    Thank Post
    69
    Thanked 79 Times in 62 Posts
    Rep Power
    36
    Does ADModify fit the bill?

    HBJB

  6. #6

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,081
    Thank Post
    210
    Thanked 431 Times in 311 Posts
    Rep Power
    145
    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
    761
    Thank Post
    56
    Thanked 192 Times in 127 Posts
    Rep Power
    102
    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
    426
    Thank Post
    74
    Thanked 43 Times in 39 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, 07:32 PM
  2. bulk adding users into open dir
    By goodhead in forum Mac
    Replies: 1
    Last Post: 16th May 2008, 03:34 PM
  3. Replies: 3
    Last Post: 11th January 2008, 08:02 PM
  4. Bulk Remove Users from OU?
    By indiegirl in forum How do you do....it?
    Replies: 11
    Last Post: 17th August 2006, 04: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
  •