RACE RESULT import

Synchronize participants data in your RACEMAP events with RACE RESULT Simple API. Use the import for automatization.

Go to participants settings in your RACEMAP event and open the import/export tab. Paste the RACE RESULT event id or the URL of the access file. RACEMAP checks the access and provides feedback. Select the contests for synchronization with your event RACEMAP.

Multi-stage events with one participant file in RACE RESULT: To prevent overwriting start- and finish reads in finished stages with data from the running stage, deactivate the synchronization in finished stages.

Simple API

To let RACEMAP query participant data go to Main Window, Simple API, and select Racemap access.

Simple API must provide the parameters:

ID in Id field
Contest

If Id or Contest parameter are missing the participants arn't pulled to RACEMAP.

ID must be unique within each contest.
ID is the identifier to address participant information in RACEMAP when synchronizing with RACE RESULT.
A new ID creates a new entry in the event in RACEMAP.
If one ID is removed then the corresponding entry is deleted in RACEMAP.
Timestamps in Start- and Finish fields in UTC format: ISO 8601 https://en.wikipedia.org/wiki/ISO_8601
Timestamps in Start- and Finish fields set the First- and the Last Time of the participants in RACEMAP, and directly impact the visibility of devices in the tracking map.
The fields Age, Sex, Club, Nationality, and Status are imported as tags into RACEMAP participant list.

Parameters of the simple API displayed in tracking map: RaceNr, Firstname, Lastname, Status, Age, Sex, Club and Nationality.

Transponder1 field

Adapt the Transponder1 field for the transponder id of passive- (Bib) or active timing (Transponder1) or use the TransponderInChipFile argument.

When conducting predictive tracking, you can hide participants from visualization depending on their status. The if function in the Transponder1 field removes the transponder id of participants with DNS, DSQ, or DNF status.

if([StatusText]="DNS" OR [StatusText]="DSQ" OR [StatusText]="DNF";"";[Bib])

Prediction: Passings from timekeeping for live extrapolation of participants' location and speed.

Predictive tracking with reads from race timing

Custom field and User defined fields

Use the custom field in the simple API to flexibly import additional parameters:

[Color] to specify markers in the visualization with different colors,
[Key] to enable live tracking with Racemap App,
[IMEI] ids of GPS trackers,
[APPID] and
[TAGS] additional tags to filter participants in the visualization and in the leaderboard.

[Color]&";"&[Key]&";"&[IMEI]&";"&[TAGS]

Go to Main Window, Participants Data, User Defined Fields to define the arguments in the custom field.

[Color]

The color parameter sets various colors of the markers in the tracking map and needs to be defined as color hex code.

Color depending on contests: Switch function in user defined fields. If Contest.Name of a participant is "Gravel" then color is "#F2F2F2". If Contest.Name is "MTB"color is "#04B404".

switch([Contest.Name]="Gravel";"#F2F2F2";[Contest.Name]="MTB";"#04B404")

Color depending on gender: Translate function in user defined fields: Set the first color ("#F2F2F2") for female and the second color ("#000000") for male.

translate([gender];"#F2F2F2";"#000000")

[Key]

Tracking keys connect the RACEMAP App (and custom tracking apps) to enable live tracking for a specific event. You can use keys to offer live tracking as an optional purchase in your online registration form, allowing all participants to join live tracking.

Keys and passcode

Assign keys to participants.

The switch function in the Key field assigns one key to every participant.

switch([Bib]>0 AND [Bib]<=500;[Key_1];[Bib]>500 AND [Bib]<=1000;[Key_2];[Bib]>1000 AND [Bib]<=1500;[Key_3])

Choose function in Key_1 field:

Paste keys from Racemap of the corresponding Racemap event. choose([Bib];"xxxxxx";"yyyyyy";"zzzzzz";...)
Up to 500 keys fit in one user defined field.
For more than 500 participants in the contest set up a second field Key_2 and so on. choose([Bib]-500;"XXXXXX";"YYYYYY";"ZZZZZZ";...)

Online registration with optional live tracking through Racemap App e.g. when the event wants to sell live tracking. Go to Main Window, Participants Data, Additional Fields, and add a checkbox "App".

If function in Key field: If the participant checks "Agree to live tracking with Racemap App" one key is assigned to this participant.

if([App]=1;switch([Bib]>0 AND [Bib]<=500;[Key_1];[Bib]>500 AND [Bib]<=1000;[Key_2];[Bib]>1000 AND [Bib]<=1500;[Key_3]))

[IMEI]

You own GPS trackers or you have rented trackers for an event. You can assign the devices to participants in RACE RESULT, directly. That way the participants data and the tracker information are synchronized with your event in RACEMAP.

[APPID]

