windows:sebeka_creating_ad_users
Creating Users for Sebeka Schools
Infinite Campus
login as tschulz
select all schools
go to Ad Hoc Reporting→Data Export
Select Student Export→New Student Logins
export as CSV
CSV
open CSV copy new student rows
open student_logins.xls
paste into New Students worksheet
in column F paste username formula e.g. row 67
=LOWER(CONCATENATE(14-E67+12,LEFT(C67,1),B67))
copy new user rows into Student Logins worksheet
Gmail
copy new user rows into gmail_script worksheet
copy user data into gam rows e.g.
gam create user <USERNAME> firstname <FNAME> lastname <LNAME> password <PASSWORD> changepassword off agreedtoterms off
Creating users in AD
copy new user rows from student_logins.xls:New Students into a fresh text file save as csv
select Students→import
on DC01 run Active User Manager run New User Wizard
align columns in New User Wizard and import
assign new users to correct groups (this is essential for network drives to map correctly)
lastly move users to their correct OU
windows/sebeka_creating_ad_users.txt · Last modified: 2014/01/22 13:17 by tschulz