Zusammenfassung der Ressource
User Management
- 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"
- 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"