Hero is capable of exchanging data with PowerSchool® via our Hero Import tool and PowerSchool® AutoSend and AutoComm features. If you are not familiar with Managed Connections, AutoSend or AutoComm settings, please refer to PowerSchool’s Import and Export User Guide.
Creating a Managed Connection (SFTP Connection) in PowerSchool
A managed connection is required to send information to or from PowerSchool via secure FTP (SFTP).
In PowerSchool navigate to Setup > System > System Settings > Plugin Management Configuration.
Click Remote Connection Manager. On the Remote Connection Manager page click Manage Remote Connection. Next, click Create Connection.
In the Create Connection Screen, enter the following:
| Name | Hero SFTP Connection |
| Description | |
| Protocol | SFTP |
| Host | sftp://sftp.hero.schoolmint.com |
| Port | 2022 |
| Username | These are created in SchoolMint Hero. System Administrators can generate and share these credentials with relevant individuals. |
| Password | |
| Confirm Password | |
| Allow Download | CHECK BOX |
| Allow Upload | CHECK BOX |
Click Test Connection. If this is the first connection to the Hero SFTP you will be prompted to accept the host key fingerprint. Click Yes, Accept Host KEY.
Click SUBMIT to save the remote connection.
Sending data to Hero SFTP
AutoSend Setup and AutoComm Setup are located in Setup > System > System Administrator main menu. If you do not see these options, your PowerSchool login may not have the appropriate permissions.
AutoSend
If you are not familiar with the AutoSend and AutoComm settings, please refer to PowerSchool’s Import and Export User Guide.
Hero requires 3 AutoSend exports from PowerSchool:
- Student Demographics
- Schedule Information
- Teacher Information
The accuracy and consistency of the exports are critical for data returned to PowerSchool.
Student Demographics AutoSend Export
Select AutoSend Setup from Select New on the AutoSend Setup screen.
| Field | Value | Comments |
| Name | REQUIRED: Title for the AutoSend i.e. Hero Student Info | |
| Data to Send | Students | REQUIRED: Select from dropdown list |
| When to Execute | REQUIRED: Select a time for the export i.e. 3:00 AM | |
| Days to Execute | MTWHF | REQUIRED: The AutoSend should run every day |
| Turn Execution Off | LEAVE BOX BLANK / UNCHECKED | |
| Send Output to | MANAGED CONNECTION Hero SFTP Connection | |
| Path | REQUIRED: Enter a file name i.e. STUDENT.TXT | |
| Field Delimiter | Tab or Comma | REQUIRED: Select from dropdown list. TAB is preferable |
| Record Delimiter | CRLF | REQUIRED: Select from dropdown list |
| Sort Order | LEAVE FIELD BLANK | |
| First record… | LEAVE FIELD BLANK / UNCHECKED | |
| Include “upload_type” | LEAVE FIELD BLANK / UNCHECKED | |
| Attendance-Specific Settings | Send any Attendance modified in last 24 Hours | REQUIRED: Select from a bullet list |
| Student Specific settings | ||
| Email completion report… | Enter in email address of IT, School or System Administrator | |
Fields to Export Attendance Field List | Student_Number First_Name Last_Name Middle_Name DOB Mailing_Street Mailing_City Mailing_State Mailing_Zip GuardianEmail Home_Phone Grade_Level | REQUIRED: Enter fields exactly as shown. Select “Attendance Field List” List from the drop down menu in the Field column |
| Duplicate this… all schools | LEAVE FIELD BLANK / UNCHECKED | |
| Duplicate this… district office | LEAVE FIELD BLANK / UNCHECKED | |
After all required fields are populated, click “Submit” to save the AutoSend export settings.
Schedule Information AutoSend Export
Select New on the AutoSend Setup screen (the AutoSend export created previously should appear on this screen).
| Field | Value | Comments |
| Name | REQUIRED: Title for the AutoSend i.e. Hero Schedule Info | |
| Data to Send | Students Schedule | REQUIRED: Select from dropdown list |
| When to Execute | REQUIRED: Select a time for the export i.e. 3:10 AM | |
| Days to Execute | MTWHF | REQUIRED: The AutoSend should run every day |
| Turn Execution Off | LEAVE FIELD BLANK / UNCHECKED | |
| Send Output to | MANAGED CONNECTION Hero SFTP Connection | |
| Path | REQUIRED: Enter a file name i.e. SCHEDULE.TXT | |
| Field Delimiter | Tab or Comma | REQUIRED: Select from dropdown list. TAB is preferable |
| Record Delimiter | CRLF | REQUIRED: Select from dropdown list |
| Sort Order | LEAVE FIELD BLANK | |
| First record… | LEAVE FIELD BLANK / UNCHECKED | |
| Include “upload_type” | LEAVE FIELD BLANK / UNCHECKED | |
| Attendance-Specific Settings | Send any Attendance modified in last 24 Hours | REQUIRED: Select from a bullet list |
| Student Specific settings | ||
| Email completion report… | Enter in email address of IT, School or System Administrator | |
Fields to Export Attendance Field List | Schoolid [01]student_number termid course_number [02]course_name section_number Period Expression [05]last_name [05]first_name [03]room teachernumber | REQUIRED: Enter fields exactly as shown. Select “Attendance Field List” List from the drop down menu in the Field column |
| Duplicate this… all schools | LEAVE FIELD BLANK / UNCHECKED | |
Duplicate this… district office | LEAVE FIELD BLANK / UNCHECKED | |
After all required fields are populated, select “Submit” to save the AutoSend export settings.
Teacher Information AutoSend Export
Select New on the AutoSend Setup screen (the AutoSend export created previously should appear on this screen).
| Field | Value | Comments |
| Name | REQUIRED: Title for the AutoSend i.e. Hero Teacher Info | |
| Data to Send | Teacher | REQUIRED: Select from dropdown list |
| When to Execute | REQUIRED: Select a time for the export i.e. 3:20 AM | |
| Days to Execute | MTWHF | REQUIRED: The AutoSend should run every day |
| Turn Execution Off | LEAVE FIELD BLANK / UNCHECKED | |
| Send Output to | MANAGED CONNECTION Hero SFTP Connection | |
| Path | REQUIRED: Enter a file name i.e. TEACHER.txt | |
| Field Delimiter | Tab or Comma | REQUIRED: Select from dropdown list. TAB is preferable |
| Record Delimiter | CRLF | REQUIRED: Select from dropdown list |
| Sort Order | LEAVE FIELD BLANK | |
| First record… | LEAVE FIELD BLANK / UNCHECKED | |
| Include “upload_type” | LEAVE FIELD BLANK / UNCHECKED | |
| Attendance-Specific Settings | Send any Attendance modified in last 24 Hours | REQUIRED: Select from a bullet list |
| Student Specific settings | ||
| Email completion report… | Enter in email address of IT, School or System Administrator | |
Fields to Export Attendance Field List | Schoolid [05]last_name [05]first_name teachernumber email_addr teachernumber status | REQUIRED: Enter fields exactly as shown. Select “Attendance Field List” List from the drop down menu in the Field column |
| Duplicate this… all schools | LEAVE FIELD BLANK / UNCHECKED | |
| Duplicate this… district office | LEAVE FIELD BLANK / UNCHECKED | |
After all required fields are populated, select “Submit” to save the AutoSend export settings.
Comments
0 comments
Article is closed for comments.