Table of Contents

Overview
How to Do It
Historical Uploads
Additional Notes
Related Articles

Overview

• You can add or edit Courses (Curriculum) in bulk via a CSV import. 

• You can use this for any bulk changes to Courses (Curriculum) data, whether it’s for your initial product implementation or at any point thereafter when you wish to add or update Courses in bulk.

How to Do It

Step 1: Navigate to Curriculum > Courses.

Step 2: Click “Import Curriculum Courses”.

Step 3: At this point, you can do one of two things, but the first is what’s recommended:

1. Click “data” to download the template with existing course data already included.

2. Click “template” to download a blank CSV template to start from scratch.

   1. This route will take you to a Google Sheet.

   2. Download by going to File > Download and then choosing .csv as your file format.

Step 4: 

• Add new courses to the template and/or update course details as necessary.

• You might want to adjust column width to make it easier to see column headers and the information you’re inputting, just note that the width will not save in CSV format (and CSV format is required for the import).

• You can input more than one value in fields where multi-select is supported.

• Separate multiple values with a comma only (no extra space), e.g. “BUS,ACCT”.

  • If you need to separate values with something other than a comma, you can do that, but you’ll want to make sure it’s accounted for in Step 10 below.

Step 5: 

• Save your CSV to an easy-to-find location on your computer.

• Note that your file must be in CSV format – if you save the template in another file format (e.g. XLS), it will not show up in the file select.

Step 6: Return to the “Import Curriculum Courses” modal.

Step 7: Click “File to upload” and select your Courses CSV file.

Step 8 (Optional):

• Add a description.

• The description will come in handy when viewing “Historical Uploads”.

Step 9: Click “Upload File”.

Step 10:

• In the “Data Mapping” screen, ensure there is a green checkmark with “Mapped” next to each field.

• CSV columns are auto-mapped to the corresponding Coursedog fields based on the CSV column header, but if you have changed it you can adjust the mapping manually at this stage.

• Custom fields that are defined on your Course template in Curriculum will appear as options to map fields to.

• If you only want the import tool to import after a certain row in your CSV, you can set that via the “Start at row” setting.

• The import tool automatically assumes values are separated by a comma.

  • If you’re using commas as part of a value and separating values with something other than a comma, input what you’re using to separate values in the delimiter column(s).

• If you wish to not import certain data, click the X next to the Coursedog Field. This will remove the Coursedog field and prevent the field from being mapped.

Step 11: Click “Submit”.

Step 12: 

• Check the “Parsing Details” screen. 

• If there aren’t any errors, click “Import Curriculum Courses” to proceed.

• If there are validation errors, fix the CSV file and re-import.

  • Errors will appear at this step if user details cannot be found or mapped in Coursedog, or you add Courses that don't exist.

Step 13: 

• Check the “Summary” screen for errors.

  • If there are errors, contact Coursedog support; be sure to include the identifier.

• If there aren’t any errors, congratulations! Your import was completed successfully.

  • Click “Done” to exit out of the modal.

  • Refresh the page to see changes reflected.

Historical Uploads

• You can view past course imports by clicking “Historical Uploads”.

• This will show you a list of all past uploads, which you can organize in ascending or descending order by using the up and down arrows.

• Click “Summary” to see the Results and Import Summary of that upload.

• Click “Download” to view the corresponding JSON file.

Additional Notes

• If the CSV file is exported from Coursedog; changed; and imported again without changes to the Course ID – which is used as a unique ID in Coursedog – then the courses will be updated.

  • If, however, the Course ID is changed or no Course ID is provided, new courses will be created.

• Courses cannot be deleted via the CSV import – only added, updated, or deactivated.

  • If you remove a course from a CSV, and then conduct a new import, it will not be removed.

  • Similarly, if you have courses already added to your UI and use the template to create new ones, we would merge the existing courses with the new ones.

  • This is to ensure no courses are accidentally deleted.

• Custom Fields appear automatically in the mapping dropdown based on what is defined on the template.

  • Fields show as available if, and only if, they are currently on the template.

  • However, when you export data that is available in app, it could technically contain data from fields that were once on the template but no longer are. In this case, you can simply disregard mapping for these fields and they will not be updated.

• Curriculum Courses Id is the only required field for uploads.

• Column order doesn’t matter (but headers do).

• Currently not supported for self-service uploads:

  • Files

  • Components

  • Topics

  • Credits

  • learningOutcomes

  • courseEquivalencies

  • Requisites

• Custom field edge case:

  • Sometimes you’ll see more fields in mapping than you expect.

  • This happens when custom fields were removed from the template, but data still exists behind the scenes.

  • You can ignore unmapped fields if they’re no longer relevant.

Related Articles

• Adding/Editing Departments via CSV Import

• Adding/Editing Programs via CSV Import

• COURSES: Setting Up the Course Template
  

• Setting Up Users