CACWT - Support Staff: Import CSV File

Import CSV File

Description:

The following steps provide details for importing a CSV file into CACWT. Uploading CSV files allows users to save time by completing bulk actions, such as enrolling multiple learners at once, importing section enrollments, creating courses, importing external course history, etc.. Note that CSV templates referenced in these instructions are only available to users with the “Affiliation” manager role in CACWT.

Instructions:

1. If you have not done so already, locate the CSV template file for this action by selecting “Import CSV” under “Administration” on the left side panel:

Figure 4.1.3.a - CACWT left panel showing “Import CSV” option.

2. The page will allow you to search for a variety of sample CSV templates by “Type” from the dropdown menu. Select the “Get Sample CSV” button to download the appropriate sample CSV file. 

Figure 4.1.3b. - Drop down menu showing selection options for Type of sample CSV file: “Learners,” “Courses,” “Sections” “Instructors Enrollments,” “Meeting Times,” and “Learners and External Courses”.

Sample CSV Template Files. 

Note: Due to size limitations, the images below may not include all headers that appear on sample CSV files.

Figure 4.1.3.c - Screenshot of sample Learner CSV template file.

Figure 4.1.3.d. - Screenshot of sample Courses CSV template file.

Figure 4.1.3e. - Screenshot of sample Sections CSV template file.

Figure 4.1.3.f. - Screenshot of sample Instructors CSV template file.

Figure 4.1.3g. - Screenshot of sample Enrollments CSV template file.

Figure 4.1.3h. - Screenshot of sample Meeting Times CSV template file.

Figure 4.1.3i - Screenshot of sample Learners and External Courses CSV template file.

3. Next, input your data into the CSV file. Refer to the header columns in the sample file to inform what needs to be populated in the appropriate fields.

4. Finally, upload the CSV file. You can do this via the “Import CSV” page under “Administration” (see Figure 4.1.3c.).
   

Figure 4.1.3j. - Screenshot of Administrator view of “Import CSV” page with “Choose file” option circled. 

5. Alternatively, you can select “Import CSV” from the appropriate heading on the left panel based on the type of file you are uploading. For example, if you are uploading a CSV file with learners, you can select “Learners” → “Import CSV” from the left side panel.

Figure 4.1.3k. - Screenshot of CACWT left side panel showing the “Import CSV” option highlighted.

6. On the next page, you will be able to upload the CSV file from your device by selecting “Browse” to locate the file and the “Upload” button to upload it.

Figure 4.1.3L. - Screenshot of “Import CSV” file upload page.

• Related Articles

• CACWT - Support Staff: eLearning SCORM Publishing Settings

  eLearning SCORM Publishing Settings Description: The following steps explain how to set up the correct publishing settings when publishing a SCORM package from an eLearning platform. Note that these steps are specific to eLearnings built in the ...

• CACWT - Support Staff: Accessing Learners through CACWT

  Accessing Learners through CACWT Description: The following set of instructions shed light on how learners can be accessed through CACWT while in the Help Desk role. Instructions: 1. From the sidebar of your CACWT dashboard, select Learners. Figure ...

• CACWT - Support Staff: Emailing Learners through CACWT

  Emailing Learners through CACWT Description: The instructions below explain how learners can be emailed through CACWT while in the Training Assistant, Administrator, Affiliation Manager or Special role. Please note: when sending an email the From ...

• CACWT - Support Staff: Enrolling Learners through CACWT

  Enrolling Learners through CACWT Description: The following set of instructions detail how learners can be enrolled in course sections through CACWT while in the Training Assistant, Administrator, Affiliation Manager or Special role. Please be sure ...

• CACWT - Support Staff: Adding a Course

  Adding a course Instructions Adding a course: Select “Add Course” on the left panel under “Courses” section: Figure 4.2.2d: CACWT left side panel with “Add Course” highlighted under the dropdown Courses section. The next screen asks for Basic ...