search

FirstLegoLeague / fllscoring

FLL Scoring app. See Demo:
http://firstlegoleague.github.io/fllscoring/
GNU General Public License v2.0
14 stars 19 forks source link

Add support for importing team list csv files created by Brian Lee's scheduler program. #297

Open alanggreen opened 6 years ago

alanggreen commented 6 years ago

Many competitions in the USA generate their schedules using a scheduler Excel spreadsheet, This Scheduler exports the team list in .csv form. For the Pilot (and beyond) it would good to support input of this file. I'll attach an example file.

My suggestion is to add a button "Import from File" to the right of the paste box with the word OR between it and the text "Paste a team list below". image

Clicking the button opens a File dialog, with the file type *.csv When the user selects a file and clicks "Open" or "Import" (Import is better but I don't know if one can select the button text), the team number and team name is written to the paste box, and the rest of the functionality continues as now.

If it's possible to remove the double scroll bar, that will be a bonus

This is an example file Animal Allies - BeerSheva 2.2 v2.zip The import can check that the 1st column of the first 3 rows contain Version Number Block Format Number of Teams and use that information to identify that this is a scheduler file, and know how many teams to import.

yosikarl commented 6 years ago

Corrections:

When the user selects a file and clicks "Open" or "Import" ... the team number and team name is written to the paste box, and the rest of the functionality continues as now.

I think @alanggreen means:

When the user selects a file and clicks "Open" or "Import" ... the lines containing teams info (lines 4 ... [number in line 3]+3) are written to the paste box, the custom delimiter field is set to comma, the [number column] field is set to 1, the [name column] field is set to 2 and the rest of the functionality continues as now

  1. It would be nice to better align the following two fields: image

  2. When pasting (or, after the correction, importing) a team list, a preview of the imported data is shown. Currently, that preview appears between the 'custom delimiter' field and the 'OK' button. This should be changed, so that the 'OK' button is on top of the list, and it remains visible even with a large team list.

alanggreen commented 6 years ago

Add new .csv file (zipped) schedule_ranking.zip

yosikarl commented 6 years ago

I edited my first comment to mention that upon importing a csv file, the system should also set [number column] field to 1, and [name column] field to 2. These values are also the defaults when the dialog opens, but should be set again when a csv is imported.