LogoLogo
UpdatesGPS trackersLoginFree trial
  • Welcome
  • Quick start guide
  • Provide live tracking
    • Features of visualization
    • Leaderboard
    • Monitor
    • Group and stages
    • Embed interactive content
    • Keys and passcode
    • Activity upload
    • Deep links on tracking app
    • Shadowtrack and mapping
  • Data APIs for live geodata
    • */current, location data
    • */distance and locations
    • */times, reads and raw data
    • */ranks, ranking and results
    • */starters, athlete data
    • */geo, geo elements
    • Tools to extract live data
  • Import participant data
    • Import with API, automatically
      • Generic import
      • RACE RESULT import
    • Import with CSV file
  • Tracker management
    • Add GPS trackers
    • Add RACE RESULT readers
    • Add devices to event
    • Send messages
    • Compose messages
    • User access to devices
    • Manage SIM cards
  • Hardware for live tracking
    • Configure GPS tracker
      • Remote configuration
      • Physical configuration
    • Update firmware of GPS tracker
    • Configuring trackers for increased autonomy
    • Track Box forwarding
    • Insiders GPS trackers
    • Prepare smartphone
    • Using GPS trackers On-Site
    • Debug tracking devices
  • Predictive tracking with reads from race timing
    • RACE RESULT
    • Other timing system
      • ChronoTrack forwarder
      • MyLaps forwarder
  • Integrations
    • Wiclax
  • Map settings
    • External map layer
  • Export data from RACEMAP
    • Hosted elevation service
    • Hosted loads information
    • Download leaderboard CSV
    • Download recorded GPX
Powered by GitBook
LogoLogo

Legacy

  • Contact
  • Terms of use
  • Privacy Policy
  • Imprint

About Racemap

  • Pricing
  • About Us
  • Apps
  • Events

Follow us

  • facebook
  • youtube
  • linkedin
  • github

Maps: ©Mapbox ©OpenStreetMap ©RACEMAP

On this page
  • Usage of CSV file
  • Format of CSV file
  1. Import participant data

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.

PreviousRACE RESULT importNextTracker management

Last updated 7 months ago

Usage of CSV file

  • 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.

Upload participant list

You want to use a CSV file to upload basic participant information - startnumber, name, tags, and marker_color - to a specific event.

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.

  1. 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.

  1. 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.

  1. Add participant information startnumber, name, tags, and marker_color in the minimal sample participant CSV file. Upload the resulting participant CSV file to your event.

Update participant list

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.

Format of 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.

Parameter
Description
Sample

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

Where to upload the CSV file with participant's information? Select the relevant event from your event list - - open the (1.) Participants section and select (2.) Import/Export.

Merge your GPS trackers with uploaded participants in the tracker management according the instructions on .

https://racemap.com/admin/events
Add devices to event
https://racemap.com/player/participant-list-sample#selected=617bb83e4cc0e8c92c7bfcb5
234B
sample_list_device_information.csv
Sample CSV file with imei and device_name of rented the trackers.
406B
sample_list_participant-device_information.csv
Sample CSV file with merged information of your participants and the rented trackers.
39B
sample-minimal_list_participant_information.csv
Add participant information in this minimal sample file.
299B
sample_list_participant_information.csv
2KB
sample_participant_file.csv
Mange the list of participants & devices in your event
Sample CSV file such that the participant list provides this information about participants and GPS trackers.
Sample CSV file such that the participant list provides this information about participants.
sample_participant_file.csv in an editor