How Do I Upload Data in Division

Import Schedules

Manually typing out or copy+pasting game info into your schedule every flavour? Fugeddahboudit! Instead, y'all can upload a CSV file of your schedule, map the details to TeamSnap schedule fields, and bada-bing bada-boom, schedule made!

In this commodity

• Import Division or Full Organization Schedule
• Import Team Schedule

Attention: CSV files are the only accepted file types for importing organization-level schedules. If yous are importing an organization schedule using a custom file in Excel (.xls) format, you'll need to save/consign it every bit a CSV file before proceeding.

---

If you lot are an administrator for an business relationship using TeamSnap for Clubs and Leagues, and so nosotros recommend downloading the arrangement schedule import template and plugging in your information for all-time results.

Download Org Schedule Import Template

*This template volition not work for squad-level imports.

Importing Prerequisites

✔ Set all divisions and/or teams in TeamSnap
✔ Add any external (non-league) opponents
✔ Add together locations in the organization-level Schedule tab
✔ Make sure all team names, external (non-league) opponent names, and location names in the import file match exactly to how they are spelled in TeamSnap (case-sensitive)
✔ Remove whatsoever blank rows, columns, and actress bare spaces before or after any of the information in each cell in your import file

Formatting Requirements

The first row of your file will be read by the system every bit column headings for mapping the imported information to the right fields. If yous prefer to apply your own custom file, ensure that your cavalcade headings lucifer the fields in the schedule in order to correctly import schedule data.

• Date: MM/DD/YYYY
  • Ensure date format is also set to this format under Team Settings in the Manager tab.
  • Teams using international date format must switch to the MM/DD/YYYY format before importing to avert errors and tin can switch back after the import is consummate.
• Start/End Time: HH:MM AM/PM
• Arrival Fourth dimension: # of minutes prior to start time (for case, xxx)

View division and org schedule import cavalcade headings

Required columns: These columns should not be deleted or your import volition fail.

• Date
• Kickoff Time
• Partitioning
• Abode Squad
• Location

Optional columns: These columns tin be deleted from your import file if they are not needed.

• End Time
• Arrival Fourth dimension
• Brusque Characterization
• Event Type
• Away Team (For effect import files only.)

---

Importing a Division or Org Schedule File

1. Click the Schedule tab
2. Click the Schedule Importsbutton
3. Click on the Upload Schedule from File button
   
4. Click Cull File and select your CSV schedule file on your computer
5. Decide if you want league-controlled or team-controlled events:
   • League-controlled (box unchecked): League-controlled games and events are visible to participating teams, but game results can simply exist entered at the team-level when allowed under the organization Settings Tab.
   • Squad-controlled (box checked): Sports org admins and team admins volition be able to edit games/events and enter game results, games and events will be displayed in org, division, and team schedule tabs, merely can only be edited at the squad level. Changes made within a team to an event where the opposing team is in the aforementioned league will only be reflected in the team where the change was made.

     

6. Click Continue
7. Click on the Create All Events button

To check on the status of your import, become back to the schedule imports list. The condition column will bespeak whether the import/event cosmos was successful or non.

Getting stuck? Check out Troubleshooting Schedule Import Issues.

Back to Top

---

Need to import a schedule direct to a specific team? If you lot are an independent squad owner or manager, or an arrangement administrator needing to import the schedule team-by-team, you tin employ our team schedule import template below, or create your own CSV file to import.

Download Team Schedule Import Template

*This template will not piece of work for partition or system-level imports.

Formatting Requirements

The kickoff row of your file volition exist read by the system as column headings for mapping the imported information to the correct fields. If using your own custom CSV file, the columns in your file should match the fields in the schedule in order to correctly import schedule information.

• Date: MM/DD/YYYY
  • Ensure date format is set this manner nether Team Settings in the Director tab
  • For teams using international date format, switch to the MM/DD/YYYY format before importing and then switch dorsum afterward the import is complete
• Offset/End Time: HH:MM AM/PM
• Arrival Fourth dimension: Minutes prior to start fourth dimension (for example, 30)
• TBD: If you lot practise not have all the details for an upcoming game just demand to become it on the schedule as a placeholder, you can enter TBD for the required fields Location, Opponents, and Time.
• Game vs Event: To specify between practices or game events in your squad import file, simply omit the Opponent for practices. If there is no opponent specified when the data is imported, it will be saved as an event and labeled equally a practice. If there is information in the opponent field, it volition be saved every bit a game. Only events are 'named' via the Name cavalcade. Games volition be represented as either "at opponent name" or "vs. opponent name" on your schedule.

Click to view squad schedule column headings

• Engagement
• Time
• Name
• Opponent Name
• Opponent Contact Name
• Opponent Contact Phone Number
• Opponent Contact Email Accost
• Location Name
• Location Address
• Location URL
• Location Details
• Home or Away
• Uniform
• Elapsing (HH:MM)
• Inflow Time (Minutes)
• Actress Label
• Notes

---

Importing a Team Schedule File

1. Click the Schedule tab
2. Click the Import > Schedule from Filepush
   
3. Click Choose File
4. Select the file to import from your computer and clickOpen
5. Map the information to the appropriate fields
   • Select the respective column name from the drib-down for each cavalcade. If yous don't want to import a column, or there is no match, select No Lucifer. We'll import just the data that has a matching cavalcade name. Scout'due south accolade.
     
6. Fix any import errors
   • Select the appropriate field mapping in the drop-down for mislabeled cavalcade headers. Yous tin edit field data for the import by clicking directly into the field to update the information.
   • If you don't correct identified errors the system will non import those fields and they will be left bare when added to TeamSnap. Missing or incorrect data can be added directly to the schedule once it is loaded into TeamSnap.

     

7. When ready y'all can check/uncheck the box to notify roster members of the schedule updates
   
8. When ready, click Save Schedule to have the organisation consummate the import process

The imported schedule will be available to view under the Scheduletab in TeamSnap. Review the published schedule in TeamSnap to double check for whatsoever incorrect schedule data.

If you realize that incorrect data was imported, you have 2 options for correcting the information:

1. For minimal changes, you can open up the event details in TeamSnap and edit the data for an individual event equally needed.
2. For more than widespread changes, you can delete the games from your schedule, update the import file, and import the file again.

Back to Top

---

Mutual Questions

What's the difference between a game and an event?

The schedule items can be created equally either games or events. It is important to create the correct schedule particular blazon because once created, they cannot be switched. Any changes would have to be made by deleting and recreating the required schedule item.

Games: Schedule items where your team competes against an opponent and there is a scored result. This schedule item type includes fields for games including Opponent, Home or Abroad, Uniform, Enter Results, etc.

Events: Schedule items which can exist annihilation on the schedule that is not a game and does not need results entered including practices, meetings, and parties. This schedule detail type includes fields for events including Daily Repeating Events, Weekly Repeating Events, Short Characterization field, etc.

To distinguish between a game or outcome, administrators can view the edit screen for the schedule item. The edit screen volition be labeled Edit Game or Edit Event.

Final updated on January 24, 2022

elserliffeent1950.blogspot.com

Source: https://helpme.teamsnap.com/article/1292-import-schedules

Share this post