Got Soccer Player Import Report Help

Importing Your Club Data to Got Soccer

Importing your club’s registration data into your state’s system is easy with Blue Sombrero! We have outlined some steps below that will walk you through the process of getting your data out of your Blue Sombrero club system and into your State’s Got Soccer system in just a few minutes. As always, your Dedicated Account Manager is here to help if you have any questions. To get started, you will be using a brand new report in your Report Wizard 2.0 that has been created specifically for this purpose – the “Got Soccer Player Import Report.”

Creating your Import File on Blue Sombrero:

1. Go to Admin>>Reports>>Report Wizard 2.0
2. Click on the edit pencil by the Got Soccer Player Import Report
3. Change the Report Name to: Got Soccer Player Import Report - 2010-2011 Travel Academy Tryouts (or whatever your program is called)
   
4. In the Field Conditions section, you will need to update the first condition to match the name of your program.  So you would edit it to say Programs Program Name is equal to <enter program name here> (in this example, our program is called: 2010-2011 Travel Academy Tryouts)
   
5. Scroll back up to the top of the report and click "Save As"
6. Scroll to the bottom of the page and click "Export to Excel"
7. Choose Save, then change the file name and extension to: Got-Soccer-Player-Import-2010-2011-Travel.xls and save it to your desktop.
8. Open the file from your desktop, and choose Save As a CSV (Comma-separated value) file.  This is an important step as you must have the file saved as a CSV file in order to import to Got Soccer.  Check out the how to save as a CSV file for more info.

Importing to Got Soccer:

1. Go to the Got Soccer site and login
2. Go to Club>>Players>>Upload Players
3. Put a check by the field, "First row contains column headings"
4. Click on "Choose File" and select your recently saved import CSV file from your desktop.
5. Click "Open Selected File"
   
   
6. For the Teams dropdown selection, choose "Create Teams (requires team name, gender, and age)" if you want teams to be created during import.
7. For each field that you are importing, you will need to map the appropriate column to the appropriate field name in the Got Soccer system.  For example, for the Middle Initial field, I have selected Middle Initial from the drop down menu.  A couple of notes:
   
   1. Player ID is not required for import as it will likely be generated by the state (however this may vary from state to state).  Player uniqueness will be determined by name, gender, and DOB in the Gotsoccer system.
   2. Team Age Group does not need to be imported as the field will be auto-populated based on the DOB of the players on the team.
      
      
8.  Click on "Import Data" and you will be taken to a confirmation screen
   
9.  That's it!