FAQ

How to Upload Schedules

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 box in the Match Criteria (or Assignment Criteria) to display other data elements. You MUST have the check mark in front of the Key box. It is best NOT to select the in front of the Action box.

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

   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 GotSoccer,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