I work for a school and we are mass importing students into AD from our Student Information System. We essentially need four bits of information for the import: First name, last name, year of graduation and school. Using this info we should be able to construct several other fields which we need.

Example - Given data:

First name: Jon

Last: Doe

Year of Graduation: 2016 - we have a custom attribute in AD which stores this.

School: HighSchool

Using this data we have so far been able to create an advanced naming template to create our usernames: jdoe16.

However we now need to create several other fields for the user to be created:

Description: We need this to read :"Student - Year of Grad" ex: "Student - 2016"

OU should be set as: "Domain\School\Students\Year of Grad" ex: Domain\HighSchool\Students\2016\

Home Directory should be set as: "\\fileserver\students\year of grad\username" ex: \\fileserver\students\2016\jdoe16

Set Group Membership to year of grad group: ex: Students - 2016

As you can see we only need a small amount of data and then can reuse that data to organize the info. We only have those four parts of info available to us. While we could certainly use excel to manipulate the import each time our goal is to use automation to automatically create new students when they are entered into our Student Information System. 

Any input on how to accomplish this would be greatly appropriated.

Thanks