Allow Import of teams data

Loran425 commented 4 years ago

User should be able to import excel file with anticipated columns or preview data and assign columns

Loran425 commented 4 years ago

Example of details to consider How many rows to skip at start of file (headers/blanks) Pick each of the 3 major data items (team name, school name, division)

Loran425 commented 4 years ago

Basic file format for import should be as follows

File format

CSV or Excel file (XLS/XLSX)

Header Row

Acceptable header values, case insensitive

Sponsor(School/Business)
Name (Team Name)
Division, Div
Mucking
Gold Pan, pan
Track Stand, track
Swede Saw, saw
Handsteel, hand steel
Jackleg
Survey

Must Contain the following

Business or School Affiliation Team Name Division

Division Values (Case Insensitive)

Men's Division [ M \ Men \ Mens \ Men's ]
Women's Division [ W \ Women \ Womens \ Women's ]
Co-Ed Division [ C \ Coed \ Co-ed ]
Alumni Division [ A \ Alumni ]

Optional Data

Time formats (any number of decimal precision acceptable)

[hh:][mm:]ss.ss (e.g. 01:00:05.234, 3:20, 45.23, 75:00.00)
ssss.ss (5.23, 123.12, 145, 1500.00005) Implementation Note: Unbalanced Times should be rejected (hours given and minutes > 60, etc)

Distance Formats

With unit (35 cm, 150.002 mm, 22.12 in, 14 ft, 240 mi)
Without unit (150, 25, 4.00005) When units are not given they should be given in cm
Acceptable Units:
Miles (mi)
Feet (ft)
Inches (in) (Fractional Inches may be supported in a future release)
Kilometers (km)
Meters (m)
Centimeters (cm)
Millimeters (mm)

Mucking / desktop