FTP Data Integration File Sample - FTP as Data Source

FTP File

1. Format: Required file format is Comma Delimited, with CSV file extension (.csv)
2. File Name: Name the file CESCourseUsers-mmddyyyyhhmm.csv, where MMDDYYYYHHMM is a date/time identifier to further identify the file.
3. Header Row: The file must contain a header row which includes the field names described below, separated by commas.

FTP File

1. NodePath: Where course resides in the Account Hierarchy (e.g., mycollege.department.program). This is an optional field, the same result can be achieved by using the Hierarchy Mapper feature to train the system to automate the course - department pairings.*
2. Code: The course code as displayed to users (Maximum 512 characters).
3. Title: The course title (Maximum 1024 characters).
4. UniqueID: The unique identifier for the course (Maximum 32 characters, and this field needs to be unique over time and project).
5. SurveyStart: The defined start date for Survey Access for this course.*
6. SurveyEnd: The defined end date for Survey Access for this course.*
7. AdminStart: The defined start date for administrator reporting access for this course.*
8. AdminEnd: The defined end date for administrator reporting for this course.*
9. InstructorStart: The defined start date for instructor reporting access for this course.*
10. InstructorEnd: The defined end date for instructor reporting access for this course.*
11. TAStart: The defined start date for teaching assistant reporting access for this course.*
12. TAEnd: The defined end date for teaching assistant reporting access for this course.*
13. UserTypeId: The code for user type, Instructor Code = 3, Students = 4 and Teaching Assistants = 6.
14. FirstName: The user’s first name (Maximum 128 characters).
15. LastName: The user’s last name (Maximum 128 characters).
16. Email: The user’s email address (Maximum 256 characters).
17. Username: The user’s Course Evaluations & Surveys username. (Maximum 60 characters).
18. Password: The user’s Course Evaluations & Surveys password (Maximum 16 characters).*

*These fields are optional, and can be omitted from the FTP file. When omitting fields from the file do not include the field name in the Header Row and omit data from Contents Rows.

Basic FTP File

1. Add File Header row.
   1. Code, Title, UniqueId, UserTypeId, Firstname, Lastname, Email, Username.
2. Each additional row in file indicates either a student, instructor or teaching assistant enrollment into a course following the fields indicated in the Header.

FTP File with Optional Fields

1. Add File Header row.
   1. Code, Title, UniqueId, SurveyStart, SurveyEnd, AdminStart, AdminEnd, InstructorStart, InstructorEnd, TAStart, TAEnd, UserTypeId, Firstname, Lastname, Email, Username, Password.
2. Each additional row in file indicates either a student, instructor or teaching assistant enrollment into a course following the fields indicated in the Header.

Selecting Courses, Students, Instructors and Teaching Assistants for a Project

1. Within the Courses Tab of a Project select FTP Data Import.
2. Using the Search feature in Step 1, Search/Filter the list of desired Courses to be added.
3. Select desired Courses.
4. Select Import Data, and Course information along with corresponding Student, Instructor and Teaching Assistant enrollments will be added to your project.

Updating Enrollments via FTP

1. To update a course’s enrollments FTP a new file which contains the current/updated enrollments for a course. This will OVERWRITE the previous enrollments for the course and adjust to the latest course enrollments in the FTP file. So, if a course unique id is included in a FTP file then it should include ALL enrollments in that course.
   1. Include any and all enrollments in the course
   2. Exclude any enrollments dropped from the course
2. Within the Users tab of a Project select FTP Student Enrollment Refresh, then schedule the date/time and frequency you wish to have the student enrollments refreshed for courses in the project. This step is required in addition to the above mentioned FTP step in order to update add/drop enrollments within a project.