Using the Data Cleaning Tool

Using the Data Cleaning Tool

Objective: Correct errors in bulk or individually for pending graduate records when importing graduates. 


  1. Select the ceremony you need to work in to correct graduate data.
  2. The total number of graduates that were flagged during the import will show in the Pending Graduates card.
  3. Under “Manage Corrections” click the Pending Graduates tab.

Perform Bulk Corrections

Pending Graduates are not fully imported - they will not be imported until the errors are corrected. Once their errors have been addressed, their import will complete and the grad will receive the email inviting them to register.

1. Bulk Corrections
  1. All GDF values that need correcting for affected grads will be at the top of this section.  
  2. Click your cursor into the Correct Value field and your predefined values will show in a dropdown menu for you to select from.
  3. Select the value you wish to bulk update the GDF values for the affected graduates.
  4. Click the Import Corrections button to save the changes and finish importing the impacted graduates.

2. Edit Individual Records
  1. For unique errors, click the edit icon next to a specific graduate's record to make manual changes.
  2. All errors for the individual graduate will show for you to correct.
  3. Like bulk editing, when you put your cursor in the open text field, the predefined values will appear in a dropdown menu for you to choose from.
  4. Once complete, select Save Corrections.


Finalize Import: Once corrected, these records will no longer be “Pending” and willbe fully imported and receive their email to register.
Make sure you address these issues as soon as possible so as to not delay graduate registration.