If the race does not already contain a field for the data you want to import, start by creating a new field under the “Custom Racer Fields” button
ON NEXT.ZONE4.CA ONLY FOR NOW, find the “import column from CSV file” button under the racer tools section.
Select the CSV file you want to import data from, and then set up the column matches:
- “CSV File column to use for matching” is the name of a column in your CSV File. select the data in the CSV file that matches some data already in your race file
- “Field to use for matching” is the name of a field in your race. Select a field on your race that contains some data which exists in both the race and the CSV file
- “CSV File Column to get data from” is the column containing the data you want to import
- “Field to update” is the name of a field in your race that you want to import data into. any data that already exists in this column will be overwritten with the data in the CSV file.
“Name” is a special value that uses the combined value of a first name and last name column or field.
So for this example, we have a CSV file that contains racer names, and birthdates in a column called “dob”. for any racer in our race file whose name matches a name in the CSV file, we will copy the value of the “dob” column in the CSV file to a field called “birthdate” in the race file.