Instructions
-
Review the details of student data fields that you can import into Naviance.
-
Note the required data fields and determine the recommended and optional fields you also want to import for students.
-
Download the student data import template from the Naviance Knowledge Base in the PowerSchool Community. Select PowerSchool Community from the Get Help menu in Naviance to access the Community.
-
Prepare the data to import using the template as a guide. The school-level student data import supports over 50k rows of data.
-
Import the data via a manual data import or an automated data import using SchoolSync.
To import data fields not supported by Clever, eSchoolPlus SIS, or PowerSchool SIS, Naviance recommends importing those fields using a manual data import or by setting up an automated data import with SchoolSync™.
Student import fields
Alternatively, review the PowerSchool SIS Student Data Field Mapping information or the eSchoolPlus SIS Student Data Field Mapping information if importing your student course data via a PowerSchool Data Integration.
|
Data field |
Requirement |
Example |
Information |
Import method |
|---|---|---|---|---|
|
Student ID |
Required |
340LJ10 |
The unique identification number assigned to a student by the school or district. |
|
|
Class Year |
Required |
2022 |
Must use a four-digit class year, not a grade level. |
|
|
Last Name |
Required |
Garcia |
The last name of the student. |
|
|
School ID |
Required in a district-level import only. |
925 |
Use the School ID numbers entered in your account settings. |
|
|
Enrollment Status |
Optional |
Graduated Active |
The enrollment status of the student in the Student Information System. This is used to determine if a student is active, inactivate, graduated, or transferred out of the school or district. |
|
|
First Name |
Recommended |
Anita |
The student's legal name. Required for college applications. |
|
|
Date of Birth |
Required for eDocs otherwise recommended |
11/15/2005 |
Must use one of these formats:
|
|
|
Student Email |
Required if setting up SAML SSO and using email as the Federation Type, otherwise recommended |
Students managing their username and password can reset their own password when an email address is available in their Naviance account. |
||
|
Federated ID |
Required if setting up SAML SSO and using Federated ID as the Federation Type, otherwise not needed |
hobsonss00000012349 |
If setting up SAML SSO, do not add Federated ID if you use email as the Federation Type. |
|
|
Naviance Student Username |
Required if setting up SAML SSO otherwise optional |
angarcia |
If you assign students a username, you must generate and distribute temporary passwords for students. |
|
|
Middle Name |
Optional |
Rose |
The legal name required for college applications. |
OneRoster (middle initial) |
|
Nickname |
Optional |
Nita |
The nickname of the student. |
|
|
State Student ID |
Optional |
483923 |
The state assigned student identification number. |
|
|
Gender |
Optional |
X |
Use a consistent code for this field. The standard gender categories are:
|
|
|
Counselor ID |
Optional |
Gardner 892140 |
Create counselor accounts in Naviance before importing student counselor assignments. Counselor ID can be the employee ID number if entered when creating the user account. |
|
|
Original Class Year |
Optional |
2021 |
The year the student is expected to graduate upon entering the 9th grade. Sometimes referred to as a Cohort Year. |
|
|
Homeroom |
Optional |
Garcia A103 204 |
Set up homerooms in individual school accounts first. Homerooms that you import must match the homerooms set up in Naviance. |
|
|
Ethnicity |
Optional |
BLA HIS ASN |
Use a consistent code. Standard ethnicity categories are:
|
|
|
Street Address 1 |
Optional |
123 19th St. SW 2400 Maple Lane |
The student's physical or mailing address. |
|
|
Street Address 2 |
Optional |
#45 |
The student's physical or mailing address. |
|
|
City |
Optional |
Lincoln Washington |
The student's physical or mailing address. |
|
|
State |
Optional |
NE Maine |
The student's physical or mailing address. |
|
|
Zip Code |
Optional |
20041 |
The student's physical or mailing address. |
|
|
Country |
Optional |
US |
The student's physical or mailing address. |
|
|
Citizenship 1 |
Optional |
US |
Enter the two-letter ISO country code for primary and secondary citizenships. |
|
|
Citizenship 2 |
Optional |
CA |
Enter the two-letter ISO country code for primary and secondary citizenships. |
|
|
GPA |
Optional |
3.9 |
The student's grade-point average, enter up to four decimal places. |
|
|
Weighted GPA |
Optional |
4.2 |
The student's weighted student grade-point average, enter up to four decimal places. |
|
|
Rank |
Optional |
150 |
An integer representing the student's rank in class. |
|
|
Decile |
Optional |
5 |
An integer representing the student's rank in terms of decile. |
|
|
AP Courses |
Optional |
4 1 |
Enter the number of AP or Honors classes the student is enrolled in. |
|
|
Home Phone |
Optional |
202-123-4567 |
The home phone number of the student. |
|
|
Mobile Phone |
Optional |
301-345-2345 |
The mobile phone number of the student. |
|
|
Counselor Comments |
Optional |
Anita is a member of the National Junior Tennis Team. |
A note about the student. |
|
|
Group 1 |
Optional |
LUN ATH |
To assign students to a group, create Groups in Naviance first. If assigning students to more than one group, add additional data columns labeled Group 2, Group 3, etc. |
|
|
FERPA Block Requested |
Required for Alumni Tracker otherwise optional |
Yes No |
Use a consistent code in this field. The standard request statuses are no and yes. If blank, FERPA Block Requested will be no. |
|
|
Graduation Date |
Required for Alumni Tracker otherwise optional |
6/29/2022 |
Use one of these six formats:
|
|
|
Diploma Type |
Required for Alumni Tracker otherwise optional |
GED Regular Diploma |
Use a consistent code in this field. Standard diploma types are:
|