Data File Creation Process

Process for Automated Upload of Student/Staff Data to an External Vendor System

  1. Given a need, a technology-based intervention or assessment tool is desired--that aligns to "The EC Way," of course--that requires student/staff data imports on a regular basis.
  2. ECISD Project Contact and ECTO Contact meet with vendor to identify the data file(s) elements needed and fills out Data Request Form.
  3. Once the Data Request form is complete, it is submitted to Mr. Selby (iTCCS Liason).
  4. When data file(s) are received and tested successfully, ECTO Contact will ensure the file gets to the vendor nightly via automated, secure file transfer process.
  5. Process is complete when data is flowing nightly into the external vendor system.

Example of Process in Action

  1. Need for providing an instructional intervention for students in grades 3-8 to facilitate differentiation.
  2. Curriculum Director contacts ECTO Director and a joint meeting takes place. After speaking with vendor, a comma-delimited file needs to be created that contains students' firstname, lastname, campus, student ID#, TSDS#, District username and password is needed nightly. A tentative start date is set for when this is needed.
  3. A Data Request form is prepared mapping iTCCS data element names to what the vendor needs an item to be called, then submittted to Mr. Selby for submission to ESC-20.
  4. Once ESC-20 has finished create the student data file, ESC-20 saves it to the ECISD SFTP Server. ECTO staff sets up an automated process to transfer the file to the vendor so they can process it nightly (e.g. 2:05am)
  5. Curriculum Director and end users (e.g. teachers in Grades 3-8) verify that information in vendor system is up to date.

Data File Creation Process (Current)