Table of Contents
Overview
How to Do It
Historical Uploads
Additional Notes
Related Articles
Overview
You can add or edit Programs in bulk via a CSV import.
You can use this for any bulk changes to Programs data, whether it’s for your initial product implementation or at any point thereafter when you wish to add or update Programs in bulk.
How to Do It
Step 1: Navigate to Curriculum > Programs.
Step 2: Click “Import Curriculum Programs”.
Step 3: At this point, you can do one of two things, but the first is what’s recommended:
Click “data” to download the template with existing program data already included.
Click “template” to download a blank CSV template to start from scratch.
This route will take you to a Google Sheet.
Download by going to File > Download and then choosing .csv as your file format.
Step 4:
Add new programs to the template and/or update program 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 Programs” modal.
Step 7: Click “File to upload” and select your Programs 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 Program 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 Programs” 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 Programs 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 program 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 Program ID – which is used as a unique ID in Coursedog – then the programs will be updated.
If, however, the Program ID is changed or no Program ID is provided, new programs will be created.
Programs cannot be deleted via the CSV import – only added, updated, or deactivated.
If you remove a program from a CSV, and then conduct a new import, it will not be removed.
Similarly, if you have programs already added to your UI and use the template to create new ones, we would merge the existing programs with the new ones.
This is to ensure no programs 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.
Programs Id is the only required field for uploads.
Column order doesn’t matter (but headers do).
Currently not supported for self-service uploads:
Components
Topics
Credits
Contacts
Learning Outcomes
Concentrations
Object Merge Settings
Requisites
Specializations
Degree Maps
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.