Mapping Student Data for Import – SchoolMint Hero

This article describes the process for mapping student data to import into SchoolMint Hero for System Administrators. Student data can be imported at the district-level or the school-level. Navigate to the relevant section for next steps:

District-Level Import
School-Level Import

District-Level Import

1. Before navigating to the Import page, go to Config > Schools and select the pencil edit icon on the first listed school. Input the School ID in the Reference ID box (or ensure the ID is already entered) and click Save.

2. Repeat this step for every school in the district.

CleanShot 2024-07-18 at 14.51.43.png

3. Next, navigate to the Imports page via Config > Imports. Click on Accounts in the upper right corner, then select + New Account.

4. Toggle ON "Group Level" and click Create. Copy the SFTP credentials and click Close.

5. Click on the Settings button in the upper right corner. Then select New Import in the upper right corner of the next page.

6. On the Import Settings page, make the following selections for a District-level import:

Select Group Level
Choose your district from the next dropdown. (The system will display a blue "Account Found" button if the SFTP setup in the previous steps was completed. If the system does not display "Account Found" please return to the beginning of these steps.)
Select Student Import
Select One Time if importing a one-time flat file or Daily if setting up automatic student imports. Then choose the Start Date (usually the current day).
Enter the email address of the user doing the import.
Save Settings

7. On the right side of the Import Settings page, select the relevant boxes:

Has Header - Check this if the import file has a header row
Notify On Success - Generally recommend leaving unchecked
Enable PGP Encryption - Generally recommend leaving unchecked
Remove Missing Records - Generally recommend leaving unchecked

CleanShot 2024-07-18 at 15.21.20.png

8. Determine if the upload should allow for any errors. This can be useful for large files with some broken data that cannot be easily cleaned.

9. Select the file for upload or click the Queue Import button if importing via SFTP.

Important: The import file name CANNOT contain spaces.

For example, the file name "School import list.csv" will NOT import whereas, "Schoolimportlist.csv" will import.

10. Complete Mapping. Save Mapping.

11. Click Queue Import.

School-Level Import

1. Before navigating to the Import page, go to Config > Schools and select the pencil edit icon for the school that will receive import data. Input the School ID in the Reference ID box (or ensure the ID is already entered) and click Save.

CleanShot 2024-07-18 at 14.51.43.png

2. Navigate to the Imports page via Config > Imports. Click on Accounts in the upper right corner, then select + New Account.

3. Leave the School Group Toggle OFF and select the relevant school from the dropdown and click Create. Copy the SFTP credentials and click Close.

4. Click on the Settings button in the upper right corner. Then select New Import in the upper right corner of the next page.

6. On the Import Settings page, make the following selections for a School-level import:

Select School Level
Choose the correct school from the second dropdown. (The system will display a blue "Account Found" button if the SFTP setup in the previous steps was completed. If the system does not display "Account Found" please return to the beginning of these steps.)
Select Student Import
Select One Time if importing a one-time flat file or Daily if setting up automatic student imports. Then choose the Start Date (usually the current day).
Enter the email address of the user doing the import.
Save Settings