Hero’s SFTP information:
- Host: sftp://sftp.hero.schoolmint.com
- Port: 2022
- Account ID & Password: This is created in SchoolMint Hero. System Administrators can generate and share these credentials with relevant individuals.
SFTP Mapping Information
Use the tables below to identify required data (column 3) and recommend data for upload in SchoolMint Hero. Recommended data is highlighted in yellow.
Student Demographics
Hero Database Field Name | Field Name | Required (Y/N) | Field Size (Characters) | Data Type |
Student.SchoolID | School ID | YES | 50 | Text |
Student.StudentID | Student ID | YES | 50 | Text |
Student.FirstName | First Name | YES | 20 | Text |
Student.LastName | Last Name | YES | 20 | Text |
Student.Grade | Grade | YES | 5 | Text |
Student.MiddleInitial | Middle Initial | NO | 50 | Text |
Student.BirthDate | Birth Date | NO | 10 | Text |
Student.Address | Address | NO | 50 | Text |
Student.City | City | NO | 50 | Text |
Student.State | State | NO | 50 | Text |
Student.Country | Country | NO | 50 | Text |
Student.Zip | Zip | NO | 10 | Text |
Student.Teacher | Teacher | NO | 50 | Text |
Student.HomePhone | Home Phone | NO | 50 | Text |
Student.WorkPhone | Work Phone | NO | 50 | Text |
Student.ContactPhone | Contact Phone | NO | 50 | Text |
Student.Guardian | Guardian | NO | 50 | Text |
Student.EmergencyContact | Emergency Contact | NO | 50 | Text |
Student.Notes | Notes | NO | 512 | Text |
Student.HomeRoom | Home Room | NO | 50 | Text |
Student.StudentEmail | Student Email | NO | 512 | Text |
Student.StudentLanguage | Student Language | NO | 10 | Text |
Student.GuardianEmail | Guardian Email | NO | 255 | Text |
Student.Gender | Gender | NO | 20 | Text |
Student.EthnicCode | Ethnic Code | NO | 20 | Text |
Student.ReferenceID | Reference ID | NO | 50 | Text |
Student Schedules
Hero Database Field Name | Field Name | Required (Y/N) | Field Size (Characters) | Data Type |
Student.StudentID | Student ID | Yes | 50 | Text |
Student.ReferenceID | Reference ID | No | 50 | Text |
StudentSchedule.Term | Term | Yes | 50 | Text |
StudentSchedule.Period | Period | Yes | 50 | Text |
StudentSchedule.Course | Course | Yes | 50 | Text |
StudentSchedule.Instructor_LastName | Instructor Last Name | Yes | 50 | Text |
StudentSchedule.Instructor_FirstName | Instructor First Name | No | 50 | Text |
StudentSchedule.RoomNumber | Room Number | No | 50 | Text |
StudentSchedule.CourseNumber | Course Number | No | 50 | Text |
StudentSchedule.Section | Section | No | 50 | Text |
StudentSchedule.Instructor_Code | Instructor Code | Yes | 50 | Text |
Faculty Data
Hero Database Field Name | Field Name | Required (Y/N) | Field Size (Characters) | Data Type |
Instructor_SchoolID | Instructor SchoolID | Yes | 50 | Text |
Instructor_Code | Instructor Code | Yes | 50 | Text |
Instructor_LastName | Instructor Last Name | Yes | 50 | Text |
Instructor_FirstName | Instructor First Name | Yes | 50 | Text |
Instructor _Email | Instructor Email | Yes | 255 | Text |
Note: The Faculty Data import will need 2 additional fields added manually. This means that when exporting this file from your SIS, you must edit it to add 2 fields and save it as a .CSV file, then import the file to the SFTP. Files cannot have spaces in the name. Added fields:
|
Comments
0 comments
Please sign in to leave a comment.