How to upload a CSV

Offerings can be imported into Course Hub via CSV upload. Offerings can be only imported inside your institution's catalogue. For the upload to work, files must be in UTF-8 format. When you save the file in excel, this will be in the list of file types. This is to ensure that any special characters used appear correctly on the website after upload.

UTF-8 format

CSV upload in Course Hub

Once you're on the Catalogue settings tab, click to 'Edit' under the header on the top right. The 'Import offerings' section will appear at the top.

Update only

To add new micro-credentials to your existing catalogue, and/or update specific existing micro-credentials without replacing the entire catalogue, ensure you switch the 'update only' option on (click to the right and it will turn green). Doing this will add new and updated micro-credentials without archiving the existing catalogue.

To archive all existing micro-credentials and replace with a new CSV import, leave this option turned off.

Ensuring upload success

• Make sure all the images in your CSV files have been added to the gallery.
• CSVs should use the .csv file extension format. Other spreadsheet file formats such as .numbers or .xls will not work. 

Steps to import offerings

1. Click the 'Select CSV file' button. A file dialogue box that will allow you to select your CSV file will appear

2. After selecting the file, click the 'Import' button on the right 

3. Depending on the number of records in your file, it may take a few seconds for the import to complete. Do not click the import button multiple times.

4. After file import is successful. All offerings in the catalogue will appear in the 'Basic settings' section below the import section.

5. Click the 'Save' button under the header on the top right to head back to 'Catalogue settings tab' in view mode. Clicking 'Cancel' will not undo the import.

Note: Depending on your CSV records, you may receive errors messages during the import. You will need to resolve the errors to complete the import. The CSV import will continue until it hits an error. Therefore if you have an error in row 6, all courses listed in rows 1-5 will upload successfully. Please refer to  upload troubleshooting to find out more about common errors that may occur during CSV imports. 

After imports

The 'Catalogue settings tab', will now display a list of all offerings in the catalogue along with associated categories. You can modify the imported offerings via the 'Offerings page'.