Data File Creation Process
Process for Automated Upload of Student/Staff Data to an External Vendor System
- 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.
- ECISD Project Contact and ECTO Contact meet with vendor to identify the data file(s) elements needed and fills out Data Request Form.
- Once the Data Request form is complete, it is submitted to Mr. Selby (iTCCS Liason).
- 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.
- Process is complete when data is flowing nightly into the external vendor system.
Example of Process in Action
- Need for providing an instructional intervention for students in grades 3-8 to facilitate differentiation.
- 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.
- 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.
- 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)
- 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)