Bulk Add Players

You can import many players at once using the Bulk Upload System.

Use our ready-made spreadsheet to make this process super easy.

Procedure

1. Log in to your xsyte, and go to the admin area by clicking the Admin link
2. Go to League > Players
3. Select Bulk Import Players and Staff
4. Copy and paste your formatted spreadsheet data (do not include headers)
5. Click Submit Bulk Player Data

The format is:
Season ID, Team Name, First Name, Last Name, Email Address, Position Code, Jersey Number, Captain Type
The first 4 fields are mandatory, the last 4 are optional.  Each player should be entered on new lines.

Note: When you paste your spreadsheet content into XSYTE the Commas may be represented by Tabs.  That is OK!  XSYTE will automatically convert tabs to commas.

Your text will look something like:

35, Blackhawks, Patrick, Kane, [e-mail], RW, 88
35, Blackhawks, Jonathan, Toews, [e-mail], C, 19, C
35, Blues, Alexander, Steen, [e-mail], LW, , A
35, Blues, Vladimir, Terasenko
40, Cubs, Kris, Bryant, , 3B, 17
40, Cubs, Anthony, Rizzo, [e-mail], 1B, 44

Information about Each Field

Season ID - Find the number associated with your season - it will be listed on the Bulk Upload Page.  This number is needed to make sure we have the right team.  For instance, the Blackhawks play in a number of seasons, so by specifying the season id we know exactly which Blackhawks team to add a player to.

Team Name - Expand the season box to show the Team names that will be accepted.  Be sure to get the team name exact so the system can find the team.

First Name - The player’s First Name.

Last Name - The player’s Last Name.

Email Address (optional) - The player’s email address.  
Why do I need this? - This can be useful so you can communicate with the teams if needed.  For instance if a game needs to be cancelled, you can send a message to game participants.

Jersey Number (optional) - The number the player wears on their jersey.

Position Code (optional) - Use the positions box to find the code associated with the player position.  Example: ‘G’ for ‘Goalie’, ‘F’ for ‘Forward’, ‘HC’ for ‘Head Coach’ etc.

Captain Type (optional) - Use ‘C’ for ‘Captain’ or ‘A’ for ‘Assistant Captain’.

Creating the Data
Use our ready-made spreadsheet to make this process super easy.

1. Populate this spreadsheet
2. Use the data on the Bulk Upload Page to Fill out the Blue Fields.
3. Copy all the data from the spreadsheet, but do not include the headers.
4. Paste into the Bulk Player Data Box.
5. Click the Submit Bulk Player Data Button
6. Read the Report! It will tell you what processed successfully and if there were any errors.

Materials & Resources

Use this google spreadsheet to create your Bulk Upload Code block.  Fill in the spreadsheet and then save as .csv file.  Copy the contents of the file, paste in the Bulk Add Players form, and click Submit Bulk Player data.

1. https://docs.google.com/spreadsheets/d/1BpraAH7zSDYFAZObOAB6Z5WluobHJpdXM_Eoc5mWYT8/edit?usp=sharing
2. Check out the video: (Coming Soon)