Sporty provides you with the ability to easily view database entries/registration information and further allows you to export this data into an Excel (CSV) file.
This article includes:
Each online form that you take registrations/entries on is its own database full of information that is submitted by each applicant.
Note: this information recorded can only be used for its intended purpose.
How to view entries/registrations
Login to your Sporty site, then from the Dashboard, click the Online Registrations tile.
Click on the name of a form/database to view all records submitted for that form.
The database will appear as shown here.
To edit a person's record and or, view their details, you can either click on their name or the view/lens icon in the options bar to the right of their registration.
It will then take you to the person's registration where you can make changes. To save, click on Submit.
You can also click View to view all registrants details and form fields in one view.
A new page will open showing all the registrants' details and form information as below:
The database display
Duplicate entries/registrations
Within a database, Sporty records one entry per team that they are entered in. If a registrant is entered into multiple teams then they will show multiple entries. For example, a registrant may be entered as a player in one team, as a coach in a second team and as a team manager in another team. This would then be reflected by the database showing three entries.
The example below shows Aurelia Daly having three entries. The top one is the original, with the two idented below being the copies of the original as the registrant has been entered into more than one team.
Please note that each duplicated registration has the status 'Pending' set by the system. This is because the registration is a duplicate and not the original.
When you hover your mouse curser over the registration record a pop up appears explaining this.
Family Registrations
If family registrations are enabled on your form, when family members register they will be grouped together. The primary registrant will head the idented group.
When you hover your mouse curser over the registration record a pop up appears explaining this.
How to export your database
You can export your database as a downloadable file that you can open in Microsoft Excel and other spreadsheet programs (E.g. Mac Numbers, Google Sheets).
To download a database, click the green Export button from the top right of your database view.
The database will automatically download to your computer as a CSV file. 'CSV' stands for Comma Separated Variable. It is simply a text file where each field from your database neatly appears in columns separated by commas. The CSV file will open in Microsoft Excel or another program on your computer, depending upon whatever default application your computer has set for opening this file type.
If your database is quite large, a window will pop up to let you know that the it will be sent to you by email instead of downloading immediately to your computer. In this window, you can also set the date range of the registrations that you want to export.
IMPORTANT: If your database is emailed to you, it may take many minutes for it to reach you, so please be patient and do NOT repeat the email process while you're waiting.
The Sporty platform also support the export of Images and Documents that were uploaded when people completed your online registration form.
This downloads a Zip file containing all documents that automatically opens on your computer. The filename for each document in the Zip file is automatically set to be the name entered on the registration form in combination with the unique registration number, so it is easy to marry each document in the Zip file with the associated registration record, like this:
To enable the export of documents and/or photos, please contact support@sportsground.com.