Complete an Attendance Import Template

A

Class ID

If you enter the Class ID, then you can skip columns B-H.

OR

You can leave this field blank and enter the class information in columns B-H.

To find the Class ID, you can look at the the Class Session Schedule report, or you can create an ad hoc report that contains the Class ID field.

B

Course

The title of the learning resource that this class is associated with. This value can also be the resource ID of the course. When provided with a title, the system will try to match the title with one on file. When provided the resource ID, the system will use this value as the unique identifier for the course.

C

Class Date

Date of the first class, MM/DD/YYYY format.

D

Class Start Time

Start time of the first class. You can use either 12 hour or 24 hour time formats, e.g. 8:00 AM or 16:00.

E

Time Zone

Time zone for the class, for example EST or CT. Use the codes shown on time zone drop down menu in Maintain Facilitated Sessions.

F

Instructor

The username or employee ID of the instructor who will lead the class.

If there is no Instructor associated with this class, this field can be left blank.

G

Venue

Venue ID or name. This field is case insensitive. Blank is permitted if your system is configured to not require a venue.

H

Room

If using rooms: room ID or name. This field is case insensitive.

Field is optional.

I

Employee

The username or employee ID of the user.

J

Date

The completion date if the upload is being used to process completions.

For enrollments or drops, this field can be left blank.

MM/DD/YYYY format.

K

Type

Enter one of the following letters:

• C Mark the user Complete in the selected class date
• E Enroll the user in the selected class date
• D Drop the user’s enrollment from the selected class date

L

Time

Optional: Enter the length, in minutes, of the class (for completions only)

M

Score

Optional: Enter a score for the user (for completions only)