Sections Import

Import Sections

Purpose: Institutional Administrators will create individual Sections.  Sections are created in and are embedded within a Course; multiple Sections can exist within a single Course. This import also defines the Instructor of each Section. 

Information needed to populate your Section import can be found in your Student Information System or Course Management System.

The Section Import should be completed each semester and include all courses being offered within your program.

Accepted File Formats – The import supports the following file types:

*.csv UTF-8

All files must have the correct file extension.

Section Import Fields

The Section Import must be completed after the Course has been submitted. 

All of these fields must be in the header row of each upload. Optional fields may be left blank, or removed from the spreadsheet. Fields can be uploaded in any order. The sample file has the fields in the following order:

Section ID

     ⦁ Explanation: Unique identifier for each section. Often, this is a CRN number from an SIS.
     ⦁ Example: 38661
     ⦁ Field Type and Length: Alphanumeric, 50
     ⦁ Sample file column: A
     ⦁ Import Status: Required

          ⦁ Note:  Must be unique in the system.
          ⦁ If your institution reuses CRN values from term to term, concatenate a term indicator with the CRN. 

Section Name

     ⦁ Explanation: Name of the Section
     ⦁ Example: Introduction to Education Department I
     ⦁ Field Type and Length: Alphanumeric, 50, Case sensitive
     ⦁ Sample file column: B
     ⦁ Import Status: Required

          ⦁ Note:  Must be unique in the system, including term over term.
          ⦁ This is a student and faculty facing label and it also shows up as a parameter in reports. 
          ⦁ Section Name appears again in the Membership File and must match, as it is used to enroll students to their course
             section).

Course Code

     ⦁ Explanation: Institution Code or Abbreviation for the Course in which the Section will be contained. Must correspond to an existing Course Code.
     ⦁ Example: EDUC 101
     ⦁ Field Type and Length: Alphanumeric, 50
     ⦁ Sample file column: C
     ⦁ Import Status: Required

          ⦁ Note:  Must match an existing Course Code.

Instructor

     ⦁ Explanation: Email address for the Instructor, Professor, Team Lead, etc. 
     ⦁ Example: jsmith@via.com
     ⦁ Field Type and Length: Alphanumeric, 50
     ⦁ Sample file column: D
     ⦁ Import Status: Required

          ⦁ Note:  Must match an existing SL&L user.

Start Date

     ⦁ Explanation: The Start Date for the section
     ⦁ Example: mm/dd/yyyy (01/01/2019)
     ⦁ Field Type and Length: Alphanumeric, 50
     ⦁ Sample file column: E
     ⦁ Import Status: Required

End Date

     ⦁ Explanation: The End Date for the section
     ⦁ Example: mm/dd/yyyy (01/01/2019)
     ⦁ Field Type and Length: Alphanumeric, 50
     ⦁ Sample file column: F
     ⦁ Import Status: Required

Term

     ⦁ Explanation: The time period that contains the section. If the designated term does not exist, a new term will be created
     ⦁ Example: Fall 2011 01/01/2019~06/01/2019 (NOTE: between the dates is a tilde)

NOTE: If you have created a term manually (go to Settings Term) or through a Terms Import, you may use the TERM CODE in this field

     ⦁ Field Type and Length: Alphanumeric, 50
     ⦁ Sample file column: G
     ⦁ Import Status: Optional