Import restrictions (Director)

Restrictions or scheduling requests can be imported with the teams import template.  The following restriction columns are available for import and will automatically create the restriction in the system for you.  Each column has a certain format and must be followed to work correctly.  We will notify if an error is made with a restriction format and notify the row that has the issue.

Date/Time Restrictions (DateTimeRestrictions)


This column is for teams that have a date/time scheduling request, maybe a team can only play in the morning or on a certain day.  The restriction can exclude or include (except for a specific date).  The following rules are listed below:

Schedule


If a team can play during a certain date/time then start the restriction off with one of the following operators below.
  • after (after {time}, after {time} on {date}, after {time} {date})
  • before (before {time}, before {time} on {date}, before {time} {date})
  • between (between {starttime} ("&" or "and" or "-") {endtime} on {date})

Don't Schedule


If a team can't play during a certain date/time then start the restriction off with one of the following operators below.  
  • not after (not after {time}, not after {time} on {date}, not after {time} {date})  
  • not before (not before {time}, not before {time} on {date}, not before {time} {date})  
  • not between (not between {starttime} ("&" or "and" or "-") {endtime} on {date})  
  • not on (not on {date})

Rules

  • Multiple Date/Time Restrictions in a row are separated by a comma (see row 7).
  • AM or PM is required for times.
  • The Between operator can use the following to separate the start and end time: and, &, - (see row 3,8,9)
  • Not On operator can only be used with a Date (see row 5,6)
  • If the Year is not provided with a Date then the Current Year is used (see row 6).
  • If the day of the week (sat,sun,mon,tue,wed,thu,fri) is used for the Date, then the following day of the week from the current import date is used (Importing on Thursday will use that weekend's Saturday for the word sat, see row 2,4,5,7)

Edge Case


if you want a team to play between two times and use the between operator, it stores that retriction inverted, excluding before the start time and after the end time.  This works fine unless you have another restriction in conjuction with this that might be an after or before operator. These will be ignored since the between operator excluded everything before and after it.  In the future we will store these as an inclusion, but right now we save our date/time restrictions with when a team CAN'T play.  
Row  DivisionTeam NameDateTimeRestrictionsDescription
116U BoysGym Ratz Whiteafter 4 pmCan play after 4:00 PM on all days
216U BoysIndiana Elitebefore 11:00 am satCan play before 11:00 am on the next Saturday
316U BoysIndiana Elite Redbetween 2 pm & 5 pm 11/23/2017Can play between 2:00 PM and 5:00 PM on November 23, 2017 (Uses ampersand "&")
416U BoysLouisville Magicnot after 5:00 PM on sunCan't play after 5:00 PM on the next Sunday
517U BoysGym Ratz Rednot on satCan't play on the next Saturday
617U BoysIndiana Elitenot on 11/23Can't play on November 23 on current year of import
717U BoysLouisville Magicbefore 11am sat, after 4pm satCan play before 11:00 AM on next Saturday, Can play after 4:00 PM on next Saturday
817U BoysIndiana Elite Rednot between 11:00 AM and 3:00 PMCan't play between 11:00 AM and 3:00 PM on all days (Uses the word "and")
917U BoysEG All-Starsnot between 11:00 AM-3:00 PM on 11/23/2017 Can't play between 11:00 AM and 3:00 PM on November 23, 2017 (Uses a dash "-")

Team Restrictions (TeamRestrictions)

This column is for teams that don't want to play at the same time, maybe they have the same coach.  The full division name is required along with the optional team name if the names are exactly the same in both divisions.  It's not necessary to put this restriction in for both teams as it will create a bi-directional restriction but is recommended for human readability.  The following rules are listed below.
  • Format: DivisionName|TeamName or DivisionName (only if team names are the same)
  • Multiple Team Restrictions in a row are separated by a comma (see row 2,3,6). 
  • If the Team Name is the same in the reference, the Division Name is only needed (see row 4)
  • If the Team Name is different in the reference, the Division Name and Team Name are required, separated by a pipe character (|) (see row 1,5)
  • Restrictions are not needed on both teams but is recommended.
RowDivisionTeam NameTeamRestrictionsDescription
116U BoysGym Ratz White17U Boys|Gym Ratz RedThe teams in both divisions have a different name, so it is required to list the name after the division.
216U BoysIndiana Elite17U Boys,16U Boys|Indiana Elite RedThe team name in row 6 is the same so only the Division Name is required but the team name in row 3 is different so the team name is required after the division name.  Both are separated by columns.
316U BoysIndiana Elite Red17U Boys,16U Boys|Indiana EliteThe team name in row 6 is the same so only the Division Name is required but the team name in row 2 is different so the team name is required after the division name.  Both are separated by columns.  
416U BoysLouisville Magic17U BoysThe team names are the same in both divisions, therefore only a division name is required.
517U BoysGym Ratz Red16U Boys|Gym Ratz WhiteThe teams in both divisions have a different name, so it is required to list the name after the division.  
617U BoysIndiana Elite16U Boys,16U Boys|Indiana Elite RedThe team name in row 2 is the same so only the Division Name is required but the team name in row 2 is different so the team name is required after the division name.  Both are separated by columns.    
717U BoysLouisville Magic
It's not necessary to put anything here because row 4 already creates the team restriction between both teams although it's recommended you do.

Exhibition Restriction (ExhibitionRestriction)

This column is for teams that will have all their games marked as an exhibition, meaning their games won't count against pool standings.  This option is good for teams who may only play one day in a shootout and must be last in the pool.  This column only requires a boolean value which can be Yes, Y, True, or 1, otherwise leave blank.
RowDivisionTeam NameExhibitionRestriction
116U BoysGym Ratz WhiteYes
216U BoysIndiana Elite1
316U BoysIndiana Elite RedY
416U BoysIndiana Elite WhiteTrue

Feedback and Knowledge Base