Importing athletes

The easiest way to do this is to import a file created by the RCA Web Registration System.

1. Find your system administrator for WRS and get them to log in (membership.rowingcanada.org)
2. Go to My Account
3. Under System Administrator - click on the administer link for the club
4. Go to Reports - Program Participants
5. Leave the report set to Administrator Report. Choose the program year, then the program whose participants you wish to export. Leave Select status as Active, and press Go.
6. There is a small Excel icon, which will allow you to export the content of the grid to Excel. Press this. A file called OrganizationCategoryMembers.xls should be downloaded to your computer. (If your computer insists on opening the file in Excel, either close it and look for the original downloaded file, or save the file as Comma Separated Values.)
7. If you like, you can email this file to me, and I will import it for you.
8. Or you can import it yourself. Open the My Club: link in the left menu of RDS.
9. Choose Athletes.
10. Choose Import RCA Excel.
11. Click on the Choose file button. Navigate to the OrganizationCategoryMembers.xls file that you downloaded from RCA's WRS and select it. Leave the Import into this club box checked.
12. Click on the Process File button.
13. The RDS compares the athletes listed in the RCA file against those in the RDS. It uses name, date of birth and RCA number to match athletes. Please scroll through the list of athletes to see whether it is making appropriate suggestions for athletes it may already have. Select the appropriate radio button if RDS has guessed wrong. If you have more than 50 athletes in your export, it may attempt to process in batches.
14. If there are changes that need to be made, press the Add and update into my club button.
15. You can check your list of athletes on the Edit athletes page. If there are athletes listed who are no longer at your club, you may remove them simply by selecting the checkbox in the Select column, then pressing the Remove selected athletes from club button.
16. If that seems like too much, return to step 7 above.

The import will add athletes who are not in the RDS, and update information for those already in the RDS. It will not, however, remove athletes who are already in your club. You can do this on the Edit athletes page.