Open AntonyM71 opened 2 months ago
@tclare95 has made a script that uses the GB freeestyle template, and hammers the API, here. This will probably be a good start, and we can do it using SQLAlchemy commands within a transactional context.
It may be worth defining our own internal competition format, which we can then convert any external formats into.
I would recommend breaking this task into two things, an internal "Upload CSV Script" task (aimed at developers), and an"Upload CSV Page" task (aimed at general users, with sensible error messaging and validation.
As a competition organiser, I would like to be able to upload a CSV of paddler/competition info with some metadata, so that I don't have to type all the names in manually for a big event.