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.