

You can add any other fields in your spreadsheet and it will be added in the Zone4 Race Timing System. Number fields can be used to create groups on the results (for example, age groups). If all the data in a column is numeric, the column will be imported as a number field. “A1”, or a comma separated list of chips for racers or teams with multiple chips, e.g.

The data for the “chip” column should be a single chip name, e.g. Use the column header “chip” or “chip_list” to set the “Chip Numbers” field on racers. Date fields can be used to calculate ages. If all the data in a column is in the format YYYY-MM-DD, it will be created as a date field. Racers with a value that isn’t male or female will be grouped into a “Gender: Not Set” group on the results. Other values are valid and will not cause errors when uploading, but only male and female groups will be created for results or start groups. If the column header is “gender” or “sex”, the data in that column should be “m”, “male”, “f”, or “female”. Use the column header “bib” to assign Racer Numbers. Note that the file will not upload unless you have columns named “first_name” and “last_name”. The first row in the file must contain column headers. To add common fields such as name, bib numbers, sex/gender, age, and timing chip, the column headers and the data fields must follow the format outlined below. Each column in your spreadsheet will be uploaded as a field in the Zone4 Race Timing System.

Please see your spreadsheet software’s help docs for instructions on saving CSV files:ĭata from the CSV file will not upload unless it is formatted correctly. If our file includes special characters, it needs to be saved as a UTF-8 File type This is a standard file format that can be exported by Excel, Numbers, Google Sheets, and other applications. You must save the file as a. You can upload racers into the Zone4 race timing system from a CSV file. For information about uploading club members into the registration system, please see this page. This is the process for uploading people into a race.
