This works on Reports such as: Basic Roster, Safe Roster Report or TeamSideline Game Card or Other. This is accessible by going to Reports > Report Viewer.
The Jersey # and Size is also on the TeamSideline Game Card and the various scoresheets. Note: Importing the Jersey # and Size is specifically for "Report Viewer" Reports as this import will not import the Jersey # and Size onto Team Sites.
The Jersey Size data will be automatically populated from your enrollment field. Note: The enrollment field must be called one of these things:
jersey number
jersey numbers
jersey #
shirt number
shirt numbers
shirt #
This article explains how to populate Jersey # data into your site if it has not already been added.
- As an Admin, create custom fields to accomodate the information: Custom Fields functionality is at Administration > Configurations > Custom Fields.
- Create one field named "Jersey #" as a two or three character Text field with a category of Player.
- After the custom field is added, parents or admins can add the Jersey # to the player account. Note: You can also setup the custom field to not be editable by parents so that only the league admins can update this data.
- If you want to add Jersey #s to the player accounts in bulk, run an Account Information or the Enrollment Information report so you can get the "Player ID - TeamSideline" for each player. You can find this report at Report > Reports Export . Note: You probably want to add the Player First Name and Player Last Name fields to this report to help you input the correct Jersey #s. These two name fields can be removed before the next step.
- Once you have the "Player ID - TeamSideline", go to Administration > Import Data and click the Excel icon to open the "Player Custom Field Import" Excel file.
- Next, paste the "Player ID - TeamSideline" from the report and the Jersey # from wherever you have the Jersey # into the "Player Custom Field Import" Excel file.
- When the data is in the "Player Custom Field Import" Excel file, click the "Player Custom Field Import" link on the Import Data page to import the Jersey #s.
- After the import is complete, the Jersey #s will be visible on the Safe Roster Print Out (Reports > Report Viewer> Launch Report Viewer).
If you want to use this also for adults/parents, then do the following.
- As an Admin, create a custom field named "Jersey #" (notice there are two spaces between "Jersey" and "#") as a two or three character Text field with a category of Parent. Custom Fields functionality is at Administration > Configurations > Custom Fields. Note: The field must be named "Jersey #" in order for the Report Viewer reports to work correctly.
- After the custom field is added, parents or admins can add the Jersey # to the parent account. Note: You can also setup the custom field to not be editable so that only the league admins can update this data.
- If you want to add Jersey #s to the parent accounts in bulk, run an Account Information or Enrollment Information report so you can get the "Parent First Name" and "Parent Last Name" for each adult. You can find these reports at Report > Reports Export .
- Add a new column to the Excel file for the "Jersey #". Save as a CSV file.
- Go to Administration > Import Data and click the "Parent Custom Field Import" link on the Import Data page to import the Jersey #s.
- After the import is complete, the Jersey #s will be visible on the Report Viewer reports.