Versions Compared

Version Old Version 2 New Version Current
Changes made by

Leo Yoon

Leo Yoon

Saved on

Key

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

...

Managing SFTP Connection in PowerSchool

This process will require PowerSchool to be connected to create a new connection to the SFTP in your district’s PowerSchool.

Info

If there are issues connecting PowerSchool to your SFTP, please be sure to white-list the PowerSchool IP Address on your SFTP server.

To add a new connection in PowerSchool:

...

Info

For enrolling student courses, an AutoComm Record must be made for every school in your PowerSchool which will be participating in course enrolment through SchoolEngage.

If you wish to increase the frequency of writing back to PowerSchool, multiple AutoComm records must be made for each time per participating school.

To add a new AutoComm Record:

  1. Change your PowerSchool’s selected school in the top right of your screen (It cannot be set to District Office)

  2. Navigate to System Management > Data > AutoComm Records

  3. Click New

  4. Set the following fields as noted (Fields not mentioned are optional):

    1. Table to Import - Student schedules

    2. When to Execute -

    3. Days to Execute - Monday - Sunday or Monday - Friday

    4. Uncheck Turn Execution Off

    5. Get Input From - Managed Connection

      1. Select the connection you created in Managing SFTP connection in PowerSchool

    6. Path - the path to the course enrolment file, including the file itself

      1. Example: /CourseEnrolment/SE_CourseEnrolment_111_1111.tsv

        1. The file’s name follows the following syntax (please contact the SchoolEngage team to get the correct numbers)

          1. SE_CourseEnrolment_

        123

          1. <PsId>_

        2318

          1. <PsSchoolId>.tsv

    7. Field Delimiter - Tab

    8. Character Set - CRLF

    9. Character Set - Mac Roman

    10. Sort Order - 0

    11. PowerSchool fields to import into (Order matters) -

      1. Studentid

      2. Termid

      3. Course_Number

      4. Section_Number

      5. Dateenrolled

...