wrcq

This is the software for computing the set of persons pre-qualified for participation in future World Rogaining Championships. You can access it live at https://pqe.rogaining.org/.

Adding an event

WRC event manager will log into https://pqe.rogaining.org/ and create the event entry. Then they will be able to upload results in one of the following machine readable result formats.

The results file should also be committed into this repository for archival purposes.

Supported result formats

CSV and SSV

CSV is the simplest supported format:

• Rows separated by \n (carriage return).
• Columns separated by , (comma), or ; (semicolon) in the case of SSV.
• First line must contain a header (column names).
• The following columns are supported:

  • id – numeric ID of the team

  • name (optional) – team name

  • gender – Sex part of category of the team, one of:

    • men
    • women
    • mixed

  • age – Age part of category of the team, one of:

    • under18
    • under20
    • under23
    • junior
    • youth
    • open
    • veteran
    • superveteran
    • ultraveteran

  • time – time on track in hh:mm:ss format, example: 24:01:17

  • score – final score (number of scored points minus the number of points lost on penalty)

  • penalty (optional) – number of points lost (e.g. due to being overtime), example: 50

  • status (optional) – Status of the team result. One of the following:

    • not started
    • not finished
    • overtime
    • disqualified
    • withdrawn
    • out of competition
    • finished (default)

    Anything other than finished will not be ranked.

  • member1country – three letter IOC country code

  • member1firstname – First name of the

  • member1lastname

Further members can be added.

Example of full header with up to five team members:

id,name,gender,age,time,score,penalty,status,member1country,member1firstname,member1lastname,member2country,member2firstname,member2lastname,member3country,member3firstname,member3lastname,member4country,member4firstname,member4lastname,member5country,member5firstname,member5lastname

IOF XML

We support ResultList message element from International Orienteering Federation Data Standard 3.0.

IRF XML

This is our own simpler XML format. See the XML schema or WRC 2022 results as an example.

Importing HTML results

If the results are only available as HTML file, you can use the scripts in the scripts directory to extract the data.

wget https://erc2024.rogain.ee/results24/results.htm -O scripts/samples/rogain-manager/erc2024.html
cat scripts/samples/rogain-manager/erc2024.html | tidy -q | python3 scripts/html2json.py | jq -L scripts --from-file scripts/erc2024.jq | python3 scripts/json2csv.py result/erc2024.csv