How to Minimize Upload Failures for Parent CSV Files

Securly’s web filtering solution relies on CSV files provided by schools to establish accurate student-parent relationships and send student activity reports to parents. To ensure that reports are delivered to the correct parent inbox, it is crucial that schools adhere to the guidelines outlined here when uploading their CSV files.

Tips

• The name of the CSV file should be parents.csv.
• A header line specifying each column name is essential.
• The header line must include: Parent First Name, Parent Last Name, Parent Email, Student First Name, Student Last Name, Student Email.
• Column names are not case sensitive.
• The student email must belong to your school domain or sub-domain. Other email addresses will be rejected during file upload.
• Student email ID or parent email ID cannot be the same as admin email ID.
• Student email ID and guardian/parent email ID cannot be the same.
• Ensure that you do not include any special characters ( ", (), *, ><, /) in either the Parent First Name, Parent Last Name, Student First Name, or Student Last Name columns.
• Column names may be in any order.
• More than one parent email or more than one student email on one line are not allowed. Each line of the CSV should establish a 1:1 mapping between student and parent.
• If the CSV file contains more than 70,000 lines, you might experience upload failure.
• Please contact support@securly.com for assistance.
• Below is a blank template that may be downloaded:

  Securly Parent Import Template.csv

Correct Formatting

• Header line: Parent First Name, Parent Last Name, Parent Email, Student First Name, Student Last Name, Student Email
• Subsequent lines: Will, Smith, willsmith@gmail.com, Sam, Tyrell, samtyrell@schooldomain.com

Incorrect Formatting

• Header line does not separate first and last names.
• Header line: Parent Name, Parent Email, Student Name, Student Email
• Subsequent lines: Will, willsmith@gmail.com, Sam, samtyrell@schooldomain.com

• Admin email is provided as parent email or student email.
• Header line: Parent Name, Parent Email, Student Name, Student Email
• Subsequent lines: Will, admin@schooldomain.com, Sam, samtyrell@schooldomain.com

• Multiple students on one line.
• Header line: Parent Name, Parent Email, Student Name, Student Email
• Subsequent lines: Will, willsmith@gmail.com, Sam, samtyrell@schooldomain.com, Jon, jonsnow@schooldomain.com

Following the above guidelines will allow you to successfully upload your CSV files to the Securly solution and keep parents updated about their kid’s online activity.

Download a blank copy of the template below.