ar-k12code/rti_scheduler

RTI_Scheduler

These scripts come without warranty of any kind. Use them at your own risk. I assume no liability for the accuracy, correctness, completeness, or usefulness of any information provided by this site nor for any sort of damages using these scripts may cause.

DO NOT INSTALL THESE SCRIPTS TO A DOMAIN CONTROLLER.

Create a dedicated VM running Windows Server 2019 or Windows 10 Pro 1809+ for your automation scripts.

Requirements

Git - https://git-scm.com/download/win

PowerShell 7 - https://github.com/PowerShell/PowerShell/releases

CognosModule - https://github.com/AR-k12code/CognosModule

Installation instructions:

Open powershell 7 (pwsh.exe)as an administrator.

In the command window paste the following:

cd c:\scripts
git clone https://github.com/AR-k12code/RTI_Scheduler
cd c:\scripts\RTI_scheduler
Copy-Item sample_settings.ps1 settings.ps1

Open the settings file and put your API token in, School Name and the number from RTI_scheduler.

You can generate a new RTI Scheduler token by going to "Data Sync API > Authentication > Generate New Token"

Attendance from Cognos to RTI Scheduler

.\RTIScheduler_Attendance.ps1

This script will pull the current days attendance and submit it to the RTI Scheduler.

Attendance from RTI Scheduler to eSchool

YOU NEED TO UNDERSTAND WHAT YOU'RE DOING BEFORE EVER RUNNING THIS SCRIPT Refer back to the disclaimer and liability warning at the top!

.\RTIScheduler_Upload_ATT_to_eSchool.ps1 -RunMode [V|R]

This script will pull the attendance from RTI Scheduler for the RTI Period and upload the absence to eSchool. This script by default runs in Verification mode. Meaning it will not actually make the changes on the eSchool Database Tables. You must run it with the parameter -RunMode R after you have sufficiently tested this process.

This process requires the ESMU6 upload defintion from the eSchoolModule. You can run the following command to create it.

New-eSPAttUploadDefinitions

Roadmap

• Ignore duplicate/failed schedule stuff

rti_scheduler's Issues

Order of RTI Data Sync API uploads

First off, thanks for publishing this repository! What an awesome way to share the Cognos integration script with other schools.

One minor issue I noticed while glossing over the script was the order in which the uploads are done. If you are running this script for the first time on a school, the ordering is important because the different objects are created on separate transactions.

Minor issue, because it only causes incomplete data the first 1 or 2 times you run it.

Example:
You can specify Instructor IDs within the Student Sync to set an advisory/homeroom instructor on each student record. But if your Instructor sync has never previously run, the Student Sync will result in warnings because the Instructor would not be found. The sync will still run, but the advisors would be missing.

It looks like Line 53 of RTIScheduler.ps1 can just its order changed to this to fix the issue. I don't have any sort of access to Cognos to test the entirety of this script.
@('Courses','Instructors','Students','Schedule','Performance') | ForEach-Object {