Bulk Add Games

You can import your entire schedules 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 > Games
3. Select Bulk Import Games
4. Copy and paste your formatted spreadsheet data (do not include headers)
5. Click Submit Bulk Games Data

The format is:
Season Code, Home Team Code, Away Team Code, Date, Time, Game Type Code, Location Code, Comment, Round
Fields in Black are mandatory.  Each game should be entered on a new line.

Your text will look something like:
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. 

31, Bears, Giants, 2012-04-26, 07:30:00, RS, 4, Season Opener, 1
31, Vikings, Packers, 2012-04-26, 18:30:00, RS
31, TBD, TBD, 2012-06-21, 19:30:00, SF, 4, 1st Place vs. 4th Place
31, TBD, TBD, , , SF, 4, 2nd Place vs. 3rd Place - Date and Time To be Determined
34, Cubs, Mets, 2012-04-26, 07:30:00, RS, 4
34, Cardinals, Braves, 2012-04-26, 18:30:00, RS, 4
34, TBD, TBD, 2012-06-21, 19:30:00, GF, , Winner of SemiFinal 1 vs Winner of Semifinal 2 - Location to be determined

Information about Each Field
Season Code - Find the number associated with your season - it will be listed on the Bulk Upload Page.
Home Team Code - Long Team Name, Short Team Name or Abbreviation is accepted.  Check Spelling is the same on your spreadsheet and in the system.  Use TBD if you do not know the team that will be playing in the game.
Away Team Code - Long Team Name, Short Team Name or Abbreviation is accepted.  Check Spelling is the same on your spreadsheet and in the system.  Use TBD if you do not know the team that will be playing in the game.  Leave Blank if there is no away team required.
Date (optional) - This must be in the proper format 2017-11-29
Time (optional) - This must be in the proper format 18:30:00
Game Type Code - Use the Game Types Box located in the Bulk Import page to find available game types.  Example: ‘RS’ for ‘Regular Season’, ‘GF’ for ‘Grand Final’, ‘BY’ for ‘Bye’ etc.
Location Code (optional) - When you set up a Venue and Game Locations for the venue, those locations ids are listed on the Bulk Import page.  Use the appropriate code in this field.
Comment (optional) - Use this to describe anything about the game.
Round (optional) - Use this to set which round this game is a part of.

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 Games Data Box.
5. Click the Submit Bulk Games 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/1nncIg7rjoBJEzlRRHDz9yPSgPpbPngvyi1yGW9yrA70/edit#gid=1149083814
2. Check out the video: (Coming Soon)