+ Post New Thread
Results 1 to 6 of 6
How do you do....it? Thread, Need to add info to AD on bulk please help! in Technical; Oh Poo, thought it was too good to be true...... we have just gone google apps, and have set up ...
  1. #1

    Join Date
    Jun 2011
    Location
    Atherton
    Posts
    112
    Thank Post
    13
    Thanked 6 Times in 1 Post
    Rep Power
    8

    Exclamation Need to add info to AD on bulk please help!

    Oh Poo, thought it was too good to be true...... we have just gone google apps, and have set up brand new accounts for staff members and all is well.
    we use google AD sync which works great that it will only syncs info found in the AD (which it should).

    However, the student user accounts are historical, so some info is missing (or rather not in the right place).

    The first name and last name fields are not filled in AD however the info i need is in "display name" (see screen shot);

    This should be Bloggs Joe not Joe Bloggs

    Capture11.PNG

    without this info this is how the users appears in google;

    Capture12.PNG

    Is there a way, i can extract data from the "display name" field into excel, but have it split the "words" because of the space into different columns.....then somehow re-import it into First and last names in AD.........(and breath)

    I dont even know where to start with this..... and i've just sync'd 1100 accounts. there has to be a better way then one at a time.

    Any help would be greatly appreciated.

    Thanks
    Last edited by jahilton2002; 24th June 2013 at 10:16 AM.

  2. #2


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

  3. #3


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,800
    Thank Post
    231
    Thanked 883 Times in 759 Posts
    Rep Power
    300
    it should be possible its certainly possible to add users from scratch using excel so modifying using dsadd shouldnt be impossible.

  4. #4
    adhutton's Avatar
    Join Date
    Dec 2008
    Location
    Northeast England
    Posts
    407
    Thank Post
    164
    Thanked 88 Times in 65 Posts
    Rep Power
    55
    Another vote here for Bulk AD Users by Wisesoft - Bulk AD Users

    We use it all the time and its really good.

    Andrew

  5. #5

    Join Date
    Jun 2011
    Location
    Atherton
    Posts
    112
    Thank Post
    13
    Thanked 6 Times in 1 Post
    Rep Power
    8
    Quote Originally Posted by CyberNerd View Post
    That looks awesome! i'll have a read thx

  6. #6

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,560
    Thank Post
    721
    Thanked 1,682 Times in 1,497 Posts
    Rep Power
    432
    If you export the list to excel you can use the Convert Text to Columns Wizard to split the data for you.

    Ben

SHARE:
+ Post New Thread

Similar Threads

  1. how can i bulk add users to a an AD group
    By goodhead in forum Windows
    Replies: 5
    Last Post: 4th December 2008, 06:32 PM
  2. Script to add computers to AD like RIS
    By box_l in forum Scripts
    Replies: 2
    Last Post: 4th June 2008, 08:34 PM
  3. How to add clients to Altiris Deployment Solution
    By meastaugh1 in forum Thin Client and Virtual Machines
    Replies: 6
    Last Post: 16th May 2007, 10:04 PM
  4. Software to add title to an image
    By Kyle in forum How do you do....it?
    Replies: 3
    Last Post: 27th August 2006, 12:00 PM
  5. Replies: 24
    Last Post: 6th September 2005, 12:26 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
  •