RedwoodSoccer
Clubs
Information
*About Us
*Contacts
*FAQ
*Fields
*Matches
*Minutes
*Past Standings
*Registration
*Search
*SiteMap
*Terminology
Logon

FAQ

Logon | Search | Help

Home | Directory | Clubs | Fields | Links

How to Upload TimeSlotsPrintable

There are two techniques to add data records to the TimeSlots Table

  1. One TimeSlot at a Time using Mange:TimeSlots

    For example adding a new TimeSlot.

  2. Bulk Load of new TimeSlots

    For example adding TimeSlots to the system when obtaining TimeSlots from a Municipal Parks & Recreation Department or School District.

Via Manage:TimeSlots

  1. Via the Administrator, Scheduler or LeagueOfficer segment visit Manage:TimeSlots
  2. Using the TimeSlots Criteria select a TimeSlot that has similar characteristics to the TimeSlot you wish to add.
  3. Edit the details of the TimeSlot (Time, Field, Rate, etc.)
  4. Click on 'Copy'.

    You should get a Green message indicating that a new TimeSlot record has been recorded.

Bulk Load

You will need to generate a csv file and then upload the Matches

  1. Generate a csv (comma separated values) file

    CSV files can be generated from spreadsheet programs such as Microsoft Excel. When you save the file you will have to select the csv file format. (MacIntosh computers can have a non-compatible csv file format.)

  2. The csv file must have a header row

    For new TimeSlots you should have Club, Date, Field, StartTime, EndTime, Type, Uxx, Method and Status as a minimum. Uxx refers to AgeLevel - please include U06 through U19. Optional is to include Rate. See below for a complete description of the possible column headings and format criteria.

  3. Save the csv file.

    Be sure to save your work as a csv file.

  4. Send the file to the webmaster for uploading OR upload the file yourself

    • At ClubOfficer:Database-Upload upload the file to the database.
    • At ClubOfficer:Database-BulkLoad "Validate" the file. - ERRORS? fix the csv file and Upload again
    • Then click "Load" to add the data records

Column Headings

Column headings are not case sensitive. However they MUST be spelled exactly. Technically, none of these headings are mandatory. From a practical matter, you want to include as many of these as possible. All but Rate should be considered required data.

  • U06
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U07
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U08
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U09
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U10
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U11
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U12
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U13
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U14
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U15
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U16
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U17
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U18
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • U19
    Enter 1 or 0. 1 for 'Yes' allow this AgeLevel to use this TimeSlot.
  • Club
    Must be exactly the same as a club as specified in the Clubs table. See a pulldown in Manage-Matches Match Criteria or Asignor-Assignment Assignment Criteria for a correctly formatted value. The Club column in the Matches table is used to identify the Assignor(s) and Scheduler(s) that have responsibility for the Match.
  • Date
    The preferred format is MM/DD/YYYY. CRITICAL, if one record has a date, all the records must have a date. Other date formats and a complete discussion of acceptable date formats can be found at Reference: Tools-Dates and Times->
  • StartTime
    The preferred format is HH:MM AM or HH:MM PM or HH:MM in a 24 hour clock. CRITICAL, if one record has a time, all the records must have a time. Other time formats and a complete discussion of acceptable date formats can be found at Reference: Tools-Dates and Times->
  • EndTime
    The preferred format is HH:MM AM or HH:MM PM or HH:MM in a 24 hour clock. CRITICAL, if one record has a time, all the records must have a time. Other time formats and a complete discussion of acceptable date formats can be found at Reference: Tools-Dates and Times->
  • Field
    The name of the field MUST be identical as listed in the database. Punctuation, spelling and capitalization have to be the same. You can put in '0' (zero) for an unknown field. It will appear in the database as 'unspecified'. Note - be sure you are checking the Field Name and not the Location Name. Use the pulldown in Match Criteria or Assignemnt Criteria
  • Type
    This must be identical to one of the options offered via the TimeSlots Criteria pulldown. Current options are Match,Other,Practice
  • Method
    This must be identical to one of the options offered via the TimeSlots Criteria pulldown. Current options are None,SelfSchedule,ManualSchedule
  • Rate
    A numerical value of the dollar amount charged for use of this TimeSlot. Do not use the dollar sign ($). Note this is called 'Rate' not 'Fee'.
  • Status
    This must be identical to one of the options offered via the TimeSlots Criteria pulldown. Current options are Available,Held by AYSO,Reserved,Returned to City
  • Priority
    An Integer value, typically between 0 and 5. The higher the value, the higher the priority. The most coveted TimeSlots have the highest value.

Updated 5/12/14
Updated 2/29/16
Updated 3/5/2019