How to Upload SchedulesPrintable

Bulk Loading and Bulk Updateing have not been tested. Anticipate some glitches till testing is complete.

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 Playing League matches to the system to take advantage of match field scheduling.

Bulk Update

You will need to download, modify and then upload Matches

  1. Via the Administrator or Staff segment visit Manage:Matches
  2. Using the Match 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 10 ) 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 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. Send the file for uploading.

    At this time only the webmaster and site Administrator can upload data files. 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.

Column Headings

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.