usspeedskating / tempus-public

This is the public issue-tracking repository for Tempus
0 stars 0 forks source link

Provide usable error messages when Excel import fails #147

Open RobertBouillon opened 3 years ago

RobertBouillon commented 3 years ago

When the Excel import fails due to a data entry error, the user receives a small application error notification. Understanding the reason for the error requires clicking the link within the 4 seconds before it disappears, and understanding the nature of the error is exacerbated by a parsing failures (#119),

Tempus has robust exception reporting, and letting the user know exactly what the problem is in the Excel sheet data could be as simple as relaying the Exception Message back to them in a friendly popup.

Use existing failed imports as test cases to ensure that useful error messages are relayed back to the user.

In the case attached to this issue, the following errors exist: DC Test2.xlsx

  1. "SuperFinal" round type not supported
  2. Missing qualification tables
  3. "SuperFinal" is in the seed time list instead of a time