If you need to upload roster data into a third-party platform like GotSport or Affinity, you can generate an upload-ready CSV file from Sprocket using the Assign Player Status report.
The key is to start from the Assign Player Status report, clear the standard fields, then add the correct “extract” fields for the platform you are uploading to.
What you’ll find in this article
Where to configure the Assign Player Status report
How to switch the report to GotSport Extract or Affinity Extract fields
How to run and export a CSV that is ready to upload
Step 1: Open the Assign Player Status report in Configure mode
Go to Reports > Reports Center.
Under the Players heading, find Assign Player Status.
Hover over the report row, then click Configure.
This opens the report builder where you can control both filters and output fields.
Step 2: Remove the standard fields
When you first open Configure, the report typically has standard fields already added in the Added column on the right.
In the Added column, remove all currently-added fields so the report output starts blank.
Tip: This step matters because third-party uploads usually require a very specific column layout. Keeping extra fields can cause the import to fail or require extra cleanup.
Step 3: Add the correct extract fields
In the Available Fields list on the left, locate the extract section you need:
GotSport Extract, or
Affinity Extract
Select the checkbox next to the appropriate extract section.
Confirm those fields now appear in the Added column on the right.
Only select the extract that matches the platform you are uploading to.
Step 4: Confirm filters and run the report
Before exporting, confirm your filters at the top match the roster set you want to upload, such as:
Program Type
Program
Registration
Team
Grade, graduation year, age group (if needed)
Not Assigned Players, expired invitations, test players (if applicable)
Once filters look correct:
Click Run Report.
Review the results to confirm the output looks right for your upload.
Step 5: Export a CSV for upload
If the results look correct:
Click Export Results at the top of the report.
Download the CSV file.
Upload the CSV into GotSport or Affinity using that platform’s import tool.
Helpful tip: save your configuration
If you run the same export regularly, click Save a Copy to save your configured version of the report. This way you do not have to remove and re-add fields each time.
If you run into any issues
The third-party upload fails: Confirm you cleared all non-extract fields and only selected GotSport Extract or Affinity Extract fields.
Too many players included: Narrow filters to a specific Program, Registration, or Team before exporting.
Missing players: Check whether Not Assigned Players are excluded, and confirm filters are not limiting the results unintentionally.
FAQs
Why do I need to remove the standard fields first?
Third-party uploads require a specific column layout. Extra fields can cause the import to fail.
How do I know which extract to choose?
Select only the extract that matches the platform you are uploading to, either GotSport Extract or Affinity Extract.
Can I reuse this setup later?
Yes. Use Save a Copy to store your configured version of the report.
What should I check if the upload fails?
Confirm that only the correct extract fields are selected and that your filters include the correct roster set.