❌ Spreadsheet errors (kickout)

When your uploaded spreadsheet contains errors, UtilityManagement creates an error file (kickout spreadsheet).

What to do

  1. Download the error (kickout) spreadsheet.
  2. Review and fix the listed errors.
  3. Upload the corrected spreadsheet.

Correct errors on an error (kickout) 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 error (kickout) 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 error (kickout) spreadsheet.
  3. Download and open the spreadsheet.
  4. Fix the error and save the spreadsheet.
  5. Upload and review the status.