Can you please update the OTHSL TeamSnap formatted schedule so it matches the current format for TeamSnap

[Timothy Horton]

I am getting an error that my Fall TeamSnap schedule I downloaded from the OTHSL website, is not aligned correctly with the TeamSnap format and therefore is not importing the data easily into TeamSnap.  I have attached the file I downloaded from the OTHSL website for Rovers FC O55 team in Div1S as well as the current TeamSnap schedule template that OTHSL can use to reorder the data for the exportable file.  Hoping the league can update the TeamSnap schedule format so I can easily import for the 3 teams in our club.

Thanks

Tim

This is the current layout of the data being exported from OTHSL today.   

Date Time Name Opponent Name Location Name Location Address Location Details Home or Away Uniform Duration (HH:MM) Arrival Time (Minutes) Extra Label Notes

This is the layout of data from the current TeamSnap template.  As you can see the current OTHSL format and the current TeamSnap template format do not align:

Date

Time

Duration (HH:MM)

Arrival Time (Minutes)

Name

Opponent Name

Opponent Contact Name

Opponent Contact Phone Number

Opponent Contact E-mail Address

Location Name

Location Address

Location Details

Location URL

Home or Away

Uniform

Extra Label

Notes

When I import the .CSV file from OTHSL, I get the following errors and message on TeamSnap. 
A key one is the date format is incorrect in the OTHSL data.

Guidance from TeamSnap website:

Import team schedules

Need to import a schedule directly to a specific team? If you are an independent team owner or manager, or an organization administrator needing to import the schedule team-by-team, you can use our team schedule import template below, or create your own CSV file to import.

Download Team Schedule Import Template

Formatting Requirements

The first row of your file will be 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 way under Team Settings in the Manager tab
  • For teams using international date format, switch to the MM/DD/YYYY format before importing and then switch back after the import is complete
• Start/End Time: HH:MM AM/PM
• Arrival Time: Minutes prior to start time (for example, 30)
• TBD: If you do not have all the details for an upcoming game but need to get 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 team 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 as a practice. If there is data in the opponent field, it will be saved as a game. Only events are 'named' via the Name column. Games will be represented as either "at opponent name" or "vs. opponent name" on your schedule. 

Click to view team schedule column headings

• Date
• Time
• Name
• Opponent Name
• Opponent Contact Name
• Opponent Contact Phone Number
• Opponent Contact E-mail Address
• Location Name
• Location Address
• Location URL
• Location Details
• Home or Away
• Uniform
• Duration (HH:MM)
• Arrival Time (Minutes)
• Extra Label
• Notes

Importing a Team Schedule File

1. Click the Schedule tab
2. Click the Import > Schedule from File button
   

• Click Choose File
• Select the file to import from your computer and click Open
• Map the data to the appropriate fields
  • Select the corresponding column name from the drop-down for each column. If you don’t want to import a column, or there is no match, select No Match. We’ll import only the data that has a matching column name. Scout’s honor.
    

Fix any import errors

• Select the appropriate field mapping in the drop-down for mislabeled column headers. You can 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 not import those fields and they will be left blank when added to TeamSnap. Missing or incorrect data can be added directly to the schedule once it is loaded into TeamSnap.

Tim Horton

t...@thehortons.com

M: 508 769-8130

[Jeremy Mordkoff]

Doesn't look hard. 

--
You received this message because you are subscribed to the Google Groups "othsl" group.
To unsubscribe from this group and stop receiving emails from it, send an email to othsl+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/othsl/BL0PR1701MB256224C9ACB7D5C8E0C50B69CF12A%40BL0PR1701MB2562.namprd17.prod.outlook.com.

[Jeremy Mordkoff]

please try again. 

I switched from a tab delimited file to a comma separated file and I added quotes around all data

I fixed the year in the date 

I fixed the date to be mm/dd/yyyy

The Location Name error baffles me. There is a Location Name column. Maybe the other errors threw it off. 

If you think any of the other columns should be included, let me know and I'll add them. 

Jeremy Mordkoff

Webmaster, www.othsl.org

 

[Timothy Horton]

Thanks Jeremy. Will try and export it again this morning and let you know the results 

Tim

Sent from my iPhone

On Aug 9, 2023, at 9:07 PM, Jeremy Mordkoff <webm...@othsl.org> wrote:



To view this discussion on the web visit https://groups.google.com/d/msgid/othsl/CANkJ7k4pDWEWm2ZuimfWXdT46X3iB4dxGdS7TCPtfOkCo2j8%2Bg%40mail.gmail.com.

[Timothy Horton]

HI Jeremy,

the updated downloadable TeamSnap schedule is now working correctly.  Thanks for your prompt response and you saved me time from not having to manually enter in the whole season schedule.  Much appreciated.

Tim

Tim Horton

t...@thehortons.com

M: 508 769-8130

---

From: ot...@googlegroups.com <ot...@googlegroups.com> on behalf of Jeremy Mordkoff <webm...@othsl.org>
Sent: Wednesday, August 9, 2023 9:07 PM
To: ot...@googlegroups.com <ot...@googlegroups.com>
Subject: Re: Can you please update the OTHSL TeamSnap formatted schedule so it matches the current format for TeamSnap

 

To view this discussion on the web visit https://groups.google.com/d/msgid/othsl/CANkJ7k4pDWEWm2ZuimfWXdT46X3iB4dxGdS7TCPtfOkCo2j8%2Bg%40mail.gmail.com.