User Management

User Management

1. New Employees

   • Open "EmployeeImport.xlsm"
     • Clear existing data
     • Connect to "a0safinsql02_efinanceplus finplus50 forefront_sql_sync"
     • Run "GetEmployeeInfo.vbs"
     • Sort A1 column by color "red" and insert blank line after "red" items
     • Run "EmployeeAccountCreation.ps1"
     • Clear old entries in "EduphoriaImport.csv" & "WelcomeList.csv". Leave header.
   • Open "EduphoriaImport.csv"
     • Remove "Substitues or Police officers"
     • Change "School Name" from Head Start to "Day Head Start, Rio Vista Head Start or Blackshear Head Start
     • Change "School Name" from Custodian to Maintenance
     • Access "https://sanangelo.schoolobjects.com"
     • "Management" - "Manage Users" - "Import Users"
     • Set pw to "welcome"

2. Update Employee Changes

   • Open "EmployeeImport.xlsm"
     • Clear existing data
     • Connect to "a0safinsql02_efinanceplus finplus50 forefront_sql_sync"
     • Run "GetEmployeeInfo.vbs"
     • Remove Ray, Tom, Cat and Perry from file
     • Run Macro, “ModifyEmployeeUserInformation”
     • Copy current file to Documents folder "EmpImports"