RDS import rca excel.php

1. 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.
2. Click on Process File.
3. 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.
4. If there are changes that need to be made, press the Add and update into my club button.

Importing from RCA's WRS

1. Find your club's 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 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.
7. If you like, you can email this file to me, and I will import it for you. The email address is at the bottom of the RDS web page.
8. Or you can import it yourself. Open the My Club: link in the left menu of RDS.
9. Choose Import RCA Excel.
10. Follow the instructions above.
11. 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.
12. If that seems like too much, return to step 7 above.