Right Reason Technologies Helpdesk

Guide to pulling a data extract from PowerSchool for import into RightPath™.

2. Students

  a. Set Enroll_Status = 0, click Search button beneath Search Students list

  b. You should see the "Current Records in selection change to a lower number.

  c. Click "Export Records" link.

  d. Grab these columns

    Student_Number

    First_Name

    Last_Name

    Gender

    Grade_Level

    SchoolID

    ID

    DOB

    Ethnicity

    Hispanic

    Migrant

    homeless

  a. Use Comma for field delimiter

  b. Set record delimiter to CRLF

  c. Use “” around fields

  d. Click Submit

  e. Name file <something>.csv

2. Staff

  a. Filter by Status = 1 and StaffStatus = 1

  b. Click Search

  c. Click Export

  d. Select these fields

    i. ID

    ii. First_Name

    iii. Last_Name

    iv. TeacherLoginID

    v. NY_StaffID

  e. Set options the same as above

3. Courses

  a. Select Courses

  b. Click Select All records

4. Sections

  a. Select Sections

  b. Filter by TermID >= 2200

  c. Click Search

  d. Click Export

  e. grab these columns

    i. ID

    ii. SchoolID

    iii. Course_Number

    iv. Expression

    v. Teacher

    vi. Section_Number

  f. Set options

  g. export

5. Roster

  a. Select CC

  b. Filter by termid >= 2200

  c. Click Search

  d. Click Export

  e. Grab these

    i. SectionID

    ii. StudentID