Auto-Importing Student Rosters

Enriching Students allows a school to automatically import roster data; every night if the data changes that frequently.  The process involves several steps:

• Exporting student data from your Student Management System (SMS)
• Posting the files to our server via FTP

Exporting the Data

The first step involves exporting the data from your SMS. 

The file generated must:

• Be a comma separated file
• The first line must read StaffId,StudentId,CourseName.  The headers are NOT case-sensitive.  However, there shouldn't be an spaces in the header names.  So, StaffId, not Staff Id. Also, there should be no comma at the end of the line.

The overall format is the same as the original import file used to set up the school.  If you have any questions about the file form, please refer to the documentation here.

Because there are a large number of SMS, we are not able to provide any technical support regarding either exporting your data or setting up an automated process for sending the files to us via FTP.

Data Validation

During the import, the file is validated in the following ways:

• The file name must be valid.  The file name has to match this format:
  
  
• IMPORTKEY-roster.csv.  The ImportKey is a value that has been assigned to your school.  This can be found by logging on to the site and going to Settings -> Configuration. (Note, you must be an admin to access this portion of the site.  If you are not an admin, contact someone in your school who is in order to get this information.)
  
  
• The phrase ROSTER (case-insensitive) has to follow the import key.  This allows us to understand it's a student file we're dealing with.
  
  
• If the file name does not follow this format, the file will NOT be imported.
  
  
• All data is validated as described in the original import documentation. Any failures will cause the import process to fail.

Two import points to keep in mind:

• Do NOT include homeroom assignments.  Homerooms are created when the student data is uploaded.  If you need to move students to a new homeroom, upload a new student file.
• ALL other rosters must be included.  The process removes students from their existing assignments and reassigns based on the data provided.  That means that all student should be included in the file.

 The import process is set to run at 9:00 PM UTC-8; (West Coast Time in the US.)

How Do I Upload the File

In order to upload the files, you will need to set up your FTP process with a valid User Id and password and point to the correct location on our server  All of this information can be found by logging on to Enriching Students and going to Settings -> Configuration.