TABLE OF CONTENTS
- CSV File
- Uploading Results
- Setting the Headers
- The Results Table Preview
RunSignup offers race directors a way to easily display their race results on a platform that allows for advanced searching and easy readability. RunSignup’s solution to results provides runners with a much more modernized presentation of information than the old standard of simple text, and is visually easier to comprehend. See below to learn how to upload your results to RunSignup.
Note: If you are using Internet Explorer as your web browser you may have trouble uploading results. Please use a more modern browser like Microsoft Edge, Mozilla Firefox, or Google Chrome if you are having trouble.
To create a modernized results table on RunSignup, all you need to prepare is a CSV file with the results of your race. The CSV file should contain the results of only a single event, and can include fields such as first name, last name, time, age, etcetera, and the fields do not need to be in any particular order.
If your race is made up of multiple events, then you will need to create a separate CSV for each event’s results. For instance - 5k Results, 10k Results, Half Marathon Results.
If you have already enabled Email or SMS notifications for finishers of this Race, and would like these results to generate these notifications be aware that you must supply the RunSignup registration IDs in your results, or import Bib Numbers to your RunSignup database before posting results, otherwise RunSignup will not be able to tie these results back to the users that signed up to track these participants.
Tip: Make sure that the first row of your CSV contains all of the column headers (ex: “First Name”, “Last Name”, “Chip Time”, “Bib Number”, etcetera).
Once you have your CSV file with the results ready for uploading, go to the "Go Race Day" tab of the race dashboard, click on the sub-heading for "Results", and choose the option for "Upload Results".
Pick the “Event” that your results pertain to from the drop down menu provided.
If the event that you are trying to upload results for is a past event that is not listed on the site, then click on the link below the drop down menu that reads: “Create the Event Here”. For more information on this topic, please refer to the upcoming subsection titled “Create a Past Event”.
In the “What do you want to call this group of results?” field, enter in a name for the selected event’s group of results that you are creating (ex: “Overall Results”, “Our Company’s Results”, “EMT Division”, etcetera), and then hit “Continue”.
In the "What E-mail address should be used to for participants to submit questions or issues about the results?" field, please enter in an email address that you would like results questions emails to be sent to. This email will not be listed publically on the website, we will just send any result submission form questions that we recieve on your results page to this address.
Next, click on “Browse” and upload the CSV with the results in it.
Setting the Headers
Verifying the Header Row
In the “Headers” section, begin by making sure that the correct row from your CSV is being used as the “Import Header”.
If the “Import Header” is not using the correct row from your CSV, then find the row that should be used as the “Import Header” row, and click “Use as Header”.
Note: Using a row other than the top row for a header will create a “Data Before Header” section. Anything that appears in the “Data Before Header” section will not be included in the posted results.
Matching the Headers
After checking that the correct row from your CSV is selected as the “Import Header”, you can then verify that all of the “RunSignup Results Display Headers” correspond to the headers in your CSV file.
The row labeled “RunSignup Results Display Header” is made up of drop down menus containing possible column names. Use the dropdowns to match as many of your columns as possible to RunSignup's internal fields.
For the example above, my "User ID" column should be mapped to RunSignup's "Registration ID" field.
If a column in your data does not match one of RunSignup's internal fields, then please use either “(Use Import Heading)” and/or “(Do Not Include)” from the drop down menu. The “(Use Import Heading)” option will set the column name to the one assigned in your CSV, and the “(Do Not Include)” option will omit this column from the final results list entirely.
For example - my column "OVR" will not be included in the results sheet, "Hometown" will be mapped to the standard "City" field in RunSignup, and "GENDER_RANK" will be included as an additional column, using "GENDER_RANK" as the heading.
Note: A unique column name, such as “BIB” or “FIRST NAME” can only be used once per results list. The “(Use Import Heading)” and “(Do Not Include)” options can be used multiple times.
See below for a list of all Results Results Column options that are available to map to, and descriptions of the ones that are not self-explanatory.
Use Import Heading - Include this column from your spreadsheet into the RunSignup's Results Set as an additional column, using the header from your Spreadsheet as the header online.
Do Not Include - Completely ignore this column that is in your spreadsheet and do not include it in your online results. You should select this for any sensitive user data like date of birth or address.
Age Group/Division Name & Place- If you calculated your own Age Group and Division places and have that data in the spreadsheet you are uploading, then you can provide them to RunSignup here. You should provide two columns, one for the name of the Age Group/Division, and another for the place within that Age Group/Division.
If you have a single column that contains both the name and place for Age Group/Divisions, you can either separate them out into two columns, or map them instead using the "Use Import Heading" option as described above.
It is always better to map to an internal field, rather than use the "Use Import Heading" option because RunSignup uses our internal age group/division name and placement fields in the finisher's certificates, and can be utilized in custom results notification text as dynamic placeholders. When you use the "Use Import Heading" option it will upload the data as an additional, custom field and cannot be referenced in the same way as the native field.
REGISTRATION ID - If you have the RunSignup Registration IDs included in the results spreadsheet that you are uploading, please map it to this column. This is needed to send out results notifications. If you have this option mapped to the Registration ID column provided in your spreadsheet, please be sure to check the "Match Users By Registration ID" setting before setting the headers.
BIB - If you do not have the RunSignup Registration IDs included in the results spreadsheet that you are uploading, you can rely on mapping the bib number to RunSignup's internal field for this value in order to correctly send out results notifications. Please note that if you are relying on this method you must have bib numbers assigned to your participant database in RunSignup before uploading results data. Additionally, please be sure to select the "Match Users By Bib or Chip" option before setting the headers.
PLACE - If you have a column in your spreadsheet for overall rank, place, or position, please map it to our "Place" internal field. If you do not provide a column from your spreadsheet to map to "Place", then you must select "Automatically Set Finishing Places". Checking this option will assume that the order in which you spreadsheet was sorted when it was uploaded is the order of their finish. Because of this, be sure that your spreadsheet is sorted correctly if you are not mapping this column, and that you have checked this box.
AVERAGE PACE - By default, if you do not provide a column that is mapped to this field, RunSignup will calculate the paces for all finishers based on their Chip Time and Distance set in the Event Setup. You can override this by providing your own pace calculation here.
If you have not included a column for finishing places in your CSV, then RunSignup can automatically generate this column based on the order of your CSV. To create this column, check off the box for “Automatically Set Finishing Places”.
Note: Do not check off the box for “Automatically Set Finishing Places” if you already have a column designated for finishing places.
Also, if you are uploading a CSV that only contains finishing times along with their corresponding Bibs or Chips, then you can check off “Match Users By Bib or Chip”, and RunSignup will automatically fill in the remaining fields based on the participant information, provided that you have previously assigned bib and chip numbers to each participant on RunSignup.
Please pay close attention to the options for Match Users. This will match your upload to existing participants. This is critical for result notifications to work as it provides a link between the registration and the result. If your CSV includes the registration IDs of existing registrants, check the “Match Users By Registration ID” checkbox. If your CSV includes either Bib or Chip numbers for existing registrants, check the “Match Users By Bib or Chip” checkbox.
The Results Table Preview
Removing a Result Row
You can remove any row from the final results table by clicking on the “Delete” option, but be aware that this option is only available to you before setting the header, so make sure you delete any unwanted rows before clicking “Set Header”.
Setting the Header
When you have finished customizing the header and deleting any unnecessary rows, click on the button marked “Set Header”. At this point, you will be able to review and edit the results before saving them.
Note: If you are using Internet Explorer as your web browser you may have trouble using the "Set Header" button. Please use a more modern browser like Microsoft Edge, Mozilla Firefox, or Google Chrome.
Editing Results Before Saving
Provided that you have clicked the “Set Header” button, you will be able to edit each individual’s results prior to saving. If you happen to find a mistake in your CSV entry while reviewing the results, then simply click on the cell that needs to be updated. A pop-up box will appear, allowing you to edit that particular field, and once the field contains the correct information, click on the button marked “OK”.
Once everything has been reviewed, and you are ready to post the results for the public, then click on the “Save Results” button, which is accessible at either the top or bottom of the “Review Results” table. You will receive confirmation that your results have been uploaded, and they will then be viewable on your race page.
Create a Past Event
If you would like to upload results for a race that is not listed on RunSignup, then you can click on the “Create the Event Here” link. This link can be found under the “Event” field, immediately after you select “Upload Individual Results”.
To “Create a Past Event”, simply enter in the “Event Name” and “Event Date”, select the “Type” of event it was from the drop down menu, and indicate the “Distance” of the event in miles, kilometers, yards, or meters. When you are finished, click “Add Event”, and you will receive confirmation that your past event has been created.
After creating a past event, you will be able to select it from the “Event” drop down on the “Upload Individual Results” page, and continue along with uploading results as explained in the previous subsection labeled “Uploading Results”.
Viewing Your Results
To view your race’s results, go to your race page, and open up the “Results” tab. From here you will be able to open up any of the available results sections that were previously uploaded.
Managing Existing Results
To manage existing results, return to the "Go Race Day" tab of the race dashboard, open up the "Results" section, and click on the option for "Edit Results".
This page will allow you to download the results as a CSV, edit the existing results, or delete that particular results list. For more information on editing the results, please refer to the section on “How to Edit Existing Results”.
In addition to being able to upload your results in the form of a CSV, you do have the option to “Upload a Preformatted Results List” from either a website, PDF, HTML or text file. You can learn more about this topic, by referring to the section “How to Upload Preformatted Results”. Keep in mind though, that preformatted lists are not viewable via RunSignup’s specialized results table, so for the purpose of functionality and the convenience of your runners, it is strongly recommended that you upload your results in the form of a CSV.