Teachers' Curriculum Institute

Technical Documentation - Scheduled Rostering with SFTP

TCI offers several options to manage and distribute subscriptions for teachers and students. These options include adding individual new users, transferring individual existing users, and managing multiple users by uploading a CSV file TCI's online subscription management tool.

This documentation provides an overview of the process involved with setting up a scheduled rostering solution with an SFTP directory.

Overview
  1. Customer SIS creates CSV files. (details below)
  2. Customer SIS places CSV files into TCI SFTP.
  3. TCI uploads both teacher and student CSV files.
  4. CSV files are processed into TCI’s roster database.
  5. Additionally, if customer implements single sign-on with auth tokens, TCI drops student CSV export in TCI SFTP.
Details for Step 1: Customer SIS creates CSV files 
  • Customer SIS creates CSV files 
‚Äč

  • Teacher CSV
    • Column 1
      • Name: ‘email’
      • Description: teacher email address
    • Column 2
      • Name: ‘first_name’
      • Description: teacher first name
    • Column 3
      • Name: ‘last_name’
      • Description: teacher last name
    • Column 4
      • Name: ‘password’
      • Description: teacher password
    • Column 5
      • Name: ‘password_confirmation’
      • Description: teacher password again
    • Column 6
      • Name: ‘program_code’
      • Description: program code from TCI system
      • Note: To find program codes, log into TCI as a subscription manager or coordinator and click on Programs tab
    • Guidelines
      • One row per teacher seat (e.g. 2 rows for single teacher with 2 programs)
      • Any teachers excluded from the file will have all programs removed
      • All field values required for new teachers
      • Password and Password Confirmation optional for existing teachers
      • Passwords entered must be at least 6 characters

  • Student CSV
  • Column 1
    • Name: ‘first_initial’
    • Description: desired value to recognize student
  • Column 2
    • Name: ‘last_name’
    • Description: desired value to recognize student
  • Column 3
    • Name: ‘username’
    • Description: student login
  • Column 4
    • Name: ‘password’
    • Description: student password
  • Column 5
    • Name: ‘password_confirmation’
    • Description: student password again
  • Column 6
    • Name: ‘teacher_email’
    • Description: email address of student’s teacher for this program
  • Column 7
    • Name: ‘program_code’
    • Description: program code from TCI system
    • Note: To find program codes, log into TCI as a subscription manager or coordinator and click on Programs tab
  • Column 8
    • Name: ‘class_period’
    • Description: period number of student’s classroom
  • Guidelines
    • One row per student seat (e.g. 2 rows for single student with 2 programs)
    • Any students excluded from the file will have all programs removed
    • All field values required for new students
    • Password and Password Confirmation optional for existing students
    • Passwords entered must be at least 6 characters
    • Referenced teachers must be registered in TCI system before adding students associated with the teacher
    • Username must be unique
    • Username can only contain letters [a-z], numbers [0-9], dashes [-] or underscores [_]

Did you find this article helpful?