CSV File Format Help

Header

The file import action looks for a single “header” line at the top of the input file that maps out where the various required fields are. After the header line, the individual student records follow below. For example:

flemailidteam
JudithDiazjudith.diaz@sysiphus.com2000001
VictoriaPricevictoria.price@sysiphus.com2000011
LeighSnyderleigh.snyder@sysiphus.com2000021
RodneyBartonrodney.barton@sysiphus2000031

The “First”, “Last”, “Email”, and “ID” fields are required in all input files. The columns in the header can be in any order, as long as the field names are correct.

The field names in the header are not case-sensitive. For any of the fields, you can also just enter the first letter of the field name as shown above (“f” instead of “First”). The exception is “Sex”, which must be spelled out to distinguish it from “Section.” Do not include anything in the header fields except the expected field names. While “First” and “f” are both valid header field names, “First Name” is not valid. Similarly, “email” is valid, but “e-mail” is not.

Required fields

First and Last name

Max Length: 20 characters

Allowed characters: letters, numbers, hyphen, space, apostrophe, period

NOTE: Your input file is allowed to have the “First” and “Last” name fields combined together in a single field. For example:

Last: First, Email, ID, Team, Section

Miller: Chase, chase@sysiphus.com, 1010111, Squirrels, Tues [… etc …]

When the first and last names are combined in a single field, the names don’t have to be separated by colons– ANY character or set of characters will work (for example, commas or semicolons). Also, the first and last names can appear in any order. What’s important here is that the “header” line expresses whatever character(s) are used to separate the first and last names and the order in which the names will appear.

Email

Student’s email address

Max Length: 40 characters

Allowed characters: something that appears to be a valid email address

ID

Student’s personal university ID number

Max Length: 15 characters

Allowed characters: letters, numbers, hyphen, and space

NOTE: If you are concerned about privacy issues, you may make up a different ID number for the student purely for use in this system. However, please be consistent across multiple surveys.

Extra fields for Team-Maker Surveys

Sex

The student’s gender

Max Length: N/A

Allowed characters: the value in this field must begin with an ‘M’ or an ‘F’ (case is unimportant)

Students can also identify their gender within the Team-Maker Survey if you ask for that information.

GPA

The student’s current overall GPA

Max Length: N/A

Allowed characters: must be a valid decimal number between 0.0 and 5.0

Pre

The student’s grade in an associated previous or prerequisite course for this class.

Max Length: N/A

Allowed characters: must either be a numeric grade (a valid decimal number between 0.0 and 5.0), a letter grade (“A”-“F” with an optional “+”/”-” afterward; “E” and “F” are equivalent), or “P”/”F” (representing pass/fail grades)

Extra Fields for Peer Evaluation Surveys

Team

The name of the team the student has been assigned to

Max Length: 30 characters

Allowed characters: letters, numbers, hyphen, space

The “Team” field is required when loading data for CATME Peer Evaluation surveys. This field is simply ignored when importing data into Team-Maker surveys.

Section

The name of the class section the student is enrolled in

Max Length: 10 characters

Allowed characters: letters, numbers, hyphen, space

The “Section” field is optional and only used when loading class lists for “multi-section” surveys. You can skip this field entirely if you do not need to define multiple sections.