Je me suis désinscrit de la compétition, mais quand je vais dans la liste des compétitions, je vois que je suis inscrit.

The current statistics page does not explain what we see. See e.g. https://skala3ma.com/competitionStats/9bb154cde877447a8d78e4fb1bfdfa78

It would be better to have a title for each chart and a caption that explains how to read it.

There should be one or two confirmation before deleting a gym.
Because there is no undo button and the delete button can be hit by mistake

Add a page to display the list of competitions of a given season in a calendar.
This could become the official calendar if all clubs create their competition at the beginning of the season.

The admin of the competition must have the ability to change the date or delete the competition (when it's in the created status).

scripts that can help to compute the challenge results from a set of competitions.

Ideally, these scripts will be integrated into the application thanks to #40

Si l'on choisit de mettre une voie en couleur marbrée, l'aspect marbré n'est pas sauvegardé et la couleur redevient pleine

We have documentation but we need a microvideo walkthrough showing major points of the app. The scenario might be as follows:

• create new gym (name, icon, address, number of routes..)
• show editing of routes; mention that the interface works well on mobile
• • show how to add a new route
• • show how to delete a route
• show the batch route editing screen
• show how to copy routeset into another routeset for an upcoming competition
• modify the routeset in the batch mode to only leave routes needed for a competition
• create a new competition and choose the newly created routeset
• set the competition to be opened
• show how it's using a different routset than the main gym

There are many apps that help with screen videos:

https://scribehow.com/features
https://www.tango.us/
https://www.screencastify.com/

Ideally we could add this video on the home page of the app.

Right now, we cannot unsubscribe to a competition and we cannot contact the organizer.
Users should be able to unsubscribe easily.

Ideally, the admin should get a notification (email? notification when connecting?...)
so that they can contact the users on the waiting list.

We could think to update automatically the status of the first user on the waiting list, but we need to notify them if we do that.

On the day of the competition, the organizer will usually check that each climber is subscribed.
It would be useful to have a checkbox for that in the administration panel.
The checkbox would indicate whether the climber is present or absent on the day of the competition.

Having this information will help to remove automatically all absent climbers from the results computation.

Start the application for the very time (no data created)
Login and create a new competition (without having first created a gym).

then, we get this error:
Traceback (most recent call last):
File "/Users/scorreia/devel/git/skala3ma/.venv/lib/python3.11/site-packages/flask/app.py", line 2463, in call
return self.wsgi_app(environ, start_response)
File "/Users/scorreia/devel/git/skala3ma/.venv/lib/python3.11/site-packages/flask/app.py", line 2449, in wsgi_app
response = self.handle_exception(e)
File "/Users/scorreia/devel/git/skala3ma/.venv/lib/python3.11/site-packages/flask/app.py", line 1866, in handle_exception
reraise(exc_type, exc_value, tb)
File "/Users/scorreia/devel/git/skala3ma/.venv/lib/python3.11/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/Users/scorreia/devel/git/skala3ma/.venv/lib/python3.11/site-packages/flask/app.py", line 2446, in wsgi_app
response = self.full_dispatch_request()
File "/Users/scorreia/devel/git/skala3ma/.venv/lib/python3.11/site-packages/flask/app.py", line 1951, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/Users/scorreia/devel/git/skala3ma/.venv/lib/python3.11/site-packages/flask/app.py", line 1820, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/Users/scorreia/devel/git/skala3ma/.venv/lib/python3.11/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/Users/scorreia/devel/git/skala3ma/.venv/lib/python3.11/site-packages/flask/app.py", line 1949, in full_dispatch_request
rv = self.dispatch_request()
File "/Users/scorreia/devel/git/skala3ma/.venv/lib/python3.11/site-packages/flask/app.py", line 1935, in dispatch_request
return self.view_functionsrule.endpoint
File "/Users/scorreia/devel/git/skala3ma/competitionsApp.py", line 163, in decorated_function
return fn(*args, **kwargs)
File "/Users/scorreia/devel/git/skala3ma/competitionsApp.py", line 693, in new_competition_post
competitionId = competitionsEngine.addCompetition(None, name, date, routesid, max_participants)
File "/Users/scorreia/devel/git/skala3ma/competitionsEngine.py", line 149, in addCompetition
competition = {"id": compId, "name": name, "date": date, "gym": gym['name'],"gym_id":gym['id'],

A nice looking pdf is necessary for each competition.
See examples attached
résultats Contest adulte RSCChampigny.xlsx
résultats Contest adulte RSCChampigny.pdf

The pdf file should be downloadable from the results page of the competition.
The pdf is only downloadable after the competition is closed.

1. Add information about the usage of the data when the user register to a competition
2. Add a checkbox so the user can refuse the use of their data, and add a text box so the user motivates their opposition

CNIL says:

les structures sportives peuvent publier les résultats sportifs des licenciés en ligne sous réserve
du respect de certaines conditions lors de la collecte des informations :
• la personne concernée a été informée de la publication de ses résultats en ligne ;
• elle peut s’opposer à cette publication de manière simple (ex. : une case à cocher mise à sa dispo-
sition sur le formulaire de participation à une compétition sportive), en faisant valoir une situation
particulière le justifiant.

At some point, if we want to be able to distinguish competitions that are part of the FSGT challenge from other competitions internal to each gym, we need a way to group competitions together.
This will help later to filter by challenge (say "Challenge IDF Saison 2023", "Nanterre CarnaGrimpe"...).
This will also help to count the statistics of the challenge (best gym, best climbers of the season,...)

There are now many lists of routes in the Nanterre gym.
We should probably delete some of them.

When deleting a list of route, this should not impact past activities (maybe, we simply deactivate the list of routes and hide it everywhere if we cannot delete it easily).

Currently, only addition or deletion of climbed routes is possible in an activity.
Some people want to be able to edit the climbed routes.

Currently, only addition or deletion of climbed routes is possible in an activity.
Some people want to be able to sort the climbed routes.

CSMG Escalade (Gennevilliers)
EMA (Maisons Alfort)

sqlite like other dbs supports blob type that can store images, we store images currently as files in a separate directory but this is not as efficient as db and actually might be less performant

to test db solution, add ability to upload competition poster to the competition

display the poster in thumbnail for each competition

When viewing routes, the marble color is exactly the same as the plain color

If we want the personal results to still be correct later, we need the route list to be fixed for ever after a competition.

When editing the routes from the main table, I have no issue to save my changes.
When editing a route via the dialog, I cannot save my changes.

This is triggered when there are 130 routes. It seems ok for 100 routes.

And the below list could be in reverse order as well: showing the most recent activity first.

To inform climbers of the route details (mainly difficulty) we need to post some information at the foot of the routes. This can be done in variety of ways. Some gyms have one frame that fits a paper where only one route is described. The paper could describe more than one route surely.

We should offer a printable view of the routes that could be cut into smaller pieces and affixed next to the routes. Possibly we could offer different layouts (table, disc, etc.)

Some persons want to know how many persons might joins the competition.
We could display this information on the competitionDetails page.

A gym is often split in several sectors.
A sector can contain several lines.

A participant could have made errors when subscribing (wrong club, wrong category).
The admin should be able to modify that.
This could be done when you edit the competition: here we can access to the list of participants. It's possible to remove a participant, but it would be nice if we could also edit the participants information (name, mail, category, ...)

Sometimes, people want to contact the organizer (to ask questions, cancel a registration, ...)
Add a form to contact the organizer of a competition (or simply a mailto field) in the competition page.

When creating a competition, the admin user must choose whether it's an adult or a teenager competition.
The difference between the 2 competitions is the list of categories.
For adult competitions, the categories are:

Séniors 16-49ans
Titane 50-64ans
Diamant 65ans et +

For teenager competitions, the categories are:

ADOs 12-13 ans
ADOs 14-15 ans
ADOs 16-17 ans

When printing the gym's routes from an Android phone, it looks like this:

It's not the same layout as when generated from the computer and it is useless to print it like this.