Schedule recurring exports of grade data to an SFTP server. Auto-exports support final grades, grade items, and grading scales.
Before configuring auto-export, ensure the following:
-
Sections are assigned to grading periods.
-
Courses have a course code.
-
Sections have a section code or section school code.
-
Unpublished items are not included in grade exports.
Configure auto-export
-
Select Tools and choose School Management.
-
Select Export.
-
Select Auto-Export.
-
Enter SFTP server credentials in the Default SFTP Configurations area. If you use auto-import, the SFTP configuration may be the same.
-
Select + Export Process.
-
Configure the export settings. Refer to the Export settings descriptions for more information.
-
Select Column Headers to choose which columns to include in the export.
-
Select Save.
Depending on server load, the export process may take up to several hours to complete.
Export settings descriptions
|
Setting |
Description |
|---|---|
|
Title |
Name to identify the export. Useful when scheduling multiple jobs. |
|
Export Location |
SFTP path to save the CSV file. Include a forward slash at the end if the path is not at the root, for example /upload/. |
|
Export Frequency |
Schedule for the export, such as daily or weekly. |
|
Schools |
Select the buildings from which to export data. |
|
Grading Periods |
Select the grading periods from which to export data. |
|
Sections |
Select the course sections from which to export data. |
|
Export Type |
Choose the grade details to export. |
|
Grades |
Optionally, select Include Midterm/Finals Information to include midterm and final grade data. |
Status log
The Status Log displays the status of a previously configured export and includes:
-
Title
-
Frequency
-
Last Successful Export (Date)
-
Status
-
Action for any known errors
Available columns by export type
Final Grades columns
|
Category |
Columns |
|---|---|
|
Course section information |
Course Name, Course Code, Course ID, Section Code, Section Name, Section School Code, Section NID (including cross-listed sections), Grading Period ID, Grading Period Title |
|
Grading information |
Comments, Grading Scale ID, Letter Grade, Letter Grade (Override), Numeric Grade, Numeric Grade (Override), Weight |
|
Student information |
Unique User ID, Username, Email, School ID, School Title |
|
Midterm/Finals |
Due Date, Exception Code, Max Points, Mid-Term Final ID, Mid-Term Final Title |
Grade Items columns
|
Category |
Columns |
|---|---|
|
Course section information |
Course Code, Course Name, Course ID, Grading Period ID, Grading Period Title, Section Name, Section NID (including cross-listed sections), Section School Code |
|
Grade item information |
Description, Title, Due Date, Grade Item ID, Grade Item Type, Last Submission, Number of Submissions, Published Status, Max Points |
|
Grading information |
Category Title, Category ID, Category Weight, Comments, Exception Code, Factor, Grading Scale ID, Is Midterm or Final, Letter Grade, Numeric Grade |
|
Student information |
Email, School ID, School Title, Unique User ID, Username |
Grading Scales columns
|
Category |
Columns |
|---|---|
|
Course section information |
Course Code, Course Name, Course ID, Grading Period ID, Grading Period Title, Section Name, Section NID (including cross-listed sections), Section School Code |
|
Grading scale information |
Level Average, Level Cutoff, Level Grade, Level Point Value, Point Value Description, Points or Percentage, Scale (Hide Numeric), Scale ID, Scale Title, Scale Type |