Membership Import

Import Membership 

Purpose: Institutional Administrators will associate existing users with individual sections, making them Members of Sections, similarly to a course roster.  This import also designates the role of members within the Section.  Most commonly, Members of a Section are students, and are assigned the role of "student" in the import.

The Membership Import should be completed each semester, typically following the Add/Drop period. 

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

*.csv UTF-8

All files must have the correct file extension.

Membership Import Fields

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. Information for the Membership Import may be found in your Student Information System or Course Registration System.

The sample file has the fields in the following order:

Section Name

     ⦁ Explanation: Name of the Section to which members will be added. Must match an existing Section Name.
     ⦁ Example: Introduction to Education Department I
     ⦁ Field Type and Length: Alphanumeric, 50, Case sensitive
     ⦁ Sample file column: A
     ⦁ Import Status: Required. Case sensitive

          ⦁ Note:  Must match an existing section name.
          ⦁ Case Sensitive

Role

     ⦁ Explanation: Define the role each member will act as within a section
     ⦁ Example: student, coordinator, additional accessor, etc.
     ⦁ Field Type and Length: Alphanumeric, 50
     ⦁ Sample file column: B
     ⦁ Import Status: Required

          ⦁ Note:  Instructors are NOT added to the Membership import. They are added through the
            Course import.

Email

     ⦁ Explanation: The email address of an existing Via user
     ⦁ Example: rsmith@via.edu
     ⦁ Field Type and Length: Alphanumeric, 100
     ⦁ Sample file column: C
     ⦁ Import Status: Required

          ⦁ Note:  Account must already exist in the system.

Status

     ⦁ Explanation: The enrollment status of a member in a section. Active indicates inclusion in the group. Deleted indicates exclusion from the group.
     ⦁ Accepted Values: "active" or "deleted" only
     ⦁ Field Type and Length: defined options, lowercase only
     ⦁ Sample file column: D
     ⦁ Import Status: Required