Administrators can add Courses and Sections in bulk to their institutions' Collaboratory by importing them from a .csv file.
NOTE: Units must be uploaded (either in bulk, or manually) before courses/sections may be imported.
How it Works
- Administrators should work with their institution to complete the Courses/Sections Bulk Import Template (we suggest starting with the registrar's office).
- Once the .csv template has been completed, email it to your Collaboratory Customer Specialist.
- Our development team will make the magic happen! Once you submit the request form, your Customer Specialist will communicate with you about timelines and with any additional questions.
- Once the bulk import process is complete, those Courses/Sections will be available in your Collaboratory Portal.
Formatting Guidelines for the .csv Import File
During the import process, we will match each column in your file to a field in our database. Certain fields, like term or active period, require a specific format. We've provided example data to help you communicate field formats to your campus data managers who are helping you generate your Course/Section export file. Follow these guidelines to format each column in your file to get the best import results.
Before You Start:
- Maintain the column labels and order of columns. This is critical to a successful upload.
- Each row should reflect one Course/Section combination. A Section is distinctly defined by the section number, its offered term, and the academic year (Period). So, if a Course has 5 Sections across all academic years and offered terms, each Section, even if they have the same section number, will be represented on a unique row in the template.
- Determine the frequency with which you want to bulk import Sections into your Collaboratory (e.g., once a year, once a semester). Once you determine the appropriate contacts and processes for obtaining data from your institution, consider setting up a recurring process so you may request this data easily in the future.
The following table defines each data point requested in the .csv template file (unless otherwise noted all fields are alphanumeric with no character number limitations):