Category: Import Teams
This utility is used for importing team settings, not rosters. For information about importing team rosters, see Import Members
You can import team information from a spreadsheet file rather than entering it all by hand using the Information form mentioned above. To do this, you'll need to create a spreadsheet file containing a row for each team and columns across for each piece of information you wish to import. The file you create must be saved as a comma separated value (.CSV) file. This file type can be generated from Excel using the Save As dialog box. To perform the actual import see the link towards the top of the Division & Teams page.
You can also use a file that was downloaded from the site using the "Export Team Data" report, also found at the top of the Division & Teams page. These files can be directly re-imported after downloading. In this way, the downloaded data can become a backup for your site's data that can later be restored by simply re-importing it should something go wrong with the data on the website. You can also use the downloaded data to make changes en masse and then re-import the changes.
The information you can include in the import file is specified below. Note that all columns are optional except for the Team Name column. The first line of the file must contain the names of the columns as specified below. The order they are encountered in the first line specifies the column order for all subsequent data in the file.
- Team_ID
- Internal database record ID from the LeagueAthletics.com database. These numbers should only come from the Export Team Data report from the website and are used to identify each team's existing data record. If these numbers are not present, the software will attempt to match existing team data based on name and division/league. If no match is found, a new record will be created.
- League/Division
- Designates the Division of the team. Must start with ">" and use ">" to show hierarchy (>League>Division>Team)
- Team_Name*
- This is the team's official name, like "U12 Bobcats."
- Nickname
- This is the nickname of the team, such as "Bobcats."
- Alias
- Used for importing schedules
- Position
- Used to order teams
- Public
- Yes - to show the teams under the Teams drop-down on the homepage of your site. No - to hide this team from public view.
- Public_Rosters
- Yes - to show a no-contact Roster available to the Public
- LastInitialOnly
- Yes - to show only First name, Last Initial on Public Roster
- Hide_Birthdays
- Yes - to hide Birhdays on the Full Contact Roster
- Show_Management
- Yes/No - If "Yes," show management (coach(s), team manager(s), etc) "Public" contact information on the team's Bulletins page.
- Live_Schedule
- Yes/No - If "Yes," schedule changes are e-mailed to all affected team members and their parents.
- If another manager schedules a game with this team, notify this email address.
- Show_Results
- Yes - will show the Results tab for this team under the team section in your website.
- Team_Password
- Restricts view of roster to only team members
- Manager_Password
- Provides specific Admin rights to Password holder
These fields are intended only for Soccer organizations:
- TeamType
- ...
- Gender
- M or F
- AgeGroup
- "U11"
- League
- ...
- SeasonalYear
- "2012 Spring"
- HomeShirt
- Color
- HomePants
- Color
- HomeSocks
- Color
- AwayShirt
- Color
- AwayPants
- Color
- AwaySocks
- Color