To successfully connect courses between Course Evaluations & Surveys (CES) and Faculty Success (FS), each course must have a unique course code across terms and academic years. If you have courses that contain duplicate course codes, you will need to update them before initiating a sync through the Course Evaluation Management tool in FS.
Accessing and Updating Course Codes in CES
To modify the course codes in CES as a CES Administrator, follow these steps:
- Go to Surveys & Projects > Projects, then open your project.
- Navigate to the Courses tab.
- Click Export All Courses to download the Excel file.
- In the Excel file, find the Code column.
- Update the course codes in the Code column to be unique across terms and academic years. Keep in mind that it's crucial to not modify the unique ID of a course. The unique ID of a course cannot be modified as it may result in duplicate courses being created or data loss.
- Once the course codes are updated, save your file and return to your project in CES.
- Go to the Courses tab.
- Click Data Import.
- Select Excel.
- Choose Course File under Select Course File Type.
Once the file is uploaded to your project, you should see a green message confirming that it's being processed. The progress of the upload can then be tracked by clicking on the bell icon in the upper-right corner to go your Notifications in CES. For more information on this process, visit Batch Changes to Course & User Information using Upload Files.
Updating Course Codes in Faculty Success
After the course codes in your CES project are updated, export all your courses by repeating the earlier steps (steps 1 to 3) to retrieve a new Excel file with the modified course codes to use as a reference when updating the corresponding Scheduled Teaching records in FS with the same course codes from the project.
For more guidance on updating existing FS records, visit CSV Imports: Updating Existing Records.
Next Steps
Once the course codes are updated to be unique across terms and academic years in both systems, you will be able to run a new sync by following the steps outlined in How to Initiate a Sync Between Course Evaluations & Surveys and Faculty Success.