Runner Import
To facilitate the entry of runners into the system, runners can be imported from Excel spreadsheets (CSV, XLSX). This function is mainly intended for schools and kindergartens, but can of course be used for all types of teams and organizations. Below we explain step by step how to import runners into the system.
Structure of the Import Files
The file must be in XLSX (Excel) or CSV format
All runners must be on one “worksheet” (Excel), all other worksheets will be ignored. The table must follow this schema:
| Vorname | Mittelname | Nachname | Team/Klasse |
|---|---|---|---|
| FirstName1 | Optional | LastName1 | Optional |
Note: The Team column can be named Team or Class!
Example: CSV
With Middle Name
First Name; Middle Name; Last Name; Team;
Peter; ; Tester; 1A
Manuel; Steffen; Rainforest; 1A
Great; ; Guy; 2A Without Middle Name
First Name; Last Name; Team;
Peter; Tester; 1A
Manuel; Rainforest; 1A
Great; Guy; 2A Example: XLSX (Excel)
With Middle Name
Without Middle Name
Import into an Organization
Choose this option if you want to automatically create teams in an organization and import the runners into them. Choose this option if you want to import runners directly into an organization.
If no team is specified for a runner in the file, they will be imported directly into the organization. If a team is specified, the team will be searched for in the organization and created if not found - then the runner will be imported into the team.
From the Organization Overview
Open Overview
Open the Orgs page in the runner system
Select File
Click on Import Runners at the top
Click on Select File and choose the file from which you want to import runners
Verify Runners
A summary of all runners found in the file will be displayed - check all runners for correctness
Select Organization
Select the organization at the top into which the runners should be imported.
Start Import
Click on Import Runners at the bottom to import the runners or Cancel to cancel the import.
The runners will now be imported into the organization.
From the Organization Detail View
Open Overview
Open the Orgs page in the runner system.
Click on the Details button for the desired organization.
Select File
Click on Import Runners at the top.
Click on Select File and choose the file from which you want to import runners.
Verify Runners
A summary of all runners found in the file will be displayed - check all runners for correctness
Select Organization
Select the organization at the top into which the runners should be imported.
Start Import
Click on Import Runners at the bottom to import the runners or Cancel to cancel the import.
The runners will now be imported into the organization.
From the Runner Overview
Open Overview
Open the Runners page in the runner system
Select File
Click on Import Runners at the top.
Click on Select File and choose the file from which you want to import runners.
Verify Runners
A summary of all runners found in the file will be displayed - check all runners for correctness
Select Organization
Select the organization (does not have a > in the name) at the top into which the runners should be imported.
Start Import
Click on Import Runners at the bottom to import the runners or Cancel to cancel the import.
The runners will now be imported into the organization.
Import into a Team
Choose this option if you want to import runners directly into a team.
If a team is specified for a runner in the file, it will be ignored and overwritten with the selected team.
From the Team Detail View
Open Overview
Open the Teams page in the runner system.
Click on the Details button for the desired team.
Select File
Click on Import Runners at the top.
Click on Select File and choose the file from which you want to import runners.
Verify Runners
A summary of all runners found in the file will be displayed - check all runners for correctness
Select Team
Select the team at the top into which the runners should be imported.
Start Import
Click on Import Runners at the bottom to import the runners or Cancel to cancel the import.
The runners will now be imported into the team
From the Runner Overview
Open Overview
Open the Runners page in the runner system.
Select File
Click on Import Runners at the top.
Click on Select File and choose the file from which you want to import runners.
Verify Runners
A summary of all runners found in the file will be displayed - check all runners for correctness
Select Team
Select the team (has a > in the name) at the top into which the runners should be imported.
Start Import
Click on Import Runners at the bottom to import the runners or Cancel to cancel the import.
The runners will now be imported into the team