How to Import Teams in CT Live 2.0

Introduction

Though teams can now be imported with athletes in the Import Athletes Tool, there may be situations where you still need to import them separately. This article will walk you through importing teams into an event. 

External Team ID

When importing teams, each Team must have a different External Team ID. This is a unique string of numbers or letters that identifies each Team. The simplest method for assigning External IDs to Teams is to use the Team Name. In your Team File, simply copy the Team Name column to a new column, then rename the copied column as 'External Team ID'.

You can also assign a random string of letters and/or numbers as the External Team ID, but generally, this overly complicates the process. 

Importing

To speed up the import process, you should ensure that the column headers in your file match the values in CT Live. The exact values that are available for import in the Import Athletes tool are: 

• Bib
• External Team ID
• Registration Choice
• Team ID
• Team Status
• Team Name

Example Team Import File Here

Team Tag is no longer able to be imported via the Import Athletes. To import Tags for Teams, do the following or use the previous Team Import process:

To keep tag maps in sync in CT Live, Tags are no longer able to be imported using the Import Athletes tool. To import tags into an event, you will need to do 2 things. 

1. Turn off bib/tag matching in CT Live under Pickup- Bib/Tag Settings.

2. Import a bib-tag map into our system following the steps laid out in this article: How to Offset Bibs and Tags in CT Live

The minimum requirement for importing teams include:

• External Team ID
• Team Name
• Registration Choice
• Bib (if the team is a Relay type)

To Import Teams:

1. Click on the "Import Athletes" page, located in the side Menu of the Athlete tab in CT Live 2.0
   
2. Select an import file from your computer to upload.
3. Once the file is loaded into the importer, hit next. 
   
4. Match the different column headers in your file to the fields present in CT Live using the Map tool.
    

5. Click next again and you will choose a corresponding selection for registration choice and team type, etc. 

   

6. Finally, you will land on a data validation page. This page will tell you how many teams will be created in addition to how many will be updated. Click Start Import Job to begin the upload.
7. Once you start the import job, you will be redirected to the Jobs page which will give you additional progress information on your import in addition to information on failures if applicable. For more information go our article on Jobs HERE. 
8. Once you wish to import teams, you may then wish to import Team Members via the Import Athletes Tool. This can be done following this article: Importing Athletes and Teams in CT Live 2.0 . For your athlete import file, ensure the extra column called "external team id" is appended and that each athlete you wish to put on a team, has a corresponding ID. If you have already imported athletes, you will need to import them again with this additional column to place them on teams.