Configure Event, Entry, and Result Uploads with RunScore

Summary

This document explains how to upload results from RunScore for cross country races. Road races are not supported at this time.

Download a zip file containing all example files from this article.

Requirements

The following is required to connect RunScore with AthleticLIVE.

  1. RunScore 8.3.3.0 (Might work on older versions but we only support this version and greater.)
  2. An Internet Connection
  3. Create a meet and select RunScore as your meet management system.

Configuration in entries.ini file

Entries and results are uploaded to AthleticLIVE via FTP. Add this snippet to your entries.ini file. Change alive_ftp_user, alive_ftp_pwd, and alive_csv_dir.

* Host is on your admin meet detail page at admin.athletic.live. 
* This should always be ftp.athletic.live
%alive_ftp_host% ftp.athletic.live

* Username is on your admin meet detail page at admin.athletic.live.
* This will change every meet.
%alive_ftp_user% User1234

* Password is on your admin meet detail page at admin.athletic.live.
* This will change every meet.
%alive_ftp_pwd% Pass1234

* The directory where you wish to save reports.
* Ideally this is the same directory as your entries.ini file.
* Trailing '\' is required.
%alive_csv_dir% C:\RunScore\MyRunScoreRace\

* Do not change. Filename for entry csv file.
%alive_csv_entry% alive_entries.csv

* Do not change. Filename prefix for result csv file.
* In UploadALiveResults.lst, you will see that the result file
* name must contain the event number, like so: alive_results_1.csv.
%alive_csv_result% alive_results

Events

Configuration

AthleticLIVE requires that you have an event number and an event name for every results list that you want to show. For a simple high school meet with 2 races, you would have 2 ALive events:

  1. Boys 5K
  2. Girls 5K

For a high school meet with separate varsity and JV races, you would have 4 ALive events.

  1. Boys 5K
  2. Girls 5K
  3. Boys 5K JV
  4. Girls 5K JV

Let's say you have a Mens 8K with 2 separate divisions. You want to show them separately and together. You need to create 3 separate ALive events:

  1. Mens 8K
  2. Mens 8K Division 1
  3. Mens 8K Division 2

Uploading Events

Upload events by creating a CSV file and uploading it at admin.athletic.live. Sample CSV File: alive_events.csv. If you are including dates and times, please use YYYY-MM-DD HH:MM:SS or MM/DD/YY HH:MM AM format.

Entries

Upload all teams and rosters to AthleticLIVE. This doesn't upload entries for a particular race.

Take a look at this sample UploadALiveEntries.lst file. Change the field names in each "Field" command to match your fields. Click on the "UploadAliveEntries" listing to upload your entries to AthleticLIVE.

Example Entry file format: alive_entries.csv.

Results

We recommend creating a single Listing file for each ALive event. When you are ready to upload results, simply double click on the listing and upload it to AthleticLIVE.

As with other listings in RunScore, you will need to customize each listing to meet your needs. You can code it however you like as long as the correct results in the correct format are sent to AthleticLIVE.

Take a look at this sample UploadALiveResults.lst file. Change the field names in each "Field" command to match your fields. Click on the "UploadAliveResults" listing to upload your results to AthleticLIVE.

If you are more proficient in RunScore programming, you may wish to create a RSM file to handle the bulk of the export, result creation, and upload. Your listing files just need to call the RSM file and pass appropriate parameters. Example:

Example Results file format: alive_results_1.csv.

Examples

We have updated two the sample RunScore XC example races so you can see how results are uploaded.

XC

Download XC-ALive.zip.

This is the very basic sample XC file. It contains one race.

In the race directory, you'll see a few ALive-specific files:

  1. alive_events.csv - The events file for this race
  2. alive_entries.csv - An entries file generated from this race.
  3. alive_results_1.csv - A results file generated from this race for ALive event #1.
  4. UploadALiveEntries.lst - The listing file to upload entries to ALive.
  5. UploadALiveResults.lst - The listing file to upload results to ALive.
  6. entries.ini - Of course this isn't ALive-specific, but observe 6 added fields that tell RunScore where to upload data.

Open RunScore and go to "Listings". You will see the 2 listing files in place. Double click on one and you will see that it generates the appropriate file in your folder. You may get an error if you don't have FTP credentials.

XCAdvanced

Download XCAdvanced-ALive.zip.

This is the advanced XC file. It contains two races.

In the race directory, you'll see a few ALive-specific files:

  1. alive_events.csv - The events file for this race
  2. alive_entries.csv - An entries file generated from this race.
  3. alive_results_1.csv - A results file generated from this race for ALive event #1.
  4. alive_results_2.csv - A results file generated from this race for ALive event #2.
  5. UploadALiveEntries.lst - The listing file to upload entries to ALive.
  6. @UploadALiveResults_Event1.1.G.lst - The listing file to upload results from event #1 to ALive.
  7. @UploadALiveResults_Event2.1.G.lst - The listing file to upload results from event #2 to ALive.
  8. ALiveResults.rsm - The listing file to upload entries to ALive.
  9. entries.ini - Of course this isn't ALive-specific, but observe 6 added fields that tell RunScore where to upload data.

Open RunScore and go to "Listings". You will see the listing files in place. Double click on one and you will see that it generates the appropriate file in your folder. You may get an error if you don't have FTP credentials.

Making your own modifications

Perhaps our LST/RSM files don't work for you or you've already got a way that you like to generate results. No problem. Here's what matters:

  1. You must use our Field Headers regardless of the field names in the RunScore database. Fields can be in any order. Available field names are:
    1. Bib
    2. Last
    3. First
    4. Grade
    5. Team
    6. Age
    7. Time
  2. CSV file names must be:
    1. Event files: alive_events.csv
    2. Entry files: alive_entries.csv
    3. Result files: alive_results_[ALIVE_EVENT_NUMBER].csv (e.g. alive_results_1.csv)
  3. Results must be sorted by time.
  4. We recommend using a MM:SS.1 time format

Resources

Download a zip file containing all example files from this article.

FAQ

Why don't the result csv files include Place?

RunScore does not export place when exporting csv files. We generate it ourselves after upload.

Why don't the result csv files include team scores?

RunScore does not export team scores when exporting csv files. We generate it ourselves after upload. Configure scorers, displaces, and tiebreakers when you edit your meet at admin.athletic.live.


How helpful was this article?


Powered by HelpDocs (opens in a new tab)