User Tools

Site Tools


windows:sebeka_creating_ad_users

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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
 +
 +
 +
 +
  
windows/sebeka_creating_ad_users.txt · Last modified: 2014/01/22 13:17 by tschulz