RedwoodSoccer
Clubs
Information
Logon

FAQ

Logon | Search | Help

Home | Directory | Clubs | Fields | Links

How to Upload SchedulesPrintable

There are two techniques involving the bulk manipulation of data to the Matches Table

  1. Bulk Update of existing schedule

    For example adding the Field and Times to existing matches or changing characteristics of a subset of existing matches.

  2. Bulk Load of new matches

    For example adding Tournament or other Playing League matches to the system to take advantage of referee scheduling or timeslot scheduling

Bulk Update

You will need to download, modify and then upload Matches

  1. Via the Administrator, Scheduler or LeagueOfficer segment visit Manage:Matches or via the Assignor segment visit Assignments
  2. Using the Match Criteria or the Assignment Criteria, select the subset of Matches that you wish to modify.
  3. Make sure that all the records you want are displayed.

    You should change the number of records displayed (default is 20 ) to a number that is larger than the number of records you expect.

  4. Make sure that all the data elements that you need are displayed.

    Use the checked box in the Match Criteria (or Assignment Criteria) to display other data elements. You MUST have the check mark checked in front of the Key box. It is best NOT to select the checked in front of the Action box.

  5. Click on 'Show'
  6. Click on the download symbol download

    This will generate a csv (comma separated value) file on your desktop. What it is named, where it appears, and where it might be stored is different depending on the browser you are using on your desktop.

  7. Open the csv file in a desktop application. Microsoft Excel works well.
  8. Make your desired modifications to the displayed Matches.

    It is okay to delete rows and/or columns that you do not need. Do not delete the header row. Do not delete the Key column. (The Key column might be shown as the Match column. Change the heading from 'Match' to 'Key'.) See below for permissible modifications. As a practical manner, you should be modifying at least 20 matches via the bulk update functionality. Less than 20 matches can be done one at a time via Manage-Matches in about the same time.

  9. Name and save your file in csv format.

    At this time send your file to the Administrator / Webmaster for uploading. Note some applications on a MacIntosh use a slightly different csv format. If given the option, save your file in PC or Microsoft csv format.

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 matches you must have Club as a minimum. As a practical matter, the more information you can bulk upload via a spreadsheet, the less keystrokes and mouse clicks you will have later in manipulating the Matches. 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. Upload the file.

    Upload data files at Administrator:Database-Upload or ClubOfficer:Dateabase-Upload. Bulk upload and bulk update bypass the normal data validation and error checking routines. Mistakes in the bulk loading or bulk updating of data can not be undone. There is no record of the data before the bulk operation. Mistakes are often irretrievable.

  5. Bulk Load the data.

    The uploaded data can now be added to a data table. Go to Administrator:Database-BulkLoad or ClubOfficer:Database:BulkLoad. Select the Matches table. Click "Validate". There may be errors in data column names, or data format (numbers versus character strings). Read the Green and Red messages. Fix any errors in your csv file and Upload again if needed. Otherwise click "Load".

Column Headings

