Specific Information about Column Data, Character Limits, and Formatting Requirements
Getting Started
To get started with uploading a Class Section file, click on the Classes tab in the left sidebar and then the Class Sections subtab that appears. Use the Actions menu at the top of the page to select “+ Assign New”.
On this screen, you’re provided with the column headers and some quick notes regarding the data you’ll include in your file. Click the “Download Template” button to easily generate your header file.
These column headers are case sensitive, so be sure not to edit them. Additionally, make sure your file is saved in CSV format.
Specific Information about Column Data, Character Limits, and Formatting Requirements
| Column Header | Limits and Requirements | Required or Optional Field |
|---|---|---|
| campus_code | Must match Campus Code in the system | Required |
| term_code |
Must match Term Code in the system. If Term Code for your campus does not exist, create new in Classes -> Terms -> Add New |
Required |
| course_title | Max. 100 characters | Required |
| course_name | Max. 100 characters | Required |
| description | Max. 1,000 characters | Optional |
| prereq | Max. 1,000 characters | Optional |
| class_number | Integer | Required |
| section_number | Integer | Required |
| credit_hours | Integer | Required |
| tuition | Decimal | Optional |
| lab_fees | Decimal | Optional |
| bldg_code | Must match LDE Site Code. | Required |
| gen_ed_course | Max. 500 characters | Required |
| course_choice | Max. 500 characters | Required |
| la_common_course_number | Max. 500 characters | Required |
| hs_course_number | Max. 500 characters | Required |
| restrictions | Max. 1,000 characters | Optional |
| status | "Active" or "Cancelled" | Required |
| start_date | yyyy-mm-dd | Required |
| end_date | yyyy-mm-dd | Required |
| instruction_mode | Max. 50 characters | Optional |
| teacher_email | Max. 50 characters | Optional |
| teacher_first_name | Max. 50 characters | Optional |
| teacher_last_name | Max. 50 characters | Optional |
| part_of_term | Max. 50 characters | Optional |
Importing Sections
When you’re finished populating your file, you’ll need to select the “Choose File” button on the Assign New screen and upload, then click the “Import Sections” button.
Once the file has been processed, the system will generate a CSV report detailing the results of the import. A new column will be added at the end of the original column headers stating whether each row was a success, or listing a specific error.
Possible Error Messages
| Error Message | Meaning |
|---|---|
| Campus code does not exist | Campus Code does not match what is listed in the system |
| User does not have permission to assign class section to passed campus code | User is attempting to upload for a campus they do not have access to |
| High School bldg code does not exist | LDE Site Code does not exist. Some Site codes start with a '0' so you will need to format the column as a 'Text' in Excel |
| Term code does not exist | If Term Code for your campus does not exist, create new in Classes -> Terms -> Add New |
| Teacher does not exist |
Teacher email does not exist (Note: This will not stop the class section from being imported) |
| Course does not exist, unable to create new | Uses course name, campus code, and credit hours to create a new course if one does not exist |