Import with CSV file

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.

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.

1. Participants >> Import/Export

2. Upload CSV file

3. Success

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.

Merge in CSV file, direcly

Merge with the tracker management

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.

234B

sample_list_device_information.csv

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.

406B

sample_list_participant-device_information.csv

39B

sample-minimal_list_participant_information.csv

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.

299B

sample_list_participant_information.csv

1. Merge your GPS trackers with uploaded participants in the tracker management according the instructions on Add devices to 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.