This shows you the differences between two versions of the page.
— |
windows:sebeka_creating_ad_users [2014/01/22 13:17] (current) tschulz created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== 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<file> | ||
+ | =LOWER(CONCATENATE(14-E67+12,LEFT(C67,1),B67)) | ||
+ | </file> | ||
+ | - 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. <file> | ||
+ | gam create user <USERNAME> firstname <FNAME> lastname <LNAME> password <PASSWORD> changepassword off agreedtoterms off | ||
+ | </file> | ||
+ | |||
+ | ===== 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 | ||
+ | |||
+ | |||
+ | |||
+ | |||