Skip to content

Records

Colin Robbins edited this page Mar 29, 2024 · 10 revisions

SCM Helper can create a web page showing your club records

Usage

First, log into SCM and export all swim times to a CSV file.

Then...

GUI

See the Records menu.

You will need to export SwimTimes from SCM (Members / Swim Times / Export), then import the to SCM Helper via the records menu.

Command line

To produce the web page HTML file:

scm --records

To add new swim times

scm --records --newtimes <filename>

Where ``filename``` is a CSV file of swim times exported from SCM (Members / Swim Times / Export)

CAUTION: Do not use excel to adjust or delete any times exported from SCM - excel will round the times to one decimal place. If you need to edit any times use a text editor.

Add Page to SCM

To add records to a SCM web page…

  • Create the web page in SCM as a blank page, and save it. (This is important - it does not work if you try to add the contents into the initial page directly).

  • Select 'Edit' about half way down on the right hand side of the page. (Do not press "Edit Page Content" - it will not work.)

  • Select "<>" (edit source code).

  • Replace everything in the window that pops up with the contents of the records.html file.

  • Press save.

  • OPTIONAL. Send a feature request to SCM to add the capability to edit a web page via the API - then a future version of this tool could do all the above for you.

New Records

Once a baseline of records has been created, you only need to export new times from SCM.

Manual Updates

If you have records that pre-date SCM, edit the records\records.csv to add them in.

Page Format

Edit records\records_header.txt to alter the page layout.

Configuration

recordset:
    "records":
      relay: false
      age_eoy: true   # Calculate age at EOY, not age from SCM export file (where possible)
      verify: true  # Check a club member at time of swim (where possible)
      se_only: true  # Only include if valid SE number
      all_ages_u18: false
      overall_fastest: false  # include an overall fastest swimmer.
    "relay_records":
      relay: true   # Process relay records
    "club_champs":
      filter:   # Only include results with the following in the "location"
        - "Club Champs"
        - "Club Championship"
      25m: true     # Inlude 25m races in records
      open_age: 17  # Just one age group above 17, not masters categories
      ignore_group: "Membership_only"  # Ignore swimmer if they are in this group
      ignore_no_sessions: true  # Ignore if they have no training sessions with us

Relays

SCM-Helper does not automatically create relay records, you need to manage them yourself. What it will do is format the web page.

To configure relays you need to do two things.

  1. create relay_records.csv

The format is:

event,swimmer 1,swimmer 2,swimmer 3,swimmer 4,time,location,date
F 100 200m Free 50,swimmer 1,swimmer 2,swimmer 3,swimmer 4,01:53.0,LEN European Champs,26/05/2016

  1. Copy records_header.txt to relay_records_header.txt, and modify the end of the file to the following:
<p>Event:
  <input checked="checked" class="radio-group" id="btn-free" name="record-stroke" type="radio" value="record-free" />
  <label for="btn-free">Freestyle</label>
  
  <input class="radio-group" id="btn-medley" name="record-stroke" type="radio" value="record-medley" />
  <label for="btn-medley">Medley</label>
</p>

<p>Gender:
  <input checked="checked" class="radio-group" id="btn-male" name="record-gender" type="radio" value="record-male" />
  <label for="btn-male">Male</label>
  
  <input class="radio-group" id="btn-female" name="record-gender" type="radio" value="record-female" />
  <label for="btn-female">Female</label>
  
  <input class="radio-group" id="btn-mixed" name="record-gender" type="radio" value="record-mixed" />
  <label for="btn-mixed">Mixed</label>
</p>

Clone this wiki locally