Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This is also a simple file that has the school number(s) and school name(s). Template is here:

View file
nameSchools.csv
Just download and fill out. This is also a .csv file.

File 3 - Classes.csv

This file is a listing of sections from PowerSchool and it needs to be exported from PowerSchool directly. First navigate to DDE (Direct Database Export. Data and Reporting > Export > Direct Database Export (DDE)

...

and select the Sections (3) table

...

You will want to do a search for term ID that is greater than or equal to the current year (3300):

...

Once you have your selection, click on the export records button. Fill in the export box with these fields:

ID
SchoolID
[2]Course_Name

This will give us the section ID, the school ID, and the course name. Set the field delimiter to “Comma” and export the file.

...

The file will export as “Sections.export.text” you will need to rename the file to “Classes.csv”

...

Students.csv