How do I import a team roster?
LeagueStat.com offers users the ability to import a team roster from a CSV file.
From Roster Management administration, click the "Import CSV"
link at the top of the page - a pop-up window will load. From here, you
can download a LeagueStat.com import template that contains the fields
that can be imported to the database for your configuration.
Most databases contain the following fields (accepted values)
Last Name (Text Field)
First Name (Text Field)
Shoots (L or R - used for skaters)
Catches (L or R - used for goalies only)
Jersey Number (Integer)
Position (Must match positions in database, positions can be
customized for each configuration. Default values are "D" "RW" "LW"
"C" "RD" "LD" and "G")
Height (Decimal - 6'1 = 6.01, 5'10 = 5.10)
Birthdate (Date - must be in the YYYY-MM-DD format)
Hometown (Text Field)
Homeprov (Text Field)
Rookie (0 if the player is not a rookie, 1 if the player is a rookie)
Column headings must match the column headings that are provided in the import template.
Note: First and Last name are the only required fields for a successful
import. It is highly recommended that the jersey number field be
completed prior to import.
Once you have completed the import file, return to the pop-up window to
upload your file. The LeagueStat.com system will attempt to match
players within your CSV file to players that already exist within the
database in an effort to prevent duplicates. Players that were matched
to existing players in the database will be displayed at the top of the
page. New players to the LeagueStat.com database will be displayed
Click "Close" to return to Roster Management Administration.
Add a player to a team roster
In the menu on the left of the screen, click People. To find the player you want to add to a roster, do any of the following: In the Search field, type a player name or ID Under Filters, click any of the drop-down lists to filter by a season, team, ...
Export a roster
If you want to make a number of changes to a team’s roster, you can export a spreadsheet of an existing roster. Once you export the spreadsheet, you can make a number of changes, and upload the roster again. For a sample of the correct formatting and ...
Edit a player's team history
If a player’s team history information is incorrect, you can edit or delete an entry in the team history. In the menu on the left of the screen, click People. To find a player, do any of the following: In the Search field, type a player name or ...
Add a player to a roster from the Roster Management screen
You can add a player to the roster from the Roster Management screen, or you can add a player to a roster from the Player Profile screen. In the menu on the left of the screen, click Teams > Roster Management. In the drop-down lists in the upper ...
Add or remove players from a roster using transactions
When you enter a player transaction, the player is automatically removed from the current team’s roster, and, if applicable, moved to a new team’s roster. For instance, if you enter a trade, the player is automatically removed from the current roster ...