How to minimize upload failures for CSV files

Follow

Securly’s web filtering solution depends upon 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 right parent inbox, it is crucial that schools follow the guidelines given here when uploading their CSV files.

 Tips

  • A header line specifying each column name is essential.
  • 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 would be rejected during file upload.
  • Student email ID or parent email ID cannot be the same as admin email ID.
  • 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 would 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.

 

Have more questions? Submit a request

Comments