For live tracking with RACEMAP App of an event with stages it can be useful to assign the App-Id to the participant information in RACE RESULT. Before the 1st stage, the participants redeem their keys in RACEMAP App. The specific App-Id of one participant becomes known and can be queried with the starters API. This way you can import the participant information including the App-Id for the subsequent stages.

*/starters, athlete data

A participant in RACEMAP, which already has an App-Id, can't get another device id (like a different App-Id, IMEI, or Transponder-Id). It is not possible to delete, refresh, or overwrite an App-Id of a participant through the RACE RESULT import.

To address a different device id you have to import the same participant information with a new import id, which creates a new participant on RACEMAP side.

[TAGS]

Synchronize additional information about categories such as sponsor, mixed team, ... in order to filter participants in the visualization and in the leaderboard. Go to Main Window, Participants Data, Additional Fields, and add the test fields "Team" and "Sponsor".

Argument in TAGS field of the user defined fields to insert the two tags Team and Sponsor of the participant.

"TAGS"&"Team:"&[Team]&",Sponsor:"&[Sponsor]

Best-practice samples

Assigning GPS devices to participants

Efficiently connecting GPS trackers with participant information is essential for a smooth deployment process. To minimize errors and streamline operations, staff members assigning tracking devices should not have to manually read and enter the long IMEI numbers of the trackers.

Automatically assign GPS trackers to participants using bib number

Before each event, prepare your GPS trackers with stickers of the bib numbers.

Go to Main Window, Participants Data, User Defined Fields, and add the field IMEI. Insert the bib number that is attached to the tracker and the corresponding IMEI number of the device.

The code sample inserts five GPS devices with bib numbers into RACE RESULT.

"IMEI" & switch(
        [Bib]="1"; 
        "860201061635184"; 
        [Bib]="2"; 
        "860201061637206"; 
        [Bib]="3"; 
        "860201061636521"; 
        [Bib]="4"; 
        "860201061319011"; 
        [Bib]="5"; 
        "860201061179373"; 
        -1; 
        "NULL"
    )

Friendly name to manually assign a specific GPS tracker to a participant

RACEMAP devices come labeled with a friendly name of six letters. You might use your GPS trackers with your own label system.

Go to Main Window, Participants Data, User Defined Fields, and add the field IMEI. Paste the friendly name of the tracker and the corresponding IMEI number.

The code sample inserts five GPS devices with its friendly names into RACE RESULT.

"IMEI" & switch(
        [Tracker]="A00B40"; 
        "860201061635184"; 
        [Tracker]="A00CFD"; 
        "860201061637206"; 
        [Tracker]="A00CFA"; 
        "860201061636521"; 
        [Tracker]="A00CF8"; 
        "860201061319011"; 
        [Tracker]="A00DC5"; 
        "860201061179373"; 
        -1; 
        "NULL"
    )

Go to Main Window, Participants Data, Additional Fields, and add the field Tracker.

Go to participants and paste the friendly name to address a specifc tracker to the participant. The IMEI of this device will be synchronized through the simple API with the RACEMAP event.

Registration form with live tracking option

Create an online registration form with the option for live tracking either with RACEMAP App or with GPS trackers.

Go to Main Window, Participants Data, Additional Fields, and add the checkbox App and add a second checkbox Tracker.

Key and Key_1 fields are similar to the sample above.

If function in IMEI field: If the participant checks "Live Tracking GPS Tracker" one IMEI is assigned to this participant.

if([Tracker]=1;switch([Bib]>0 AND [Bib]<=100;"IMEI"&[IMEI_1]))

Choose function in IMEI_1 field, past the IMEI numbers from the GPS devices.

choose([Bib];"xxxxxx";"yyyyyy";"zzzzzz";...)

Keys and passcode

Cut-off time at checkpoint

Participants reach the checkpoint before the cut-off time and continue on the white course.

RACE RESULT settings with three contests - grey, white and black
User defined field for sorting participants during the event from grey contest to white or to black depending on detections at the checkpoint.

cut-off

grey

white

black

until cut-off time

all participants

no participant

from cut-off time

no participant

participants with detection at checkpoint

participants without detection at checkpoint

RACEMAP settings:

create a tracking map with the white course (shadowtrack) and synchronize participants from grey and white contests
create another map with the black course and synchronize participants from grey and black contests
create a group and add the white map

Description of the process:

From the start, all participants are calculated on the white- and on the black shadowtrack. That means each participant is shown twice - in the white and the black map.
At the cut-off time the participants in the white (black) contest are synchronized with the white (black) map. That means each participant is visible in either the white or the black map.
Now, add the black map to the group map. That way spectators continue streaming the same group with the new sorting of participants.

To select a contest in the RACE RESULT import at least one participant needs to be assigned to this contest. That means at the beginning you need to add one participant in the white and the black contest. This one participant does not need to have a transponder Id.

PreviousGeneric import NextImport with CSV file

Last updated 5 months ago