untitled article

Sharon Parbhakar Updated by Sharon Parbhakar

Staff License load to ODS 2025

Job is scheduled to load Staff license to ODS every AM from the below PPsft file as the source .

Input File from Peoplesoft : D:\BPS Pub\ftproot\PeopleSoftFiles\BPS_ALL_LICENSE_AND_ENDORS.txt

Script Location : D:\Ed-Fi\StaffLicenseYS\StaffLicenseAspenCsvToEdFiAPINewFormatODS2025.ps1

GET Request through EdFIApi : https://edfi.mybps.org:443/s3v5ys/api/data/v3/2025/my-bps/staffLicenses

Following fields from source are converted to Json for the POST to ODS

Input file fields 

StaffId,GradeLevel,LicenseNo,IssueDate,ExpireDate,License,LicenseDescription,LicenseStage,LicenseStatus,Accomp

Conversion in Case of following strings in file

Case > LicenseDescription

LicenseDescription -Contains "Sheltered Eng Immersion - Tch" >> “Sheltered English Immersion - Teacher"

Case > GradeLevel

GradeLevel -Contains "Grade" >> $GradeLevel -replace "Grade", "Grades"

Case > Stage

Stage -Contains "Initial - Extension" >> "Initial Extension"

Stage -Contains "Emergency - Extension" >> "Emergency"

Case > Status

Status -Contains "Invalid: RETELL/SEI Restricted" or "Invalid: RETELL/SEI Restricted" >> Invalid: RETELL/SEI R

Status -Contains "Licensed: RETELL/SEI Restricted or Status -Contains "Licensed: RETELL/SEI Restricted >> "Licensed: RETELL/SEI R"

Status -Contains "Inactive/Invalid: RETELL/SEI Restricted" >>"Inactive/Invalid: RETELL/SEI R"

Error Logs >> D:\BPS Pub\ftproot\PeopleSoftFiles\Logs ( 20 days old log files are deleted through script)

How did we do?

Work from Home (WFH) Tips

Contact