Information
Logon

FAQ

Bulk Load New Matches

The EYSAReferees website will upload multiple matches at a time if you present it with a properly formatted csv (comma separated values) file. Microsoft Excel works well for this. (MacIntosh computers can have a non-compatible csv file format.)

Create a new file using Excel. Header Row

The spreadsheet is required to have a header row.
This row contains the names of the fields to be uploaded.
These names are predefined (see below) but are NOT case sensitive.
The order of the elements in the header row do not matter.

Matches

Matches are entered one per row under the Header Row.
The contents in each column must be valid (see below) or none of the games will upload.

Saving the Match File

To save the match file csv format, you will need to select the csv format. This can be done by choosing "Save As", then selecting "Other Formats" and then selecting "CSV (comma delimited) *.csv".

Uploading the Match File to the Website

Go to Scheduler: Database: Upload
Click the "Browse" button and find the Match File
Click "Upload File". This will transfer the file from your computer to the Website into a file named bulk.xxx.csv.

Bulk Loading the Matches into the Database

Don't skip the previous steps to upload the match file to the website
Go to Scheduler: Database: Bulk Load
Under "Destination" choose "Matches"
Click "Validate". The website will now make sure it understands all the data in the file.
If there is any invalid data, the website will tell you and not upload the matches.
If the data is all valid, it will ask you to finish the bulk load by clicking "Load".
The matches will NOT be loaded if the data is invalid, or you don't click the final "Load" button.

Match Headers and Values

Below is a list of possible headers to be entered in the Header Row. With each header is a list of possible values. The headers and the values must be exact for the matches to load. Fields that should be uploaded and their valid values:

Date - Use the EXCEL function =TEXT(date, "MM/DD/YYYY") to get the correct format
Time - Use the EXCEL function =TEXT(time, "HH:MM") to get the correct format
Field - Must match exact name of field (e.g. Beaver Lake Park 3B)
League - Must match exact name of league (e.g. Rec)
Club - Bellevue, Eastside FC, Issaquah, Lake Hills, Mercer Island, or Newport
Gender - G, B
Level - U08, U09, U10, U11, U12, U13, U14, U15, U16, U17, U18, U19, 3rd Grade, 4th Grade, 5th Grade, 6th Grade, 7th Grade
Division - 1, 2, 3, 4, A, B, C, Gold, Silver, Bronze
Season - Fall, Winter, Spring, Summer, Tournament
Home - Name of home team
Away - Name of away team

Fields that can be uploaded:

Authority - EYSA, NPSL, Parks & Rec, RCL, US Club, WSYSA, WSYSA District II, WSYSA District III
Home ID - ID number of home team
Away ID - ID number of away team

Fields that generally don't get uploaded since the system has logic to set them:

Status - Normal, Cancelled - Defaults to Normal
Rank - 0 to 25 - Set by website based on Level and League
Ref Status - Open, Accept, Turnback, Unconfirmed - Defaults to Open
Ref Method - Self-Assign, Manual, None - Defaults to Self-Assign
AR1 Status - Open, Accept, Turnback, Unconfirmed - Defaults to Open
AR1 Method - Self-Assign, Manual, None - Set by website based on Level and League
AR2 Status - Open, Accept, Turnback, Unconfirmed - Defaults to Open
AR2 Method - Self-Assign, Manual, None - Set by website based on Level and League
4th Status - Open, Accept, Turnback, Unconfirmed - Defaults to Open
4th Method - Self-Assign, Manual, None - Set by website based on Level and League