Spreadsheet kickouts (errors)

If you have errors in your spreadsheet, the system generates a kickout (errors) spreadsheet. You can download this error spreadsheet, fix the errors, and upload it into UtilityManagement.

Correct errors on a kickout (error) spreadsheet

  1. Download the error spreadsheet.
  2. Review the error message and make your corrections in the spreadsheet.
  3. Use Import to upload the error spreadsheet in UtilityManagement.
  4. Review the spreadsheet log for your results and repeat the process as needed.

Error messages

  • Each row in the kickout (error) spreadsheet is a different error.
  • The first column states the error message.
  • The incorrect cell in each row is highlighted.

Example

  1. This update sheet has a duplicate organization code.
  2. After the file is uploaded a banner message indicates an error. The failed column provides a link to download the kickout spreadsheet.
  3. Download and open the kickout spreadsheet.
  4. Fix the error and save the kickout spreadsheet.
  5. Upload and review the status.