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.
AutoComm Import
If you are not familiar with AutoComm please refer to PowerSchool’s Import and Export User Guide or contact your PowerSchool representative.
AutoComm will import data into PowerSchool® that has been extracted from the SchoolMint Hero. No disciplinary information is transferred with AutoComm; only attendance related data or Trac Codes.
In the AutoComm Setup window select “New”. The AutoComm Record window will open.
Populate the AutoComm Record screen with the following information for the SchoolMint Hero export:
| Field | Value | Comments |
| Name | REQUIRED: Title for the AutoComm indicating type of import | |
| Table to Import | Attendance | REQUIRED: Select from dropdown list |
| When to Execute | REQUIRED: Select a time after the data is exported from the DEM | |
| Days to Execute | MTWHF | REQUIRED: The AutoComm should run every day |
| Turn Execution Off | LEAVE FIELD BLANK / UNCHECKED | |
| Send Output to | MANAGED CONNECTION SchoolMint Hero SFTP Connection | |
| Path | REQUIRED: Enter the path where Hero Export is sending the data and the file name: export/export_file_name.txt NOTE: Hero places all exports into the export folder. This location needs to be reverenced with the file name as referenced above | |
| Field Delimiter | Tab | REQUIRED: Select from dropdown list |
| Record Delimiter | LF | REQUIRED: Select from dropdown list |
| Character Set | Windows ANSI | REQUIRED: Select from dropdown list |
| Sort Order | LEAVE FIELD BLANK / UNCHECKED | |
| Synchronize Mode | LEAVE FIELD BLANK / UNCHECKED | |
| Update existing records… | YES | REQUIRED: Check this box |
| Mark students… | LEAVE FIELD BLANK / UNCHECKED | |
| First record… | LEAVE FIELD BLANK / UNCHECKED | |
| Email completion report… | Enter in email address of IT, School or System Administrator | |
PowerSchool fields to import into:
Attendance Field | SchoolID Student_Number Course_Number Section_Number Att_Date Attendance Code Period Abbreviation | REQUIRED: Enter fields exactly as shown. Select “Attendance Field” List from the drop down menu in the Field column |
| Duplicate this on… all schools Duplicate this on…district | LEAVE FIELD BLANK / UNCHECKED LEAVE FIELD BLANK / UNCHECKED | |
The information below for “PowerSchool fields...” can be copied from this document and in most cases pasted into the area. This will alleviate any typographical errors:
SchoolID
Student_Number
Course_Number
Section_Number
Att_Date
Attendance Code
Period Abbreviation
After all required fields are populated, select “Submit” to save the AutoComm import settings.
Comments
0 comments
Article is closed for comments.