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 10:16 AM.
it should be possible its certainly possible to add users from scratch using excel so modifying using dsadd shouldnt be impossible.
If you export the list to excel you can use the Convert Text to Columns Wizard to split the data for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)