Skip to content
This repository has been archived by the owner on Jun 16, 2018. It is now read-only.

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

Open
alanggreen opened this issue Nov 15, 2017 · 3 comments

Comments

@alanggreen
Copy link

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
Copy link
Member

yosikarl commented Nov 16, 2017

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
Copy link
Author

Add new .csv file (zipped)
schedule_ranking.zip

@yosikarl
Copy link
Member

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

3 participants