Before proceeding with the following troubleshooting steps, it is recommended that you save a copy of the entire i>clicker folder somewhere safe. This will ensure your data is not lost should you accidentally delete something.
Removing the existing roster information
Make sure the i>clicker program is not running before you start deleting files.
First, navigate to the folder that contains the i>clicker program and data.
Within this folder, there should be another folder called “Classes”. Open it.
Next, open the folder that pertains to the class you are troubleshooting the roster for. In this case, the class is “Sample Class”.
Delete the file called roster_canvas.csv within that folder.
Open The “SessionData” folder.
If that folder contains a file called RemoteID.csv, go ahead and delete it. This file is created after you run a poll and hit the “Sync” button within the i>clicker Gradebook, so the file may not exist in your folder if you haven’t done that yet.
Now when you import the new roster information, you should be starting with a blank slate containing no incorrect information. Don’t worry, the student’s response data is all still intact.
Exporting your Canvas Roster
Navigate to your class within Canvas.
Click on the “Settings” link for the class.
Next, click on the “Feature Options” tab.
Turn on the “Gradebook – List Students by Sortable Name” option. This will list your students by last name first in your Canvas gradebook.
Now click on the “Grades” link.
Click the “Actions” button above the student names and click “Export”.
The location that the CSV file is saved in will depend on which browser you are using and whether or not you have changed your default download folder for the browser. Most likely your file will be downloaded to the “Downloads” folder. Regardless of where it is stored, you will want to open that file using Excel.
Modifying the Excel Roster
Once the roster file that you just downloaded is opened in Excel, make sure the first Cell in Row 2 says “Points Possible”. If you have any muted assignments within Canvas, a row is added to the spreadsheet and will corrupt your roster import. If this is the case, simply delete the ENTIRE second row. In the below example, the row containing the “Muted” data is present and will need deleted.
Next, we need to delete the column containing the “Section” data and everything to the right of it.
You’re final Canvas Roster file should look like the below example. Only the columns labeled “Student”, “ID”, “SIS User ID”, and “SIS Login ID” are necessary for a successful roster import.
Save this file. If you choose “Save As” you’ll want to make sure Excel is saving the file as a .csv file. Some versions of Excel will default to another file format when you “Save As”. Comma Delimited CSV will work fine. Below are examples of this for both Mac and PC. You may see slight variations from these examples depending on what year your version of Excel is.
You may be prompted by a window stating that some workbook features may be lost if you continue to save as a .csv file. Just click “Yes” when it asks if you’d like to continue saving using that format. No data will be lost.
Your roster modifications should now be done. Simply follow the directions for normally importing a Canvas roster and make sure to use the Excel file that you have just created. Directions for importing rosters from Canvas can be found here: Roster Import Guide. Should you require further assistance, don’t hesitate to contact firstname.lastname@example.org.