Importing extended contact records to Gradelink can be done in just a few clicks. The key to success is ensuring your data is extremely clean and normalized. Like tidying up a room or garage by sorting everything into properly labelled bins, cleaning up data ensures records are easy to retrieve and reporting is accurate.
- Ensure any student accounts associated to the transcript records you import have been added or imported to the Students page.
- Download the import template, a .csv (comma separated value) formatted file.
- Paste your date into the template. Below are the columns and what should go in them.
- Save the template file, and drag it to the Upload area.
- Click Submit
If any errors are detected in your upload, the import gets completely aborted (no records imported) and we'll present a returned .csv file that includes specific error notations.
Field | Examples | Required? | Explanation |
SISStudentID | 123456 | Yes | Student's unique ID number from originating system. If no prior ID available, enter student's Gradelink ID. |
Contact #1 First Name | Mary | No | First name of contact 1. |
Contact #1 Last Name | Smith | No | Last name of contact 1. |
Contact #1 Relationship | Grandmother | No | Relationship of contact 1. |
Contact #1 Street Addr. | 1234 Anystreet Ave. | No | Street address of contact 1. |
Contact #1 City | Anytown | No | City of contact 1. |
Contact #1 State | CA | No | State of contact 1. |
Contact #1 Zip/Postal | 99999 | No | Zip or postal code of name of contact 1. |
Contact #1 Phone | 555-123-4567 | No | Phone number of contact 1. |
Contact #1 Email | [email protected] | No | Email address of contact 1. |
Contact #1 Role Permission | Emergency Contact; Authorized for pickup; NOT Authorized for pickup | No | Roles/permissions of contact 1, separated by semicolon (;) |
Contact #2 First Name | Bill | No | First name of contact 2. |
Contact #2 Last Name | Jones | No | Last name of contact 2. |
Contact #2 Relationship | Uncle | No | Relationship of contact 2. |
Contact #2 Street Addr. | 9876 Somewhere Cir. | No | Street address of contact 2,. |
Contact #2 City | Anytown | No | City of contact 2, |
Contact #2 State | CA | No | State of contact 2, |
Contact #2 Zip/Postal | 99999 | No | Zip or postal code of name of contact 2. |
Contact #2 Phone | 555-987-6543 | No | Phone number of contact 2. |
Contact #2 Email | [email protected] | No | Email address of contact 2, |
Contact #2 Role Permission | Emergency Contact; Authorized for pickup; NOT Authorized for pickup | No | Roles/permissions of contact 2, separated by semicolon (;) |
Contact #3 First Name | Christina | No | First name of contact 3. |
Contact #3 Last Name | Heartwell | No | Last name of contact 3. |
Contact #3 Relationship | Doctor | No | Relationship of contact 3. |
Contact #3 Street Addr. | 1000 Medical Way | No | Street address of contact 3. |
Contact #3 City | Anytown | No | City of contact 3. |
Contact #3 State | CA | No | State of contact 3. |
Contact #3 Zip/Postal | 99999 | No | Zip or postal code of name of contact 3. |
Contact #3 Phone | 555-246-8012 | No | Phone number of contact 3. |
Contact #3 Email | [email protected] | No | Email address of contact 3. |
Contact #3 Role Permission | Emergency Contact; Authorized for pickup; NOT Authorized for pickup | No | Roles/permissions of contact 3, separated by semicolon (;) |