StoaTrax - How to Import Judges

We recommend that only 1 person be in charge of creating judge badges to avoid unnecessary confusion.

1. To access the judge file needed from your tournament, go to Admin-Entries-Export and click the Export Tab.
2. You will see an option called StoaTrax with a Download .csv link. Click on that link and the file will download onto your computer.
3. Open the file and clean up the information.
   1. Change all the headers in each column to match StoaTrax.
      1. Column A - Change Last Name to Last
      2. Column B - Change First Name to First
      3. Column C - Change Email Address to Email
      4. Column D - State can be left alone
      5. Column E - Change Cell Phone to Cell
      6. Column F - Insert a column to the right of Cell and label the column Phone
      7. Column G - Change Debate Club Long Name to Debate Club
      8. Column H - Delete current column of Debate Club short name, which would then make Column H Speech Club Long Name, which you'll need to rename Speech Club
      9. Column I - Delete current column of Speech Club short name, which would then make Column I Type, which you'll need to rename Kind
      10. Column J - Insert a column here and label it "Letter"
      11. Column K - Judge Number can be left alone
      12. Column L - Insert a new column here and label it Judge ID
      13. Column M - Registered at can be left alone
      14. Column N - Label this column Gender and enter n/a for all judges

      15. 

   2. Names - Make sure judges have proper capitalization. How it appears in the spreadsheet will be how it prints on the judge badges.
   3. Email Address - This will be whatever is the default for the judge's StoaHub profile.
   4. State - Make sure all states are 2 letters
   5. Cell Phone - This will be whatever is the default for the judge's StoaHub profile.
   6. Phone - Leave this blank as we don't have home phones in StoaHub
   7. Debate Club - All parent and alumni judges need to be associated with a club to show club conflicts in StoaTrax. If a parent hasn't indicated a club, you need to find out what club they are from and enter that club here. Community judges can be left blank if they didn't enter a club conflict.
   8. Speech Club - All parent and alumni judges need to be associated with a club to show club conflicts in StoaTrax. If a parent hasn't indicated a club, you need to find out what club they are from and enter that club here. Community judges can be left blank if they didn't enter a club conflict.
   9. Kind - Can either be a Parent, Alumni, or Community.
   10. Letter- For all the Parents enter letter P, all Alumni with the letter A, and all Community with the letter C. Important. If their judge number is 3 digits (999 or less) you'll need to add a zero after their letter.
   11. Judge Number - Any judge number that is 4 digits is fine. If a judge number has 3 digits (999 and below) they will get a zero added to the front when you combine the letter with a zero from step i in the next step.
   12. Judge ID - You will need to combine columns J (Letter) and K (Judge Number). To do this, enter this formula in the first cell under Judge ID (L2): =J2&K2 - This will combine the letter in column J and number in column K. Copy this equation and paste in down the entire L column so that all Judge IDs will be a combined letter and number. Once you've done this, select the entire column K, right click on the column and select copy. Select the entire column K again and click Paste Value.

   13. 

   14. This will give you a properly formatted judge number.
   15. Save the file. You do not need to delete any columns as StoaTrax will grab what it needs.
4. Navigate to your StoaTrax tournament website and login.
5. Click Judges on the left tab.
6. Click on the blue "IMPORT JUDGES" option.
7. Upload the file you just saved.
8. The judges should all appear with all the correct information. If you made a mistake, you can always go back to the spreadsheet and correct it. Then try again.
9. Congratulations. You have entered your judges.

To Print Judge Badges

1. Click on the "Judges" tab.
2. Click on the blue "PRINT JUDGES" button. This will download an Adobe file that will have 6 judge badges measuring 3 x 4 per page.