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

![Mange the list of participants & devices in your event](https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2FF4JupcultvrDYv1NSgzA%2FCSV.png?alt=media\&token=02a69aaa-2c47-4eb6-808e-0fd188b16f5e)

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

{% tabs %}
{% tab title="1. Participants >> Import/Export" %}

<figure><img src="https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2Fj3qlxAqCmMuq9nvqwXFH%2Fscreenshot-racemap.com-2024.08.07-17_22_58.png?alt=media&#x26;token=d8a8ecf1-e4bf-4e25-b0ad-cf03197f4e8d" alt=""><figcaption></figcaption></figure>
{% endtab %}

{% tab title="2. Upload CSV file" %}

<figure><img src="https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2FhWH7OoqQA88iu3FPFPSV%2Fscreenshot-racemap.com-2024.08.07-17_25_30.png?alt=media&#x26;token=11f98219-9f35-47dc-bdb5-ad50f3cb0488" alt=""><figcaption></figcaption></figure>
{% endtab %}

{% tab title="3. Success" %}

<figure><img src="https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2FgcOCxGzXLYtpi2X5Vk0g%2Fscreenshot-racemap.com-2024.08.07-17_29_47.png?alt=media&#x26;token=7e0639d4-c7da-4296-b299-9154ba567c90" alt=""><figcaption></figcaption></figure>
{% endtab %}
{% endtabs %}

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.&#x20;

{% tabs %}
{% tab title="Merge in CSV file, direcly " %}

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.&#x20;

{% file src="<https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2FekU3XOFDKgnaKuLJoxca%2Fsample_list_device_information.csv?alt=media&token=d81047ed-d869-45b9-8758-59fc13297a77>" %}
Sample CSV file with `imei` and `device_name` of rented the trackers.
{% endfile %}

2. 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.&#x20;

{% file src="<https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2FPV6xWzO2tOxchq2y1BcJ%2Fsample_list_participant-device_information.csv?alt=media&token=4e57268a-4f0f-4f02-8664-8d8b184f0b6f>" %}
Sample CSV file with merged information of your participants and the rented trackers.
{% endfile %}

<figure><img src="https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2FbZMBD1bB7YeW5bhe9c8i%2Fscreenshot-racemap_com-2024_09_25-16_43_27.png?alt=media&#x26;token=3ac1ecf9-7688-4d7e-a03c-03c79f81a3d4" alt=""><figcaption><p>Sample CSV file such that the participant list provides this information about participants and GPS trackers.</p></figcaption></figure>
{% endtab %}

{% tab title="Merge with the tracker management" %}
{% file src="<https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2FoWDwPc8gaLLsiZXJVJK7%2Fsample-minimal_list_participant_information.csv?alt=media&token=44fd0cce-6337-40f7-8cea-262665a42db0>" %}
Add participant information in this minimal sample file.
{% endfile %}

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.

{% file src="<https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2FfzkfKJcHUe3AXPjYfT52%2Fsample_list_participant_information.csv?alt=media&token=fe210917-77db-4c2d-8f9f-c1f0cb707961>" %}

<figure><img src="https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2F8wTQT4G6nSfAc60sOXD0%2Fscreenshot-racemap.com-2024.08.07-16_56_52.png?alt=media&#x26;token=d6c1f8d7-e143-4414-b521-e33f0ac82b18" alt=""><figcaption><p>Sample CSV file such that the participant list provides this information about participants.</p></figcaption></figure>

2. Merge your GPS trackers with uploaded participants in the tracker management according the instructions on [Add devices to event](https://docs.racemap.com/tracker-management/add-to-event).
   {% endtab %}
   {% endtabs %}

#### 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

{% file src="<https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2F00pgi6J104EWFsQIFIdj%2Fsample_participant_file.csv?alt=media&token=0f0fc03a-a021-47c5-a3d3-4221125687e1>" %}

![sample\_participant\_file.csv in an editor](https://1672210197-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSRNxaH2Ju9Flr7JhJD%2Fuploads%2FzePbobCklaIUF1Sw5WDf%2FScreenshot%202024-09-25%20165948.png?alt=media\&token=defbbabc-ef12-40c7-bec4-5f373c58ef6a)

* Only refresh the needed parameters. No need to keep all parameters in the file.
* Parameters are semicolon-separated.&#x20;
* Any sequence of parameters is allowed.
* Empty cells are accepted.

<table><thead><tr><th width="216.7146836227593">Parameter</th><th width="332.7637445340682">Description</th><th>Sample</th><th data-hidden></th></tr></thead><tbody><tr><td><code>startnumber</code></td><td>bib number of participant</td><td>40012, 🔥, Max</td><td></td></tr><tr><td><code>name</code></td><td>name of participant</td><td>Max, 🔥, 40012</td><td></td></tr><tr><td><code>imei</code></td><td>IMEI or transponder ID of device</td><td>4106050246, RRPing_ZDKAR32, RRPing_70761</td><td></td></tr><tr><td><code>device_class</code></td><td>specific device class</td><td>Mobile, Tracker, Upload, Transponder, TrackPingTransponder</td><td></td></tr><tr><td><code>device_type</code></td><td>specific device type </td><td>GL300, LK106, active, passive</td><td></td></tr><tr><td><code>marker_color</code></td><td>color of marker in tracking map, hex code</td><td>#023d10</td><td></td></tr><tr><td><code>tags.[attribute]</code></td><td>additional attributes to filter participants eg. age group, status or nationality <code>tags.Age</code> or <code>tags.Status</code></td><td>35, 24 <br>DSQ, DNS, DNF</td><td></td></tr><tr><td><code>startTime</code></td><td>timestamp of first location in UTC, first location   that is considered in the event, locations before are ignored</td><td>2021-10-23T00:35:00.000Z</td><td></td></tr><tr><td><code>endTime</code></td><td>timestamp of last location in UTC, last location   that is considered in the event, locations after are ignored</td><td>2021-10-23T01:15:59.710Z</td><td></td></tr><tr><td><code>manualResult</code></td><td>duration to finish [hh:mm:ss]</td><td>06:10:13</td><td></td></tr><tr><td><code>times.start</code></td><td>timestamp of first timing split in UTC, considered in leaderboard. If <code>startTime</code> is undefined, then <code>startTime</code> is written accordingly.</td><td>2021-10-23T00:55:35.000Z</td><td></td></tr><tr><td><code>times.end</code></td><td><p>timestamp of last timing split in UTC,</p><p>considered in leaderboard. If <code>endTime</code> is undefined, then <code>endTime</code> is written accordingly.</p></td><td>2021-10-24T05:31:41.021Z</td><td></td></tr><tr><td><code>key</code></td><td>no import if value of <code>key</code> does not belong to Racemap event</td><td>3Z2GPX</td><td></td></tr><tr><td><code>starter_id</code></td><td>unique Racemap ID of participant, assigned to specific participant</td><td>617bb83e4cc0e8c92c7bfcb5</td><td></td></tr><tr><td><code>device_id</code></td><td>unique Racemap ID of device</td><td>5b6ac1561c6a700020a00133</td><td></td></tr><tr><td><code>device_name</code></td><td>name of GPS device in tracker management</td><td>A00133</td><td></td></tr><tr><td><code>player_link</code></td><td>URL to select participant in tracking map</td><td><a href="https://racemap.com/player/participant-list-sample#selected=617bb83e4cc0e8c92c7bfcb5">https://racemap.com/player/participant-list-sample#selected=617bb83e4cc0e8c92c7bfcb5</a></td><td></td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.racemap.com/api-import-and-export-data/import-data-from-csv.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.