PYSA bills rec clubs based on team count, player count, and coach count. Each season, the recreational players must be imported into OYSA affinity and assigned to Affinity teams in order for this to occur.
The import process is technical and relies on Python, docker, and Playmetrics admin capabilities.
clone playmetrics automation from admin@swizzler.org:src/lys/playmetrics.git
docker-compose up to export all current information
- in playmetrics, export all rosters
teams -> more actions -> export rosters
- download and copy team_rosters.csv to playmetrics git repo out/ directory
- in playmetrics, export all teams
teams -> more actions -> export teams
- download and copy all_teams.csv to playmetrics git repo out/ directory
- In affinity, search for all teams in the season
teams -> team lookup -> search (for all)
- copy the table of teams and update all team names/ids in the 'oysa_team_ids' dictionary on oysa_player_import.py:25
- modify the name of the playmetrics program export file in oysa_player_import:325 to match the exported file.
- fix up any coach-created teams to match what is recorded in Affinity (oysa_player_import.py:87)
- run oysa_player_import.py
For spring, PYSA appreciates a spreadsheet that lists only new players since fall. To do this:
- Put all spring player data a google sheet with a tab named "spring"
- You will need to use the Playmetrics data for this, because it contains the division data. PYSA charges different fees based on division.
- make a second tab named "fall" in the sheet that has all fall player data
- in each tab, insert a column A before the rest of the data with the formula "=CONCAT(B1,C1)"
extend the data to the end a the sheet to make a "FirstNameLastName" column where duplicate players can be found
- create a third tab, with the following formula in A1
- =filter(spring!A:Y,iserror(match(spring!A:A, fall!A:A,0)))
- copy the list into a spreadsheet to be shared by PYSA. Spot-check the data.
EXAMPLE documents should help, in the 2025/2026 submitted to pysa registration folder: https://docs.google.com/spreadsheets/d/1HIyxUSj4fzp6M2w4B9B_iib4W6sDwLS4YIWB0nrv_ik