How to Upload SchedulesThere are two techniques involving the bulk manipulation of data to the Matches Table
- Bulk Update of existing schedule
For example adding the Field and Times to existing matches or changing characteristics of a subset of existing matches. - 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 UpdateYou will need to download, modify and then upload Matches
- Via the Administrator, Scheduler or LeagueOfficer segment visit Manage:Matches or via the Assignor segment visit Assignments
- Using the Match Criteria or the Assignment Criteria, select the subset of Matches that you wish to modify.
- 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. - 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. - Click on 'Show'
- 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. - Open the csv file in a desktop application. Microsoft Excel works well.
- 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. - 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 LoadYou will need to generate a csv file and then upload the Matches
- 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.) - 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. - Save the csv file.
Be sure to save your work as a csv file. - 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. - 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 HeadingsThe 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.
|