usspeedskating / tempus-public

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

Incorporate NoElimination Tables into Build #13

Open gregw94542 opened 3 years ago

gregw94542 commented 3 years ago

Describe the bug Tried to Create Import file to test upcoming USS meet (Jan 30/31, 2021) Specified Competition Table does not exist in the current build. Greg Test Template.xlsx

Steps to Reproduce Steps to reproduce the behavior:

  1. http://tempus.usspeedskating.net/browser
  2. Click on "Import Competition"
  3. Upload "Greg Test Template.xlxs"
  4. Not sure if excel file is uploading

Expected behavior Excel file imported..

Screenshots Excel - Divisions Tab:

Name | Gender | Qualification Table | Rules | Distance | Distance | Distance Womens | Female | NoElimination | National Competition | 1500 | 500 | 1000 Mens | Male |. NoElimination | National Competition |1500 | 500 | 1000

After upload: Application Exception Qualification table NoElimination specified for Womens does not exist in the settings file at USS.Meets.Excel.DivisionDataSheet.ParseDivision(FinalsEventGroup finals, IEnumerable1 data) at USS.Meets.Excel.DivisionDataSheet.Parse() at USS.Meets.Competition.Import(Workbook workbook, SheetTypes sheets) at USS.Meets.Competition.Import(Stream stream, SheetTypes sheets) at USS.Meets.Competition.LoadXml(Stream stream, SheetTypes sheets) at TempusBlazor.Client.Pages.FileBrowserPage.HandleFileSelected(InputFileChangeEventArgs args) at Microsoft.AspNetCore.Components.ComponentBase.CallSt System.Exception: Qualification table NoElimination specified for Womens does not exist in the settings file at USS.Meets.Excel.DivisionDataSheet.ParseDivision(FinalsEventGroup finals, IEnumerable1 data) at USS.Meets.Excel.DivisionDataSheet.Parse() at USS.Meets.Competition.Import(Workbook workbook, SheetTypes sheets) at USS.Meets.Competition.Import(Stream stream, SheetTypes sheets) at USS.Meets.Competition.LoadXml(Stream stream, SheetTypes sheets) at TempusBlazor.Client.Pages.FileBrowserPage.HandleFileSelected(InputFileChangeEventArgs args) at Microsoft.AspNetCore.Components.ComponentBase.CallStateHasChangedOnAsyncCompletion(Task task)

RobertBouillon commented 3 years ago

The application exception indicates that the NoElimination table does not exist.

The name of the qualification table has to match a name of one of the tables loaded in by the NoElimQT settings file.