Welcome to assignr.com!
Our goal is to make the referee assigning process as simple as possible for both assignors and officials.
If you have an idea on how we can make assignr.com better, we encourage you to share your idea with other customers, or suggest a new feature in our forums.
assignr.com Help Center
Importing from a Spreadsheet
If your games / people are in an Excel spreadsheet, you will need to use the File : Save As command in Excel to save your existing spreadsheet in a Comma Separated Value format.
Each game or person must be on a single row of your spreadsheet.
The assignr.com import process assumes that your spreadsheet’s first row is column headings. These column headings will be visible
- Click the Games or People tab
- Click the Import CSV Text File link
- Click the Browse button and select your CSV import file
-
Click
After you click Submit, assignr.com will show you the first five rows of your spreadsheet.
In the drop-down boxes, you’ll need to match up the assignr.com field names with the columns of your spreadsheet.
If you are importing games, you’ll also be asked to choose an officiating pattern A pattern defines the number and type(s) of officials that are to be assigned to each game.
Once the columns of your spreadsheet are matched up with the assignr.com field names, click Submit.
Importable Fields for Games
- Games
- Date (required)
- Start Time (required)
- Venue (required)
- Age Group (required)
- Home Team (required)
- Away Team (required)
- League
- Gender
- Game Type
- Game ID#
- Public Comment
- Private Comment
Importable Fields for People
- First Name (required unless full name provided)
- Last Name (required unless full name provided)
- Middle Name
- Full Name (required unless first & last name provided)
- Address Line 1
- Address Line 2
- City
- State/Province
- ZIP/Postal Code
- Home Phone
- Work Phone
- Cell Phone
- Referee ID #1
- Referee ID #2
- Email Address #1
- Email Address #2
- Referee Grade
Each referee must have either First and Last Name in two separate fields, or a Full Name as a single field. Full name can be either "FirstName LastName" or "LastName, FirstName" format.
Referee accounts will be created when you import your referee data. However, user names and passwords are NOT distributed until you tell assignr.com to send credentials to your officials.