Move data from LIBRUS to OFFICE365

Script helps school administrator to copy all classes and users to office365 environment

USAGE

edit config.js with valid login, password and domain to Microsoft Azure AD.
change runscript to one in scripts folder (without .ps1)

to run script use command:

$ npm run start

Scripts

add_users - parse csv from export folder, create new user accounts and enroll users to groups or unroll existing user from all groups then enroll to new from csv
purge_calendar - Delete all meetings from calendar
addClasses - parse csv from export folder and create new groups

CSV for import markdown (from librus export):

BOLD ARE REQUIRED FIELDS

Student.csv

SIS ID,School SIS ID,Username,First Name,Last Name,Password,State ID,Secondary Email,Student Number,Middle Name,Grade,Status,Mailing Address,Mailing City,Mailing State,Mailing Zip,Mailing Latitude,Mailing Longitude,Mailing Country,Residence Address,Residence City,Residence State,Residence Zip,Residence Latitude,Residence Longitude,Residence Country,Gender,Birthdate,ELL Status,FederalRace,Graduation Year

Teacher.csv

SIS ID,School SIS ID,Username,First Name,Last Name,Password,State ID,Teacher Number,Status,Middle Name,Secondary Email,Title,Qualification

StudentEnrollment.csv

Section SIS ID,SIS ID

TeacherRoster.csv