Since CSV files are not formally-specified, a variety of implementations exist. For the Gradebook Import Scores From File option, CSV input files must meet the following criteria:

• The file can include a header row. If the CSV file has a header row, check File has Header Row when importing.
• The file can include multiple fields, but it must include fields for Student ID and the score to be imported.
• The file must use commas as a delimiters.
• Quotes are not permitted in fields.
• If spaces are present in a field, they are read during import.

How CSV files are read by the Import Scores from File option

• Since quotes are not permitted, fields cannot include commas (each comma is interpreted to delimit a new field).
• Scores are not checked when read from a CSV file. Any invalid scores are flagged after entry to the Gradebook Entry page.

Example file:

The example below has a header row, five columns, and six student records. The Student ID is in column 2, and the student's score is in column 4.

Grade,Student ID,Student Age,Score,Homeroom

10,107769,15,92,4C-117

10,106732,16,C,4C-117

11,102531,16,88,3B-222

9,109441,14,77,2A-247

10,105321,15,A,4C-119

10,107621,15,69,4C-117

For this input file, the Import Scores From File selections would be:

Text files can include a header row. If the file has a header row, check File has Header Row when importing. All data is referenced by a record's horizontal position, so each field must contain the same number of characters.

How text files are read by the Import Scores from File option

• If a text file record has no data in any of the specified Student ID Positions or Score Positions, an error is generated.
• Scores are not checked when read from a text file. Invalid scores are flagged after entry to the Gradebook Entry page.

Example file:

The example file below holds the same student and score information as the above example and likewise includes a header row. Since data is stored by position in text files, each field selected for input must have the appropriate number of characters to be read properly. In this example, the header row lists each field's position.

Grade (1-2) Student ID (3-8) Student Age (9-10) Score (11-12) Homeroom (13-18)

1010776915924C-117

1010673216 C4C-117

1110253116883B-222

0910944114772A-247

1010532115 A4C-119

1010762115694C-117

For this input file, the Import Scores from File selections would be:

Related Topics

Gradebook Page Overview

Entering Gradebook Scores