Need to add info to AD on bulk please help!

[Jaan]

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.

 

Thanks

Edited June 24, 2013 by Jaan

[CyberNerd]

Bulk AD Users

[sted]

it should be possible its certainly possible to add users from scratch using excel so modifying using dsadd shouldnt be impossible.

[adhutton]

Another vote here for Bulk AD Users by Wisesoft - Bulk AD Users

 

We use it all the time and its really good.

 

Andrew

[Jaan]

Bulk AD Users

 

That looks awesome! i'll have a read thx

[plexer]

If you export the list to excel you can use the Convert Text to Columns Wizard to split the data for you.

 

Ben