Close

Spreadsheet Format for Bulk Upload Requests

If you maintain a course that is non-academic, meaning it is not connected with Banner, you can submit a request to have the users for the course uploaded using a spreadsheet. These requests must be in a specific format.
The actions we can do in bulk are the following.

  • Enroll users already in the system
  • Unenroll users from a course
  • Import external users (ONLY WITH COURSES ON 2ND D2L SERVER - TTUEPRD)

Spreadsheets should contain the columns of data listed below and saved as an CSV. No heading row.

Enrolling Users on iLearn

This will enroll the users into the class as the role specified. These users must already have accounts in the current system. TN Tech users will always use their campus username and credentials to access these systems.

TN Tech User enrollment on iLearn

Download the ENROLL Template

ENROLL Username OrgDefined Id (T#) Role Name Course Code
ENROLL jadoe42 T12345678 Banner_Student non-academic-class

External User enrollment on TTUEPRD

On TTUEPRD, the external users will use their email address for their username.

ENROLL Username OrgDefined Id Role Name Course Code
ENROLL absmith@me.com EXAMPLE0001 Banner_Student non-academic-class

 

Unenrolling Users on iLearn or TTUEPRD

This will unenroll the users from the course specified.

TN Tech user unenrollment on iLearn or TTUEPRD

UNENROLL Username OrdDefined Id (T#) Course Code
UNENROLL jadoe42 T12345678 non-academic-class

External user unenrollment on TTUEPRD

UNENROLL Username OrgDefined Id Course Code
UNENROLL absmith@me.com EXAMPLE0001 non-academic-class

 

Import Users Into a Class - Only on TTUEPRD

This option is only available for courses on TTUEPRD (2nd D2L Server) for programs who have paid for the users being imported.

IMPORT Username OrgDefined Id (T#) First Name Last Name Password (blank) Role Name Is Active (1) Email Address Course Code
IMPORT jadoe T12345678 Jane Doe   Learner 1 jadoe@mail.com non-academic-class
IMPORT absmith@me.com EXAMPLE0001 A Smith   Learner 1 absmith@me.com non-academic-class

Roles Available to Request

  • iLearn Roles
  • TTUEPRD (2nd D2L Server) Roles
    • Learner
    • Instructor