Handle duplicate columns in spreadsheet upload

[jpschewe]

If the user has 2 columns with the same name we should handle that. Perhaps just prefix each column number with its index. If we do this we should update the web pages to tell the user that is what they are seeing.

[jpschewe]

Looking at this I want to modify all code that uses UploadSpreadsheet to use the column information parsed in StoreColumnInformation. This should not throw out blank or null column names. It should prefix the column name with the index so that all column names are unique. It should also sanitize the column names to be safe as database column names.

All downstream code should then skip past the header row and use the previously processed information for column headers. This will include checking the parsed headers to get the index of the column to find the needed data.

[jpschewe]

Thinking of having an object that contains

• File
• List<@Nullable String> original headers
• List<String> sanitized headers - safe for database use, non-null
• int header row index
• @Nullable String sheet name

[jpschewe]

Tasks:

• modify javascript automatic column select to check end of string rather than whole string
• modify Java automatic column select to find option where end of string matches
• Modify FullTournamentTest to check for option ending with the specified string for column names
• Remove sanitize from the stored column information (update documentation as well). Only sanitize when going to a database column.
• When uploading team data, leave the columns unsanitized, however do the translation on the back end