Bulk Schedule and Inventory Operations

Course Management contains Bulk Operations Tools that allow Schools and Departments to upload, download, and update large quantities of courses in their Course Inventory or Class Schedule. Each tool provides CSV. file templates that users can download to enter their course information to ensure that their class updates and uploads are successful. 

To request a template for Bulk Operations or submit any inquiries, please contact [email protected]. 

For any additional information on required and optional template headers, please refer to this link: Template Header Requirements Sheet

Below are the instructions on how to utilize the Bulk Operations tools in the Course Inventory and Class Schedule. 

Course Inventory

This section allows you to download Courses in the Course Inventory owned by your School or Department.  Please note that if you do not specify a class status or subject, your download file will contain courses across all subjects and statuses under your program.

  1. On the Course Management Main Menu page, Select the "Bulk Schedule and Inventory Operations" to access the Bulk Upload page. 
This image displays the Course Management Main Menu where Users are to select 'Bulk Schedule and Inventory Operations" to access the Bulk Upload page. 

Upon clicking on the Bulk Inventory and Operations button, you will be directed to a page with actionable steps to:

  • 'Download class Schedules' 
  • 'Upload Classes'
  • 'Download and Upload Courses'

2. Click on 'Download and Upload Courses' to download a .CSV file of your school or department's active and/or courses. 

This page depicts the three actions a user can do as part of the Bulk Upload Process: 'Download class Schedules,' 'Upload Classes,Download and Upload Courses.'​​​​​​​

Once you have completed the action above, you will be redirected to the Bulk Inventory Operations page. From here, you must select the 'Owner' of the courses you would like to download from the Course Inventory. There are also optional filters such as the Courses' status and subject which you can use to download more specific courses. 

Please Select the 'Owner' of the courses you would like to download from the inventory. For more specific results, select the 'Status' and 'Subect' of the courses you would like in your download file.

Class Schedule

The Upload Classes section allows users to create or update class schedules for their Semester Schedule. This page also contains a sample file detailing the necessary class information for a successful Bulk Upload. Users should download and complete the file before uploading their schedules. Information on how to upload class schedules to the semester schedule as well as reference pictures are located below. 

How to Create New Class Schedules: 

  1. Click on 'Create' to access the section of the tool that allows you to upload new class schedules to the Semester Schedule. 
  2. Click on 'Download Sample File' to download the Class Upload template file for new class Schedules. The file contains the fields where users can enter the class information required for a successful upload. 
  3. Click on the 'Upload Classes CSV' button to upload your file. As noted, only .CSV files are supported by the Bulk Upload Tool, which means other file types will not accepted or processed. 
  4. If you would like to add a new file or notice an error, click on the 'Reset' button to restart the Class Upload process(optional). 

Once you have uploaded your file, the system will validate the information and confirm whether your classes have been successfully uploaded to the Term Schedule. 

WARNING: Please do not delete the prefilled cells in the Template file. Deleting any of the preset columns or leaving the cells empty will result in a failed update.  However you can edit the information in the sheet and add additional class information in new columns.

 

Click on 'Create' to access the section of the tool that allows you to upload new class schedules to the Semester Schedule. Click on 'Download Sample File' to download the Class Upload template file for new class Schedules. The file contains the fields where users can enter the class information required for a successful upload. Click on the 'Upload Classes CSV' button to upload your file. As noted, only .CSV files are supported by the Bulk Upload Tool, which means other file types will not accepted or pr

Class Schedule Template for New Uploads:

This CSV Template File contains the required fields and class information that users will be responsible for entering in order to successfully upload their class schedule to the semester schedule.

This section allows you to download existing Class Schedules from your School or Department's Semester Schedule. Please note that if you do not specify a term, your download file will contain all of your program's available classes across multiple terms.

To download existing Class Schedules:

  1.  Enter your School/Dept/program name in the owner section. 
  2. Select the term of interest from the dropdown list (optional).
  3. Click on the 'Download Class Schedule text and Icon to download the class schedule to your device. 
To download existing Class Schedules: Enter your School/Dept/program name in the owner section. Select the term of interest from the dropdown list. Click on the 'Download Class Schedule text and Icon to download your class schedule to your device. 

This process allows you to Bulk update the information for classes already on your School or Department's Semester Schedule. Please note that editing the 'FALSE' value for column that contains it will activate that particular aspect of the class.

How to Update Class Schedules:

  1. Click on 'Update' to access the section of the tool that allows you to upload updated class schedules to the Semester Schedule. 
  2. Click on 'Download Sample File' to download the Class Upload template file for class Schedules update. The file contains the fields where users can enter the class information required for a successful upload. 
  3. Click on the 'Upload Classes CSV' button to upload your file. As noted, only .CSV files are supported by the Bulk Upload Tool, which means other file types will not accepted or processed. 
  4. If you would like to add a new file or notice an error, click on the 'Reset' button to restart the Class Upload process(optional). 

WARNING: Please do not delete the prefilled cells in the Template file. Deleting any of the preset columns or leaving the cells empty will result in a failed update. However, you can edit the information in the sheet and add any additional class information in new columns.

Click on 'Update' to access the section of the tool that allows you to upload updated class schedules to the Semester Schedule. Click on 'Download Sample File' to download the Class Upload template file for class Schedules update. The file contains the fields where users can enter the class information required for a successful upload. Click on the 'Upload Classes CSV' button to upload your file. As noted, only .CSV files are supported by the Bulk Upload Tool, which means other file types will not accepte

Class Schedule Bulk Update Template: 

This CSV Template File contains the required fields and class information that users will be responsible for entering in order to successfully upload their class schedule to the semester schedule. User can also enter information in row 2 for the optional fields they want to include in their Class Schedule Information for the Bulk Update.