Import with CSV file
Use a CSV file to upload participants and devices for live tracking in RACEMAP. Download the participant list as a CSV file or automatically call the API endpoint.
Last updated
Use a CSV file to upload participants and devices for live tracking in RACEMAP. Download the participant list as a CSV file or automatically call the API endpoint.
Last updated
Import participants and add devices (GPS tracker, transponder, Track Box, decoder).
Download the participant list for further processing eg. updating an existing list.
Automatically call the participants' information from the given API endpoint.
You want to use a CSV file to upload basic participant information - startnumber, name, tags, and marker_color - to a specific event.
Where to upload the CSV file with participant's information? Select the relevant event from your event list - https://racemap.com/admin/events - open the (1.) Participants section and select (2.) Import/Export.
This section introduces the two options - CSV file & tracker management - on how to merge the information of a participant with a specific GPS tracker that this participant will use for live tracking. Both options work with your GPS trackers the same way as with rented GPS trackers from RACEMAP.
GPS trackers from RACEMAP: We provide a CSV file with devices' information imei and device_name of the trackers sent to you. device_name matches the sticker on the device, helping to identify a specific device with a friendly name.
Use the provided CSV file with the device information as a template and add participant information startnumber, name, tags, and marker_color. Upload the resulting CSV file - that contains the merged information of participants and trackers - to your event.
Follow the workflow to update & add entries in an existing participant list using a CSV file.
There is a unique starter_id generated for each new participant that is uploaded without a starter_id.
Download the current participant list. The CSV file includes starter_id for each participant.
Modify or add data in the CSV file such as race number, name, color, IMEI or app ID, key, tags.
Upload the reworked CSV file. The entries in Racemap are updated corresponding to the starter_id.
It is not possible to delete entries by uploading a CSV file.
Only refresh the needed parameters. No need to keep all parameters in the file.
Parameters are semicolon-separated.
Any sequence of parameters is allowed.
Empty cells are accepted.
startnumber
bib number of participant
40012, 🔥, Max
name
name of participant
Max, 🔥, 40012
imei
IMEI or transponder ID of device
4106050246, RRPing_ZDKAR32, RRPing_70761
device_class
specific device class
Mobile, Tracker, Upload, Transponder, TrackPingTransponder
device_type
specific device type
GL300, LK106, active, passive
marker_color
color of marker in tracking map, hex code
#023d10
tags.[attribute]
additional attributes to filter participants eg. age group, status or nationality tags.Age or tags.Status
35, 24 DSQ, DNS, DNF
startTime
timestamp of first location in UTC, first location that is considered in the event, locations before are ignored
2021-10-23T00:35:00.000Z
endTime
timestamp of last location in UTC, last location that is considered in the event, locations after are ignored
2021-10-23T01:15:59.710Z
manualResult
duration to finish [hh:mm:ss]
06:10:13
times.start
timestamp of first timing split in UTC, considered in leaderboard. If startTime is undefined, then startTime is written accordingly.
2021-10-23T00:55:35.000Z
times.end
timestamp of last timing split in UTC,
considered in leaderboard. If endTime is undefined, then endTime is written accordingly.
2021-10-24T05:31:41.021Z
key
no import if value of key does not belong to Racemap event
3Z2GPX
starter_id
unique Racemap ID of participant, assigned to specific participant
617bb83e4cc0e8c92c7bfcb5
device_id
unique Racemap ID of device
5b6ac1561c6a700020a00133
device_name
name of GPS device in tracker management
A00133
player_link
URL to select participant in tracking map
imei and device_name of rented the trackers.
