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 ...
24th June 2013, 11:10 AM #1
- Rep Power
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
without this info this is how the users appears in google;
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.
Last edited by jahilton2002; 24th June 2013 at 11:16 AM.
24th June 2013, 11:14 AM #2
24th June 2013, 11:14 AM #3
it should be possible its certainly possible to add users from scratch using excel so modifying using dsadd shouldnt be impossible.
24th June 2013, 11:17 AM #4
Another vote here for Bulk AD Users by Wisesoft - Bulk AD Users
We use it all the time and its really good.
24th June 2013, 11:17 AM #5
- Rep Power
That looks awesome! i'll have a read thx
Originally Posted by CyberNerd
24th June 2013, 12:06 PM #6
If you export the list to excel you can use the Convert Text to Columns Wizard to split the data for you.
By goodhead in forum Windows
Last Post: 4th December 2008, 07:32 PM
By box_l in forum Scripts
Last Post: 4th June 2008, 09:34 PM
By meastaugh1 in forum Thin Client and Virtual Machines
Last Post: 16th May 2007, 11:04 PM
By Kyle in forum How do you do....it?
Last Post: 27th August 2006, 01:00 PM
By ninjabeaver in forum Windows
Last Post: 6th September 2005, 01:26 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)