The order of column headings is immaterial. Column headings are not case sensitive. However they MUST be spelled exactly. Note that these values can be used in Options-Methods, Options-Fees and Options-Ranks to establish the default referee assigning method, the default referee match fees and the default match difficulty ranking. Consequently, it is important to include many of these headings when uploading matches. Technically, none of these headings are mandatory. From a practical matter, you want to include as many of them as possible. Consider, Gender, AgeLevel, Club, TimeSlotsClub,UseStandings, Home, Date, PlayingLeague, Season, Class as required data.

  • Gender
    Current options are B,G,Mixed
  • AgeLevel
    U08,U09,U10,U11,U12,U13,U14,U15,U16,U17,U18,U19
  • Club
    Must be exactly the same as a club as specified in the Clubs table. See a pulldown in Manage-Matches Match Criteria for a correctly formatted value. The Club column in the Matches table is used to identify the Assignor(s) that have responsibility for the Match. (The "Client" in the pensra.org database.)
  • TimeSlotsClub
    Must be exactly the same as a club as specified in the Clubs table. See a pulldown in Manage-Matches Match Criteria for a correctly formatted value. The TimeSlotsClub column in the Matches table is used to identify the Scheduler(s) that have responsibility for the Match (when using the TiemSolte mechanism).
  • UseStandings
    0 = No and 1 = Yes. Should this Match be used to calculate standings? Currently no longer being used. In the past, typically set = 1 only in Redwood, Abronzino, Delgado and Alvarez PlayingLeagues. Set to 0 for tournaments, and other playing leagues.
  • Home
    The name of the Home team. The name is NOT linked to other parts of the database. So you can put anything you want here, including 'TBD' or 'Unknown Opponent'
  • Away
    The name of the Away team. The name is NOT linked to other parts of the database. So you can put anything you want here, including 'TBD' or 'Unknown Opponent'
  • HomeID
    The team ID number in the DD-LL-CC-TTTT format. It is via this number that Matches are linked with team records, coaches, managers, club records, etc. If the Match is to be modified or viewed by a Coach or a Manager, the ID number must be in place and correct.
  • AwayID
    The team ID number in the DD-LL-CC-TTTT format. It is via this number that Matches are linked with team records, coaches, managers, club records, etc. If the Match is to be modified or viewed by a Coach or a Manager, the ID number must be in place and correct. It is okay to have a HomeID and no AwayID or vice versa.
  • SourceKey & Source
    SourceKey is a Match number from another software system. Source can be GotSport If the other League uses a Match number, we can store that number here for future cross referencing or lookups. GotSoccer Match Numbers are stored in the format {GotSoccerEvent Number}.{Match Number}
  • 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->
  • Time
    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, spacing and capitalization have to be the same. Do not include '(Grass)' or '(SyntheticTurf)' in the Field name. 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 to see the appropriate Field names.
  • Bracket
    This must be identical to one of the options offered via the Match Criteria pulldown. Current options are Premier,Gold,Silver,Bronze,Copper
  • PlayingLeague
    This must be identical to one of the options offered via the Match Criteria pulldown. Current options are CalNorth Premier Leagues,CCSLBay,CCSL Coast,CCSL State Premier League,CYSA State Cup,District 2 Cup,Friendly,Juventus Tournament,NorCal NPL,NorCal Premier,NorCal State Cup,Ravenswood AL,SF PAL,Soccer by the Bay,Stanford WinterTournament,Tall Trees,Viking Rec,Viking Upper House
  • Flight
    This must be identical to one of the options offered via the Match Criteria pulldown. Current options are 1,2,3,4,A,B,C
  • Season
    This must be identical to one of the options offered via the Match Criteria pulldown. Current options are Fall,Spring,Summer,Tournament,Winter
  • Class
    This must be identical to one of the options offered via the Match Criteria pulldown. Current options are Competitive,Premier
  • RefMethod
    This must be identical to one of the options offered via the Match Criteria pulldown. Typical values are Pensra, and None.. Pensra means that the Method will be set for the referees via Options-Methods of the Pensra.org website. If not specified, a value will be looked up from the Options-Methods Table. Note "Pensra" and not "PENSRA". This is case sensitive.
  • AR1Method
    This must be identical to one of the options offered via the Match Criteria pulldown. Typical values are Pensra, and None.. Pensra means that the Method will be set for the referees via Options-Methods of the Pensra.org website. If not specified, a value will be looked up from the Options-Methods Table. Note "Pensra" and not "PENSRA". This is case sensitive.
  • AR2Method
    This must be identical to one of the options offered via the Match Criteria pulldown. Typical values are Pensra, and None.. Pensra means that the Method will be set for the referees via Options-Methods of the Pensra.org website. If not specified, a value will be looked up from the Options-Methods Table. Note "Pensra" and not "PENSRA". This is case sensitive.
  • MatchReport
    Set to "1" if Referees will be required to submit a MatchReport. Set to "0" if no Referee MatchReport is desired.

Last Updated 8/11/2013
Updated 3/5/2019